python django原生语句

使用原生sql的 方法 :

raw

# row方法:（掺杂着原生sql和orm来执行的操作）

 res = CookBook.objects.raw('select id as nid  from  epos_cookbook  where  id>%s', params=[1, ])
print(res.columns) # ['nid']
print(type(res)) # <class 'django.db.models.query.RawQuerySet'>

# 在select里面查询到的数据orm里面的要一一对应
res = CookBook.objects.raw("select * from epos_cookbook")
print(res)
for i in res:
    print(i.create_date)
    print(i)

res = CookBook.objects.raw('select * from epos_cookbook where id>%s', params=[1, ])
# 后面可以加参数进来
print(res)
for i in res:
    # print(i.create_date)
    print(i)

extra

# (1,2) 必须两个以上
# res = CookBook.objects.extra(select={"aaa": "cook_type = 1"}, where=['id in (1,2)', ]).values()
res = CookBook.objects.extra(select={"aaa": "cook_type = 1"}, where=['id in (1,2)', ])
print(res)  # <QuerySet [<CookBook: 鱼香肉丝>, <CookBook: 水煮鱼>]>
for r in res:
    print(r)

connections (最原生)

from django.db import connection, connections
# 需要配置数据库
# cursor=connection['default'].cursor() 
cursor = connection.cursor()  
# 不传参数的情况
cursor.execute("""select  * from epos_cookbook""")

# 为原生sql语句设置参数的情况
# cursor.execute("""select  * from  epos_cookbook   where   id=%s""",[2,]) # 2 是 id
# cursor.execute("""select  * from  api_userinfo   where   id=%s"""%1)

# 防止注入攻击
cursor.execute("select  * from  epos_cookbook   where   id=%s", params=[1, ])
# row=cursor.fetchone()
# row=cursor.fetchmany()
row = cursor.fetchall()  ##拿到全部的数据

print(row)

from django.db import connection

cursor=connection.cursor()

# 插入操作
cursor.execute("insert into hello_author(name) values('钱钟书')")

# 更新操作
cursor.execute("update hello_author set name='abc' where name='bcd'")

# 删除操作
cursor.execute("delete from hello_author where name='abc'")

# 查询操作
cursor.execute("select * from hello_author")

raw=cursor.fetchone()  # 返回结果行游标直读向前，读取一条
cursor.fetchall()  # 读取所有

数据库分离使用原生sql

from django.db import connection, connections
# cursor = connection.cursor()
cursor = connections['db2'].cursor()
cursor.execute("""SELECT * from app01_student """, )
row = cursor.fetchall()
print(row)

转载请注明出处:

转载自http://lxfamn.cn/blog

未经允许不得转载：lxfamn » python django原生语句