Skip to content
一个MySQL简单操作方式
Python
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
puremysql
test
.gitignore
MANIFEST.in
README.md
requirements.txt
setup.py

README.md

PureMySQL

PyPI

一个MySQL简单操作方式

pip 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)

# 或者
# url = "mysql://root:123456@127.0.0.1:3306/mydata"
# pure_mysql = PureMysql(db_url=url)

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}
You can’t perform that action at this time.