Add sqlite (libsqlite and sqlite-cli) package

git-svn-id: svn://svn.openwrt.org/openwrt/trunk/openwrt@1185 3c298f89-4303-0410-b956-a3cf2f4a3e73

6 files changed, 190 insertions, 1 deletions

diff --git a/package/Config.in b/package/Config.in
index 6ca34a4ab3..c098c995d5 100644
--- a/package/Config.in
+++ b/package/Config.in
@@ -89,7 +89,7 @@ source "package/glib/Config.in"
 source "package/libelf/Config.in"
 source "package/libevent/Config.in"
 source "package/libgd/Config.in"
-source "package/gmp/Config.in"  # libbgmp
+source "package/gmp/Config.in"  # libgmp
 source "package/libtool/Config.in"  # libltdl
 source "package/lzo/Config.in"  # liblzo
 source "package/matrixssl/Config.in"  # libmatrixssl
@@ -108,6 +108,7 @@ source "package/libpthread/Config.in"
 source "package/readline/Config.in"  # libreadline
 source "package/cyrus-sasl/Config.in"  # libsasl2
 source "package/speex/Config.in" # libspeex
+source "package/sqlite/Config.in" # libsqlite
 source "package/libusb/Config.in"
 source "package/uclibc++/Config.in"
 source "package/zlib/Config.in"
diff --git a/package/Makefile b/package/Makefile
index d91002b2a3..183c44bf9f 100644
--- a/package/Makefile
+++ b/package/Makefile
@@ -94,6 +94,7 @@ package-$(BR2_PACKAGE_SIPROXD) += siproxd
 package-$(BR2_PACKAGE_SIPSAK) += sipsak
 package-$(BR2_PACKAGE_SNORT) += snort
 package-$(BR2_PACKAGE_SPEEX) += speex
+package-$(BR2_PACKAGE_SQLITE) += sqlite
 package-$(BR2_PACKAGE_STRACE) += strace
 package-$(BR2_PACKAGE_TCPDUMP) += tcpdump
 package-$(BR2_PACKAGE_TINC) += tinc
@@ -145,6 +146,7 @@ postgresql-compile: zlib-compile
 screen-compile: ncurses-compile
 siproxd-compile: libosip2-compile
 sipsak-compile: openssl-compile
+sqlite-compile: ncurses-compile readline-compile
 tcpdump-compile: libpcap-compile
 tinc-compile: zlib-compile openssl-compile lzo-compile
 vtun-compile: zlib-compile openssl-compile lzo-compile
diff --git a/package/sqlite/Config.in b/package/sqlite/Config.in
new file mode 100644
index 0000000000..79ecfa314e
--- /dev/null
+++ b/package/sqlite/Config.in
@@ -0,0 +1,75 @@
+config BR2_PACKAGE_SQLITE
+	bool
+	default n
+	depends BR2_PACKAGE_LIBSQLITE
+
+config BR2_PACKAGE_LIBSQLITE
+	prompt "libsqlite - Self-contained, embeddable, zero-configuration SQL database engine"
+	tristate
+#	default m if CONFIG_DEVEL
+	default n
+	select BR2_PACKAGE_SQLITE
+	help
+	  SQLite is a small C library that implements a self-contained, embeddable, 
+	  zero-configuration SQL database engine. Features include:
+	  
+	    * Transactions are atomic, consistent, isolated, and durable (ACID) 
+	      even after system crashes and power failures.
+	    * Zero-configuration - no setup or administration needed.
+	    * Implements most of SQL92. (Features not supported)
+	    * A complete database is stored in a single disk file.
+	    * Database files can be freely shared between machines with different 
+	      byte orders.
+	    * Supports databases up to 2 terabytes (241 bytes) in size.
+	    * Sizes of strings and BLOBs limited only by available memory.
+	    * Small code footprint: less than 30K lines of C code, less than 250KB 
+	      code space (gcc on i486)
+	    * Faster than popular client/server database engines for most common 
+	      operations.
+	    * Simple, easy to use API.
+	    * TCL bindings included. Bindings for many other languages available 
+	      separately.
+	    * Well-commented source code with over 95% test coverage.
+	    * Self-contained: no external dependencies.
+	    * Sources are in the public domain. Use for any purpose.
+	  
+	  http://www.sqlite.org/
+	  
+	  This package contains the shared library, needed by other programs.
+	  
+config BR2_PACKAGE_SQLITE_CLI
+	prompt "sqlite-cli - Command line interface for SQLite"
+	tristate
+#	default m if CONFIG_DEVEL
+	default n
+	depends BR2_PACKAGE_LIBSQLITE
+	help
+	  SQLite is a small C library that implements a self-contained, embeddable, 
+	  zero-configuration SQL database engine. Features include:
+	  
+	    * Transactions are atomic, consistent, isolated, and durable (ACID) 
+	      even after system crashes and power failures.
+	    * Zero-configuration - no setup or administration needed.
+	    * Implements most of SQL92. (Features not supported)
+	    * A complete database is stored in a single disk file.
+	    * Database files can be freely shared between machines with different 
+	      byte orders.
+	    * Supports databases up to 2 terabytes (241 bytes) in size.
+	    * Sizes of strings and BLOBs limited only by available memory.
+	    * Small code footprint: less than 30K lines of C code, less than 250KB 
+	      code space (gcc on i486)
+	    * Faster than popular client/server database engines for most common 
+	      operations.
+	    * Simple, easy to use API.
+	    * TCL bindings included. Bindings for many other languages available 
+	      separately.
+	    * Well-commented source code with over 95% test coverage.
+	    * Self-contained: no external dependencies.
+	    * Sources are in the public domain. Use for any purpose.
+	  
+	  http://www.sqlite.org/
+	  
+	  This package contains a terminal-based front-end to the SQLite library 
+	  that can evaluate queries interactively and display the results in 
+	  multiple formats.
+	  
\ No newline at end of file
diff --git a/package/sqlite/Makefile b/package/sqlite/Makefile
new file mode 100644
index 0000000000..dea4c56dbc
--- /dev/null
+++ b/package/sqlite/Makefile
@@ -0,0 +1,98 @@
+# $Id$
+
+include $(TOPDIR)/rules.mk
+
+PKG_NAME:=sqlite
+PKG_VERSION:=3.2.1
+PKG_RELEASE:=1
+PKG_MD5SUM:=ccf3831c2f67452d444c5e5e2c7ca6f0
+
+PKG_SOURCE_URL:=http://www.sqlite.org/
+PKG_SOURCE:=$(PKG_NAME)-$(PKG_VERSION).tar.gz
+PKG_CAT:=zcat
+
+PKG_BUILD_DIR:=$(BUILD_DIR)/$(PKG_NAME)-$(PKG_VERSION)
+PKG_INSTALL_DIR:=$(PKG_BUILD_DIR)/ipkg-install
+
+include $(TOPDIR)/package/rules.mk
+
+$(eval $(call PKG_template,LIBSQLITE,libsqlite,$(PKG_VERSION)-$(PKG_RELEASE),$(ARCH)))
+$(eval $(call PKG_template,SQLITE_CLI,sqlite-cli,$(PKG_VERSION)-$(PKG_RELEASE),$(ARCH)))
+
+$(PKG_BUILD_DIR)/.configured:
+	(cd $(PKG_BUILD_DIR); rm -rf config.{cache,status} ; \
+		$(TARGET_CONFIGURE_OPTS) \
+		CFLAGS="$(TARGET_CFLAGS)" \
+		CPPFLAGS="-I$(STAGING_DIR)/usr/include" \
+		LDFLAGS="-L$(STAGING_DIR)/usr/lib" \
+		config_BUILD_CC="$(HOSTCC)" \
+		config_BUILD_CFLAGS="-O2" \
+		config_TARGET_CC="$(TARGET_CC)" \
+		config_TARGET_CFLAGS="$(TARGET_CFLAGS)" \
+		config_TARGET_READLINE_INC="-I$(STAGING_DIR)/usr/include" \
+		config_TARGET_READLINE_LIBS="-L$(STAGING_DIR)/usr/lib -lreadline -lncurses" \
+		./configure \
+		  --target=$(GNU_TARGET_NAME) \
+		  --host=$(GNU_TARGET_NAME) \
+		  --build=$(GNU_HOST_NAME) \
+		  --program-prefix="" \
+		  --program-suffix="" \
+		  --prefix=/usr \
+		  --exec-prefix=/usr \
+		  --bindir=/usr/bin \
+		  --datadir=/usr/share \
+		  --includedir=/usr/include \
+		  --infodir=/usr/share/info \
+		  --libdir=/usr/lib \
+		  --libexecdir=/usr/lib \
+		  --localstatedir=/var \
+		  --mandir=/usr/share/man \
+		  --sbindir=/usr/sbin \
+		  --sysconfdir=/etc \
+		  $(DISABLE_LARGEFILE) \
+		  $(DISABLE_NLS) \
+		  --enable-shared \
+		  --enable-static \
+		  --disable-tcl \
+	);
+	touch $@
+
+$(PKG_BUILD_DIR)/.built:
+	rm -rf $(PKG_INSTALL_DIR)
+	mkdir -p $(PKG_INSTALL_DIR)
+	$(MAKE) -C $(PKG_BUILD_DIR) \
+		DESTDIR="$(PKG_INSTALL_DIR)" \
+		all install
+	touch $@
+
+$(IPKG_LIBSQLITE):
+	install -d -m0755 $(IDIR_LIBSQLITE)/usr/lib
+	cp -fpR $(PKG_INSTALL_DIR)/usr/lib/libsqlite3.so.* $(IDIR_LIBSQLITE)/usr/lib/
+	$(RSTRIP) $(IDIR_LIBSQLITE)
+	$(IPKG_BUILD) $(IDIR_LIBSQLITE) $(PACKAGE_DIR)
+
+$(IPKG_SQLITE_CLI):
+	install -d -m0755 $(IDIR_SQLITE_CLI)/usr/bin
+	cp -fpR $(PKG_INSTALL_DIR)/usr/bin/sqlite3 $(IDIR_SQLITE_CLI)/usr/bin/
+	$(RSTRIP) $(IDIR_SQLITE_CLI)
+	$(IPKG_BUILD) $(IDIR_SQLITE_CLI) $(PACKAGE_DIR)
+
+$(STAGING_DIR)/usr/lib/libsqlite3.so: $(PKG_BUILD_DIR)/.built
+	mkdir -p $(STAGING_DIR)/usr/include
+	cp -fpR $(PKG_INSTALL_DIR)/usr/include/sqlite3.h $(STAGING_DIR)/usr/include/
+	mkdir -p $(STAGING_DIR)/usr/lib
+	cp -fpR $(PKG_INSTALL_DIR)/usr/lib/libsqlite3.{a,so*} $(STAGING_DIR)/usr/lib/
+	mkdir -p $(STAGING_DIR)/usr/lib/pkgconfig
+	cp -fpR $(PKG_INSTALL_DIR)/usr/lib/pkgconfig/sqlite3.pc $(STAGING_DIR)/usr/lib/pkgconfig/
+	touch $@
+
+install-dev: $(STAGING_DIR)/usr/lib/libsqlite3.so
+
+uninstall-dev:
+	rm -rf \
+		$(STAGING_DIR)/usr/include/sqlite3.h \
+		$(STAGING_DIR)/usr/lib/libsqlite3.{a,so*} \
+		$(STAGING_DIR)/usr/lib/pkgconfig/sqlite3.pc \
+
+compile: install-dev
+clean: uninstall-dev
diff --git a/package/sqlite/ipkg/libsqlite.control b/package/sqlite/ipkg/libsqlite.control
new file mode 100644
index 0000000000..d12f44f4cb
--- /dev/null
+++ b/package/sqlite/ipkg/libsqlite.control
@@ -0,0 +1,6 @@
+Package: libsqlite
+Priority: optional
+Section: libs
+Maintainer: Nico <nthill@free.fr>
+Source: http://openwrt.org/cgi-bin/viewcvs.cgi/openwrt/package/sqlite/
+Description: Self-contained, embeddable, zero-configuration SQL database engine
diff --git a/package/sqlite/ipkg/sqlite-cli.control b/package/sqlite/ipkg/sqlite-cli.control
new file mode 100644
index 0000000000..27b4c9224c
--- /dev/null
+++ b/package/sqlite/ipkg/sqlite-cli.control
@@ -0,0 +1,7 @@
+Package: sqlite-cli
+Priority: optional
+Section: libs
+Maintainer: Nico <nthill@free.fr>
+Source: http://openwrt.org/cgi-bin/viewcvs.cgi/openwrt/package/sqlite/
+Description: Command Line Interface (CLI) for SQLite
+Depends: libsqlite