dyne / restroom-mw

🛠 Easy REST API builder executing Zencode
https://restroom.dyne.org
GNU Affero General Public License v3.0
3 stars 11 forks source link

Add statement to run SQL query #46

Closed andrea-dintino closed 2 years ago

andrea-dintino commented 3 years ago

A statement like:

I execute the query 'myQuery' into the database 'mySqlite'

With data:

{
"mySqlite": "'sqlite:///home/site/public_html/sqlite.db", 
"myQuery": "CREATE TABLE [IF NOT EXISTS] Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);"

}