DEV Community

Momin Iqbal
Momin Iqbal

Posted on

HadiDB: A Lightweight, Horizontally Scalable Database in Python

#database #mongodb #hadidb #mysql

Downloads

HadiDB

HadiDB is a lightweight, highly horizontally scalable database written in Python.

How to install hadidb 

pip install hadidb
Enter fullscreen mode Exit fullscreen mode

Create User HadiDB

Creates a new user with the example username admin and example password admin using createUser(). It then authenticates the same user by calling the authentication() method.

from HadiDB.operation import User user = User("admin", "admin") user.createUser() # Creating a new user in the HadiDB user.authentication() # Authenticating the HadiDB user
Enter fullscreen mode Exit fullscreen mode
Result: 
{'status': 200, 'message': 'Database user Created'}
Enter fullscreen mode Exit fullscreen mode

Create Databse , Collection and Schema

This code sets up user credentials and a schema for a database collection. It initializes a database operation using the Operation class with the specified username, password, database, and collection. Finally, it inserts the provided data into the collection and stores the result.

from HadiDB.operation import Operation username = "admin" password = "admin" database = "mefiz.com" collection = "authUser" schema = { "username":"Unique", "password":"Hash", "cnic":"Unique", "picture":"Image", "bio":"Text" } db = Operation(username,password,database,collection) db.create_database(schema)
Enter fullscreen mode Exit fullscreen mode

Insert Data

Insert Data into the Collection use db.insert(data) inserts the data into the specified database collection.

from HadiDB.operation import Operation username = "admin" password = "admin" database = "mefiz.com" collection = "authUser" db = Operation(username,password,database,collection) data = { "username":"hadidb", "password":"12345", "cnic":"123232442", "picture":"user/my/hadidb.jpg", "bio":"HadiDB is the Best ;)" } result = db.insert(data) print(result)
Enter fullscreen mode Exit fullscreen mode
Result: 
{ 'status': 200, 'message': 'Data insert successfully', 'data': { 'username': 'hadidb', 'password': '12345', 'cnic': '123232442', 'picture': 'user/my/hadidb.jpg', 'bio': 'HadiDB is the Best ;)', 'id': 1 } }
Enter fullscreen mode Exit fullscreen mode

Update Data

Update Data db.update(1, update_data) updates the record with the ID 1 in the database using the provided update_data.

from HadiDB.operation import Operation username = "admin" password = "admin" database = "mefiz.com" collection = "authUser" db = Operation(username,password,database,collection) update_data = { "username": "hadidb_update", "password": "123455", "cnic": "1232324423", "picture": "user/my/hadidb1.jpg", "bio": "HadiDB is the Best ;) update bio" } result = db.update(1,update_data) print(result)
Enter fullscreen mode Exit fullscreen mode
Result: 
{ 'status': 200, 'message': 'Data Update successfully', 'data': { 'username': 'hadidb_update', 'password': '123455', 'cnic': '1232324423', 'picture': 'user/my/hadidb1.jpg', 'bio': 'HadiDB is the Best ;) update bio', 'id': 1 } }
Enter fullscreen mode Exit fullscreen mode

GetByID

The unique identifier (ID) of the document you want to retrieve specific object or an error if the document does not exist.

result = db.getbyID(1) print(result)
Enter fullscreen mode Exit fullscreen mode

Get All Object

The getAll method retrieves all documents from the specified collection in the database.

result = db.getAll() print(result)
Enter fullscreen mode Exit fullscreen mode

GetByKey

The getbykey method retrieves all documents from the database where the specified key-value pair matches. Not Support multi keys values pairs

result = db.getbykey({ "username":"momin" }) print(result)
Enter fullscreen mode Exit fullscreen mode

GetByKeys

The getbykeys function uses an implicit AND (&&)operation. Both conditions Example (cnic and bio) if matched key values in the database then return the matched object.

result = db.getbykeys({ "cnic":"123232442", "bio":"HadiDB is the Best ;) update bio" }) print(result)
Enter fullscreen mode Exit fullscreen mode

Count

The count method returns the total number of documents (or objects) present in the specified collection in the database.

result = db.count() print(result)
Enter fullscreen mode Exit fullscreen mode
Result: 
{'status': 200, 'count': 1}
Enter fullscreen mode Exit fullscreen mode

GeyByKeyCount

The getbykeyCount method counts the number of documents in the collection where the specified key-value pair matches.

result = db.getbykeyCount({ "username":"momin" })
Enter fullscreen mode Exit fullscreen mode

Delete

Deletes a document from the database by its unique identifier (id)

result = db.delete(1) print(result)
Enter fullscreen mode Exit fullscreen mode
Reuslt: 
{'status': 200, 'message': 'data delete successful'}
Enter fullscreen mode Exit fullscreen mode

Get All Database

Retrieves all available databases by using the get_database() method of the Configuration class

from HadiDB.operation import Configuration print(Configuration().get_database())
Enter fullscreen mode Exit fullscreen mode

Get All Collection

Retrieves all collections from a specific database using the get_collection() method of the Configuration class.

from HadiDB.operation import Configuration database = "mefiz.com" print(Configuration(database).get_collection())
Enter fullscreen mode Exit fullscreen mode

Get Schema of Specfic Collection

Return Schema of a specific collection by using get_schema()method from the Configuration class.

from HadiDB.operation import Configuration database = "mefiz.com" collection = "authUser" print(Configuration(database,collection).get_schema())
Enter fullscreen mode Exit fullscreen mode

Delete Collection

Deletes a specific collection from a database using the deleteCollection() method of the DatabaseDeletionService class.

from HadiDB.operation import DatabaseDeletionService db = DatabaseDeletionService(username,password,database,collection) print(db.deleteCollection())
Enter fullscreen mode Exit fullscreen mode

Delete Database

Deletes Database using the deleteDatabase() method of the DatabaseDeletionService class.

from HadiDB.operation import DatabaseDeletionService db = DatabaseDeletionService(username,password,database,collection) print(db.deleteDatabase())
Enter fullscreen mode Exit fullscreen mode
GitHub : https://github.com/MominIqbal-1234/hadidb
Check Site : https://mefiz.com
Developed by : Momin Iqbal

Top comments (0)