[Quantproject-developers] QuantProject/b2_DataAccess DataBaseVersionManager.cs,1.5,1.6

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory sc8-pr-cvs1:/tmp/cvs-serv11507/b2_DataAccess

Modified Files:
	DataBaseVersionManager.cs 
Log Message:
- removed commented code
- fixed syntax for CREATE TABLE tickerGroups
- fixed syntax for CREATE TABLE quotesFromSecondarySources

Index: DataBaseVersionManager.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBaseVersionManager.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** DataBaseVersionManager.cs	17 Jan 2004 15:47:08 -0000	1.5
--- DataBaseVersionManager.cs	17 Jan 2004 19:10:14 -0000	1.6
***************
*** 97,129 ****
  	private void createTables()
      {
- //<<<<<<< DataBaseVersionManager.cs
- //      string command =
- //        "create table validatedTickers " +
- //        "( vtTicker TEXT(8) , vtStartDate DATETIME , vtEndDate DATETIME , vtDate DATETIME, " +
- //        "CONSTRAINT myKey PRIMARY KEY ( vtTicker ) )";
- //      OleDbCommand oleDbCommand = new OleDbCommand( command , this.oleDbConnection );
- //      oleDbCommand.ExecuteNonQuery();
- //      oleDbCommand.CommandText =
- //        "create table validatedTickers " +
- //        "( vvTicker TEXT(8) , vvStartDate DATETIME , vvEndDate DATETIME , " +
- //        "vvHashValue TEXT(50) , vvEditDate DATETIME, " +
- //        "vvCloseToCloseRatio BIT , vvRangeToRangeRatio BIT , " +
- //        "CONSTRAINT myKey PRIMARY KEY ( vvTicker ) )";
- //      oleDbCommand.ExecuteNonQuery();
- //      oleDbCommand.CommandText =
- //        "create table quotesFromOtherSources " +
- //        "(qsTicker TEXT(8) , " +
- //        "qsDate DATETIME , " +
- //        "qsSource SHORT , " +
- //        "qsOpen SINGLE , " +
- //        "qsHigh SINGLE , " +
- //        "qsLow SINGLE , " +
- //        "qsClose SINGLE , " +
- //        "qsVolume SINGLE , " +
- //        "qsAdjustedClose SINGLE , " +
- //        "qsAdjustedCloseToCloseRatio DOUBLE " +
- //        "qsEditDate DATETIME , " +
- //        "CONSTRAINT myKey PRIMARY KEY ( qsTicker , qsDate , qsSource ) )";
- //=======
  		this.executeCommand("CREATE TABLE tickers (tiTicker TEXT(8))");
  		this.executeCommand("CREATE TABLE quotes (quTicker TEXT(8), quDate DATETIME, " +
--- 97,100 ----
***************
*** 137,141 ****
  		// validating, updating data from the web, testing strategies
  		this.executeCommand("CREATE TABLE tickerGroups " +
! 			"( tgId TEXT(8) , tgDescription(100), tgTgId TEXT(8))");
      // where to store the relation between a ticker and a group
      // NOTE that a group can be created inside another group and
--- 108,112 ----
  		// validating, updating data from the web, testing strategies
  		this.executeCommand("CREATE TABLE tickerGroups " +
! 			"( tgId TEXT(8) , tgDescription TEXT(100), tgTgId TEXT(8))");
      // where to store the relation between a ticker and a group
      // NOTE that a group can be created inside another group and
***************
*** 178,185 ****
        "qsVolume SINGLE , " +
        "qsAdjustedClose SINGLE , " +
!       "qsAdjustedCloseToCloseRatio DOUBLE " +
        "qsEditDate DATETIME , " +
        "CONSTRAINT myKey PRIMARY KEY ( qsTicker , qsDate , qsSource ) )" );
- //    >>>>>>> 1.4
      }
  
--- 149,155 ----
        "qsVolume SINGLE , " +
        "qsAdjustedClose SINGLE , " +
!       "qsAdjustedCloseToCloseRatio DOUBLE , " +
        "qsEditDate DATETIME , " +
        "CONSTRAINT myKey PRIMARY KEY ( qsTicker , qsDate , qsSource ) )" );
      }
  
***************
*** 220,225 ****
  		catch(Exception ex)
  		{
! 			string notUsed = ex.ToString();// to avoid warning after compilation
! 		}	
  	}
  	
--- 190,195 ----
  		catch(Exception ex)
  		{
!       string notUsed = ex.ToString();// to avoid warning after compilation
!     }	
  	}