throw-out / sqlite3unity3d_ts Goto Github PK

  class Data {
      @Column("number")
      public id: number;
      @Column("string")
      public name: string;
      @Column("number")
      public age: number;
      @Column("number")
      public sex: number;
  }

    let conn = new DBConnection("db path");
    conn.open();

    //创建表
    conn.createTable(Data);
    //清空表
    conn.clearTable(Data);
    //删除表
    conn.dropTable(Data);

    let data = new Data();
    //直接插入
    conn.insert(data);
    //条件更新或插入数据
    //注:基于字符串解析, 无法直接获取data.id的值, 需要通过对象传入
    let id = data.id;
    let ret = conn.table(Data)
        .where(o => o.id == id && id != 0, { id })
        .updateOrInsert(data);

    let queryAll: Data[] = conn.table(Data)
        .query();
    let queryBetween: Data[] = conn.table(Data)
        .between(o => o.age, "20", "30")
        .query();

    let ret = conn.table(Data)
        .where(o => o.id == 10)
        .delete();