32 lines
729 B
Markdown
32 lines
729 B
Markdown
# cherrypy_sqlite_restapi
|
|
|
|
Simple, lightweight, universal SQLite API, based on cherrypy.
|
|
|
|
## Requirements:
|
|
1. universal
|
|
2. ssl / non-ssl versions
|
|
3. secure / cleanup of querries
|
|
4. DB/table specification
|
|
5. row inserts
|
|
6. row deletes
|
|
7. row modifies
|
|
|
|
## REST API
|
|
https://www.restapitutorial.com/
|
|
|
|
## Cherrypy http microframework / server
|
|
https://cherrypy.org/
|
|
|
|
## Progress
|
|
1. set up Cherrypy server as base for RESTAPI (matoumi)
|
|
- cherrypy base, config, root, ssl (later)?
|
|
- responses for /insert /select /delete /modify
|
|
|
|
2. classes and functions for DB operations and mapping
|
|
- INSERT
|
|
- SELECT
|
|
- DELETE
|
|
- MODIFY / ALTER
|
|
|
|
3. aggregate functions and complex queries mapping
|