database layer for my personal server.
Project description
lapa_database
about
database layer for my personal server.
installation
pip install lapa_database[all]
usage (WIP)
config.example.ini to config.ini.
CREATE_SCHEMA = True to create database from scratch.
LOG_FILE_NAME and configure logger
link to lapa_database_structure
configs
- lapa_database\data\config.ini (can be created using lapa_database\data\config.example.ini)
- lapa_logger\data\config.ini
env
- python>=3.12.0
changelog
v0.0.6
- change default value of ignore_filters_and_get_all to False.
v0.0.5
- make crud logic default to no rows when filters are empty.
- add new parameters to make it easy to select all rows for edit, delete and get.
- move logger to configuration.py to fix bug of multiple logs being created.
v0.0.4
- rename to lapa database.
- fix bug in create_database that occurred in default data insertion.
- add logs to gitignore.
- change psycopg2 to psycopg2-binary in setup.py.
v0.0.3
- created utils folder containing CommonOperations.py under which the common functions used across modules are stored.
- web_socket implemented for retrieving the data from the table when a new row is added/deleted/updated.
- it takes database_name, table_name and schema_name as input through query params.
- input for websocket
- /ws/<database_name>/<table_name>/<schema_name>
- E.g. /ws/game/player/public
- /ws/<database_name>/<table_name>/<schema_name>
- initially returns all the rows and if any update is made it returns the updated data.
- trigger creation is implemented once the websocket connection is made. it will first check if the trigger function already exists or not and then only create.
v0.0.2
- remove databases folder and enums related to tables and put in separate module for better version control.
- add proper error message display on errors in configuration.py.
- known bugs:
- creating engines everytime on fastapi route call is creating idle sessions.
v0.0.1
- initial implementation.
- known bugs:
- creating engines everytime on fastapi route call is creating idle sessions.
Feedback is appreciated. Thank you!
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
lapa_database-0.0.6.tar.gz
(10.8 kB
view hashes)
Built Distribution
Close
Hashes for lapa_database-0.0.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1cc0d58728ce6e5ff088bab41535701ef957102e4253019e8907a9eccfdb5764 |
|
MD5 | 55d25da426b22fe2c0492905b2a9301d |
|
BLAKE2b-256 | 3b45f84e24f60676d832c0fdfa2ec52ee520fb737760e388c3df0c6f1d3b2bd5 |