#include "mkcal_export.h"
#include "extendedstorage.h"
#include "notebook.h"
#include <KCalendarCore/Incidence>
#include <sqlite3.h>

Include dependency graph for sqliteformat.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Classes
class	mKCal::SqliteFormat

Namespaces
namespace	mKCal

Macros
#define	SL3_try_exec(db)
#define	SL3_exec(db)
#define	SL3_prepare_v2(db, query, qsize, stmt, tail)
#define	SL3_bind_text(stmt, index, value, size, desc)
#define	SL3_bind_blob(stmt, index, value, size, desc)
#define	SL3_bind_int(stmt, index, value)
#define	SL3_bind_int64(stmt, index, value)
#define	SL3_bind_double(stmt, index, value)
#define	SL3_step(stmt)
#define	SL3_reset(stmt)
#define	CREATE_METADATA "CREATE TABLE IF NOT EXISTS Metadata(transactionId INTEGER)"
#define	CREATE_CALENDARS
#define	CREATE_COMPONENTS
#define	CREATE_RDATES "CREATE TABLE IF NOT EXISTS Rdates(ComponentId INTEGER, Type INTEGER, Date INTEGER, DateLocal INTEGER, TimeZone TEXT)"
#define	CREATE_CUSTOMPROPERTIES "CREATE TABLE IF NOT EXISTS Customproperties(ComponentId INTEGER, Name TEXT, Value TEXT, Parameters TEXT)"
#define	CREATE_RECURSIVE
#define	CREATE_ALARM
#define	CREATE_ATTENDEE
#define	CREATE_ATTACHMENTS
#define	CREATE_CALENDARPROPERTIES
#define	INDEX_CALENDAR "CREATE INDEX IF NOT EXISTS IDX_CALENDAR on Calendars(CalendarId)"
#define	INDEX_COMPONENT "CREATE INDEX IF NOT EXISTS IDX_COMPONENT on Components(ComponentId, Notebook, DateStart, DateEndDue, DateDeleted)"
#define	INDEX_COMPONENT_UID "CREATE UNIQUE INDEX IF NOT EXISTS IDX_COMPONENT_UID on Components(UID, RecurId, DateDeleted)"
#define	INDEX_COMPONENT_NOTEBOOK "CREATE INDEX IF NOT EXISTS IDX_COMPONENT_NOTEBOOK on Components(Notebook)"
#define	INDEX_RDATES "CREATE INDEX IF NOT EXISTS IDX_RDATES on Rdates(ComponentId)"
#define	INDEX_CUSTOMPROPERTIES "CREATE INDEX IF NOT EXISTS IDX_CUSTOMPROPERTIES on Customproperties(ComponentId)"
#define	INDEX_RECURSIVE "CREATE INDEX IF NOT EXISTS IDX_RECURSIVE on Recursive(ComponentId)"
#define	INDEX_ALARM "CREATE INDEX IF NOT EXISTS IDX_ALARM on Alarm(ComponentId)"
#define	INDEX_ATTENDEE "CREATE INDEX IF NOT EXISTS IDX_ATTENDEE on Attendee(ComponentId)"
#define	INDEX_ATTACHMENTS "CREATE INDEX IF NOT EXISTS IDX_ATTACHMENTS on Attachments(ComponentId)"
#define	INDEX_CALENDARPROPERTIES "CREATE INDEX IF NOT EXISTS IDX_CALENDARPROPERTIES on Calendarproperties(CalendarId)"
#define	INSERT_CALENDARS "insert into Calendars values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '', '')"
#define	INSERT_COMPONENTS
#define	INSERT_CUSTOMPROPERTIES "insert into Customproperties values (?, ?, ?, ?)"
#define	INSERT_CALENDARPROPERTIES "insert into Calendarproperties values (?, ?, ?)"
#define	INSERT_RDATES "insert into Rdates values (?, ?, ?, ?, ?)"
#define	INSERT_RECURSIVE "insert into Recursive values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
#define	INSERT_ALARM "insert into Alarm values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
#define	INSERT_ATTENDEE "insert into Attendee values (?, ?, ?, ?, ?, ?, ?, ?, ?)"
#define	INSERT_ATTACHMENTS "insert into Attachments values (?, ?, ?, ?, ?, ?, ?)"
#define	UPDATE_METADATA "replace into Metadata (rowid, transactionId) values (1, ?)"
#define	UPDATE_CALENDARS
#define	UPDATE_COMPONENTS
#define	UPDATE_COMPONENTS_AS_DELETED "update Components set DateDeleted=? where ComponentId=?"
#define	DELETE_CALENDARS "delete from Calendars where CalendarId=?"
#define	DELETE_COMPONENTS "delete from Components where ComponentId=?"
#define	DELETE_RDATES "delete from Rdates where ComponentId=?"
#define	DELETE_CUSTOMPROPERTIES "delete from Customproperties where ComponentId=?"
#define	DELETE_CALENDARPROPERTIES "delete from Calendarproperties where CalendarId=?"
#define	DELETE_RECURSIVE "delete from Recursive where ComponentId=?"
#define	DELETE_ALARM "delete from Alarm where ComponentId=?"
#define	DELETE_ATTENDEE "delete from Attendee where ComponentId=?"
#define	DELETE_ATTACHMENTS "delete from Attachments where ComponentId=?"
#define	SELECT_METADATA "select * from Metadata where rowid=1"
#define	SELECT_CALENDARS_ALL "select * from Calendars order by Name"
#define	SELECT_COMPONENTS_ALL "select * from Components where DateDeleted=0"
#define	SELECT_COMPONENTS_ALL_DELETED "select * from Components where DateDeleted<>0"
#define	SELECT_COMPONENTS_ALL_DELETED_BY_NOTEBOOK "select * from Components where Notebook=? and DateDeleted<>0"
#define	SELECT_COMPONENTS_BY_RECURSIVE
#define	SELECT_COMPONENTS_BY_DATE_BOTH "select * from Components where DateStart<? and (DateEndDue>=? or (DateEndDue=0 and DateStart>=?)) and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_DATE_START "select * from Components where (DateEndDue>=? or (DateEndDue=0 and DateStart>=?)) and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_DATE_END "select * from Components where DateStart<? and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_UID "select * from Components where UID=? and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_NOTEBOOKUID "select * from Components where Notebook=? and DateDeleted=0"
#define	SELECT_ROWID_FROM_COMPONENTS_BY_NOTEBOOK_UID_AND_RECURID "select ComponentId from Components where Notebook=? and UID=? and RecurId=? and DateDeleted=0"
#define	SELECT_RDATES_BY_ID "select * from Rdates where ComponentId=?"
#define	SELECT_CUSTOMPROPERTIES_BY_ID "select * from Customproperties where ComponentId=?"
#define	SELECT_RECURSIVE_BY_ID "select * from Recursive where ComponentId=?"
#define	SELECT_ALARM_BY_ID "select * from Alarm where ComponentId=?"
#define	SELECT_ATTENDEE_BY_ID "select * from Attendee where ComponentId=?"
#define	SELECT_ATTACHMENTS_BY_ID "select * from Attachments where ComponentId=?"
#define	SELECT_CALENDARPROPERTIES_BY_ID "select * from Calendarproperties where CalendarId=?"
#define	SELECT_COMPONENTS_BY_CREATED "select * from Components where DateCreated>=? and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_CREATED_AND_NOTEBOOK "select * from Components where DateCreated>=? and Notebook=? and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_LAST_MODIFIED "select * from Components where DateLastModified>=? and DateCreated<? and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_LAST_MODIFIED_AND_NOTEBOOK "select * from Components where DateLastModified>=? and DateCreated<? and Notebook=? and DateDeleted=0"
#define	SELECT_COMPONENTS_BY_DELETED "select * from Components where DateDeleted>=? and DateCreated<?"
#define	SELECT_COMPONENTS_BY_DELETED_AND_NOTEBOOK "select * from Components where DateDeleted>=? and DateCreated<? and Notebook=?"
#define	SELECT_COMPONENTS_BY_UID_RECID_AND_DELETED "select ComponentId, DateDeleted from Components where UID=? and RecurId=? and DateDeleted<>0"
#define	SELECT_COMPONENTS_BY_NOTEBOOK_UID_RECID_AND_DELETED "select ComponentId from Components where Notebook=? and UID=? and RecurId=? and DateDeleted<>0"
#define	SEARCH_COMPONENTS
#define	UNSET_FLAG_FROM_CALENDAR "update Calendars set Flags=(Flags & (~?))"
#define	BEGIN_TRANSACTION "BEGIN IMMEDIATE;"
#define	COMMIT_TRANSACTION "END;"

Enumerations
enum	mKCal::DBOperation { mKCal::DBInsert , mKCal::DBUpdate , mKCal::DBMarkDeleted , mKCal::DBDelete }

Macro Definition Documentation

◆ BEGIN_TRANSACTION

#define BEGIN_TRANSACTION "BEGIN IMMEDIATE;"

◆ COMMIT_TRANSACTION

#define COMMIT_TRANSACTION "END;"

◆ CREATE_ALARM

#define CREATE_ALARM

Value:

"CREATE TABLE IF NOT EXISTS Alarm(ComponentId INTEGER, Action INTEGER, Repeat INTEGER, Duration INTEGER, " \
  "Offset INTEGER, Relation TEXT, DateTrigger INTEGER, DateTriggerLocal INTEGER, triggerTimeZone TEXT, " \
  "Description TEXT, Attachment TEXT, Summary TEXT, Address TEXT, CustomProperties TEXT, isEnabled INTEGER)"

◆ CREATE_ATTACHMENTS

#define CREATE_ATTACHMENTS

Value:

"CREATE TABLE IF NOT EXISTS Attachments(ComponentId INTEGER, Data BLOB, Uri TEXT, MimeType TEXT, " \

"ShowInLine INTEGER, Label TEXT, Local INTEGER)"

◆ CREATE_ATTENDEE

#define CREATE_ATTENDEE

Value:

"CREATE TABLE IF NOT EXISTS Attendee(ComponentId INTEGER, Email TEXT, Name TEXT, IsOrganizer INTEGER, Role INTEGER, " \

"PartStat INTEGER, Rsvp INTEGER, DelegatedTo TEXT, DelegatedFrom TEXT)"

◆ CREATE_CALENDARPROPERTIES

#define CREATE_CALENDARPROPERTIES

Value:

"CREATE TABLE IF NOT EXISTS Calendarproperties(CalendarId REFERENCES Calendars(CalendarId) " \

"ON DELETE CASCADE, Name TEXT NOT NULL, Value TEXT, UNIQUE (CalendarId, Name))"

◆ CREATE_CALENDARS

#define CREATE_CALENDARS

Value:

"CREATE TABLE IF NOT EXISTS Calendars(CalendarId TEXT PRIMARY KEY, Name TEXT, Description TEXT, Color INTEGER, " \
  "Flags INTEGER, syncDate INTEGER, pluginName TEXT, account TEXT, attachmentSize INTEGER, modifiedDate INTEGER, " \
  "sharedWith TEXT, syncProfile TEXT, createdDate INTEGER, extra1 STRING, extra2 STRING)"

◆ CREATE_COMPONENTS

#define CREATE_COMPONENTS

Value:

"CREATE TABLE IF NOT EXISTS Components(ComponentId INTEGER PRIMARY KEY AUTOINCREMENT, Notebook TEXT, Type TEXT, " \
  "Summary TEXT, Category TEXT, DateStart INTEGER, DateStartLocal INTEGER, StartTimeZone TEXT, HasDueDate INTEGER, " \
  "DateEndDue INTEGER, DateEndDueLocal INTEGER, EndDueTimeZone TEXT, Duration INTEGER, Classification INTEGER, " \
  "Location TEXT, Description TEXT, Status INTEGER, GeoLatitude REAL, GeoLongitude REAL, Priority INTEGER, " \
  "Resources TEXT, DateCreated INTEGER, DateStamp INTEGER, DateLastModified INTEGER, Sequence INTEGER, Comments TEXT, " \
  "Attachments TEXT, Contact TEXT, InvitationStatus INTEGER, RecurId INTEGER, RecurIdLocal INTEGER, " \
  "RecurIdTimeZone TEXT, RelatedTo TEXT, URL TEXT, UID TEXT, Transparency INTEGER, LocalOnly INTEGER, Percent INTEGER, " \
  "DateCompleted INTEGER, DateCompletedLocal INTEGER, CompletedTimeZone TEXT, DateDeleted INTEGER, " \
  "extra1 STRING, extra2 STRING, extra3 INTEGER, thisAndFuture INTEGER)"

◆ CREATE_CUSTOMPROPERTIES

#define CREATE_CUSTOMPROPERTIES "CREATE TABLE IF NOT EXISTS Customproperties(ComponentId INTEGER, Name TEXT, Value TEXT, Parameters TEXT)"

◆ CREATE_METADATA

#define CREATE_METADATA "CREATE TABLE IF NOT EXISTS Metadata(transactionId INTEGER)"

◆ CREATE_RDATES

#define CREATE_RDATES "CREATE TABLE IF NOT EXISTS Rdates(ComponentId INTEGER, Type INTEGER, Date INTEGER, DateLocal INTEGER, TimeZone TEXT)"

◆ CREATE_RECURSIVE

#define CREATE_RECURSIVE

Value:

"CREATE TABLE IF NOT EXISTS Recursive(ComponentId INTEGER, RuleType INTEGER, Frequency INTEGER, Until INTEGER, " \
  "UntilLocal INTEGER, untilTimeZone TEXT, Count INTEGER, Interval INTEGER, BySecond TEXT, ByMinute TEXT, " \
  "ByHour TEXT, ByDay TEXT, ByDayPos Text, ByMonthDay TEXT, ByYearDay TEXT, ByWeekNum TEXT, ByMonth TEXT, " \
  "BySetPos TEXT, WeekStart INTEGER)"

◆ DELETE_ALARM

#define DELETE_ALARM "delete from Alarm where ComponentId=?"

◆ DELETE_ATTACHMENTS

#define DELETE_ATTACHMENTS "delete from Attachments where ComponentId=?"

◆ DELETE_ATTENDEE

#define DELETE_ATTENDEE "delete from Attendee where ComponentId=?"

◆ DELETE_CALENDARPROPERTIES

#define DELETE_CALENDARPROPERTIES "delete from Calendarproperties where CalendarId=?"

◆ DELETE_CALENDARS

#define DELETE_CALENDARS "delete from Calendars where CalendarId=?"

◆ DELETE_COMPONENTS

#define DELETE_COMPONENTS "delete from Components where ComponentId=?"

◆ DELETE_CUSTOMPROPERTIES

#define DELETE_CUSTOMPROPERTIES "delete from Customproperties where ComponentId=?"

◆ DELETE_RDATES

#define DELETE_RDATES "delete from Rdates where ComponentId=?"

◆ DELETE_RECURSIVE

#define DELETE_RECURSIVE "delete from Recursive where ComponentId=?"

◆ INDEX_ALARM

#define INDEX_ALARM "CREATE INDEX IF NOT EXISTS IDX_ALARM on Alarm(ComponentId)"

◆ INDEX_ATTACHMENTS

#define INDEX_ATTACHMENTS "CREATE INDEX IF NOT EXISTS IDX_ATTACHMENTS on Attachments(ComponentId)"

◆ INDEX_ATTENDEE

#define INDEX_ATTENDEE "CREATE INDEX IF NOT EXISTS IDX_ATTENDEE on Attendee(ComponentId)"

◆ INDEX_CALENDAR

#define INDEX_CALENDAR "CREATE INDEX IF NOT EXISTS IDX_CALENDAR on Calendars(CalendarId)"

◆ INDEX_CALENDARPROPERTIES

#define INDEX_CALENDARPROPERTIES "CREATE INDEX IF NOT EXISTS IDX_CALENDARPROPERTIES on Calendarproperties(CalendarId)"

◆ INDEX_COMPONENT

#define INDEX_COMPONENT "CREATE INDEX IF NOT EXISTS IDX_COMPONENT on Components(ComponentId, Notebook, DateStart, DateEndDue, DateDeleted)"

◆ INDEX_COMPONENT_NOTEBOOK

#define INDEX_COMPONENT_NOTEBOOK "CREATE INDEX IF NOT EXISTS IDX_COMPONENT_NOTEBOOK on Components(Notebook)"

◆ INDEX_COMPONENT_UID

#define INDEX_COMPONENT_UID "CREATE UNIQUE INDEX IF NOT EXISTS IDX_COMPONENT_UID on Components(UID, RecurId, DateDeleted)"

◆ INDEX_CUSTOMPROPERTIES

#define INDEX_CUSTOMPROPERTIES "CREATE INDEX IF NOT EXISTS IDX_CUSTOMPROPERTIES on Customproperties(ComponentId)"

◆ INDEX_RDATES

#define INDEX_RDATES "CREATE INDEX IF NOT EXISTS IDX_RDATES on Rdates(ComponentId)"

◆ INDEX_RECURSIVE

#define INDEX_RECURSIVE "CREATE INDEX IF NOT EXISTS IDX_RECURSIVE on Recursive(ComponentId)"

◆ INSERT_ALARM

#define INSERT_ALARM "insert into Alarm values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

◆ INSERT_ATTACHMENTS

#define INSERT_ATTACHMENTS "insert into Attachments values (?, ?, ?, ?, ?, ?, ?)"

◆ INSERT_ATTENDEE

#define INSERT_ATTENDEE "insert into Attendee values (?, ?, ?, ?, ?, ?, ?, ?, ?)"

◆ INSERT_CALENDARPROPERTIES

#define INSERT_CALENDARPROPERTIES "insert into Calendarproperties values (?, ?, ?)"

◆ INSERT_CALENDARS

#define INSERT_CALENDARS "insert into Calendars values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '', '')"

◆ INSERT_COMPONENTS

#define INSERT_COMPONENTS

Value:

"insert into Components values (NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " \

"?, ?, 0, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, ?, '', 0, ?)"

◆ INSERT_CUSTOMPROPERTIES

#define INSERT_CUSTOMPROPERTIES "insert into Customproperties values (?, ?, ?, ?)"

◆ INSERT_RDATES

#define INSERT_RDATES "insert into Rdates values (?, ?, ?, ?, ?)"

◆ INSERT_RECURSIVE

#define INSERT_RECURSIVE "insert into Recursive values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

◆ SEARCH_COMPONENTS

#define SEARCH_COMPONENTS

Value:

"select *, (ComponentId in (select DISTINCT ComponentId from Recursive)" \
"        or ComponentId in (select DISTINCT ComponentId from Rdates)) as doRecur" \
" from Components where DateDeleted=0 and (summary like ? escape '\\'" \
"                                       or description like ? escape '\\'" \
"                                       or location like ? escape '\\') order by doRecur desc, datestart desc"

◆ SELECT_ALARM_BY_ID

#define SELECT_ALARM_BY_ID "select * from Alarm where ComponentId=?"

◆ SELECT_ATTACHMENTS_BY_ID

#define SELECT_ATTACHMENTS_BY_ID "select * from Attachments where ComponentId=?"

◆ SELECT_ATTENDEE_BY_ID

#define SELECT_ATTENDEE_BY_ID "select * from Attendee where ComponentId=?"

◆ SELECT_CALENDARPROPERTIES_BY_ID

#define SELECT_CALENDARPROPERTIES_BY_ID "select * from Calendarproperties where CalendarId=?"

◆ SELECT_CALENDARS_ALL

#define SELECT_CALENDARS_ALL "select * from Calendars order by Name"

◆ SELECT_COMPONENTS_ALL

#define SELECT_COMPONENTS_ALL "select * from Components where DateDeleted=0"

◆ SELECT_COMPONENTS_ALL_DELETED

#define SELECT_COMPONENTS_ALL_DELETED "select * from Components where DateDeleted<>0"

◆ SELECT_COMPONENTS_ALL_DELETED_BY_NOTEBOOK

#define SELECT_COMPONENTS_ALL_DELETED_BY_NOTEBOOK "select * from Components where Notebook=? and DateDeleted<>0"

◆ SELECT_COMPONENTS_BY_CREATED

#define SELECT_COMPONENTS_BY_CREATED "select * from Components where DateCreated>=? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_CREATED_AND_NOTEBOOK

#define SELECT_COMPONENTS_BY_CREATED_AND_NOTEBOOK "select * from Components where DateCreated>=? and Notebook=? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_DATE_BOTH

#define SELECT_COMPONENTS_BY_DATE_BOTH "select * from Components where DateStart<? and (DateEndDue>=? or (DateEndDue=0 and DateStart>=?)) and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_DATE_END

#define SELECT_COMPONENTS_BY_DATE_END "select * from Components where DateStart<? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_DATE_START

#define SELECT_COMPONENTS_BY_DATE_START "select * from Components where (DateEndDue>=? or (DateEndDue=0 and DateStart>=?)) and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_DELETED

#define SELECT_COMPONENTS_BY_DELETED "select * from Components where DateDeleted>=? and DateCreated<?"

◆ SELECT_COMPONENTS_BY_DELETED_AND_NOTEBOOK

#define SELECT_COMPONENTS_BY_DELETED_AND_NOTEBOOK "select * from Components where DateDeleted>=? and DateCreated<? and Notebook=?"

◆ SELECT_COMPONENTS_BY_LAST_MODIFIED

#define SELECT_COMPONENTS_BY_LAST_MODIFIED "select * from Components where DateLastModified>=? and DateCreated<? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_LAST_MODIFIED_AND_NOTEBOOK

#define SELECT_COMPONENTS_BY_LAST_MODIFIED_AND_NOTEBOOK "select * from Components where DateLastModified>=? and DateCreated<? and Notebook=? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_NOTEBOOK_UID_RECID_AND_DELETED

#define SELECT_COMPONENTS_BY_NOTEBOOK_UID_RECID_AND_DELETED "select ComponentId from Components where Notebook=? and UID=? and RecurId=? and DateDeleted<>0"

◆ SELECT_COMPONENTS_BY_NOTEBOOKUID

#define SELECT_COMPONENTS_BY_NOTEBOOKUID "select * from Components where Notebook=? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_RECURSIVE

#define SELECT_COMPONENTS_BY_RECURSIVE

Value:

"select * from Components where ((ComponentId in (select DISTINCT ComponentId from Recursive)) "\

"or (ComponentId in (select DISTINCT ComponentId from Rdates)) or (RecurId!=0)) and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_UID

#define SELECT_COMPONENTS_BY_UID "select * from Components where UID=? and DateDeleted=0"

◆ SELECT_COMPONENTS_BY_UID_RECID_AND_DELETED

#define SELECT_COMPONENTS_BY_UID_RECID_AND_DELETED "select ComponentId, DateDeleted from Components where UID=? and RecurId=? and DateDeleted<>0"

◆ SELECT_CUSTOMPROPERTIES_BY_ID

#define SELECT_CUSTOMPROPERTIES_BY_ID "select * from Customproperties where ComponentId=?"

◆ SELECT_METADATA

#define SELECT_METADATA "select * from Metadata where rowid=1"

◆ SELECT_RDATES_BY_ID

#define SELECT_RDATES_BY_ID "select * from Rdates where ComponentId=?"

◆ SELECT_RECURSIVE_BY_ID

#define SELECT_RECURSIVE_BY_ID "select * from Recursive where ComponentId=?"

◆ SELECT_ROWID_FROM_COMPONENTS_BY_NOTEBOOK_UID_AND_RECURID

#define SELECT_ROWID_FROM_COMPONENTS_BY_NOTEBOOK_UID_AND_RECURID "select ComponentId from Components where Notebook=? and UID=? and RecurId=? and DateDeleted=0"

◆ SL3_bind_blob

#define SL3_bind_blob	(	stmt,
		index,
		value,
		size,
		desc )

Value:

{                                                                     \
  rv = sqlite3_bind_blob( (stmt), (index), (value), (size), (desc) ); \
  if ( rv ) {                                                         \
    qCWarning(lcMkcal) << "sqlite3_bind_blob error:" << rv << "on index and value:" << index << value; \
    goto error;                                                       \
  }                                                                   \
  index++;                                                            \
}

◆ SL3_bind_double

#define SL3_bind_double	(	stmt,
		index,
		value )

Value:

{                                                                     \
  rv = sqlite3_bind_double( (stmt), (index), (value) );               \
  if ( rv ) {                                                         \
    qCWarning(lcMkcal) << "sqlite3_bind_int error:" << rv << "on index and value:" << index << value; \
    goto error;                                                       \
  }                                                                   \
  index++;                                                            \
}

◆ SL3_bind_int

#define SL3_bind_int	(	stmt,
		index,
		value )

Value:

{                                                                     \
  rv = sqlite3_bind_int( (stmt), (index), (value) );                  \
  if ( rv ) {                                                         \
    qCWarning(lcMkcal) << "sqlite3_bind_int error:" << rv << "on index and value:" << index << value; \
    goto error;                                                       \
  }                                                                   \
  index++;                                                            \
}

◆ SL3_bind_int64

#define SL3_bind_int64	(	stmt,
		index,
		value )

Value:

{                                                                     \
  rv = sqlite3_bind_int64( (stmt), (index), (value) );                \
  if ( rv ) {                                                         \
    qCWarning(lcMkcal) << "sqlite3_bind_int64 error:" << rv << "on index and value:" << index << value; \
    goto error;                                                       \
  }                                                                   \
  index++;                                                            \
}

◆ SL3_bind_text

#define SL3_bind_text	(	stmt,
		index,
		value,
		size,
		desc )

Value:

{                                                                     \
  rv = sqlite3_bind_text( (stmt), (index), (value), (size), (desc) ); \
  if ( rv ) {                                                         \
    qCWarning(lcMkcal) << "sqlite3_bind_text error:" << rv << "on index and value:" << index << value; \
    goto error;                                                       \
  }                                                                   \
  index++;                                                            \
}

◆ SL3_exec

#define SL3_exec ( db )

Value:

{                                                             \
  SL3_try_exec( (db) );                                       \
  if ( rv && rv != SQLITE_CONSTRAINT ) {                      \
      goto error;                                             \
  }                                                           \
}

◆ SL3_prepare_v2

#define SL3_prepare_v2	(	db,
		query,
		qsize,
		stmt,
		tail )

Value:

{                                                                     \
 /* kDebug() << "SQL query:" << query;     */                         \
  rv = sqlite3_prepare_v2( (db), (query), (qsize), (stmt), (tail) );  \
  if ( rv ) {                                                         \
    qCWarning(lcMkcal) << "sqlite3_prepare error code:" << rv;                  \
    qCWarning(lcMkcal) << sqlite3_errmsg( (db) );                               \
    goto error;                                                       \
  }                                                                   \
}

◆ SL3_reset

#define SL3_reset ( stmt )

Value:

{                                                       \
  rv = sqlite3_reset( (stmt) );                         \
  if ( rv && rv != SQLITE_OK ) {                        \
    qCWarning(lcMkcal) << "sqlite3_reset error:" << rv; \
    goto error;                                         \
  }                                                     \
}

◆ SL3_step

#define SL3_step ( stmt )

Value:

{                                                       \
  rv = sqlite3_step( (stmt) );                          \
  if ( rv && rv != SQLITE_DONE && rv != SQLITE_ROW ) {  \
    if ( rv != SQLITE_CONSTRAINT ) {                    \
      qCWarning(lcMkcal) << "sqlite3_step error:" << rv;          \
    }                                                   \
    goto error;                                         \
  }                                                     \
}

◆ SL3_try_exec

#define SL3_try_exec ( db )

Value:

{                                                             \
 /* kDebug() << "SQL query:" << query;    */                  \
  rv = sqlite3_exec( (db), query, NULL, 0, &errmsg );         \
  if ( rv ) {                                                 \
      qCWarning(lcMkcal) << "sqlite3_exec error code:" << rv; \
      if ( errmsg ) {                                         \
          qCWarning(lcMkcal) << errmsg;                       \
          sqlite3_free( errmsg );                             \
          errmsg = NULL;                                      \
      }                                                       \
  }                                                           \
}

◆ UNSET_FLAG_FROM_CALENDAR

#define UNSET_FLAG_FROM_CALENDAR "update Calendars set Flags=(Flags & (~?))"

◆ UPDATE_CALENDARS

#define UPDATE_CALENDARS

Value:

"update Calendars set Name=?, Description=?, Color=?, Flags=?, syncDate=?, pluginName=?, account=?, attachmentSize=?, " \

"modifiedDate=?, sharedWith=?, syncProfile=?, createdDate=? where CalendarId=?"

◆ UPDATE_COMPONENTS

#define UPDATE_COMPONENTS

Value:

"update Components set Notebook=?, Type=?, Summary=?, Category=?, DateStart=?, DateStartLocal=?, StartTimeZone=?, " \
"HasDueDate=?, DateEndDue=?, DateEndDueLocal=?, EndDueTimeZone=?, Duration=?, Classification=?, Location=?, " \
"Description=?, Status=?, GeoLatitude=?, GeoLongitude=?, Priority=?, Resources=?, DateCreated=?, DateStamp=?, " \
"DateLastModified=?, Sequence=?, Comments=?, Attachments=?, Contact=?, RecurId=?, RecurIdLocal=?, RecurIdTimeZone=?, " \
"RelatedTo=?, URL=?, UID=?, Transparency=?, LocalOnly=?, Percent=?, DateCompleted=?, DateCompletedLocal=?, " \
"CompletedTimeZone=?, extra1=?, thisAndFuture=? where ComponentId=?"

◆ UPDATE_COMPONENTS_AS_DELETED

#define UPDATE_COMPONENTS_AS_DELETED "update Components set DateDeleted=? where ComponentId=?"

◆ UPDATE_METADATA

#define UPDATE_METADATA "replace into Metadata (rowid, transactionId) values (1, ?)"

Classes

Namespaces

Macros

Enumerations

Macro Definition Documentation

◆ BEGIN_TRANSACTION

◆ COMMIT_TRANSACTION

◆ CREATE_ALARM

◆ CREATE_ATTACHMENTS

◆ CREATE_ATTENDEE

◆ CREATE_CALENDARPROPERTIES

◆ CREATE_CALENDARS

◆ CREATE_COMPONENTS

◆ CREATE_CUSTOMPROPERTIES

◆ CREATE_METADATA

◆ CREATE_RDATES

◆ CREATE_RECURSIVE

◆ DELETE_ALARM

◆ DELETE_ATTACHMENTS

◆ DELETE_ATTENDEE

◆ DELETE_CALENDARPROPERTIES

◆ DELETE_CALENDARS

◆ DELETE_COMPONENTS

◆ DELETE_CUSTOMPROPERTIES

◆ DELETE_RDATES

◆ DELETE_RECURSIVE

◆ INDEX_ALARM

◆ INDEX_ATTACHMENTS

◆ INDEX_ATTENDEE

◆ INDEX_CALENDAR

◆ INDEX_CALENDARPROPERTIES

◆ INDEX_COMPONENT

◆ INDEX_COMPONENT_NOTEBOOK

◆ INDEX_COMPONENT_UID

◆ INDEX_CUSTOMPROPERTIES

◆ INDEX_RDATES

◆ INDEX_RECURSIVE

◆ INSERT_ALARM

◆ INSERT_ATTACHMENTS

◆ INSERT_ATTENDEE

◆ INSERT_CALENDARPROPERTIES

◆ INSERT_CALENDARS

◆ INSERT_COMPONENTS

◆ INSERT_CUSTOMPROPERTIES

◆ INSERT_RDATES

◆ INSERT_RECURSIVE

◆ SEARCH_COMPONENTS

◆ SELECT_ALARM_BY_ID

◆ SELECT_ATTACHMENTS_BY_ID

◆ SELECT_ATTENDEE_BY_ID

◆ SELECT_CALENDARPROPERTIES_BY_ID

◆ SELECT_CALENDARS_ALL

◆ SELECT_COMPONENTS_ALL

◆ SELECT_COMPONENTS_ALL_DELETED

◆ SELECT_COMPONENTS_ALL_DELETED_BY_NOTEBOOK

◆ SELECT_COMPONENTS_BY_CREATED

◆ SELECT_COMPONENTS_BY_CREATED_AND_NOTEBOOK

◆ SELECT_COMPONENTS_BY_DATE_BOTH

◆ SELECT_COMPONENTS_BY_DATE_END

◆ SELECT_COMPONENTS_BY_DATE_START

◆ SELECT_COMPONENTS_BY_DELETED

◆ SELECT_COMPONENTS_BY_DELETED_AND_NOTEBOOK

◆ SELECT_COMPONENTS_BY_LAST_MODIFIED

◆ SELECT_COMPONENTS_BY_LAST_MODIFIED_AND_NOTEBOOK

◆ SELECT_COMPONENTS_BY_NOTEBOOK_UID_RECID_AND_DELETED

◆ SELECT_COMPONENTS_BY_NOTEBOOKUID

◆ SELECT_COMPONENTS_BY_RECURSIVE

◆ SELECT_COMPONENTS_BY_UID

◆ SELECT_COMPONENTS_BY_UID_RECID_AND_DELETED

◆ SELECT_CUSTOMPROPERTIES_BY_ID

◆ SELECT_METADATA

◆ SELECT_RDATES_BY_ID

◆ SELECT_RECURSIVE_BY_ID

◆ SELECT_ROWID_FROM_COMPONENTS_BY_NOTEBOOK_UID_AND_RECURID

◆ SL3_bind_blob

◆ SL3_bind_double

◆ SL3_bind_int

◆ SL3_bind_int64

◆ SL3_bind_text

◆ SL3_exec