From: Kevin M. Rosenberg Date: Tue, 6 Apr 2004 14:59:00 +0000 (+0000) Subject: r8836: more usql integration X-Git-Tag: v3.8.6~735 X-Git-Url: http://git.kpe.io/?p=clsql.git;a=commitdiff_plain;h=a179ca240c6f64d2dee0640ef4ceaecacd00827e r8836: more usql integration --- diff --git a/CONTRIBUTORS b/CONTRIBUTORS new file mode 100644 index 0000000..43bd401 --- /dev/null +++ b/CONTRIBUTORS @@ -0,0 +1,24 @@ +CLSQL Contributors +------------------ +Kevin Rosenberg (main author CLSQL) +Pierre Mai (original author MaiSQL from which CLSQL was based) +Marcus Pearce (initial port of USQL to CLSQL) +Marc Battyani + + +USQL Contributors +----------------- +This is a list of those individuals who have contributed in some way +or other to Uncommonsql. The sources of the attributions are CVS +annotation, patch submission, and original authorship, write us if +we've missed anybody. + +Jesse Bouwman +Craig Brozefsky +Sean Champ +Matthew Danish +Adam Di Carlo +Lyn Headley +John Krug +Pierre Mai (original author) +Christopher J. Vogt diff --git a/COPYING.USQL b/COPYING.USQL new file mode 100644 index 0000000..e27518e --- /dev/null +++ b/COPYING.USQL @@ -0,0 +1,24 @@ +Copyright (c) 1999 - 2003 onShore Development, Inc. +All rights reserved. + +Redistribution and use in source and binary forms, with or without +modification, are permitted provided that the following conditions +are met: +1. Redistributions of source code must retain the above copyright + notice, this list of conditions and the following disclaimer. +2. Redistributions in binary form must reproduce the above copyright + notice, this list of conditions and the following disclaimer in the + documentation and/or other materials provided with the distribution. +3. The name of the author may not be used to endorse or promote products + derived from this software without specific prior written permission. + +THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR +IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES +OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. +IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, +INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT +NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, +DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY +THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT +(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF +THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. diff --git a/TODO b/TODO index 139597f..4bc5eaf 100644 --- a/TODO +++ b/TODO @@ -1,2 +1,100 @@ +GENERAL +* test on (and port to) scl, mcl and openmcl; +* implement remaining functions for CLSQL AODBC backend; +* port UncommonSQL ODBC and Oracle backends to CLSQL. + +COMMONSQL SPEC + +* Missing: + + RECONNECT + CACHE-TABLE-QUERIES + *CACHE-TABLE-QUERIES-DEFAULT* + *DEFAULT-UPDATE-OBJECTS-MAX-LEN* + UPDATE-OBJECT-JOINS + INSTANCE-REFRESHED + + +* Incompatible + + + >> Initialisation and connection + + CONNECT + o should accept string as connection spec + + DISCONNECT + o should accept string as connection spec + + INITIALIZE-DATABASE-TYPE + o should initialise appropriate backend + + STATUS + o what is the behaviour in CommonSQL (esp :full parameter)? + + + >> The functional sql interface + + SELECT + o should accept keyword arg :refresh and call INSTANCE-REFRESHED + o should return (values result-list field-names) + o should coerce values returned as strings to appropriate lisp type + + QUERY + o should return (values result-list field-names) + o should coerce values returned as strings to appropriate lisp type + + LIST-ATTRIBUTE-TYPES + o should return list of (attribute datatype precision scale nullable) + + LOOP + o the extension is currently CMUCL specific + + + >> The object-oriented sql interface + + DEF-VIEW-CLASS + o get :target-slot working + o implement :retrieval :immediate + + LIST-CLASSES + o keyword arg :root-class should do something (portable) + + DO-QUERY,MAP-QUERY,LOOP + o should work with object queries as well as functional ones + + + >> Symbolic SQL syntax + + o Complete sql expressions (see operations.lisp) + + substr + some + order-by + times + nvl + null + distinct + except + intersect + between + userenv + + o variables (e.g., table identifiers) should be instantiated at runtime + + + +NOTES ABOUT THE BACKENDS + +MYSQL + +drop-index: requires a table to be specified with the :from keyword parameter +transactions: don't seem to work +views: mysql does not support views +queries: nested subqueries do not seem to work + +SQLITE + +create-view: column-list parameter not supported diff --git a/usql/CONTRIBUTORS b/usql/CONTRIBUTORS deleted file mode 100644 index fc0c0e9..0000000 --- a/usql/CONTRIBUTORS +++ /dev/null @@ -1,22 +0,0 @@ -This is a list of those individuals who have contributed in some way -or other to Uncommonsql. The sources of the attributions are CVS -annotation, patch submission, and original authorship, write us if -we've missed anybody. - -Jesse Bouwman - -Craig Brozefsky - -Sean Champ - -Matthew Danish - -Adam Di Carlo - -Lyn Headley - -John Krug - -Pierre Mai (original author) - -Christopher J. Vogt diff --git a/usql/COPYING b/usql/COPYING deleted file mode 100644 index 59644a1..0000000 --- a/usql/COPYING +++ /dev/null @@ -1,84 +0,0 @@ -This document contains the copyright notices distributed with: - - o UncommonSQL - o CLSQL - o MaiSQL - -from which this software was derived. - - -UncommonSQL ================================================================ -============================================================================ - -Copyright (c) 1999 - 2003 onShore Development, Inc. -All rights reserved. - -Redistribution and use in source and binary forms, with or without -modification, are permitted provided that the following conditions -are met: -1. Redistributions of source code must retain the above copyright - notice, this list of conditions and the following disclaimer. -2. Redistributions in binary form must reproduce the above copyright - notice, this list of conditions and the following disclaimer in the - documentation and/or other materials provided with the distribution. -3. The name of the author may not be used to endorse or promote products - derived from this software without specific prior written permission. - -THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR -IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES -OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. -IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, -INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT -NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, -DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY -THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT -(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF -THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. - - -CLSQL ====================================================================== -============================================================================ - -CLSQL is written and Copyright (c) 2002 by Kevin M. Rosenberg and is -based on the MaiSQL package written and Copyright (c) 1999-2001 by -Pierre R. Mai. - -CLSQL is licensed under the terms of the Lisp Lesser GNU -Public License (http://opensource.franz.com/preamble.html), known as -the LLGPL. The LLGPL consists of a preamble (see above URL) and the -LGPL. Where these conflict, the preamble takes precedence. -CLSQL is referenced in the preamble as the "LIBRARY." - -CLSQL is distributed in the hope that it will be useful, -but WITHOUT ANY WARRANTY; without even the implied warranty of -MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. - - -MaiSQL ===================================================================== -============================================================================ - - Copyright (C) 1999-2001 Pierre R. Mai - - Permission is hereby granted, free of charge, to any person obtaining - a copy of this software and associated documentation files (the - "Software"), to deal in the Software without restriction, including - without limitation the rights to use, copy, modify, merge, publish, - distribute, sublicense, and/or sell copies of the Software, and to - permit persons to whom the Software is furnished to do so, subject to - the following conditions: - - The above copyright notice and this permission notice shall be - included in all copies or substantial portions of the Software. - - THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, - EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF - MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. - IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY CLAIM, DAMAGES OR - OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, - ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR - OTHER DEALINGS IN THE SOFTWARE. - - Except as contained in this notice, the name of the author shall - not be used in advertising or otherwise to promote the sale, use or - other dealings in this Software without prior written authorization - from the author. diff --git a/usql/TODO b/usql/TODO deleted file mode 100644 index cedc464..0000000 --- a/usql/TODO +++ /dev/null @@ -1,101 +0,0 @@ - -GENERAL - -* test on (and port to) sbcl, lispworks, acl, scl, mcl and openmcl; -* implement remaining functions for CLSQL AODBC backend; -* port UncommonSQL ODBC and Oracle backends to CLSQL. - - -COMMONSQL SPEC - -* Missing: - - RECONNECT - CACHE-TABLE-QUERIES - *CACHE-TABLE-QUERIES-DEFAULT* - *DEFAULT-UPDATE-OBJECTS-MAX-LEN* - UPDATE-OBJECT-JOINS - INSTANCE-REFRESHED - - -* Incompatible - - - >> Initialisation and connection - - CONNECT - o should accept string as connection spec - - DISCONNECT - o should accept string as connection spec - - INITIALIZE-DATABASE-TYPE - o should initialise appropriate backend - - STATUS - o what is the behaviour in CommonSQL (esp :full parameter)? - - - >> The functional sql interface - - SELECT - o should accept keyword arg :refresh and call INSTANCE-REFRESHED - o should return (values result-list field-names) - o should coerce values returned as strings to appropriate lisp type - - QUERY - o should return (values result-list field-names) - o should coerce values returned as strings to appropriate lisp type - - LIST-ATTRIBUTE-TYPES - o should return list of (attribute datatype precision scale nullable) - - LOOP - o the extension is currently CMUCL specific - - - >> The object-oriented sql interface - - DEF-VIEW-CLASS - o get :target-slot working - o implement :retrieval :immediate - - LIST-CLASSES - o keyword arg :root-class should do something (portable) - - DO-QUERY,MAP-QUERY,LOOP - o should work with object queries as well as functional ones - - - >> Symbolic SQL syntax - - o Complete sql expressions (see operations.lisp) - - substr - some - order-by - times - nvl - null - distinct - except - intersect - between - userenv - - o variables (e.g., table identifiers) should be instantiated at runtime - - - -NOTES ABOUT THE BACKENDS - -MYSQL - -drop-index: requires a table to be specified with the :from keyword parameter -transactions: don't seem to work -views: mysql does not support views -queries: nested subqueries do not seem to work - -SQLITE - -create-view: column-list parameter not supported