clsql.git
9 years agoAdd value check before updating :default slots. auto-increment
Holger Schauer [Thu, 10 Mar 2011 12:34:15 +0000 (13:34 +0100)]
Add value check before updating :default slots.

9 years agoFix broken tests for nodes datasets by adding :autoincrement constraints.
Holger Schauer [Thu, 3 Mar 2011 15:01:21 +0000 (16:01 +0100)]
Fix broken tests for nodes datasets by adding :autoincrement constraints.

9 years agoSupport :autoincrement for Postgres on table creation by rebuilding what Postgres...
Holger Schauer [Thu, 3 Mar 2011 14:48:26 +0000 (15:48 +0100)]
Support :autoincrement for Postgres on table creation by rebuilding what Postgres is doing when using the serial tye. view-class-slot-definition-mixin: add new slot autoincrement-sequence. database-make-autoincrement-sequence: new generic function/method. database-generate-column-definition: specialize for postgresql-db. database-last-auto-increment-id: honor autoincrement-sequence. database-last-auto-increment-id: use :int for result-types, not integer.

9 years agoAdd support for :default in db constraints. make-constraint-description: use next...
Holger Schauer [Thu, 3 Mar 2011 14:37:31 +0000 (15:37 +0100)]
Add support for :default in db constraints. make-constraint-description: use next element as default value for default constraint. update-record-from-slots: fetch value for slots with defaults. ds-artists: add genre slot with default constraint. test-oodml: new test update-records/12 checks working default constraint.

9 years agods-artists: new test dataset ds-artists. clsql-tests.asd: add new filee ds-artists...
Holger Schauer [Thu, 3 Mar 2011 10:24:10 +0000 (11:24 +0100)]
ds-artists: new test dataset ds-artists. clsql-tests.asd: add new filee ds-artists. test-oodml: Add two simple tests in tests-oodml for autoincrement behaviour.

10 years agoMore code that should have been in the last patch.
Nathan Bird [Mon, 8 Mar 2010 19:07:39 +0000 (14:07 -0500)]
More code that should have been in the last patch.

10 years agoFirst draft at making auto-increment more general.
Nathan Bird [Sun, 7 Mar 2010 20:17:51 +0000 (15:17 -0500)]
First draft at making auto-increment more general.

10 years agoGot the update-record-from-* functions all going through the slots variant. all tests...
Nathan Bird [Fri, 5 Mar 2010 22:07:50 +0000 (17:07 -0500)]
Got the update-record-from-* functions all going through the slots variant. all tests pass

10 years agoAdding docstring warning on clear-con-pool
Nathan Bird [Fri, 5 Mar 2010 22:05:21 +0000 (17:05 -0500)]
Adding docstring warning on clear-con-pool

10 years agoFixing bug in test 9-slots
Nathan Bird [Fri, 5 Mar 2010 22:04:52 +0000 (17:04 -0500)]
Fixing bug in test 9-slots

10 years agoAdding changelog entry about odbc changes.
Nathan Bird [Thu, 4 Mar 2010 19:42:04 +0000 (14:42 -0500)]
Adding changelog entry about odbc changes.

10 years agoIn ODBC when reading data in chunks with a specified out-length, use that as
nathan@acceleration.net [Thu, 10 Apr 2008 15:25:12 +0000 (11:25 -0400)]
In ODBC when reading data in chunks with a specified out-length, use that as
an indicator since freetds doens't set the info status appropriately.

10 years agoDon't declare the the column precisions to be a fixnum since odbc implementations...
Nathan Bird [Fri, 27 Feb 2009 22:48:05 +0000 (17:48 -0500)]
Don't declare the the column precisions to be a fixnum since odbc implementations like to set it to 2147483647, we aren't going to allocate anything of this size, we use
guards such as max-precision on that.

10 years agoThis function now takes an encoding argument, pass what we have along
Nathan Bird [Wed, 3 Mar 2010 21:43:44 +0000 (16:43 -0500)]
This function now takes an encoding argument, pass what we have along

10 years agoRestoring &optional lambda-list flag that looks to have been dropped on accident...
Nathan Bird [Wed, 3 Mar 2010 21:43:23 +0000 (16:43 -0500)]
Restoring &optional lambda-list flag that looks to have been dropped on accident in fe6d36c1

10 years agoCheck for *db-pool-max-free-connections* being nil, if so don't enforce a max.
Nathan Bird [Wed, 3 Mar 2010 19:46:22 +0000 (14:46 -0500)]
Check for *db-pool-max-free-connections* being nil, if so don't enforce a max.

10 years agoNew builds of the documentation
Nathan Bird [Wed, 3 Mar 2010 17:26:24 +0000 (12:26 -0500)]
New builds of the documentation

10 years agoAdding new doc section on db-pool-max-free-connections, improving other doc pages...
Nathan Bird [Wed, 3 Mar 2010 17:26:05 +0000 (12:26 -0500)]
Adding new doc section on db-pool-max-free-connections, improving other doc pages on connecting and disconnecting.

10 years agoMerge branch 'master' into development
Nathan Bird [Tue, 2 Mar 2010 23:24:32 +0000 (18:24 -0500)]
Merge branch 'master' into development
(appears to be spurious, should be the same as 406feeb749bb475bec8077a2716a5b6089bd9072)

10 years agoMerge branch 'connection-pool-fix'
Nathan Bird [Tue, 2 Mar 2010 23:19:02 +0000 (18:19 -0500)]
Merge branch 'connection-pool-fix'

10 years agoUpdating ChangeLog
Nathan Bird [Tue, 2 Mar 2010 22:31:53 +0000 (17:31 -0500)]
Updating ChangeLog

10 years agoREADME: adding info about build targets
Nathan Bird [Tue, 2 Mar 2010 22:18:56 +0000 (17:18 -0500)]
README: adding info about build targets

10 years agowhitespace-cleanup
Nathan Bird [Tue, 2 Mar 2010 22:16:36 +0000 (17:16 -0500)]
whitespace-cleanup

10 years agoFixing docbook xml schema errors in the documentation.
Nathan Bird [Tue, 2 Mar 2010 22:02:33 +0000 (17:02 -0500)]
Fixing docbook xml schema errors in the documentation.

10 years agoFinishing doc for file-enable-sql-reader-syntax, adding warnings to docs on other...
Nathan Bird [Tue, 2 Mar 2010 21:57:17 +0000 (16:57 -0500)]
Finishing doc for file-enable-sql-reader-syntax, adding warnings to docs on other enable methods, tip at the top of the syntax page.

10 years agoStarting a README for how to build the doc
Nathan Bird [Tue, 2 Mar 2010 17:11:21 +0000 (12:11 -0500)]
Starting a README for how to build the doc

10 years agoBuilding doc: recognize ubuntu as being a stand in for debian.
Nathan Bird [Tue, 2 Mar 2010 17:11:06 +0000 (12:11 -0500)]
Building doc: recognize ubuntu as being a stand in for debian.

10 years agoFirst draft at doc for file-enable-sql-reader-syntax
Nathan Bird [Mon, 1 Mar 2010 22:26:19 +0000 (17:26 -0500)]
First draft at doc for file-enable-sql-reader-syntax

10 years agoIf updating an instance from the database and we found the row in the
Nathan Bird [Thu, 15 Jan 2009 16:19:09 +0000 (11:19 -0500)]
If updating an instance from the database and we found the row in the
database then set the view-database slot. This indicates that this
instance now reflects an object in that DB. Underneath
get-slot-values-from-view (the next function) we depend on the slot
being present.

10 years agoAdding an oodml read-sql-value case for double-float
Nathan Bird [Mon, 1 Mar 2010 20:17:55 +0000 (15:17 -0500)]
Adding an oodml read-sql-value case for double-float

10 years agoGuard against already converted values in read-sql-value
Nathan Bird [Mon, 20 Jul 2009 20:18:12 +0000 (16:18 -0400)]
Guard against already converted values in read-sql-value
Sometimes select has already done the conversion to native lisp format,
we then don't need to do anything here, but was causing an error as
read-from-string on a value that isn't a string isn't allowed.

10 years agonew syntax macro (FILE-ENABLE-SQL-READER-SYNTAX)
Nathan Bird [Mon, 20 Apr 2009 14:15:25 +0000 (10:15 -0400)]
new syntax macro (FILE-ENABLE-SQL-READER-SYNTAX)
Turns on the SQL reader syntax for the rest of the file.
The CL spec says that when finished loading a file the original
*readtable* is restored.  clhs COMPILE-FILE

This is because we kept having problems with the read syntax
not being disabled. When clsql goes to enable the syntax it first
checks that it hasn't already done so. Clsql believed it had, but
the lisp had correctly disabled it and so we are left without the
syntax being enabled.

10 years agoAdding some TODO notes about potential race conditions.
Nathan Bird [Mon, 1 Mar 2010 19:08:41 +0000 (14:08 -0500)]
Adding some TODO notes about potential race conditions.

10 years agoModified pool.lisp:acquire-from-conn-pool to perform connection
Nathan Bird [Mon, 5 Jan 2009 19:18:42 +0000 (14:18 -0500)]
Modified pool.lisp:acquire-from-conn-pool to perform connection
validity checks on all returned connections. Pooled connections can
become invalid whenever the pipe goes down, (such as db reboot).

Where possible use a reset command against the DB, otherwise we
do a simple 'SELECT 1;' on the connection and catch any errors
that occur, disconnecting the connection if it is no longer valid.

Several databases have reset commands that also reset connection
variables back to their database defaults leading to more consistent
behavior from a new connection.
 * mssql - sp_reset_connection
 * postgres - "RESET ALL"

Also introduced clsql-sys:*db-pool-max-free-connections* which
is a heuristic threshold for when to disconnect a connection
rather than returning it to the pool.

10 years agoRemove spurious enumeration
Kevin Rosenberg [Tue, 2 Mar 2010 03:32:13 +0000 (20:32 -0700)]
Remove spurious enumeration

10 years agoRemove spurious enumeration
Kevin Rosenberg [Tue, 2 Mar 2010 03:32:13 +0000 (20:32 -0700)]
Remove spurious enumeration

10 years agoAutomated commit for upstream build of version 5.0.4 debian-5.0.4-1 v5.0.4
Kevin Rosenberg [Wed, 17 Feb 2010 17:55:57 +0000 (10:55 -0700)]
Automated commit for upstream build of version 5.0.4

10 years agoVersion 5.0.4
Kevin Rosenberg [Wed, 17 Feb 2010 17:55:08 +0000 (10:55 -0700)]
Version 5.0.4

10 years agoMySQL options parameter fix and documentation
Kevin Rosenberg [Tue, 16 Feb 2010 16:07:32 +0000 (09:07 -0700)]
MySQL options parameter fix and documentation
* db-mysql/mysql-api.lisp: Fix mysql_options UFFI parameter list
* doc/ref-connect.xml: Document the MySQL options parameter as
  part of the connection-spec.

10 years agoCheck parse of MySQL options
Kevin Rosenberg [Mon, 15 Feb 2010 21:05:03 +0000 (14:05 -0700)]
Check parse of MySQL options

10 years agoFix minor makefile errors
Kevin Rosenberg [Mon, 15 Feb 2010 20:21:11 +0000 (13:21 -0700)]
Fix minor makefile errors

10 years agoAdded support for MySQL options
Kevin Rosenberg [Mon, 15 Feb 2010 20:12:42 +0000 (13:12 -0700)]
Added support for MySQL options
Support sending options to MySQL using mysql_options, which occurs between
the API calls of mysql_init and mysql_real_connect.

10 years agoVersion 5.0.3: Full foreign string internationalization support debian-5.0.3-1 v5.0.3
Kevin Rosenberg [Thu, 11 Feb 2010 23:03:48 +0000 (16:03 -0700)]
Version 5.0.3: Full foreign string internationalization support

10 years agoFurther internationalization.
Kevin Rosenberg [Thu, 11 Feb 2010 20:59:31 +0000 (13:59 -0700)]
Further internationalization.
Change UFFI:CONVERT-RAW-FIELD and UFFI:CONVERT-FROM-FOREIGN-STRINGS
        invocations to use the foreign character set encoding of the
        database object.

10 years agoChangelog update: mssql 'date support.
Nathan Bird [Thu, 11 Feb 2010 19:39:48 +0000 (14:39 -0500)]
Changelog update: mssql 'date support.

10 years agoMerge branch 'development'
Nathan Bird [Thu, 11 Feb 2010 19:26:04 +0000 (14:26 -0500)]
Merge branch 'development'

10 years agoSupport Snow Leopard by generating universal (x86_64,i386) dylib bundles)
Kevin Rosenberg [Thu, 11 Feb 2010 17:00:26 +0000 (10:00 -0700)]
Support Snow Leopard by generating universal (x86_64,i386) dylib bundles)

10 years agoRemoving owner reference in test :ooddl/big/1; it's not about ownership
Nathan Bird [Wed, 10 Feb 2010 22:08:46 +0000 (17:08 -0500)]
Removing owner reference in test :ooddl/big/1; it's not about ownership

10 years agoOn MSSQL < 2008 there is no timestamp (the default type for 'date), we use datetime...
Nathan Bird [Wed, 10 Feb 2010 22:08:02 +0000 (17:08 -0500)]
On MSSQL < 2008 there is no timestamp (the default type for 'date), we use datetime which is present on all versions of sqlserver.

10 years agoUpdating uffi:foreign-encoded-string-octets->uffi:foreign-encoded-octet-count to...
Nathan Bird [Wed, 10 Feb 2010 22:06:04 +0000 (17:06 -0500)]
Updating uffi:foreign-encoded-string-octets->uffi:foreign-encoded-octet-count to keep up with changes there.

10 years agoVersion 5.0.2: Add missing slot accessor, make defgenerics match defmethod debian-5.0.2-1 v5.0.2
Kevin Rosenberg [Mon, 8 Feb 2010 23:51:23 +0000 (16:51 -0700)]
Version 5.0.2: Add missing slot accessor, make defgenerics match defmethod

10 years agoVersion 5.0.1: Add encoding slot to database object debian-5.0.1-1 v5.0.1
Kevin Rosenberg [Mon, 8 Feb 2010 05:36:26 +0000 (22:36 -0700)]
Version 5.0.1: Add encoding slot to database object

10 years agoAutomated commit for debian release 5.0.0-1 debian-5.0.0-1
Kevin Rosenberg [Sun, 7 Feb 2010 09:52:55 +0000 (02:52 -0700)]
Automated commit for debian release 5.0.0-1

10 years agoAutomated commit for upstream build of version 5.0.0 v5.0.0
Kevin Rosenberg [Sun, 7 Feb 2010 09:52:35 +0000 (02:52 -0700)]
Automated commit for upstream build of version 5.0.0

10 years agoVersion 5.0.0: International character sets support
Kevin Rosenberg [Sun, 7 Feb 2010 09:50:17 +0000 (02:50 -0700)]
Version 5.0.0: International character sets support

First release of CLSQL to formally and consistently support non-ASCII
strings with encoding of external formats for SQL strings.

UFFI version 1.8.1 is higher is required.

This change may introduce some differences in string handling for
people who are using non-ASCII encoded characters.  Thus, because of
the risk of BACKWARD INCOMPATIBILITY, the major version number was
incremented with this release.

10 years agoAdd changes for internationalized strings missed on last commit.
Kevin Rosenberg [Sun, 7 Feb 2010 03:22:27 +0000 (20:22 -0700)]
Add changes for internationalized strings missed on last commit.

10 years agoSupport UFFI's new internationalized string capabilities.
Kevin Rosenberg [Sun, 7 Feb 2010 03:16:33 +0000 (20:16 -0700)]
Support UFFI's new internationalized string capabilities.

10 years agoEnsure reasonable lisp type for slot in compute-lisp-type-from-specified-type
Kevin Rosenberg [Sat, 6 Feb 2010 17:32:48 +0000 (10:32 -0700)]
Ensure reasonable lisp type for slot in compute-lisp-type-from-specified-type

10 years agoEnsure that *print-circle* is nil for comparing output of FORMAT.
Kevin Rosenberg [Sat, 6 Feb 2010 16:21:58 +0000 (09:21 -0700)]
Ensure that *print-circle* is nil for comparing output of FORMAT.

10 years agoAdd Mac OS X dylib files to .gitignore
Kevin Rosenberg [Sat, 6 Feb 2010 09:25:29 +0000 (02:25 -0700)]
Add Mac OS X dylib files to .gitignore

10 years agoRemove CVS $Id$ keyword
Kevin Rosenberg [Sat, 6 Feb 2010 09:17:01 +0000 (02:17 -0700)]
Remove CVS $Id$ keyword

10 years agoFix symbol case for case-sensitive Allegro
Kevin Rosenberg [Sat, 6 Feb 2010 07:59:07 +0000 (00:59 -0700)]
Fix symbol case for case-sensitive Allegro

10 years agoEnsure that uffi system is loaded before reading defsystem
Kevin Rosenberg [Sat, 6 Feb 2010 07:46:43 +0000 (00:46 -0700)]
Ensure that uffi system is loaded before reading defsystem

10 years agoTurn off benign console messages when testing on Postgres
Kevin Rosenberg [Sat, 6 Feb 2010 07:28:12 +0000 (00:28 -0700)]
Turn off benign console messages when testing on Postgres

10 years agoFix some case issues for case-sensitive, modern-mode Allegro
Kevin Rosenberg [Sat, 6 Feb 2010 05:37:12 +0000 (22:37 -0700)]
Fix some case issues for case-sensitive, modern-mode Allegro

10 years agoLoad and use test-i18n.lisp when uffi:no-i18n is not present in cl:*features*
Kevin Rosenberg [Fri, 5 Feb 2010 22:27:37 +0000 (15:27 -0700)]
Load and use test-i18n.lisp when uffi:no-i18n is not present in cl:*features*

10 years agoAdd OpenMCL support for #\no-break_space
Kevin Rosenberg [Fri, 5 Feb 2010 17:31:22 +0000 (10:31 -0700)]
Add OpenMCL support for #\no-break_space

10 years agoComment that CMUCL errors when reading #\no-break_space
Kevin Rosenberg [Fri, 5 Feb 2010 17:19:59 +0000 (10:19 -0700)]
Comment that CMUCL errors when reading #\no-break_space

10 years agoConditionalize read of #\no-break_space for non-unicode SBCL and non-ics Allegro.
Kevin Rosenberg [Fri, 5 Feb 2010 17:08:10 +0000 (10:08 -0700)]
Conditionalize read of #\no-break_space for non-unicode SBCL and non-ics Allegro.

10 years agoMove i18n tests to separate file until we have a better system of dealing with them.
Nathan Bird [Thu, 4 Feb 2010 14:44:00 +0000 (09:44 -0500)]
Move i18n tests to separate file until we have a better system of dealing with them.
Also added some comments to properly documenting them as multi-byte tests and describe
their properties a bit better.

10 years agoRemove spurious character
Kevin Rosenberg [Thu, 4 Feb 2010 05:02:21 +0000 (22:02 -0700)]
Remove spurious character

10 years agoUse lower case symbols for compatibility with "modern"-mode AllegroCL
Kevin Rosenberg [Thu, 4 Feb 2010 02:07:43 +0000 (19:07 -0700)]
Use lower case symbols for compatibility with "modern"-mode AllegroCL

10 years ago2 tests for sending non multibyte characters to the database and back. Not sure how...
Nathan Bird [Wed, 3 Feb 2010 22:01:47 +0000 (17:01 -0500)]
2 tests for sending non multibyte characters to the database and back. Not sure how to handle this on unicode.

10 years agoAdding some tests for sending large strings to and from the database.
Nathan Bird [Wed, 3 Feb 2010 21:09:02 +0000 (16:09 -0500)]
Adding some tests for sending large strings to and from the database.

10 years agoAdd *test-report-width* variable. Word-wrap skipped tests reason field.
Kevin Rosenberg [Wed, 3 Feb 2010 19:22:46 +0000 (12:22 -0700)]
Add *test-report-width* variable. Word-wrap skipped tests reason field.

10 years agoAllow skipped test name field width to be as narrow as possible
Kevin Rosenberg [Wed, 3 Feb 2010 17:32:27 +0000 (10:32 -0700)]
Allow skipped test name field width to be as narrow as possible

10 years agoAdding a test that is just micro-seconds for sqlserver, marking usec ones as skip.
Nathan Bird [Wed, 3 Feb 2010 15:48:33 +0000 (10:48 -0500)]
Adding a test that is just micro-seconds for sqlserver, marking usec ones as skip.

10 years agoTime printing bugfixes- Use a #\T to separate date and time per iso standard.
Nathan Bird [Wed, 3 Feb 2010 15:07:17 +0000 (10:07 -0500)]
Time printing bugfixes- Use a #\T to separate date and time per iso standard.
Thanks to Harald Hanche-Olsen for the report
http://lists.b9.com/pipermail/clsql/2010-February/001836.html

10 years agoEnsure report column is wide enough for longest test name
Kevin Rosenberg [Wed, 3 Feb 2010 09:19:02 +0000 (02:19 -0700)]
Ensure report column is wide enough for longest test name

10 years agoShorten skipped test reasons
Kevin Rosenberg [Wed, 3 Feb 2010 00:34:01 +0000 (17:34 -0700)]
Shorten skipped test reasons

10 years agoIn ODBC time conversion take into account the fraction if we have it.
Nathan Bird [Tue, 2 Feb 2010 20:52:47 +0000 (15:52 -0500)]
In ODBC time conversion take into account the fraction if we have it.

10 years agorewrite asserts in pg time tests into standard rt parlance
Russ Tyndall [Tue, 2 Feb 2010 20:53:58 +0000 (15:53 -0500)]
rewrite asserts in pg time tests into standard rt parlance

10 years agoAdding a bunch of straight parse-timestring tests.
Nathan Bird [Tue, 2 Feb 2010 20:10:05 +0000 (15:10 -0500)]
Adding a bunch of straight parse-timestring tests.

10 years agoFixed bugs in iso-timestring regarding printing microseconds
Russ Tyndall [Tue, 2 Feb 2010 19:45:29 +0000 (14:45 -0500)]
Fixed bugs in iso-timestring regarding printing microseconds

iso-timestring used to output
  YYYY-MM-DD HH:MM:SS,,UUUUUU

What was invalid in this format was the two commas and because 3 usec
would be output as xx,,3 instead of xx,,000003.

It now outputs
  YYYY-MM-DD HH:MM:SS.UUUUUU

Also we only print the amount of fractional seconds necessary.
Different databases support different precisions so this is
intended to ensure that we dont print with a greater
(ie: unparsable)  precision than we read from the DB
   EG 1.123400 sec prints as 1.1234
  and      1.0 sec prints as 1

iso-timestring new implementation tested to be ~2x less memory at
the same speed

10 years agoUse fddl on cross-platform test to try to work for more databases. remove limit from...
Nathan Bird [Tue, 2 Feb 2010 16:26:27 +0000 (11:26 -0500)]
Use fddl on cross-platform test to try to work for more databases. remove limit from queries that don't need them.

10 years agoTime test tweaks, mostly readability.
Nathan Bird [Tue, 2 Feb 2010 15:09:06 +0000 (10:09 -0500)]
Time test tweaks, mostly readability.

10 years agoTests for time printing and retrieving
Nathan Bird [Mon, 1 Feb 2010 21:33:02 +0000 (16:33 -0500)]
Tests for time printing and retrieving

These tests will create a table and verify that the date inserted is
the date retrieved and that when we update the database the value we
retrieve is the same as the one we inserted.

Some backends support timezones and some do not, also some support
usecs and some dont.

Things the following tests try to prove correct
 * Reading and writing usec and usec-less times
 * reading and writing timezones (Z=utc) when appropriate (eg: postgresql-socket)
 * reading and writing localtimes when appropriate (eg: ODBC)
 * reading and writing through both the oodml and fdml layers

All these tests fail right now. All tests may not be correct yet.

10 years agomade run-tests take a :suites arg
Russ Tyndall [Sat, 23 Jan 2010 20:42:07 +0000 (15:42 -0500)]
made run-tests take a :suites arg

Also compute-tests-for-backend and do-tests-for-backend, take a :suites arg
where you can specify the *rt-* variable "suites" you wish to run
defaulting to all of them

10 years agoMarking :connection/query-command as mysql only for now. It is low priority and cause...
Nathan Bird [Mon, 1 Feb 2010 20:12:12 +0000 (15:12 -0500)]
Marking :connection/query-command as mysql only for now. It is low priority and causes chained failures on other backends.

10 years agoadded a test for setting floats to nil and back (was failing in postgresql at some...
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)

10 years agoReduce code duplication in mysql backend.
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.

10 years agoMysql shouldn't segfault in database-query when running a command with no resultset.
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.

10 years agoAdding new connection tests that are the simplest query/command against a database...
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

10 years agoUpdating logic for odbc database-list-{tables,views} to use owner and skip system...
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.

10 years agomerge from master
Kevin Rosenberg [Fri, 29 Jan 2010 23:53:33 +0000 (16:53 -0700)]
merge from master

10 years agoVersion 4.3.3 release debian-4.3.3-1 v4.3.3
Kevin Rosenberg [Fri, 29 Jan 2010 23:49:12 +0000 (16:49 -0700)]
Version 4.3.3 release

10 years agoNew file clsql-cffi.asd
Kevin Rosenberg [Fri, 29 Jan 2010 22:00:59 +0000 (15:00 -0700)]
New file clsql-cffi.asd

10 years agoNew file clsql-cffi.asd
Kevin Rosenberg [Fri, 29 Jan 2010 22:00:59 +0000 (15:00 -0700)]
New file clsql-cffi.asd

10 years agocleanup *.asd files
Kevin Rosenberg [Fri, 29 Jan 2010 21:54:43 +0000 (14:54 -0700)]
cleanup *.asd files

10 years agocleanup *.asd files
Kevin Rosenberg [Fri, 29 Jan 2010 21:54:43 +0000 (14:54 -0700)]
cleanup *.asd files