PureMySQL: 一个MySQL简单操作方式

• https://github.com/mouday/PureMySQL
• https://pypi.org/project/PureMySQL/

安装

pip3 install PureMySQL

  

 

  
1
 

代码示例

# -*- 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}


  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
  
16
  
17
  
18
  
19
  
20
  
21
  
22
  
23
  
24
  
25
  
26
  
27
  
28
  
29
  
30
  
31
  
32
  
33
  
34
  
35
  
36
  
37
  
38
  
39
  
40
  
41
  
42
  
43
  
44
  
45
  
46
  
47
  
48
  
49
  
50
  
51
  
52
  
53
  
54
  
55
  
56
  
57
  
58
  
59
  
60
  
61
  
62
  
63
  
64
  
65
  
66
  
67
  
68
  
69
  
70
  
71
  
72
  
73
  
74
  
75
  
76
  
77
  
78
  
79
  
80
  
81
 

文章来源: pengshiyu.blog.csdn.net，作者：彭世瑜，版权归原作者所有，如需转载，请联系作者。

原文链接：pengshiyu.blog.csdn.net/article/details/93993189