A small package that wraps MySQLdb for easy usage and encryption
mysqldb_wrapper is a python module that will help you easily communicate with your database and provides encryption with Fernet using the cryptography module. This module is inspired by SQLAlchemy but is even simpler to use and has less limitations (but is also less complete).
IMPORTANT: This module is only made to use with simple mysql queries. You can still use it with more complex queries, but no interface is provided for those.
This module is available via pip:
pip install mysqldb_wrapper
First, you need to create a
table. Here's an example:
from mysqldb_wrapper import Base, Id class Test(Base): __tablename__ = "test" id = Id() another_table_id = Id() hashed = bytes() number = int(1) string = str("string") boolean = bool(True)
To explain in details:
id = Id()is, as its name implies, the database object
id. Always put one Id.
another_table_id = Id()is the
idof another table in the database.
hashed = bytes()will be a hashed string, always declare it empty.
number = int(1)will be a int with a default value
string = str("string")will be a string with a default value
boolean = bool(True)will be a boolean with a default value
Easy, right ?
Note: This implementation does not support complex types, so keep your table simple ;)
You need to create your database by hand Although this module will not create the database for you, it will create the tables automatically !
Note: keep in mind that if your table change (remove fields, change field types, ...), you will need to remove/update them by hand.
To initialize a session with the database, use:
from mysqldb_wrapper import Session session = Session(DB_USERNAME, DB_PASSWORD, DB_TEST, FERNET_KEY)
So here we have:
DB_USERNAMEis the username of the mysql user
DB_PASSWORDis the password of the mysql user
DB_TESTis the name of the database
FERNET_KEYis the encryption key. You can create one with
Fernet.generate_key(), but keep in mind to always use the same one. (So generate one by hand then keep it somewhere safe)
And now we have all we need to use the mysql database.
Adding an object
Remember your table ? Just create a new object from it and use the
add method of the session with it. Also, the table objects supports
obj = Test(hashed="abcd", string="word") session.add(obj)
obj now automatically contains the id generated by the database. Also, this method returns the object in case you want to chain methods.
Updating an object
obj from before:
obj.number = 2553166 obj.string = "a sentence" obj.boolean = True session.update(obj)
This method also returns the object.
Deleting an object
obj now is not in the database anymore but you can still continue to use it, just remember it doesn't have an
id (set to 0). Like the others, this method returns the object.
We have more to talk about in this section.
obj = session.query(Test).first()
This one is easy. You put the table you want in
query() and you want to get the first result.
obj_list = session.query(Test).all()
Same than before, except this time you retrieve all the results. It is guaranteed to return a list, even if empty.
Now the tricky part:
obj = session.query(Test).where(Test.id == 2).first()
This time, we are still querying in the Test table, but we want a specific result, the one where the id is equal to 2. You don't have to worry about doing anything more, everything is handled by the
Base class your
Test table inherited from.
Remember we had a hash in our table ? Don't worry, it is handled as well. How does it work ? Like the others field. =)
obj = session.query(Test).where(Test.hashed == "abcd").first()
You can also chain the
where methods, use variables and query all objects:
a_string = "something" list_obj = session.query(Test).where(Test.another_table_id == 2).where(Test.hashed == a_string).all()
where method only works with equality as of now. Also, you can only query by Id and hashes.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size mysqldb_wrapper-0.3.0-py3-none-any.whl (7.0 kB)||File type Wheel||Python version py3||Upload date||Hashes View|
|Filename, size mysqldb_wrapper-0.3.0.tar.gz (10.3 kB)||File type Source||Python version None||Upload date||Hashes View|
Hashes for mysqldb_wrapper-0.3.0-py3-none-any.whl