Class SQL

Example

const result = await Resources.sql.create({
  name: "Latest temperature",
  query: "SELECT variable, value, time FROM device($1) AS d WHERE variable = 'temperature' ORDER BY time DESC LIMIT 10",
  params: [{ key: "$1", value: "my-device-id" }],
});
console.log(result); // { id: 'query-id-123', name: 'Latest temperature', ... }
Copy

Example

const result = await Resources.sql.delete("query-id-123");
console.log(result); // { id: 'query-id-123' }
Copy

Example

const result = await Resources.sql.edit("query-id-123", {
  name: "Latest temperature",
  query: "SELECT variable, value, time FROM device($1) AS d ORDER BY time DESC LIMIT 20",
  params: [{ key: "$1", value: "my-device-id" }],
});
console.log(result); // { id: 'query-id-123', version: 2, ... }
Copy

Example

If receive an error "Authorization Denied", check policy SQL Query / Execute in Access Management.

const result = await Resources.sql.execute("query-id-123", {
  params: [{ key: "$1", value: "my-device-id" }],
});
console.log(result); // { columns: [...], rows: [...], row_count: 1, ... }
Copy

Example

const result = await Resources.sql.getVersion("query-id-123", 1);
console.log(result); // { query: 'SELECT ...', params: [], created_at: ... }
Copy

Example

If receive an error "Authorization Denied", check policy SQL Query / Access in Access Management.

const result = await Resources.sql.info("query-id-123");
console.log(result); // { id: 'query-id-123', name: 'My query', query: 'SELECT ...', ... }
Copy

Example

If receive an error "Authorization Denied", check policy SQL Query / Access in Access Management.

const result = await Resources.sql.list({
  page: 1,
  fields: ["id", "name", "tags"],
  amount: 20,
});
console.log(result); // [ { id: 'query-id-123', name: 'My query', tags: [] } ]
Copy

Example

const result = await Resources.sql.tables({ filter: "sensor", amount: 20 });
console.log(result); // { tables: [...], resources: { devices: [...], entities: [...] } }
Copy