[24325] trunk/dports/java
source_changes at macosforge.org
source_changes at macosforge.org
Sat Apr 21 19:21:06 PDT 2007
Revision: 24325
http://trac.macosforge.org/projects/macports/changeset/24325
Author: pguyot at kallisys.net
Date: 2007-04-21 19:21:05 -0700 (Sat, 21 Apr 2007)
Log Message:
-----------
new port: java/javasqlite 20060714
Added Paths:
-----------
trunk/dports/java/javasqlite/
trunk/dports/java/javasqlite/Portfile
trunk/dports/java/javasqlite/files/
trunk/dports/java/javasqlite/files/patch-Makefile.in
trunk/dports/java/javasqlite/files/patch-Makefile.in-jnilib
trunk/dports/java/javasqlite/files/patch-configure
trunk/dports/java/javasqlite/files/test.output
Added: trunk/dports/java/javasqlite/Portfile
===================================================================
--- trunk/dports/java/javasqlite/Portfile (rev 0)
+++ trunk/dports/java/javasqlite/Portfile 2007-04-22 02:21:05 UTC (rev 24325)
@@ -0,0 +1,45 @@
+# $Id$
+
+PortSystem 1.0
+
+name javasqlite
+version 20060714
+categories java database
+platforms darwin
+
+maintainers pguyot at kallisys.net
+description Java wrapper for sqlite
+long_description Java wrapper including a basic JDBC driver for the SQLite \
+ 2/3 database engine. It is designed using JNI to \
+ interface to the SQLite API.
+homepage http://www.ch-werner.de/javasqlite/
+master_sites ${homepage}
+checksums md5 ac9b2a256a657b2717659acea7f2e41a \
+ sha1 f9d74f6c891b27713ecaa1444b4bee1bb6841cf0 \
+ rmd160 725b2455208ca40b9c0edd9769431c637f0b8d3b
+patchfiles patch-configure \
+ patch-Makefile.in
+
+depends_lib port:sqlite2 \
+ port:sqlite3
+
+configure.args-append --with-jardir=${prefix}/share/java/ \
+ --with-sqlite=${prefix} \
+ --with-sqlite3=${prefix}
+
+test.run yes
+post-test {
+ # This test function could be improved. We probably want a diff method
+ # in base/
+ system "cd ${worksrcpath} && java test > ${worksrcpath}/test.output 2>&1"
+ system "exit `diff ${filespath}/test.output ${worksrcpath}/test.output | wc -l`"
+}
+
+platform darwin {
+ patchfiles-append patch-Makefile.in-jnilib
+}
+
+livecheck.url http://www.ch-werner.de/javasqlite/overview-summary.html
+livecheck.check regexm
+livecheck.regex {<H1>\s+SQLite Java Wrapper/JDBC Driver\s+<br><small>\s+(.*)\s+</small>\s+</H1>}
+livecheck.version 2006-07-14
Property changes on: trunk/dports/java/javasqlite/Portfile
___________________________________________________________________
Name: svn:keywords
+ Id
Name: svn:eol-style
+ native
Added: trunk/dports/java/javasqlite/files/patch-Makefile.in
===================================================================
--- trunk/dports/java/javasqlite/files/patch-Makefile.in (rev 0)
+++ trunk/dports/java/javasqlite/files/patch-Makefile.in 2007-04-22 02:21:05 UTC (rev 24325)
@@ -0,0 +1,14 @@
+--- Makefile.in.orig 2007-04-22 10:34:07.000000000 +0900
++++ Makefile.in 2007-04-22 10:34:26.000000000 +0900
+@@ -126,7 +126,7 @@
+ $(INSTALL) -m 644 test.java doc/test.java
+
+ install:
+- $(INSTALL) -d -m 755 $(JAR_DIR)
+- $(INSTALL) -m 644 sqlite.jar $(JAR_DIR)
+- $(INSTALL) -d -m 755 $(NATIVE_LIB_DIR)
+- $(LIBTOOL) $(INSTALL) libsqlite_jni.la $(NATIVE_LIB_DIR)
++ $(INSTALL) -d -m 755 $(DESTDIR)$(JAR_DIR)
++ $(INSTALL) -m 644 sqlite.jar $(DESTDIR)$(JAR_DIR)
++ $(INSTALL) -d -m 755 $(DESTDIR)$(NATIVE_LIB_DIR)
++ $(LIBTOOL) $(INSTALL) libsqlite_jni.la $(DESTDIR)$(NATIVE_LIB_DIR)
Added: trunk/dports/java/javasqlite/files/patch-Makefile.in-jnilib
===================================================================
--- trunk/dports/java/javasqlite/files/patch-Makefile.in-jnilib (rev 0)
+++ trunk/dports/java/javasqlite/files/patch-Makefile.in-jnilib 2007-04-22 02:21:05 UTC (rev 24325)
@@ -0,0 +1,28 @@
+--- Makefile.in 2007-04-22 10:59:59.000000000 +0900
++++ Makefile.in 2007-04-22 11:06:25.000000000 +0900
+@@ -78,7 +78,7 @@
+ SQLite/ProgressHandler.java \
+ SQLite/StringEncoder.java
+
+-all: sqlite.jar libsqlite_jni.la
++all: sqlite.jar libsqlite_jni.jnilib
+
+ SQLite/Constants.java: native/mkconst
+ native/mkconst > SQLite/Constants.java
+@@ -94,8 +94,8 @@
+ sqlite_jni.lo: native/sqlite_jni.h native/sqlite_jni.c
+ $(LIBTOOL) $(CC) -c $(CFLAGS) native/sqlite_jni.c
+
+-libsqlite_jni.la: sqlite_jni.lo
+- $(LIBTOOL) $(CC) -o libsqlite_jni.la sqlite_jni.lo \
++libsqlite_jni.jnilib: sqlite_jni.lo
++ $(LIBTOOL) $(CC) -bundle -o libsqlite_jni.jnilib sqlite_jni.lo \
+ -rpath $(NATIVE_LIB_DIR) $(LIBS)
+
+ native/mkconst: native/mkconst.c
+@@ -129,4 +129,4 @@
+ $(INSTALL) -d -m 755 $(DESTDIR)$(JAR_DIR)
+ $(INSTALL) -m 644 sqlite.jar $(DESTDIR)$(JAR_DIR)
+ $(INSTALL) -d -m 755 $(DESTDIR)$(NATIVE_LIB_DIR)
+- $(LIBTOOL) $(INSTALL) libsqlite_jni.la $(DESTDIR)$(NATIVE_LIB_DIR)
++ $(LIBTOOL) $(INSTALL) libsqlite_jni.jnilib $(DESTDIR)$(NATIVE_LIB_DIR)
Added: trunk/dports/java/javasqlite/files/patch-configure
===================================================================
--- trunk/dports/java/javasqlite/files/patch-configure (rev 0)
+++ trunk/dports/java/javasqlite/files/patch-configure 2007-04-22 02:21:05 UTC (rev 24325)
@@ -0,0 +1,12 @@
+--- configure 2005-05-16 19:03:35.000000000 +0900
++++ configure 2007-04-22 10:26:45.000000000 +0900
+@@ -7485,6 +7485,9 @@
+ linux* )
+ JNIINCLUDE="-I$JAVA_HOME/include -I$JAVA_HOME/include/linux"
+ ;;
++ darwin* )
++ JNIINCLUDE="-I/System/Library/Frameworks/JavaVM.framework/Versions/A/Headers/ -framework JavaVM"
++ ;;
+ *)
+ JNIINCLUDE="-I${JAVA_HOME}/include -I${JAVA_HOME}/include/${build_os}"
+ { echo "$as_me:$LINENO: WARNING: setting generic JNI include file directives!" >&5
Added: trunk/dports/java/javasqlite/files/test.output
===================================================================
--- trunk/dports/java/javasqlite/files/test.output (rev 0)
+++ trunk/dports/java/javasqlite/files/test.output 2007-04-22 02:21:05 UTC (rev 24325)
@@ -0,0 +1,131 @@
+WARNING: using non-UTF SQLite2 engine
+LIB version: 2.8.17
+DB version: 3.3.15
+==== local callback ====
+#cols = 5
+col0: type
+col1: name
+col2: tbl_name
+col3: rootpage
+col4: sql
+data0: table
+data1: TEST
+data2: TEST
+data3: 2
+data4: CREATE TABLE TEST(id, firstname, lastname)
+==== get_table ====
+id|firstname|lastname|
+1|Christian|Werner|
+2|John|Doe|
+3|Duffy|Duck|
+4|Mickey|Mouse|
+5|Speedy|Gonzales|
+==== get_table w/ args ====
+type|name|tbl_name|rootpage|sql|
+table|TEST|TEST|2|CREATE TABLE TEST(id, firstname, lastname)|
+==== call regular function ====
+function:
+arg[0]=Christian
+#cols = 1
+col0: myregfunc(TEST.firstname)
+data0: christian
+function:
+arg[0]=John
+data0: john
+function:
+arg[0]=Duffy
+data0: duffy
+function:
+arg[0]=Mickey
+data0: mickey
+function:
+arg[0]=Speedy
+data0: speedy
+==== call aggregate function ====
+step:
+step:
+step:
+step:
+step:
+last_step
+#cols = 1
+col0: myaggfunc(TEST.firstname)
+data0: Christian John Duffy Mickey Speedy
+==== compile/step interface ====
+AUTH: 21,null,null,null,null
+AUTH: 20,TEST,id,main,null
+AUTH: 20,TEST,firstname,main,null
+AUTH: 20,TEST,lastname,main,null
+---- STMT #1 ----
+TRACE: select * from TEST;
+#cols = 3
+col0: id
+col1: firstname
+col2: lastname
+coltype0: integer
+coltype1: text
+coltype2: text
+data0: 1
+data1: Christian
+data2: Werner
+data0: 2
+data1: John
+data2: Doe
+data0: 3
+data1: Duffy
+data2: Duck
+data0: 4
+data1: Mickey
+data2: Mouse
+data0: 5
+data1: Speedy
+data2: Gonzales
+AUTH: 9,TEST,null,main,null
+AUTH: 20,TEST,id,main,null
+---- STMT #2 ----
+TRACE: delete from TEST where id = 5;
+AUTH: 18,TEST,null,main,null
+---- STMT #3 ----
+TRACE: insert into TEST values(5, 'Speedy', 'Gonzales');
+AUTH: 21,null,null,null,null
+AUTH: 20,TEST,id,main,null
+AUTH: 20,TEST,firstname,main,null
+AUTH: 20,TEST,lastname,main,null
+setting progress handler
+---- STMT #4 ----
+TRACE: select * from TEST
+PROGRESS
+PROGRESS
+PROGRESS
+#cols = 3
+col0: id
+col1: firstname
+col2: lastname
+coltype0: integer
+coltype1: text
+coltype2: text
+data0: 1
+data1: Christian
+data2: Werner
+PROGRESS
+data0: 2
+data1: John
+data2: Doe
+PROGRESS
+data0: 3
+data1: Duffy
+data2: Duck
+PROGRESS
+data0: 4
+data1: Mickey
+data2: Mouse
+PROGRESS
+data0: 5
+data1: Speedy
+data2: Gonzales
+An exception is expected from now on.
+==== local callback ====
+error: SQLite.Exception: database already closed
+cleaning up ...
+error: SQLite.Exception: database already closed
+done.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macosforge.org/pipermail/macports-changes/attachments/20070421/1d49b3c9/attachment.html
More information about the macports-changes
mailing list