//public DbIns INS (params string[] values) { return new DbInsert(Name, fieldNames, fieldTypes, utl.stringArr2s(values, ", ")) ; }
//public DbIns INS (string values) { return new DbIns(Name, fieldNames, fieldTypes, values) ; }
public long copyTo(Db tgtDb)
{
//if (this.Name.Equals("webpge")) this.Name = this.Name;
tgtDb.exec(tgtDb.Tables[this.Name].DEL);
DatSet dat = this.db.exec(this.db.Tables[this.Name].SLD);
if (dat.Raws.Len == 0)
{
return(0);
}
return(tgtDb.exec(tgtDb.Tables[this.Name].INS(dat)));
}
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;
}
public DbIns INS(DatSet values)
{
return(new DbIns(this, values));
}
