Django/db-api broken for create database?

Question

Was hoping to use Django / db-api's built in string excaping, but it looks like it doesn't work for create database commands?

from django.db import connections
cursor = connections['dbadmin'].cursor()
cursor.execute('create database %s', ['foo'])

Which fails with

DatabaseError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''foo'' at line 1")

Although a straight, unparameterized create database foo works fine.

That looks like a bug to me, right? drop database has a similar problem...

Ignacio Vazquez-Abrams · Accepted Answer · 2012-09-27 17:22:32Z

1

You cannot use parameters for metadata such as table or database names. This is a limitation of the underlying C library, not of DB-API.

answered Sep 27, 2012 at 17:22

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

Collectives™ on Stack Overflow

Django/db-api broken for create database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related