PureMySQL: 一个MySQL简单操作方式

pip3 install PureMySQL

# -*- coding: utf-8 -*-
from puremysql import PureMysql
db_config = {
    "database": "mydata",
    "user": "root",
    "password": "123456",
    "host": "127.0.0.1",
    "port": 3306,
}
pure_mysql = PureMysql(**db_config)
student = pure_mysql.table("student")
# 插入数据
def test_insert():
    data = {
        "name": "Tom",
        "age": 25
    }
    count = student.insert(data)
    print(count)  # 1
    data = [
        {
            "name": "Tom",
            "age": 26,
        },
        {
            "name": "Jack",
            "age": 27,
        }
    ]
    count = student.insert(data)
    print(count)  # 2
# 删除数据
def test_delete():
    ret = student.delete("id=13")
    print(ret)  # 1
    ret = student.delete_by_id(12)
    print(ret)  # 1
# 更新数据
def test_update():
    data = {
        "name": "Tom"
    }
    ret = student.update(data, "name='Tom'")
    print(ret)  # 1
    ret = student.update_by_id(data, 1)
    print(ret)  # 1
# 查询数据
def test_select():
    ret = student.select(["name", "age"], "id=1")
    print(ret)
    # [{"name": "Tom", "age": 25}]
    ret = student.select("name, age", "id=1")
    print(ret)
    # [{"name": "Tom", "age": 25}]
    ret = student.select_one(["name", "age"], "id=1")
    print(ret)
    # {"name": "Tom", "age": 25}
    ret = student.select_by_id("name, age", 2007)
    print(ret)
    # {"name": "Tom", "age": 25}