Sqlite format implementation.
More...
#include <sqliteformat.h>
|
| SqliteFormat (SqliteStorage *storage, sqlite3 *database) |
| Constructor a new Sqlite Format object. More...
|
|
virtual | ~SqliteFormat () |
| Destructor. More...
|
|
bool | modifyCalendars (const Notebook::Ptr ¬ebook, DBOperation dbop, sqlite3_stmt *stmt) |
| Update notebook data in Calendars table. More...
|
|
Notebook::Ptr | selectCalendars (sqlite3_stmt *stmt) |
| Select notebooks from Calendars table. More...
|
|
bool | modifyComponents (const KCalendarCore::Incidence::Ptr &incidence, const QString ¬ebook, DBOperation dbop, sqlite3_stmt *stmt1, sqlite3_stmt *stmt2, sqlite3_stmt *stmt3, sqlite3_stmt *stmt4, sqlite3_stmt *stmt5, sqlite3_stmt *stmt6, sqlite3_stmt *stmt7, sqlite3_stmt *stmt8, sqlite3_stmt *stmt9, sqlite3_stmt *stmt10, sqlite3_stmt *stmt11, sqlite3_stmt *delAttachmentStmt, sqlite3_stmt *insAttachmentStmt) |
| Update incidence data in Components table. More...
|
|
bool | purgeDeletedComponents (const KCalendarCore::Incidence::Ptr &incidence, sqlite3_stmt *stmt1, sqlite3_stmt *stmt2, sqlite3_stmt *stmt3, sqlite3_stmt *stmt4, sqlite3_stmt *stmt5, sqlite3_stmt *stmt6, sqlite3_stmt *stmt7, sqlite3_stmt *attachmentStmt) |
|
KCalendarCore::Incidence::Ptr | selectComponents (sqlite3_stmt *stmt1, sqlite3_stmt *stmt2, sqlite3_stmt *stmt3, sqlite3_stmt *stmt4, sqlite3_stmt *stmt5, sqlite3_stmt *stmt6, sqlite3_stmt *attachmentStmt, QString ¬ebook) |
| Select incidences from Components table. More...
|
|
KCalendarCore::Person::List | selectContacts (sqlite3_stmt *stmt) |
| Select contacts and order them by appearances. More...
|
|
Sqlite format implementation.
This class implements the Sqlite format. It provides methods for loading/saving/converting Sqlite format data into the internal representation as Calendar and Incidences.
◆ RDateType
The different types of rdates.
Enumerator |
---|
RDate | |
XDate | |
RDateTime | |
XDateTime | |
◆ SqliteFormat()
SqliteFormat::SqliteFormat |
( |
SqliteStorage * |
storage, |
|
|
sqlite3 * |
database |
|
) |
| |
Constructor a new Sqlite Format object.
◆ ~SqliteFormat()
SqliteFormat::~SqliteFormat |
( |
| ) |
|
|
virtual |
◆ modifyCalendars()
Update notebook data in Calendars table.
- Parameters
-
notebook | notebook to update |
dbop | database operation |
stmt | prepared sqlite statement for calendars table |
- Returns
- true if the operation was successful; false otherwise.
◆ modifyComponents()
bool SqliteFormat::modifyComponents |
( |
const KCalendarCore::Incidence::Ptr & |
incidence, |
|
|
const QString & |
notebook, |
|
|
DBOperation |
dbop, |
|
|
sqlite3_stmt * |
stmt1, |
|
|
sqlite3_stmt * |
stmt2, |
|
|
sqlite3_stmt * |
stmt3, |
|
|
sqlite3_stmt * |
stmt4, |
|
|
sqlite3_stmt * |
stmt5, |
|
|
sqlite3_stmt * |
stmt6, |
|
|
sqlite3_stmt * |
stmt7, |
|
|
sqlite3_stmt * |
stmt8, |
|
|
sqlite3_stmt * |
stmt9, |
|
|
sqlite3_stmt * |
stmt10, |
|
|
sqlite3_stmt * |
stmt11, |
|
|
sqlite3_stmt * |
delAttachmentStmt, |
|
|
sqlite3_stmt * |
insAttachmentStmt |
|
) |
| |
Update incidence data in Components table.
- Parameters
-
incidence | incidence to update |
notebook | notebook of incidence |
dbop | database operation |
stmt1 | prepared sqlite statement for components table |
stmt2 | prepared sqlite statement for customproperties table |
stmt3 | prepared sqlite statement for attendee table |
stmt4 | prepared sqlite statement for alarm table |
delAttachmentStmt | prepared sqlite statement to delete entries from the attachment table |
insAttachmentStmt | prepared sqlite statement to insert entries into the attachment table |
- Returns
- true if the operation was successful; false otherwise.
◆ purgeDeletedComponents()
bool SqliteFormat::purgeDeletedComponents |
( |
const KCalendarCore::Incidence::Ptr & |
incidence, |
|
|
sqlite3_stmt * |
stmt1, |
|
|
sqlite3_stmt * |
stmt2, |
|
|
sqlite3_stmt * |
stmt3, |
|
|
sqlite3_stmt * |
stmt4, |
|
|
sqlite3_stmt * |
stmt5, |
|
|
sqlite3_stmt * |
stmt6, |
|
|
sqlite3_stmt * |
stmt7, |
|
|
sqlite3_stmt * |
attachmentStmt |
|
) |
| |
◆ selectCalendars()
Notebook::Ptr SqliteFormat::selectCalendars |
( |
sqlite3_stmt * |
stmt | ) |
|
Select notebooks from Calendars table.
- Parameters
-
stmt | prepared sqlite statement for calendars table |
- Returns
- the queried notebook.
◆ selectComponents()
Incidence::Ptr SqliteFormat::selectComponents |
( |
sqlite3_stmt * |
stmt1, |
|
|
sqlite3_stmt * |
stmt2, |
|
|
sqlite3_stmt * |
stmt3, |
|
|
sqlite3_stmt * |
stmt4, |
|
|
sqlite3_stmt * |
stmt5, |
|
|
sqlite3_stmt * |
stmt6, |
|
|
sqlite3_stmt * |
attachmentStmt, |
|
|
QString & |
notebook |
|
) |
| |
Select incidences from Components table.
- Parameters
-
stmt1 | prepared sqlite statement for components table |
stmt2 | prepared sqlite statement for customproperties table |
stmt3 | prepared sqlite statement for attendee table |
stmt4 | prepared sqlite statement for alarm table |
stmt5 | prepared sqlite statement for recursive table |
stmt6 | prepared sqlite statement for rdates table |
attachmentStmt | prepared sqlite statement for attachments table |
notebook | notebook of incidence |
- Returns
- the queried incidence.
◆ selectContacts()
KCalendarCore::Person::List mKCal::SqliteFormat::selectContacts |
( |
sqlite3_stmt * |
stmt | ) |
|
Select contacts and order them by appearances.
- Parameters
-
stmt | prepared sqlite statement for Attendees table |
- Returns
- ordered list of contacts.
The documentation for this class was generated from the following files: