aboutsummaryrefslogtreecommitdiffstats
path: root/src/base/UDataBase.pas
diff options
context:
space:
mode:
authorb_krueger <b_krueger@b956fd51-792f-4845-bead-9b4dfca2ff2c>2009-07-18 13:36:34 +0000
committerb_krueger <b_krueger@b956fd51-792f-4845-bead-9b4dfca2ff2c>2009-07-18 13:36:34 +0000
commit1ce18fc38205cc21752579b3cb5dd4c083730ba2 (patch)
tree42b4089ab3d67aadb17cf8d5b4fa6ab86a4b5957 /src/base/UDataBase.pas
parentf755ee5aa3b6949d633cd3e157f3611be10595ff (diff)
downloadusdx-1ce18fc38205cc21752579b3cb5dd4c083730ba2.tar.gz
usdx-1ce18fc38205cc21752579b3cb5dd4c083730ba2.tar.xz
usdx-1ce18fc38205cc21752579b3cb5dd4c083730ba2.zip
some modifications on the DataBaseLoading
- now ALL databases in table "us_songs" gets the column "Rating" - nicer Structure and some useful comments -> should work now with all DB-loading-combinations! git-svn-id: svn://svn.code.sf.net/p/ultrastardx/svn/trunk@1851 b956fd51-792f-4845-bead-9b4dfca2ff2c
Diffstat (limited to '')
-rw-r--r--src/base/UDataBase.pas37
1 files changed, 28 insertions, 9 deletions
diff --git a/src/base/UDataBase.pas b/src/base/UDataBase.pas
index ae9f2532..227db653 100644
--- a/src/base/UDataBase.pas
+++ b/src/base/UDataBase.pas
@@ -119,6 +119,11 @@ uses
SysUtils,
ULog;
+{
+ cDBVersion - history
+ 0 = USDX 1.01 or no Database
+ 01 = USDX 1.1
+}
const
cDBVersion = 01; // 0.1
cUS_Scores = 'us_scores';
@@ -146,16 +151,11 @@ begin
Version := GetVersion();
- finalizeConvertion := false;
+ //Adds Table cUS_Statistics_Info
+ //Happens from Convertion 1.01 -> 1.1
if not ScoreDB.TableExists(cUS_Statistics_Info) then
begin
- Log.LogInfo('Outdated song-database file found', 'TDataBaseSystem.Init');
- Version := 0;
- //following just works with convertion of usdx1.01 to usdx1.1!
- //Rename old Tables - to be able to insert new table-structures
- ScoreDB.ExecSQL('ALTER TABLE US_Scores RENAME TO us_scores_101;');
- ScoreDB.ExecSQL('ALTER TABLE US_Songs RENAME TO us_songs_101;');
-
+ Log.LogInfo('Outdated song-database file found - Missing Table"'+cUS_Statistics_Info+'"', 'TDataBaseSystem.Init');
ScoreDB.ExecSQL('CREATE TABLE IF NOT EXISTS ['+cUS_Statistics_Info+'] (' +
'[ResetTime] INTEGER' +
');');
@@ -163,6 +163,16 @@ begin
ScoreDB.ExecSQL(Format('INSERT INTO ['+cUS_Statistics_Info+'] ' +
'([ResetTime]) VALUES(%d);',
[DateTimeToUnix(Now())]));
+ end;
+
+ //Converts data of 1.01 -> 1.1
+ //Part #1 - prearrangement
+ finalizeConvertion := false;
+ if (Version = 0) AND ScoreDB.TableExists('US_Scores') then
+ begin
+ //Rename old Tables - to be able to insert new table-structures
+ ScoreDB.ExecSQL('ALTER TABLE US_Scores RENAME TO us_scores_101;');
+ ScoreDB.ExecSQL('ALTER TABLE US_Songs RENAME TO us_songs_101;');
finalizeConvertion := true; //means: convertion has to be done!
end;
@@ -177,7 +187,6 @@ begin
// 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.
-
ScoreDB.ExecSQL('CREATE TABLE IF NOT EXISTS ['+cUS_Scores+'] (' +
'[SongID] INTEGER NOT NULL, ' +
'[Difficulty] INTEGER NOT NULL, ' +
@@ -193,8 +202,11 @@ begin
'[Rating] INTEGER NULL' +
');');
+ //Converts data of 1.01 -> 1.1
+ //Part #2 - accomplishment
if finalizeConvertion then
begin
+ Log.LogInfo('Outdated song-database file found - Began Converting from V1.01 to V1.1', 'TDataBaseSystem.Init');
//insert old values in new db-schemes (/tables)
ScoreDB.ExecSQL('INSERT INTO '+cUS_Scores+' SELECT SongID, Difficulty, Player, Score FROM us_scores_101;');
ScoreDB.ExecSQL('INSERT INTO '+cUS_Songs+' SELECT ID, Artist, Title, TimesPlayed, ''NULL'' FROM us_songs_101;');
@@ -203,6 +215,13 @@ begin
ScoreDB.ExecSQL('DROP TABLE us_songs_101;');
end;
+ //Adds Column Rating to cUS_Songs
+ //Just for the users of Nightly-Builds and all Developers!
+ if not ScoreDB.ContainsColumn(cUS_Songs, 'Rating') then
+ begin
+ Log.LogInfo('Outdated song-database file found - Adding Column Rating to "'+cUS_Songs+'"', 'TDataBaseSystem.Init');
+ ScoreDB.ExecSQL('ALTER TABLE '+cUS_Songs+' ADD COLUMN Rating INTEGER NULL');
+ end;
except
on E: Exception do