sqlcreatedb.C

Go to the documentation of this file.

/// \file
/// \ingroup tutorial_sql
/// Create a runcatalog table in a MySQL test database.
///
/// \macro_code
///
/// \author Sergey Linev
 
void sqlcreatedb()
{
   // read in runcatalog table definition
   FILE *fp = fopen("runcatalog.sql", "r");
   const char sql[4096];
   fread(sql, 1, 4096, fp);
   fclose(fp);
 
   // open connection to MySQL server on localhost
   TSQLServer *db = TSQLServer::Connect("mysql://localhost/test", "nobody", "");
 
   TSQLResult *res;
 
   // create new table (delete old one first if exists)
   res = db->Query("DROP TABLE runcatalog");
   delete res;
 
   res = db->Query(sql);
   delete res;
 
   delete db;
}