1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
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__
|
