pyfast-sqlite

Fast_sqlite

Fast SQL is a Python library to make and use a sqlite3 database. For use this library you can copy the file in your code directory and use below codes or read src/example/write_and_read_data.py file

Create values to use library

from fast_sql import fast_sqlite

fsql = fast_sqlite(db_name="database.db", table_name="users", attributes=["username", "email", "password"])

Connect to a database

fsql.connect()
# Congratulation! You have been connected :)

Close connection

fsql.close()
# Oh... You have been disconnected :( 
# We will work together for next time

Insert data in database

fsql.Insert_in(values=["admin", "[e-mail]", "admin"]) # output: True/False

# This is how it save:
# --> users:
#      ________________________________________________________________
#     |                |                         |                     |
#     |    username    |          email          |       password      |
#     |________________|_________________________|_____________________|
#     |                |                         |                     |
#     |     admin      |     admin.root@ad...    |        admin        |
#     |                |                         |                     |
#     |     user1      |     user.1234@use...    |        12345        |
#     |                |                         |                     |
#     |________________|_________________________|_____________________|

Select data from database

#                    select "password", where username='username'
password = fsql.Select_from("password", "username", username) # output: password

Use a custome command

output = fsql.Custome_command("command") # output: output of your command :)
print(output)

Contributes

1.Unknow-per