26 printf(
"\nList all databases on server %s\n", db->
GetHost());
28 while ((row = res->
Next())) {
35 printf(
"\nList all tables in database \"test\" on server %s\n",
38 while ((row = res->
Next())) {
45 printf(
"\nList all columns in table \"runcatalog\" in database \"test\" on server %s\n",
48 while ((row = res->
Next())) {
59 const char *sql =
"select dataset,rawfilepath from test.runcatalog "
60 "WHERE tag&(1<<2) AND (run=490001 OR run=300122)";
67 printf(
"\nGot %d rows in result\n", nrows);
70 for (
int i = 0; i < nfields; i++)
73 for (
int i = 0; i < nfields*40; i++)
77 for (
int i = 0; i < nrows; i++) {
79 for (
int j = 0; j < nfields; j++) {
94 printf(
"\nRealTime=%f seconds, CpuTime=%f seconds\n", rtime, ctime);
virtual const char * GetFieldName(Int_t field)=0
virtual Int_t GetRowCount() const
virtual TSQLRow * Next()=0
virtual Int_t GetFieldCount()=0
virtual const char * GetField(Int_t field)=0
const char * GetHost() const
virtual TSQLResult * GetColumns(const char *dbname, const char *table, const char *wild=nullptr)=0
virtual TSQLResult * GetDataBases(const char *wild=nullptr)=0
virtual const char * ServerInfo()=0
virtual TSQLResult * Query(const char *sql)=0
virtual TSQLResult * GetTables(const char *dbname, const char *wild=nullptr)=0
static TSQLServer * Connect(const char *db, const char *uid, const char *pw)
The db should be of the form: <dbms>://<host>[:<port>][/<database>], e.g.: mysql://pcroot....
Double_t RealTime()
Stop the stopwatch (if it is running) and return the realtime (in seconds) passed between the start a...
void Start(Bool_t reset=kTRUE)
Start the stopwatch.
Double_t CpuTime()
Stop the stopwatch (if it is running) and return the cputime (in seconds) passed between the start an...
void Stop()
Stop the stopwatch.