# 原生sql(有些sql用orm写不出来)
# from django.db import connection # # cursor = connection.cursor() # # cursor.execute("""SELECT * from app01_book where id = %s""", [1]) # # # row = cursor.fetchone() # row = cursor.fetchall() # print(row)
# 第二种,用的多
# books=models.Book.objects.raw('select * from app01_book where id >3') # print(books)#RawQuerySet对象 # for book in books: # print(book.name) # books=models.Book.objects.raw('select * from app01_publish') # for book in books: # print(book.__dict__) # print(book.name) # print(book.addr) # print(book.email) # print(book.price) # authors = models.Author.objects.raw('SELECT app01_author.id,app01_author. NAME,app01_authordetail.sex FROM app01_author JOIN app01_authordetail ON app01_author.author_detail_id = app01_authordetail.id WHERE app01_authordetail.sex = 1') # # for author in authors: # print(author.name) # print(author.__dict__)
标签:原生,author,book,books,app01,sql,print,id From: https://www.cnblogs.com/97zs/p/17868014.html