Tizen 2.1 base

14 files changed, 1141 insertions, 0 deletions

diff --git a/CMakeLists.txt b/CMakeLists.txt
new file mode 100644
index 0000000..01055ed
--- /dev/null
+++ b/CMakeLists.txt
@@ -0,0 +1,46 @@
+CMAKE_MINIMUM_REQUIRED(VERSION 2.6)
+PROJECT(rua C)
+
+SET(PREFIX ${CMAKE_INSTALL_PREFIX})
+SET(EXEC_PREFIX "\${prefix}")
+SET(LIBDIR "\${prefix}/lib")
+SET(INCLUDEDIR "\${prefix}/include/${PROJECT_NAME}")
+SET(VERSION 0.1.0)
+
+SET(SRCS
+	src/perf-measure.c
+	src/rua.c
+)
+
+INCLUDE_DIRECTORIES(${CMAKE_SOURCE_DIR}/include)
+
+INCLUDE(FindPkgConfig)
+pkg_check_modules(pkgs REQUIRED sqlite3 db-util)
+
+FOREACH(flag ${pkgs_CFLAGS})
+	SET(EXTRA_CFLAGS "${EXTRA_CFLAGS} ${flag}")
+ENDFOREACH(flag)
+
+SET(EXTRA_CFLAGS "${EXTRA_CFLAGS} -fvisibility=hidden")
+
+SET(CMAKE_C_FLAGS "${CMAKE_C_FLAGS} ${EXTRA_CFLAGS}")
+
+ADD_DEFINITIONS("-DPREFIX=\"${PREFIX}\"")
+ADD_DEFINITIONS("-DFACTORYFS=\"$ENV{FACTORYFS}\"")
+ADD_DEFINITIONS("-DDATAFS=\"$ENV{DATADIR}\"")
+
+ADD_LIBRARY(${PROJECT_NAME} SHARED ${SRCS})
+SET_TARGET_PROPERTIES(${PROJECT_NAME} PROPERTIES SOVERSION 0)
+SET_TARGET_PROPERTIES(${PROJECT_NAME} PROPERTIES VERSION ${VERSION})
+TARGET_LINK_LIBRARIES(${PROJECT_NAME} ${pkgs_LDFLAGS})
+
+CONFIGURE_FILE(${PROJECT_NAME}.pc.in ${PROJECT_NAME}.pc @ONLY)
+#CONFIGURE_FILE(${PROJECT_NAME}.pc.in ${CMAKE_CURRENT_BINARY_DIR}/${PROJECT_NAME}.pc @ONLY)
+
+INSTALL(TARGETS ${PROJECT_NAME} DESTINATION lib COMPONENT RuntimeLibraries)
+INSTALL(FILES ${CMAKE_CURRENT_BINARY_DIR}/${PROJECT_NAME}.pc DESTINATION lib/pkgconfig)
+INSTALL(FILES ${CMAKE_CURRENT_SOURCE_DIR}/include/rua.h DESTINATION include/${PROJECT_NAME})
+
+INSTALL(FILES ${CMAKE_CURRENT_SOURCE_DIR}/data/rua_db.sql DESTINATION /opt/share/)
+
+#ADD_SUBDIRECTORY(test)
diff --git a/LICENSE b/LICENSE
new file mode 100644
index 0000000..bae7f54
--- /dev/null
+++ b/LICENSE
@@ -0,0 +1,204 @@
+Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.

+

+                                 Apache License

+                           Version 2.0, January 2004

+                        http://www.apache.org/licenses/

+

+   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION

+

+   1. Definitions.

+

+      "License" shall mean the terms and conditions for use, reproduction,

+      and distribution as defined by Sections 1 through 9 of this document.

+

+      "Licensor" shall mean the copyright owner or entity authorized by

+      the copyright owner that is granting the License.

+

+      "Legal Entity" shall mean the union of the acting entity and all

+      other entities that control, are controlled by, or are under common

+      control with that entity. For the purposes of this definition,

+      "control" means (i) the power, direct or indirect, to cause the

+      direction or management of such entity, whether by contract or

+      otherwise, or (ii) ownership of fifty percent (50%) or more of the

+      outstanding shares, or (iii) beneficial ownership of such entity.

+

+      "You" (or "Your") shall mean an individual or Legal Entity

+      exercising permissions granted by this License.

+

+      "Source" form shall mean the preferred form for making modifications,

+      including but not limited to software source code, documentation

+      source, and configuration files.

+

+      "Object" form shall mean any form resulting from mechanical

+      transformation or translation of a Source form, including but

+      not limited to compiled object code, generated documentation,

+      and conversions to other media types.

+

+      "Work" shall mean the work of authorship, whether in Source or

+      Object form, made available under the License, as indicated by a

+      copyright notice that is included in or attached to the work

+      (an example is provided in the Appendix below).

+

+      "Derivative Works" shall mean any work, whether in Source or Object

+      form, that is based on (or derived from) the Work and for which the

+      editorial revisions, annotations, elaborations, or other modifications

+      represent, as a whole, an original work of authorship. For the purposes

+      of this License, Derivative Works shall not include works that remain

+      separable from, or merely link (or bind by name) to the interfaces of,

+      the Work and Derivative Works thereof.

+

+      "Contribution" shall mean any work of authorship, including

+      the original version of the Work and any modifications or additions

+      to that Work or Derivative Works thereof, that is intentionally

+      submitted to Licensor for inclusion in the Work by the copyright owner

+      or by an individual or Legal Entity authorized to submit on behalf of

+      the copyright owner. For the purposes of this definition, "submitted"

+      means any form of electronic, verbal, or written communication sent

+      to the Licensor or its representatives, including but not limited to

+      communication on electronic mailing lists, source code control systems,

+      and issue tracking systems that are managed by, or on behalf of, the

+      Licensor for the purpose of discussing and improving the Work, but

+      excluding communication that is conspicuously marked or otherwise

+      designated in writing by the copyright owner as "Not a Contribution."

+

+      "Contributor" shall mean Licensor and any individual or Legal Entity

+      on behalf of whom a Contribution has been received by Licensor and

+      subsequently incorporated within the Work.

+

+   2. Grant of Copyright License. Subject to the terms and conditions of

+      this License, each Contributor hereby grants to You a perpetual,

+      worldwide, non-exclusive, no-charge, royalty-free, irrevocable

+      copyright license to reproduce, prepare Derivative Works of,

+      publicly display, publicly perform, sublicense, and distribute the

+      Work and such Derivative Works in Source or Object form.

+

+   3. Grant of Patent License. Subject to the terms and conditions of

+      this License, each Contributor hereby grants to You a perpetual,

+      worldwide, non-exclusive, no-charge, royalty-free, irrevocable

+      (except as stated in this section) patent license to make, have made,

+      use, offer to sell, sell, import, and otherwise transfer the Work,

+      where such license applies only to those patent claims licensable

+      by such Contributor that are necessarily infringed by their

+      Contribution(s) alone or by combination of their Contribution(s)

+      with the Work to which such Contribution(s) was submitted. If You

+      institute patent litigation against any entity (including a

+      cross-claim or counterclaim in a lawsuit) alleging that the Work

+      or a Contribution incorporated within the Work constitutes direct

+      or contributory patent infringement, then any patent licenses

+      granted to You under this License for that Work shall terminate

+      as of the date such litigation is filed.

+

+   4. Redistribution. You may reproduce and distribute copies of the

+      Work or Derivative Works thereof in any medium, with or without

+      modifications, and in Source or Object form, provided that You

+      meet the following conditions:

+

+      (a) You must give any other recipients of the Work or

+          Derivative Works a copy of this License; and

+

+      (b) You must cause any modified files to carry prominent notices

+          stating that You changed the files; and

+

+      (c) You must retain, in the Source form of any Derivative Works

+          that You distribute, all copyright, patent, trademark, and

+          attribution notices from the Source form of the Work,

+          excluding those notices that do not pertain to any part of

+          the Derivative Works; and

+

+      (d) If the Work includes a "NOTICE" text file as part of its

+          distribution, then any Derivative Works that You distribute must

+          include a readable copy of the attribution notices contained

+          within such NOTICE file, excluding those notices that do not

+          pertain to any part of the Derivative Works, in at least one

+          of the following places: within a NOTICE text file distributed

+          as part of the Derivative Works; within the Source form or

+          documentation, if provided along with the Derivative Works; or,

+          within a display generated by the Derivative Works, if and

+          wherever such third-party notices normally appear. The contents

+          of the NOTICE file are for informational purposes only and

+          do not modify the License. You may add Your own attribution

+          notices within Derivative Works that You distribute, alongside

+          or as an addendum to the NOTICE text from the Work, provided

+          that such additional attribution notices cannot be construed

+          as modifying the License.

+

+      You may add Your own copyright statement to Your modifications and

+      may provide additional or different license terms and conditions

+      for use, reproduction, or distribution of Your modifications, or

+      for any such Derivative Works as a whole, provided Your use,

+      reproduction, and distribution of the Work otherwise complies with

+      the conditions stated in this License.

+

+   5. Submission of Contributions. Unless You explicitly state otherwise,

+      any Contribution intentionally submitted for inclusion in the Work

+      by You to the Licensor shall be under the terms and conditions of

+      this License, without any additional terms or conditions.

+      Notwithstanding the above, nothing herein shall supersede or modify

+      the terms of any separate license agreement you may have executed

+      with Licensor regarding such Contributions.

+

+   6. Trademarks. This License does not grant permission to use the trade

+      names, trademarks, service marks, or product names of the Licensor,

+      except as required for reasonable and customary use in describing the

+      origin of the Work and reproducing the content of the NOTICE file.

+

+   7. Disclaimer of Warranty. Unless required by applicable law or

+      agreed to in writing, Licensor provides the Work (and each

+      Contributor provides its Contributions) on an "AS IS" BASIS,

+      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or

+      implied, including, without limitation, any warranties or conditions

+      of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A

+      PARTICULAR PURPOSE. You are solely responsible for determining the

+      appropriateness of using or redistributing the Work and assume any

+      risks associated with Your exercise of permissions under this License.

+

+   8. Limitation of Liability. In no event and under no legal theory,

+      whether in tort (including negligence), contract, or otherwise,

+      unless required by applicable law (such as deliberate and grossly

+      negligent acts) or agreed to in writing, shall any Contributor be

+      liable to You for damages, including any direct, indirect, special,

+      incidental, or consequential damages of any character arising as a

+      result of this License or out of the use or inability to use the

+      Work (including but not limited to damages for loss of goodwill,

+      work stoppage, computer failure or malfunction, or any and all

+      other commercial damages or losses), even if such Contributor

+      has been advised of the possibility of such damages.

+

+   9. Accepting Warranty or Additional Liability. While redistributing

+      the Work or Derivative Works thereof, You may choose to offer,

+      and charge a fee for, acceptance of support, warranty, indemnity,

+      or other liability obligations and/or rights consistent with this

+      License. However, in accepting such obligations, You may act only

+      on Your own behalf and on Your sole responsibility, not on behalf

+      of any other Contributor, and only if You agree to indemnify,

+      defend, and hold each Contributor harmless for any liability

+      incurred by, or claims asserted against, such Contributor by reason

+      of your accepting any such warranty or additional liability.

+

+   END OF TERMS AND CONDITIONS

+

+   APPENDIX: How to apply the Apache License to your work.

+

+      To apply the Apache License to your work, attach the following

+      boilerplate notice, with the fields enclosed by brackets "[]"

+      replaced with your own identifying information. (Don't include

+      the brackets!)  The text should be enclosed in the appropriate

+      comment syntax for the file format. We also recommend that a

+      file or class name and description of purpose be included on the

+      same "printed page" as the copyright notice for easier

+      identification within third-party archives.

+

+   Copyright [yyyy] [name of copyright owner]

+

+   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.

+

diff --git a/NOTICE b/NOTICE
new file mode 100644
index 0000000..4c49449
--- /dev/null
+++ b/NOTICE
@@ -0,0 +1 @@
+Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
diff --git a/data/rua_db.sql b/data/rua_db.sql
new file mode 100644
index 0000000..4ae26ca
--- /dev/null
+++ b/data/rua_db.sql
@@ -0,0 +1,9 @@
+PRAGMA journal_mode = PERSIST;
+
+CREATE TABLE IF NOT EXISTS rua_history (
+	id INTEGER PRIMARY KEY,
+	pkg_name TEXT,
+	app_path TEXT,
+	arg TEXT,
+	launch_time INTEGER
+);
diff --git a/include/db-schema.h b/include/db-schema.h
new file mode 100644
index 0000000..f405aea
--- /dev/null
+++ b/include/db-schema.h
@@ -0,0 +1,42 @@
+/*
+ *  RUA
+ *
+ * Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@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 __RUA_SCHEMA_H__
+#define __RUA_SCHEMA_H__
+
+#define CREATE_RUA_HISTORY_TABLE " \
+create table if not exists rua_history ( \
+id INTEGER PRIMARY KEY, \
+pkg_name TEXT, \
+app_path TEXT, \
+arg TEXT, \
+launch_time INTEGER \
+);"
+
+/* table index */
+enum {
+	RUA_COL_ID = 0x00,
+	RUA_COL_PKGNAME,
+	RUA_COL_APPPATH,
+	RUA_COL_ARG,
+	RUA_COL_LAUNCHTIME
+};
+#endif				/* __RUA_SCHEMA_H__ */
diff --git a/include/perf-measure.h b/include/perf-measure.h
new file mode 100644
index 0000000..49dcc68
--- /dev/null
+++ b/include/perf-measure.h
@@ -0,0 +1,66 @@
+/*
+ *  RUA
+ *
+ * Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@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 __PERF_MEASURE__
+#define __PERF_MEASURE__
+
+#include <time.h>
+
+
+//#define PERF_MEASURE_ENABLE
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+#ifdef PERF_MEASURE_ENABLE
+
+unsigned int _perf_measure_start(const char *tag, char *func_name, int line);
+unsigned int _perf_measure_end(const char *tag, unsigned int ts_start,
+			char *func_name, int line);
+
+#define PERF_MEASURE_START(tag) _perf_measure_start(tag, __func__,__LINE__)
+#define PERF_MEASURE_END(tag, ts_start) \
+	_perf_measure_end(tag, ts_start,__func__, __LINE__)
+
+#else
+
+#define PERF_MEASURE_START(tag) (0)
+#define PERF_MEASURE_END(tag, ts_start) (0)
+
+#endif
+
+
+
+
+
+
+
+
+
+
+
+
+
+#ifdef __cplusplus
+}
+#endif
+#endif				/*__PERF_MEASURE__*/
diff --git a/include/rua.h b/include/rua.h
new file mode 100755
index 0000000..642e617
--- /dev/null
+++ b/include/rua.h
@@ -0,0 +1,167 @@
+/*
+ *  RUA
+ *
+ * Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@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.
+ *
+ */
+
+/**
+ * @file 	rua.h
+ * @brief       RUA API declaration header file.
+ * @author      Jinwoo Nam (jwoo.nam@samsung.com)
+ * @version     0.1
+ * @history     0.1: RUA API Declarations, structure declaration
+ */
+
+#ifndef __RUA_H__
+#define __RUA_H__
+
+#include <sqlite3.h>
+#include <time.h>
+
+#ifndef API
+#define API __attribute__ ((visibility("default")))
+#endif
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+/**
+ * @defgroup RUA rua
+ * @{
+ */
+
+/**
+ * @}
+ */
+
+/**
+ * @addtogroup RUA
+ * @{
+ */
+
+/**
+ * @struct rua_rec
+ * @brief RUA record info structure
+ */
+struct rua_rec {
+	int id;		/**<  primary key */
+	char *pkg_name;		/**< package name */
+	char *app_path;		/**< application path */
+	char *arg;		/**< application launching argument */
+	time_t launch_time;		/**< application launching time */
+};
+
+/**
+ * @brief	Clear history
+ * @return 	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_clear_history(void);
+
+/**
+ * @brief	Delete history with pkg_name
+ * @param[in]	pkg_name package name to delete history
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_delete_history_with_pkgname(char *pkg_name);
+
+/**
+ * @brief	Delete history with app_path
+ * @param[in]	app_path package name to delete history
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_delete_history_with_apppath(char *app_path);
+
+/**
+ * @brief	Add application to recently used application list
+ * @param[in]	rec  record to add history
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_add_history(struct rua_rec *rec);
+
+/**
+ * @brief	Load recently used application history db.
+ * @param[out]	table db table pointer
+ * @param[out]	nrows the number of record
+ * @param[out]	ncols the number of field
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_history_load_db(char ***table, int *nrows, int *ncols);
+
+/**
+ * @brief	Unload recently used application history db.
+ * @param[in]	table db table pointer to unload
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_history_unload_db(char ***table);
+
+/**
+ * @brief	Load recently used application record.
+ * @param[out]	rec record to load
+ * @param[in]	table db table pointer
+ * @param[in]	nrows the number of record
+ * @param[in]	ncols the number of field
+ * @param[in]	row record index to load
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_history_get_rec(struct rua_rec *rec, char **table,
+				int nrows, int ncols, int row);
+
+/**
+ * @brief	Check some package is latest or not with package name
+ * @param[in]	pkg_name package name
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 if given pkg_name is lastest application
+ * @retval	-1 if not lastest applicaton or on failed
+ */
+API int rua_is_latest_app(const char *pkg_name);
+
+/**
+ * @brief	Initialize rua
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_init(void);
+
+/**
+ * @brief	Finalize rua
+ * @return	0 on success, otherwise a nagative error value
+ * @retval	0 on successful
+ * @retval	-1 on failed
+ */
+API int rua_fini(void);
+
+#ifdef __cplusplus
+}
+#endif
+#endif				/*__RUA_H__*/
diff --git a/librua.manifest b/librua.manifest
new file mode 100644
index 0000000..eab0f7e
--- /dev/null
+++ b/librua.manifest
@@ -0,0 +1,15 @@
+<manifest>
+	<define>
+		<domain name="rua"/>
+		<provide>
+			<label name="rua::db"/>
+		</provide>
+	</define>
+	<request>
+		<domain name="rua"/>
+	</request>
+	<assign>
+		<filesystem path="/usr/lib/librua.so.0" label="_"/>
+		<filesystem path="/usr/lib/librua.so.0.1.0" label="_"/>
+	</assign>
+</manifest>
diff --git a/packaging/librua.spec b/packaging/librua.spec
new file mode 100644
index 0000000..ae7f5d2
--- /dev/null
+++ b/packaging/librua.spec
@@ -0,0 +1,74 @@
+
+Name:       librua
+Summary:    Recently used application
+Version:    0.1.0
+Release:    34
+Group:      System/Libraries
+License:    Apache License, Version 2.0
+Source0:    librua-%{version}.tar.gz
+Requires(post): /sbin/ldconfig
+Requires(post): /usr/bin/sqlite3
+Requires(postun): /sbin/ldconfig
+BuildRequires:  cmake
+BuildRequires:  pkgconfig(sqlite3)
+BuildRequires:  pkgconfig(db-util)
+
+
+%description
+Recently used application library
+
+
+
+%package devel
+Summary:    Recently used application (devel)
+Group:      Development/Libraries
+Requires:   %{name} = %{version}-%{release}
+
+%description devel
+Recently used application library (devel)
+
+
+%prep
+%setup -q -n %{name}-%{version}
+
+
+%build
+cmake . -DCMAKE_INSTALL_PREFIX=%{_prefix}
+
+
+make %{?jobs:-j%jobs}
+
+%install
+rm -rf %{buildroot}
+%make_install
+
+%post
+/sbin/ldconfig
+mkdir -p /opt/dbspace/
+sqlite3 /opt/dbspace/.rua.db < /opt/share/rua_db.sql
+rm -rf /opt/share/rua_db.sql
+chown 0:5000 /opt/dbspace/.rua.db
+chown 0:5000 /opt/dbspace/.rua.db-journal
+chmod 660 /opt/dbspace/.rua.db
+chmod 660 /opt/dbspace/.rua.db-journal
+chsmack -a rua::db /opt/dbspace/.rua.db
+chsmack -a rua::db /opt/dbspace/.rua.db-journal
+
+%postun -p /sbin/ldconfig
+
+
+
+%files
+%manifest librua.manifest
+%defattr(-,root,root,-)
+%config(missingok) /opt/share/rua_db.sql
+/usr/lib/librua.so.*
+
+
+
+%files devel
+%defattr(-,root,root,-)
+/usr/include/rua/*.h
+/usr/lib/librua.so
+/usr/lib/pkgconfig/rua.pc
+
diff --git a/rua.pc.in b/rua.pc.in
new file mode 100644
index 0000000..08e4410
--- /dev/null
+++ b/rua.pc.in
@@ -0,0 +1,11 @@
+prefix=@PREFIX@
+exec_prefix=@EXEC_PREFIX@
+libdir=@LIBDIR@
+includedir=@INCLUDEDIR@
+
+Name: rua
+Description: recently used application library
+Version: @VERSION@
+Requires: sqlite3
+Libs: -L${libdir} -lrua
+Cflags: -I${includedir}
diff --git a/src/perf-measure.c b/src/perf-measure.c
new file mode 100644
index 0000000..5168852
--- /dev/null
+++ b/src/perf-measure.c
@@ -0,0 +1,63 @@
+/*
+ *  RUA
+ *
+ * Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@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 <sys/time.h>
+
+unsigned int _perf_measure_start(const char *tag, char *func_name, int line)
+{
+	struct timeval t;
+	unsigned int ts_start;
+
+	if (!tag)
+		return 0;
+
+	gettimeofday(&t, NULL);
+	ts_start = t.tv_sec * 1000000UL + t.tv_usec;
+
+	printf("### START [%s:%d] timestamp(%u)\n", func_name, line, ts_start);
+
+	return ts_start;
+}
+
+unsigned int _perf_measure_end(const char *tag, unsigned int ts_start,
+				char *func_name, int line)
+{
+	struct timeval t;
+	unsigned int ts_end;
+	unsigned int elapsed_time = 0;
+
+	gettimeofday(&t, NULL);
+	ts_end = t.tv_sec * 1000000UL + t.tv_usec;
+
+	if (ts_start)
+		elapsed_time = ts_end - ts_start;
+
+	printf("### END [%s:%d] timestamp(%u)\n", func_name, line, ts_end);
+
+	if (elapsed_time)
+		printf("### ELAPSED [%s:%d] timestamp(%u)\n", func_name, line,
+			elapsed_time);
+
+	return ts_end;
+}
+
diff --git a/src/rua.c b/src/rua.c
new file mode 100644
index 0000000..9b5ef8b
--- /dev/null
+++ b/src/rua.c
@@ -0,0 +1,356 @@
+/*
+ *  RUA
+ *
+ * Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@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.
+ *
+ */
+
+/*
+ * @file    rua.c
+ * @version 0.1
+ */
+
+#include <stdio.h>
+#include <stdlib.h>
+#include <string.h>
+
+#include <db-util.h>
+
+#include "rua.h"
+#include "db-schema.h"
+#include "perf-measure.h"
+
+#define RUA_DB_PATH	"/opt/dbspace"
+#define RUA_DB_NAME	".rua.db"
+#define RUA_HISTORY	"rua_history"
+#define QUERY_MAXLEN	4096
+#define Q_LATEST \
+	"select pkg_name from rua_history " \
+	"order by launch_time desc limit 1 "
+
+static sqlite3 *_db = NULL;
+
+static int __exec(sqlite3 *db, char *query);
+static int __create_table(sqlite3 *db);
+static sqlite3 *__db_init(char *root);
+
+int rua_clear_history(void)
+{
+	int r;
+	char query[QUERY_MAXLEN];
+
+	if (_db == NULL)
+		return -1;
+
+	snprintf(query, QUERY_MAXLEN, "delete from %s;", RUA_HISTORY);
+
+	r = __exec(_db, query);
+
+	return r;
+}
+
+int rua_delete_history_with_pkgname(char *pkg_name)
+{
+	int r;
+	char query[QUERY_MAXLEN];
+
+	if (_db == NULL)
+		return -1;
+
+	if (pkg_name == NULL)
+		return -1;
+
+	snprintf(query, QUERY_MAXLEN, "delete from %s where pkg_name = '%s';",
+		RUA_HISTORY, pkg_name);
+
+	r = __exec(_db, query);
+
+	return r;
+}
+
+int rua_delete_history_with_apppath(char *app_path)
+{
+	int r;
+	char query[QUERY_MAXLEN];
+
+	if (_db == NULL)
+		return -1;
+
+	if (app_path == NULL)
+		return -1;
+
+	snprintf(query, QUERY_MAXLEN, "delete from %s where app_path = '%s';",
+		RUA_HISTORY, app_path);
+
+	r = __exec(_db, query);
+
+	return r;
+}
+
+int rua_add_history(struct rua_rec *rec)
+{
+	int r;
+	int cnt = 0;
+	char query[QUERY_MAXLEN];
+	sqlite3_stmt *stmt;
+
+	unsigned int timestamp;
+	timestamp = PERF_MEASURE_START("RUA");
+
+	if (_db == NULL)
+		return -1;
+
+	if (rec == NULL)
+		return -1;
+
+	snprintf(query, QUERY_MAXLEN,
+		"select count(*) from %s where pkg_name = '%s';", RUA_HISTORY,
+		rec->pkg_name);
+
+	r = sqlite3_prepare(_db, query, sizeof(query), &stmt, NULL);
+	if (r != SQLITE_OK) {
+		return -1;
+	}
+
+	r = sqlite3_step(stmt);
+	if (r == SQLITE_ROW) {
+		cnt = sqlite3_column_int(stmt, 0);
+	}
+	sqlite3_finalize(stmt);
+
+	if (cnt == 0)
+		/* insert */
+		snprintf(query, QUERY_MAXLEN,
+			"insert into %s ( pkg_name, app_path, arg, launch_time ) "
+			" values ( \"%s\", \"%s\", \"%s\", %d ) ",
+			RUA_HISTORY,
+			rec->pkg_name ? rec->pkg_name : "",
+			rec->app_path ? rec->app_path : "",
+			rec->arg ? rec->arg : "", time(NULL));
+	else
+		/* update */
+		snprintf(query, QUERY_MAXLEN,
+			"update %s set arg='%s', launch_time='%d' where pkg_name = '%s';",
+			RUA_HISTORY,
+			rec->arg ? rec->arg : "", time(NULL), rec->pkg_name);
+
+	r = __exec(_db, query);
+	if (r == -1) {
+		printf("[RUA ADD HISTORY ERROR] %s\n", query);
+		return -1;
+	}
+
+	PERF_MEASURE_END("RUA", timestamp);
+
+	return r;
+}
+
+int rua_history_load_db(char ***table, int *nrows, int *ncols)
+{
+	int r;
+	char query[QUERY_MAXLEN];
+	char *db_err = NULL;
+	char **db_result = NULL;
+
+	if (table == NULL)
+		return -1;
+	if (nrows == NULL)
+		return -1;
+	if (ncols == NULL)
+		return -1;
+
+	snprintf(query, QUERY_MAXLEN,
+		 "select * from %s order by launch_time desc;", RUA_HISTORY);
+
+	r = sqlite3_get_table(_db, query, &db_result, nrows, ncols, &db_err);
+
+	if (r == SQLITE_OK)
+		*table = db_result;
+	else
+		sqlite3_free_table(db_result);
+
+	return r;
+}
+
+int rua_history_unload_db(char ***table)
+{
+	if (*table) {
+		sqlite3_free_table(*table);
+		*table = NULL;
+		return 0;
+	}
+	return -1;
+}
+
+int rua_history_get_rec(struct rua_rec *rec, char **table, int nrows, int ncols,
+			int row)
+{
+	char **db_result = NULL;
+	char *tmp = NULL;
+
+	if (rec == NULL)
+		return -1;
+	if (table == NULL)
+		return -1;
+	if (row >= nrows)
+		return -1;
+
+	db_result = table + ((row + 1) * ncols);
+
+	tmp = db_result[RUA_COL_ID];
+	if (tmp) {
+		rec->id = atoi(tmp);
+	}
+
+	tmp = db_result[RUA_COL_PKGNAME];
+	if (tmp) {
+		rec->pkg_name = tmp;
+	}
+
+	tmp = db_result[RUA_COL_APPPATH];
+	if (tmp) {
+		rec->app_path = tmp;
+	}
+
+	tmp = db_result[RUA_COL_ARG];
+	if (tmp) {
+		rec->arg = tmp;
+	}
+
+	tmp = db_result[RUA_COL_LAUNCHTIME];
+	if (tmp) {
+		rec->launch_time = atoi(tmp);
+	}
+
+	return 0;
+}
+
+int rua_is_latest_app(const char *pkg_name)
+{
+	int r;
+	sqlite3_stmt *stmt;
+	const unsigned char *ct;
+
+	if (!pkg_name || !_db)
+		return -1;
+
+	r = sqlite3_prepare(_db, Q_LATEST, sizeof(Q_LATEST), &stmt, NULL);
+	if (r != SQLITE_OK) {
+		return -1;
+	}
+
+	r = sqlite3_step(stmt);
+	if (r == SQLITE_ROW) {
+		ct = sqlite3_column_text(stmt, 0);
+		if (ct == NULL || ct[0] == '\0') {
+			sqlite3_finalize(stmt);
+			return -1;
+		}
+
+		if (strncmp(pkg_name, ct, strlen(pkg_name)) == 0) {
+			sqlite3_finalize(stmt);
+			return 0;
+		}
+	}
+
+	sqlite3_finalize(stmt);
+	return -1;
+}
+
+int rua_init(void)
+{
+	unsigned int timestamp;
+	timestamp = PERF_MEASURE_START("RUA");
+
+	if (_db) {
+		return 0;
+	}
+
+	char defname[FILENAME_MAX];
+	snprintf(defname, sizeof(defname), "%s/%s", RUA_DB_PATH, RUA_DB_NAME);
+	_db = __db_init(defname);
+
+	if (_db == NULL)
+		return -1;
+
+	PERF_MEASURE_END("RUA", timestamp);
+
+	return 0;
+}
+
+int rua_fini(void)
+{
+	unsigned int timestamp;
+	timestamp = PERF_MEASURE_START("RUA");
+
+	if (_db) {
+		db_util_close(_db);
+		_db = NULL;
+	}
+
+	PERF_MEASURE_END("RUA", timestamp);
+	return 0;
+}
+
+static int __exec(sqlite3 *db, char *query)
+{
+	int r;
+	char *errmsg = NULL;
+
+	if (db == NULL)
+		return -1;
+
+	r = sqlite3_exec(db, query, NULL, NULL, &errmsg);
+
+	if (r != SQLITE_OK) {
+		sqlite3_free(errmsg);
+		return -1;
+	}
+
+	return 0;
+}
+
+static int __create_table(sqlite3 *db)
+{
+	int r;
+
+	r = __exec(db, CREATE_RUA_HISTORY_TABLE);
+	if (r == -1)
+		return -1;
+
+	return 0;
+}
+
+static sqlite3 *__db_init(char *root)
+{
+	int r;
+	sqlite3 *db = NULL;
+
+	r = db_util_open(root, &db, 0);
+	if (r) {
+		db_util_close(db);
+		return NULL;
+	}
+
+	r = __create_table(db);
+	if (r) {
+		db_util_close(db);
+		return NULL;
+	}
+
+	return db;
+}
diff --git a/test/CMakeLists.txt b/test/CMakeLists.txt
new file mode 100644
index 0000000..3f7d5c8
--- /dev/null
+++ b/test/CMakeLists.txt
@@ -0,0 +1,22 @@
+SET(RUATEST rua-test)
+SET(RUATEST_SRCS rua-test.c)
+SET(RUATEST_VENDOR samsung)
+SET(RUATEST_DIR /usr/bin)
+SET(RUATEST_LOCALEDIR /usr/share/locale)
+
+INCLUDE_DIRECTORIES(${CMAKE_CURRENT_SOURCE_DIR})
+PKG_CHECK_MODULES(RUATEST_PKGS REQUIRED
+	)
+
+FOREACH(flag ${RUATEST_PKGS_CFLAGS})
+	SET(RUATEST_CFLAGS "${RUATEST_CFLAGS} ${flag}")
+ENDFOREACH(flag)
+
+SET(RUATEST_CFLAGS, "${RUATEST_CFLAGS} -DPREFIX=\"${CMAKE_INSTALL_PREFIX}\"")
+
+ADD_EXECUTABLE(${RUATEST} ${RUATEST_SRCS})
+SET_TARGET_PROPERTIES(${RUATEST} PROPERTIES COMPILE_FLAGS "${RUATEST_CFLAGS}")
+TARGET_LINK_LIBRARIES(${RUATEST} ${PROJECT_NAME} ${RUATEST_PKGS_LDFLAGS})
+
+INSTALL(TARGETS ${RUATEST} DESTINATION bin)
+
diff --git a/test/rua-test.c b/test/rua-test.c
new file mode 100644
index 0000000..6fdd2e0
--- /dev/null
+++ b/test/rua-test.c
@@ -0,0 +1,65 @@
+/*
+ *  RUA
+ *
+ * Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@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 <getopt.h>
+#include <time.h>
+#include <stdlib.h>
+#include <string.h>
+
+#include "rua.h"
+
+int __add_history(char *pkgname)
+{
+	int ret = 0;
+	struct rua_rec rec;
+	char apppath[FILENAME_MAX] = "";
+
+	snprintf(apppath, "/opt/apps/%s", pkgname, FILENAME_MAX);
+	memset(&rec, 0, sizeof(rec));
+	rec.pkg_name = pkgname;
+	rec.app_path = apppath;
+
+	ret = rua_init();
+	if (ret) {
+		fprintf(stderr, "error rua_init()\n");
+		return -1;
+	}
+
+	ret = rua_add_history(&rec);
+
+	rua_fini();
+
+	return ret;
+
+}
+
+int main(int argc, char* argv[])
+{
+	int ret = 0;
+
+	if (argc != 2)
+		return 0;
+	ret = __add_history(argv[1]);
+	return 0;
+}
+
+