diff options
Diffstat (limited to 'src/base/stats_database.cpp')
| -rw-r--r-- | src/base/stats_database.cpp | 196 |
1 files changed, 196 insertions, 0 deletions
diff --git a/src/base/stats_database.cpp b/src/base/stats_database.cpp new file mode 100644 index 00000000..deb896ef --- /dev/null +++ b/src/base/stats_database.cpp @@ -0,0 +1,196 @@ +/* + * UltraStar Deluxe - Karaoke Game + * + * UltraStar Deluxe is the legal property of its developers, whose names + * are too numerous to list here. Please refer to the COPYRIGHT + * file distributed with this source distribution. + * + * This program is free software; you can redistribute it and/or + * modify it under the terms of the GNU General Public License + * as published by the Free Software Foundation; either version 2 + * of the License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program; see the file COPYING. If not, write to + * the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, + * Boston, MA 02110-1301, USA. + * + * $URL$ + * $Id$ + */ + +#include "stats_database.hpp" + +namespace usdx +{ + const int db_version = 1; + const std::string StatDatabase::usdx_scores = + "us_scores"; + + const std::string StatDatabase::usdx_songs = + "us_songs"; + + const std::string StatDatabase::usdx_statistics_info = + "us_statistics_info"; + + log4cxx::LoggerPtr StatDatabase::log = + log4cxx::Logger::getLogger("usdx.base.StatDatabase"); + + StatDatabase::StatDatabase(const std::string filename) : + Database(filename) + { + LOG4CXX_DEBUG(log, "Initializing Database: " << filename); + + if (! sqlite_table_exists(usdx_statistics_info)) { + // add table usdx_statistics_info, needed in the + // conversion from 1.01 to 1.1 + LOG4CXX_INFO(log, "Outdated song database found " << + "- missing table'" << + usdx_statistics_info << "'"); + + sqlite_exec("CREATE TABLE IF NOT EXISTS [" + + usdx_statistics_info + + "] ([ResetTime] Integer);"); + + // insert creation timestamp + sqlite3_stmt *sqliteStatement = + sqlite_prepare("INSERT INTO [" + + usdx_statistics_info + + "] ([ResetTime]) VALUES (?1);"); + + sqlite3_bind_int(sqliteStatement, 1, time(NULL)); + sqlite3_step(sqliteStatement); + sqlite3_finalize(sqliteStatement); + } + + int version = get_version(); + + bool finalizeConversion = false; + if (version == 0 && sqlite_table_exists("US_Scores")) { + // convert data from 1.01 to 1.1 + // part #1 - prearrangement: rename old tables + // to be able to insert new table structures + sqlite_exec("ALTER TABLE US_Scores RENAME TO us_scores_101;"); + sqlite_exec("ALTER TABLE US_Songs RENAME TO us_songs_101;"); + } + + if (version == 0) { + // Set version number after creation + set_version(db_version); + } + + // SQLite does not handle VARCHAR(n) or INT(n) as expected. + // Texts do not have a restricted length, no matter which type + // is used, so use the native TEXT type. INT(n) is always + // INTEGER. In addition, SQLiteTable3 will fail if other types + // than the native SQLite types are used (especially + // FieldAsInteger). Also take care to write the types in + // upper-case letters although SQLite does not care about this - + // SQLiteTable3 is very sensitive in this regard. + std::string sqlStatement; + + sqlStatement = "CREATE TABLE IF NOT EXISTS ["; + sqlStatement += usdx_scores; + sqlStatement += "] ("; + sqlStatement += "[SongID] INTEGER NOT NULL, "; + sqlStatement += "[Difficulty] INTEGER NOT NULL, "; + sqlStatement += "[Player] TEXT NOT NULL, "; + sqlStatement += "[Score] INTEGER NOT NULL, "; + sqlStatement += "[Date] INTEGER NULL"; + sqlStatement += ");"; + + sqlite_exec(sqlStatement); + + sqlStatement = "CREATE TABLE IF NOT EXISTS ["; + sqlStatement += usdx_songs; + sqlStatement += "] ("; + sqlStatement += "[ID] INTEGER PRIMARY KEY, "; + sqlStatement += "[Artist] TEXT NOT NULL, "; + sqlStatement += "[Title] TEXT NOT NULL, "; + sqlStatement += "[TimesPlayed] INTEGER NOT NULL, "; + sqlStatement += "[Rating] INTEGER NULL"; + sqlStatement += ");"; + + sqlite_exec(sqlStatement); + + if (finalizeConversion) { + // convert data from 1.01 to 1.1 + // part #2 - accomplishment + LOG4CXX_INFO(log, "Outdated song database found - " << + "begin conversion from V1.01 to V1.1"); + + // insert old values into new db-schemes (/tables) + sqlStatement = "INSERT INTO ["; + sqlStatement += usdx_scores; + sqlStatement += "] SELECT [SongID], "; + sqlStatement += "[Difficulty], [Player], "; + sqlStatement += "[Score] FROM [us_scores_101];"; + sqlite_exec(sqlStatement); + + sqlStatement = "INSERT INTO ["; + sqlStatement += usdx_songs; + sqlStatement += "] SELECT [ID], [Artist], "; + sqlStatement += "[Title], [TimesPlayed], NULL "; + sqlStatement += "FROM [us_songs_101];"; + sqlite_exec(sqlStatement); + + // now drop old tables + sqlite_exec("DROP TABLE us_scores_101;"); + sqlite_exec("DROP TABLE us_songs_101;"); + } + + // add column rating to cUS_Songs + // just for users of nightly builds and developers! + if (! sqlite_table_contains_column(usdx_songs, "Rating")) { + LOG4CXX_INFO(log, "Outdated song database found - " << + "adding column rating to '" << + usdx_songs << "'"); + + sqlite_exec("ALTER TABLE [" + usdx_songs + + "] ADD COLUMN [Rating] INTEGER NULL;"); + } + + //add column date to cUS-Scores + if (! sqlite_table_contains_column(usdx_scores, "Date")) { + LOG4CXX_INFO(log, "Outdated score database found - " << + "adding column date to '" << + usdx_scores << "'"); + + sqlite_exec("ALTER TABLE [" + usdx_scores + + "] ADD COLUMN [Date] INTEGER NULL;"); + } + } + + StatDatabase::~StatDatabase(void) + { + this->Database::~Database(); + } + + char* StatDatabase::format_date(char* time, + size_t max, + time_t timestamp) + { + if (timestamp != 0) { + struct tm tmp; + + if (localtime_r(×tamp, &tmp)) { + strftime(time, max, "%d.%m.%y" + /* TODO: Language.Translate("STAT_FORMAT_DATE")*/, + &tmp); + return time; + } + } + + if (max > 0) { + time[0] = '\0'; + return time; + } + + return NULL; + } +}; |