XTY的小站
记录技术笔记和技术博客

models: 1.0 models中的数据，如何实现数据库中的select语句

17 Nov 2016

1. views中实现models数据查询

1) 精确匹配

sql: select from table where field = "filter"

YOURMODELS.objects.filter(field = "filter")

2) 首部匹配

sql: select from table where field like "%filter"

YOURMODELS.objects.filter(field__startswith = "filter")
# 忽略大小写可以用istartswith

3) 尾部匹配

sql: select from table where field like "filter%"

YOURMODELS.objects.filter(field__endswith = "filter")
# 忽略大小写可以用iendwith

4) 中部匹配

sql: select from table where field like "%filter%"

YOURMODELS.objects.filter(field__contains = "filter")
# 忽略大小写可以用icontains

2. 如何实现filter()中的field和filter的外部传参

my_filter = {}
my_filter[my_keyword] = my_filter_value
my_object = MyModel.objects.filter(**my_filter)

3. filter之后的排序问题

# 指定排序字段
YOURMODELS.objects.filter(field = 'filter').order_by('field')

# 逆序排序
YOURMODELS.objects.filter(field = 'filter').order_by('-field')

# 多条件排序
YOURMODELS.objects.filter(field = 'filter').order_by('-field', 'another field')

django doc