Add sqlite (libsqlite and sqlite-cli) package

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

4 files changed, 186 insertions, 0 deletions

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