-#ifdef LOG_TAG
-#undef LOG_TAG
-#endif
-
-#define LOG_TAG "RUA"
-
-#define RUA_STAT_DB_NAME ".rua_stat.db"
-#define QUERY_MAXLEN 4096
-#define WIN_SCORE 100
-#define LOSE_SCORE_RATE 0.7f
-
-static sqlite3 *_db = NULL;
-static int __exec(sqlite3 *db, char *query);
-static sqlite3 *__db_init(char *root, int flags);
-
-
-int __rua_stat_insert(char *caller, char *rua_stat_tag) {
-
- int r;
- char query[QUERY_MAXLEN];
- sqlite3_stmt *stmt = NULL;
- sqlite3_snprintf(QUERY_MAXLEN, query,
- "INSERT INTO rua_panel_stat (caller_panel, rua_stat_tag, score) VALUES (?,?,?)");
-
- r = sqlite3_prepare(_db, query, sizeof(query), &stmt, NULL);
- if (r != SQLITE_OK) {
- LOGE("sqlite3_prepare error(%d , %d, %s)", r, sqlite3_extended_errcode(_db), sqlite3_errmsg(_db));
- goto out;
- }
-
- r = sqlite3_bind_text(stmt, 1, caller, strlen(caller), SQLITE_STATIC);
- if(r != SQLITE_OK) {
- LOGE("caller bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_bind_text(stmt, 2, rua_stat_tag, strlen(rua_stat_tag), SQLITE_STATIC);
- if(r != SQLITE_OK) {
- LOGE("rua_stat_tag bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_bind_int(stmt, 3, WIN_SCORE);
- if(r != SQLITE_OK) {
- LOGE("arg bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_step(stmt);
- if (r != SQLITE_DONE) {
- LOGE("step error(%d) \n", r);
- goto out;
- }
-
-
-out :
- if(stmt)
- sqlite3_finalize(stmt);
-
- return r;
-}
-
-int __rua_stat_lose_score_update(char *caller, char *rua_stat_tag) {
-
- int r;
- char query[QUERY_MAXLEN];
- sqlite3_stmt *stmt = NULL;
- sqlite3_snprintf(QUERY_MAXLEN, query,
- "UPDATE rua_panel_stat SET score = score * %f WHERE caller_panel = ? AND rua_stat_tag != ?",
- LOSE_SCORE_RATE);
-
- LOGD("lose score update sql : %s", query);
-
- r = sqlite3_prepare(_db, query, sizeof(query), &stmt, NULL);
- if (r != SQLITE_OK) {
- LOGE("sqlite3_prepare error(%d , %d, %s)", r, sqlite3_extended_errcode(_db), sqlite3_errmsg(_db));
- goto out;
- }
-
- r = sqlite3_bind_text(stmt, 1, caller, strlen(caller), SQLITE_STATIC);
- if(r != SQLITE_OK) {
- LOGE("caller bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_bind_text(stmt, 2, rua_stat_tag, strlen(rua_stat_tag), SQLITE_STATIC);
- if(r != SQLITE_OK) {
- LOGE("rua_stat_tag bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_step(stmt);
- if (r != SQLITE_DONE) {
- LOGE("step error(%d) \n", r);
- goto out;
- }
-
-
-out :
- if(stmt)
- sqlite3_finalize(stmt);
-
- return r;
-
-}
-
-int __rua_stat_win_score_update(char *caller, char *rua_stat_tag) {
-
- int r;
- char query[QUERY_MAXLEN];
- sqlite3_stmt *stmt = NULL;
- sqlite3_snprintf(QUERY_MAXLEN, query,
- "UPDATE rua_panel_stat SET score = score + %d WHERE caller_panel = ? AND rua_stat_tag = ?",
- WIN_SCORE);
-
- LOGD("win score update sql : %s", query);
-
- r = sqlite3_prepare(_db, query, sizeof(query), &stmt, NULL);
- if (r != SQLITE_OK) {
- LOGE("sqlite3_prepare error(%d , %d, %s)", r, sqlite3_extended_errcode(_db), sqlite3_errmsg(_db));
- goto out;
- }
-
- r = sqlite3_bind_text(stmt, 1, caller, strlen(caller), SQLITE_STATIC);
- if(r != SQLITE_OK) {
- LOGE("caller bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_bind_text(stmt, 2, rua_stat_tag, strlen(rua_stat_tag), SQLITE_STATIC);
- if(r != SQLITE_OK) {
- LOGE("rua_stat_tag bind error(%d) \n", r);
- goto out;
- }
-
- r = sqlite3_step(stmt);
- if (r != SQLITE_DONE) {
- LOGE("step error(%d) \n", r);
- goto out;
- }
-
-
-out :
- if(stmt)
- sqlite3_finalize(stmt);
-
- return r;
-
-}