[server] "overrule" case insensitivity of database name (closes: #611294) stable
authorSylvain Thénault <sylvain.thenault@logilab.fr>
Mon, 27 Jun 2011 18:46:08 +0200
branchstable
changeset 7564 1d64c8d33156
parent 7561 45ff0b097be0
child 7566 be2fe6fff734
[server] "overrule" case insensitivity of database name (closes: #611294) The only instances where you are required to use quotes are either when a database object's identifier is identical to a keyword, or when the identifier has at least one capitalized letter in its name. In either of these circumstances, you must remember to quote the identifier both when creating the object, as well as in any subsequent references to that object
server/serverctl.py
--- a/server/serverctl.py	Mon Jun 27 15:17:52 2011 +0200
+++ b/server/serverctl.py	Mon Jun 27 18:46:08 2011 +0200
@@ -355,7 +355,7 @@
                         print '-> user %s created.' % user
                 if dbname in helper.list_databases(cursor):
                     if automatic or ASK.confirm('Database %s already exists -- do you want to drop it ?' % dbname):
-                        cursor.execute('DROP DATABASE %s' % dbname)
+                        cursor.execute('DROP DATABASE "%s"' % dbname)
                     else:
                         print ('you may want to run "cubicweb-ctl db-init '
                                '--drop %s" manually to continue.' % config.appid)