[Quantproject-developers] QuantProject/b2_DataAccess DataBaseVersionManager.cs,1.9,1.10
Brought to you by:
glauco_1
|
From: Glauco S. <gla...@us...> - 2004-03-28 20:15:20
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25296/b2_DataAccess Modified Files: DataBaseVersionManager.cs Log Message: - added the visuallyValidatedQuotes table - removed the visuallyValidatedTickers table Index: DataBaseVersionManager.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBaseVersionManager.cs,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** DataBaseVersionManager.cs 21 Mar 2004 16:15:56 -0000 1.9 --- DataBaseVersionManager.cs 28 Mar 2004 20:03:57 -0000 1.10 *************** *** 100,106 **** "quOpen REAL, quHigh REAL, quLow REAL, quClose REAL, " + "quVolume INTEGER, quAdjustedClose REAL, quAdjustedCloseToCloseRatio FLOAT)"); - // table where to store the time period for which tickers' quotes have been validated - this.executeCommand("CREATE TABLE validatedTickers " + - "( vtTicker TEXT(8) , vtStartDate DATETIME , vtEndDate DATETIME , vtDate DATETIME)"); // table of groups where you can collect tickers. // Groups are used to simplify operations like: --- 100,103 ---- *************** *** 118,136 **** "( vtTicker TEXT(8) , vtStartDate DATETIME , vtEndDate DATETIME , vtEditDate DATETIME, " + "CONSTRAINT myKey PRIMARY KEY ( vtTicker ) )" ); ! // visuallyValidatedTickers will contain a record for each ticker whose ! // quotes with suspicious ratios have been validated. // Field list: ! // vvTicker: validated ticker ! // vvStartDate: starting date of the time span being visually validated ! // vvEndDate: ending date of the time span being visually validated // vvHashValue: hash value for the visually validated quotes ! // vvCloseToCloseRatio: the close to close ratio has been checked to be acceptable ! // vvRangeToRangeRatio: the High-Low range ratio has been checked to be acceptable ! // vvDate: Last date this record has been added/modified ! this.executeCommand( "CREATE TABLE visuallyValidatedTickers " + ! "( vvTicker TEXT(8) , vvStartDate DATETIME , vvEndDate DATETIME , " + ! "vvHashValue TEXT(50) , vvEditDate DATETIME, " + ! "vvCloseToCloseRatio BIT , vvRangeToRangeRatio BIT , " + ! "CONSTRAINT myKey PRIMARY KEY ( vvTicker ) )" ); // quotesFromSecondarySources will contain quotes coming from sources different // from the main one. It will be used for confirming and thus validation purposes. --- 115,130 ---- "( vtTicker TEXT(8) , vtStartDate DATETIME , vtEndDate DATETIME , vtEditDate DATETIME, " + "CONSTRAINT myKey PRIMARY KEY ( vtTicker ) )" ); ! // visuallyValidatedQuotes will contain a record for each ! // quote with suspicious ratio that has been validated. // Field list: ! // vvTicker: validated ticker ! // vvDate: validated quote date ! // vvValidationType: 1 = close to close ratio ; 2 = range to range ratio // vvHashValue: hash value for the visually validated quotes ! // vvEditDate: Last date this record has been added/modified ! this.executeCommand( "CREATE TABLE visuallyValidatedQuotes " + ! "( vvTicker TEXT(8) , vvDate DATETIME , vvValidationType INT , " + ! "vvHashValue TEXT(50) , vvEditDate DATETIME , " + ! "CONSTRAINT myKey PRIMARY KEY ( vvTicker , vvDate , vvValidationType ) )" ); // quotesFromSecondarySources will contain quotes coming from sources different // from the main one. It will be used for confirming and thus validation purposes. *************** *** 185,188 **** --- 179,183 ---- { this.executeCommand("DROP TABLE version"); + this.executeCommand("DROP TABLE visuallyValidatedTickers"); } private void executeCommand(string commandToBeExecuted) |