sqlcreatedb.py

Go to the documentation of this file.

## \file
## \ingroup tutorial_sql
## \notebook -nodraw
## Create a runcatalog table in a MySQL test database.
##
## Based on the code sqlcreatedb.C by Sergey Linev
##
## \macro_code
##
## \author Juan Fernando Jaramillo Botero
 
from ROOT import TSQLServer
 
 
# read in runcatalog table definition
fp = open("runcatalog.sql", "r")
sql = fp.read()
fp.close()
 
# open connection to MySQL server on localhost
db = TSQLServer.Connect("mysql://localhost/test", "nobody", "")
 
# create new table (delete old one first if exists)
res = db.Query("DROP TABLE runcatalog")
 
res = db.Query(sql)