Russ Tyndall [Tue, 26 Jan 2010 21:13:38 +0000 (16:13 -0500)]
fixed a bug in parsing column types from sqlite3 databases by adding a trim
Nathan Bird [Tue, 26 Jan 2010 21:21:52 +0000 (16:21 -0500)]
Adding another attributes test that highlights a fault in the sqlite attribute parser.
Nathan Bird [Mon, 25 Jan 2010 22:07:10 +0000 (17:07 -0500)]
Adding more owner tests, and removing references to owner from a lot of other tests.
Nathan Bird [Sat, 23 Jan 2010 19:02:11 +0000 (14:02 -0500)]
Bind *test-database-user* correctly for odbc.
per documentation :odbc and :aodbc have their user in the second slot of the connection spec.
This causes a number more tests to fail that used to pass because this variable wasn't right.
Nathan Bird [Mon, 25 Jan 2010 22:06:19 +0000 (17:06 -0500)]
Changed ds-fddl to use fddl for table creation.
This is somewhat inline with the fddl tests, and allows us to use the compat layer for handling 'date' datatype.
Nathan Bird [Mon, 25 Jan 2010 22:44:12 +0000 (17:44 -0500)]
Print the error in a useful format.
Nathan Bird [Mon, 25 Jan 2010 19:48:09 +0000 (14:48 -0500)]
Write the database name in the report banner. This is especially useful for testing multiple odbc backend dbs.
Kevin Rosenberg [Wed, 20 Jan 2010 21:49:00 +0000 (14:49 -0700)]
Merge branch 'dataset-refactoring' of git://github.com/UnwashedMeme/clsql
Kevin Rosenberg [Wed, 20 Jan 2010 21:47:44 +0000 (14:47 -0700)]
new version
Nathan Bird [Tue, 19 Jan 2010 15:27:22 +0000 (10:27 -0500)]
Fixing benchmarks that depend on the *ds-employees* dataset.
Nathan Bird [Mon, 18 Jan 2010 16:51:56 +0000 (11:51 -0500)]
Marking tests that depend on the ds-nodes dataset as skipped unless backend implements auto-increment.
Nathan Bird [Fri, 15 Jan 2010 15:37:35 +0000 (10:37 -0500)]
Adding db-type-has-auto-increment
Nathan Bird [Thu, 14 Jan 2010 00:23:30 +0000 (19:23 -0500)]
Got everything running under mysql; I think all the remaining failures are actual logic problems.
Also simplified a number of the oodml test cases that were making a change, then the same code
again to change it back so that future tests will run sanely. That's not needed anymore.
Nathan Bird [Wed, 13 Jan 2010 23:55:14 +0000 (18:55 -0500)]
Got test-fdml using the employees dataset.
Nathan Bird [Wed, 13 Jan 2010 23:54:25 +0000 (18:54 -0500)]
Moving object data out of init into separate files and each one made a dataset.
Nathan Bird [Wed, 13 Jan 2010 23:34:21 +0000 (18:34 -0500)]
whitespace-cleanup
Nathan Bird [Wed, 13 Jan 2010 23:33:59 +0000 (18:33 -0500)]
Moving the insert/update tests to after the select as verifying the update works depends on select working.
Nathan Bird [Wed, 13 Jan 2010 21:56:25 +0000 (16:56 -0500)]
First working version of tests with datasets. So far: internal,connection,basic,fddl passed, with one punted from fddl to ooddl (it appeared to be testing the class definition more.
Nathan Bird [Wed, 13 Jan 2010 18:41:43 +0000 (13:41 -0500)]
First working edition of datasets code.
Nathan Bird [Mon, 18 Jan 2010 18:08:02 +0000 (13:08 -0500)]
Proposed abstraction for datasets.
Nathan Bird [Mon, 11 Jan 2010 19:25:22 +0000 (14:25 -0500)]
Simplifying code in a few more tests, shouldn't be any logical differences.
Nathan Bird [Mon, 11 Jan 2010 19:20:52 +0000 (14:20 -0500)]
Adding 3 new tests that show the update-record-from-slots function is awry with the normalization code.
Nathan Bird [Fri, 8 Jan 2010 22:37:32 +0000 (17:37 -0500)]
Further textual condensing on oodml/update-records/4-9 to improve readability, shouldn't be any logic changes.
Nathan Bird [Fri, 8 Jan 2010 22:12:30 +0000 (17:12 -0500)]
Updating :oodml/update-records/4 through /9.
* condensing tests by FLETting repeated code
* when verifying the update record went through, requery the database to ensure a fresh view of it.
Nathan Bird [Fri, 15 Jan 2010 16:35:53 +0000 (11:35 -0500)]
Adding *.fasl to the .gitignore.
Kevin Rosenberg [Thu, 7 Jan 2010 19:45:45 +0000 (12:45 -0700)]
compiles on lispworks 6
Kevin Rosenberg [Fri, 11 Dec 2009 00:05:42 +0000 (17:05 -0700)]
Version 4.2.0 release, new manuals built
Kevin Rosenberg [Thu, 10 Dec 2009 18:21:24 +0000 (11:21 -0700)]
Add normalized view classes
Large patch from Thijs Oppermann <thijso+clsql@gmail.com> to add
support for normalized view classes. When having view class that
inherit from others, CLSQL by default builds tab all the columns from
the parent in the child. This patch is meant to normali so that a join
is done on the primary keys of the concerned tables to get a set.
Kevin Rosenberg [Thu, 10 Dec 2009 14:15:30 +0000 (07:15 -0700)]
Fix to SYNTAX-PARSE-ISO-8601 to parse fractions of seconds
Kevin Rosenberg [Thu, 10 Dec 2009 14:08:35 +0000 (07:08 -0700)]
Fix for time.lisp's roll function
Kevin Rosenberg [Thu, 12 Nov 2009 07:57:12 +0000 (00:57 -0700)]
avoid errors if 32-bit build fails on 64-bit system
Kevin Rosenberg [Thu, 12 Nov 2009 07:56:54 +0000 (00:56 -0700)]
avoid errors if 32-bit build fails on 64-bit system
Kevin Rosenberg [Thu, 12 Nov 2009 07:48:42 +0000 (00:48 -0700)]
ignore build errors for 32-bit libraries on Linux x64
Kevin Rosenberg [Thu, 12 Nov 2009 07:43:25 +0000 (00:43 -0700)]
Version 4.1.2 - Build improvments
21 Nov 2009 Kevin Rosenberg <kevin@rosenberg.net>
* Version 4.1.2
* Makefiles: On 64-bit Linux systems, try to build both 32 and 64-bit
interface libraries. This requires the installation of multiarch build tools
as well as 32-bit support libraries (libc, libz and libmysqlclient).
Kevin Rosenberg [Fri, 4 Sep 2009 19:38:25 +0000 (13:38 -0600)]
Automated commit for upstream build of version 4.1.1
Kevin Rosenberg [Fri, 4 Sep 2009 19:37:30 +0000 (13:37 -0600)]
New documentation files
Kevin Rosenberg [Fri, 4 Sep 2009 19:02:42 +0000 (13:02 -0600)]
New release 4.1.1
Kevin Rosenberg [Fri, 4 Sep 2009 18:51:23 +0000 (12:51 -0600)]
Rework initialize-instance for view-class-direct-slot-definition
Kevin Rosenberg [Fri, 4 Sep 2009 18:36:58 +0000 (12:36 -0600)]
Use :verbose nil for asdf:operate invocation
Kevin Rosenberg [Fri, 4 Sep 2009 18:27:48 +0000 (12:27 -0600)]
fix parse-iso-8601-duration always answering 0-length duration
Kevin Rosenberg [Fri, 4 Sep 2009 18:22:52 +0000 (12:22 -0600)]
Improved handlining of nested transactions
Kevin Rosenberg [Fri, 4 Sep 2009 18:16:57 +0000 (12:16 -0600)]
Have database-type default be *default-database-type*
Kevin Rosenberg [Fri, 4 Sep 2009 18:02:59 +0000 (12:02 -0600)]
Add directory for MacPorts mysql5 port
Kevin Rosenberg [Fri, 4 Sep 2009 17:57:30 +0000 (11:57 -0600)]
Fix transposed letters
Kevin Rosenberg [Fri, 4 Sep 2009 17:53:45 +0000 (11:53 -0600)]
Allow optional connect parameters for postgresql databases
Kevin Rosenberg [Fri, 4 Sep 2009 17:46:09 +0000 (11:46 -0600)]
Rework do-query to use database for special case
* sql/fdml.lisp: Rework do-query to use supplied database
parameter when passed a sql-object-query
(thanks to JTK <jetmonk@gmail.com>)
Kevin Rosenberg [Wed, 2 Sep 2009 12:51:38 +0000 (06:51 -0600)]
Windows Drive Patch
Commit patch from Andreas Franke to honor windows drive letter
when loading clsql_mysql C library.
Kevin Rosenberg [Tue, 1 Sep 2009 05:15:59 +0000 (23:15 -0600)]
fix spelling error
Kevin Rosenberg [Tue, 1 Sep 2009 04:44:35 +0000 (22:44 -0600)]
Version 4.1.0
* db-mysql/mysql-{sql,api}.lisp,db-mysql/clsql_mysql.c:
Latest version of mysqlclient once again changed the C
structures from which the mysql backend reads data.
Rather than adding yet another structure definition which
is enabled by the client version as read by mysql-client-info.lisp,
the mysql backend has been re-written to ignore in the internal
C structures. Instead, C wrapper functions for slot access have
been added to clsql_mysql.c and are used by mysql-sql.lisp to
access the internals of C structures. This adds a bit of overhead,
but completely separates the lisp code from trying to keep up
with the continually changing internal C structure of mysql.
All tests in the test suite executed correctly with this change.
Kevin Rosenberg [Tue, 1 Sep 2009 00:59:48 +0000 (18:59 -0600)]
Automated commit for debian release 4.0.6-1
Kevin Rosenberg [Tue, 1 Sep 2009 00:59:25 +0000 (18:59 -0600)]
Version 4.0.6
* sql/database.lisp: Fix syntax on process-lock (thanks to
Stian Sletner)
* db-mysql/mysql-sql.lisp: Allow use of database parameter
in database-list function (thanks to Michael Pheasant)
* sql/oodml.lisp: Allow NULL values for floating-point fields
(thanks to Jan Rychter)
Kevin Rosenberg [Mon, 10 Aug 2009 16:06:33 +0000 (10:06 -0600)]
fix bug of two asd files copied
Kevin Rosenberg [Tue, 4 Aug 2009 09:27:50 +0000 (03:27 -0600)]
convert to dh-lisp; add Vcs-Browser
Kevin Rosenberg [Sun, 2 Aug 2009 06:23:31 +0000 (00:23 -0600)]
update debian standards
Kevin Rosenberg [Mon, 27 Jul 2009 02:32:14 +0000 (20:32 -0600)]
update to debhelper 5
Kevin Rosenberg [Mon, 27 Jul 2009 02:28:47 +0000 (20:28 -0600)]
Automated commit for debian release 4.0.5-2
Kevin Rosenberg [Mon, 27 Jul 2009 02:28:34 +0000 (20:28 -0600)]
update section to new lisp section
Kevin Rosenberg [Sun, 26 Jul 2009 23:35:04 +0000 (17:35 -0600)]
remove changelog, update debian standards version
Kevin Rosenberg [Sun, 26 Jul 2009 23:32:28 +0000 (17:32 -0600)]
Update changelog for recent changes
Kevin Rosenberg [Sun, 26 Jul 2009 23:28:59 +0000 (17:28 -0600)]
remove dependency on version of libmysqlclient
Kevin Rosenberg [Wed, 3 Jun 2009 00:34:08 +0000 (18:34 -0600)]
change permissions
Kevin Rosenberg [Wed, 3 Jun 2009 00:33:44 +0000 (18:33 -0600)]
fix permissions, remove dylib libs
Kevin Rosenberg [Wed, 3 Jun 2009 00:28:48 +0000 (18:28 -0600)]
Version 4.0.5
02 Jun 2009 Kevin Rosenberg <kevin@rosenberg.net>
* Version 4.0.5
* sql/database.lisp: Add process-lock for deleting database from
a pool (thanks to Ralf Mattes).
Kevin Rosenberg [Sat, 7 Mar 2009 20:45:06 +0000 (13:45 -0700)]
Automated commit for debian release 4.0.4-1
Kevin Rosenberg [Sat, 7 Mar 2009 20:33:09 +0000 (13:33 -0700)]
update oracle/ffi backend. close debian bug
Kevin Rosenberg [Wed, 12 Dec 2007 20:34:49 +0000 (13:34 -0700)]
* sql/expressions.lisp: Bind *in-subselect* when outputting selections
Kevin Rosenberg [Wed, 12 Dec 2007 01:35:01 +0000 (18:35 -0700)]
remove extra whitespace
Kevin Rosenberg [Wed, 12 Dec 2007 01:18:09 +0000 (18:18 -0700)]
Automated commit for debian release 4.0.3-1
Kevin Rosenberg [Wed, 12 Dec 2007 01:17:43 +0000 (18:17 -0700)]
* Version 4.0.3
* sql/metaclasses.lisp: Unify base-table processing by extracting
the correct code from initialize-instance :around into the helper
function set-view-table-slot. Call that function also in
reinitialize-instance :around replacing erroneous code discovered
by Josh Feinstein.
Kevin Rosenberg [Sat, 17 Nov 2007 15:58:03 +0000 (08:58 -0700)]
note new bug entry in ChangeLog
Kevin Rosenberg [Sat, 17 Nov 2007 15:56:02 +0000 (08:56 -0700)]
note the benefit of using configure file to create Makefiles
Kevin Rosenberg [Tue, 23 Oct 2007 14:58:31 +0000 (08:58 -0600)]
db-postgresql/postgresql-sql.lisp: Patch from Gabriele Favalessa based on
Andrew Golding suggestion for more informative :error-id slot
Kevin Rosenberg [Mon, 17 Sep 2007 17:01:16 +0000 (11:01 -0600)]
Version 4.0.1
17 Sep 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 4.0.1
* db-mysql/mysql-sql.lisp: Convert query to uffi cstring (thanks to
Albert Krewinkel).
* doc/Makefile, doc/html.xsl: Change output encoding from ISO-8859-1 to UTF-8
Kevin Rosenberg [Sat, 15 Sep 2007 11:54:44 +0000 (05:54 -0600)]
14 Sep 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 4.0.0: Major version increase to warn of potential
backwards incompatibility.
* NEWS: Document potentional backward incompatible changes
* db-mysql/mysql-sql.lisp: Changes session SQL mode to ANSI immediately
after connecting. This may break compatibility with some applications
who are using non-ANSI features with MySQL. This change is required to
properly support view-classes using a string as their :base-table
attribute. This allows users to specify the case of table names.
This is feature is even more essential for MySQL itself since MySQL
uses case-sensitive table names. Use connection-based database-create
and database-destroy rather than trying to invoke command-line mysql
utility. Remove automatic upcasing of strings from list-indices.
* db-postgresql/postgresql-sql.lisp: Use connection-based
database-create and database-destroy rather than trying to invoke
command-line utilities.
* db-postgresql-socket/postgresql-socket-sql.lisp: Use
database-execute-command rather than execute-command for
database-{create,destroy}. Connect to postgres database
rather than template1 for those database creation/deletion.
* sql/metaclasses.lisp: Store the string value of :base-table if a
string is provided. Perform sql-escape at time of view-table name
creation.
* tests/test-init.lisp: Use "ej_join" as a string, rather than a
symbol, since "ej_join" is specified as :base-table. Clear the
expression output-cache in case the code for generating sql output
has changed.
* test/test-oodml.lisp: whitespace fix
* sql/ooddl.lisp: Use quoted string for primary key constraint if
table name is specified as a string.
* sql/oodml.lisp: Don't convert a string view-table name to database's
default case.
* sql/expressions.lisp: Properly handle table and attribute identifiers
when they are a string. Do not change case of symbols to match database
default case.
* sql/operations.lisp: Change multiword symbols to upper case.
* sql/fddl.lisp: Quote base-table if a string to preserve case
for drop-table and create-table.
* tests/test-syntax.lisp: Add tests of low-level string attribute
identifiers.
Kevin M. Rosenberg [Fri, 31 Aug 2007 18:04:31 +0000 (18:04 +0000)]
r11859: Canonicalize whitespace
Kevin M. Rosenberg [Tue, 28 Aug 2007 14:45:17 +0000 (14:45 +0000)]
r11852:
Kevin M. Rosenberg [Thu, 26 Jul 2007 22:57:09 +0000 (22:57 +0000)]
r11773: cl-sql (3.8.6.1-3) unstable; urgency=low
* debian/control: actually use the binary:Version for any-to-any dependencies
(closes:434812)
-- Kevin M. Rosenberg <kmr@debian.org> Thu, 26 Jul 2007 16:55:29 -0600
Kevin M. Rosenberg [Mon, 23 Jul 2007 19:27:37 +0000 (19:27 +0000)]
r11768:
Kevin M. Rosenberg [Mon, 23 Jul 2007 18:57:15 +0000 (18:57 +0000)]
r11766:
Kevin M. Rosenberg [Fri, 20 Jul 2007 23:19:02 +0000 (23:19 +0000)]
r11761: 20 Jul 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 3.8.6
* db-oracle/oracle-loader.lisp: Rework use of ORACLE_HOME directory
(problem noted on clsql-devel by icardo Boccato Alves)
* sql/pool.lisp: Remove incorrect keyword
* sql/database.lisp: Rework WITH-DATABASE to not make the database the
default database (reported by Saurabh Nanda and Chaitanya Gupta)
* doc/ref-connect.lisp: Update the documentation to WITH-DATABASE to emphasis
that make-default has a default value of nil.
* sql/transaction.lisp: Adjust commit/rollback messages for Microsoft SQL Server.
(patch from Nathan Bird)
* sql/metaclasses.lisp: Use finalize-inheritance hack on SBCL because of trouble with
def-view-class compilations (patch from Nathan Bird)
Kevin M. Rosenberg [Thu, 19 Jul 2007 02:34:57 +0000 (02:34 +0000)]
r11760: do not ignore make errors
Kevin M. Rosenberg [Thu, 19 Jul 2007 02:26:14 +0000 (02:26 +0000)]
r11758: new watch file
Kevin M. Rosenberg [Mon, 16 Jul 2007 08:16:45 +0000 (08:16 +0000)]
r11754: 3.8.5 final
Kevin M. Rosenberg [Mon, 16 Jul 2007 08:15:23 +0000 (08:15 +0000)]
r11753: 15 Jul 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 3.8.5
* db-mysql/mysql-loader.lisp: Revert previous change since libmysql is
not dynamically loaded on Windows
* debian/control: Add libmysqlclient15-dev as dependency for cl-sql-mysql
since clsql-mysql modules depends on finding the .so files to load
Kevin M. Rosenberg [Fri, 22 Jun 2007 17:02:06 +0000 (17:02 +0000)]
r11736: * debian/control: Change from ${Source-Version} to ${source:Version}
Kevin M. Rosenberg [Fri, 22 Jun 2007 16:54:51 +0000 (16:54 +0000)]
r11735: 22 Jun 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 3.8.4
* db-mysql/mysql-loader.lisp: Do not bother loading libmysqlclient since
that library is dymically linked to clsql-mysql library. Thus, the mysql
library will be automatically loaded. This has only been tested on Linux,
thus far.
Kevin M. Rosenberg [Sun, 17 Jun 2007 19:39:07 +0000 (19:39 +0000)]
r11727: 17 Jun 2007 Kevin Rosenberg <kevin@rosenberg.net>
* db-mysql/mysql-loader.lisp: Do not bother loading libmysqlclient since
that library is dymically linked to clsql-mysql library. Thus, the mysql
library will be automatically loaded.
Kevin M. Rosenberg [Thu, 31 May 2007 02:51:37 +0000 (02:51 +0000)]
r11718: 29 May 2007 Kevin Rosenberg <kevin@rosenberg.net>
* tests/test-fddl.lisp: Add :order-by for :fddl/big/1 as
reported by Ricardo Boccato Alves
Kevin M. Rosenberg [Thu, 3 May 2007 03:17:56 +0000 (03:17 +0000)]
r11675: 02 May 2007 Kevin Rosenberg <kevin@rosenberg.net>
* sql/database.lisp: Add ability of WITH-DATABASE to return
multiple values (patch from Liam Healy)
Kevin M. Rosenberg [Wed, 25 Apr 2007 18:14:36 +0000 (18:14 +0000)]
r11657: 25 Apr 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 3.8.3
* doc/connect.xml: variable description fix by Liam Healy
* db-sqlite3/sqlite3-api.lisp, uffi/clsql-uffi-loader.lisp:
Apply patches from Marcus Pierce to reduce load-time warnings
* sql/package.lisp: Export iso-timestring as requested by Kevin Blaisdell
Kevin M. Rosenberg [Wed, 25 Apr 2007 07:21:53 +0000 (07:21 +0000)]
r11653: documentation update
Kevin M. Rosenberg [Wed, 25 Apr 2007 05:51:22 +0000 (05:51 +0000)]
r11651: 25 Apr 2007 Kevin Rosenberg <kevin@rosenberg.net>
* doc/connect.xml: variable description fix by Liam Healy
Kevin M. Rosenberg [Fri, 23 Mar 2007 13:44:17 +0000 (13:44 +0000)]
r11597: 23 Mar 2007 Kevin Rosenberg <kevin@rosenberg.net>
* Version 3.8.2
* sql/db-postgresql-socket-api.lisp: Change read-socket-sequence to
disable wide characters for crypt salt sequence on SBCL, based
on patch from Lars Nostdal.
Kevin M. Rosenberg [Fri, 26 Jan 2007 15:30:45 +0000 (15:30 +0000)]
r11517: Automated commit for Debian build of clsql upstream-version-3.8.1
Kevin M. Rosenberg [Thu, 25 Jan 2007 08:52:23 +0000 (08:52 +0000)]
r11510: disconnect pooled session already removed from stack with
database-disconnect rather than the higher level disconnect fn
Kevin M. Rosenberg [Thu, 25 Jan 2007 08:22:32 +0000 (08:22 +0000)]
r11509: fix number of arguments to handler-case :no-error form
Kevin M. Rosenberg [Thu, 25 Jan 2007 06:14:01 +0000 (06:14 +0000)]
r11508: 25 Jan 2007 Kevin Rosenberg <kevin@rosenberg.net>
* sql/pool.lisp: Test pooled connection when popped from
the pool to ensure the connection still works. Currently, implemented
only for MySQL.
Kevin M. Rosenberg [Fri, 19 Jan 2007 22:00:13 +0000 (22:00 +0000)]
r11497: 17 Jan 2007 Kevin Rosenberg <kevin@rosenberg.net>
* db-mysql/Makefile: Add potential mysq
Kevin M. Rosenberg [Fri, 19 Jan 2007 21:58:43 +0000 (21:58 +0000)]
r11496: add dir
Kevin M. Rosenberg [Fri, 19 Jan 2007 21:57:20 +0000 (21:57 +0000)]
r11495: add dir