diff options
Diffstat (limited to 'doc/latex/classcSQLiteDatabase.tex')
-rw-r--r-- | doc/latex/classcSQLiteDatabase.tex | 224 |
1 files changed, 224 insertions, 0 deletions
diff --git a/doc/latex/classcSQLiteDatabase.tex b/doc/latex/classcSQLiteDatabase.tex new file mode 100644 index 0000000..78bb93d --- /dev/null +++ b/doc/latex/classcSQLiteDatabase.tex @@ -0,0 +1,224 @@ +\hypertarget{classcSQLiteDatabase}{ +\section{cSQLiteDatabase Class Reference} +\label{classcSQLiteDatabase}\index{cSQLiteDatabase@{cSQLiteDatabase}} +} +{\tt \#include $<$database.h$>$} + +Collaboration diagram for cSQLiteDatabase:\nopagebreak +\begin{figure}[H] +\begin{center} +\leavevmode +\includegraphics[height=400pt]{classcSQLiteDatabase__coll__graph} +\end{center} +\end{figure} +\subsection*{Public Member Functions} +\begin{CompactItemize} +\item +int \hyperlink{classcSQLiteDatabase_2119fbbf7a02c9c627038ddc14c9eb48}{getResultCount} () const +\item +long \hyperlink{classcSQLiteDatabase_408e5de345a74f2540ee1cea3c97cd51}{getLastInsertRowID} () const +\item +\hyperlink{classcRows}{cRows} $\ast$ \hyperlink{classcSQLiteDatabase_4cd24d9d63173c54b63aadc7ada86e7e}{getResultRows} () const +\item +int \hyperlink{classcSQLiteDatabase_33ac864ee86fe3f08f66f1c14fcfc331}{execStatement} (const char $\ast$Statement,...) +\item +void \hyperlink{classcSQLiteDatabase_5c481c06d73cff4f1192409bfc23a15a}{startTransaction} () +\item +void \hyperlink{classcSQLiteDatabase_f11b7090ae824f7f3fc094dc7112323a}{commitTransaction} () +\item +void \hyperlink{classcSQLiteDatabase_e20eff598832e1da41a8e915ee807548}{rollbackTransaction} () +\item +void \hyperlink{classcSQLiteDatabase_b1749baadeb733ea3efdbbd9ffe83253}{setAutoCommit} (bool Commit=true) +\end{CompactItemize} +\subsection*{Static Public Member Functions} +\begin{CompactItemize} +\item +static const char $\ast$ \hyperlink{classcSQLiteDatabase_cdc42326657aea81fd26da6500642381}{sprintf} (const char $\ast$Format,...) +\item +static \hyperlink{classcSQLiteDatabase}{cSQLiteDatabase} $\ast$ \hyperlink{classcSQLiteDatabase_a39756509bd68fd8e335cc9cc40c6f26}{getInstance} () +\end{CompactItemize} +\subsection*{Friends} +\begin{CompactItemize} +\item +\hypertarget{classcSQLiteDatabase_e652fe93205a32a144bf764782bea797}{ +class \textbf{cStatement}} +\label{classcSQLiteDatabase_e652fe93205a32a144bf764782bea797} + +\end{CompactItemize} + + +\subsection{Detailed Description} +SQLite Database + +This is a wrapper class for a SQLite3 database connection It supports simple execution functions. + +On requests with returns any results a instance of {\tt cRows$\ast$} will be created. + +\subsection{Member Function Documentation} +\hypertarget{classcSQLiteDatabase_f11b7090ae824f7f3fc094dc7112323a}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!commitTransaction@{commitTransaction}} +\index{commitTransaction@{commitTransaction}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{commitTransaction}]{\setlength{\rightskip}{0pt plus 5cm}void cSQLiteDatabase::commitTransaction ()}} +\label{classcSQLiteDatabase_f11b7090ae824f7f3fc094dc7112323a} + + +Commits a transaction + +This function commits the transaction and writes all changes to the database + +\begin{Desc} +\item[See also:]\hyperlink{classcSQLiteDatabase_5c481c06d73cff4f1192409bfc23a15a}{cSQLiteDatabase::startTransaction} \end{Desc} +\hypertarget{classcSQLiteDatabase_33ac864ee86fe3f08f66f1c14fcfc331}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!execStatement@{execStatement}} +\index{execStatement@{execStatement}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{execStatement}]{\setlength{\rightskip}{0pt plus 5cm}int cSQLiteDatabase::execStatement (const char $\ast$ {\em Statement}, \/ {\em ...})}} +\label{classcSQLiteDatabase_33ac864ee86fe3f08f66f1c14fcfc331} + + +Executes a SQL statement + +This will execute the statement in the first parameter. If it is followed by any optional parameters it will be formated using the same function as in {\tt \hyperlink{classcSQLiteDatabase_cdc42326657aea81fd26da6500642381}{cSQLiteDatabase::sprintf()}}. + +\begin{Desc} +\item[See also:]\hyperlink{classcSQLiteDatabase_cdc42326657aea81fd26da6500642381}{cSQLiteDatabase::sprintf()}.\end{Desc} +\begin{Desc} +\item[Returns:]returns an integer representing\begin{itemize} +\item {\bf {\tt -1},} in case of an error\item {\bf {\tt 0},} when the statement was executed successfuly \end{itemize} +\end{Desc} +\begin{Desc} +\item[Parameters:] +\begin{description} +\item[{\em Statement}]Statement to be executed \end{description} +\end{Desc} +\hypertarget{classcSQLiteDatabase_a39756509bd68fd8e335cc9cc40c6f26}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!getInstance@{getInstance}} +\index{getInstance@{getInstance}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{getInstance}]{\setlength{\rightskip}{0pt plus 5cm}{\bf cSQLiteDatabase} $\ast$ cSQLiteDatabase::getInstance ()\hspace{0.3cm}{\tt \mbox{[}static\mbox{]}}}} +\label{classcSQLiteDatabase_a39756509bd68fd8e335cc9cc40c6f26} + + +Returns the instance of the database + +Returns the instance of the SQLite database. This will create a single instance of none is existing on the very first call. A subsequent call will return the same instance. + +\begin{Desc} +\item[Returns:]the database instance \end{Desc} +\hypertarget{classcSQLiteDatabase_408e5de345a74f2540ee1cea3c97cd51}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!getLastInsertRowID@{getLastInsertRowID}} +\index{getLastInsertRowID@{getLastInsertRowID}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{getLastInsertRowID}]{\setlength{\rightskip}{0pt plus 5cm}long cSQLiteDatabase::getLastInsertRowID () const}} +\label{classcSQLiteDatabase_408e5de345a74f2540ee1cea3c97cd51} + + +The last {\tt INSERT} RowID + +Returns the primary key of the last inserted row. This will only work if there are no successive calls to the database. + +\begin{Desc} +\item[Returns:]the last insert RowID \end{Desc} +\hypertarget{classcSQLiteDatabase_2119fbbf7a02c9c627038ddc14c9eb48}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!getResultCount@{getResultCount}} +\index{getResultCount@{getResultCount}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{getResultCount}]{\setlength{\rightskip}{0pt plus 5cm}int cSQLiteDatabase::getResultCount () const\hspace{0.3cm}{\tt \mbox{[}inline\mbox{]}}}} +\label{classcSQLiteDatabase_2119fbbf7a02c9c627038ddc14c9eb48} + + +Row count of the last result + +Returns the row count of the last \{{\tt SQL} SELECT\} request. + +\begin{Desc} +\item[See also:]\hyperlink{classcRows}{cRows} \end{Desc} +\begin{Desc} +\item[Returns:]the result row count \end{Desc} +\hypertarget{classcSQLiteDatabase_4cd24d9d63173c54b63aadc7ada86e7e}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!getResultRows@{getResultRows}} +\index{getResultRows@{getResultRows}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{getResultRows}]{\setlength{\rightskip}{0pt plus 5cm}{\bf cRows}$\ast$ cSQLiteDatabase::getResultRows () const\hspace{0.3cm}{\tt \mbox{[}inline\mbox{]}}}} +\label{classcSQLiteDatabase_4cd24d9d63173c54b63aadc7ada86e7e} + + +Result set of the last request + +Returns the result rows of the SQL SELECT request. This might be NULL, if the last statement was not a SELECT. + +\begin{Desc} +\item[See also:]\hyperlink{classcRows}{cRows} \end{Desc} +\begin{Desc} +\item[Returns:]the result rows of the last {\tt SELECT} statement. \end{Desc} +\hypertarget{classcSQLiteDatabase_e20eff598832e1da41a8e915ee807548}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!rollbackTransaction@{rollbackTransaction}} +\index{rollbackTransaction@{rollbackTransaction}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{rollbackTransaction}]{\setlength{\rightskip}{0pt plus 5cm}void cSQLiteDatabase::rollbackTransaction ()}} +\label{classcSQLiteDatabase_e20eff598832e1da41a8e915ee807548} + + +Performs a rollback on a transaction + +This function performs a rollback. No changes will be made to the database + +\begin{Desc} +\item[See also:]\hyperlink{classcSQLiteDatabase_e20eff598832e1da41a8e915ee807548}{cSQLiteDatabase::rollbackTransaction} \end{Desc} +\hypertarget{classcSQLiteDatabase_b1749baadeb733ea3efdbbd9ffe83253}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!setAutoCommit@{setAutoCommit}} +\index{setAutoCommit@{setAutoCommit}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{setAutoCommit}]{\setlength{\rightskip}{0pt plus 5cm}void cSQLiteDatabase::setAutoCommit (bool {\em Commit} = {\tt true})\hspace{0.3cm}{\tt \mbox{[}inline\mbox{]}}}} +\label{classcSQLiteDatabase_b1749baadeb733ea3efdbbd9ffe83253} + + +Set the commit behavior + +This function sets the auto commit behavior on new transactions with \begin{Desc} +\item[See also:]\hyperlink{classcSQLiteDatabase_5c481c06d73cff4f1192409bfc23a15a}{cSQLiteDatabase::startTransaction}.\end{Desc} +\begin{itemize} +\item {\bf {\tt true},} commits the last transaction before starting a new one\item {\bf {\tt false},} performs a rollback on the old transaction \end{itemize} +\begin{Desc} +\item[Parameters:] +\begin{description} +\item[{\em Commit}]Switches the behavior of auto commit \end{description} +\end{Desc} +\hypertarget{classcSQLiteDatabase_cdc42326657aea81fd26da6500642381}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!sprintf@{sprintf}} +\index{sprintf@{sprintf}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{sprintf}]{\setlength{\rightskip}{0pt plus 5cm}const char $\ast$ cSQLiteDatabase::sprintf (const char $\ast$ {\em Format}, \/ {\em ...})\hspace{0.3cm}{\tt \mbox{[}static\mbox{]}}}} +\label{classcSQLiteDatabase_cdc42326657aea81fd26da6500642381} + + +Prints a SQLite escaped text + +Returns a formated text with special characters to escape SQLite special characters like \char`\"{}'\char`\"{}. Additionally to the well known characters of {\em printf\/} the following are allowed: + +\begin{itemize} +\item {\bf {\tt q},} like s, escapes single quotes in strings\item {\bf {\tt Q},} like q, surrounds the escaped string with additional single quotes\item {\bf {\tt z},} frees the string after reading and coping it\end{itemize} + + +\begin{Desc} +\item[See also:]\hyperlink{classcSQLiteDatabase_cdc42326657aea81fd26da6500642381}{sprintf()} \end{Desc} +\begin{Desc} +\item[Returns:]the formated string \end{Desc} +\begin{Desc} +\item[Parameters:] +\begin{description} +\item[{\em Format}]The format string \end{description} +\end{Desc} +\hypertarget{classcSQLiteDatabase_5c481c06d73cff4f1192409bfc23a15a}{ +\index{cSQLiteDatabase@{cSQLiteDatabase}!startTransaction@{startTransaction}} +\index{startTransaction@{startTransaction}!cSQLiteDatabase@{cSQLiteDatabase}} +\subsubsection[{startTransaction}]{\setlength{\rightskip}{0pt plus 5cm}void cSQLiteDatabase::startTransaction ()}} +\label{classcSQLiteDatabase_5c481c06d73cff4f1192409bfc23a15a} + + +Starts a transaction + +This starts a new transaction and commits or rolls back a previous. + +\begin{Desc} +\item[See also:]\hyperlink{classcSQLiteDatabase_b1749baadeb733ea3efdbbd9ffe83253}{cSQLiteDatabase::setAutoCommit} + +\hyperlink{classcSQLiteDatabase_f11b7090ae824f7f3fc094dc7112323a}{cSQLiteDatabase::commitTransaction} \end{Desc} + + +The documentation for this class was generated from the following files:\begin{CompactItemize} +\item +database/database.h\item +database/database.cpp\end{CompactItemize} |