protected createTable ( string tableName ) : void | ||
tableName | string | |
Результат | void |
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 ++; }
protected static void convertPersonAndPersonSessionTo77() { //create person77 SqlitePerson sqlitePersonObject = new SqlitePerson(); sqlitePersonObject.createTable(Constants.PersonTable); //create personSession77 SqlitePersonSession sqlitePersonSessionObject = new SqlitePersonSession(); sqlitePersonSessionObject.createTable(Constants.PersonSessionTable); //select all personOld data SqlitePersonOld sqlitePersonOldObject = new SqlitePersonOld(); ArrayList personsOld = sqlitePersonOldObject.SelectAllPersons(); conversionRateTotal = personsOld.Count; conversionRate = 1; foreach (PersonOld pOld in personsOld) { Person p = new Person( pOld.UniqueID, pOld.Name, pOld.Sex, pOld.DateBorn, pOld.Race, pOld.CountryID, pOld.Description, pOld.ServerUniqueID ); p.InsertAtDB(true, Constants.PersonTable); //select all personSessionOld data of this person SqlitePersonSessionOld sqlitePersonSessionOldObject = new SqlitePersonSessionOld(); ArrayList personSessionsOld = sqlitePersonSessionOldObject.SelectAllPersonSessionsOfAPerson(p.UniqueID); conversionSubRateTotal = personSessionsOld.Count; conversionSubRate = 1; foreach (PersonSessionOld psOld in personSessionsOld) { PersonSession ps = new PersonSession( psOld.UniqueID, psOld.PersonID, psOld.SessionID, pOld.Height, psOld.Weight, pOld.SportID, pOld.SpeciallityID, pOld.Practice, "" //comments ); ps.InsertAtDB(true, Constants.PersonSessionTable); conversionSubRate ++; } conversionRate ++; } //drop old tables Sqlite.dropTable(Constants.PersonOldTable); Sqlite.dropTable(Constants.PersonSessionOldWeightTable); }
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 ++; }