数据表操作

BaaS.TableSchema 对象封装了针对数据表相关的操作，通过实例化 TableSchema，我们可以对数据表进行增删改查。

let tableSchema = new BaaS.TableSchema()

创建数据表

tableSchema.createSchema(schemaInfo)

参数说明

参数 row_read_perm 和 row_write_perm 控制数据表数据的读写权限，读权限表示用户是否有权限获取数据，写权限表示用户是否有权限更新数据。

参数 write_perm 控制数据表的写权限，即表示用户是否有权限创建数据。

权限参数的说明：

具体描述与使用场景可参考ACL 访问控制列表。

参数 schema 用于存储数据表字段的元信息，其结构遵循JSON-Table-Schema的描述。

例：

{
  "fields": [
    {
      "name": "field_name",
      "type": "string",
      "description": "description of field_name",
      "constraints": {
        "required": true # 设置写入/更新必填选项
      },
      "default": "hello, world", # 设置默认值
      "acl": {
        "clientVisibile": true, # 设置客户端可见
        "clientReadOnly": true, # 设置客户端只读
        "creatorVisible": true  # 设置创建者可见
      }
    }
  ]
}

数据表列的元信息：

• type 目前支持 string、integer、number、boolean、array、geojson、file、date、reference(pointer 类型字段)等

• items 目前支持 string、integer、number、boolean 等

• coordinate_type 目前支持 wgs84（地球坐标）、gcj02（火星坐标）

若字段是 array 类型，字段元信息为：

{
  "name": "array_field",
  "type": "array",
  "items": {
    "type": "string"
  }
}

若字段是 geojson 类型，字段元信息为：

{
  "name": "location",
  "type": "geojson",
  "format": "default",
  "coordinate_type": "gcj02"
}

若字段是 pointer 类型，字段元信息为：

{
  "name": "pointer",
  "type": "reference",
  "schema_id": "1"
}

字段权限相关的属性存储在 acl 中：

代码示例

• async/await
• promise

const schemaInfo = {
  "name": "Table199",
  "schema": {
    "fields": [
      {
        "name": "String",
        "type": "string"
      }
    ]
  },
  "row_read_perm": [
    "user:anonymous"
  ],
  "row_write_perm": [
    "user:*"
  ],
  "write_perm": [
    "user:*"
  ]
}
async function createSchema() {
  try {
    let tableSchema = new BaaS.TableSchema()
    let res = await tableSchema.createSchema(schemaInfo)
    // success
    return res
  } catch(err) {
    // error
    throw err
  }
}

const schemaInfo = {
  "name": "Table199",
  "schema": {
    "fields": [
      {
        "name": "String",
        "type": "string"
      }
    ]
  },
  "row_read_perm": [
    "user:anonymous"
  ],
  "row_write_perm": [
    "user:*"
  ],
  "write_perm": [
    "user:*"
  ]
}
function createSchema() {
  let tableSchema = new BaaS.TableSchema()
  tableSchema.createSchema(schemaInfo).then(res=>{
    // success
    callback(null, res)
  }).catch(err => {
    // error
    callback(err)
  })
}

返回示例

res.data 结构如下

{
  "id": 1,
  "name": "Table",
  "protected_fields": null,
  "schema": {
    "fields": [
      {
        "description": "id",
        "name": "id",
        "type": "id"
      },
      {
        "description": "created_by",
        "name": "created_by",
        "type": "integer"
      },
      {
        "description": "created_at",
        "name": "created_at",
        "type": "integer"
      },
      {
        "description": "updated_at",
        "name": "updated_at",
        "type": "integer"
      },
      {
        "name": "String",
        "type": "string",
        "description": "string"
      }
    ]
  },
  "write_perm": [
    "user:*"
  ],
  "default_row_perm": {
    "_read_perm": [
      "user:anonymous"
    ],
    "_write_perm": [
      "user:*"
    ]
  },
  "created_at": 1519538564,
  "updated_at": 1519640477
}

字段如 id、created_by、created_at、updated_at 为自动添加的内置字段

返回参数说明

状态码说明

201: 修改成功

400: 表名已存在；不合法的数据

获取数据表详情

接口

tableSchema.getSchema(schemaID)

代码示例

• async/await
• promise

async function getSchema() {
  try {
    let tableSchema = new BaaS.TableSchema()
    let res = await tableSchema.getSchema(1)
    // success
    return res
  } catch(err) {
    // error
    throw err
  }
}

function getSchema() {
  let tableSchema = new BaaS.TableSchema()
  tableSchema.getSchema(1).then(res => {
    // success
    callback(null, res)
  }).catch(err => {
    // error
    callback(err)
  })
}

返回示例

res.data 结构如下

{
  "id": 1,
  "name": "Table",
  "protected_fields": null,
  "schema": {
    "fields": [
      {
        "name": "String",
        "type": "string"
      }
    ]
  },
  "write_perm": [
    "user:*"
  ],
  "default_row_perm": {
    "_read_perm": [
      "user:*"
    ],
    "_write_perm": [
      "user:*"
    ]
  },
  "created_at": 1519538564,
  "updated_at": 1519640477
}

状态码说明

200: 成功

获取数据表列表

tableSchema.getSchemaList({offset, limit})

参数说明

代码示例

• async/await
• promise

async funnction getSchemaList() {
  try {
    let res = await tableSchema.getSchemaList({limit:20, offset: 0})
    // success
    return res
  } catch(err) {
    // error
    throw err
  }
}

function getSchemaList() {
  tableSchema.getSchemaList({limit:20, offset: 0}).then(res=>{
    // success
    callback(null, res)
  }).catch(err => {
    // error
    callback(err)
  })
}

返回示例

res.data 结构如下

{
  "meta": {
    "limit": 20,
    "next": null,
    "offset": 0,
    "previous": null,
    "total_count": 1
  },
  "objects": [
    {
      "id": 1,
      "name": "Table",
      "protected_fields": null,
      "schema": {
        "fields": [
          {
            "name": "String",
            "type": "string"
          }
        ]
      },
      "write_perm": [
        "user:*"
      ],
      "default_row_perm": {
        "_read_perm": [
          "user:*"
        ],
        "_write_perm": [
          "user:*"
        ]
      },
      "created_at": 1519538564,
      "updated_at": 1519640477
    }
  ]
}

状态码说明

200: 成功

更新数据表

tableSchema.updateSchema(schemaID, schemaInfo)

数据表更新接口支持一次更新一个或多个字段

代码示例

• async/await
• promise

const schemaInfo = {
  name: "table"
}
async function updateSchema() {
  try {
    let res = await tableSchema.updateSchema(1, schemaInfo)
    // success
    return res
  } catch(err) {
    // error
    throw err
  }
}

const schemaInfo = {
  name: "table"
}
function updateSchema() {
  tableSchema.updateSchema(1, schemaInfo).then(res=>{
    // success
    callback(null, res)
  }).catch(err => {
    // error
    callback(err)
  })
}

返回示例

res.data 接口如下

{
  "id": 1,
  "name": "table",
  "protected_fields": null,
  "schema": {
    "fields": [
      {
        "name": "String",
        "type": "string"
      }
    ]
  },
  "write_perm": [
    "user:*"
  ],
  "default_row_perm": {
    "_read_perm": [
      "user:*"
    ],
    "_write_perm": [
      "user:*"
    ]
  },
  "created_at": 1519538564,
  "updated_at": 1519640477
}

状态码说明

200: 修改成功

400: 表名已存在；不合法的数据

删除数据表

tableSchema.deleteSchema(schemaID)

代码示例

• async/await
• promise

async function deleteSchema() {
  try {
    let res = await tableSchema.deleteSchema(1)
    // success
    return res
  } catch(err) {
    // error
    throw err
  }
}

function deleteSchema() {
  tableSchema.deleteSchema(1).then(res => {
    // success
    callback(null, res)
  }).catch(err => {
    // error
    callback(err)
  })
}

状态码说明

204: 删除成功