A library with the sole purpose of making connections to mysql databases easier
Project description
eto-mysql-databaselib
OK SO MOST IMPORTANT THING, IF YOU WANNA USE THIS LIB YOU NEED TO HAVE A MYSQL DATABASE ONLINE,THEN, THE MOST IMPORTANT STUFF TO DO IS THIS ( IF YOU DON'T DO THIS AND TRY TO USE ANY OTHER THING IN THE PACKAGE, IT WILL NOT WORK, SINCE THE basemysqldatabaselib module IS THE BASE MODULE OF THE PROJECT, EVERYTHING DEPENDS ON IT ):
def main():
from databaselib import basemysqldatabaselib, databaseAbstractions
basemysqldatabaselib.database = basemysqldatabaselib.Database("your host here", "your database username here", "your database password here", "your database name here")
basemysqldatabaselib.conn = basemysqldatabaselib.connect()
if __name__ == "__main__":
main()
LIBRARY USAGE EXAMPLES
Register example
from databaselib import basemysqldatabaselib, databaseAbstractions
from databaselib.databaseDevFriendlyAbstraction import User
def main():
basemysqldatabaselib.database = basemysqldatabaselib.Database("your host here", "your database username here", "your database password here", "your database name here")
basemysqldatabaselib.conn = basemysqldatabaselib.connect()
username:str = input("Insert your username: ")
password:str = input("Insert your password: ")
user:User = databaseAbstractions.registerUser(username, password)
if user == None:
print("User with that username already exists!")
return
print(user)
if __name__ == "__main__":
main()
Login example
from databaselib import basemysqldatabaselib, databaseAbstractions
from databaselib.databaseDevFriendlyAbstraction import User
def main():
basemysqldatabaselib.database = basemysqldatabaselib.Database("your host here", "your database username here", "your database password here", "your database name here")
basemysqldatabaselib.conn = basemysqldatabaselib.connect()
username:str = input("Insert your username: ")
password:str = input("Insert your password: ")
user:User = databaseAbstractions.loginUser(username, password)
if user == None:
print("Wrong password!")
return
print(user)
if __name__ == "__main__":
main()
User edit example
from databaselib import basemysqldatabaselib, databaseAbstractions
from databaselib.databaseDevFriendlyAbstraction import User
def main():
basemysqldatabaselib.database = basemysqldatabaselib.Database("your host here", "your database username here", "your database password here", "your database name here")
basemysqldatabaselib.conn = basemysqldatabaselib.connect()
username:str = input("Insert your username: ")
password:str = input("Insert your password: ")
user:User = databaseAbstractions.loginUser(username, password)
if user == None:
print("Wrong password!")
return
print(user)
new_username:str = input("Insert your new username")
new_password:str = input("Insert your new password")
# edits both the username and the password
edited_user = databaseAbstractions.editUser(user, new_username, new_password)
if edited_user == None:
print("Something went wrong while editing the user!")
return
print(edited_user)
# only edits the username
#edited_user = databaseAbstractions.editUser(user, new_username=new_username)
# only edits the password
#edited_user = databaseAbstractions.editUser(user, new_password=new_password)
if __name__ == "__main__":
main()
OR
from databaselib import basemysqldatabaselib, databaseAbstractions
from databaselib.databaseDevFriendlyAbstraction import User
def main():
basemysqldatabaselib.database = basemysqldatabaselib.Database("your host here", "your database username here", "your database password here", "your database name here")
basemysqldatabaselib.conn = basemysqldatabaselib.connect()
username:str = input("Insert your username: ")
password:str = input("Insert your password: ")
user:User = databaseAbstractions.loginUser(username, password)
if user == None:
print("Wrong password!")
return
print(user)
new_username:str = input("Insert your new username ( it needs to be different than the current one ): ")
new_password:str = input("Insert your new password ( it needs to be different than the current one ): ")
# edits the username
user.username = new_username
if new_username == username:
print("Something went wrong while editing the user's username!")
return
# edits the password
user.password = new_password
if new_password == password:
print("Something went wrong while editing the user's password!")
return
print(user)
if __name__ == "__main__":
main()
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
Built Distribution
Close
Hashes for eto_mysql_databaselib-1.1.5.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 156860033e29a62451c21d26239817002aa6e0fd04b1dd3d9872775c4ce95784 |
|
MD5 | e7c5b3622307b68a89f5b73b84658d22 |
|
BLAKE2b-256 | c1304784fc0bf4f1234828a086acf0ac2906ab6edddb21d08bc9d02c10a36dfc |
Close
Hashes for eto_mysql_databaselib-1.1.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dbd438e9c9abb83ffba61def0d01bf65a11e1369e4f135fe2ade74bd9430e9b4 |
|
MD5 | 5b3e3f2c1a22e9f981b34e9d76546b85 |
|
BLAKE2b-256 | 7aeed5d1747b28c46a06bdab92fb1b063314002f8415deb0971224cdf2bd0ac9 |