Ejemplo n.º 1
0
        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)  ) "));
        }
Ejemplo n.º 2
0
 internal DbIns(DbGrid into, DatSet values)
 {
     init();
     grid   = into;
     datSet = values;
 }