From a179ca240c6f64d2dee0640ef4ceaecacd00827e Mon Sep 17 00:00:00 2001 From: "Kevin M. Rosenberg" Date: Tue, 6 Apr 2004 14:59:00 +0000 Subject: [PATCH] r8836: more usql integration --- usql/CONTRIBUTORS => CONTRIBUTORS | 18 +++--- COPYING.USQL | 24 +++++++ TODO | 98 +++++++++++++++++++++++++++++ usql/COPYING | 84 ------------------------- usql/TODO | 101 ------------------------------ 5 files changed, 132 insertions(+), 193 deletions(-) rename usql/CONTRIBUTORS => CONTRIBUTORS (61%) create mode 100644 COPYING.USQL delete mode 100644 usql/COPYING delete mode 100644 usql/TODO diff --git a/usql/CONTRIBUTORS b/CONTRIBUTORS similarity index 61% rename from usql/CONTRIBUTORS rename to CONTRIBUTORS index fc0c0e9..43bd401 100644 --- a/usql/CONTRIBUTORS +++ b/CONTRIBUTORS @@ -1,22 +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/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 -- 2.34.1