Py-Simple-DB
Install:
pip install PySimpleDB
Load:
from PySimpleDB import DataBase
mydb = DataBase("simple.bd")
mydb_unique = DataBase("unique.bd", unique="user")
You can use a database in which the unique key will be a number, or specify your own name for the unique key, which will need to be transmitted
Add row:
This command automatically saves the state of the database.
mydb.add(name="Hello", last_name="world", gender="male") # any values
mydb_unique.add(user="User1", name="Hello world", gender="male") # any values
# ^ unique key
Make sure you are passing in a unique key for the appropriate database.
As in this example, the unique key is the "user" argument specified during initialization.
Find:
Returns the id of the first matched element, or an array of ids.
id_first = mydb.find(name="Hello") # 0
id_array = mydb.find_all(gender="male") # [0...]
id_first_unique = mydb_unique.find(gender="male") # "User1"
id_array_unique = mydb_unique.find_all(gender="male") # ["User1"...]
Get row:
Returns value by id.
mydb.get(id_first) # {"name": "Hello", "last_name": "world", "gender": "male"}
mydb_unique.get(id_first_unique) # {"name": "Hello world", "gender": "male"}
Delete row:
This command automatically saves the state of the database.
mydb.delete(id_first)
mydb_unique.delete(id_first_unique)
Save:
mydb.save()
Get All Data:
Allows you to get the whole database.
mydb.get_all()
or
mydb.data