//recuperate temp jumpRj or RunI if chronojump hangs
private string recuperateBrokenEvents()
{
string returnString = "";
string tableName = "tempJumpRj";
int existsTempData = Sqlite.TempDataExists(tableName);
if (existsTempData > 0)
{
JumpRj myJumpRj = SqliteJumpRj.SelectJumpData("tempJumpRj", existsTempData, false);
try {
myJumpRj.InsertAtDB(true, Constants.JumpRjTable);
} catch {} //pitty, cannot insert
Sqlite.DeleteTempEvents(tableName);
returnString = "Recuperated last Reactive Jump";
}
tableName = "tempRunInterval";
existsTempData = Sqlite.TempDataExists(tableName);
if (existsTempData > 0)
{
RunInterval myRun = SqliteRunInterval.SelectRunData("tempRunInterval", existsTempData, false);
try {
myRun.InsertAtDB(true, Constants.RunIntervalTable);
} catch {} //pitty, cannot insert
Sqlite.DeleteTempEvents(tableName);
returnString = "Recuperated last Intervallic Run";
}
return(returnString);
}
protected override void getData()
{
//create directory fileName_files/
string directoryName = Util.GetReportDirectoryName(fileName);
if (!Directory.Exists(directoryName))
{
Directory.CreateDirectory(directoryName);
}
else
{
//if it exists before, delete all pngs
string [] pngs = Directory.GetFiles(directoryName, "*.png");
foreach (string myFile in pngs)
{
File.Delete(myFile);
}
}
if (ShowCurrentSessionJumpers)
{
myPersonsAndPS = SqlitePersonSession.SelectCurrentSessionPersons(sessionID, true);
}
//Leave SQL opened in all this process
Sqlite.Open(); // ------------------------------
if (ShowSimpleJumps)
{
myJumps = SqliteJump.SelectJumps(true, sessionID, -1, "", "",
Sqlite.Orders_by.DEFAULT, -1);
}
if (ShowReactiveJumps)
{
myJumpsRj = SqliteJumpRj.SelectJumps(true, sessionID, -1, "", "");
}
if (ShowSimpleRuns)
{
myRuns = SqliteRun.SelectRuns(true, sessionID, -1, "",
Sqlite.Orders_by.DEFAULT, -1);
}
if (ShowIntervalRuns)
{
myRunsInterval = SqliteRunInterval.SelectRuns(true, sessionID, -1, "");
}
if (ShowReactionTimes)
{
myReactionTimes = SqliteReactionTime.SelectReactionTimes(true, sessionID, -1, "",
Sqlite.Orders_by.DEFAULT, -1);
}
if (ShowPulses)
{
myPulses = SqlitePulse.SelectPulses(true, sessionID, -1);
}
Sqlite.Close(); // ------------------------------
}
public override int InsertAtDB(bool dbconOpened, string tableName)
{
return(SqliteJumpRj.Insert(dbconOpened, tableName,
uniqueID.ToString(),
personID, sessionID,
type, TvMax, TcMax, fall, weight,
description, TvAvg, TcAvg, tvString, tcString,
jumps, time, limited,
angleString, simulated));
}
protected virtual void getData()
{
myPersonsAndPS = SqlitePersonSession.SelectCurrentSessionPersons(mySession.UniqueID, true);
//Leave SQL opened in all this process
Sqlite.Open(); // ------------------------------
myJumps = SqliteJump.SelectJumps(true, mySession.UniqueID, -1, "", "",
Sqlite.Orders_by.DEFAULT, -1);
myJumpsRj = SqliteJumpRj.SelectJumps(true, mySession.UniqueID, -1, "", "");
myRuns = SqliteRun.SelectRuns(true, mySession.UniqueID, -1, "",
Sqlite.Orders_by.DEFAULT, -1);
myRunsInterval = SqliteRunInterval.SelectRuns(true, mySession.UniqueID, -1, "");
myReactionTimes = SqliteReactionTime.SelectReactionTimes(true, mySession.UniqueID, -1, "",
Sqlite.Orders_by.DEFAULT, -1);
myPulses = SqlitePulse.SelectPulses(true, mySession.UniqueID, -1);
myMCs = SqliteMultiChronopic.SelectTests(true, mySession.UniqueID, -1);
Sqlite.Close(); // ------------------------------
}
protected void writeRj(bool tempTable)
{
LogB.Information("----------WRITING----------");
int jumps;
string limitString = "";
string description = "";
//if user clicked in finish earlier
//or toggled with shouldFinishAtNextTime
if (finish)
{
//if user clicked finish and last event was tc, probably there are more TCs than TFs
//if last event was tc, it has no sense, it should be deleted
tcString = Util.DeleteLastTcIfNeeded(tcString, tvString);
//when we mark that jump should finish by time, chronopic thread is probably capturing data
//check if it captured more than date limit, and if it has done, delete last(s) jump(s)
//also have in mind that allowFinishAfterTime exist
bool deletedEvent = false;
if (!jumpsLimited && limitAsDouble != -1)
{
bool eventPassed = Util.EventPassedFromMaxTime(tcString, tvString, limitAsDouble, allowFinishAfterTime);
while (eventPassed)
{
tcString = Util.DeleteLastSubEvent(tcString);
tvString = Util.DeleteLastSubEvent(tvString);
LogB.Information("Deleted one event out of time");
eventPassed = Util.EventPassedFromMaxTime(tcString, tvString, limitAsDouble, allowFinishAfterTime);
deletedEvent = true;
}
}
if (deletedEvent)
{
//update graph if a event was deleted
PrepareEventGraphJumpReactiveObject = new PrepareEventGraphJumpReactive(Util.GetLast(tvString), Util.GetLast(tcString), tvString, tcString);
needUpdateGraphType = eventType.JUMPREACTIVE;
needUpdateGraph = true;
//try to fix this:
//http://mail.gnome.org/archives/chronojump-list/2007-June/msg00013.html
updateProgressBar = new UpdateProgressBar(
true, //isEvent
jumpsLimited, //if jumpsLimited: do fraction; if time limited: do pulse
Util.GetNumberOfJumps(tvString, false)
);
needUpdateEventProgressBar = true;
//and this:
//http://mail.gnome.org/archives/chronojump-list/2007-June/msg00017.html
updateTimerCountWithChronopicData(tcString, tvString);
}
jumps = Util.GetNumberOfJumps(tvString, false);
if (jumpsLimited)
{
limitString = jumps.ToString() + "J";
}
else
{
limitString = Util.GetTotalTime(tcString, tvString) + "T";
limited = limitString; //define limited because it's checked in treeviewJump, and possibly it's not the initial defined time (specially when allowFinishRjAfterTime is true)
//leave the initial selected time into description/comments:
description = string.Format(Catalog.GetString("Initially selected {0} seconds"), limitAsDouble.ToString());
}
}
else
{
if (jumpsLimited)
{
limitString = limitAsDouble.ToString() + "J";
jumps = (int)limitAsDouble;
}
else
{
//if time finished and the last event was tc, probably there are more TCs than TFs
//if last event was tc, it has no sense, it should be deleted
//this is not aplicable in tempTable
if (!tempTable)
{
tcString = Util.DeleteLastTcIfNeeded(tcString, tvString);
}
//limitString = limitAsDouble.ToString() + "T";
limitString = Util.GetTotalTime(tcString, tvString) + "T";
limited = limitString; //define limited because it's checked in treeviewJump, and possibly it's not the initial defined time (specially when allowFinishRjAfterTime is true)
//leave the initial selected time into description/comments:
description = string.Format(Catalog.GetString("Initially selected {0} seconds"), limitAsDouble.ToString());
string [] myStringFull = tcString.Split(new char[] { '=' });
jumps = myStringFull.Length;
}
}
if (type == Constants.RunAnalysisName)
{
//double speed = (fall /10) / Util.GetTotalTime(tcString, tvString);
/*
* Josep Ma Padullés test
*
* string tcStringWithoutFirst = Util.DeleteFirstSubEvent(tcString);
* string tvStringWithoutFirst = Util.DeleteFirstSubEvent(tvString);
*
* double averagePlatformTimes = ( Util.GetAverage(tcStringWithoutFirst) + Util.GetAverage(tvStringWithoutFirst) ) / 2;
* double freq = 1 / averagePlatformTimes;
*
* //amplitud
* double range = speed / freq;
*
* //don't put "=" because can appear problems in different parts of the code
* description =
* Catalog.GetString ("AVG speed") + "->" + Util.TrimDecimals(speed.ToString(), pDN) + "m/s, " +
* Catalog.GetString ("AVG frequencies") + "->" + Util.TrimDecimals(freq.ToString(), pDN) + "Hz, " +
* Catalog.GetString ("AVG range") + "->" + Util.TrimDecimals(range.ToString(), pDN) + "m.";
*/
}
if (tempTable)
{
SqliteJumpRj.Insert(false, Constants.TempJumpRjTable, "NULL", personID, sessionID,
type, Util.GetMax(tvString), Util.GetMax(tcString),
fall, weight, description,
Util.GetAverage(tvString), Util.GetAverage(tcString),
tvString, tcString,
jumps, Util.GetTotalTime(tcString, tvString), limitString, angleString, Util.BoolToNegativeInt(simulated)
);
}
else
{
uniqueID = SqliteJumpRj.Insert(false, Constants.JumpRjTable, "NULL", personID, sessionID,
type, Util.GetMax(tvString), Util.GetMax(tcString),
fall, weight, description,
Util.GetAverage(tvString), Util.GetAverage(tcString),
tvString, tcString,
jumps, Util.GetTotalTime(tcString, tvString), limitString, angleString, Util.BoolToNegativeInt(simulated)
);
//define the created object
eventDone = new JumpRj(uniqueID, personID, sessionID, type, tvString, tcString, fall, weight, description, jumps, Util.GetTotalTime(tcString, tvString), limitString, angleString, Util.BoolToNegativeInt(simulated));
//event will be raised, and managed in chronojump.cs
/*
* string myStringPush =
* //Catalog.GetString("Last jump: ") +
* personName + " " +
* type + " (" + limitString + ") " +
* " " + Catalog.GetString("AVG TF") + ": " + Util.TrimDecimals( Util.GetAverage (tvString).ToString(), pDN ) +
* " " + Catalog.GetString("AVG TC") + ": " + Util.TrimDecimals( Util.GetAverage (tcString).ToString(), pDN ) ;
*/
if (simulated)
{
feedbackMessage = Catalog.GetString(Constants.SimulatedMessage);
}
else
{
feedbackMessage = "";
}
needShowFeedbackMessage = true;
//event will be raised, and managed in chronojump.cs
fakeButtonFinished.Click();
needEndEvent = true; //used for hiding some buttons on eventWindow, and also for updateTimeProgressBar here
}
}
public static bool ConvertToLastChronojumpDBVersion()
{
LogB.SQL("SelectChronojumpProfile ()");
//if(checkIfIsSqlite2())
// convertSqlite2To3();
addChronopicPortNameIfNotExists();
currentVersion = SqlitePreferences.Select("databaseVersion");
//LogB.SQL("lastDB: {0}", Convert.ToDouble(lastChronojumpDatabaseVersion));
//LogB.SQL("currentVersion: {0}", Convert.ToDouble(currentVersion));
bool returnSoftwareIsNew = true; //-1 if software is too old for database (moved db to other computer)
if(
Convert.ToDouble(Util.ChangeDecimalSeparator(lastChronojumpDatabaseVersion)) ==
Convert.ToDouble(Util.ChangeDecimalSeparator(currentVersion)))
LogB.SQL("Database is already latest version");
else if(
Convert.ToDouble(Util.ChangeDecimalSeparator(lastChronojumpDatabaseVersion)) <
Convert.ToDouble(Util.ChangeDecimalSeparator(currentVersion))) {
LogB.SQL("User database newer than program, need to update software");
returnSoftwareIsNew = false;
} else {
LogB.Warning("Old database, need to convert");
LogB.Warning("db version: " + currentVersion);
bool needToConvertPersonToSport = false;
bool jumpFallAsDouble = false;
bool runAndRunIntervalInitialSpeedAdded = false;
bool addedRSA = false;
SqliteJumpRj sqliteJumpRjObject = new SqliteJumpRj();
SqliteRunInterval sqliteRunIntervalObject = new SqliteRunInterval();
SqliteReactionTime sqliteReactionTimeObject = new SqliteReactionTime();
SqlitePulse sqlitePulseObject = new SqlitePulse();
SqliteMultiChronopic sqliteMultiChronopicObject = new SqliteMultiChronopic();
SqlitePersonSessionOld sqlitePersonSessionOldObject = new SqlitePersonSessionOld();
if(currentVersion == "0.41") {
Sqlite.Open();
//SqlitePulse.createTable(Constants.PulseTable);
sqlitePulseObject.createTable(Constants.PulseTable);
SqlitePulseType.createTablePulseType();
SqlitePulseType.initializeTablePulseType();
SqlitePreferences.Update ("databaseVersion", "0.42", true);
LogB.SQL("Converted DB to 0.42 (added pulse and pulseType tables)");
Sqlite.Close();
currentVersion = "0.42";
}
if(currentVersion == "0.42") {
Sqlite.Open();
SqlitePulseType.Insert ("Free:-1:-1:free PulseStep mode", true);
SqlitePreferences.Insert ("language", "es-ES");
SqlitePreferences.Update ("databaseVersion", "0.43", true);
LogB.SQL("Converted DB to 0.43 (added 'free' pulseType & language peference)");
Sqlite.Close();
currentVersion = "0.43";
}
if(currentVersion == "0.43") {
Sqlite.Open();
SqlitePreferences.Insert ("showQIndex", "False");
SqlitePreferences.Insert ("showDjIndex", "False");
SqlitePreferences.Update ("databaseVersion", "0.44", true);
LogB.SQL("Converted DB to 0.44 (added showQIndex, showDjIndex)");
Sqlite.Close();
currentVersion = "0.44";
}
if(currentVersion == "0.44") {
Sqlite.Open();
SqlitePreferences.Insert ("allowFinishRjAfterTime", "True");
SqlitePreferences.Update ("databaseVersion", "0.45", true);
LogB.SQL("Converted DB to 0.45 (added allowFinishRjAfterTime)");
Sqlite.Close();
currentVersion = "0.45";
}
if(currentVersion == "0.45") {
Sqlite.Open();
SqliteJumpType.JumpTypeInsert ("Free:1:0:Free jump", true);
SqlitePreferences.Update ("databaseVersion", "0.46", true);
LogB.SQL("Added Free jump type");
Sqlite.Close();
currentVersion = "0.46";
}
if(currentVersion == "0.46") {
Sqlite.Open();
//SqliteReactionTime.createTable(Constants.ReactionTimeTable);
sqliteReactionTimeObject.createTable(Constants.ReactionTimeTable);
SqlitePreferences.Update ("databaseVersion", "0.47", true);
LogB.SQL("Added reaction time table");
Sqlite.Close();
currentVersion = "0.47";
}
if(currentVersion == "0.47") {
Sqlite.Open();
//SqliteJumpRj.createTable(Constants.TempJumpRjTable);
sqliteJumpRjObject.createTable(Constants.TempJumpRjTable);
//SqliteRun.intervalCreateTable(Constants.TempRunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
SqlitePreferences.Update ("databaseVersion", "0.48", true);
LogB.SQL("created tempJumpReactive and tempRunInterval tables");
Sqlite.Close();
currentVersion = "0.48";
}
if(currentVersion == "0.48") {
Sqlite.Open();
SqliteJumpType.JumpTypeInsert ("Rocket:1:0:Rocket jump", true);
string [] iniRunTypes = {
"Agility-20Yard:18.28:20Yard Agility test",
"Agility-505:10:505 Agility test",
"Agility-Illinois:60:Illinois Agility test",
"Agility-Shuttle-Run:40:Shuttle Run Agility test",
"Agility-ZigZag:17.6:ZigZag Agility test"
};
foreach(string myString in iniRunTypes) {
string [] s = myString.Split(new char[] {':'});
RunType type = new RunType();
type.Name = s[0];
type.Distance = Convert.ToDouble(s[1]);
type.Description = s[2];
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
}
SqliteEvent.createGraphLinkTable();
SqliteRunType.AddGraphLinksRunSimpleAgility();
SqlitePreferences.Update ("databaseVersion", "0.49", true);
LogB.SQL("Added graphLinkTable, added Rocket jump and 5 agility tests: (20Yard, 505, Illinois, Shuttle-Run & ZigZag. Added graphs pof the 5 agility tests)");
Sqlite.Close();
currentVersion = "0.49";
}
if(currentVersion == "0.49") {
Sqlite.Open();
SqliteJumpType.Update ("SJ+", "SJl");
SqliteJumpType.Update ("CMJ+", "CJl");
SqliteJumpType.Update ("ABK+", "ABKl");
SqliteJump.ChangeWeightToL();
SqliteJumpType.AddGraphLinks();
SqliteJumpType.AddGraphLinksRj();
SqlitePreferences.Update ("databaseVersion", "0.50", true);
LogB.SQL("changed SJ+ to SJl, same for CMJ+ and ABK+, added jump and jumpRj graph links");
Sqlite.Close();
currentVersion = "0.50";
}
if(currentVersion == "0.50") {
Sqlite.Open();
SqliteRunType.AddGraphLinksRunSimple();
SqliteRunIntervalType.AddGraphLinksRunInterval();
SqlitePreferences.Update ("databaseVersion", "0.51", true);
LogB.SQL("added graphLinks for run simple and interval");
Sqlite.Close();
currentVersion = "0.51";
}
if(currentVersion == "0.51") {
Sqlite.Open();
SqliteJumpType.Update ("CJl", "CMJl");
SqliteEvent.GraphLinkInsert (Constants.JumpTable, "CMJl", "jump_cmj_l.png", true);
SqliteEvent.GraphLinkInsert (Constants.JumpTable, "ABKl", "jump_abk_l.png", true);
SqlitePreferences.Update ("databaseVersion", "0.52", true);
LogB.SQL("added graphLinks for cmj_l and abk_l, fixed CMJl name");
Sqlite.Close();
currentVersion = "0.52";
}
if(currentVersion == "0.52") {
Sqlite.Open();
sqlitePersonSessionOldObject.createTable ();
Sqlite.Close();
//this needs the dbCon closed
SqlitePersonSessionOld.moveOldTableToNewTable ();
Sqlite.Open();
SqlitePreferences.Update ("databaseVersion", "0.53", true);
Sqlite.Close();
LogB.SQL("created weightSession table. Moved person weight data to weightSession table for each session that has performed");
currentVersion = "0.53";
}
if(currentVersion == "0.53") {
Sqlite.Open();
SqliteSport.createTable();
SqliteSport.initialize();
SqliteSpeciallity.createTable();
SqliteSpeciallity.initialize();
//SqlitePersonOld.convertTableToSportRelated ();
needToConvertPersonToSport = true;
SqlitePreferences.Update ("databaseVersion", "0.54", true);
Sqlite.Close();
LogB.SQL("Created sport tables. Added sport data, speciallity and level of practice to person table");
currentVersion = "0.54";
}
if(currentVersion == "0.54") {
Sqlite.Open();
SqliteSpeciallity.InsertUndefined(true);
SqlitePreferences.Update ("databaseVersion", "0.55", true);
Sqlite.Close();
LogB.SQL("Added undefined to speciallity table");
currentVersion = "0.55";
}
if(currentVersion == "0.55") {
Sqlite.Open();
SqliteSessionOld.convertTableAddingSportStuff();
SqlitePreferences.Update ("databaseVersion", "0.56", true);
Sqlite.Close();
LogB.SQL("Added session default sport stuff into session table");
currentVersion = "0.56";
}
if(currentVersion == "0.56") {
Sqlite.Open();
//jump and jumpRj
ArrayList arrayAngleAndSimulated = new ArrayList(1);
arrayAngleAndSimulated.Add("-1"); //angle
arrayAngleAndSimulated.Add("-1"); //simulated
//run and runInterval
ArrayList arraySimulatedAndInitialSpeed = new ArrayList(1);
arraySimulatedAndInitialSpeed.Add("-1"); //simulated
arraySimulatedAndInitialSpeed.Add("0"); //initial speed
//others
ArrayList arraySimulated = new ArrayList(1);
arraySimulated.Add("-1"); //simulated
conversionRateTotal = 9;
conversionRate = 1;
convertTables(new SqliteJump(), Constants.JumpTable, 9, arrayAngleAndSimulated, false);
conversionRate ++;
convertTables(new SqliteJumpRj(), Constants.JumpRjTable, 16, arrayAngleAndSimulated, false);
conversionRate ++;
convertTables(new SqliteRun(), Constants.RunTable, 7, arraySimulated, false);
conversionRate ++;
convertTables(new SqliteRunInterval(), Constants.RunIntervalTable, 11, arraySimulated, false);
runAndRunIntervalInitialSpeedAdded = true;
conversionRate ++;
convertTables(new SqliteReactionTime(), Constants.ReactionTimeTable, 6, arraySimulated, false);
conversionRate ++;
convertTables(new SqlitePulse(), Constants.PulseTable, 8, arraySimulated, false);
//reacreate temp tables for have also the simulated column
conversionRate ++;
Sqlite.dropTable(Constants.TempJumpRjTable);
sqliteJumpRjObject.createTable(Constants.TempJumpRjTable);
Sqlite.dropTable(Constants.TempRunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
conversionRate ++;
SqliteCountry.createTable();
SqliteCountry.initialize();
conversionRate ++;
int columnsBefore = 10;
bool putDescriptionInMiddle = false;
ArrayList arrayPersonRaceCountryServerID = new ArrayList(1);
if(needToConvertPersonToSport) {
columnsBefore = 7;
arrayPersonRaceCountryServerID.Add(Constants.SportUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.SpeciallityUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.LevelUndefinedID.ToString());
putDescriptionInMiddle = true;
}
arrayPersonRaceCountryServerID.Add(Constants.RaceUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.CountryUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.ServerUndefinedID.ToString());
convertTables(new SqlitePersonOld(), Constants.PersonOldTable, columnsBefore, arrayPersonRaceCountryServerID, putDescriptionInMiddle);
SqlitePreferences.Update ("databaseVersion", "0.57", true);
Sqlite.Close();
LogB.SQL("Added simulated column to each event table on client. Added to person: race, country, serverUniqueID. Convert to sport related done here if needed. Added also run and runInterval initial speed");
currentVersion = "0.57";
}
if(currentVersion == "0.57") {
Sqlite.Open();
//check if "republic" is in country table
if(SqliteCountry.TableHasOldRepublicStuff()){
conversionRateTotal = 4;
conversionRate = 1;
Sqlite.dropTable(Constants.CountryTable);
conversionRate ++;
SqliteCountry.createTable();
conversionRate ++;
SqliteCountry.initialize();
conversionRate ++;
LogB.SQL("Countries without kingdom or republic (except when needed)");
}
SqlitePreferences.Update ("databaseVersion", "0.58", true);
Sqlite.Close();
currentVersion = "0.58";
}
if(currentVersion == "0.58") {
Sqlite.Open();
conversionRateTotal = 2;
conversionRate = 1;
SqlitePreferences.Insert ("showAngle", "False");
alterTableColumn(new SqliteJump(), Constants.JumpTable, 11);
//jump fall is also converted to double (don't need to do at conversion to 0.76)
jumpFallAsDouble = true;
SqlitePreferences.Update ("databaseVersion", "0.59", true);
LogB.SQL("Converted DB to 0.59 (added 'showAngle' to preferences, changed angle on jump to double)");
conversionRate = 2;
Sqlite.Close();
currentVersion = "0.59";
}
if(currentVersion == "0.59") {
Sqlite.Open();
conversionRateTotal = 4;
conversionRate = 1;
SqlitePreferences.Insert ("volumeOn", "True");
SqlitePreferences.Insert ("evaluatorServerID", "-1");
conversionRate = 2;
int columnsBefore = 8;
ArrayList arrayServerID = new ArrayList(1);
arrayServerID.Add(Constants.ServerUndefinedID.ToString());
convertTables(new SqliteSession(), Constants.SessionTable, columnsBefore, arrayServerID, false);
conversionRate = 3;
SqliteEvent.SimulatedConvertToNegative();
SqlitePreferences.Update ("databaseVersion", "0.60", true);
LogB.SQL("Converted DB to 0.60 (added volumeOn and evaluatorServerID to preferences. session has now serverUniqueID. Simulated now are -1, because 0 is real and positive is serverUniqueID)");
conversionRate = 4;
Sqlite.Close();
currentVersion = "0.60";
}
if(currentVersion == "0.60") {
Sqlite.Open();
conversionRateTotal = 3;
conversionRate = 1;
ArrayList arrayDS = new ArrayList(1);
arrayDS.Add("-1"); //distancesString
convertTables(new SqliteRunIntervalType(), Constants.RunIntervalTypeTable, 7, arrayDS, false);
conversionRate = 2;
//SqliteRunType.RunIntervalTypeInsert ("MTGUG:-1:true:3:false:Modified time Getup and Go test:1-7-19", true);
RunType type = new RunType();
type.Name = "MTGUG";
type.Distance = -1;
type.TracksLimited = true;
type.FixedValue = 3;
type.Unlimited = false;
type.Description = "Modified time Getup and Go test";
type.DistancesString = "1-7-19";
SqliteRunIntervalType.Insert(type, Constants.RunIntervalTypeTable, true);
SqlitePreferences.Update ("databaseVersion", "0.61", true);
LogB.SQL("Converted DB to 0.61 added RunIntervalType distancesString (now we van have interval tests with different distances of tracks). Added MTGUG");
conversionRate = 3;
Sqlite.Close();
currentVersion = "0.61";
}
if(currentVersion == "0.61") {
Sqlite.Open();
SqliteJumpType.JumpRjTypeInsert ("RJ(hexagon):1:0:1:18:Reactive Jump on a hexagon until three full revolutions are done", true);
SqlitePreferences.Update ("databaseVersion", "0.62", true);
LogB.SQL("Converted DB to 0.62 added hexagon");
Sqlite.Close();
currentVersion = "0.62";
}
if(currentVersion == "0.62") {
Sqlite.Open();
SqlitePreferences.Insert ("versionAvailable", "");
SqlitePreferences.Update ("databaseVersion", "0.63", true);
LogB.SQL("Converted DB to 0.63 (added 'versionAvailable' to preferences)");
Sqlite.Close();
currentVersion = "0.63";
}
if(currentVersion == "0.63") {
Sqlite.Open();
RunType type = new RunType();
type.Name = "Margaria";
type.Distance = 0;
type.Description = "Margaria-Kalamen test";
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
SqliteEvent.GraphLinkInsert (Constants.RunTable, "Margaria", "margaria.png", true);
SqlitePreferences.Update ("databaseVersion", "0.64", true);
LogB.SQL("Converted DB to 0.64 (added margaria test)");
Sqlite.Close();
currentVersion = "0.64";
}
if(currentVersion == "0.64") {
Sqlite.Open();
SqliteServer sqliteServerObject = new SqliteServer();
//user has also an evaluator table with a row (it's row)
sqliteServerObject.CreateEvaluatorTable();
SqlitePreferences.Update ("databaseVersion", "0.65", true);
LogB.SQL("Converted DB to 0.65 (added Sevaluator on client)");
Sqlite.Close();
currentVersion = "0.65";
}
if(currentVersion == "0.65") {
Sqlite.Open();
//now runAnalysis is a multiChronopic event
//SqliteJumpType.JumpRjTypeInsert ("RunAnalysis:0:0:1:-1:Run between two photocells recording contact and flight times in contact platform/s. Until finish button is clicked.", true);
SqlitePreferences.Update ("databaseVersion", "0.66", true);
//LogB.SQL("Converted DB to 0.66 (added RunAnalysis Reactive jump)");
LogB.SQL("Converted DB to 0.66 (done nothing)");
Sqlite.Close();
currentVersion = "0.66";
}
if(currentVersion == "0.66") {
Sqlite.Open();
SqliteJumpType.JumpTypeInsert ("TakeOff:0:0:Take off", true);
SqliteJumpType.JumpTypeInsert ("TakeOffWeight:0:0:Take off with weight", true);
SqlitePreferences.Update ("databaseVersion", "0.67", true);
LogB.SQL("Converted DB to 0.67 (added TakeOff jumps)");
Sqlite.Close();
currentVersion = "0.67";
}
if(currentVersion == "0.67") {
Sqlite.Open();
sqliteMultiChronopicObject.createTable(Constants.MultiChronopicTable);
SqlitePreferences.Update ("databaseVersion", "0.68", true);
LogB.SQL("Converted DB to 0.68 (added multiChronopic tests table)");
Sqlite.Close();
currentVersion = "0.68";
}
if(currentVersion == "0.68") {
Sqlite.Open();
RunType type = new RunType();
type.Name = "Gesell-DBT";
type.Distance = 2.5;
type.Description = "Gesell Dynamic Balance Test";
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
SqliteEvent.GraphLinkInsert (Constants.RunTable, "Gesell-DBT", "gesell_dbt.png", true);
SqlitePreferences.Update ("databaseVersion", "0.69", true);
LogB.SQL("Converted DB to 0.69 (added Gesell-DBT test)");
Sqlite.Close();
currentVersion = "0.69";
}
if(currentVersion == "0.69") {
Sqlite.Open();
SqlitePreferences.Insert ("showPower", "True");
SqlitePreferences.Update ("databaseVersion", "0.70", true);
LogB.SQL("Converted DB to 0.70 (added showPower)");
Sqlite.Close();
currentVersion = "0.70";
}
if(currentVersion == "0.70") {
Sqlite.Open();
SqlitePersonSessionNotUpload.CreateTable();
SqlitePreferences.Update ("databaseVersion", "0.71", true);
LogB.SQL("Converted DB to 0.71 (created personNotUploadTable on client)");
Sqlite.Close();
currentVersion = "0.71";
}
if(currentVersion == "0.71") {
Sqlite.Open();
datesToYYYYMMDD();
SqlitePreferences.Update ("databaseVersion", "0.72", true);
LogB.SQL("Converted DB to 0.72 (dates to YYYY-MM-DD)");
Sqlite.Close();
currentVersion = "0.72";
}
if(currentVersion == "0.72") {
Sqlite.Open();
deleteOrphanedPersonsOld();
SqlitePreferences.Update ("databaseVersion", "0.73", true);
LogB.SQL("Converted DB to 0.73 (deleted orphaned persons (in person table but not in personSessionWeight table)");
Sqlite.Close();
currentVersion = "0.73";
}
if(currentVersion == "0.73") {
//dbcon open laters on mid convertDJinDJna()
convertDJInDJna();
SqlitePreferences.Update ("databaseVersion", "0.74", true);
LogB.SQL("Converted DB to 0.74 (All DJ converted to DJna)");
Sqlite.Close();
currentVersion = "0.74";
}
if(currentVersion == "0.74") {
conversionRateTotal = 3;
conversionRate = 1;
Sqlite.Open();
convertTables(new SqlitePersonOld(), Constants.PersonOldTable, 13, new ArrayList(), false);
conversionRate++;
convertTables(new SqlitePersonSessionOld(), Constants.PersonSessionOldWeightTable, 4, new ArrayList(), false);
SqlitePreferences.Update ("databaseVersion", "0.75", true);
conversionRate++;
LogB.SQL("Converted DB to 0.75 (person, and personSessionWeight have height and weight as double)");
Sqlite.Close();
currentVersion = "0.75";
}
if(currentVersion == "0.75") {
conversionRateTotal = 3;
conversionRate = 1;
Sqlite.Open();
if(!jumpFallAsDouble)
alterTableColumn(new SqliteJump(), Constants.JumpTable, 11);
conversionRate++;
alterTableColumn(new SqliteJumpRj(), Constants.JumpRjTable, 18);
SqlitePreferences.Update ("databaseVersion", "0.76", true);
conversionRate++;
LogB.SQL("Converted DB to 0.76 (jump & jumpRj falls as double)");
Sqlite.Close();
currentVersion = "0.76";
}
if(currentVersion == "0.76") {
Sqlite.Open();
convertPersonAndPersonSessionTo77();
SqlitePreferences.Update ("databaseVersion", "0.77", true);
LogB.SQL("Converted DB to 0.77 (person77, personSession77)");
Sqlite.Close();
currentVersion = "0.77";
}
if(currentVersion == "0.77") {
Sqlite.Open();
SqliteJumpType.UpdateOther ("weight", Constants.TakeOffWeightName, "1");
Random rnd = new Random();
string machineID = rnd.Next().ToString();
SqlitePreferences.Insert ("machineID", machineID);
SqlitePreferences.Update ("databaseVersion", "0.78", true);
LogB.SQL("Converted DB to 0.78 (Added machineID to preferences, takeOffWeight has no weight in db conversions since 0.66)");
Sqlite.Close();
currentVersion = "0.78";
}
if(currentVersion == "0.78") {
Sqlite.Open();
SqlitePreferences.Insert ("multimediaStorage", Constants.MultimediaStorage.BYSESSION.ToString());
SqlitePreferences.Update ("databaseVersion", "0.79", true);
LogB.SQL("Converted DB to 0.79 (Added multimediaStorage structure id)");
Sqlite.Close();
currentVersion = "0.79";
}
if(currentVersion == "0.79") {
Sqlite.Open();
if(! runAndRunIntervalInitialSpeedAdded) {
ArrayList myArray = new ArrayList(1);
myArray.Add("0"); //initial speed
conversionRateTotal = 3;
conversionRate = 1;
convertTables(new SqliteRun(), Constants.RunTable, 8, myArray, false);
conversionRate ++;
convertTables(new SqliteRunInterval(), Constants.RunIntervalTable, 12, myArray, false);
conversionRate ++;
LogB.SQL("Converted DB to 0.80 Added run and runInterval initial speed (if not done in 0.56 conversion)");
}
SqlitePreferences.Update ("databaseVersion", "0.80", true);
Sqlite.Close();
currentVersion = "0.80";
}
if(currentVersion == "0.80") {
Sqlite.Open();
ArrayList myArray = new ArrayList(1);
myArray.Add("0"); //initial speed
conversionRateTotal = 2;
conversionRate = 1;
Sqlite.dropTable(Constants.TempRunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
conversionRate ++;
LogB.SQL("Converted DB to 0.81 Added tempRunInterval initial speed");
SqlitePreferences.Update ("databaseVersion", "0.81", true);
Sqlite.Close();
currentVersion = "0.81";
}
if(currentVersion == "0.81") {
Sqlite.Open();
conversionRateTotal = 2;
conversionRate = 1;
SqlitePreferences.Insert ("videoOn", "False");
conversionRate = 2;
LogB.SQL("Converted DB to 0.82 Added videoOn");
SqlitePreferences.Update ("databaseVersion", "0.82", true);
Sqlite.Close();
currentVersion = "0.82";
}
if(currentVersion == "0.82") {
Sqlite.Open();
conversionRateTotal = 2;
conversionRate = 1;
SqliteEncoder.createTableEncoder();
SqliteEncoder.createTableEncoderExercise();
SqliteEncoder.initializeTableEncoderExercise();
conversionRate = 2;
LogB.SQL("Created encoder tables.");
SqlitePreferences.Update ("databaseVersion", "0.83", true);
Sqlite.Close();
currentVersion = "0.83";
}
if(currentVersion == "0.83") {
Sqlite.Open();
RunType type = new RunType();
type.Name = "RSA 8-4-R3-5";
type.Distance = -1;
type.TracksLimited = true;
type.FixedValue = 4;
type.Unlimited = false;
type.Description = "RSA testing";
type.DistancesString = "8-4-R3-5";
SqliteRunIntervalType.Insert(type, Constants.RunIntervalTypeTable, true);
LogB.SQL("Added 1st RSA test.");
SqlitePreferences.Update ("databaseVersion", "0.84", true);
Sqlite.Close();
currentVersion = "0.84";
}
if(currentVersion == "0.84") {
Sqlite.Open();
SqliteJumpType.JumpTypeInsert ("slCMJ:1:0:Single-leg CMJ jump", true);
SqlitePreferences.Update ("databaseVersion", "0.85", true);
LogB.SQL("Converted DB to 0.85 (added slCMJ jump)");
Sqlite.Close();
currentVersion = "0.85";
}
if(currentVersion == "0.85") {
Sqlite.Open();
LogB.SQL("Converted DB to 0.86 videoOn: TRUE");
SqlitePreferences.Update("videoOn", "True", true);
SqlitePreferences.Update ("databaseVersion", "0.86", true);
Sqlite.Close();
currentVersion = "0.86";
}
if(currentVersion == "0.86") {
Sqlite.Open();
LogB.SQL("Added run speed start preferences on sqlite");
SqlitePreferences.Insert ("runSpeedStartArrival", "True");
SqlitePreferences.Insert ("runISpeedStartArrival", "True");
SqlitePreferences.Update ("databaseVersion", "0.87", true);
Sqlite.Close();
currentVersion = "0.87";
}
if(currentVersion == "0.87") {
//delete runInterval type
SqliteRunIntervalType.Delete("RSA 8-4-R3-5");
//delete all it's runs
Sqlite.Open();
dbcmd.CommandText = "DELETE FROM " + Constants.RunIntervalTable +
" WHERE type == \"RSA 8-4-R3-5\"";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
//add know RSAs
SqliteRunIntervalType.addRSA();
addedRSA = true;
LogB.SQL("Deleted fake RSA test and added known RSA tests.");
SqlitePreferences.Update ("databaseVersion", "0.88", true);
Sqlite.Close();
currentVersion = "0.88";
}
if(currentVersion == "0.88") {
Sqlite.Open();
SqliteEncoder.addEncoderFreeExercise();
LogB.SQL("Added encoder exercise: Free");
SqlitePreferences.Update ("databaseVersion", "0.89", true);
Sqlite.Close();
currentVersion = "0.89";
}
if(currentVersion == "0.89") {
Sqlite.Open();
SqlitePreferences.Insert("encoderPropulsive", "True");
SqlitePreferences.Insert("encoderSmoothEccCon", "0.6");
SqlitePreferences.Insert("encoderSmoothCon", "0.7");
LogB.SQL("Preferences added propulsive and encoder smooth");
SqlitePreferences.Update ("databaseVersion", "0.90", true);
Sqlite.Close();
currentVersion = "0.90";
}
if(currentVersion == "0.90") {
Sqlite.Open();
SqliteEncoder.UpdateExercise(true, "Squat", "Squat", 100, "weight bar", "", "");
LogB.SQL("Encoder Squat 75% -> 100%");
SqlitePreferences.Update ("databaseVersion", "0.91", true);
Sqlite.Close();
currentVersion = "0.91";
}
if(currentVersion == "0.91") {
Sqlite.Open();
SqlitePreferences.Insert("videoDevice", "0");
LogB.SQL("Added videoDevice to preferences");
SqlitePreferences.Update ("databaseVersion", "0.92", true);
Sqlite.Close();
currentVersion = "0.92";
}
if(currentVersion == "0.92") {
Sqlite.Open();
SqliteEncoder.UpdateExercise(true, "Bench press", "Bench press", 0, "weight bar", "","0.185");
SqliteEncoder.UpdateExercise(true, "Squat", "Squat", 100, "weight bar", "","0.31");
LogB.SQL("Added speed1RM on encoder exercise");
SqlitePreferences.Update ("databaseVersion", "0.93", true);
Sqlite.Close();
currentVersion = "0.93";
}
if(currentVersion == "0.93") {
Sqlite.Open();
SqliteEncoder.createTable1RM();
LogB.SQL("Added encoder1RM table");
SqlitePreferences.Update ("databaseVersion", "0.94", true);
Sqlite.Close();
currentVersion = "0.94";
}
if(currentVersion == "0.94") {
Sqlite.Open();
SqlitePreferences.Insert ("encoder1RMMethod",
Constants.Encoder1RMMethod.WEIGHTED2.ToString());
LogB.SQL("Added encoder1RMMethod");
SqlitePreferences.Update ("databaseVersion", "0.95", true);
Sqlite.Close();
currentVersion = "0.95";
}
if(currentVersion == "0.95") {
Sqlite.Open();
Update(true, Constants.EncoderTable, "future3", "", Constants.EncoderConfigurationNames.LINEAR.ToString(),
"signalOrCurve", "signal");
Update(true, Constants.EncoderTable, "future3", "0", Constants.EncoderConfigurationNames.LINEAR.ToString(),
"signalOrCurve", "signal");
Update(true, Constants.EncoderTable, "future3", "1", Constants.EncoderConfigurationNames.LINEARINVERTED.ToString(),
"signalOrCurve", "signal");
LogB.SQL("Encoder signal future3 three modes");
SqlitePreferences.Update ("databaseVersion", "0.96", true);
Sqlite.Close();
currentVersion = "0.96";
}
if(currentVersion == "0.96") {
Sqlite.Open();
SqlitePreferences.Insert ("inertialmomentum", "0.01");
LogB.SQL("Added inertialmomentum in preferences");
SqlitePreferences.Update ("databaseVersion", "0.97", true);
Sqlite.Close();
currentVersion = "0.97";
}
if(currentVersion == "0.97") {
Sqlite.Open();
Update(true, Constants.EncoderTable, "laterality", "both", "RL", "", "");
Update(true, Constants.EncoderTable, "laterality", "Both", "RL", "", "");
Update(true, Constants.EncoderTable, "laterality", Catalog.GetString("Both"), "RL", "", "");
Update(true, Constants.EncoderTable, "laterality", "right", "R", "", "");
Update(true, Constants.EncoderTable, "laterality", "Right", "R", "", "");
Update(true, Constants.EncoderTable, "laterality", Catalog.GetString("Right"), "R", "", "");
Update(true, Constants.EncoderTable, "laterality", "left", "L", "", "");
Update(true, Constants.EncoderTable, "laterality", "Left", "L", "", "");
Update(true, Constants.EncoderTable, "laterality", Catalog.GetString("Left"), "L", "", "");
LogB.SQL("Fixed encoder laterality");
SqlitePreferences.Update ("databaseVersion", "0.98", true);
Sqlite.Close();
currentVersion = "0.98";
}
if(currentVersion == "0.98") {
Sqlite.Open();
ArrayList array = SqliteOldConvert.EncoderSelect098(true,-1,-1,-1,"all",false);
conversionRateTotal = array.Count;
dropTable(Constants.EncoderTable);
//CAUTION: do like this and never do createTableEncoder,
//because method will change in the future and will break updates
SqliteOldConvert.createTableEncoder99();
int count = 1;
foreach( EncoderSQL098 es in array) {
conversionRate = count;
//do not use SqliteEncoder.Insert because that method maybe changes in the future,
//and here we need to do a conversion that works from 0.98 to 0.99
dbcmd.CommandText = "INSERT INTO " + Constants.EncoderTable +
" (uniqueID, personID, sessionID, exerciseID, eccon, laterality, extraWeight, " +
"signalOrCurve, filename, url, time, minHeight, smooth, description, status, " +
"videoURL, mode, inertiaMomentum, diameter, future1, future2, future3)" +
" VALUES (" + es.uniqueID + ", " +
es.personID + ", " + es.sessionID + ", " +
es.exerciseID + ", \"" + es.eccon + "\", \"" +
es.laterality + "\", \"" + es.extraWeight + "\", \"" +
es.signalOrCurve + "\", \"" + es.filename + "\", \"" +
es.url + "\", " + es.time + ", " + es.minHeight + ", " +
Util.ConvertToPoint(es.smooth) + ", \"" + es.description + "\", \"" +
es.future1 + "\", \"" + es.future2 + "\", \"LINEAR\", " + //status, videoURL, mode
"0, 0, \"\", \"\", \"\")"; //inertiaMomentum, diameter, future1, 2, 3
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
count ++;
}
conversionRate = count;
LogB.SQL("Encoder table improved");
SqlitePreferences.Update ("databaseVersion", "0.99", true);
Sqlite.Close();
currentVersion = "0.99";
}
if(currentVersion == "0.99") {
Sqlite.Open();
SqliteEncoder.putEncoderExerciseAnglesAt90();
SqliteEncoder.addEncoderJumpExercise();
SqliteEncoder.addEncoderInclinedExercises();
LogB.SQL("Added Free and inclinedExercises");
SqlitePreferences.Update ("databaseVersion", "1.00", true);
Sqlite.Close();
currentVersion = "1.00";
}
if(currentVersion == "1.00") {
Sqlite.Open();
SqlitePreferences.Insert ("CSVExportDecimalSeparator", Util.GetDecimalSeparatorFromLocale());
LogB.SQL("Added export to CSV configuration on preferences");
SqlitePreferences.Update ("databaseVersion", "1.01", true);
Sqlite.Close();
currentVersion = "1.01";
}
if(currentVersion == "1.01") {
Sqlite.Open();
RunType type = new RunType("Agility-T-Test");
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
type = new RunType("Agility-3L3R");
SqliteRunIntervalType.Insert(type, Constants.RunIntervalTypeTable, true);
LogB.SQL("Added Agility Tests: Agility-T-Test, Agility-3l3R");
SqlitePreferences.Update ("databaseVersion", "1.02", true);
Sqlite.Close();
currentVersion = "1.02";
}
if(currentVersion == "1.02") {
Sqlite.Open();
DeleteFromName(true, Constants.EncoderExerciseTable, "Inclinated plane Custom");
SqliteEncoder.removeEncoderExerciseAngles();
LogB.SQL("Updated encoder exercise, angle is now on encoder configuration");
SqlitePreferences.Update ("databaseVersion", "1.03", true);
Sqlite.Close();
currentVersion = "1.03";
}
if(currentVersion == "1.03") {
Sqlite.Open();
ArrayList array = SqliteOldConvert.EncoderSelect103(true,-1,-1,-1,"all",false);
conversionRateTotal = array.Count;
dropTable(Constants.EncoderTable);
//CAUTION: do like this and never do createTableEncoder,
//because method will change in the future and will break updates
SqliteOldConvert.createTableEncoder104();
//in this conversion put this as default for all SQL rows
EncoderConfiguration econf = new EncoderConfiguration();
int count = 1;
foreach(EncoderSQL103 es in array) {
conversionRate = count;
//do not use SqliteEncoder.Insert because that method maybe changes in the future,
//and here we need to do a conversion that works from 1.03 to 1.04
dbcmd.CommandText = "INSERT INTO " + Constants.EncoderTable +
" (uniqueID, personID, sessionID, exerciseID, eccon, laterality, extraWeight, " +
"signalOrCurve, filename, url, time, minHeight, description, status, " +
"videoURL, encoderConfiguration, future1, future2, future3)" +
" VALUES (" + es.uniqueID + ", " +
es.personID + ", " + es.sessionID + ", " +
es.exerciseID + ", \"" + es.eccon + "\", \"" +
es.laterality + "\", \"" + es.extraWeight + "\", \"" +
es.signalOrCurve + "\", \"" + es.filename + "\", \"" +
es.url + "\", " + es.time + ", " + es.minHeight + ", \"" + es.description + "\", \"" +
es.status + "\", \"" + es.videoURL + "\", \"" +
econf.ToStringOutput(EncoderConfiguration.Outputs.SQL) + "\", \"" + //in this conversion put this as default for all SQL rows.
es.future1 + "\", \"" + es.future2 + "\", \"" + es.future3 + "\")";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
count ++;
}
conversionRate = count;
LogB.SQL("Encoder table improved");
SqlitePreferences.Update ("databaseVersion", "1.04", true);
Sqlite.Close();
currentVersion = "1.04";
}
if(currentVersion == "1.04") {
Sqlite.Open();
dbcmd.CommandText = "DELETE FROM " + Constants.EncoderTable +
" WHERE encoderConfiguration LIKE \"%INERTIAL%\" AND " +
" signalOrCurve == \"curve\"";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
LogB.SQL("Removed inertial curves, because sign was not checked on 1.04 when saving curves");
SqlitePreferences.Update ("databaseVersion", "1.05", true);
Sqlite.Close();
currentVersion = "1.05";
}
if(currentVersion == "1.05") {
Sqlite.Open();
SqliteEncoder.createTableEncoderSignalCurve();
ArrayList signals = SqliteEncoder.Select(true, -1, -1, -1, Constants.EncoderGI.ALL,
-1, "signal", EncoderSQL.Eccons.ALL, false, false);
ArrayList curves = SqliteEncoder.Select(true, -1, -1, -1, Constants.EncoderGI.ALL,
-1, "curve", EncoderSQL.Eccons.ALL, false, false);
int signalID;
conversionRateTotal = signals.Count;
conversionRate = 1;
//in 1.05 curves can be related to signals only by date
foreach(EncoderSQL s in signals) {
conversionRate ++;
conversionSubRateTotal = curves.Count;
conversionSubRate = 1;
//needed to know if there are duplicates
ArrayList curvesStored = new ArrayList();
foreach(EncoderSQL c in curves) {
conversionSubRate ++;
if(s.GetDate(false) == c.GetDate(false) && s.eccon == c.eccon) {
int msCentral = SqliteEncoder.FindCurveInSignal(
s.GetFullURL(false), c.GetFullURL(false));
signalID = Convert.ToInt32(s.uniqueID);
if(msCentral == -1)
signalID = -1; //mark as an orphaned curve (without signal)
/*
* about duplicated curves from 1.05 and before:
* There are two kind of duplicates, in both, eccon is the same, and they overlap.
*
* Overlapings situations:
* - they are saved two times (same msCentral), or
* - they are saved two times with different smoothing (different msCentral)
*
* from now on (1.06) there will be no more duplicates
* about the old duplicated curves, is the user problem,
* except the curves of the first kind, that we know exactly that they are duplicated
*/
//curves come sorted by UniqueID DESC (selected with orderIDascendent = false)
//if does not exist: insert in encoderSignalCurve
bool exists = false;
foreach(int ms in curvesStored)
if(ms == msCentral)
exists = true;
if(exists) {
//delete this (newer will not be deleted)
Sqlite.Delete(true,
Constants.EncoderTable, Convert.ToInt32(c.uniqueID));
} else {
curvesStored.Add(msCentral);
SqliteEncoder.SignalCurveInsert(true,
signalID, Convert.ToInt32(c.uniqueID), msCentral);
}
}
}
}
conversionSubRate ++;
conversionRate ++;
LogB.SQL("Curves are now linked to signals");
SqlitePreferences.Update ("databaseVersion", "1.06", true);
Sqlite.Close();
currentVersion = "1.06";
}
if(currentVersion == "1.06") {
Sqlite.Open();
Update(true, Constants.GraphLinkTable, "graphFileName", "jump_dj.png", "jump_dj_a.png",
"eventName", "DJa");
LogB.SQL("Added jump_dj_a.png");
SqlitePreferences.Update ("databaseVersion", "1.07", true);
Sqlite.Close();
currentVersion = "1.07";
}
if(currentVersion == "1.07") {
Sqlite.Open();
LogB.SQL("Added translate statistics graph option to preferences");
SqlitePreferences.Insert ("RGraphsTranslate", "True");
SqlitePreferences.Update ("databaseVersion", "1.08", true);
Sqlite.Close();
currentVersion = "1.08";
}
if(currentVersion == "1.08") {
Sqlite.Open();
LogB.SQL("Added option on preferences to useHeightsOnJumpIndexes (default) or not");
SqlitePreferences.Insert ("useHeightsOnJumpIndexes", "True");
SqlitePreferences.Update ("databaseVersion", "1.09", true);
Sqlite.Close();
currentVersion = "1.09";
}
if(currentVersion == "1.09") {
Sqlite.Open();
LogB.SQL("Added RSA RAST on runType");
/*
* addRSA() contains RAST since 1.10
* database started at 1.10 or more contains RAST
* database started before 0.87 adds RAST on the addRSA() method
* satabase started after 0.87 adds RAST now
*/
if(! addedRSA) {
RunType type = new RunType();
type.Name = "RSA RAST 35, R10 x 6";
type.Distance = -1;
type.TracksLimited = true;
type.FixedValue = 12;
type.Unlimited = false;
type.Description = "RSA RAST Test";
type.DistancesString = "35-R10";
SqliteRunIntervalType.Insert(type, Constants.RunIntervalTypeTable, true);
addedRSA = true;
}
SqlitePreferences.Update ("databaseVersion", "1.10", true);
Sqlite.Close();
currentVersion = "1.10";
}
if(currentVersion == "1.10") {
Sqlite.Open();
LogB.SQL("Added option on autosave curves on capture (all/bestmeanpower/none)");
SqlitePreferences.Insert ("encoderAutoSaveCurve", Constants.EncoderAutoSaveCurve.BEST.ToString());
SqlitePreferences.Update ("databaseVersion", "1.11", true);
Sqlite.Close();
currentVersion = "1.11";
}
if(currentVersion == "1.11") {
Sqlite.Open();
LogB.SQL("URLs from absolute to relative)");
SqliteOldConvert.ConvertAbsolutePathsToRelative();
SqlitePreferences.Update ("databaseVersion", "1.12", true);
Sqlite.Close();
currentVersion = "1.12";
}
if(currentVersion == "1.12") {
Sqlite.Open();
LogB.SQL("Added ExecuteAuto table");
SqliteExecuteAuto.createTableExecuteAuto();
SqlitePreferences.Update ("databaseVersion", "1.13", true);
Sqlite.Close();
currentVersion = "1.13";
}
if(currentVersion == "1.13") {
Sqlite.Open();
LogB.SQL("slCMJ -> slCMJleft, slCMJright");
SqliteOldConvert.slCMJDivide();
SqlitePreferences.Update ("databaseVersion", "1.14", true);
Sqlite.Close();
currentVersion = "1.14";
}
if(currentVersion == "1.14") {
Sqlite.Open();
LogB.SQL("added Chronojump profile and bilateral profile");
SqliteExecuteAuto.addChronojumpProfileAndBilateral();
SqlitePreferences.Update ("databaseVersion", "1.15", true);
Sqlite.Close();
currentVersion = "1.15";
}
if(currentVersion == "1.15") {
Sqlite.Open();
LogB.SQL("Cyprus moved to Europe");
Update(true, Constants.CountryTable, "continent", "Asia", "Europe", "code", "CYP");
SqlitePreferences.Update ("databaseVersion", "1.16", true);
Sqlite.Close();
currentVersion = "1.16";
}
if(currentVersion == "1.16") {
Sqlite.Open();
LogB.SQL("Deleting Max jump");
Update(true, Constants.JumpTable, "type", "Max", "Free", "", "");
DeleteFromName(true, Constants.JumpTypeTable, "Max");
SqlitePreferences.Update ("databaseVersion", "1.17", true);
Sqlite.Close();
currentVersion = "1.17";
}
if(currentVersion == "1.17") {
Sqlite.Open();
LogB.SQL("Deleted Negative runInterval runs (bug from last version)");
SqliteOldConvert.deleteNegativeRuns();
SqlitePreferences.Update ("databaseVersion", "1.18", true);
Sqlite.Close();
currentVersion = "1.18";
}
if(currentVersion == "1.18") {
LogB.SQL("Preferences deleted showHeight, added showStiffness");
Sqlite.Open();
DeleteFromName(true, Constants.PreferencesTable, "showHeight");
SqlitePreferences.Insert ("showStiffness", "True");
SqlitePreferences.Update ("databaseVersion", "1.19", true);
Sqlite.Close();
currentVersion = "1.19";
}
if(currentVersion == "1.19") {
LogB.SQL("Preferences: added user email");
Sqlite.Open();
SqlitePreferences.Insert ("email", "");
SqlitePreferences.Update ("databaseVersion", "1.20", true);
Sqlite.Close();
currentVersion = "1.20";
}
if(currentVersion == "1.20") {
LogB.SQL("Fixing loosing of encoder videoURL after recalculate");
Sqlite.Open();
SqliteOldConvert.ConvertAbsolutePathsToRelative(); //videoURLs got absolute again
SqliteOldConvert.FixLostVideoURLAfterEncoderRecalculate();
SqlitePreferences.Update ("databaseVersion", "1.21", true);
Sqlite.Close();
currentVersion = "1.21";
}
if(currentVersion == "1.21") {
LogB.SQL("Encoder laterality in english again");
Sqlite.Open();
if(Catalog.GetString("RL") != "RL")
Update(true, Constants.EncoderTable, "laterality", Catalog.GetString("RL"), "RL", "", "");
if(Catalog.GetString("R") != "R")
Update(true, Constants.EncoderTable, "laterality", Catalog.GetString("R"), "R", "", "");
if(Catalog.GetString("L") != "L")
Update(true, Constants.EncoderTable, "laterality", Catalog.GetString("L"), "L", "", "");
SqlitePreferences.Update ("databaseVersion", "1.22", true);
Sqlite.Close();
currentVersion = "1.22";
}
if(currentVersion == "1.22") {
LogB.SQL("Added encoder configuration");
Sqlite.Open();
SqlitePreferences.Insert ("encoderConfiguration", new EncoderConfiguration().ToStringOutput(EncoderConfiguration.Outputs.SQL));
SqlitePreferences.Update ("databaseVersion", "1.23", true);
Sqlite.Close();
currentVersion = "1.23";
}
// ----------------------------------------------
// IMPORTANT HERE IS DEFINED sqliteOpened == true
// this is useful to not do more than 50 SQL open close
// that crashes mac (Linux 100)
// ----------------------------------------------
LogB.SQL("Leaving Sqlite opened before DB updates");
Sqlite.Open(); //------------------------------------------------
if(currentVersion == "1.23") {
LogB.SQL("Delete runISpeedStartArrival and add 4 double contacts configs");
DeleteFromName(true, Constants.PreferencesTable, "runISpeedStartArrival");
SqlitePreferences.Insert ("runDoubleContactsMode", Constants.DoubleContact.LAST.ToString());
SqlitePreferences.Insert ("runDoubleContactsMS", "1000");
SqlitePreferences.Insert ("runIDoubleContactsMode", Constants.DoubleContact.AVERAGE.ToString());
SqlitePreferences.Insert ("runIDoubleContactsMS", "1000");
currentVersion = updateVersion("1.24");
}
if(currentVersion == "1.24") {
LogB.SQL("Language defaults to (empty string), means detected");
SqlitePreferences.Update("language", "", true);
currentVersion = updateVersion("1.25");
}
if(currentVersion == "1.25") {
LogB.SQL("Changed Inclinated to Inclined");
Update(true, Constants.EncoderExerciseTable, "name", "Inclinated plane", "Inclined plane", "", "");
Update(true, Constants.EncoderExerciseTable, "name", "Inclinated plane BW", "Inclined plane BW", "", "");
currentVersion = updateVersion("1.26");
}
if(currentVersion == "1.26") {
LogB.SQL("Changing runDoubleContactsMS and runIDoubleContactsMS from 1000ms to 300ms");
SqlitePreferences.Update("runDoubleContactsMS", "300", true);
SqlitePreferences.Update("runIDoubleContactsMS", "300", true);
currentVersion = updateVersion("1.27");
}
if(currentVersion == "1.27") {
LogB.SQL("Changed encoderAutoSaveCurve BESTMEANPOWER to BEST");
Update(true, Constants.PreferencesTable, "value", "BESTMEANPOWER", "BEST", "name", "encoderAutoSaveCurve");
currentVersion = updateVersion("1.28");
}
if(currentVersion == "1.28") {
LogB.SQL("Changed reaction time rows have reactionTime as default value");
Update(true, Constants.ReactionTimeTable, "type", "", "reactionTime", "", "");
currentVersion = updateVersion("1.29");
}
if(currentVersion == "1.29") {
LogB.SQL("Added SIMULATED session");
//add SIMULATED session if doesn't exists. Unique session where tests can be simulated.
SqliteSession.insertSimulatedSession();
currentVersion = updateVersion("1.30");
}
if(currentVersion == "1.30") {
LogB.SQL("Insert encoderCaptureCheckFullyExtended and ...Value at preferences");
SqlitePreferences.Insert ("encoderCaptureCheckFullyExtended", "True");
SqlitePreferences.Insert ("encoderCaptureCheckFullyExtendedValue", "4");
currentVersion = updateVersion("1.31");
}
if(currentVersion == "1.31") {
LogB.SQL("encoderCaptureOptionsWin -> preferences");
SqlitePreferences.Insert ("encoderCaptureTime", "60");
SqlitePreferences.Insert ("encoderCaptureInactivityEndTime", "3");
SqlitePreferences.Insert ("encoderCaptureMainVariable", Constants.EncoderVariablesCapture.MeanPower.ToString());
SqlitePreferences.Insert ("encoderCaptureMinHeightGravitatory", "20");
SqlitePreferences.Insert ("encoderCaptureMinHeightInertial", "5");
SqlitePreferences.Insert ("encoderShowStartAndDuration", "False");
currentVersion = updateVersion("1.32");
}
if(currentVersion == "1.32") {
LogB.SQL("Added chronopicRegister table");
SqliteChronopicRegister.createTableChronopicRegister();
currentVersion = updateVersion("1.33");
}
if(currentVersion == "1.33") {
LogB.SQL("Added thresholdJumps, thresholdRuns, thresholdOther to preferences");
SqlitePreferences.Insert ("thresholdJumps", "50");
SqlitePreferences.Insert ("thresholdRuns", "10");
SqlitePreferences.Insert ("thresholdOther", "50");
currentVersion = updateVersion("1.34");
}
// --- add more updates here
// --- end of update, close DB
LogB.SQL("Closing Sqlite after DB updates");
Sqlite.Close(); //------------------------------------------------
}
//if changes are made here, remember to change also in CreateTables()
//remember to change also the databaseVersion below
return returnSoftwareIsNew;
}
public static void CreateTables(bool server)
{
Sqlite.Open();
creationTotal = 14;
creationRate = 1;
SqliteServer sqliteServerObject = new SqliteServer();
//user has also an evaluator table with a row (it's row)
sqliteServerObject.CreateEvaluatorTable();
if(server) {
sqliteServerObject.CreatePingTable();
SqliteServerSession sqliteSessionObject = new SqliteServerSession();
sqliteSessionObject.createTable(Constants.SessionTable);
} else {
SqliteSession sqliteSessionObject = new SqliteSession();
sqliteSessionObject.createTable(Constants.SessionTable);
//add SIMULATED session if doesn't exists. Unique session where tests can be simulated.
SqliteSession.insertSimulatedSession();
SqlitePersonSessionNotUpload.CreateTable();
creationRate ++;
}
SqlitePerson sqlitePersonObject = new SqlitePerson();
sqlitePersonObject.createTable(Constants.PersonTable);
//graphLinkTable
SqliteEvent.createGraphLinkTable();
creationRate ++;
//jumps
SqliteJump sqliteJumpObject = new SqliteJump();
SqliteJumpRj sqliteJumpRjObject = new SqliteJumpRj();
sqliteJumpObject.createTable(Constants.JumpTable);
sqliteJumpRjObject.createTable(Constants.JumpRjTable);
sqliteJumpRjObject.createTable(Constants.TempJumpRjTable);
//jump Types
creationRate ++;
SqliteJumpType.createTableJumpType();
SqliteJumpType.createTableJumpRjType();
SqliteJumpType.initializeTableJumpType();
SqliteJumpType.initializeTableJumpRjType();
//runs
creationRate ++;
SqliteRun sqliteRunObject = new SqliteRun();
SqliteRunInterval sqliteRunIntervalObject = new SqliteRunInterval();
sqliteRunObject.createTable(Constants.RunTable);
sqliteRunIntervalObject.createTable(Constants.RunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
//run Types
creationRate ++;
SqliteRunType sqliteRunTypeObject = new SqliteRunType();
sqliteRunTypeObject.createTable(Constants.RunTypeTable);
SqliteRunType.initializeTable();
SqliteRunIntervalType sqliteRunIntervalTypeObject = new SqliteRunIntervalType();
sqliteRunIntervalTypeObject.createTable(Constants.RunIntervalTypeTable);
SqliteRunIntervalType.initializeTable();
//reactionTimes
creationRate ++;
SqliteReactionTime sqliteReactionTimeObject = new SqliteReactionTime();
sqliteReactionTimeObject.createTable(Constants.ReactionTimeTable);
//pulses and pulseTypes
creationRate ++;
SqlitePulse sqlitePulseObject = new SqlitePulse();
sqlitePulseObject.createTable(Constants.PulseTable);
SqlitePulseType.createTablePulseType();
SqlitePulseType.initializeTablePulseType();
//multiChronopic tests
creationRate ++;
SqliteMultiChronopic sqliteMultiChronopicObject = new SqliteMultiChronopic();
sqliteMultiChronopicObject.createTable(Constants.MultiChronopicTable);
//encoder
creationRate ++;
SqliteEncoder.createTableEncoder();
SqliteEncoder.createTableEncoderSignalCurve();
SqliteEncoder.createTableEncoderExercise();
SqliteEncoder.initializeTableEncoderExercise();
SqliteEncoder.createTable1RM();
//sports
creationRate ++;
SqliteSport.createTable();
SqliteSport.initialize();
SqliteSpeciallity.createTable();
SqliteSpeciallity.initialize();
SqliteSpeciallity.InsertUndefined(true);
creationRate ++;
SqlitePersonSession sqlitePersonSessionObject = new SqlitePersonSession();
sqlitePersonSessionObject.createTable(Constants.PersonSessionTable);
creationRate ++;
SqlitePreferences.createTable();
SqlitePreferences.initializeTable(lastChronojumpDatabaseVersion, creatingBlankDatabase);
creationRate ++;
SqliteCountry.createTable();
SqliteCountry.initialize();
SqliteExecuteAuto.createTableExecuteAuto();
SqliteExecuteAuto.addChronojumpProfileAndBilateral();
SqliteChronopicRegister.createTableChronopicRegister();
//changes [from - to - desc]
//1.33 - 1.34 Converted DB to 1.34 Added thresholdJumps, thresholdRuns, thresholdOther to preferences
//1.32 - 1.33 Converted DB to 1.33 Added chronopicRegister table
//1.31 - 1.32 Converted DB to 1.32 encoderCaptureOptionsWin -> preferences
//1.30 - 1.31 Converted DB to 1.31 Insert encoderCaptureCheckFullyExtended and ...Value at preferences
//1.29 - 1.30 Converted DB to 1.30 Added SIMULATED session
//1.28 - 1.29 Converted DB to 1.29 Changed reaction time rows have reactionTime as default value
//1.27 - 1.28 Converted DB to 1.28 Changed encoderAutoSaveCurve BESTMEANPOWER to BEST
//1.26 - 1.27 Converted DB to 1.27 Changing runDoubleContactsMS and runIDoubleContactsMS from 1000ms to 300ms
//1.25 - 1.26 Converted DB to 1.26 Changed Inclinated to Inclined
//1.24 - 1.25 Converted DB to 1.25 Language defaults to (empty string), means detected
//1.23 - 1.24 Converted DB to 1.24 Delete runISpeedStartArrival and add 4 double contacts configs
//1.22 - 1.23 Converted DB to 1.23 Added encoder configuration
//1.21 - 1.22 Converted DB to 1.22 Encoder laterality in english again
//1.20 - 1.21 Converted DB to 1.21 Fixing loosing of encoder videoURL after recalculate
//1.19 - 1.20 Converted DB to 1.20 Preferences: added user email
//1.18 - 1.19 Converted DB to 1.19 Preferences deleted showHeight, added showStiffness
//1.17 - 1.18 Converted DB to 1.18 deleted Negative runInterval runs (bug from last version)
//1.16 - 1.17 Converted DB to 1.17 Deleted Max jump (we already have "Free")
//1.15 - 1.16 Converted DB to 1.16 Cyprus moved to Europe
//1.14 - 1.15 Converted DB to 1.15 added Chronojump profile and bilateral profile
//1.13 - 1.14 Converted DB to 1.14 slCMJ -> slCMJleft, slCMJright
//1.12 - 1.13 Converted DB to 1.13 Added ExecuteAuto table
//1.11 - 1.12 Converted DB to 1.12 URLs from absolute to relative
//1.10 - 1.11 Converted DB to 1.11 Added option on autosave curves on capture (all/bestmeanpower/none)
//1.09 - 1.10 Converted DB to 1.10 Added RSA RAST on runType
//1.08 - 1.09 Converted DB to 1.09 Added option on preferences to useHeightsOnJumpIndexes (default) or not
//1.07 - 1.08 Converted DB to 1.08 Added translate statistics graph option to preferences
//1.06 - 1.07 Converted DB to 1.07 Added jump_dj_a.png
//1.05 - 1.06 Converted DB to 1.06 Curves are now linked to signals
//1.04 - 1.05 Converted DB to 1.05 Removed inertial curves, because sign was not checked on 1.04 when saving curves
//1.03 - 1.04 Converted DB to 1.04 Encoder table improved
//1.02 - 1.03 Converted DB to 1.03 Updated encoder exercise, angle is now on encoder configuration
//1.01 - 1.02 Converted DB to 1.02 Added Agility Tests: Agility-T-Test, Agility-3L3R
//1.00 - 1.01 Converted DB to 1.01 Added export to CSV configuration on preferences
//0.99 - 1.00 Converted DB to 1.00 Encoder added Free and Inclined Exercises
//0.98 - 0.99 Converted DB to 0.99 Encoder table improved
//0.97 - 0.98 Converted DB to 0.98 Fixed encoder laterality
//0.96 - 0.97 Converted DB to 0.97 Added inertialmomentum in preferences
//0.95 - 0.96 Converted DB to 0.96 Encoder signal future3 three modes
//0.94 - 0.95 Converted DB to 0.95 Added encoder1RMMethod
//0.93 - 0.94 Converted DB to 0.94 Added encoder1RM table
//0.92 - 0.93 Converted DB to 0.93 Added speed1RM on encoder exercise
//0.91 - 0.92 Converted DB to 0.92 Added videoDevice to preferences
//0.90 - 0.91 Converted DB to 0.91 Encoder Squat 75% -> 100%
//0.89 - 0.90 Converted DB to 0.90 Preferences added propulsive and encoder smooth
//0.88 - 0.89 Converted DB to 0.89 Added encoder exercise: Free
//0.87 - 0.88 Converted DB to 0.88 Deleted fake RSA test and added known RSA tests
//0.86 - 0.87 Converted DB to 0.87 Added run speed start preferences on sqlite
//0.85 - 0.86 Converted DB to 0.86 videoOn: TRUE
//0.84 - 0.85 Converted DB to 0.85 Added slCMJ jump
//0.83 - 0.84 Converted DB to 0.84 Added first RSA test
//0.82 - 0.83 Converted DB to 0.83 Created encoder table
//0.81 - 0.82 Converted DB to 0.82 Added videoOn
//0.80 - 0.81 Converted DB to 0.81 Added tempRunInterval initial speed
//0.79 - 0.80 Converted DB to 0.80 Added run and runInterval initial speed (if not done in 0.56 conversion)
//0.78 - 0.79 Converted DB to 0.79 (Added multimediaStorage structure id)
//0.77 - 0.78 Converted DB to 0.78 (Added machineID to preferences, takeOffWeight has no weight in db conversions since 0.66)
//0.76 - 0.77 Converted DB to 0.77 (person77, personSession77)
//0.75 - 0.76 Converted DB to 0.76 (jump & jumpRj falls as double)
//0.74 - 0.75 Converted DB to 0.75 (person, and personSessionWeight have height and weight as double)
//0.73 - 0.74 Converted DB to 0.74 (All DJ converted to DJna)
//0.72 - 0.73 Converted DB to 0.73 (deleted orphaned persons (in person table but not in personSessionWeight table))
//0.71 - 0.72 dates to YYYY-MM-DD
//0.70 - 0.71 created personNotUploadTable on client
//0.69 - 0.70 added showPower to preferences
//0.68 - 0.69 added Gesell-DBT test
//0.67 - 0.68 added multiChronopic tests table
//0.66 - 0.67 added TakeOff jumps
//0.65 - 0.66 added done nothing
//0.64 - 0.65 added Sevaluator on client
//0.63 - 0.64 added margaria test
//0.62 - 0.63 added 'versionAvailable' to preferences
//0.61 - 0.62 added hexagon (jumpRj test)
//0.60 - 0.61 added RunIntervalType distancesString (now we van have interval tests with different distances of tracks). Added MTGUG
//0.59 - 0.60 added volumeOn and evaluatorServerID to preferences. Session has now serverUniqueID. Simulated now are -1, because 0 is real and positive is serverUniqueID
//0.58 - 0.59 Added 'showAngle' to preferences, changed angle on jump to double
//0.57 - 0.58 Countries without kingdom or republic (except when needed)
//0.56 - 0.57 Added simulated column to each event table on client. person: race, country, serverID. Convert to sport related done here if needed. Added also run and runInterval initial speed);
//0.55 - 0.56 Added session default sport stuff into session table
//0.54 - 0.55 Added undefined to speciallity table
//0.53 - 0.54 created sport tables. Added sport data, speciallity and level of practice to person table
//0.52 - 0.53 added table weightSession, moved person weight data to weightSession table for each session that has performed
//0.51 - 0.52 added graphLinks for cmj_l and abk_l. Fixed CMJ_l name
//0.50 - 0.51 added graphLinks for run simple and interval
//0.49 - 0.50: changed SJ+ to SJl, same for CMJ+ and ABK+, added jump and jumpRj graph links
//0.48 - 0.49: added graphLinkTable, added rocket jump and 5 agility tests: (20Yard, 505, Illinois, Shuttle-Run & ZigZag). Added graphs pof the 5 agility tests
//0.47 - 0.48: added tempJumpReactive and tempRunInterval tables
//0.46 - 0.47: added reactionTime table
//0.45 - 0.46: added "Free" jump type
//0.44 - 0.45: added allowFinishRjAfterTime
//0.43 - 0.44: added showQIndex and showDjIndex
//0.42 - 0.43: added 'free' pulseType & language preference
//0.41 - 0.42: added pulse and pulseType tables
//0.4 - 0.41: jump, jumpRj weight is double (always a percent)
Sqlite.Close();
creationRate ++;
}
private static void on_server_upload_session_started()
{
int evalSID = Convert.ToInt32(SqlitePreferences.Select("evaluatorServerID"));
try {
ChronojumpServer myServer = new ChronojumpServer();
LogB.Information(myServer.ConnectDatabase());
int state = (int)Constants.ServerSessionStates.UPLOADINGSESSION;
//create ServerSession based on Session currentSession
ServerSession serverSession = new ServerSession(currentSession, evalSID, progName + " " + progVersion,
UtilAll.GetOS(), DateTime.Now, state);
//if uploading session for first time
if (currentSession.ServerUniqueID == Constants.ServerUndefinedID)
{
//upload ServerSession
int idAtServer = myServer.UploadSession(serverSession);
//update session currentSession (serverUniqueID) on client database
currentSession.ServerUniqueID = idAtServer;
SqliteSession.UpdateServerUniqueID(currentSession.UniqueID, currentSession.ServerUniqueID);
}
state = (int)Constants.ServerSessionStates.UPLOADINGDATA;
myServer.UpdateSession(currentSession.ServerUniqueID, state);
sessionUploadPersonData.testTypes = "";
string testTypesSeparator = "";
sessionUploadPersonData.sports = "";
string sportsSeparator = "";
//upload persons (updating also person.serverUniqueID locally)
ArrayList persons = SqlitePersonSession.SelectCurrentSessionPersons(
serverSession.UniqueID,
false); //means: do not returnPersonAndPSlist
Constants.UploadCodes uCode;
ArrayList notToUpload = SqlitePersonSessionNotUpload.SelectAll(currentSession.UniqueID);
//store in variable for updating progressBar from other thread
progressBarPersonsNum = persons.Count - notToUpload.Count;
foreach (Person p in persons)
{
Person person = p;
//do not continue with this person if has been banned to upload
if (Util.FoundInArrayList(notToUpload, person.UniqueID.ToString()))
{
continue;
}
PersonSession ps = SqlitePersonSession.Select(person.UniqueID, currentSession.UniqueID);
//check person if exists
if (person.ServerUniqueID != Constants.ServerUndefinedID)
{
uCode = Constants.UploadCodes.EXISTS;
}
else
{
uCode = Constants.UploadCodes.OK;
person = serverUploadPerson(myServer, person, serverSession.UniqueID);
}
//if sport is user defined, upload it
//and when upload the person, do it with new sportID
Sport sport = SqliteSport.Select(false, ps.SportID);
//but record old sport ID because locally will be a change in serverUniqueID
//(with slite update)
//but local sport has not to be changed
int sportUserDefinedLocal = -1;
if (sport.UserDefined)
{
sportUserDefinedLocal = sport.UniqueID;
//this will be uploaded
int newSport = myServer.UploadSport(sport);
if (newSport != -1)
{
ps.SportID = newSport;
sessionUploadPersonData.sports += sportsSeparator + sport.Name;
sportsSeparator = ", ";
}
}
//a person can be in the database for one session,
//but maybe now we add jumps from another session and we should add an entry at personsession
serverUploadPersonSessionIfNeeded(myServer, person.ServerUniqueID,
currentSession.ServerUniqueID, ps, sportUserDefinedLocal);
//other thread updates the gui:
sessionUploadPersonData.person = person;
sessionUploadPersonData.personCode = uCode;
//upload jumps
int countU = 0;
int countE = 0;
int countS = 0;
string [] jumps = SqliteJump.SelectJumps(false, currentSession.UniqueID, person.UniqueID, "", "",
Sqlite.Orders_by.DEFAULT, -1);
Sqlite.Open();
foreach (string myJump in jumps)
{
string [] js = myJump.Split(new char[] { ':' });
//select jump
Jump test = SqliteJump.SelectJumpData(Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
//if test is not simulated and has not been uploaded,
//see if it's type is not predefined and is not in the database
//then upload it first
if (test.Simulated == 0)
{
//upload jumpType if is user defined and doesn't exists in server database
//JumpType type = new JumpType(test.Type);
JumpType type = SqliteJumpType.SelectAndReturnJumpType(test.Type, true);
if (!type.IsPredefined)
{
//Console.WriteLine("USER DEFINED TEST: " + test.Type);
//
//this uploads the new type, as it's user created, it will be like this
//eg: for user defined jumpType: "supra" of evaluatorServerID: 9
//at server will be "supra-9"
//then two problems get solved:
//1.- every evaluator that uploads a type will have a different name
//than other evaluator uploading a type that is named the same but could be different
//(one can think that "supra" is another thing
//2- when the same evaluator upload some supra's, only a new type is created
//test.Type = myServer.UploadJumpType(type, evalSID);
//int testType = (int) Constants.TestTypes.JUMP;
//string insertedType = myServer.UploadTestType(Constants.TestTypes.JUMP, type, evalSID);
//string insertedType = myServer.UploadTestType(testType, type, evalSID);
string insertedType = myServer.UploadJumpType(type, evalSID);
if (insertedType != "-1")
{
//record type in test (with the "-7" if it's done by evaluator 7)
test.Type = insertedType;
//show user uploaded type (without the "-7")
sessionUploadPersonData.testTypes += testTypesSeparator + type.Name;
testTypesSeparator = ", ";
}
//test.Type in the server will have the correct name "supra-9"
}
}
//upload... (if not because of simulated or uploaded before, report also the user)
uCode = serverUploadTest(myServer, Constants.TestTypes.JUMP, Constants.JumpTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.jumpsU = countU;
sessionUploadPersonData.jumpsE = countE;
sessionUploadPersonData.jumpsS = countS;
//upload jumpsRj
countU = 0;
countE = 0;
countS = 0;
string [] jumpsRj = SqliteJumpRj.SelectJumps(false, currentSession.UniqueID, person.UniqueID, "", "");
Sqlite.Open();
foreach (string myJump in jumpsRj)
{
string [] js = myJump.Split(new char[] { ':' });
//select jump
JumpRj test = SqliteJumpRj.SelectJumpData(Constants.JumpRjTable, Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
if (test.Simulated == 0)
{
JumpType type = SqliteJumpType.SelectAndReturnJumpRjType(test.Type, true);
if (!type.IsPredefined)
{
string insertedType = myServer.UploadJumpRjType(type, evalSID);
if (insertedType != "-1")
{
test.Type = insertedType;
sessionUploadPersonData.testTypes += testTypesSeparator + type.Name;
testTypesSeparator = ", ";
}
}
}
//upload...
uCode = serverUploadTest(myServer, Constants.TestTypes.JUMP_RJ, Constants.JumpRjTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.jumpsRjU = countU;
sessionUploadPersonData.jumpsRjE = countE;
sessionUploadPersonData.jumpsRjS = countS;
//upload runs
countU = 0;
countE = 0;
countS = 0;
string [] runs = SqliteRun.SelectRuns(false, currentSession.UniqueID, person.UniqueID, "",
Sqlite.Orders_by.DEFAULT, -1);
Sqlite.Open();
foreach (string myRun in runs)
{
string [] js = myRun.Split(new char[] { ':' });
//select run
Run test = SqliteRun.SelectRunData(Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
if (test.Simulated == 0)
{
RunType type = SqliteRunType.SelectAndReturnRunType(test.Type, true);
if (!type.IsPredefined)
{
string insertedType = myServer.UploadRunType(type, evalSID);
if (insertedType != "-1")
{
test.Type = insertedType;
sessionUploadPersonData.testTypes += testTypesSeparator + type.Name;
testTypesSeparator = ", ";
}
}
}
//upload...
uCode = serverUploadTest(myServer, Constants.TestTypes.RUN, Constants.RunTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.runsU = countU;
sessionUploadPersonData.runsE = countE;
sessionUploadPersonData.runsS = countS;
//upload runs intervallic
countU = 0;
countE = 0;
countS = 0;
string [] runsI = SqliteRunInterval.SelectRuns(false, currentSession.UniqueID, person.UniqueID, "");
Sqlite.Open();
foreach (string myRun in runsI)
{
string [] js = myRun.Split(new char[] { ':' });
//select run
RunInterval test = SqliteRunInterval.SelectRunData(Constants.RunIntervalTable, Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
if (test.Simulated == 0)
{
RunType type = SqliteRunIntervalType.SelectAndReturnRunIntervalType(test.Type, true);
if (!type.IsPredefined)
{
string insertedType = myServer.UploadRunIntervalType(type, evalSID);
if (insertedType != "-1")
{
test.Type = insertedType;
sessionUploadPersonData.testTypes += testTypesSeparator + type.Name;
testTypesSeparator = ", ";
}
}
}
//upload...
uCode = serverUploadTest(myServer, Constants.TestTypes.RUN_I, Constants.RunIntervalTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.runsIU = countU;
sessionUploadPersonData.runsIE = countE;
sessionUploadPersonData.runsIS = countS;
//upload reaction times
countU = 0;
countE = 0;
countS = 0;
string [] rts = SqliteReactionTime.SelectReactionTimes(false, currentSession.UniqueID, person.UniqueID,
Sqlite.Orders_by.DEFAULT, -1);
Sqlite.Open();
foreach (string myRt in rts)
{
string [] js = myRt.Split(new char[] { ':' });
//select rt
ReactionTime test = SqliteReactionTime.SelectReactionTimeData(Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
//upload...
uCode = serverUploadTest(myServer, Constants.TestTypes.RT, Constants.ReactionTimeTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.rtsU = countU;
sessionUploadPersonData.rtsE = countE;
sessionUploadPersonData.rtsS = countS;
//upload pulses
countU = 0;
countE = 0;
countS = 0;
string [] pulses = SqlitePulse.SelectPulses(false, currentSession.UniqueID, person.UniqueID);
Sqlite.Open();
foreach (string myPulse in pulses)
{
string [] js = myPulse.Split(new char[] { ':' });
//select pulse
Pulse test = SqlitePulse.SelectPulseData(Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
//upload...
uCode = serverUploadTest(myServer, Constants.TestTypes.PULSE, Constants.PulseTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.pulsesU = countU;
sessionUploadPersonData.pulsesE = countE;
sessionUploadPersonData.pulsesS = countS;
//upload multiChronopic
countU = 0;
countE = 0;
countS = 0;
string [] mcs = SqliteMultiChronopic.SelectTests(false, currentSession.UniqueID, person.UniqueID);
Sqlite.Open();
foreach (string mc in mcs)
{
string [] js = mc.Split(new char[] { ':' });
//select mc
MultiChronopic test = SqliteMultiChronopic.SelectMultiChronopicData(Convert.ToInt32(js[1]), true); //uniqueID
//fix it to server person, session keys
test.PersonID = person.ServerUniqueID;
test.SessionID = currentSession.ServerUniqueID;
//upload...
uCode = serverUploadTest(myServer, Constants.TestTypes.MULTICHRONOPIC, Constants.MultiChronopicTable, test);
if (uCode == Constants.UploadCodes.OK)
{
countU++;
}
else if (uCode == Constants.UploadCodes.EXISTS)
{
countE++;
}
else //SIMULATED
{
countS++;
}
}
Sqlite.Close();
//other thread updates the gui:
sessionUploadPersonData.mcsU = countU;
sessionUploadPersonData.mcsE = countE;
sessionUploadPersonData.mcsS = countS;
needUpdateServerSession = true;
while (needUpdateServerSession)
{
//wait until data is printed on the other thread
}
}
state = (int)Constants.ServerSessionStates.DONE;
//myServer.UpdateSession(currentSession.ServerUniqueID, (ServerSessionStates) Constants.ServerSessionStates.DONE);
myServer.UpdateSession(currentSession.ServerUniqueID, state);
LogB.Information(myServer.DisConnectDatabase());
} catch {
//other thread updates the gui:
serverSessionError = true;
}
}
public static bool ConvertToLastChronojumpDBVersion()
{
//if(checkIfIsSqlite2())
// convertSqlite2To3();
addChronopicPortNameIfNotExists();
currentVersion = SqlitePreferences.Select("databaseVersion");
//Log.WriteLine("lastDB: {0}", Convert.ToDouble(lastChronojumpDatabaseVersion));
//Log.WriteLine("currentVersion: {0}", Convert.ToDouble(currentVersion));
bool returnSoftwareIsNew = true; //-1 if software is too old for database (moved db to other computer)
if(
Convert.ToDouble(Util.ChangeDecimalSeparator(lastChronojumpDatabaseVersion)) ==
Convert.ToDouble(Util.ChangeDecimalSeparator(currentVersion)))
Log.WriteLine("Database is already latest version");
else if(
Convert.ToDouble(Util.ChangeDecimalSeparator(lastChronojumpDatabaseVersion)) <
Convert.ToDouble(Util.ChangeDecimalSeparator(currentVersion))) {
Log.WriteLine("User database newer than program, need to update software");
returnSoftwareIsNew = false;
} else {
Log.WriteLine("Old database, need to convert");
Log.WriteLine("db version: " + currentVersion);
bool needToConvertPersonToSport = false;
bool jumpFallAsDouble = false;
bool runAndRunIntervalInitialSpeedAdded = false;
SqliteJumpRj sqliteJumpRjObject = new SqliteJumpRj();
SqliteRunInterval sqliteRunIntervalObject = new SqliteRunInterval();
SqliteReactionTime sqliteReactionTimeObject = new SqliteReactionTime();
SqlitePulse sqlitePulseObject = new SqlitePulse();
SqliteMultiChronopic sqliteMultiChronopicObject = new SqliteMultiChronopic();
SqlitePersonSessionOld sqlitePersonSessionOldObject = new SqlitePersonSessionOld();
if(currentVersion == "0.41") {
dbcon.Open();
//SqlitePulse.createTable(Constants.PulseTable);
sqlitePulseObject.createTable(Constants.PulseTable);
SqlitePulseType.createTablePulseType();
SqlitePulseType.initializeTablePulseType();
SqlitePreferences.Update ("databaseVersion", "0.42", true);
Log.WriteLine("Converted DB to 0.42 (added pulse and pulseType tables)");
dbcon.Close();
currentVersion = "0.42";
}
if(currentVersion == "0.42") {
dbcon.Open();
SqlitePulseType.Insert ("Free:-1:-1:free PulseStep mode", true);
SqlitePreferences.Insert ("language", "es-ES");
SqlitePreferences.Update ("databaseVersion", "0.43", true);
Log.WriteLine("Converted DB to 0.43 (added 'free' pulseType & language peference)");
dbcon.Close();
currentVersion = "0.43";
}
if(currentVersion == "0.43") {
dbcon.Open();
SqlitePreferences.Insert ("showQIndex", "False");
SqlitePreferences.Insert ("showDjIndex", "False");
SqlitePreferences.Update ("databaseVersion", "0.44", true);
Log.WriteLine("Converted DB to 0.44 (added showQIndex, showDjIndex)");
dbcon.Close();
currentVersion = "0.44";
}
if(currentVersion == "0.44") {
dbcon.Open();
SqlitePreferences.Insert ("allowFinishRjAfterTime", "True");
SqlitePreferences.Update ("databaseVersion", "0.45", true);
Log.WriteLine("Converted DB to 0.45 (added allowFinishRjAfterTime)");
dbcon.Close();
currentVersion = "0.45";
}
if(currentVersion == "0.45") {
dbcon.Open();
SqliteJumpType.JumpTypeInsert ("Free:1:0:Free jump", true);
SqlitePreferences.Update ("databaseVersion", "0.46", true);
Log.WriteLine("Added Free jump type");
dbcon.Close();
currentVersion = "0.46";
}
if(currentVersion == "0.46") {
dbcon.Open();
//SqliteReactionTime.createTable(Constants.ReactionTimeTable);
sqliteReactionTimeObject.createTable(Constants.ReactionTimeTable);
SqlitePreferences.Update ("databaseVersion", "0.47", true);
Log.WriteLine("Added reaction time table");
dbcon.Close();
currentVersion = "0.47";
}
if(currentVersion == "0.47") {
dbcon.Open();
//SqliteJumpRj.createTable(Constants.TempJumpRjTable);
sqliteJumpRjObject.createTable(Constants.TempJumpRjTable);
//SqliteRun.intervalCreateTable(Constants.TempRunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
SqlitePreferences.Update ("databaseVersion", "0.48", true);
Log.WriteLine("created tempJumpReactive and tempRunInterval tables");
dbcon.Close();
currentVersion = "0.48";
}
if(currentVersion == "0.48") {
dbcon.Open();
SqliteJumpType.JumpTypeInsert ("Rocket:1:0:Rocket jump", true);
string [] iniRunTypes = {
"Agility-20Yard:18.28:20Yard Agility test",
"Agility-505:10:505 Agility test",
"Agility-Illinois:60:Illinois Agility test",
"Agility-Shuttle-Run:40:Shuttle Run Agility test",
"Agility-ZigZag:17.6:ZigZag Agility test"
};
foreach(string myString in iniRunTypes) {
string [] s = myString.Split(new char[] {':'});
RunType type = new RunType();
type.Name = s[0];
type.Distance = Convert.ToDouble(s[1]);
type.Description = s[2];
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
}
SqliteEvent.createGraphLinkTable();
SqliteRunType.AddGraphLinksRunSimpleAgility();
SqlitePreferences.Update ("databaseVersion", "0.49", true);
Log.WriteLine("Added graphLinkTable, added Rocket jump and 5 agility tests: (20Yard, 505, Illinois, Shuttle-Run & ZigZag. Added graphs pof the 5 agility tests)");
dbcon.Close();
currentVersion = "0.49";
}
if(currentVersion == "0.49") {
dbcon.Open();
SqliteJumpType.Update ("SJ+", "SJl");
SqliteJumpType.Update ("CMJ+", "CJl");
SqliteJumpType.Update ("ABK+", "ABKl");
SqliteJump.ChangeWeightToL();
SqliteJumpType.AddGraphLinks();
SqliteJumpType.AddGraphLinksRj();
SqlitePreferences.Update ("databaseVersion", "0.50", true);
Log.WriteLine("changed SJ+ to SJl, same for CMJ+ and ABK+, added jump and jumpRj graph links");
dbcon.Close();
currentVersion = "0.50";
}
if(currentVersion == "0.50") {
dbcon.Open();
SqliteRunType.AddGraphLinksRunSimple();
SqliteRunIntervalType.AddGraphLinksRunInterval();
SqlitePreferences.Update ("databaseVersion", "0.51", true);
Log.WriteLine("added graphLinks for run simple and interval");
dbcon.Close();
currentVersion = "0.51";
}
if(currentVersion == "0.51") {
dbcon.Open();
SqliteJumpType.Update ("CJl", "CMJl");
SqliteEvent.GraphLinkInsert (Constants.JumpTable, "CMJl", "jump_cmj_l.png", true);
SqliteEvent.GraphLinkInsert (Constants.JumpTable, "ABKl", "jump_abk_l.png", true);
SqlitePreferences.Update ("databaseVersion", "0.52", true);
Log.WriteLine("added graphLinks for cmj_l and abk_l, fixed CMJl name");
dbcon.Close();
currentVersion = "0.52";
}
if(currentVersion == "0.52") {
dbcon.Open();
sqlitePersonSessionOldObject.createTable ();
dbcon.Close();
//this needs the dbCon closed
SqlitePersonSessionOld.moveOldTableToNewTable ();
dbcon.Open();
SqlitePreferences.Update ("databaseVersion", "0.53", true);
dbcon.Close();
Log.WriteLine("created weightSession table. Moved person weight data to weightSession table for each session that has performed");
currentVersion = "0.53";
}
if(currentVersion == "0.53") {
dbcon.Open();
SqliteSport.createTable();
SqliteSport.initialize();
SqliteSpeciallity.createTable();
SqliteSpeciallity.initialize();
//SqlitePersonOld.convertTableToSportRelated ();
needToConvertPersonToSport = true;
SqlitePreferences.Update ("databaseVersion", "0.54", true);
dbcon.Close();
Log.WriteLine("Created sport tables. Added sport data, speciallity and level of practice to person table");
currentVersion = "0.54";
}
if(currentVersion == "0.54") {
dbcon.Open();
SqliteSpeciallity.InsertUndefined(true);
SqlitePreferences.Update ("databaseVersion", "0.55", true);
dbcon.Close();
Log.WriteLine("Added undefined to speciallity table");
currentVersion = "0.55";
}
if(currentVersion == "0.55") {
dbcon.Open();
SqliteSessionOld.convertTableAddingSportStuff();
SqlitePreferences.Update ("databaseVersion", "0.56", true);
dbcon.Close();
Log.WriteLine("Added session default sport stuff into session table");
currentVersion = "0.56";
}
if(currentVersion == "0.56") {
dbcon.Open();
//jump and jumpRj
ArrayList arrayAngleAndSimulated = new ArrayList(1);
arrayAngleAndSimulated.Add("-1"); //angle
arrayAngleAndSimulated.Add("-1"); //simulated
//run and runInterval
ArrayList arraySimulatedAndInitialSpeed = new ArrayList(1);
arraySimulatedAndInitialSpeed.Add("-1"); //simulated
arraySimulatedAndInitialSpeed.Add("0"); //initial speed
//others
ArrayList arraySimulated = new ArrayList(1);
arraySimulated.Add("-1"); //simulated
conversionRateTotal = 9;
conversionRate = 1;
convertTables(new SqliteJump(), Constants.JumpTable, 9, arrayAngleAndSimulated, false);
conversionRate ++;
convertTables(new SqliteJumpRj(), Constants.JumpRjTable, 16, arrayAngleAndSimulated, false);
conversionRate ++;
convertTables(new SqliteRun(), Constants.RunTable, 7, arraySimulated, false);
conversionRate ++;
convertTables(new SqliteRunInterval(), Constants.RunIntervalTable, 11, arraySimulated, false);
runAndRunIntervalInitialSpeedAdded = true;
conversionRate ++;
convertTables(new SqliteReactionTime(), Constants.ReactionTimeTable, 6, arraySimulated, false);
conversionRate ++;
convertTables(new SqlitePulse(), Constants.PulseTable, 8, arraySimulated, false);
//reacreate temp tables for have also the simulated column
conversionRate ++;
Sqlite.dropTable(Constants.TempJumpRjTable);
sqliteJumpRjObject.createTable(Constants.TempJumpRjTable);
Sqlite.dropTable(Constants.TempRunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
conversionRate ++;
SqliteCountry.createTable();
SqliteCountry.initialize();
conversionRate ++;
int columnsBefore = 10;
bool putDescriptionInMiddle = false;
ArrayList arrayPersonRaceCountryServerID = new ArrayList(1);
if(needToConvertPersonToSport) {
columnsBefore = 7;
arrayPersonRaceCountryServerID.Add(Constants.SportUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.SpeciallityUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.LevelUndefinedID.ToString());
putDescriptionInMiddle = true;
}
arrayPersonRaceCountryServerID.Add(Constants.RaceUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.CountryUndefinedID.ToString());
arrayPersonRaceCountryServerID.Add(Constants.ServerUndefinedID.ToString());
convertTables(new SqlitePersonOld(), Constants.PersonOldTable, columnsBefore, arrayPersonRaceCountryServerID, putDescriptionInMiddle);
SqlitePreferences.Update ("databaseVersion", "0.57", true);
dbcon.Close();
Log.WriteLine("Added simulated column to each event table on client. Added to person: race, country, serverUniqueID. Convert to sport related done here if needed. Added also run and runInterval initial speed");
currentVersion = "0.57";
}
if(currentVersion == "0.57") {
dbcon.Open();
//check if "republic" is in country table
if(SqliteCountry.TableHasOldRepublicStuff()){
conversionRateTotal = 4;
conversionRate = 1;
Sqlite.dropTable(Constants.CountryTable);
conversionRate ++;
SqliteCountry.createTable();
conversionRate ++;
SqliteCountry.initialize();
conversionRate ++;
Log.WriteLine("Countries without kingdom or republic (except when needed)");
}
SqlitePreferences.Update ("databaseVersion", "0.58", true);
dbcon.Close();
currentVersion = "0.58";
}
if(currentVersion == "0.58") {
dbcon.Open();
conversionRateTotal = 2;
conversionRate = 1;
SqlitePreferences.Insert ("showAngle", "False");
alterTableColumn(new SqliteJump(), Constants.JumpTable, 11);
//jump fall is also converted to double (don't need to do at conversion to 0.76)
jumpFallAsDouble = true;
SqlitePreferences.Update ("databaseVersion", "0.59", true);
Log.WriteLine("Converted DB to 0.59 (added 'showAngle' to preferences, changed angle on jump to double)");
conversionRate = 2;
dbcon.Close();
currentVersion = "0.59";
}
if(currentVersion == "0.59") {
dbcon.Open();
conversionRateTotal = 4;
conversionRate = 1;
SqlitePreferences.Insert ("volumeOn", "True");
SqlitePreferences.Insert ("evaluatorServerID", "-1");
conversionRate = 2;
int columnsBefore = 8;
ArrayList arrayServerID = new ArrayList(1);
arrayServerID.Add(Constants.ServerUndefinedID.ToString());
convertTables(new SqliteSession(), Constants.SessionTable, columnsBefore, arrayServerID, false);
conversionRate = 3;
SqliteEvent.SimulatedConvertToNegative();
SqlitePreferences.Update ("databaseVersion", "0.60", true);
Log.WriteLine("Converted DB to 0.60 (added volumeOn and evaluatorServerID to preferences. session has now serverUniqueID. Simulated now are -1, because 0 is real and positive is serverUniqueID)");
conversionRate = 4;
dbcon.Close();
currentVersion = "0.60";
}
if(currentVersion == "0.60") {
dbcon.Open();
conversionRateTotal = 3;
conversionRate = 1;
ArrayList arrayDS = new ArrayList(1);
arrayDS.Add("-1"); //distancesString
convertTables(new SqliteRunIntervalType(), Constants.RunIntervalTypeTable, 7, arrayDS, false);
conversionRate = 2;
//SqliteRunType.RunIntervalTypeInsert ("MTGUG:-1:true:3:false:Modified time Getup and Go test:1-7-19", true);
RunType type = new RunType();
type.Name = "MTGUG";
type.Distance = -1;
type.TracksLimited = true;
type.FixedValue = 3;
type.Unlimited = false;
type.Description = "Modified time Getup and Go test";
type.DistancesString = "1-7-19";
SqliteRunIntervalType.Insert(type, Constants.RunIntervalTypeTable, true);
SqlitePreferences.Update ("databaseVersion", "0.61", true);
Log.WriteLine("Converted DB to 0.61 added RunIntervalType distancesString (now we van have interval tests with different distances of tracks). Added MTGUG");
conversionRate = 3;
dbcon.Close();
currentVersion = "0.61";
}
if(currentVersion == "0.61") {
dbcon.Open();
SqliteJumpType.JumpRjTypeInsert ("RJ(hexagon):1:0:1:18:Reactive Jump on a hexagon until three full revolutions are done", true);
SqlitePreferences.Update ("databaseVersion", "0.62", true);
Log.WriteLine("Converted DB to 0.62 added hexagon");
dbcon.Close();
currentVersion = "0.62";
}
if(currentVersion == "0.62") {
dbcon.Open();
SqlitePreferences.Insert ("versionAvailable", "");
SqlitePreferences.Update ("databaseVersion", "0.63", true);
Log.WriteLine("Converted DB to 0.63 (added 'versionAvailable' to preferences)");
dbcon.Close();
currentVersion = "0.63";
}
if(currentVersion == "0.63") {
dbcon.Open();
RunType type = new RunType();
type.Name = "Margaria";
type.Distance = 0;
type.Description = "Margaria-Kalamen test";
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
SqliteEvent.GraphLinkInsert (Constants.RunTable, "Margaria", "margaria.png", true);
SqlitePreferences.Update ("databaseVersion", "0.64", true);
Log.WriteLine("Converted DB to 0.64 (added margaria test)");
dbcon.Close();
currentVersion = "0.64";
}
if(currentVersion == "0.64") {
dbcon.Open();
SqliteServer sqliteServerObject = new SqliteServer();
//user has also an evaluator table with a row (it's row)
sqliteServerObject.CreateEvaluatorTable();
SqlitePreferences.Update ("databaseVersion", "0.65", true);
Log.WriteLine("Converted DB to 0.65 (added Sevaluator on client)");
dbcon.Close();
currentVersion = "0.65";
}
if(currentVersion == "0.65") {
dbcon.Open();
//now runAnalysis is a multiChronopic event
//SqliteJumpType.JumpRjTypeInsert ("RunAnalysis:0:0:1:-1:Run between two photocells recording contact and flight times in contact platform/s. Until finish button is clicked.", true);
SqlitePreferences.Update ("databaseVersion", "0.66", true);
//Log.WriteLine("Converted DB to 0.66 (added RunAnalysis Reactive jump)");
Log.WriteLine("Converted DB to 0.66 (done nothing)");
dbcon.Close();
currentVersion = "0.66";
}
if(currentVersion == "0.66") {
dbcon.Open();
SqliteJumpType.JumpTypeInsert ("TakeOff:0:0:Take off", true);
SqliteJumpType.JumpTypeInsert ("TakeOffWeight:0:0:Take off with weight", true);
SqlitePreferences.Update ("databaseVersion", "0.67", true);
Log.WriteLine("Converted DB to 0.67 (added TakeOff jumps)");
dbcon.Close();
currentVersion = "0.67";
}
if(currentVersion == "0.67") {
dbcon.Open();
sqliteMultiChronopicObject.createTable(Constants.MultiChronopicTable);
SqlitePreferences.Update ("databaseVersion", "0.68", true);
Log.WriteLine("Converted DB to 0.68 (added multiChronopic tests table)");
dbcon.Close();
currentVersion = "0.68";
}
if(currentVersion == "0.68") {
dbcon.Open();
RunType type = new RunType();
type.Name = "Gesell-DBT";
type.Distance = 2.5;
type.Description = "Gesell Dynamic Balance Test";
SqliteRunType.Insert(type, Constants.RunTypeTable, true);
SqliteEvent.GraphLinkInsert (Constants.RunTable, "Gesell-DBT", "gesell_dbt.png", true);
SqlitePreferences.Update ("databaseVersion", "0.69", true);
Log.WriteLine("Converted DB to 0.69 (added Gesell-DBT test)");
dbcon.Close();
currentVersion = "0.69";
}
if(currentVersion == "0.69") {
dbcon.Open();
SqlitePreferences.Insert ("showPower", "True");
SqlitePreferences.Update ("databaseVersion", "0.70", true);
Log.WriteLine("Converted DB to 0.70 (added showPower)");
dbcon.Close();
currentVersion = "0.70";
}
if(currentVersion == "0.70") {
dbcon.Open();
SqlitePersonSessionNotUpload.CreateTable();
SqlitePreferences.Update ("databaseVersion", "0.71", true);
Log.WriteLine("Converted DB to 0.71 (created personNotUploadTable on client)");
dbcon.Close();
currentVersion = "0.71";
}
if(currentVersion == "0.71") {
dbcon.Open();
datesToYYYYMMDD();
SqlitePreferences.Update ("databaseVersion", "0.72", true);
Log.WriteLine("Converted DB to 0.72 (dates to YYYY-MM-DD)");
dbcon.Close();
currentVersion = "0.72";
}
if(currentVersion == "0.72") {
dbcon.Open();
deleteOrphanedPersonsOld();
SqlitePreferences.Update ("databaseVersion", "0.73", true);
Log.WriteLine("Converted DB to 0.73 (deleted orphaned persons (in person table but not in personSessionWeight table)");
dbcon.Close();
currentVersion = "0.73";
}
if(currentVersion == "0.73") {
//dbcon open laters on mid convertDJinDJna()
convertDJInDJna();
SqlitePreferences.Update ("databaseVersion", "0.74", true);
Log.WriteLine("Converted DB to 0.74 (All DJ converted to DJna)");
dbcon.Close();
currentVersion = "0.74";
}
if(currentVersion == "0.74") {
conversionRateTotal = 3;
conversionRate = 1;
dbcon.Open();
convertTables(new SqlitePersonOld(), Constants.PersonOldTable, 13, new ArrayList(), false);
conversionRate++;
convertTables(new SqlitePersonSessionOld(), Constants.PersonSessionOldWeightTable, 4, new ArrayList(), false);
SqlitePreferences.Update ("databaseVersion", "0.75", true);
conversionRate++;
Log.WriteLine("Converted DB to 0.75 (person, and personSessionWeight have height and weight as double)");
dbcon.Close();
currentVersion = "0.75";
}
if(currentVersion == "0.75") {
conversionRateTotal = 3;
conversionRate = 1;
dbcon.Open();
if(!jumpFallAsDouble)
alterTableColumn(new SqliteJump(), Constants.JumpTable, 11);
conversionRate++;
alterTableColumn(new SqliteJumpRj(), Constants.JumpRjTable, 18);
SqlitePreferences.Update ("databaseVersion", "0.76", true);
conversionRate++;
Log.WriteLine("Converted DB to 0.76 (jump & jumpRj falls as double)");
dbcon.Close();
currentVersion = "0.76";
}
if(currentVersion == "0.76") {
dbcon.Open();
convertPersonAndPersonSessionTo77();
SqlitePreferences.Update ("databaseVersion", "0.77", true);
Log.WriteLine("Converted DB to 0.77 (person77, personSession77)");
dbcon.Close();
currentVersion = "0.77";
}
if(currentVersion == "0.77") {
dbcon.Open();
SqliteJumpType.UpdateOther ("weight", Constants.TakeOffWeightName, "1");
Random rnd = new Random();
string machineID = rnd.Next().ToString();
SqlitePreferences.Insert ("machineID", machineID);
SqlitePreferences.Update ("databaseVersion", "0.78", true);
Log.WriteLine("Converted DB to 0.78 (Added machineID to preferences, takeOffWeight has no weight in db conversions since 0.66)");
dbcon.Close();
currentVersion = "0.78";
}
if(currentVersion == "0.78") {
dbcon.Open();
SqlitePreferences.Insert ("multimediaStorage", Constants.MultimediaStorage.BYSESSION.ToString());
SqlitePreferences.Update ("databaseVersion", "0.79", true);
Log.WriteLine("Converted DB to 0.79 (Added multimediaStorage structure id)");
dbcon.Close();
currentVersion = "0.79";
}
if(currentVersion == "0.79") {
dbcon.Open();
if(! runAndRunIntervalInitialSpeedAdded) {
ArrayList myArray = new ArrayList(1);
myArray.Add("0"); //initial speed
conversionRateTotal = 3;
conversionRate = 1;
convertTables(new SqliteRun(), Constants.RunTable, 8, myArray, false);
conversionRate ++;
convertTables(new SqliteRunInterval(), Constants.RunIntervalTable, 12, myArray, false);
conversionRate ++;
Log.WriteLine("Converted DB to 0.80 Added run and runInterval initial speed (if not done in 0.56 conversion)");
}
SqlitePreferences.Update ("databaseVersion", "0.80", true);
dbcon.Close();
currentVersion = "0.80";
}
if(currentVersion == "0.80") {
dbcon.Open();
ArrayList myArray = new ArrayList(1);
myArray.Add("0"); //initial speed
conversionRateTotal = 2;
conversionRate = 1;
Sqlite.dropTable(Constants.TempRunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
conversionRate ++;
Log.WriteLine("Converted DB to 0.81 Added tempRunInterval initial speed");
SqlitePreferences.Update ("databaseVersion", "0.81", true);
dbcon.Close();
currentVersion = "0.81";
}
if(currentVersion == "0.81") {
dbcon.Open();
conversionRateTotal = 2;
conversionRate = 1;
SqlitePreferences.Insert ("videoOn", "False");
conversionRate = 2;
Log.WriteLine("Converted DB to 0.82 Added videoOn");
SqlitePreferences.Update ("databaseVersion", "0.82", true);
dbcon.Close();
currentVersion = "0.82";
}
if(currentVersion == "0.82") {
dbcon.Open();
conversionRateTotal = 2;
conversionRate = 1;
SqliteEncoder.createTableEncoder();
SqliteEncoder.createTableEncoderExercise();
SqliteEncoder.initializeTableEncoderExercise();
conversionRate = 2;
Log.WriteLine("Created encoder tables.");
SqlitePreferences.Update ("databaseVersion", "0.83", true);
dbcon.Close();
currentVersion = "0.83";
}
if(currentVersion == "0.83") {
dbcon.Open();
RunType type = new RunType();
type.Name = "RSA 8-4-R3-5";
type.Distance = -1;
type.TracksLimited = true;
type.FixedValue = 4;
type.Unlimited = false;
type.Description = "RSA testing";
type.DistancesString = "8-4-R3-5";
SqliteRunIntervalType.Insert(type, Constants.RunIntervalTypeTable, true);
Log.WriteLine("Added 1st RSA test.");
SqlitePreferences.Update ("databaseVersion", "0.84", true);
dbcon.Close();
currentVersion = "0.84";
}
}
//if changes are made here, remember to change also in CreateTables()
//remember to change also the databaseVersion below
return returnSoftwareIsNew;
}
public static void CreateTables(bool server)
{
dbcon.Open();
creationTotal = 14;
creationRate = 1;
SqliteServer sqliteServerObject = new SqliteServer();
//user has also an evaluator table with a row (it's row)
sqliteServerObject.CreateEvaluatorTable();
if(server) {
sqliteServerObject.CreatePingTable();
SqliteServerSession sqliteSessionObject = new SqliteServerSession();
sqliteSessionObject.createTable(Constants.SessionTable);
} else {
SqliteSession sqliteSessionObject = new SqliteSession();
sqliteSessionObject.createTable(Constants.SessionTable);
SqlitePersonSessionNotUpload.CreateTable();
creationRate ++;
}
SqlitePerson sqlitePersonObject = new SqlitePerson();
sqlitePersonObject.createTable(Constants.PersonTable);
//graphLinkTable
SqliteEvent.createGraphLinkTable();
creationRate ++;
//jumps
SqliteJump sqliteJumpObject = new SqliteJump();
SqliteJumpRj sqliteJumpRjObject = new SqliteJumpRj();
sqliteJumpObject.createTable(Constants.JumpTable);
sqliteJumpRjObject.createTable(Constants.JumpRjTable);
sqliteJumpRjObject.createTable(Constants.TempJumpRjTable);
//jump Types
creationRate ++;
SqliteJumpType.createTableJumpType();
SqliteJumpType.createTableJumpRjType();
SqliteJumpType.initializeTableJumpType();
SqliteJumpType.initializeTableJumpRjType();
//runs
creationRate ++;
SqliteRun sqliteRunObject = new SqliteRun();
SqliteRunInterval sqliteRunIntervalObject = new SqliteRunInterval();
sqliteRunObject.createTable(Constants.RunTable);
sqliteRunIntervalObject.createTable(Constants.RunIntervalTable);
sqliteRunIntervalObject.createTable(Constants.TempRunIntervalTable);
//run Types
creationRate ++;
SqliteRunType sqliteRunTypeObject = new SqliteRunType();
sqliteRunTypeObject.createTable(Constants.RunTypeTable);
SqliteRunType.initializeTable();
SqliteRunIntervalType sqliteRunIntervalTypeObject = new SqliteRunIntervalType();
sqliteRunIntervalTypeObject.createTable(Constants.RunIntervalTypeTable);
SqliteRunIntervalType.initializeTable();
//reactionTimes
creationRate ++;
SqliteReactionTime sqliteReactionTimeObject = new SqliteReactionTime();
sqliteReactionTimeObject.createTable(Constants.ReactionTimeTable);
//pulses and pulseTypes
creationRate ++;
SqlitePulse sqlitePulseObject = new SqlitePulse();
sqlitePulseObject.createTable(Constants.PulseTable);
SqlitePulseType.createTablePulseType();
SqlitePulseType.initializeTablePulseType();
//multiChronopic tests
creationRate ++;
SqliteMultiChronopic sqliteMultiChronopicObject = new SqliteMultiChronopic();
sqliteMultiChronopicObject.createTable(Constants.MultiChronopicTable);
//encoder
creationRate ++;
SqliteEncoder.createTableEncoder();
SqliteEncoder.createTableEncoderExercise();
SqliteEncoder.initializeTableEncoderExercise();
//sports
creationRate ++;
SqliteSport.createTable();
SqliteSport.initialize();
SqliteSpeciallity.createTable();
SqliteSpeciallity.initialize();
SqliteSpeciallity.InsertUndefined(true);
creationRate ++;
SqlitePersonSession sqlitePersonSessionObject = new SqlitePersonSession();
sqlitePersonSessionObject.createTable(Constants.PersonSessionTable);
creationRate ++;
SqlitePreferences.createTable();
SqlitePreferences.initializeTable(lastChronojumpDatabaseVersion, creatingBlankDatabase);
creationRate ++;
SqliteCountry.createTable();
SqliteCountry.initialize();
//changes [from - to - desc]
//0.83 - 0.84 Converted DB to 0.84 Added first RSA test
//0.82 - 0.83 Converted DB to 0.83 Created encoder table
//0.81 - 0.82 Converted DB to 0.82 Added videoOn
//0.80 - 0.81 Converted DB to 0.81 Added tempRunInterval initial speed
//0.79 - 0.80 Converted DB to 0.80 Added run and runInterval initial speed (if not done in 0.56 conversion)
//0.78 - 0.79 Converted DB to 0.79 (Added multimediaStorage structure id)
//0.77 - 0.78 Converted DB to 0.78 (Added machineID to preferences, takeOffWeight has no weight in db conversions since 0.66)
//0.76 - 0.77 Converted DB to 0.77 (person77, personSession77)
//0.75 - 0.76 Converted DB to 0.76 (jump & jumpRj falls as double)
//0.74 - 0.75 Converted DB to 0.75 (person, and personSessionWeight have height and weight as double)
//0.73 - 0.74 Converted DB to 0.74 (All DJ converted to DJna)
//0.72 - 0.73 Converted DB to 0.73 (deleted orphaned persons (in person table but not in personSessionWeight table))
//0.71 - 0.72 dates to YYYY-MM-DD
//0.70 - 0.71 created personNotUploadTable on client
//0.69 - 0.70 added showPower to preferences
//0.68 - 0.69 added Gesell-DBT test
//0.67 - 0.68 added multiChronopic tests table
//0.66 - 0.67 added TakeOff jumps
//0.65 - 0.66 added done nothing
//0.64 - 0.65 added Sevaluator on client
//0.63 - 0.64 added margaria test
//0.62 - 0.63 added 'versionAvailable' to preferences
//0.61 - 0.62 added hexagon (jumpRj test)
//0.60 - 0.61 added RunIntervalType distancesString (now we van have interval tests with different distances of tracks). Added MTGUG
//0.59 - 0.60 added volumeOn and evaluatorServerID to preferences. Session has now serverUniqueID. Simulated now are -1, because 0 is real and positive is serverUniqueID
//0.58 - 0.59 Added 'showAngle' to preferences, changed angle on jump to double
//0.57 - 0.58 Countries without kingdom or republic (except when needed)
//0.56 - 0.57 Added simulated column to each event table on client. person: race, country, serverID. Convert to sport related done here if needed. Added also run and runInterval initial speed);
//0.55 - 0.56 Added session default sport stuff into session table
//0.54 - 0.55 Added undefined to speciallity table
//0.53 - 0.54 created sport tables. Added sport data, speciallity and level of practice to person table
//0.52 - 0.53 added table weightSession, moved person weight data to weightSession table for each session that has performed
//0.51 - 0.52 added graphLinks for cmj_l and abk_l. Fixed CMJ_l name
//0.50 - 0.51 added graphLinks for run simple and interval
//0.49 - 0.50: changed SJ+ to SJl, same for CMJ+ and ABK+, added jump and jumpRj graph links
//0.48 - 0.49: added graphLinkTable, added rocket jump and 5 agility tests: (20Yard, 505, Illinois, Shuttle-Run & ZigZag). Added graphs pof the 5 agility tests
//0.47 - 0.48: added tempJumpReactive and tempRunInterval tables
//0.46 - 0.47: added reactionTime table
//0.45 - 0.46: added "Free" jump type
//0.44 - 0.45: added allowFinishRjAfterTime
//0.43 - 0.44: added showQIndex and showDjIndex
//0.42 - 0.43: added 'free' pulseType & language preference
//0.41 - 0.42: added pulse and pulseType tables
//0.4 - 0.41: jump, jumpRj weight is double (always a percent)
dbcon.Close();
creationRate ++;
}