CDBVis: C:/mesDocs/QT_confDbVis_canvas/test.py Source File

00001 #################################################
00002 #            AUTOGENERATED PYTHON CODE          #
00003 #                   BY CDBVIS                   #
00004 #################################################
00005 
00006 Edit the following : 
00007 databasename="Your_DB_Name"
00008 username="Username"
00009 password="Password"
00010 
00011 from confDBpython import *
00012 import cx_Oracle
00013 
00014 cfDB = CONFDB(databasename,username,password)
00015 cfDB.DBConnexion()
00016 
00017 oracle = cx_Oracle.connect(username+'/'+password+'@'+databasename)
00018 cfDB2 = oracle.cursor()
00019 
00020 cfDB.DeleteFunctionalDevice("1298927")
00021 cfDB2.execute("DELETE FROM LHCB_DEVICES_URL WHERE DEVICENAME='rouba3i_1_7' ")
00022 
00023 
00024 cfDB.DBDeconnexion()
00025 oracle.commit()
00026 
00027