[Quantproject-developers] QuantProject/b2_DataAccess DataBaseVersionManager.cs,1.9,1.10

[Glauco S. <gla...@us...>]

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)