Using raw sql in django

Question

What would be the equivalent raw sql for the following:

def index:
    Emails.objects.create(email=request.POST['invite_email'])

I have this so far, but I can't quite get the quotations working --

    cursor = connection.cursor()
    cursor.execute("insert into splash_emails (id, email) values ('0','request.POST[invite_email]')")
    transaction.commit_unless_managed()

What would be correct way to write this, and is this the simplest way to perform raw sql?

Sam Dolan · Accepted Answer · 2011-05-04 00:56:16Z

2

If you ever want to see the queries django is using you can do:

emails = Emails.objects.create(email=request.POST['invite_email'])
print emails.query

It's a bit verbose, but you'll get the gist.

answered May 4, 2011 at 0:56

Sam Dolan

32.6k10 gold badges93 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kevin Pullin · Accepted Answer · 2011-05-04 00:25:18Z

2

I think after reading the Django cookbook chapter on Security, you'll have a good idea on how to execute raw sql AND execute it safely.

answered May 4, 2011 at 0:25

Kevin Pullin

13.4k3 gold badges26 silver badges35 bronze badges

Collectives™ on Stack Overflow

Using raw sql in django

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related