OOP abstraction/wrapper for work with SQL data bases
Project description
OOPDB
OOPDB - OOP wrapper for work with database. For now it's based on sqlite3 python lib.
Supported database features
- Data types
- Integer (DataTypes.INTEGER) - simple type for storing integer numbers
- Text (DataTypes.TEXT) - simple type for storing text/strings with a maximum length of 65'535 bytes
- Column configurations
- Column config - base abstraction for describing column configuration using folowing information
- Name
- Nullability [- x] -ype - type from DataTypes
- Primary key - abstraction based on column config abstraction using following additional information
- Autoincrement
- Foreign key - abstraction based on column config abstraction using following additional information
- Reference table name
- Reference column name
- Column config - base abstraction for describing column configuration using folowing information
- Commands
- Create table - creates table with the given name and list of column configurations
- Select - select data from the given table and list of given column names in the table
- Table names - get all table names that are exist in database
- Column names - get all column names that are exist in the table with the given table name
- Insert into - append row values to the table with the given name and list of column names
- Select count - select row count from the table with the given name
- Inner join - merges two tables with the given table names and column names
- Order by - sort result by the given lists of column names and orders for each column
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
oopdb-0.0.4.tar.gz
(4.5 kB
view hashes)
Built Distribution
oopdb-0.0.4-py3-none-any.whl
(5.0 kB
view hashes)