🚀 Big News: Socket Acquires Coana to Bring Reachability Analysis to Every Appsec Team.Learn more
Socket
Book a DemoInstallSign in
Socket

pyfast-sqlite

Package Overview
Dependencies
Maintainers
1
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

pyfast-sqlite

Fast_sqlite is a library to use sqlite database faster and easier.

0.1.1
PyPI
Maintainers
1

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", "admin.root@admin.com", "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

FAQs

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts