Skip to main content

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 DataBases:

1)SQLite

multiprocess:

now (v0.0.5) supports multi processing. manage multiple databases(0-infinity) By multiprocess object. one command to manage mulitple databases!. More info given below..

view: https://techabam.000webhsotapp.com/DbManager/

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 10)to start a multiprocess:- 'from DataBaseManager import multiprocess' 'MyObj = multiprocess(your_data_base("database name"),your_second_database("databasename"))' your data base name may be sqlite or any other DataBaseManager Supports. execute MyObj.insert, update ,execute,executescript,select, commit, etc. as same in the other db objects

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.5--new multiprocess object for using mulitple processes at the same time

Versions

v0.0.1=>old stable Versions not stable v0.0.2=>error in this version import prints a while loop v0.0.3=>Stable version not recommended v0.0.4=>fixed bugs. not supported multiprocess object. not recommended v0.0.5=>new object multiprocess for manageing multiple database at the same time. Latest

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

DataBaseManager-0.0.5.linux-aarch64.tar.gz (9.3 kB view details)

Uploaded Source

File details

Details for the file DataBaseManager-0.0.5.linux-aarch64.tar.gz.

File metadata

  • Download URL: DataBaseManager-0.0.5.linux-aarch64.tar.gz
  • Upload date:
  • Size: 9.3 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

Hashes for DataBaseManager-0.0.5.linux-aarch64.tar.gz
Algorithm Hash digest
SHA256 11c58f5b5a8b66b0357d326d88bf43932e5c92f92637a45389ddec9bacd95727
MD5 b1f296a29f4a28b54ef33cd1ed72f56e
BLAKE2b-256 cbe85d4ce236911118250587cc59e925bee8ec61808fd60296b51386b192295f

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page