database layer for my personal server.
Project description
lapa_database_structure
about
database structure layer for my personal server.
installation
pip install lapa_database_structure
usage
to add a new database
- create a package with package name as database name.
to add a new schema
- add package in database_name package with schema name as package name.
to add a new table
- create /database_name/schema_name/tables.py file if not already created.
- create class corresponding to your new table add in /database_name/schema_name/tables.py file.
to add default data in table
- append row objects containing your default data to the data_to_insert list inside the /database_name/schema_name/tables.py file.
do not forget to add new database_names, schema_names and/or table_names to main.py enums to make it accessible through api calls.
do not forget to clone changes to all testing database.
configs
None
env
- python>=3.12.0
changelog
v0.0.8
- Overhauled authentication schema, again.
v0.0.7
- Overhauled authentication schema,
- introducing new tables: User, UsernameAuthentication, UserProfile, AuthenticationType, UserAccountStatus, UserLog, and UserLogStatus.
v0.0.6
- changed db structure
- removed game db
- added testing db which is clone of lapa
v0.0.5
- file_storage -> public -> File
- change file_extension to file_content_type.
- file_system_relative_path default change from "." to "".
v.0.0.4
- authentication database added with the below tables
- user
- user_validation_status
- user_registration
- hashing_algorithm
v0.0.3
- Changed package name to lapa_database_structure.
v0.0.2
- Update table for file_storage -> File.
v0.0.1
- initial implementation.
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
Built Distribution
Close
Hashes for lapa_database_structure-0.0.8.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 616cb8e852ec90b5a4b9d20428fdf3c660fd13f08a044fc1958a2bedb5f2f517 |
|
MD5 | 16bdb503a94b80de9d4625fc0bd84eb6 |
|
BLAKE2b-256 | b7e1a5c07c4eed48e0dda2e9143180963d07a936bbf658c769b388422e506720 |
Close
Hashes for lapa_database_structure-0.0.8-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 68023c8fc99c0c88b350aba223a787a8e2834bf4573b12a3272a8da4bbe2bc38 |
|
MD5 | 89a494f75ab24e6de8a611413eacedd4 |
|
BLAKE2b-256 | 544566f216a1be793fc4d8333e8114dd470727ced502cd0b5900850b740c6f64 |