A simple Database manager. You can manage database simply without using SQL or any other query language. The Inputs and outputs are in the form of JSON so you can simply share the data across networks. A simple SQL shell was attached to do more with Your Db.
Project description
#DataBaseManager A simple DataBaseManager manager. You can manage DataBaseManager simply without using SQL or any other query language. The Inputs and outputs are in the form of JSON so you can simply share the data across networks. A simple SQL shell was attached to do more with Your Db. Execute "pip install DataBaseManager" Then import it By Executing "import DataBaseManager"
#Supported DataBaseManagers: 1)SQLite
#SQLite 1)import:- 'from DataBaseManager import sqlite' 2)create object:- 'MyObj = sqlite("your file path") 3)If you want to create a new Db 'MyObj = sqlite()' 'MyObj.CreateDb("db name",{"table name":{"column":"type"}})' 4)For inserting data:- 'MyObj.insert("table name",[{"column1":"value1","column2":"value2"},{"column":"next items"}])' 5)for selecting:- 'MyObj.select(["table1","table2"],select=["table1.column","table2.column"],where={"table1.column":"value","table2.column":"value2"}))' This will return the data in the form of a list of the result tuples same as the form of fetchall() Use MyObj.parse_fetch_all() to get the data in the form of dictionary 5)For Getting shell:- "MyObj.shell('Any commands if you want')" 6)also have execute, executescript, commit, fetchone,fetchall etc. cursor same as the python sqlite3 7) execute MyObj.conn to return the connection 8) execute MyObj.schema to get the schema in the form of a dictionary 9) execute MyObj.tables to get the table names
sqlite shell info at:- https://techabam.000webhostapp.com/DataBaseManager/sqlite/shell.html More info on the link: https://techabam.000webhostapp.com/DataBaseManager
#Whats new
V0.0.2--new sqlite.Reload() to re initialize the class. for geting the changes that you change in the schema
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
File details
Details for the file DataBaseManager-0.0.2.tar.gz
.
File metadata
- Download URL: DataBaseManager-0.0.2.tar.gz
- Upload date:
- Size: 4.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.0 requests-toolbelt/0.9.1 tqdm/4.50.0 CPython/3.8.6
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | c8c58b52ddf6a5996b471f359d25601a5bad5c354a6e3512019c76ca54593134 |
|
MD5 | 644a63e6adbf0e6a314be8261d9a71f3 |
|
BLAKE2b-256 | 7371bd00731b4b86c04eb192372619b80869989f6bf39326fe27b3ae043cbcbf |