FilesExpand file tree

 master

/

sqlchemy_2.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

68 lines (43 loc) · 1.53 KB

 master

/

sqlchemy_2.py

Copy path

Top

File metadata and controls

• Code
• Blame

68 lines (43 loc) · 1.53 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

#! /usr/bin/python

# -*- coding: UTF-8 -*-

"""

作者: 小肥巴巴

简书: https://www.jianshu.com/u/db796a501972

邮箱: imyunshi@163.com

github: https://github.com/xiaofeipapa/python_example

您可以任意转载, 恳请保留我作为原作者, 谢谢.

"""

from sqlal_comm import Session, Product, UsingAlchemy

is_available = 1

# 重新插入数据

def re_insert_data():

with UsingAlchemy() as ua:

# 删除所有数据

ua.session.query(Product).filter(Product.id > 0).delete()

data_list = []

for i in range(0, 10):

data = Product()

data.name = '双肩包%d' % i

data.remark = '双肩包%d' % i

data.isBuy = is_available

data_list.append(data)

# 批量增加数据

ua.session.add_all(data_list)

# 测试分页查找

def check_search(page_no, page_size):

re_insert_data()

with UsingAlchemy() as ua:

# 多条件的列表组合

query_filter = list()

# 增加另一个查询条件作为测试

query_filter.append(Product.isBuy == is_available)

offset = (page_no - 1) * page_size

# 查找结果

data_list = ua.session.query(Product).filter(*query_filter).limit(page_size).offset(offset).all()

print('=== 记录条数: {}'.format(len(data_list)))

for data in data_list:

print('-- 记录: ' + data.name)

if __name__ == '__main__':

page_size = 5

for page_no in range(1, 3):

check_search(page_no, page_size)