[Quantproject-developers] QuantProject/b2_DataAccess/Tables Bars.cs, 1.9, 1.10
Brought to you by:
glauco_1
|
From: Marco M. <mi...@us...> - 2009-03-13 15:04:42
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv28257/b2_DataAccess/Tables Modified Files: Bars.cs Log Message: Some bugs have been fixed Index: Bars.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Bars.cs,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** Bars.cs 8 Feb 2009 16:43:34 -0000 1.9 --- Bars.cs 13 Mar 2009 15:04:23 -0000 1.10 *************** *** 268,276 **** DateTime lastBarDateTime, int intervalFrameInSeconds) { ! string sql = "select * from bars " + "where " + Bars.TickerFieldName + "='" + ticker + "' and " + Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + ! "and " + Bars.DateTimeForOpen + " between " + SQLBuilder.GetDateConstant(firstBarDateTime) + " " + ! "and " + SQLBuilder.GetDateConstant(lastBarDateTime) + " " + "order by " + Bars.DateTimeForOpen; return SqlExecutor.GetDataTable( sql ); --- 268,278 ---- DateTime lastBarDateTime, int intervalFrameInSeconds) { ! string sql = "select " + ! Bars.Open + "," + Bars.Low + "," + Bars.High + "," + Bars.Close + ! " from bars " + "where " + Bars.TickerFieldName + "='" + ticker + "' and " + Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + ! "and " + Bars.DateTimeForOpen + " between " + SQLBuilder.GetDateTimeConstant(firstBarDateTime) + " " + ! "and " + SQLBuilder.GetDateTimeConstant(lastBarDateTime) + " " + "order by " + Bars.DateTimeForOpen; return SqlExecutor.GetDataTable( sql ); *************** *** 382,386 **** { string sql = ! "select baDateTimeForOpen from bars " + "where (baTicker='" + ticker + "') and " + "(baInterval=" + intervalFrameInSeconds + ") and" + --- 384,388 ---- { string sql = ! "select baDateTimeForOpen, baOpen, baHigh, baLow, baClose from bars " + "where (baTicker='" + ticker + "') and " + "(baInterval=" + intervalFrameInSeconds + ") and" + |