Jalpesh Patel(OpenERP) has proposed merging
lp:~openerp-dev/openobject-server/trunk-addons21-general-dbname-pja into
lp:openobject-server.
Requested reviews:
Atul Patel(OpenERP) (atp-openerp)
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-server/trunk-addons21-general-dbname-pja/+merge/133892
Hello sir,
I have fix problem of craete data base when already exists it's given
traceback.
Thanks!
pja
--
https://code.launchpad.net/~openerp-dev/openobject-server/trunk-addons21-general-dbname-pja/+merge/133892
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-server/trunk-addons21-general-dbname-pja.
=== modified file 'openerp/service/web_services.py'
--- openerp/service/web_services.py 2012-10-04 07:44:20 +0000
+++ openerp/service/web_services.py 2012-11-12 10:39:24 +0000
@@ -120,6 +120,12 @@
db = sql_db.db_connect('postgres')
cr = db.cursor()
chosen_template = tools.config['db_template']
+ cr.execute("""SELECT datname
+ FROM pg_database
+ WHERE datname = %s """,
+ (name,))
+ if cr.fetchall():
+ raise openerp.exceptions.Warning(" %s database already exists!" % name )
try:
cr.autocommit(True) # avoid transaction block
cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "%s" """ % (name, chosen_template))
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
