Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
example¶
This is an example table spec.
Platform support¶
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: example
- Windows
- Linux
- Mac OSX
- Free BSD
Table schema¶
Name | Type | Description |
---|---|---|
name | TEXT | Description for name column |
points | INTEGER | This is a signed SQLite int column |
size | BIGINT | This is a signed SQLite bigint column |
action | TEXT | Action performed in generation |
id | INTEGER | An index of some sort |
path | TEXT | Path of example |
Query examples¶
select * from example where id = 1
select name from example where action = 'new'
select e.* from example e, example_environments ee where e.id = ee.id