原生sql

# 原生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__)