12 #ifndef ROOT_TSQLiteServer
13 #define ROOT_TSQLiteServer
15 #ifndef ROOT_TSQLServer
19 #if !defined(__CINT__)
Bool_t Exec(const char *sql)
Execute SQL command which does not produce any result sets.
Bool_t HasStatement() const
We assume prepared statements work for all SQLite-versions.
TSQLResult * Query(const char *sql)
Execute SQL command.
Int_t Reload()
Reload permission tables.
~TSQLiteServer()
Close SQLite DB.
ClassDef(TSQLiteServer, 0)
TSQLResult * GetColumns(const char *dbname, const char *table, const char *wild=0)
List all columns in specified table (database argument is ignored).
Int_t CreateDataBase(const char *dbname)
Create a database.
TSQLiteServer(const char *db, const char *uid=NULL, const char *pw=NULL)
Bool_t StartTransaction()
submit "START TRANSACTION" query to database return kTRUE, if successful
const char * ServerInfo()
Return server info, must be deleted by user.
Int_t Shutdown()
Shutdown the database server.
Int_t SelectDataBase(const char *dbname)
Select a database.
TSQLResult * GetDataBases(const char *wild=0)
List all available databases.
void Close(Option_t *opt="")
Close connection to SQLite DB.
TSQLStatement * Statement(const char *sql, Int_t=100)
Produce TSQLiteStatement.
TSQLResult * GetTables(const char *dbname, const char *wild=0)
List all tables in the specified database.
Int_t DropDataBase(const char *dbname)
Drop (i.e.
TSQLTableInfo * GetTableInfo(const char *tablename)
Produces SQL table info.