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.
[](https://pepy.tech/project/quicksqlconnector) [](https://badge.fury.io/py/quicksqlconnector) [](https://pypi.python.org/pypi/ansicolortags/) [](https://shields.io/)
## 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).
* ```mysql```
* ```sqlite3```
* ```postgres```
> 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](https://github.com/Anas-Dew/QuickSQLConnector/blob/main/src/quicksqlconnector/test.py).
## 🔗Useful Links
| Route | Link |
| ----------- | ----------- |
| Buy me a Coffee | [Visit](https://www.buymeacoffee.com/anasraza) |
| Email | [Visit](mailto:anasraza1@yahoo.com)|
| PyPi | [Visit](https://pypi.org/project/quicksqlconnector/) |
| Website | [Visit](https://quicksqlconnector.web.app/)|
Raw data
{
"_id": null,
"home_page": "https://quicksqlconnector.web.app/",
"name": "quicksqlconnector",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "quicksqlconnector,sql,database,mysql,postgres,sqlite3",
"author": "Anas Raza",
"author_email": "anasraza1@yahoo.com",
"download_url": "https://files.pythonhosted.org/packages/fb/ba/981abf0ac9c264dca7c4f1cbe5a28ff245c0dbf85e95a9c50c3aae234e1c/quicksqlconnector-1.5.3.tar.gz",
"platform": null,
"description": "\n\nDevelopers 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. \n\nReducing 80% lines of code and get more done and it's all done in the same syntax with all SQL databases mentioned.\n\n[](https://pepy.tech/project/quicksqlconnector) [](https://badge.fury.io/py/quicksqlconnector) [](https://pypi.python.org/pypi/ansicolortags/) [](https://shields.io/)\n\n\n\n## Installation \ud83d\udcbf\n\n> USING PIP\n\n pip install quicksqlconnector\n\n> FOR LINUX FRIENDS\n\n python3 pip install quicksqlconnector\n\nTo update Quick SQL Connector to the latest version, add --upgrade flag to the above commands.\n\n## Write your first query.\n\n### Use 'quicksqlconnector' keyword to import\n\n from quicksqlconnector import quicksqlconnector\n\n### Creating instance of module\n\n DB = quicksqlconnector('database','host', port, 'username', 'password')\n\n NOTE : If you're using SQLite, you must provide database file name as follows.\n\n DB = quicksqlconnector('sqlite3', database_name='my_example_database')\n\nFor database, it has 3 options (case-sensitive).\n* ```mysql```\n* ```sqlite3```\n* ```postgres```\n\n> quicksqlconnector only have one method which is 'query'.\n\n DB.query('query','parameters:optional')\n\n FOR SQLite, you don't need to use parameterized quieries as it is not supported in SQLite.\n\n> It has two arguments, query and parameters, parameters are optional.\n \n # EXAMPLES FOR 'MYSQL'\n\n DB.query(\"SELECT * FROM test where id= %s\", (input_user,))\n DB.query(\"SELECT * FROM test\")\n DB.query('CREATE TABLE test(name varchar(10), id int(10))')\n DB.query(\"INSERT INTO test values(%s, %s)\", ('harry', 13))\n\n # EXAMPLES FOR 'SQLITE'\n\n DB.query('DROP TABLE movie')\n DB.query(\"CREATE TABLE movie(title varchar(1), year int(1), score int(1))\")\n\n # EXAMPLE FOR 'POSTGRESQL'\n\n DB.query('SELECT datname FROM pg_database')\n\nSee `test.py` for [more examples](https://github.com/Anas-Dew/QuickSQLConnector/blob/main/src/quicksqlconnector/test.py).\n\n## \ud83d\udd17Useful Links\n\n| Route | Link |\n| ----------- | ----------- |\n| Buy me a Coffee | [Visit](https://www.buymeacoffee.com/anasraza) |\n| Email | [Visit](mailto:anasraza1@yahoo.com)|\n| PyPi | [Visit](https://pypi.org/project/quicksqlconnector/) |\n| Website | [Visit](https://quicksqlconnector.web.app/)|\n\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Run MySQL, PostgresSQL, SQLite queries with just one line in python. The Ultimate SQL Library.",
"version": "1.5.3",
"split_keywords": [
"quicksqlconnector",
"sql",
"database",
"mysql",
"postgres",
"sqlite3"
],
"urls": [
{
"comment_text": "",
"digests": {
"md5": "39bee89e3be9e920bfd36bff72190b91",
"sha256": "16ee75716f3f7823a4492c6c8ec6208429af627477b3a96533c5efe0d55f25e3"
},
"downloads": -1,
"filename": "quicksqlconnector-1.5.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "39bee89e3be9e920bfd36bff72190b91",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 5444,
"upload_time": "2023-01-02T11:53:47",
"upload_time_iso_8601": "2023-01-02T11:53:47.826024Z",
"url": "https://files.pythonhosted.org/packages/79/c2/6d78442db2a2501f15301188ce432ffdc31b47b7cee9ea2fd9e720d863e8/quicksqlconnector-1.5.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"md5": "baea18e41f049c98a70e58003a169c73",
"sha256": "2bc12761f0bc934d63e2a0ee61b0e2249f71ccd51c74b51277996b7fc681fa8c"
},
"downloads": -1,
"filename": "quicksqlconnector-1.5.3.tar.gz",
"has_sig": false,
"md5_digest": "baea18e41f049c98a70e58003a169c73",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 4002,
"upload_time": "2023-01-02T11:53:50",
"upload_time_iso_8601": "2023-01-02T11:53:50.400945Z",
"url": "https://files.pythonhosted.org/packages/fb/ba/981abf0ac9c264dca7c4f1cbe5a28ff245c0dbf85e95a9c50c3aae234e1c/quicksqlconnector-1.5.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-01-02 11:53:50",
"github": false,
"gitlab": false,
"bitbucket": false,
"lcname": "quicksqlconnector"
}
JSON