2 PATH=/bin:/usr/bin:/sbin:/usr/sbin
4 source /etc/tizen-platform.conf
6 PARSER_DB_NAME=.pkgmgr_parser.db
7 PARSER_DB_PATH=$TZ_SYS_DB/$PARSER_DB_NAME
9 function migrate_cert_db() {
10 echo "PRAGMA user_version=30004;" | sqlite3 $TZ_SYS_DB/.pkgmgr_cert.db
13 function migrate_parser_db() {
16 echo -e "CREATE TABLE IF NOT EXISTS package_dependency_info (\n" \
17 " package TEXT NOT NULL,\n" \
18 " depends_on TEXT NOT NULL,\n" \
19 " type TEXT NOT NULL,\n" \
20 " required_version TEXT,\n" \
21 " PRIMARY KEY(package, depends_on),\n" \
22 " FOREIGN KEY(package)\n" \
23 " REFERENCES package_info(package) ON DELETE CASCADE);" | sqlite3 $dbpath
25 echo -e "CREATE TABLE IF NOT EXISTS package_plugin_info (\n" \
26 " pkgid TEXT NOT NULL,\n" \
28 " plugin_type TEXT NOT NULL,\n" \
29 " plugin_name TEXT NOT NULL);" | sqlite3 $dbpath
31 echo "PRAGMA user_version=30004;" | sqlite3 $dbpath
34 function migrate_user_db() {
35 #get each user db path and call migrate_parser_db for each of it
37 find $TZ_SYS_DB/user -name $PARSER_DB_NAME | while read DBPATH
39 migrate_parser_db $DBPATH
43 migrate_parser_db $PARSER_DB_PATH