/* OLD STUFF */ /* * don't do more like this, use Sqlite.convertTables() */ //change DB from 0.55 to 0.56 protected internal static void convertTableAddingSportStuff() { ArrayList myArray = new ArrayList(2); //1st create a temp table //createTable(Constants.ConvertTempTable); SqliteSessionOld sqliteSessionObject = new SqliteSessionOld(); sqliteSessionObject.createTable(Constants.ConvertTempTable); //2nd copy all data from session table to temp table dbcmd.CommandText = "SELECT * " + "FROM " + Constants.SessionTable + " ORDER BY uniqueID"; SqliteDataReader reader; reader = dbcmd.ExecuteReader(); while (reader.Read()) { Session mySession = new Session(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), UtilDate.FromSql(reader[3].ToString()), 1, //sport undefined -1, //speciallity undefined -1, //practice level undefined reader[4].ToString(), //comments Constants.ServerUndefinedID ); myArray.Add(mySession); } reader.Close(); foreach (Session mySession in myArray) { InsertOld(true, Constants.ConvertTempTable, mySession.Name, mySession.Place, UtilDate.ToSql(mySession.Date), mySession.PersonsSportID, mySession.PersonsSpeciallityID, mySession.PersonsPractice, mySession.Comments); } //3rd drop table sessions Sqlite.dropTable(Constants.SessionTable); //4d create table persons (now with sport related stuff //createTable(Constants.SessionTable); sqliteSessionObject.createTable(Constants.SessionTable); //5th insert data in sessions (with sport related stuff) foreach (Session mySession in myArray) { InsertOld(true, Constants.SessionTable, mySession.Name, mySession.Place, UtilDate.ToSql(mySession.Date), mySession.PersonsSportID, mySession.PersonsSpeciallityID, mySession.PersonsPractice, mySession.Comments); } //6th drop temp table Sqlite.dropTable(Constants.ConvertTempTable); }
/* OLD STUFF */ /* * don't do more like this, use Sqlite.convertTables() */ //change DB from 0.55 to 0.56 protected internal static void convertTableAddingSportStuff() { ArrayList myArray = new ArrayList(2); //1st create a temp table //createTable(Constants.ConvertTempTable); SqliteSessionOld sqliteSessionObject = new SqliteSessionOld(); sqliteSessionObject.createTable(Constants.ConvertTempTable); //2nd copy all data from session table to temp table dbcmd.CommandText = "SELECT * " + "FROM " + Constants.SessionTable + " ORDER BY uniqueID"; SqliteDataReader reader; reader = dbcmd.ExecuteReader(); while(reader.Read()) { Session mySession = new Session(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), UtilDate.FromSql(reader[3].ToString()), 1, //sport undefined -1, //speciallity undefined -1, //practice level undefined reader[4].ToString(), //comments Constants.ServerUndefinedID ); myArray.Add(mySession); } reader.Close(); foreach (Session mySession in myArray) InsertOld(true, Constants.ConvertTempTable, mySession.Name, mySession.Place, UtilDate.ToSql(mySession.Date), mySession.PersonsSportID, mySession.PersonsSpeciallityID, mySession.PersonsPractice, mySession.Comments); //3rd drop table sessions Sqlite.dropTable(Constants.SessionTable); //4d create table persons (now with sport related stuff //createTable(Constants.SessionTable); sqliteSessionObject.createTable(Constants.SessionTable); //5th insert data in sessions (with sport related stuff) foreach (Session mySession in myArray) InsertOld(true, Constants.SessionTable, mySession.Name, mySession.Place, UtilDate.ToSql(mySession.Date), mySession.PersonsSportID, mySession.PersonsSpeciallityID, mySession.PersonsPractice, mySession.Comments); //6th drop temp table Sqlite.dropTable(Constants.ConvertTempTable); }