From 2b6d715c84d4727f9c5b13d8099c04e372f442d0 Mon Sep 17 00:00:00 2001 From: nico Date: Fri, 10 Jun 2005 15:54:29 +0000 Subject: Add sqlite (libsqlite and sqlite-cli) package git-svn-id: svn://svn.openwrt.org/openwrt/trunk/openwrt@1185 3c298f89-4303-0410-b956-a3cf2f4a3e73 --- package/Config.in | 3 +- package/Makefile | 2 + package/sqlite/Config.in | 75 ++++++++++++++++++++++++++ package/sqlite/Makefile | 98 ++++++++++++++++++++++++++++++++++ package/sqlite/ipkg/libsqlite.control | 6 +++ package/sqlite/ipkg/sqlite-cli.control | 7 +++ 6 files changed, 190 insertions(+), 1 deletion(-) create mode 100644 package/sqlite/Config.in create mode 100644 package/sqlite/Makefile create mode 100644 package/sqlite/ipkg/libsqlite.control create mode 100644 package/sqlite/ipkg/sqlite-cli.control diff --git a/package/Config.in b/package/Config.in index 6ca34a4ab..c098c995d 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 d91002b2a..183c44bf9 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 000000000..79ecfa314 --- /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 000000000..dea4c56db --- /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 000000000..d12f44f4c --- /dev/null +++ b/package/sqlite/ipkg/libsqlite.control @@ -0,0 +1,6 @@ +Package: libsqlite +Priority: optional +Section: libs +Maintainer: Nico +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 000000000..27b4c9224 --- /dev/null +++ b/package/sqlite/ipkg/sqlite-cli.control @@ -0,0 +1,7 @@ +Package: sqlite-cli +Priority: optional +Section: libs +Maintainer: Nico +Source: http://openwrt.org/cgi-bin/viewcvs.cgi/openwrt/package/sqlite/ +Description: Command Line Interface (CLI) for SQLite +Depends: libsqlite -- cgit v1.2.3