modify terminology:calendar->book,allday->localtime,normal->utime,svc->service

[platform/core/pim/calendar-service.git] / server / db / cal_db.c

diff --git a/server/db/cal_db.c b/server/db/cal_db.c
index 1e8f328..80b232b 100644 (file)
--- a/server/db/cal_db.c
+++ b/server/db/cal_db.c
@@ -38,12 +38,12 @@
 /*
  * Declear DB plugin
  */
-extern cal_db_plugin_cb_s cal_db_calendar_plugin_cb;
+extern cal_db_plugin_cb_s cal_db_book_plugin_cb;
 extern cal_db_plugin_cb_s cal_db_event_plugin_cb;
-extern cal_db_plugin_cb_s cal_db_instance_normal_plugin_cb;
-extern cal_db_plugin_cb_s cal_db_instance_normal_extended_plugin_cb;
-extern cal_db_plugin_cb_s cal_db_instance_allday_plugin_cb;
-extern cal_db_plugin_cb_s cal_db_instance_allday_extended_plugin_cb;
+extern cal_db_plugin_cb_s cal_db_instance_utime_plugin_cb;
+extern cal_db_plugin_cb_s cal_db_instance_utime_extended_plugin_cb;
+extern cal_db_plugin_cb_s cal_db_instance_localtime_plugin_cb;
+extern cal_db_plugin_cb_s cal_db_instance_localtime_extended_plugin_cb;
 extern cal_db_plugin_cb_s cal_db_todo_plugin_cb;
 extern cal_db_plugin_cb_s cal_db_alarm_plugin_cb;
 extern cal_db_plugin_cb_s cal_db_attendee_plugin_cb;
@@ -90,8 +90,8 @@ int cal_db_append_string(char **dst, const char *src)
 cal_db_plugin_cb_s* _cal_db_get_plugin(cal_record_type_e type)
 {
        switch (type) {
-       case CAL_RECORD_TYPE_CALENDAR:
-               return (&cal_db_calendar_plugin_cb);
+       case CAL_RECORD_TYPE_BOOK:
+               return (&cal_db_book_plugin_cb);
        case CAL_RECORD_TYPE_EVENT:
                return (&cal_db_event_plugin_cb);
        case CAL_RECORD_TYPE_TODO:
@@ -102,14 +102,14 @@ cal_db_plugin_cb_s* _cal_db_get_plugin(cal_record_type_e type)
                return (&cal_db_attendee_plugin_cb);
        case CAL_RECORD_TYPE_TIMEZONE:
                return (&cal_db_timezone_plugin_cb);
-       case CAL_RECORD_TYPE_INSTANCE_NORMAL:
-               return (&cal_db_instance_normal_plugin_cb);
-       case CAL_RECORD_TYPE_INSTANCE_ALLDAY:
-               return (&cal_db_instance_allday_plugin_cb);
-       case CAL_RECORD_TYPE_INSTANCE_NORMAL_EXTENDED:
-               return (&cal_db_instance_normal_extended_plugin_cb);
-       case CAL_RECORD_TYPE_INSTANCE_ALLDAY_EXTENDED:
-               return (&cal_db_instance_allday_extended_plugin_cb);
+       case CAL_RECORD_TYPE_INSTANCE_UTIME:
+               return (&cal_db_instance_utime_plugin_cb);
+       case CAL_RECORD_TYPE_INSTANCE_LOCALTIME:
+               return (&cal_db_instance_localtime_plugin_cb);
+       case CAL_RECORD_TYPE_INSTANCE_UTIME_EXTENDED:
+               return (&cal_db_instance_utime_extended_plugin_cb);
+       case CAL_RECORD_TYPE_INSTANCE_LOCALTIME_EXTENDED:
+               return (&cal_db_instance_localtime_extended_plugin_cb);
        case CAL_RECORD_TYPE_SEARCH:
                return (&cal_db_search_plugin_cb);
        case CAL_RECORD_TYPE_EXTENDED:
@@ -196,7 +196,7 @@ void cal_db_initialize_view_table(void)
        }
 
        /*
-        * CAL_VIEW_TABLE_NORMAL_INSTANCE  : CALENDAR_VIEW_INSTANCE_NORMAL_CALENDAR
+        * CAL_VIEW_TABLE_UTIME_INSTANCE  : CALENDAR_VIEW_INSTANCE_UTIME_CALENDAR
         * normal_instance_table + schedule_table(type=1) + calendar_table
         * A = normal_instace_table
         * B = schedule_table
@@ -215,8 +215,8 @@ void cal_db_initialize_view_table(void)
                        "FROM %s as A, %s as B, %s as C "
                        "ON A.event_id = B.id AND B.calendar_id = C.id "
                        "where C.deleted = 0 AND B.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_NORMAL_INSTANCE,
-                       CAL_TABLE_NORMAL_INSTANCE,
+                       CAL_VIEW_TABLE_UTIME_INSTANCE,
+                       CAL_TABLE_UTIME_INSTANCE,
                        CAL_TABLE_SCHEDULE,
                        CAL_TABLE_CALENDAR);
        ret = cal_db_util_query_exec(query);
@@ -227,7 +227,7 @@ void cal_db_initialize_view_table(void)
                /* LCOV_EXCL_STOP */
        }
 
-       /* CAL_VIEW_TABLE_ALLDAY_INSTANCE  : CALENDAR_VIEW_INSTANCE_ALLDAY_CALENDAR */
+       /* CAL_VIEW_TABLE_LOCALTIME_INSTANCE  : CALENDAR_VIEW_INSTANCE_LOCALTIME_CALENDAR */
        snprintf(query, sizeof(query),
                        "CREATE VIEW IF NOT EXISTS %s AS SELECT A.event_id, "
                        "B.dtstart_type, B.dtstart_utime, A.dtstart_datetime, "
@@ -241,8 +241,8 @@ void cal_db_initialize_view_table(void)
                        "FROM %s as A, %s as B, %s as C "
                        "ON A.event_id = B.id AND B.calendar_id = C.id "
                        "where C.deleted = 0 AND B.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_ALLDAY_INSTANCE,
-                       CAL_TABLE_ALLDAY_INSTANCE,
+                       CAL_VIEW_TABLE_LOCALTIME_INSTANCE,
+                       CAL_TABLE_LOCALTIME_INSTANCE,
                        CAL_TABLE_SCHEDULE,
                        CAL_TABLE_CALENDAR);
        ret = cal_db_util_query_exec(query);
@@ -254,7 +254,7 @@ void cal_db_initialize_view_table(void)
        }
 
        /*
-        * CAL_VIEW_TABLE_NORMAL_INSTANCE_EXTENDED  : CALENDAR_VIEW_INSTANCE_NORMAL_CALENDAR_EXTENDED
+        * CAL_VIEW_TABLE_UTIME_INSTANCE_EXTENDED  : CALENDAR_VIEW_INSTANCE_UTIME_CALENDAR_EXTENDED
         * normal_instance_table + schedule_table(type=1) + calendar_table
         * A = normal_instace_table
         * B = schedule_table
@@ -273,8 +273,8 @@ void cal_db_initialize_view_table(void)
                        "FROM %s as A, %s as B, %s as C "
                        "ON A.event_id = B.id AND B.calendar_id = C.id "
                        "where C.deleted = 0 AND B.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_NORMAL_INSTANCE_EXTENDED,
-                       CAL_TABLE_NORMAL_INSTANCE,
+                       CAL_VIEW_TABLE_UTIME_INSTANCE_EXTENDED,
+                       CAL_TABLE_UTIME_INSTANCE,
                        CAL_TABLE_SCHEDULE,
                        CAL_TABLE_CALENDAR);
        ret = cal_db_util_query_exec(query);
@@ -285,7 +285,7 @@ void cal_db_initialize_view_table(void)
                /* LCOV_EXCL_STOP */
        }
 
-       /* CAL_VIEW_TABLE_ALLDAY_INSTANCE_EXTENDED  : CALENDAR_VIEW_INSTANCE_ALLDAY_CALENDAR_EXTENDED */
+       /* CAL_VIEW_TABLE_LOCALTIME_INSTANCE_EXTENDED  : CALENDAR_VIEW_INSTANCE_LOCALTIME_CALENDAR_EXTENDED */
        snprintf(query, sizeof(query),
                        "CREATE VIEW IF NOT EXISTS %s AS SELECT A.event_id, "
                        "B.dtstart_type, B.dtstart_utime, A.dtstart_datetime, "
@@ -299,8 +299,8 @@ void cal_db_initialize_view_table(void)
                        "FROM %s as A, %s as B, %s as C "
                        "ON A.event_id = B.id AND B.calendar_id = C.id "
                        "where C.deleted = 0 AND B.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_ALLDAY_INSTANCE_EXTENDED,
-                       CAL_TABLE_ALLDAY_INSTANCE,
+                       CAL_VIEW_TABLE_LOCALTIME_INSTANCE_EXTENDED,
+                       CAL_TABLE_LOCALTIME_INSTANCE,
                        CAL_TABLE_SCHEDULE,
                        CAL_TABLE_CALENDAR);
        ret = cal_db_util_query_exec(query);
@@ -312,7 +312,7 @@ void cal_db_initialize_view_table(void)
        }
 
        /*
-        * event_calendar view  :  CALENDAR_VIEW_EVENT_CALENDAR
+        * event_calendar view  :  CALENDAR_VIEW_EVENT_BOOK
         * A : schedule_table
         * B : rrule_table
         * C : calendar_table
@@ -328,7 +328,7 @@ void cal_db_initialize_view_table(void)
                        "JOIN %s C ON A.calendar_id = C.id "
                        "LEFT OUTER JOIN %s B ON A.id = B.event_id "
                        "WHERE A.type = 1 AND c.deleted = 0 AND A.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_EVENT_CALENDAR,
+                       CAL_VIEW_TABLE_EVENT_BOOK,
                        CAL_TABLE_SCHEDULE, CAL_TABLE_CALENDAR,
                        CAL_TABLE_RRULE);
        ret = cal_db_util_query_exec(query);
@@ -340,7 +340,7 @@ void cal_db_initialize_view_table(void)
        }
 
        /*
-        * todo_calendar view  : CALENDAR_VIEW_TODO_CALENDAR
+        * todo_calendar view  : CALENDAR_VIEW_TODO_BOOK
         * A : schedule_table
         * B : rrule_table
         * C : calendar_table
@@ -356,7 +356,7 @@ void cal_db_initialize_view_table(void)
                        "JOIN %s C ON A.calendar_id = C.id "
                        "LEFT OUTER JOIN %s B ON A.id = B.event_id "
                        "WHERE A.type = 2 AND c.deleted = 0 AND A.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_TODO_CALENDAR,
+                       CAL_VIEW_TABLE_TODO_BOOK,
                        CAL_TABLE_SCHEDULE, CAL_TABLE_CALENDAR,
                        CAL_TABLE_RRULE);
        ret = cal_db_util_query_exec(query);
@@ -368,7 +368,7 @@ void cal_db_initialize_view_table(void)
        }
 
        /*
-        * event_calendar_attendee view  :  CALENDAR_VIEW_EVENT_CALENDAR_ATTENDEE
+        * event_calendar_attendee view  :  CALENDAR_VIEW_EVENT_BOOK_ATTENDEE
         * A : schedule_table
         * B : attendee_table
         * C : calendar_table
@@ -386,7 +386,7 @@ void cal_db_initialize_view_table(void)
                        "JOIN %s C ON A.calendar_id = C.id "
                        "LEFT OUTER JOIN %s D ON A.id = D.event_id "
                        "WHERE A.type = 1 AND c.deleted = 0 AND A.is_deleted = 0 ",
-                       CAL_VIEW_TABLE_EVENT_CALENDAR_ATTENDEE,
+                       CAL_VIEW_TABLE_EVENT_BOOK_ATTENDEE,
                        CAL_TABLE_SCHEDULE, CAL_TABLE_ATTENDEE, CAL_TABLE_CALENDAR,
                        CAL_TABLE_RRULE);
        ret = cal_db_util_query_exec(query);