public void InitTable() { DB.CreateTable(TableName, new ColumnDefinition("level", "nvarchar(250)") .AddDefinition(new ColumnDefinition("time", "datetime")) .AddDefinition(new ColumnDefinition("message", "nvarchar(4000)")) ); }
public StreamingEventSource() { DB = InitDB(); Options = InitStreamingOptions(); DB.CreateTable(TableName, ValueDefs); SqlConnection = DB.NewSqlConnection(); SqlConnection.Open(); // init the cursor and options String dropCursorCmd = String.Format(@"DEALLOCATE {0};", CursorName); String createCursorCmd = String.Format(@"DECLARE {0} CURSOR Dynamic Read_Only FOR SELECT * FROM {1} where row_id>={2} OPEN {0};", CursorName, TableName, Options.CurrentRow); DB.ExecuteNonQuery(createCursorCmd, SqlConnection); FetchNextCursorCmd = String.Format(@"FETCH NEXT FROM {0};", CursorName); FetchPriorCursorCmd = String.Format(@"FETCH PRIOR FROM {0};", CursorName); FetchScrollCursorCmd = String.Format(@"FETCH ABSOLUTE {0} FROM {1};", Options.CurrentRow, CursorName); ValueNames = ValueDefs.ToList() .Select(def => def.ColumnName).ToArray(); // skip to the unhappend event //while (true) //{ Object[] rs = NextRow(); if (rs != null) { if (IsValidRow(rs)) { //back one PriroRow(); //break; } //else continue; // visited rows } // else break; //} }
protected BlobStore(QCDBClient db) { DB = db; DB.CreateTable(TableName, ValueDefs); }
public void InitTable() { DB.CreateTable(TableName, ValueDefs); //DB.CreateIndex(TableName, "fire_time"); DB.CreateIndex(TableName, "status"); }
public void InitTable() { DB = InitDB(); DB.CreateTable(TableName, ValueDefs); }
public void InitTable() { DB.CreateTable(TableName, new ColumnDefinition("name", "nvarchar(250)") .AddDefinition(new ColumnDefinition("value", "nvarchar(250)"))); }