diff options
Diffstat (limited to 'src/appsvc_db.c')
| -rwxr-xr-x | src/appsvc_db.c | 239 |
1 files changed, 239 insertions, 0 deletions
diff --git a/src/appsvc_db.c b/src/appsvc_db.c new file mode 100755 index 0000000..d56ca16 --- /dev/null +++ b/src/appsvc_db.c @@ -0,0 +1,239 @@ +/* + * app-svc + * + * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved. + * + * Contact: Jayoun Lee <airjany@samsung.com>, Sewook Park <sewook7.park@samsung.com>, Jaeho Lee <jaeho81.lee@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. + * + */ + + +#include <stdio.h> +#include <string.h> +#include <stdlib.h> + +#include "appsvc_db.h" +#include "internal.h" + + +#define SVC_DB_PATH "/opt/dbspace/.appsvc.db" +#define QUERY_MAXLEN 4096 +#define BUF_MAX_LEN 1024 + +static sqlite3 *svc_db = NULL; + + +/** + * db initialize + */ +static int __init(void) +{ + int rc; + + if (svc_db) { + _D("Already initialized\n"); + return 0; + } + + rc = sqlite3_open(SVC_DB_PATH, &svc_db); + if(rc) { + _E("Can't open database: %s", sqlite3_errmsg(svc_db)); + goto err; + } + + // Enable persist journal mode + rc = sqlite3_exec(svc_db, "PRAGMA journal_mode = PERSIST", NULL, NULL, NULL); + if(SQLITE_OK!=rc){ + _D("Fail to change journal mode\n"); + goto err; + } + + return 0; +err: + sqlite3_close(svc_db); + return -1; +} + +static int __fini(void) +{ + if (svc_db) { + sqlite3_close(svc_db); + svc_db = NULL; + } + return 0; +} + + +int _svc_db_add_app(const char *op, const char *mime_type, const char *uri, const char *pkg_name) +{ + int ret = -1; + char m[BUF_MAX_LEN]; + char u[BUF_MAX_LEN]; + char query[BUF_MAX_LEN]; + char* error_message = NULL; + + if(__init()<0) + return -1; + + if(op == NULL ) + return -1; + + if(mime_type==NULL) + strncpy(m,"NULL",BUF_MAX_LEN-1); + else + strncpy(m,mime_type,BUF_MAX_LEN-1); + + if(uri==NULL) + strncpy(u,"NULL",BUF_MAX_LEN-1); + else + strncpy(u,uri,BUF_MAX_LEN-1); + + sprintf(query,"insert into appsvc( operation, mime_type, uri, pkg_name) \ + values('%s','%s','%s','%s')",op,m,u,pkg_name); + + if (SQLITE_OK != sqlite3_exec(svc_db, query, NULL, NULL, &error_message)) + { + _E("Don't execute query = %s, error message = %s\n", query, error_message); + return -1; + } + + __fini(); + return 0; +} + +int _svc_db_delete_with_pkgname(const char *pkg_name) +{ + char query[BUF_MAX_LEN]; + char* error_message = NULL; + + if(pkg_name == NULL) { + _E("Invalid argument: data to delete is NULL\n"); + return -1; + } + + if(__init()<0) + return -1; + + snprintf(query, BUF_MAX_LEN, "delete from appsvc where pkg_name = '%s';", pkg_name); + + if (SQLITE_OK != sqlite3_exec(svc_db, query, NULL, NULL, &error_message)) + { + _E("Don't execute query = %s, error message = %s\n", query, error_message); + return -1; + } + + __fini(); + + return 0; +} + +int _svc_db_is_defapp(const char *pkg_name) +{ + char query[BUF_MAX_LEN]; + char* error_message = NULL; + sqlite3_stmt *stmt; + int cnt = 0; + int ret = -1; + + if(pkg_name == NULL) { + _E("Invalid argument: data to delete is NULL\n"); + return 0; + } + + if(__init()<0) + return 0; + + snprintf(query, BUF_MAX_LEN, + "select count(*) from appsvc where pkg_name = '%s';", pkg_name); + + ret = sqlite3_prepare(svc_db, query, sizeof(query), &stmt, NULL); + if (ret != SQLITE_OK) { + return -1; + } + + ret = sqlite3_step(stmt); + if (ret == SQLITE_ROW) { + cnt = sqlite3_column_int(stmt, 0); + } + sqlite3_finalize(stmt); + + __fini(); + + if(cnt < 1) return 0; + + return 1; +} + +char* _svc_db_get_app(const char *op, const char *mime_type, const char *uri) +{ + char* res = NULL; + char m[BUF_MAX_LEN]; + char u[BUF_MAX_LEN]; + char query[BUF_MAX_LEN]; + char* error_message = NULL; + sqlite3_stmt* stmt; + int ret; + char* pkgname; + + if(op == NULL ) + return NULL; + + if(mime_type==NULL) + strncpy(m,"NULL",BUF_MAX_LEN-1); + else + strncpy(m,mime_type,BUF_MAX_LEN-1); + + if(uri==NULL) + strncpy(u,"NULL",BUF_MAX_LEN-1); + else + strncpy(u,uri,BUF_MAX_LEN-1); + +// if(doubt_sql_injection(mime_type)) +// return NULL; + + if(__init() < 0) + return NULL; + + + sprintf(query,"select pkg_name from appsvc where operation='%s' and mime_type='%s' and uri='%s'",\ + op,m,u); + + _D("query : %s\n",query); + + ret = sqlite3_prepare(svc_db, query, strlen(query), &stmt, NULL); + + if ( ret != SQLITE_OK) { + _E("prepare error\n"); + return NULL; + } + + ret = sqlite3_step(stmt); + if (ret == SQLITE_DONE) { + return NULL; + } + + pkgname = malloc(BUF_MAX_LEN); + strncpy(pkgname, sqlite3_column_text(stmt, 0),BUF_MAX_LEN-1); + //pkgname = (char*) sqlite3_column_text(stmt, 0); + + _D("pkgname : %s\n",pkgname); + + ret = sqlite3_finalize(stmt); + + __fini(); + + return pkgname; +} + |