var sql = new AbstractSQL("test"); sql.createTable([ new AbstractSQL.Field("id",AbstractSQL.FieldType.INTEGER,10,true), new AbstractSQL.Field("name",AbstractSQL.FieldType.TEXT,255,false) ]); sql.comment("insert"); sql.insert({ "id":101, "name":"長瀬敦史" }); sql.insert({ "id":100, "name":"長瀬敦史" },AbstractSQL.Conflict.REPLACE); sql.comment("insert"); sql.count("id",[ new AbstractSQL.Where("name","長%",AbstractSQL.Operator.LIKE) ]); sql.update({ name:"あいうえ", id:12 },[ new AbstractSQL.WhereList(AbstractSQL.Logic.OR,[ new AbstractSQL.Where("id",100) ]) ],AbstractSQL.Conflict.REPLACE); sql.select(["id","name"],[ new AbstractSQL.WhereList(AbstractSQL.Logic.OR,[ new AbstractSQL.Where("id",100), new AbstractSQL.Where("id","101") ]) ]); sql.select("*", new AbstractSQL.Where("id", new AbstractSQL("test").select("id",null,10,new AbstractSQL.Order("id",true)) ) );