clsql.git
19 years agor9288: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Sat, 8 May 2004 19:02:55 +0000 (19:02 +0000)]
r9288: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * tests/benchmarks.lisp: Add immediate vs. deferred
        join test.

19 years agor9287: add object selection tests
Kevin M. Rosenberg [Sat, 8 May 2004 18:05:02 +0000 (18:05 +0000)]
r9287: add object selection tests

19 years agor9286: Automated commit for Debian build of clsql upstream-version-2.10.13
Kevin M. Rosenberg [Sat, 8 May 2004 17:43:08 +0000 (17:43 +0000)]
r9286: Automated commit for Debian build of clsql upstream-version-2.10.13

19 years agor9285: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Sat, 8 May 2004 17:41:46 +0000 (17:41 +0000)]
r9285: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * sql/objects.lisp: Add :retrieval :immediate for
        object selections. More tests

19 years agor9280: sql/objects.lisp: more framework for supporing immediate retrieval
Kevin M. Rosenberg [Fri, 7 May 2004 06:15:59 +0000 (06:15 +0000)]
r9280: sql/objects.lisp: more framework for supporing immediate retrieval

19 years agor9279: Handle differences in direct-slot-definition values which
Kevin M. Rosenberg [Fri, 7 May 2004 05:53:13 +0000 (05:53 +0000)]
r9279: Handle differences in direct-slot-definition values which
        are now listify by openmcl 14.2

19 years agor9277: 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Thu, 6 May 2004 20:32:05 +0000 (20:32 +0000)]
r9277: 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * tests/test-init.lisp: Add non-index fields for testing
        join class employee-addresss
        * test/test-oodml.lisp: Add tests for retrieval immediate

19 years agor9275: new debian release, update README file location in docs
Kevin M. Rosenberg [Thu, 6 May 2004 19:42:39 +0000 (19:42 +0000)]
r9275: new debian release, update README file location in docs

19 years agor9270: No need to specialize finalize-inheritance for openmcl
Kevin M. Rosenberg [Thu, 6 May 2004 17:13:00 +0000 (17:13 +0000)]
r9270: No need to specialize finalize-inheritance for openmcl

19 years agor9269: 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Thu, 6 May 2004 17:10:52 +0000 (17:10 +0000)]
r9269: 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
        changing the type-specifier. Use a lisp type of (OR NULL FOO)
        for a specified-type of FOO unless :db-constraints :not-null.

19 years agor9261: more :base-table testing
Kevin M. Rosenberg [Thu, 6 May 2004 03:58:36 +0000 (03:58 +0000)]
r9261: more :base-table testing

19 years agor9260: 6 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Thu, 6 May 2004 03:51:35 +0000 (03:51 +0000)]
r9260: 6 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * tests/test-*.lisp: Rename fields so that joins occur on
        fields with different names. This ensures that join code is
        selecting the proper name.
        * test/test-init.lisp: Add :base-table for employee-address
        view class for testing.
        * sql/objects.lisp: Use view-table rather than name of table
        in a number of places to fix errors noted with using :base-table.

19 years agor9259: fix typo in var name
Kevin M. Rosenberg [Thu, 6 May 2004 00:36:09 +0000 (00:36 +0000)]
r9259: fix typo in var name

19 years agor9258: change package name
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:47 +0000 (00:32 +0000)]
r9258: change package name

19 years agor9257: proper name for file
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:29 +0000 (00:32 +0000)]
r9257: proper name for file

19 years agor9256: proper name for file
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:19 +0000 (00:32 +0000)]
r9256: proper name for file

19 years agor9255: move loop extension file
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:06 +0000 (00:32 +0000)]
r9255: move loop extension file

19 years agor9254: 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Wed, 5 May 2004 23:43:47 +0000 (23:43 +0000)]
r9254: 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * tests/test-syntax.lisp: Add syntax tests for SQL-OBJECT-QUERY

19 years agor9253: Add *db-auto-sync* special var for controlling creation/updating of db records...
Marcus Pearce [Wed, 5 May 2004 23:32:42 +0000 (23:32 +0000)]
r9253: Add *db-auto-sync* special var for controlling creation/updating of db records when objects are created/manipulated. Import symbols from time.lisp into clsql.

19 years agor9252: Implement new SQL-QUERY-OBJECT class and change behavior of [select 'class]
Kevin M. Rosenberg [Wed, 5 May 2004 23:03:02 +0000 (23:03 +0000)]
r9252: Implement new SQL-QUERY-OBJECT class and change behavior of [select 'class]

19 years agor9251:
Kevin M. Rosenberg [Wed, 5 May 2004 17:52:04 +0000 (17:52 +0000)]
r9251:

19 years agor9250: make :target-slot joins many times more efficient
Kevin M. Rosenberg [Wed, 5 May 2004 15:02:31 +0000 (15:02 +0000)]
r9250: make :target-slot joins many times more efficient

19 years agor9249: separate target-slot processing in prep for rewrite to use single join statement
Kevin M. Rosenberg [Wed, 5 May 2004 11:11:36 +0000 (11:11 +0000)]
r9249: separate target-slot processing in prep for rewrite to use single join statement

19 years agor9246: return list of lists for :target-slot
Kevin M. Rosenberg [Wed, 5 May 2004 10:09:10 +0000 (10:09 +0000)]
r9246: return list of lists for :target-slot

19 years agor9245: New section on optimizations, especially optimizing JOINs
Kevin M. Rosenberg [Wed, 5 May 2004 09:09:35 +0000 (09:09 +0000)]
r9245: New section on optimizations, especially optimizing JOINs

19 years agor9244: Automated commit for Debian build of clsql upstream-version-2.10.11
Kevin M. Rosenberg [Wed, 5 May 2004 08:36:20 +0000 (08:36 +0000)]
r9244: Automated commit for Debian build of clsql upstream-version-2.10.11

19 years agor9243: add :target-slot support
Kevin M. Rosenberg [Wed, 5 May 2004 08:06:39 +0000 (08:06 +0000)]
r9243: add :target-slot support

19 years agor9242: make update-records-from-instance on make-instance selectable
Kevin M. Rosenberg [Wed, 5 May 2004 06:23:38 +0000 (06:23 +0000)]
r9242: make update-records-from-instance on make-instance selectable

19 years agor9241: add type-modified database identifier support to SELECT
Kevin M. Rosenberg [Wed, 5 May 2004 04:28:32 +0000 (04:28 +0000)]
r9241: add type-modified database identifier support to SELECT

19 years agor9240: rework to avoid some sbcl optimization notes
Kevin M. Rosenberg [Wed, 5 May 2004 03:22:57 +0000 (03:22 +0000)]
r9240: rework to avoid some sbcl optimization notes

19 years agor9239: avoid multiple query-expression evaluation
Kevin M. Rosenberg [Wed, 5 May 2004 02:45:40 +0000 (02:45 +0000)]
r9239: avoid multiple query-expression evaluation

19 years agor9238: Automated commit for Debian build of clsql upstream-version-2.10.10
Kevin M. Rosenberg [Wed, 5 May 2004 02:27:32 +0000 (02:27 +0000)]
r9238: Automated commit for Debian build of clsql upstream-version-2.10.10

19 years agor9237: remove obsolete openmcl processing
Kevin M. Rosenberg [Wed, 5 May 2004 02:07:19 +0000 (02:07 +0000)]
r9237: remove obsolete openmcl processing

19 years agor9235: fix test
Kevin M. Rosenberg [Wed, 5 May 2004 01:12:03 +0000 (01:12 +0000)]
r9235: fix test

19 years agor9234: rename package
Kevin M. Rosenberg [Wed, 5 May 2004 01:00:20 +0000 (01:00 +0000)]
r9234: rename package

19 years agor9233: fix loop
Kevin M. Rosenberg [Wed, 5 May 2004 00:26:02 +0000 (00:26 +0000)]
r9233: fix loop

19 years agor9232: OODML LOOP now works on Lispworks
Kevin M. Rosenberg [Tue, 4 May 2004 23:47:56 +0000 (23:47 +0000)]
r9232: OODML LOOP now works on Lispworks

19 years agor9231: add tests for fdml query, fix loop for single-variable, result-type :auto...
Kevin M. Rosenberg [Tue, 4 May 2004 22:55:57 +0000 (22:55 +0000)]
r9231: add tests for fdml query, fix loop for single-variable, result-type :auto default for fdml query

19 years agor9230: fix loop tests
Kevin M. Rosenberg [Tue, 4 May 2004 22:01:51 +0000 (22:01 +0000)]
r9230: fix loop tests

19 years agor9229: new tests
Kevin M. Rosenberg [Tue, 4 May 2004 21:32:59 +0000 (21:32 +0000)]
r9229: new tests

19 years agor9228: add tests for result-types for map-query and do-query, ignore incorrect select...
Kevin M. Rosenberg [Tue, 4 May 2004 20:58:47 +0000 (20:58 +0000)]
r9228: add tests for result-types for map-query and do-query, ignore incorrect select for LOOP macro

19 years agor9227: 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Tue, 4 May 2004 20:43:51 +0000 (20:43 +0000)]
r9227: 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * sql/metaclasses.lisp: Properly store specified-type from
        direct-slot-definition and then store translated type in
        effective-slot-definition
        * sql/objects.lisp: Use specified type when invocating
        database-get-type-specifier. Return class for def-view-class.
        * base/basic-sql.lisp: Make :AUTO the default value for
        :RESULT-TYPES for MAP-QUERY and DO-QUERY.
        * sql/objects.lisp: Add bigint type
        * base/loop.lisp: Add placeholder (and warning) for object iteration
        * TODO: Need results for result-types for map-query and do-query

19 years agor9224: 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
Kevin M. Rosenberg [Tue, 4 May 2004 19:14:30 +0000 (19:14 +0000)]
r9224: 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * sql/metaclasses.lisp: Properly store specified-type from
        direct-slot-definition and then store translated type in
        effective-slot-definition
        * sql/objects.lisp: Use specified type when invocating
        database-get-type-specifier

19 years agor9223: Automated commit for Debian build of clsql upstream-version-2.10.9
Kevin M. Rosenberg [Tue, 4 May 2004 18:53:48 +0000 (18:53 +0000)]
r9223: Automated commit for Debian build of clsql upstream-version-2.10.9

19 years agor9222: new debian package
Kevin M. Rosenberg [Tue, 4 May 2004 18:52:39 +0000 (18:52 +0000)]
r9222: new debian package

19 years agor9221: Test for boolean slots.
Marcus Pearce [Tue, 4 May 2004 12:35:35 +0000 (12:35 +0000)]
r9221: Test for boolean slots.

19 years agor9220: Added type specifier for universal-time.
Marcus Pearce [Tue, 4 May 2004 11:50:03 +0000 (11:50 +0000)]
r9220: Added type specifier for universal-time.

19 years agor9219: sql/relations.lisp: fix to add subclassing support, minor optimizations [Edi...
Kevin M. Rosenberg [Tue, 4 May 2004 01:32:57 +0000 (01:32 +0000)]
r9219: sql/relations.lisp: fix to add subclassing support, minor optimizations [Edi Weitz]

19 years agor9216: new location
Kevin M. Rosenberg [Mon, 3 May 2004 21:58:31 +0000 (21:58 +0000)]
r9216: new location

19 years agor9215: initial benchmark suite
Kevin M. Rosenberg [Mon, 3 May 2004 21:20:16 +0000 (21:20 +0000)]
r9215: initial benchmark suite

19 years agor9214: Fix ATTRIBUTE-TYPE so that
Kevin M. Rosenberg [Mon, 3 May 2004 20:45:22 +0000 (20:45 +0000)]
r9214: Fix ATTRIBUTE-TYPE so that
        it can handle NIL values from the ODBC driver

19 years agor9213: fix odbc/postgresql null value for strings
Kevin M. Rosenberg [Mon, 3 May 2004 20:17:00 +0000 (20:17 +0000)]
r9213: fix odbc/postgresql null value for strings

19 years agor9212: Automated commit for Debian build of clsql upstream-version-2.10.8
Kevin M. Rosenberg [Mon, 3 May 2004 18:44:03 +0000 (18:44 +0000)]
r9212: Automated commit for Debian build of clsql upstream-version-2.10.8

19 years agor9211: add *backend-warning-behavior
Kevin M. Rosenberg [Mon, 3 May 2004 18:03:39 +0000 (18:03 +0000)]
r9211: add *backend-warning-behavior

19 years agor9210: handle odbc/postgresql boolean reading
Kevin M. Rosenberg [Mon, 3 May 2004 16:05:52 +0000 (16:05 +0000)]
r9210: handle odbc/postgresql boolean reading

19 years agor9209: read tinyint as integer for odbc, handle boolean reading/writing fields
Kevin M. Rosenberg [Mon, 3 May 2004 16:02:24 +0000 (16:02 +0000)]
r9209: read tinyint as integer for odbc, handle boolean reading/writing fields

19 years agor9208: fix bad declaration
Kevin M. Rosenberg [Mon, 3 May 2004 13:24:35 +0000 (13:24 +0000)]
r9208: fix bad declaration

19 years agor9207: fix bad declaration
Kevin M. Rosenberg [Mon, 3 May 2004 13:16:55 +0000 (13:16 +0000)]
r9207: fix bad declaration

19 years agor9206: Automated commit for Debian build of clsql upstream-version-2.10.6
Kevin M. Rosenberg [Mon, 3 May 2004 01:59:28 +0000 (01:59 +0000)]
r9206: Automated commit for Debian build of clsql upstream-version-2.10.6

19 years agor9205: new release
Kevin M. Rosenberg [Mon, 3 May 2004 01:58:57 +0000 (01:58 +0000)]
r9205: new release

19 years agor9204: Get DO-QUERY and MAP-QUERY working with object queries and add :field-names...
Kevin M. Rosenberg [Mon, 3 May 2004 01:58:23 +0000 (01:58 +0000)]
r9204: Get DO-QUERY and MAP-QUERY working with object queries and add :field-names argument to SELECT.

19 years agor9203: Improved CommonSQL compatibility for SELECT.
Marcus Pearce [Sun, 2 May 2004 18:24:48 +0000 (18:24 +0000)]
r9203: Improved CommonSQL compatibility for SELECT.

19 years agor9202: minor typo
Kevin M. Rosenberg [Sun, 2 May 2004 17:20:52 +0000 (17:20 +0000)]
r9202: minor typo

19 years agor9201: rename clsql-classic-sys to its former nickname of clsql-classic
Kevin M. Rosenberg [Sun, 2 May 2004 03:16:25 +0000 (03:16 +0000)]
r9201: rename clsql-classic-sys to its former nickname of clsql-classic

19 years agor9200: move large object support to base
Kevin M. Rosenberg [Sun, 2 May 2004 03:13:19 +0000 (03:13 +0000)]
r9200: move large object support to base

19 years agor9199: fold clsql-base and clsql-base-sys into clsql-base
Kevin M. Rosenberg [Sun, 2 May 2004 02:53:10 +0000 (02:53 +0000)]
r9199: fold clsql-base and clsql-base-sys into clsql-base

19 years agor9198: more needed tests
Kevin M. Rosenberg [Sun, 2 May 2004 00:56:40 +0000 (00:56 +0000)]
r9198: more needed tests

19 years agor9197: add universal-time and bigint types
Kevin M. Rosenberg [Sun, 2 May 2004 00:54:54 +0000 (00:54 +0000)]
r9197: add universal-time and bigint types

19 years agor9196: remove bogus subtest
Kevin M. Rosenberg [Sat, 1 May 2004 22:21:58 +0000 (22:21 +0000)]
r9196: remove bogus subtest

19 years agor9195: tests didn't cache old :db-type attributes
Kevin M. Rosenberg [Sat, 1 May 2004 22:04:33 +0000 (22:04 +0000)]
r9195: tests didn't cache old :db-type attributes

19 years agor9194: add new section for tests that need to be added
Kevin M. Rosenberg [Sat, 1 May 2004 22:03:03 +0000 (22:03 +0000)]
r9194: add new section for tests that need to be added

19 years agor9193: remove old :nulls-ok attribute. Add :void-value attribute.
Kevin M. Rosenberg [Sat, 1 May 2004 22:00:53 +0000 (22:00 +0000)]
r9193: remove old :nulls-ok attribute. Add :void-value attribute.

19 years agor9192: fix :db-type to :db-kind
Kevin M. Rosenberg [Sat, 1 May 2004 21:42:19 +0000 (21:42 +0000)]
r9192: fix :db-type to :db-kind

19 years agor9191: improve sqlite result-types processing, passes all tests
Kevin M. Rosenberg [Sat, 1 May 2004 20:07:04 +0000 (20:07 +0000)]
r9191: improve sqlite result-types processing, passes all tests

19 years agor9190: few bug fixes
Kevin M. Rosenberg [Sat, 1 May 2004 19:32:19 +0000 (19:32 +0000)]
r9190: few bug fixes

19 years agor9189: implement result-types for sqlite
Kevin M. Rosenberg [Sat, 1 May 2004 18:19:03 +0000 (18:19 +0000)]
r9189: implement result-types for sqlite

19 years agor9188: make result-types :auto the default
Kevin M. Rosenberg [Sat, 1 May 2004 11:41:32 +0000 (11:41 +0000)]
r9188: make result-types :auto the default

19 years agor9187: Automated commit for Debian build of clsql upstream-version-2.10.1
Kevin M. Rosenberg [Sat, 1 May 2004 10:31:49 +0000 (10:31 +0000)]
r9187: Automated commit for Debian build of clsql upstream-version-2.10.1

19 years agor9186: add attribute caching, improve inititialize-database-type
Kevin M. Rosenberg [Sat, 1 May 2004 10:31:08 +0000 (10:31 +0000)]
r9186: add attribute caching, improve inititialize-database-type

19 years agor9185: first effort at support field names in QUERY calls, still needs testing
Kevin M. Rosenberg [Sat, 1 May 2004 04:10:50 +0000 (04:10 +0000)]
r9185: first effort at support field names in QUERY calls, still needs testing

20 years agor9182: add missing extra-slot-option
Kevin M. Rosenberg [Sat, 1 May 2004 01:26:00 +0000 (01:26 +0000)]
r9182: add missing extra-slot-option

20 years agor9181: remove old lispworks cruft, replace it with code that will work on LW 4.2...
Kevin M. Rosenberg [Sat, 1 May 2004 01:12:58 +0000 (01:12 +0000)]
r9181: remove old lispworks cruft, replace it with code that will work on LW 4.2 and earlier

20 years agor9180: remove old lispworks cruft, replace it with code that will work on LW 4.2...
Kevin M. Rosenberg [Sat, 1 May 2004 01:12:54 +0000 (01:12 +0000)]
r9180: remove old lispworks cruft, replace it with code that will work on LW 4.2 and earlier

20 years agor9179: 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
Kevin M. Rosenberg [Fri, 30 Apr 2004 23:21:13 +0000 (23:21 +0000)]
r9179: 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
        * Version 2.9.6
        * sql/objects.lisp: remove create/drop-sequence-from-class.
        * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
        * sql/objects.lisp: improved CommonSQL compatibility for
        UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
        UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
        * sql/generics.lisp: move generics from objects.lisp to here.

20 years agor9178: add mysql client 4.1 version detection
Kevin M. Rosenberg [Fri, 30 Apr 2004 03:08:19 +0000 (03:08 +0000)]
r9178: add mysql client 4.1 version detection

20 years agor9169: allow :metaclass in def-view-class
Kevin M. Rosenberg [Wed, 28 Apr 2004 15:57:33 +0000 (15:57 +0000)]
r9169: allow :metaclass in def-view-class

20 years agor9168: fix transaction detection
Kevin M. Rosenberg [Tue, 27 Apr 2004 23:17:47 +0000 (23:17 +0000)]
r9168: fix transaction detection

20 years agor9166: Automated commit for clsql debian-version-2.9.4-2
Kevin M. Rosenberg [Mon, 26 Apr 2004 23:36:04 +0000 (23:36 +0000)]
r9166: Automated commit for clsql debian-version-2.9.4-2

20 years agor9165: support all lisps now
Kevin M. Rosenberg [Sat, 24 Apr 2004 14:34:20 +0000 (14:34 +0000)]
r9165: support all lisps now

20 years agor9162: case-sensitive changes
Kevin M. Rosenberg [Sat, 24 Apr 2004 13:55:48 +0000 (13:55 +0000)]
r9162: case-sensitive changes

20 years agor9154: add missing lispworks results
Kevin M. Rosenberg [Fri, 23 Apr 2004 12:01:43 +0000 (12:01 +0000)]
r9154: add missing lispworks results

20 years agor9140: Automated commit for Debian build of clsql upstream-version-2.9.3
Kevin M. Rosenberg [Fri, 23 Apr 2004 04:44:23 +0000 (04:44 +0000)]
r9140: Automated commit for Debian build of clsql upstream-version-2.9.3

20 years agor9139: new version
Kevin M. Rosenberg [Fri, 23 Apr 2004 04:27:08 +0000 (04:27 +0000)]
r9139: new version

20 years agor9138: add generics
Kevin M. Rosenberg [Fri, 23 Apr 2004 04:13:15 +0000 (04:13 +0000)]
r9138: add generics

20 years agor9137: add defgenerics
Kevin M. Rosenberg [Fri, 23 Apr 2004 03:47:55 +0000 (03:47 +0000)]
r9137: add defgenerics

20 years agor9136: fix tinyint allocation
Kevin M. Rosenberg [Fri, 23 Apr 2004 03:47:37 +0000 (03:47 +0000)]
r9136: fix tinyint allocation

20 years agor9134: add machine-type to report
Kevin M. Rosenberg [Fri, 23 Apr 2004 02:34:40 +0000 (02:34 +0000)]
r9134: add machine-type to report

20 years agor9133: case handling, test report summarizing, documentation additions
Kevin M. Rosenberg [Fri, 23 Apr 2004 02:25:57 +0000 (02:25 +0000)]
r9133: case handling, test report summarizing, documentation additions

20 years agor9129: case fixes
Kevin M. Rosenberg [Thu, 22 Apr 2004 06:14:38 +0000 (06:14 +0000)]
r9129: case fixes

20 years agor9128: all multiple specs for a given backend
Kevin M. Rosenberg [Thu, 22 Apr 2004 05:50:46 +0000 (05:50 +0000)]
r9128: all multiple specs for a given backend