ctpysql 1.4.5

This library helps you run MYSQL queries as fast as possible 🚄🔥!

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=[e-mail])

---

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'})