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

Name	Type	Description
database_name*	nameString	The name of the database you want to create.

200: OK If all parameters are correct, database is created successfully.

400: Bad Request ERROR CODE: 111001 Deserialization error. Check the format of your request data.

Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.

500: Internal Server Error ERROR CODE: 111002 Internal server error. Please try again later.

500: Internal Server Error ERROR CODE: 111003 Something unexpected happened on the server.

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

Name	Type	Description
database_name*	nameString	Database name you want to check

200: OK If all parameters are true, the check completes successfully and returns the answer to you as JSON.

400: Bad Request If some of the parameters you send are wrong, you will get error code 400.

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

Name	Type	Description
database_name*	nameString	The database name you will delete.

200: OK If all parameters are correct, the database will be deleted successfully.

400: Bad Request ERROR CODE: 111001 Deserialization error. Check the format of your request data.

Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.

500: Internal Server Error ERROR CODE: 111002 Internal server error. Please try again later.

500: Internal Server Error ERROR CODE: 111003 Something unexpected happened on the server.

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

Name	Type	Description
database_name*	nameString	The database name you will process.
table_create_query*	tableCreateQueryString	Query to be run to create a table.

200: OK If all parameters are correct, the table will be created successfully with the query you submit.

400: Bad Request ERROR CODE: 111001 Deserialization error. Check the format of your request data.

Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.

500: Internal Server Error ERROR CODE: 111002 Internal server error. Please try again later.

500: Internal Server Error ERROR CODE: 111003 Something unexpected happened on the server.

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

Name	Type	Description
database_name*	nameString	The database name you will process.
table_name*	tableNameString	Name of the table you want to delete.

200: OK If all parameters are correct, the table will be deleted successfully.

400: Bad Request ERROR CODE: 111001 Deserialization error. Check the format of your request data.

Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.

500: Internal Server Error ERROR CODE: 111002 Internal server error. Please try again later.

500: Internal Server Error ERROR CODE: 111003 Something unexpected happened on the server.

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

Name	Type	Description
database_name*	nameString	The database name you will process.
table_name	tableNameString	Table name you want to check

200: OK If all parameters are true, the check completes successfully and returns the answer to you as JSON.

400: Bad Request If some of the parameters you send are wrong, you will get error code 400.

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

Name	Type	Description
database_name*	nameString	The database name you will process.
query*	queryString	The query you want to run.

200: OK If all parameters are correct, the query will be executed successfully.

400: Bad Request ERROR CODE: 111001 Deserialization error. Check the format of your request data.

Please send all parameters. key -> Your data key. --- defaultValue -> If data is null return default value.

500: Internal Server Error ERROR CODE: 111002 Internal server error. Please try again later.

500: Internal Server Error ERROR CODE: 111003 Something unexpected happened on the server.

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.