|
| | CViewDatabase () |
| |
| | ~CViewDatabase () override |
| |
| bool | Open () override |
| |
| bool | GetViewState (const std::string &path, int windowID, CViewState &state, const std::string &skin) |
| |
| bool | SetViewState (const std::string &path, int windowID, const CViewState &state, const std::string &skin) |
| |
| bool | ClearViewStates (int windowID) |
| |
| | CDatabase () |
| |
| virtual | ~CDatabase (void) |
| |
| bool | IsOpen () |
| |
| virtual void | Close () |
| |
| bool | Compress (bool bForce=true) |
| |
| void | Interrupt () |
| |
| bool | Open (const DatabaseSettings &db) |
| |
| void | BeginTransaction () |
| |
| virtual bool | CommitTransaction () |
| |
| void | RollbackTransaction () |
| |
| void | CopyDB (const std::string &latestDb) |
| |
| void | DropAnalytics () |
| |
| std::string | PrepareSQL (std::string strStmt,...) const |
| |
| std::string | GetSingleValue (const std::string &strTable, const std::string &strColumn, const std::string &strWhereClause=std::string(), const std::string &strOrderBy=std::string()) |
| | Get a single value from a table. More...
|
| |
| std::string | GetSingleValue (const std::string &query) |
| |
| std::string | GetSingleValue (const std::string &query, std::unique_ptr< dbiplus::Dataset > &ds) |
| | Get a single value from a query on a dataset. More...
|
| |
| int | GetSingleValueInt (const std::string &strTable, const std::string &strColumn, const std::string &strWhereClause=std::string(), const std::string &strOrderBy=std::string()) |
| | Get a single integer value from a table. More...
|
| |
| int | GetSingleValueInt (const std::string &query) |
| |
| int | GetSingleValueInt (const std::string &query, std::unique_ptr< dbiplus::Dataset > &ds) |
| | Get a single integer value from a query on a dataset. More...
|
| |
| bool | DeleteValues (const std::string &strTable, const Filter &filter=Filter()) |
| | Delete values from a table. More...
|
| |
| bool | ExecuteQuery (const std::string &strQuery) |
| | Execute a query that does not return any result. Note that if BeginMultipleExecute() has been called, the query will be queued until CommitMultipleExecute() is called. More...
|
| |
| bool | ResultQuery (const std::string &strQuery) |
| | Execute a query that returns a result. More...
|
| |
| bool | BeginMultipleExecute () |
| | Start a multiple execution queue. Any ExecuteQuery() function following this call will be queued rather than executed until CommitMultipleExecute() is performed. NOTE: Queries that rely on any queued execute query will not function as expected during this period! More...
|
| |
| bool | CommitMultipleExecute () |
| | Commit the multiple execution queue to the database. Queries are performed within a transaction, and the transaction is rolled back should any one query fail. More...
|
| |
| bool | QueueInsertQuery (const std::string &strQuery) |
| | Put an INSERT or REPLACE query in the queue. More...
|
| |
| bool | CommitInsertQueries () |
| | Commit all queries in the queue. More...
|
| |
| size_t | GetInsertQueriesCount () |
| | Get the number of INSERT queries in the queue. More...
|
| |
| bool | QueueDeleteQuery (const std::string &strQuery) |
| | Put a DELETE query in the queue. More...
|
| |
| bool | CommitDeleteQueries () |
| | Commit all queued DELETE queries. More...
|
| |
| size_t | GetDeleteQueriesCount () |
| | Get the number of DELETE queries in the queue. More...
|
| |
| virtual bool | GetFilter (CDbUrl &dbUrl, Filter &filter, SortDescription &sorting) |
| |
| virtual bool | BuildSQL (const std::string &strBaseDir, const std::string &strQuery, Filter &filter, std::string &strSQL, CDbUrl &dbUrl) |
| |
| virtual bool | BuildSQL (const std::string &strBaseDir, const std::string &strQuery, Filter &filter, std::string &strSQL, CDbUrl &dbUrl, SortDescription &sorting) |
| |
| bool | Connect (const std::string &dbName, const DatabaseSettings &db, bool create) |
| |