django里执行 sql

django里执行原生sql
[ccn lang="python" tab_size="4" theme="blackboard" width="800" ]
def my_custom_sql():
from django.db import connection, transaction
cursor = connection.cursor()

# Data modifying operation - commit required
cursor.execute("UPDATE bar SET foo = 1 WHERE baz = %s", [self.baz])
transaction.commit_unless_managed()

# Data retrieval operation - no commit required
cursor.execute("SELECT foo FROM bar WHERE baz = %s", [self.baz])
row = cursor.fetchone()

return row
[/ccn]