This library helps you run MYSQL queries as fast as possible 🚄🔥!
Project description
cautious-pysql
CTpysql helps you to code mysql queries as fast as possible 🚄🔥
Usage
Installation
Use pip install ctpysql
to install the ctpysql and it's dependencies on your pc (or venv).
import module with:
from ctpysql import ctpysql
to use it in your project.
How it works?
You may import mysql.connector to work with ctpysql, just use:
from mysql.connector import (connection, Error)
and make a connection like this:
cnx = connection.MySQLConnection(user='root', password='password', host='127.0.0.1', database='db')
then make an object from ctpysql class using this connection:
obj = ctpysql(cnx)
after these steps you are able to use this library correctly, for example, insert query using dictionary values:
obj.insert('users', {'username': 'user1', 'password': 'password1'})
Supported queries
Supported queries at this version (they will be more soon):
Insert
Last rowid inserted return
insert('table', {dictionary values})
Truncate:
truncate('table')
Select
Selected row(s) return
fetch('table', 'case [all or one]', 'type [dic or None]', **data)
Example:
fetch('users', 'one', None, id=3)
Select all
Selected row(s) return
fetchall('table', 'type [dic or None]')
Example 1:
fetchall('products', None)
Example 2:
fetchall('products', 'dic')
Update
Affected rows count return
update('table', 'condition column name', 'condition column value', **data)
Example:
update('users', 'username', usernameVar, password=123, email=a@a.com)
Delete
Deleted rows count return
delete('table', 'condition column name', 'condition value')
Drop
"Success" or error return
drop('case', 'name')
Example:
drop('table', 'product')
Example2:
drop('view', '[mysql queries]')
Order
Fetched items return
order('table', **data(column1="order like ASC", column2="order like DESC"))
Example:
order('products', name="ASC", id="DESC")
Create table
"Success" or error return
create_table('table name', **data)
Example:
create_table('users', id="INT AUTO_INCREMENT PRIMARY KEY", name="VARCHAR(255)")
Between
Fetched rows return
between('table name', 'type [dic or None]', 'condition column', 'first parameter', 'second parameter')
Example:
between('products', None, 'id', 1, 4)
Don't forget!
Don't forget this is a class and you should call this functions from an object of class. A full example here:
from mysql.connector import (connection, Error)
from ctpysql import ctpysql
connection = connection.MySQLConnection(user='root', password='password', host='127.0.0.1', database='testdb')
object = ctpysql(cnx)
object.insert('products', {'name': 'Laptop', 'brand': 'Asus'})
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.