Tizen 2.0 Releasesubmit/tizen_2.0/20130216.100704accepted/tizen_2.0/20130216.0940012.0_releasetizen_2.0

1 files changed, 78 insertions, 0 deletions

diff --git a/native/ctsvc_sqlite.h b/native/ctsvc_sqlite.h
new file mode 100755
index 0000000..696b36d
--- /dev/null
+++ b/native/ctsvc_sqlite.h
@@ -0,0 +1,78 @@
+/*
+ * Contacts Service
+ *
+ * Copyright (c) 2010 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Dohyung Jin <dh.jin@samsung.com>
+ *                 Jongwon Lee <gogosing.lee@samsung.com>
+ *                 Donghee Ye <donghee.ye@samsung.com>
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ *
+ */
+
+#ifndef __TIZEN_SOCIAL_CTSVC_SQLITE_H__
+#define __TIZEN_SOCIAL_CTSVC_SQLITE_H__
+
+#include <sqlite3.h>
+
+#define CTS_SQL_MAX_LEN   2048 //normal string length
+#define CTS_SQL_MIN_LEN  1024 //short sql string length
+
+typedef sqlite3_stmt* cts_stmt;
+
+int ctsvc_db_open(void);
+int ctsvc_db_close(void);
+int cts_db_change();
+int cts_db_get_last_insert_id(void);
+int cts_db_get_next_id(const char *table);
+
+int ctsvc_query_get_first_int_result(const char *query, int *result);
+int ctsvc_query_exec(const char *query);
+cts_stmt cts_query_prepare(char *query);
+
+int cts_stmt_step(cts_stmt stmt);
+void cts_stmt_reset(cts_stmt stmt);
+void cts_stmt_finalize(cts_stmt stmt);
+
+int ctsvc_stmt_get_first_int_result(cts_stmt stmt, int *result);
+
+
+static inline double ctsvc_stmt_get_dbl(cts_stmt stmt, int pos) {
+	return sqlite3_column_double(stmt, pos);
+}
+static inline int ctsvc_stmt_get_int(cts_stmt stmt, int pos) {
+	return sqlite3_column_int(stmt, pos);
+}
+static inline char* ctsvc_stmt_get_text(cts_stmt stmt, int pos) {
+	return (char *)sqlite3_column_text(stmt, pos);
+}
+static inline long long int ctsvc_stmt_get_int64(cts_stmt stmt, int pos) {
+	return sqlite3_column_int64(stmt, pos);
+}
+
+static inline int cts_stmt_bind_int(cts_stmt stmt, int pos, int num) {
+	return sqlite3_bind_int(stmt, pos, num);
+}
+static inline int cts_stmt_bind_text(cts_stmt stmt, int pos, const char *str) {
+	return sqlite3_bind_text(stmt, pos, str, strlen(str), SQLITE_STATIC);
+}
+static inline int cts_stmt_bind_copy_text(cts_stmt stmt, int pos,
+		const char *str, int strlen){
+	return sqlite3_bind_text(stmt, pos, str, strlen, SQLITE_TRANSIENT);
+}
+
+int cts_stmt_bind_copy_text(cts_stmt stmt, int pos, const char *str, int strlen);
+
+
+#endif //__TIZEN_SOCIAL_CTSVC_SQLITE_H__