Russ Tyndall [Tue, 26 Jan 2010 19:42:17 +0000 (14:42 -0500)]
added a test for setting floats to nil and back (was failing in postgresql at some previously)
Nathan Bird [Mon, 1 Feb 2010 19:26:50 +0000 (14:26 -0500)]
Reduce code duplication in mysql backend.
database-query and database-query-result-set call
database-execute-command which does the mysql_real_query and raises an
error if there is a problem.
Nathan Bird [Tue, 19 Jan 2010 18:59:52 +0000 (13:59 -0500)]
Mysql shouldn't segfault in database-query when running a command with no resultset.
From docs at http://dev.mysql.com/doc/refman/5.0/en/mysql-real-query.html and
http://dev.mysql.com/doc/refman/5.0/en/mysql-field-count.html after performing the query
and attempting to get a result set, the RS ptr should be checked for null and
if it is check mysql_errno to see if there actually was an error, or just no result.
This patch makes database-query return NIL if there was no resultset.
Nathan Bird [Tue, 19 Jan 2010 20:28:01 +0000 (15:28 -0500)]
Adding new connection tests that are the simplest query/command against a database connection.
Dropping test :fdml/execute-command/1 everything is tested elsewhere.
table-exists-p - :fddl/table/2
execute-command - :connection/execute-command
Nathan Bird [Sat, 23 Jan 2010 20:52:48 +0000 (15:52 -0500)]
Updating logic for odbc database-list-{tables,views} to use owner and skip system tables.
SqlServer 2005 moved around their namespaces, and added more. Adding
those to the hardcoded skip lists.
Since ODBC doesn't expose the owner we use that parameter to filter
on schema since that's what tends to be exposed. Some DBs like mssql
2000 conflate the two so at least there it works nicely.
TODO: revisit owner/schema logic.
From 2000->2005 sqlserver they separated owner from schema and so
this will probably need to be revisited further-- not sure how
given the ODBC nature.
Kevin Rosenberg [Fri, 29 Jan 2010 23:53:33 +0000 (16:53 -0700)]
merge from master
Kevin Rosenberg [Fri, 29 Jan 2010 23:49:12 +0000 (16:49 -0700)]
Version 4.3.3 release
Kevin Rosenberg [Fri, 29 Jan 2010 22:00:59 +0000 (15:00 -0700)]
New file clsql-cffi.asd
Kevin Rosenberg [Fri, 29 Jan 2010 22:00:59 +0000 (15:00 -0700)]
New file clsql-cffi.asd
Kevin Rosenberg [Fri, 29 Jan 2010 21:54:43 +0000 (14:54 -0700)]
cleanup *.asd files
Kevin Rosenberg [Fri, 29 Jan 2010 21:54:43 +0000 (14:54 -0700)]
cleanup *.asd files
Kevin Rosenberg [Fri, 29 Jan 2010 20:53:28 +0000 (13:53 -0700)]
ChangeLog line-length formatting
Nathan Bird [Fri, 29 Jan 2010 20:16:55 +0000 (15:16 -0500)]
Using the new clsql-sys::+whitespace-chars+ param.
Nathan Bird [Fri, 29 Jan 2010 20:13:57 +0000 (15:13 -0500)]
Updating the changelog with some of what's changed.
Nathan Bird [Fri, 29 Jan 2010 20:13:27 +0000 (15:13 -0500)]
Adding myself to the contributors file.
Nathan Bird [Fri, 29 Jan 2010 20:11:52 +0000 (15:11 -0500)]
Merge commit 'origin/master' into development
Kevin Rosenberg [Fri, 29 Jan 2010 19:52:32 +0000 (12:52 -0700)]
Add implementation-specific +whitespace-chars+ variable
Nathan Bird [Fri, 29 Jan 2010 19:22:04 +0000 (14:22 -0500)]
Merge commit 'master' into development
Conflicts:
tests/test-init.lisp --pretty small.
Kevin Rosenberg [Fri, 29 Jan 2010 15:50:33 +0000 (08:50 -0700)]
Conditionalize #\no-break-space for lispworks
Kevin Rosenberg [Fri, 29 Jan 2010 15:33:26 +0000 (08:33 -0700)]
Ignore 64-bit named shared library file
Kevin Rosenberg [Fri, 29 Jan 2010 15:00:12 +0000 (08:00 -0700)]
Add missing defgeneric declaration
Kevin Rosenberg [Fri, 29 Jan 2010 14:52:14 +0000 (07:52 -0700)]
Improve formatting skipped-test messages. Fix symbol name.
Kevin Rosenberg [Fri, 29 Jan 2010 14:48:02 +0000 (07:48 -0700)]
Improve skipped tests reason messages
Kevin Rosenberg [Fri, 29 Jan 2010 06:56:27 +0000 (23:56 -0700)]
Fix for UPDATE-RECORD-FROM-SLOTS for normalized view-classes
Kevin Rosenberg [Fri, 29 Jan 2010 06:50:27 +0000 (23:50 -0700)]
fix spelling of no-break-space
Signed-off-by: Kevin Rosenberg <kevin@rosenberg.net>
Kevin Rosenberg [Fri, 29 Jan 2010 01:37:09 +0000 (18:37 -0700)]
publish new release
Kevin Rosenberg [Fri, 29 Jan 2010 01:14:30 +0000 (18:14 -0700)]
Change from British normalised spelling
Signed-off-by: Kevin Rosenberg <kevin@rosenberg.net>
Kevin Rosenberg [Thu, 28 Jan 2010 23:58:47 +0000 (16:58 -0700)]
Support for 64-bit Fedora 11/12
Kevin Rosenberg [Thu, 28 Jan 2010 22:11:17 +0000 (15:11 -0700)]
Ensure that Lispworks 6 lock is sharing-mode.
Signed-off-by: Kevin Rosenberg <kevin@rosenberg.net>
Russ Tyndall [Sat, 23 Jan 2010 20:43:48 +0000 (15:43 -0500)]
added a skip this test restart on with-dataset
Nathan Bird [Tue, 26 Jan 2010 21:43:02 +0000 (16:43 -0500)]
in output-sql (sql-relational-exp)-> made it not output anything if the relation has no subexpressions.
Russ Tyndall [Fri, 22 Jan 2010 18:52:08 +0000 (13:52 -0500)]
added syntax/logical tests to check nested logical operators with different numbers of children
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