django F和Q

# F 使用查詢條件的值

from django.db.models import F
models.Tb1.objects.update(num=F('num')+)

# Q 建構搜尋條件
from django.db.models import Q
con = Q()

q1 = Q()
q1.connector = 'OR'
q1.children.append(('id', ))
q1.children.append(('id', ))
q1.children.append(('id', ))

q2 = Q()
q2.connector = 'OR'
q2.children.append(('c1', ))
q2.children.append(('c1', ))
q2.children.append(('c1', ))

con.add(q1, 'AND')
con.add(q2, 'AND')

models.Tb1.objects.filter(con)

from django.db import connection
cursor = connection.cursor()
cursor.execute("""SELECT * from tb where name = %s""", ['Lennon'])
row = cursor.fetchone()