Metadata-Version: 2.1
Name: lapa_database_structure
Version: 0.0.9
Summary: database layer for my personal server.
Home-page: https://github.com/B21amish/lapa_database_structure
Author: Amish Palkar, thePmSquare, Lav Sharma, Aaditya Sangishetty
Author-email: amishpalkar302001@gmail.com, thepmsquare@gmail.com, lavsharma2016@gmail.com, adityasehtty35@gmail.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.9
Description-Content-Type: text/markdown

# 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.9

- rename authentication_username_hashed_access_token and authentication_username_hashed_refresh_token.
- update enum in main.py.

### 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!


