private static void selfTest() { selfTested = true; ctx cx = new ctx(); Db db = new Db(cx.DbDrivers); DatSet ds = new DatSet(); ObjPile v = new ObjPile("1", 2); ds.Raws.Add(v); ds.Raws.Add(v); ass(db.Grid("tbl").sC(db.dF("a"), db.dsF("isa")).INS(db.ds("1"), 2).sql().Equals("INSERT INTO tbl (a, 'isa' ) \r\nVALUES ('1', 2 )")); ass(db.Grid("tbl").sC("id, nm").INS(db.ds("1"), 2).sql().Equals("INSERT INTO tbl (id, nm ) \r\nVALUES ('1', 2 )")); ass(db.Grid("tbl").sC("id, nm").INS(ds).sql().Equals("INSERT INTO tbl (id, nm ) \r\n(\r\n SELECT '1', 2)\r\nUNION\r\n( SELECT '1', 2\r\n)")); ass(db.Grid("tbl").sC("id, nm").INS(db.Grid("tbl").sC("id, nm").sR(db.cd("id").GT(0)).SLC).sql().Equals("INSERT INTO tbl (id, nm ) \r\n SELECT id, nm \r\n FROM tbl tbl \r\n WHERE ( (id > 0) ) ")); }
internal DbIns(DbGrid into, DatSet values) { init(); grid = into; datSet = values; }