database structure layer for my personal server.

pip install lapa_database_structure

• create a package with package name as database name.

• add package in database_name package with schema name as package name.

• 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.

• 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.

None

• python>=3.12.0

lapa and lapa_testing

• authentication
  • rename user_session_hashed_refresh_token to user_session_refresh_token

lapa and lapa_testing

• authentication
  • remove device table and remove references of device in user_device_session (old name).
  • add session_expiry_time in user_session table.
• public
  • add table for testing.

lapa and lapa_testing

• authentication
  • naming convention changes to tables and columns.
  • make user_id unique in user_credential table. (1 user can have only 1 username-password)
  • make user_id unique in user_profile table. (1 user can have only 1 profile)
  • add auto increment to user_log_id and user_device_session_id. (primary keys)
  • introduce device_id in device table.
  • assign foreign key to user_id in user_device_session table.
  • introduce foreign key device_id to user_device_session table.
  • make device_encrypted_mac_address unique in device table. (unencrypted mac address is supposed to be unique)
  • make user_device_session_hashed_refresh_token unique in device table. (plaintext refresh token is supposed to be unique)

• removed UserAuthentication
• renamed user_authentication -> credential
• new table device and user_device_session

• removed salt authentication_username_salt column

• renamed authentication_username_salt.
• added local_string_database_name in each database.
• removed main.py file and its enums.

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

• Overhauled authentication schema, again.

• Overhauled authentication schema,
• introducing new tables: User, UsernameAuthentication, UserProfile, AuthenticationType, UserAccountStatus, UserLog, and UserLogStatus.

• changed db structure
• removed game db
• added testing db which is clone of lapa

• file_storage -> public -> File
  • change file_extension to file_content_type.
  • file_system_relative_path default change from "." to "".

• authentication database added with the below tables
  • user
  • user_validation_status
  • user_registration
  • hashing_algorithm

• Changed package name to lapa_database_structure.

• Update table for file_storage -> File.

• initial implementation.