sqlite: Add 2.8.17 from bug #688, thanks to Eric Shattow

5 files changed, 123 insertions, 0 deletions

diff --git a/packages/sqlite/sqlite-2.8.17/.mtn2git_empty b/packages/sqlite/sqlite-2.8.17/.mtn2git_empty
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/packages/sqlite/sqlite-2.8.17/.mtn2git_empty
diff --git a/packages/sqlite/sqlite-2.8.17/mainmk_build_dynamic.patch b/packages/sqlite/sqlite-2.8.17/mainmk_build_dynamic.patch
new file mode 100644
index 0000000000..e936f81c72
--- /dev/null
+++ b/packages/sqlite/sqlite-2.8.17/mainmk_build_dynamic.patch
@@ -0,0 +1,30 @@
+diff -bur sqlite-2.8.17~orig/main.mk sqlite-2.8.17/main.mk
+--- sqlite-2.8.17~orig/main.mk	2005-04-23 17:43:23.000000000 -0500
++++ sqlite-2.8.17/main.mk	2006-02-13 03:31:03.000000000 -0600
+@@ -139,7 +139,7 @@
+ # This is the default Makefile target.  The objects listed here
+ # are what get build when you type just "make" with no arguments.
+ #
+-all:	sqlite.h config.h libsqlite.a sqlite$(EXE)
++all:   sqlite.h config.h libsqlite.so sqlite$(EXE)
+ 
+ # Generate the file "last_change" which contains the date of change
+ # of the most recently modified source code file
+@@ -148,13 +148,12 @@
+ 	cat $(SRC) | grep '$$Id: ' | sort +4 | tail -1 \
+           | awk '{print $$5,$$6}' >last_change
+ 
+-libsqlite.a:	$(LIBOBJ)
+-	$(AR) libsqlite.a $(LIBOBJ)
+-	$(RANLIB) libsqlite.a
++libsqlite.so:	$(LIBOBJ)
++	$(CC) -shared -o libsqlite.so -Wl,-soname,libsqlite.so.0 $(LIBOBJ)
+ 
+-sqlite$(EXE):	$(TOP)/src/shell.c libsqlite.a sqlite.h
++sqlite$(EXE):	$(TOP)/src/shell.c libsqlite.so sqlite.h
+ 	$(TCCX) $(READLINE_FLAGS) -o sqlite$(EXE) $(TOP)/src/shell.c \
+-		libsqlite.a $(LIBREADLINE) $(THREADLIB)
++		-lsqlite $(LIBREADLINE) $(THREADLIB)
+ 
+ sqlite_analyzer$(EXE):	$(TOP)/src/tclsqlite.c libsqlite.a $(TESTSRC) \
+ 			$(TOP)/tool/spaceanal.tcl
diff --git a/packages/sqlite/sqlite-2.8.17/mainmk_no_tcl.patch b/packages/sqlite/sqlite-2.8.17/mainmk_no_tcl.patch
new file mode 100644
index 0000000000..b84b6486ef
--- /dev/null
+++ b/packages/sqlite/sqlite-2.8.17/mainmk_no_tcl.patch
@@ -0,0 +1,20 @@
+diff -bur sqlite-2.8.17~orig/main.mk sqlite-2.8.17/main.mk
+--- sqlite-2.8.17~orig/main.mk	2006-02-13 04:09:33.000000000 -0600
++++ sqlite-2.8.17/main.mk	2006-02-13 04:15:42.000000000 -0600
+@@ -58,7 +58,7 @@
+          expr.o func.o hash.o insert.o \
+          main.o opcodes.o os.o pager.o parse.o pragma.o printf.o random.o \
+          select.o table.o tokenize.o trigger.o update.o util.o \
+-         vacuum.o vdbe.o vdbeaux.o where.o tclsqlite.o
++         vacuum.o vdbe.o vdbeaux.o where.o
+ 
+ # All of the source code files.
+ #
+@@ -91,7 +91,6 @@
+   $(TOP)/src/sqlite.h.in \
+   $(TOP)/src/sqliteInt.h \
+   $(TOP)/src/table.c \
+-  $(TOP)/src/tclsqlite.c \
+   $(TOP)/src/tokenize.c \
+   $(TOP)/src/trigger.c \
+   $(TOP)/src/update.c \
diff --git a/packages/sqlite/sqlite-2.8.17/sqlite.pc b/packages/sqlite/sqlite-2.8.17/sqlite.pc
new file mode 100644
index 0000000000..6bc742eecb
--- /dev/null
+++ b/packages/sqlite/sqlite-2.8.17/sqlite.pc
@@ -0,0 +1,12 @@
+# Package Information for pkg-config
+
+prefix=/usr
+exec_prefix=${prefix}
+libdir=${exec_prefix}/lib
+includedir=${prefix}/include
+
+Name: SQLite
+Description: SQL database engine
+Version: 2.8.17
+Libs: -L${libdir} -lsqlite
+Cflags: -I${includedir}
diff --git a/packages/sqlite/sqlite_2.8.17.bb b/packages/sqlite/sqlite_2.8.17.bb
new file mode 100644
index 0000000000..7e44ac87ae
--- /dev/null
+++ b/packages/sqlite/sqlite_2.8.17.bb
@@ -0,0 +1,61 @@
+DESCRIPTION = "An Embeddable SQL Database Engine"
+HOMEPAGE = "http://www.sqlite.org/"
+SECTION = "libs"
+PRIORITY = "optional"
+DEPENDS = "readline ncurses"
+LICENSE = "PD"
+PR = "r0"
+
+SRC_URI = "http://www.hwaci.com/sw/sqlite/sqlite-${PV}.tar.gz \
+       file://mainmk_build_dynamic.patch;patch=1 \
+       file://mainmk_no_tcl.patch;patch=1 \
+	   file://sqlite.pc"
+
+SOURCES = "attach.o auth.o btree.o btree_rb.o build.o copy.o date.o delete.o \
+           expr.o func.o hash.o insert.o main.o opcodes.o os.o pager.o \
+           parse.o pragma.o printf.o random.o select.o table.o tokenize.o \
+           trigger.o update.o util.o vacuum.o vdbe.o vdbeaux.o where.o"
+
+inherit autotools pkgconfig
+
+do_configure() {
+    echo "main.mk is patched, no need to configure"
+}
+
+do_compile() {
+	oe_runmake -f Makefile.linux-gcc \
+                   TOP="${S}" \
+                   BCC="${BUILD_CC}" \
+                   TCC="${CC}" \
+                   OPTS="-fPIC -D'INTPTR_TYPE=int'" \
+                   TCL_FLAGS= LIBTCL= \
+                   READLINE_FLAGS="-DHAVE_READLINE=1 -I${STAGING_INCDIR}" \
+                   LIBREADLINE="-L. -L${STAGING_LIBDIR} -lreadline -lncurses"
+}
+
+do_stage() {
+	install -m 0755 libsqlite.so ${STAGING_LIBDIR}/libsqlite.so.0.8.6
+        ln -sf libsqlite.so.0.8.6 ${STAGING_LIBDIR}/libsqlite.so
+        ln -sf libsqlite.so.0.8.6 ${STAGING_LIBDIR}/libsqlite.so.0
+        ln -sf libsqlite.so.0.8.6 ${STAGING_LIBDIR}/libsqlite.so.0.8
+        install -m 0644 sqlite.h ${STAGING_INCDIR}
+
+	# make pkgconfig.bbclass pick this up
+	mv ${WORKDIR}/sqlite.pc ${S}
+}
+
+do_install() {
+	install -d ${D}${libdir} ${D}${bindir}
+	install sqlite ${D}${bindir}
+	install -m 0755 libsqlite.so ${D}${libdir}/libsqlite.so.0.8.6
+	ln -sf libsqlite.so.0.8.6 ${D}${libdir}/libsqlite.so
+        ln -sf libsqlite.so.0.8.6 ${D}${libdir}/libsqlite.so.0
+        ln -sf libsqlite.so.0.8.6 ${D}${libdir}/libsqlite.so.0.8
+        install -d ${D}${includedir}
+        install -m 0644 sqlite.h ${D}${includedir}/sqlite.h
+}
+
+PACKAGES += "${PN}-bin"
+FILES_${PN}-bin = "${bindir}"
+FILES_${PN} = "${libdir}/*.so.*"
+