Create a runcatalog table in a MySQL test database.
Based on the code sqlcreatedb.C by Sergey Linev
Author: Juan Fernando Jaramillo Botero
This notebook tutorial was automatically generated with ROOTBOOK-izer from the macro found in the ROOT repository on Tuesday, March 19, 2024 at 07:19 PM.
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)