SQLite API
Database Routes
Create Database
POST http://lyour_local_ip:49761/sqlite/create/database/
You can create a database with this link. If the database name already exists, you will not get any error.
Request Body
database_name*
nameString
The name of the database you want to create.
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Check Is Database Exist
GET http://lyour_local_ip:49761/sqlite/is/database/exist/
If you want to check if a certain database name already exists, you can use this link.
Query Parameters
database_name*
nameString
Database name you want to check
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Delete Database
DELETE http://lyour_local_ip:49761/sqlite/delete/database/
You can delete a database with this link. It is enough to send the name of the database you want to delete.
Request Body
database_name*
nameString
The database name you will delete.
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Table Routes
Create Table
POST http://lyour_local_ip:49761/sqlite/create/table/
You can create a table with this link. You can send the SQLite table creation query to create a table. This query will be executed on the server.
Request Body
database_name*
nameString
The database name you will process.
table_create_query*
tableCreateQueryString
Query to be run to create a table.
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Delete Table
DELETE http://lyour_local_ip:49761/sqlite/delete/table/
You can delete a table with this link. It is enough to send the database name and the name of the table you want to delete.
Request Body
database_name*
nameString
The database name you will process.
table_name*
tableNameString
Name of the table you want to delete.
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Check Is Table Exist
GET http://lyour_local_ip:49761/sqlite/is/table/exist/
If you want to check if a certain table name already exists, you can use this link.
Query Parameters
database_name*
nameString
The database name you will process.
table_name
tableNameString
Table name you want to check
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Run Query Route
SQLite Query
POST http://lyour_local_ip:49761/sqlite/query/
With this link you can perform all CRUD operations using SQLite syntax. The query you send will be executed on the server and the operation you want to do will be performed successfully.
Request Body
database_name*
nameString
The database name you will process.
query*
queryString
The query you want to run.
Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.
Please remember. When you use the links above, database_name is created even if there is no database when the server starts processing for the database in the links you send.
Last updated
Was this helpful?