How to create and query data on Edge SQL
Preview
Once you’ve created your Edge SQL database, you can begin creating tables and inserting data into them.
Go to Edge SQL referenceCreating a table
Run the following POST
request in your terminal, replacing [TOKEN VALUE]
with your personal token and {id_database}
with the ID of the database you want to create a table into:
curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \--header 'Authorization: Token [TOKEN VALUE]' \--header 'Content-Type: application/json' \--data '{ "statements": [ "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);" ]}'
You should receive the following response:
{ "state": "executed", "data": [ { "results": { "columns": [], "rows": [] } } ]}
Adding data into a table
Run the following POST
request in your terminal, replacing [TOKEN VALUE]
with your personal token and {id_database}
with the ID of the table you want to insert data into:
curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \--header 'Authorization: Token [TOKEN VALUE]' \--header 'Content-Type: application/json' \--data '{ "statements": [ "INSERT INTO users VALUES (1, '\''item 1'\'');", "INSERT INTO users VALUES (2, '\''item 2'\'');", "INSERT INTO users VALUES (3, '\''item 3'\'');" ]}'
You should receive the following response:
{ "state": "executed", "data": [ { "results": { "columns": [], "rows": [] } }, { "results": { "columns": [], "rows": [] } }, { "results": { "columns": [], "rows": [] } } ]}
Listing data in a table
Run the following POST
request in your terminal, replacing [TOKEN VALUE]
with your personal token and {id_database}
with the ID of the table you want to retrieve:
curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \--header 'Authorization: Token [TOKEN VALUE]' \--header 'Content-Type: application/json' \--data '{ "statements": [ "SELECT * FROM users;" ]}'
You should receive the following response:
{ "state": "executed", "data": [ { "results": { "columns": [ "id", "name" ], "rows": [ [ 1, "item 1" ], [ 2, "item 2" ], [ 3, "item 3" ] ] } } ]}
Contributors