QuickSQLConnector
SQL in one line
Install / Use
/learn @Anas-Dew/QuickSQLConnectorREADME
Developers are struggling to execute a query and what if you need to execute another query somewhere else? That's a lot of code to rewrite again. You don't have to do this because QuickSQLConnector got you covered!. <a href="https://quicksqlconnector.web.app/">Quick SQL Connector</a> is a python library that lets you execute MySQL, PostgreSQL, and SQLite queries with just one line of code.
Reducing 80% lines of code and get more done and it's all done in the same syntax with all SQL databases mentioned.
Installation 💿
USING PIP
pip install quicksqlconnector
FOR LINUX FRIENDS
python3 pip install quicksqlconnector
To update Quick SQL Connector to the latest version, add --upgrade flag to the above commands.
Write your first query.
Use 'quicksqlconnector' keyword to import
from quicksqlconnector import quicksqlconnector
Creating instance of module
DB = quicksqlconnector('database','host', port, 'username', 'password')
NOTE : If you're using SQLite, you must provide database file name as follows.
DB = quicksqlconnector('sqlite3', database_name='my_example_database')
For database, it has 3 options (case-sensitive).
mysqlsqlite3postgres
quicksqlconnector only have one method which is 'query'.
DB.query('query','parameters:optional')
FOR SQLite, you don't need to use parameterized quieries as it is not supported in SQLite.
It has two arguments, query and parameters, parameters are optional.
# EXAMPLES FOR 'MYSQL'
DB.query("SELECT * FROM test where id= %s", (input_user,))
DB.query("SELECT * FROM test")
DB.query('CREATE TABLE test(name varchar(10), id int(10))')
DB.query("INSERT INTO test values(%s, %s)", ('harry', 13))
# EXAMPLES FOR 'SQLITE'
DB.query('DROP TABLE movie')
DB.query("CREATE TABLE movie(title varchar(1), year int(1), score int(1))")
# EXAMPLE FOR 'POSTGRESQL'
DB.query('SELECT datname FROM pg_database')
See test.py for more examples.
🔗Useful Links
| Route | Link | | ----------- | ----------- | | Buy me a Coffee | Visit | | Email | Visit| | PyPi | Visit | | Website | Visit|
