gnustep/libs-sqlclient
0
0
Fork 0
mirror of https://github.com/gnustep/libs-sqlclient.git synced 2025-02-14 15:40:59 +00:00
Code Issues Projects Releases Packages Wiki Activity Actions
libs-sqlclient/ChangeLog

1811 lines
58 KiB
Text
Raw Permalink Normal View History

Fix for millisecond timestamp info
2024-01-26 14:12:01 +00:00
2024-01-26 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Fix error in parsing milliseconds in timestamp.
Report lock delays as part of query duration logging
2023-11-23 10:07:23 +00:00
2023-11-23 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: New instance variables for timing lock waits.
* SQLClient.m: Record duration of waits for locks.
* SQLClientPool.m: Tell client when pool was locked before query.
Changes so that, the time spent waiting to obtain a lock to get a
connection from a pool or to be able to execute a query on a
connection used by another thread is recorded. When query duration
logging is performed, report lock delays of over a millisecond.
Make lock reporting threshold go to zero if in debug or recording all queries.
2023-11-24 13:37:35 +00:00
If debug is on or if the query logging duration is zero, then any
lock delay (no matter how small) is reported.
Report lock delays as part of query duration logging
2023-11-23 10:07:23 +00:00
Add connect_timeout= option
2023-08-16 15:22:29 +00:00
2023-08-16 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Implement support for connect_timeoout= option to
control how long we allow for a connection attempt to a host.
make release
2023-01-13 15:00:52 +00:00
2023-01-13 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: bumped version to 1.9.0.
Track committed transactions
2022-07-14 14:08:13 +00:00
2022-06-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Declare new (-committed) method.
* SQLClient.m:
* SQLClientPool.m:
Implement -committed to return the count of transactions committed by
a client or pool. Update -description to report that too.
Add option to require encrypted connection.
2022-06-08 15:43:13 +00:00
2022-06-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Declare new (-setOptions:) method.
* SQLClient.m: Implement stub for new method and add code to call it
to register any optional configuration, passing the configuration
dictionary as a parameter.
* Postgres.m: Implement new method to store configuration information
and use sslmode option if (and only if) it is set to require an
encrypted connection.
Reinstate fix to avoid deadlock while purging pool
2020-09-01 13:24:16 +00:00
2020-09-01 Wolfgang Lux <wolfgang.lux@gmail.com>
* SQLClient.m (release): Reinstate fix to avoid deadlock while
purging pool.
Change notification code to de-duplicate notifications if/when postgres sends many copies of the same notification at the same time. Also change the code to queue notifications in the thread that received them (as documented) and only queue them in the main thread if the receiving thread does not have an active run loop.
2020-04-21 09:51:54 +00:00
2020-04-21 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Change notification code to de-duplicate notifications
if/when postgres sends many copies of the same notification at the
same time. Also change the code to queue notifications in the thread
that received them (as documented) and only queue them in the main
thread if the receiving thread does not have an active run loop.
Bring MySQL backend back to life for the GNUstep Objective-C runtime
2020-04-13 13:38:51 +00:00
2020-04-13 Wolfgang Lux <wolfgang.lux@gmail.com>
Eventually reconfigure a client connection that gets reused.
2020-04-06 07:04:08 +00:00
Bring MySQL backend back to life for the GNUstep Objective-C runtime
2020-04-13 13:38:51 +00:00
* MySQL.m (backendQuery:recordType:listType:):
Change argument types to match those of the overridden base class
implementation to make the override work with the GNUstep
Objective-C runtime.
Eventually reconfigure a client connection that gets reused
2020-04-08 12:24:39 +00:00
2020-04-08 Wolfgang Lux <wolfgang.lux@gmail.com>
Eventually reconfigure a client connection that gets reused.
2020-04-06 07:04:08 +00:00
Eventually reconfigure a client connection that gets reused
2020-04-08 12:24:39 +00:00
* SQLClient.m (clientWithConfiguration:name:):
* SQLClient.m (initWithConfiguration:name:pool:):
Eventually reconfigure a client connection that gets reused.
Eventually reconfigure a client connection that gets reused.
2020-04-06 07:04:08 +00:00
Improve logging of timings (log time taken for connection separately from that to query/execute a statement).
2020-03-21 17:15:27 +00:00
2020-03-21 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Don't attempt to establish connection before query or
execute (the superclass should do it).
* SQLClient.m: Ensure connection is established before calling backend
methods where possible. Add timing to establishment of connection.
make aware of tiny strings
2020-02-27 14:55:59 +00:00
2020-02-27 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Make the code aware of the tiny string class used by
the gnustep base library. Treat tiny strings as literal strings
because, unfortunately, we can't tell if they were created at
compile time or at run time.
changes to avoid deadlock
2020-02-25 11:21:11 +00:00
2020-02-25 Richard Frith-Macdonald <rfm@gnu.org>
make aware of tiny strings
2020-02-27 14:55:59 +00:00
* SQLClient.m: Changes to -release to avoid deadlock purging pool.
changes to avoid deadlock
2020-02-25 11:21:11 +00:00
New SQLString implementation
2020-02-14 17:04:24 +00:00
2020-02-14 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Re-implement SQLString as a true subclass rather than
using trick depending on internals of gnustep-base (which change with
the ObjC-2.0 ABI and would break).
Remove some redundant code
2020-02-11 15:32:49 +00:00
2020-02-11 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Remove redundant -prepareQuery: method.
* SQLClient.m: Remove redundant -prepareQuery: method and redundant
code from query building methods.
* SQLClientPool.m: Remove redundant -prepareQuery: method and redundant
code from query building methods.
Fix notinifcation posting to refrain from coalescing
2020-01-22 12:29:27 +00:00
2020-01-22 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Fix notification posting to refrain from coalescing.
Hide database connection password from debug logs
2019-12-11 08:40:12 +00:00
2019-12-11 Wolfgang Lux <wolfgang.lux@gmail.com>
* Postgres.m: Hide database connection password from debug logs.
fix error in exception text
2019-08-06 17:52:50 +00:00
2019-08-06 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClientPool.m: Fix error specifying query string in exceptions
Improve duration/debug logging
2019-07-29 11:33:42 +00:00
2019-07-29 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Improve logging of cache queries to indicate that
the query was from the cache and whether it was a it or a miss.
Hide structure definition from public interface, as it is incompatible with ARC
2019-07-14 08:28:27 +00:00
2019-07-14 Wolfgang Lux <wolfgang.lux@gmail.com>
* SQLClient.h
* SQLClientPool.m:
Hide definition of SQLClientPoolItem from the public interface,
as it is incompatible with automatic reference counting.
Rewrite release method to become portable accross Objective-C runtimes
2019-05-03 15:45:54 +00:00
2019-05-03 Wolfgang Lux <wolfgang.lux@gmail.com>
* SQLClient.m:
Rewrite release method to work with version 1.9 of the GNUstep
Objective-C runtime system and also Apple's runtime.
Fix insertTransaction:atIndex: to work as advertised
2019-03-07 13:08:31 +00:00
2019-03-07 Wolfgang Lux <wolfgang.lux@gmail.com>
* SQLClient.m:
Fix insertTransaction:atIndex: to work as advertised and insert at
the specified index.
Improve warnings about literals
2019-03-07 12:06:34 +00:00
2019-03-07 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: fix to make the result of a prepare method contain
'literal' strings.
Don't set flag to say we are in a transaction unless the sql executes
2019-03-07 15:09:15 +00:00
In -begin do not set the flag to say we are in a transaction until
the statement has actually executed.
Improve warnings about literals
2019-03-07 12:06:34 +00:00
Fix minor space leak in the Postgres backendConnect method
2019-02-28 17:55:23 +00:00
2019-02-28 Wolfgang Lux <wolfgang.lux@gmail.com>
* Postgres.m:
Fix minor space leak in the Postgres backendConnect method.
More sql injection prevention code
2019-02-28 16:51:49 +00:00
2019-02-28 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
add new method to pool
2019-02-28 16:57:41 +00:00
* SQLClientPool.m:
More sql injection prevention code
2019-02-28 16:51:49 +00:00
Add -prepareQuery:... method and make simpleQuery methods check that
they are given a literal (or proxy);
remove deprecated transaction merging.
2019-02-19 13:55:31 +00:00
2019-02-19 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Remove transaction merging (deprecated in 2015).
Fix optimization to reuse small data values in Postgres query results so that it actually works.
2019-01-24 10:39:28 +00:00
2019-01-24 Wolfgang Lux <wolfgang.lux@gmail.com>
* Postgres.m (backendQuery:recordType:listType:):
Fix optimization to reuse small data values in query results so
that it actually works.
Avoid loss of precision when quoting floagint-point numbers
2018-11-23 13:46:01 +00:00
2018-11-23 Wolfgang Lux <wolfgang.lux@gmail.com>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Use a double for the argument of quoteFloat: and replace the
inappropriate %f conversion by %.17g to avoid loss of precision
when quoting floating-point numbers.
* SQLClient.m: Fix some spelling errors.
2018-07-27 08:21:10 +00:00
2018-07-27 Yavor Doganov <yavor@gnu.org>
* SQLClient.m: Fix some spelling errors.
Make SQLTransaction methods thread-safe
2018-06-29 08:22:13 +00:00
2018-06-28 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Make SQLTransaction thread-safe, also add -lock and -unlock methods
to allow a sequence of other methods to be called without another
thread interfering. Add -setResetOnExecute: method to configure a
transaction to be automatically reset on successful execution.
fixup for {key?default} syntax
2018-04-16 15:45:25 +00:00
2018-04-16 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix error checking for nil values when preparing with
a dictionary. This should make the {key?default} syntax work.
Simplify database notification observation
2017-09-19 10:28:05 +00:00
2017-09-19 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Simplify observation of database notifications ... one observation per
name per observing object.
Making ready for release
2017-08-31 10:05:08 +00:00
2017-07-27 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Temporarily restore earlier behavior ...
Autoquote warnings off by default.
Connection retries off by default.
In future releases the plan is to
a. have connection attempts retried forever by default
b. first turn on warnings about autoquote issues by default
c. later, rurn on autoquote by default
More auto retry code
2017-08-27 15:13:10 +00:00
2017-07-27 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Have connection attempts automatically retried (blocking
indefinitely). Have queries and statements outside a transaction
automatically retried if they fail due to loss of connection.
fixups for notification file handle monitoring
2017-08-25 09:33:55 +00:00
2017-08-25 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Cache the file descriptor to fix problem in cleanup
when postgres returns -1 from PQsocket() as we are trying to remove
descriptor from run loop. Also fix error in unlisten where we would
stop monitoring the descriptor prematurely.
Fix for clean handling of loss of database server connection when we are listening for notifications.
2017-08-15 10:13:06 +00:00
2017-08-15 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Add code so that if the database connection is lost
while we are listening for notifications from it, we notice that
and clean up properly rather than continuing to process/ignore a
stream of end-of-file events on the dead descriptor.
More quoting changes
2017-07-04 11:13:16 +00:00
2017-07-04 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
* Postgres.m:
Lots of changes introducing new concept of a 'literal' as a string
which does not need to be quoted (and must not be autoquoted).
Quoting via the -quote: method now raises an exception if the
argument is not supported, but we have a new method to allow
classes to provide a mechanism for quoting themselves (ie to add
support for them being using in SQL queries/statements).
comment on new method and turn warnings on by default
2017-06-29 08:47:40 +00:00
2017-06-29 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
New method to control warnings (on by default) about strings which
would automaticaly be quoted when autoquote is turned on.
Fix leak git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@40453 72102866-910b-0410-8b05-ffd578937521
2017-04-07 14:27:20 +00:00
2017-04-07 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m:
Fix leak of SQLString instances caused by inheriting memory management
methods from the literal string class.
Changes for sql injection attack resistance. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@40368 72102866-910b-0410-8b05-ffd578937521
2017-03-06 17:23:37 +00:00
2017-03-06 Richard Frith-Macdonald <rfm@gnu.org>
Fix leak git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@40453 72102866-910b-0410-8b05-ffd578937521
2017-04-07 14:27:20 +00:00
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Changes for sql injection attack resistance. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@40368 72102866-910b-0410-8b05-ffd578937521
2017-03-06 17:23:37 +00:00
Add new +literal: and -literal: methods to make a normal string into
one recognised as suitable for use literally (ie without quoting) in
an SQL query/statement.
Add +setAutoquote: method to turn on automatic quoting of non-literal
strings as an aid to avoiding SQL injectiuon attacks.
Fix for thread safety issue spotted by Wolfgang. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@40162 72102866-910b-0410-8b05-ffd578937521
2016-10-19 12:38:02 +00:00
2016-10-19 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Wolfgang spotted that the asynchronous notification
code is not thread safe ... we must not have one thread handle a
notification at the same time that another is trying to use the
database connectionto execute a query/statement.
Use the client's lock to prevent that from happening.
Don't allow pool clients to be set as database notification observers git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@40152 72102866-910b-0410-8b05-ffd578937521
2016-10-18 08:32:05 +00:00
2016-10-18 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Make -addObserver:selector:name: raise if applied to a client in a
pool. Improve documentation to make it clear that pool clients
can't be used as observers of database notifications.
fix to use case sensitive notification names git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39909 72102866-910b-0410-8b05-ffd578937521
2016-06-23 11:00:58 +00:00
2016-06-23 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fixup to use case sensitive notification names.
fixes to ensure that we don't return a client to a pool while it has notification observers. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39895 72102866-910b-0410-8b05-ffd578937521
2016-06-21 15:34:42 +00:00
2016-06-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Allow easy removal of all database notification observers.
Remove all observers when a client is returned to a pool.
missing changelog entry git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39899 72102866-910b-0410-8b05-ffd578937521
2016-06-21 16:15:51 +00:00
Postgres.m:
Implement asynchronous notification by watching descriptor.
fixes to ensure that we don't return a client to a pool while it has notification observers. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39895 72102866-910b-0410-8b05-ffd578937521
2016-06-21 15:34:42 +00:00
bugfixes git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39730 72102866-910b-0410-8b05-ffd578937521
2016-05-06 13:01:42 +00:00
2016-05-06 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix bug in initialisation ordering.
* Postgres.m: Fix bug in array parsing.
Add -isNull git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39698 72102866-910b-0410-8b05-ffd578937521
2016-04-27 07:55:26 +00:00
2016-04-27 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add -isNull helper method for testing for null fields in records
returned from the database.
fix for #47178 git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@39394 72102866-910b-0410-8b05-ffd578937521
2016-02-18 09:25:09 +00:00
2016-02-18 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: get host and cpu with more recent gnustep-make
* configure: regenerate
* JDBC.m: Update for connection pools (bug #47178)
* testJDBC.m: get rid of compiler warnings
Improve handling of server failure git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38974 72102866-910b-0410-8b05-ffd578937521
2015-09-08 08:12:18 +00:00
2015-07-22 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: disconnect on fatal error, so we don't keep trying to
re-use the same connection when there's a problem with the server.
Ensure dates are quoted correctly irrespective of their current format. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38835 72102866-910b-0410-8b05-ffd578937521
2015-07-23 14:59:03 +00:00
2015-07-23 Wolfgang Lux <wolfgang.lux@gmail.com>
* SQLClient.m (initialize): Restore initialization of NSDateClass
so that dates are quoted correctly irrespective of their current
format.
Internal reorganisation git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38826 72102866-910b-0410-8b05-ffd578937521
2015-07-22 11:04:39 +00:00
2015-07-22 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClientPool.m:
Change internal pool data to allow for storing reference counts and
first attempt at allowing re-use of a client by different code layers as long as they are in the same thread. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38827 72102866-910b-0410-8b05-ffd578937521
2015-07-22 12:45:21 +00:00
the threads which own each client connection.
Support exclusive and non-exclusive clients in the pool, where an
exclusive client is one which is only usable by the code which
fetched it from the pool, but a non-exclusive client may be provided
to other code in the same thread.
Change behavior of -provideClient and -provideClientBeforeDate: to
provide non-exclusive clients.
Add -provideClientExclusive and -provideClientBeforeDate:exclusive:
to support the old behavior.
Internal reorganisation git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38826 72102866-910b-0410-8b05-ffd578937521
2015-07-22 11:04:39 +00:00
Add support for parsing "char"[] into NSArray git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38813 72102866-910b-0410-8b05-ffd578937521
2015-07-17 13:36:49 +00:00
2015-07-17 Niels Grewe <niels.grewe@halbordnung.de>
* Postgres.m: Support for "char"[] parsing.
Use local time zone instead of GMT when parsing a date without a time zone. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38810 72102866-910b-0410-8b05-ffd578937521
2015-07-16 13:54:23 +00:00
2015-07-16 Wolfgang Lux <wolfgang.lux@gmail.com>
* Postgres.m (newDateFromBuffer): Use local time zone instead of
GMT when parsing a date without a time zone.
fix deadlock git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38717 72102866-910b-0410-8b05-ffd578937521
2015-06-29 10:38:39 +00:00
2015-06-29 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Implement another missing convenience method.
Fix locking error when executing a batch.
Another new method for pools and transactions git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38718 72102866-910b-0410-8b05-ffd578937521
2015-06-29 11:59:18 +00:00
Add -prepare:with: method for use by transactions.
further cleanups git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38719 72102866-910b-0410-8b05-ffd578937521
2015-06-29 12:07:00 +00:00
Add -owner method to get a transaction's owner.
fix deadlock git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38717 72102866-910b-0410-8b05-ffd578937521
2015-06-29 10:38:39 +00:00
implement -batch: git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38714 72102866-910b-0410-8b05-ffd578937521
2015-06-27 15:28:03 +00:00
2015-06-27 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Implement -batch: method for client pools.
client name settings git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38694 72102866-910b-0410-8b05-ffd578937521
2015-06-26 12:06:13 +00:00
2015-06-26 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Implement -transaction method for client pools so that we can build
a transaction which, when executed, will use any available client
from the pool.
Support setting of the client name for clients in a pool.
Add an accessor method to SQLClient to allow getting the pool that owns the connection. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38679 72102866-910b-0410-8b05-ffd578937521
2015-06-25 13:38:41 +00:00
2015-06-25 Niels Grewe <niels.grewe@halbordnung.de>
* SQLClient.[hm]: Add an accessor method to obtain the SQLClientPool
client name settings git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38694 72102866-910b-0410-8b05-ffd578937521
2015-06-26 12:06:13 +00:00
object owning a specific SQLClient.
Add an accessor method to SQLClient to allow getting the pool that owns the connection. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38679 72102866-910b-0410-8b05-ffd578937521
2015-06-25 13:38:41 +00:00
Fixup default name git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38678 72102866-910b-0410-8b05-ffd578937521
2015-06-25 08:08:47 +00:00
2015-06-25 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add -name method for pools.
* SQLClient.m: Match documentation and use 'Database' as default name.
* SQLClientPool.m: Add -name method and fix default name.
fix error parsing timezone. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38643 72102866-910b-0410-8b05-ffd578937521
2015-06-16 09:37:59 +00:00
2015-06-19 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Fix error parsing timezone in date.
Attempted deadlock fix git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38606 72102866-910b-0410-8b05-ffd578937521
2015-06-09 16:47:36 +00:00
2015-06-09 Richard Frith-Macdonald <rfm@gnu.org>
Fixup default name git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38678 72102866-910b-0410-8b05-ffd578937521
2015-06-25 08:08:47 +00:00
* SQLClient.m: Fix race condition spotted by Wolfgang and change
Attempted deadlock fix git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38606 72102866-910b-0410-8b05-ffd578937521
2015-06-09 16:47:36 +00:00
purge operation to avoid disconnecting clients while the class lock
is locked.
Various pool management enhancements git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38579 72102866-910b-0410-8b05-ffd578937521
2015-05-28 08:39:10 +00:00
2015-05-28 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add pool purge control method.
* SQLClient.m: Fix bug finding least recently used client.
* SQLClientPool.m: Refine purging of pool. Fix autorelease bug.
Improve diagnostics. Fix bug reporting time pool has blocked.
connection pool enhancements git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38578 72102866-910b-0410-8b05-ffd578937521
2015-05-27 14:53:36 +00:00
2015-05-27 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: bugfixes
* SQLClient.m: bugfix for finding oldest idle connection
* SQLClientPool.m: implement method to disconnect idle connections
in pool. also check for clients being returned to pool while a
transaction is still in progress.
Optimisation tweaks git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38467 72102866-910b-0410-8b05-ffd578937521
2015-04-30 09:12:47 +00:00
2015-04-30 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m:
* testPostgres.m:
Fix error parsing timestamps in arrays when the server quoters them.
Also optimise string allocation, and add some tests.
performance tweaks git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38461 72102866-910b-0410-8b05-ffd578937521
2015-04-28 11:47:23 +00:00
2015-04-28 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* Postgres.m:
Optimisation tweaks git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38467 72102866-910b-0410-8b05-ffd578937521
2015-04-30 09:12:47 +00:00
Deprecate transaction merging.
performance tweaks git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38461 72102866-910b-0410-8b05-ffd578937521
2015-04-28 11:47:23 +00:00
Rewrite SQLRecord concrete class to use a new SQLRecordKeys object
shared between all the records produced by a query (as a performance
enhancement for large queries).
fixup to post notifications from the database on the main thread git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38457 72102866-910b-0410-8b05-ffd578937521
2015-04-15 16:14:02 +00:00
2015-04-15 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: notifications are posted in main thread.
Changes to avoid a client being removed from the pool longer than necessary. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38454 72102866-910b-0410-8b05-ffd578937521
2015-04-13 08:30:31 +00:00
2015-04-13 Richard Frith-Macdonald <rfm@gnu.org>
add -cache method for client pool git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38455 72102866-910b-0410-8b05-ffd578937521
2015-04-13 09:23:29 +00:00
* SQLClient.h:
Changes to avoid a client being removed from the pool longer than necessary. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38454 72102866-910b-0410-8b05-ffd578937521
2015-04-13 08:30:31 +00:00
* SQLClientPool.m:
Make sure clients provided temporarily in convenience methods are
swallowed by the pool again as soon as possible. Also trap and
re-raise exceptions after swallowing provided client, to avoid
the client being in use longer than necessary after an exception.
Also, avoid taking clients from the pool in a few cases wehere we
don't actually need to.
add -cache method for client pool git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38455 72102866-910b-0410-8b05-ffd578937521
2015-04-13 09:23:29 +00:00
Add -cache method for SQLClientPool.
Changes to avoid a client being removed from the pool longer than necessary. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38454 72102866-910b-0410-8b05-ffd578937521
2015-04-13 08:30:31 +00:00
expose method git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38453 72102866-910b-0410-8b05-ffd578937521
2015-04-12 09:50:50 +00:00
2015-04-12 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Expose method to add statement for insertion of data objects to
transaction.
quoting improvements for pools git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38452 72102866-910b-0410-8b05-ffd578937521
2015-04-09 08:04:38 +00:00
2015-04-09 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add array quoting method for pool. Add pool ivar.
* SQLClientPool.m: Implement array quoting and change other quoting
to use new ivar rather than expensive provide/swallow sequence.
Threading/notification improvments git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38447 72102866-910b-0410-8b05-ffd578937521
2015-04-01 11:32:49 +00:00
2015-04-01 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* Postgres.m:
Fixup notification posting to be asynchronous using the default
notification queue for the thread so that the notifications do
not get delivered while the query/statement at which they were
detected is still in progress.
Add method to explicitly grab/release the client for the current
thread.
Add preliminary array support git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38400 72102866-910b-0410-8b05-ffd578937521
2015-03-11 17:16:14 +00:00
2015-03-11 Richard Frith-Macdonald <rfm@gnu.org>
Threading/notification improvments git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38447 72102866-910b-0410-8b05-ffd578937521
2015-04-01 11:32:49 +00:00
* SQLClientPool.m: Fixup for exposing prepare method
Add preliminary array support git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38400 72102866-910b-0410-8b05-ffd578937521
2015-03-11 17:16:14 +00:00
* SQLClient.h:
* SQLClient.m:
* Postgres.m:
* testPostgres.m:
Add simple array support for char/varchar/text, integer/real,
Threading/notification improvments git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38447 72102866-910b-0410-8b05-ffd578937521
2015-04-01 11:32:49 +00:00
timestamp, bool and bytea. When a query returns an array of
one of these types, the resulting object is an NSArray containing
the database array elements rather than an NSString containing the
string literal representation of the database array.
Also added a method to convert an NSArray to a string literal
representation of a database array.
Add preliminary array support git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38400 72102866-910b-0410-8b05-ffd578937521
2015-03-11 17:16:14 +00:00
Improve string quotng support git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38373 72102866-910b-0410-8b05-ffd578937521
2015-03-02 09:36:50 +00:00
2015-03-02 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.h: Drop support for old versions of postgres which didn't
support standard conforming strings. This allows us to always turn
on standard conforming strings and be able to quote string and bytea
objects whether the database connection has been established or not.
bump version when we drop support for versions of postgres which don't support standard sql strings git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38374 72102866-910b-0410-8b05-ffd578937521
2015-03-02 15:19:15 +00:00
* GNUmakefile:
Bumped version to 1.8.4.
Improve string quotng support git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38373 72102866-910b-0410-8b05-ffd578937521
2015-03-02 09:36:50 +00:00
updat to 1.8.2 for exposing minor functionality git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38366 72102866-910b-0410-8b05-ffd578937521
2015-02-26 16:14:51 +00:00
2014-12-11 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* GNUmakefile:
Expose method to prepare a statement and a convenience method to
check for an existing cached value (using a prepared statement
as the cache key).
Bumped version to 1.8.3.
convenience methods git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38249 72102866-910b-0410-8b05-ffd578937521
2014-12-11 17:26:32 +00:00
2014-12-11 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Fix minor thread safety issue.
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Convenience methods to let a pool act as a client for any one-off op.
fix to handle TIME fields git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38183 72102866-910b-0410-8b05-ffd578937521
2014-11-19 10:21:24 +00:00
2014-11-19 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: bump version to 1.8.2 for bugfix release.
* Postgres.m: Fix error handling TIME fields.
2014-11-04 Richard Frith-Macdonald <rfm@gnu.org>
new release git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38158 72102866-910b-0410-8b05-ffd578937521
2014-11-04 12:33:10 +00:00
* GNUmakefile: bump version to 1.8.1 for connection pool tweaks.
connection pool tweaks git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38114 72102866-910b-0410-8b05-ffd578937521
2014-10-13 10:47:06 +00:00
2014-10-13 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* SQLClientPool.m:
Keep connections in pools outside the normal count of maximum number
of concurrent connections. If we are using a pool then we must
assume we want the pool to operate to its configured capacity.
thread-safety fixup git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38110 72102866-910b-0410-8b05-ffd578937521
2014-10-07 09:15:16 +00:00
2014-10-07 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Add locking of the database client by SQLTransaction
in case another thread tries to use the client whjile the transaction
is using it (ie between an attempted transaction and a rollback if
it fails).
fix failure to roll back git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38101 72102866-910b-0410-8b05-ffd578937521
2014-10-02 20:30:22 +00:00
2014-10-02 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: On exception during SQLTransaction -execute, roll back.
don't auto-disconnect on error git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38091 72102866-910b-0410-8b05-ffd578937521
2014-09-24 15:03:05 +00:00
2014-09-24 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: An SQL exception/error should not automatically
disconnect.
Fix bug setting database user git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38070 72102866-910b-0410-8b05-ffd578937521
2014-09-10 11:36:20 +00:00
2014-09-10 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m:
Fix error in [-setUser:] ... was checking wrong instance variable
to see if the user changed.
lter merging mechanism for flexibility and ease of use git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38043 72102866-910b-0410-8b05-ffd578937521
2014-08-09 14:02:11 +00:00
2014-08-09 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Redesign merging to give control over the number of statements
merged and to make merging an attribute of the transaction
rather than something done by a specific method.
first attempt at merge code git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@38041 72102866-910b-0410-8b05-ffd578937521
2014-08-08 08:07:06 +00:00
2014-08-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add merging of insert/update statements in a transaction.
patch by Yavor for versioned bundles git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37999 72102866-910b-0410-8b05-ffd578937521
2014-07-17 08:51:33 +00:00
2014-07-17 Yavor Doganov <yavor@gnu.org>
Install bundles in a versioned directory.
* GNUmakefile (BUNDLE_INSTALL_DIR): Append the interface version.
* GNUmakefile.preamble (ADDITIONAL_CPPFLAGS): Define.
* SQLClient.m (-_configure:): Load bundles from the versioned
directory.
fixes for bug #42733 and bug #42734 by Yavor git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37993 72102866-910b-0410-8b05-ffd578937521
2014-07-13 08:38:55 +00:00
2014-07-11 Yavor Doganov <yavor@gnu.org>
* GNUmakefile (SQLClient_LIBRARIES_DEPEND_UPON): Add $(FND_LIBS)
and $(OBJC_LIBS).
new version number git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37958 72102866-910b-0410-8b05-ffd578937521
2014-06-20 15:44:52 +00:00
2014-06-20 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: bump version to 1.8.0 for next release (will break
binary compatibility due to changes for pools adding ivars).
more pool improvements git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37953 72102866-910b-0410-8b05-ffd578937521
2014-06-20 08:35:33 +00:00
2014-06-20 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add SQLClientPool, new method to check idle clients
and new initialiser.
* SQLClient.m: Changes to support pools of clients and permit a pool
to contain multiple clients with the same config.
* SQLClientPool.m: new class to provide a pool of clients with the
same config.
bugfix release for thread safety of notifications git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37913 72102866-910b-0410-8b05-ffd578937521
2014-05-27 15:22:35 +00:00
2014-05-27 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Warn about not using the database inside a
notification handler.
* Postgres.m: Add locking around database operations caused
by asynchronous arrival of a notification.
* GNUmakefile: new subminor version for bugfix release
* Version 1.7.3: released
more locking added git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37892 72102866-910b-0410-8b05-ffd578937521
2014-05-19 08:30:31 +00:00
2014-05-19 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: More locking to try to protect all access to the
database connection.
* GNUmakefile: new subminor version for bugfix release
* Version 1.7.2: released
fix minor thread safety issue git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37878 72102866-910b-0410-8b05-ffd578937521
2014-05-13 10:26:48 +00:00
2014-05-13 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m:
Fix tiny window in which a connection could be unlocked yet have
the flag set to say it is in a transaction (thus potentially
allowing a locking consistency error).
more thread-safety changes git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37879 72102866-910b-0410-8b05-ffd578937521
2014-05-13 11:01:50 +00:00
Add locking to protect setting/changing configuration.
fix minor thread safety issue git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37878 72102866-910b-0410-8b05-ffd578937521
2014-05-13 10:26:48 +00:00
1.7.1 bugfix release git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37859 72102866-910b-0410-8b05-ffd578937521
2014-05-08 07:56:13 +00:00
2014-05-08 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: new subminor version for bugfix release
* Version 1.7.1: released
Fix retain/release error git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37794 72102866-910b-0410-8b05-ffd578937521
2014-04-12 07:24:31 +00:00
2014-04-12 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m:
Fix error removing database observer when last name is removed.
Fix incorrect comparison operator. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37725 72102866-910b-0410-8b05-ffd578937521
2014-03-05 17:25:07 +00:00
2014-03-05 Wolfgang Lux <wolfgang.lux@gmail.com>
* Postgres.m (backendExecute:):
Fix incorrect comparison operator.
fixup for caching queries git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37700 72102866-910b-0410-8b05-ffd578937521
2014-02-21 09:56:09 +00:00
2014-02-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add mutable copy implementation so that set and dictionary builders
can be used by caching queries without raising an exception ... the
mutable copy of the helper's content is what gets cached.
add helper for building counted set git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37692 72102866-910b-0410-8b05-ffd578937521
2014-02-15 07:16:26 +00:00
2014-02-15 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add helper for building counted set from query.
add 1.7 release note git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37044 72102866-910b-0410-8b05-ffd578937521
2013-09-06 06:59:13 +00:00
2013-09-06 Richard Frith-Macdonald <rfm@gnu.org>
* Version 1.7.0: released
fixup return type of sizeInBytes: git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@37042 72102866-910b-0410-8b05-ffd578937521
2013-09-05 12:48:53 +00:00
2013-09-05 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Use NSUInteger for sizeInBytes:
Turn off automatic trimming by default git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36500 72102866-910b-0410-8b05-ffd578937521
2013-04-10 15:03:55 +00:00
2013-04-10 Richard Frith-Macdonald <rfm@gnu.org>
* ECPG.pgm:
* MySQL.m:
* Oracle.pm:
* Postgres.m:
* SQLClient.h:
* SQLClient.m:
* GNUmakefile:
Change behavior to no longer trim leading and trailing space from
values retrieved from database by default.
Add method to restore automatic trimming for a connection if needed.
1.6.0 release git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36262 72102866-910b-0410-8b05-ffd578937521
2013-03-04 14:48:29 +00:00
2013-03-04 Richard Frith-Macdonald <rfm@gnu.org>
fixup version for minor release git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36264 72102866-910b-0410-8b05-ffd578937521
2013-03-04 14:59:14 +00:00
* Version 1.6.1: released
1.6.0 release git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36262 72102866-910b-0410-8b05-ffd578937521
2013-03-04 14:48:29 +00:00
add helper classes git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36261 72102866-910b-0410-8b05-ffd578937521
2013-03-04 14:47:29 +00:00
2013-03-04 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add helper classe interfaces.
* SQLClient.m: Add helper classe implementations.
Add performance helper classes for when querying a set of records
containing single values and when querying a dataset which contains
key/value pairs more naturally haqndled as a dictionary than an array.
* ECPG.pgm * testECPG.m * testMySQL.m * testSQLite.m use PRIuPTR to NSLog NSUIntegers OK Richard git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36111 72102866-910b-0410-8b05-ffd578937521
2013-02-11 16:05:47 +00:00
2013-02-11 Sebastian Reitenbach <sebastia@l00-bugdead-prods.de>
* ECPG.pgm
* testECPG.m
* testMySQL.m
* testSQLite.m
use PRIuPTR to NSLog NSUIntegers
fixes for potential locking issues. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@36047 72102866-910b-0410-8b05-ffd578937521
2013-01-31 09:04:35 +00:00
2013-01-31 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Check for -disconnect being called when inside a
transaction and handle locking properly in that case.
Change simple execute and query methods so they don't call -debug:
inside locked regions, in case the method has been overridden to
do something not safe in such locked sections (such as trying a
query in another thread to report extra debug info).
lock safety fixes git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35832 72102866-910b-0410-8b05-ffd578937521
2012-11-29 11:40:04 +00:00
2012-11-29 Richard Frith-Macdonald <rfm@gnu.org>
* Wrap more code in exception handlers where there is any potential
for an exception in a lock protected region.
Don't use -lobjc -lgnustep-base, use $(FND_LIBS) and $(OBJC_LIBS) instead. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35788 72102866-910b-0410-8b05-ffd578937521
2012-11-10 13:33:39 +00:00
2012-11-10 Niels Grewe <niels.grewe@halbordnung.de>
* GNUmakefile: Link against $(FND_LIBS) and $(OBJC_LIBS) instead
of -lgnustep-base and -lobjc.
Support for async notifications in Postgres git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35732 72102866-910b-0410-8b05-ffd578937521
2012-10-22 15:57:56 +00:00
2012-10-22 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* Postgres.m:
* GNUmakefile:
Add support for asynchronous notifications and bump version number.
improved execute git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35722 72102866-910b-0410-8b05-ffd578937521
2012-10-19 18:41:36 +00:00
2012-10-18 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* ECPG.pgm:
* MySQL.m:
* Postgres.m:
* Oracle.pm:
* SQLite.m:
* JDBC.m:
* testPostgres.m:
Change execute methods to return a count of the rows to which the
executed operation applies, or -1 if not supported.
tweak git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35723 72102866-910b-0410-8b05-ffd578937521
2012-10-19 18:51:51 +00:00
Implement for postgresql and mysql.
improved execute git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35722 72102866-910b-0410-8b05-ffd578937521
2012-10-19 18:41:36 +00:00
improve transaction compatibility check git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@35206 72102866-910b-0410-8b05-ffd578937521
2012-06-17 14:57:48 +00:00
2012-06-17 Richard Frith-Macdonald <rfm@gnu.org>
* Improve check for compatibility of transactions between clients.
mkae version 1.5.3 git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@33914 72102866-910b-0410-8b05-ffd578937521
2011-09-30 17:21:04 +00:00
2011-09-30 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: try to use pg_config if available.
* configure: regenerate
* Postgres.m: Fix to handle new bytea with \x format
* GNUmakefile: Bump to 1.5.3
locking cleanups git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@33842 72102866-910b-0410-8b05-ffd578937521
2011-09-16 07:25:33 +00:00
2011-04-01 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Cleanup locking on -begin/-commit/-rollback
* Version 1.5.2: bump version number
bump version number git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@32750 72102866-910b-0410-8b05-ffd578937521
2011-04-01 04:09:40 +00:00
2011-04-01 Richard Frith-Macdonald <rfm@gnu.org>
* Version 1.5.1: bump version number
Fixed rebuilding the library; nothing should happen if you type 'make' in an already-built directory git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@31615 72102866-910b-0410-8b05-ffd578937521
2010-11-17 15:21:11 +00:00
2010-11-17 Nicola Pero <nicola.pero@meta-innovation.com>
* GNUmakefile.postamble: Uncommented .PRECIOUS for ECPG and
Oracle, so that typing 'make' does nothing when everything is
already built.
mysql fixes git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@31131 72102866-910b-0410-8b05-ffd578937521
2010-08-13 13:20:06 +00:00
2010-08-13 Richard Frith-Macdonald <rfm@gnu.org>
* MySQL.m: Try to recognise loss of connection.
Fix bug in timezone management.
MySQL fixups git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@30982 72102866-910b-0410-8b05-ffd578937521
2010-07-16 14:49:55 +00:00
2010-07-16 Richard Frith-Macdonald <rfm@gnu.org>
* MySQL.m: Add support for TEXT data and for MySQL's failure to support
timezones. Also add support for multiple statements in a batch.
check for mysqlclient library in more places git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@30977 72102866-910b-0410-8b05-ffd578937521
2010-07-16 10:04:59 +00:00
2010-07-16 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Improve check for mysql library.
minor cleanups git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@29641 72102866-910b-0410-8b05-ffd578937521
2010-02-15 11:52:59 +00:00
2010-02-15 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Just include Foundation.h, fix minor doc errors
* GNUmakefile: Add documentation flag to avoid warning.
Fixup for postgres change git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@29442 72102866-910b-0410-8b05-ffd578937521
2010-01-29 13:36:01 +00:00
2010-01-29 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Fix to cope with a new date format in recent postgres.
Note changes for snow leopard git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@29035 72102866-910b-0410-8b05-ffd578937521
2009-11-18 11:26:22 +00:00
2009-11-18 Richard Frith-Macdonald <rfm@gnu.org>
Many tweaks to build under OSX snow leopard.
Try to get notifications sent properly. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@28895 72102866-910b-0410-8b05-ffd578937521
2009-10-27 12:34:41 +00:00
2009-10-27 Richard Frith-Macdonald <rfm@gnu.org>
* ECPG.pgm:
* MySQL.m:
* Postgres.m:
* Oracle.pm:
* SQLite.m:
* JDBC.m:
Don't call -backendConnect or -backendDisconnect ... should be using
the public API so that notifications are sent properly.
2009-10-01 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: workaround autoconf bug.
* configure: regenerate
2009-09-16 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add convenience method to convert array of rows into an array of
columns.
2009-09-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add method for executing a batch of statements/transactions and
returning any failed statements/transactions to they can be
re-done. Also add methods to manipulate the statements in a
transaction so we can retry things intelligently.
2008-11-12 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add support for tracking the number of consecutive connection failures
and imposing a delay between connection attempts.
* JDBC.m: fix typo
* GNUMmakefile: bump version
2008-07-19 Nicola Pero <nicola.pero@meta-innovation.com>
* configure.ac: Documented the --with-additional-include=,
--with-additional-lib=, --with-postgres-dir= and
--with-jre-architecture= options.
* configure: Regenerated.
* config.h.in: Regenerated.
2008-03-03 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* ECPG.pgm:
* MySQL.m:
* Postgres.m:
* SQLite.m:
* JDBC.m:
Alter to allow control of both the way records are strored and
the way they are listed ... so people can make performance
optimisations.
2008-02-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Experimental new method to set a thread to do all cached
queries on and to perform asynchronous updates if other
threads request information which is in the cache but
past its expiry date. Should allow threads to use
config information from a database without blocking
unnecessarily.
2008-02-15 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix memory leak when executing transaction.
2007-10-23 Richard Frith-Macdonald <rfm@gnu.org>
Postgres.m: Use E'...' syntax for bytea if it is available.
2007-09-14 Richard Frith-Macdonald <rfm@gnu.org>
Update to LGPL3
2007-07-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix retasin bug copying transactions.
* JDBC.m: Update for new batch code
2007-07-09 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Post notifications upon connect and disconnect.
2007-07-07 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix error causing loss of some debug output when an
exception occurs in a transaction.
Rewrite transaction code to support execution with automatic retry of
statements when batching.
* JDBC.m: Update for new transaction code
2007-04-01 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* testSQLite.m:
* testJDBC.m:
* MySQL.m:
* Postgres.m:
* GNUmakefile:
* SQLite.m:
* JDBC.m:
* testMySQL.m:
* testPostgres.m:
* testECPG.m:
Updates to build on MacOS-X with apple-apple-appple
2007-03-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* MySQL.m:
* ECPG.pgm:
* Postgres.m:
* Oracle.pm:
* SQLite.m:
* JDBC.m:
Add KVC support for SQLRecord. Make SQLRecord into a class cluster
with a single concrete implementation for now. Extend API to allow
specifying of an alternative SQLRecord subclass when doing a query
so that query results can be efficiently stored into custom subclasses
rather than having to first be retrieved into an SQLRecord and then
copied.
2007-02-14 Nicola Pero <nicola.pero@meta-innovation.com>
* GNUmakefile (BUNDLE_INSTALL_DIR): Set using GNUSTEP_BUNDLES,
not GNUSTEP_INSTALLATION_DIR.
2007-01-29 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC.m: Add JDBC2.0 batching for when all statements in a
transaction are simple (ie no NSData arguments) and the batch
API is supported by the driver.
* testJDBC.m: Add simple transaction/batch test.
2007-01-29 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC.m: Add support for SQLTransaction class to batch JDBC
operations.
2006-12-24 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC.m: Don't store pointer to jni information in local variable
until after we have opened the connection to the database, or we
may be using a null pointer and generate a crash.
2006-12-22 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: save/restore LIBS after jdbc check so that other
tests don't try to link jre
2006-10-06 Nicola Pero <nicola.pero@meta-innovation.com>
* GNUmakefile.wrapper.objc.preamble (ADDITIONAL_LIB_DIRS): Added
variable so that the wrapper compiles before the library is installed.
2006-10-02 Nicola Pero <nicola.pero@meta-innovation.com>
* configure.ac: Do not read gnustep configuration which is never
used.
* configure.ac: Added --disable-jdbc-bundle,
--disable-mysql-bundle, --disable-sqllite-bundle,
--disable-postgres-bundle flags to be able to turn some bundles
off (regardless of config results).
* configure: Regenerated.
2006-10-01 Graham J Lee <graham.lee@operatelecom.com>
* configure.ac: Fix to use GNUSTEP_CONFIG_FILE environment variable.
2006-09-14 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC push and pop local frames to avoid memory leaks.
2006-08-03 Nicola Pero <nicola.pero@meta-innovation.com>
* SQLClient.m ([SQLClient -quoteString:]): Renamed local variable
that had the same name as the method argument.
2005-06-23 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: transaction efficiency tweak.
* GNUmakefile: bump version to 1.3 as the new blob marker changes and
postgres quoting changes alter behavior.
2005-06-04 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: avoid useless compiler warnings.
2005-05-25 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Check for new postgres string escaping
* configure: Regenerate
* SQLClient.h: Add quoteString method for subclasses to override
* SQLClient.m: Add new method and change marker for blobs to be
one that shouldn't occur in a quoted string.
* SQLite.m: Use new blob marker
* MySQL.m: Use new blob marker
* config.h.in: Add new postgres escaping function
* Postgres.m: Handle new escaping
* testPostgres.m: Add check for escaping odd characters.
2005-02-22 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Support quoting of NSArray and NSSet objects.
2006-01-11 Nicola Pero <nicola@brainstorm.co.uk>
* configure.ac: Do not source GNUSTEP_CONFIG_FILE if it doesn't
exist, so that the library can be used with older versions of
gnustep-make/gnustep-base too. :-)
* configure: Regenerated.
2005-11-23 Richard Frith-Macdonald <rfm@gnu.org>
Added SQLite backend support.
2005-11-14 Richard Frith-Macdonald <rfm@gnu.org>
Factor out WebServer into separate library, and timer and caching
stuff into Performance library. Make this library depend on the
Performance library.
2005-10-27 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Add more accurate timestamps and implement request
and session duration logging. Also add a unique session ID number
to each log to make it easy to track requests on a session.
2005-09-28 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile.wrapper.objc.preamble: new file
* SQLClient.jigs: new file
* GNUmakefile: Provide java wrappings for SQLClient and friends
2005-09-28 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: boost performance of quoting a little.
Provide -count method for transactions.
2005-09-26 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Clean up caching/timestamps.
* SQLClient.m: ditto.
2005-09-22 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Rewrite caching, and expose cache for external use.
* SQLClient.m: ditto.
2005-09-20 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: make SQLRecord modifieable (replace values).
* SQLClient.m: ditto.
2005-09-15 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Locate postgres 8.0 on debian
* configure: regenerate
2005-08-03 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Add SQLClient_LIBRARIES_DEPEND_UPON for apple as
suggested by Yen-Ju Chen.
* SQLClient.m: Don't call allocation debug functions on apple,
and avoid bogus apple compiler warning.
Guard against nil object passed to NSMapRemove() ... the apple
implementation crashes on this.
2005-08-02 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Don't build WebServer stuff on MacOS-X when using the
apple runtime (and presumably foundation).
2005-07-07 Richard Frith-Macdonald <rfm@gnu.org>
* MySQL.m:
* SQLClient.m:
* WebServer.h:
* WebServer.m:
Tweaks to keep gcc-4 happy (signedness issues) and add support for
using separate ssl conmfig for different IP addresses.
2005-06-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Expand tilde in paths searched for backend bundles.
2005-05-25 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Clear connection if an exception occurs while
disconnecting ... otherwise a failed disconnect can prevent
any new connection from being established.
Improve quoting of strings to be a bit more efficient and to
remove nul characters.
2005-05-09 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add method to encode a form from a dictionary
into a data object ... convenience for where form data is needed.
2005-03-02 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add support for basic http authentication either
via username/password pairs in property list or in database table.
* SQLClient.[hm]: Add methods to query database with local caching
of results, for use on systems needing high performance, where
database query (and/or database client-server comms) overheads are
important.
2005-02-25 Adam Fedor <fedor@gnu.org>
* Version 1.1.0:
* GNUmakefile: Add version.
* README: Add ftp location.
Sat Feb 19 04:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* Makefile: Build two versions of each bundle with different library
linkage for systems where dybnamic linker symbol visibility differs.
* SQLClient.m: Try alternative bundle versions.
Mon Jan 07 15:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* Makefile: Bump version.
* SQLClient.h: Improve documentation.
Sat Dec 18 06:00:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Fix bug in substitution of nil values into templates.
Add new method to vend static pages.
Wed Dec 15 13:10:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* MySQL.m, Postgres.m, ECPG.pgm: Do NSLog() logging of field
information only when debug level is greater than 1.
Fri Dec 10 10:50:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Remove unnecessary libraries from link commands for
bundles. On Darwin, specifying these leads to multiply defined
symbols when an executable attempts to load the bundle.
Fri Nov 19 14:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: parse basic authentication infor and set it in extra
headers in request.
* WebServerBundles.m: support handling of paths longer than the
ones set for each bundle.
Tue Nov 11 14:48:05 2004 Nicola Pero <n.pero@mi.flashnet.it>
* GNUmakefile (BUNDLE_INSTALL_DIR): install bundles in
GNUSTEP_INSTALLATION_DIR, not GNUSTEP_LOCAL_ROOT.
Tue Nov 09 10:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.hm: add ([-append:]) method to merge transactions.
Thu Oct 28 08:45:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Don't generate alert about connection with empty
request if we have lready handled a request and reset.
Tue Oct 26 16:50:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: debug and duration logging should be turned off
by default ... a different value crept in somehow.
Sat Oct 9 14:29:35 2004 Nicola Pero <n.pero@mi.flashnet.it>
* SQLClient.m ([SQLClient -simpleExecute:]): Fixed logging
durations and statements in transactions.
Thu Oct 08 10:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Add ([-quotef:,...]) to perform efficient quoting
of a string produced using printf style format and arguments.
Thu Oct 07 10:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Optimise timing operations somewhat.
Wed Oct 06 15:04:23 2004 Nicola Pero <n.pero@mi.flashnet.it>
* WebServer.h: Fixed typo in parameter name.
Wed Oct 06 13:10:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Allow a database transaction to already have been
begun when [SQLTransactiuon-execute] is called, so we can have
queries in the same database transaction as a list of statements.
Wed Oct 06 06:15:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Make the rollback opoeration a safe no-op if
there is no transaction in progress.
* Postgres.m: Improve exception text by reporting the offending
SQL statement(s).
Fri Sep 17 16:55:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: When reporting the duration of a commit or
rollback, report text of all the statements in the transaction.
Fri Aug 28 09:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add support for limiting maximum number of incoming
sessions permitted from mone host.
Tue Aug 24 14:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add support for HTTP/1.1 persistent connections.
Sun Aug 22 10:35:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Add ([SQLRecord-dictionary]) and tidy/comment the
class a bit better.
Sat Aug 07 14:25:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Add session timeouts to kill off idle sessions.
Tue Jul 27 17:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Give more help when postgres is not found.
* configure: regenerate
Mon Jul 26 09:50:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add -transaction method and SQLTransaction class
* SQLClient.m: Implement -transaction method and SQLTransaction class
to provide a simple convenient mechanism for executing a sequence
of statements as a single transaction.
Thu Jul 15 09:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: ([_didRead:]) more informative logging upon reading
an unexpected end-of-file
Wed Jul 14 12:07:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Check for PQfformat in libpq, if it is not there
but the library is there, warn that it is too old.
Thu Jul 02 17:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Add control over character encoding used to
interpret form data.
Thu Jul 02 13:25:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Fix error response when an exception occurs.
Thu Jul 01 18:00:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Make ([setPort:secure:]) return a status.
* WebServerBundles.m: Check that web server is able to start.
* WebServer.h: ditto
Wed Jun 30 05:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Use ./obj as location for library to link,
for initial case where we link the bundles before installing
the library.
* WebServer.m: Add casts to prevent compiler warning.
* Postgres.m: Commented out NSLog() left over from debugging.
Tue Jun 29 18:10:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix code for retrieving reference name ... look in
the config dictionary first, and in user defaults if not found
there.
* SQLClient.h: Document change.
* GNUmakefile: Link bundles with the library to ensure that they
find the SQLRecord class when loaded.
Mon Jun 28 12:55:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.h: New file.
* WebServer.m: New file.
* WebServerBundles.m: New file.
* SQLClient.h: Mention WebServer.
* GNUmakefile: Build WebServer classes.
Added framework to make it easy to use SQLClient to produce
standalone http/https applications, such as accepting POST'ed
records for addition to a database.
Fri May 07 09:15:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
Add methods to log duration of any statements over a certain
limit.
Tidy instance variables ... prefix mprivate ones with underscore.
Install header!
Thu Apr 29 15:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Fix URLs in documentation as suggested by Adam.
* SQLClient.html: regenerate
Mon Apr 26 16:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
Initial checkin of library.
workaround autoconf bug git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@28763 72102866-910b-0410-8b05-ffd578937521
2009-10-02 18:34:28 +00:00
2009-10-01 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: workaround autoconf bug.
* configure: regenerate
add convenience method git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@28691 72102866-910b-0410-8b05-ffd578937521
2009-09-16 08:59:59 +00:00
2009-09-16 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add convenience method to convert array of rows into an array of
columns.
Transaction manipulation methods added. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@28628 72102866-910b-0410-8b05-ffd578937521
2009-09-08 08:05:31 +00:00
2009-09-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add method for executing a batch of statements/transactions and
returning any failed statements/transactions to they can be
re-done. Also add methods to manipulate the statements in a
transaction so we can retry things intelligently.
Add mechanism to avoid overloading database server when it's restarting. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@27024 72102866-910b-0410-8b05-ffd578937521
2008-11-12 05:52:38 +00:00
2008-11-12 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Add support for tracking the number of consecutive connection failures
and imposing a delay between connection attempts.
Changes for new version git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@27025 72102866-910b-0410-8b05-ffd578937521
2008-11-12 06:09:44 +00:00
* JDBC.m: fix typo
* GNUMmakefile: bump version
Add mechanism to avoid overloading database server when it's restarting. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@27024 72102866-910b-0410-8b05-ffd578937521
2008-11-12 05:52:38 +00:00
SQLClient: documented better some configure options, then regenerated configure and config.h.in git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@26794 72102866-910b-0410-8b05-ffd578937521
2008-07-19 13:40:51 +00:00
2008-07-19 Nicola Pero <nicola.pero@meta-innovation.com>
* configure.ac: Documented the --with-additional-include=,
--with-additional-lib=, --with-postgres-dir= and
--with-jre-architecture= options.
* configure: Regenerated.
* config.h.in: Regenerated.
Add options to permit performance optimisation. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@26183 72102866-910b-0410-8b05-ffd578937521
2008-03-03 14:10:54 +00:00
2008-03-03 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* ECPG.pgm:
* MySQL.m:
* Postgres.m:
* SQLite.m:
* JDBC.m:
Alter to allow control of both the way records are strored and
the way they are listed ... so people can make performance
optimisations.
Add mechanism to update cache only in main thread. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@26117 72102866-910b-0410-8b05-ffd578937521
2008-02-21 16:23:23 +00:00
2008-02-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
Experimental new method to set a thread to do all cached
queries on and to perform asynchronous updates if other
threads request information which is in the cache but
past its expiry date. Should allow threads to use
config information from a database without blocking
unnecessarily.
Fix memory leak git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@26070 72102866-910b-0410-8b05-ffd578937521
2008-02-15 06:52:53 +00:00
2008-02-15 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix memory leak when executing transaction.
Update bytea escaping for postgres-8.3 and beyond. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25531 72102866-910b-0410-8b05-ffd578937521
2007-10-23 09:27:08 +00:00
2007-10-23 Richard Frith-Macdonald <rfm@gnu.org>
Postgres.m: Use E'...' syntax for bytea if it is available.
Update to LGPL3 git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25490 72102866-910b-0410-8b05-ffd578937521
2007-09-14 13:02:05 +00:00
2007-09-14 Richard Frith-Macdonald <rfm@gnu.org>
Update to LGPL3
Fix retain/release error when copying transactions git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25344 72102866-910b-0410-8b05-ffd578937521
2007-07-21 05:33:10 +00:00
2007-07-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix retasin bug copying transactions.
* JDBC.m: Update for new batch code
Post notifications on connect and disconnect. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25309 72102866-910b-0410-8b05-ffd578937521
2007-07-09 17:08:22 +00:00
2007-07-09 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Post notifications upon connect and disconnect.
debug logging fix. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25306 72102866-910b-0410-8b05-ffd578937521
2007-07-07 07:23:40 +00:00
2007-07-07 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix error causing loss of some debug output when an
exception occurs in a transaction.
Post notifications on connect and disconnect. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25309 72102866-910b-0410-8b05-ffd578937521
2007-07-09 17:08:22 +00:00
Rewrite transaction code to support execution with automatic retry of
statements when batching.
* JDBC.m: Update for new transaction code
debug logging fix. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@25306 72102866-910b-0410-8b05-ffd578937521
2007-07-07 07:23:40 +00:00
update to build with apple-apple-apple git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24959 72102866-910b-0410-8b05-ffd578937521
2007-04-01 08:03:21 +00:00
2007-04-01 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* testSQLite.m:
* testJDBC.m:
* MySQL.m:
* Postgres.m:
* GNUmakefile:
* SQLite.m:
* JDBC.m:
* testMySQL.m:
* testPostgres.m:
* testECPG.m:
Updates to build on MacOS-X with apple-apple-appple
SQLRecord enhancements for KVC and for performance optimisations. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24827 72102866-910b-0410-8b05-ffd578937521
2007-03-08 17:12:55 +00:00
2007-03-08 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h:
* SQLClient.m:
* MySQL.m:
* ECPG.pgm:
* Postgres.m:
* Oracle.pm:
* SQLite.m:
* JDBC.m:
Add KVC support for SQLRecord. Make SQLRecord into a class cluster
with a single concrete implementation for now. Extend API to allow
specifying of an alternative SQLRecord subclass when doing a query
so that query results can be efficiently stored into custom subclasses
rather than having to first be retrieved into an SQLRecord and then
copied.
Do not use GNUSTEP_INSTALLATION_DIR git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24553 72102866-910b-0410-8b05-ffd578937521
2007-02-14 12:28:32 +00:00
2007-02-14 Nicola Pero <nicola.pero@meta-innovation.com>
* GNUmakefile (BUNDLE_INSTALL_DIR): Set using GNUSTEP_BUNDLES,
not GNUSTEP_INSTALLATION_DIR.
Add simple JDBC batching if available git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24429 72102866-910b-0410-8b05-ffd578937521
2007-01-29 19:40:08 +00:00
2007-01-29 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC.m: Add JDBC2.0 batching for when all statements in a
transaction are simple (ie no NSData arguments) and the batch
API is supported by the driver.
* testJDBC.m: Add simple transaction/batch test.
Add JDBC transaction/batching git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24427 72102866-910b-0410-8b05-ffd578937521
2007-01-29 13:51:39 +00:00
2007-01-29 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC.m: Add support for SQLTransaction class to batch JDBC
operations.
Bugfix for occasional crash executing query. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24231 72102866-910b-0410-8b05-ffd578937521
2006-12-24 08:45:43 +00:00
2006-12-24 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC.m: Don't store pointer to jni information in local variable
until after we have opened the connection to the database, or we
may be using a null pointer and generate a crash.
Automcnf fixup git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@24222 72102866-910b-0410-8b05-ffd578937521
2006-12-22 13:01:29 +00:00
2006-12-22 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: save/restore LIBS after jdbc check so that other
tests don't try to link jre
Fixed compiling the wrapper before the library is installed git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23773 72102866-910b-0410-8b05-ffd578937521
2006-10-06 07:49:59 +00:00
2006-10-06 Nicola Pero <nicola.pero@meta-innovation.com>
* GNUmakefile.wrapper.objc.preamble (ADDITIONAL_LIB_DIRS): Added
variable so that the wrapper compiles before the library is installed.
2006-10-02 Nicola Pero <nicola.pero@meta-innovation.com>
Do not read gnustep config info which is not used; added a few useful configure flags that I felt were missing git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23727 72102866-910b-0410-8b05-ffd578937521
2006-10-02 17:30:40 +00:00
* configure.ac: Do not read gnustep configuration which is never
used.
* configure.ac: Added --disable-jdbc-bundle,
--disable-mysql-bundle, --disable-sqllite-bundle,
--disable-postgres-bundle flags to be able to turn some bundles
off (regardless of config results).
* configure: Regenerated.
Add patch to use config file environment variable git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23716 72102866-910b-0410-8b05-ffd578937521
2006-10-02 14:36:53 +00:00
2006-10-01 Graham J Lee <graham.lee@operatelecom.com>
* configure.ac: Fix to use GNUSTEP_CONFIG_FILE environment variable.
Memory leak fixes git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23508 72102866-910b-0410-8b05-ffd578937521
2006-09-14 15:40:14 +00:00
2006-09-14 Richard Frith-Macdonald <rfm@gnu.org>
* JDBC push and pop local frames to avoid memory leaks.
Fixed local variable name that had the same name as method argument - confusing git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23198 72102866-910b-0410-8b05-ffd578937521
2006-08-03 00:14:22 +00:00
2006-08-03 Nicola Pero <nicola.pero@meta-innovation.com>
* SQLClient.m ([SQLClient -quoteString:]): Renamed local variable
that had the same name as the method argument.
New release for postgres and blob handling updates git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23101 72102866-910b-0410-8b05-ffd578937521
2006-06-23 19:45:59 +00:00
2005-06-23 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: transaction efficiency tweak.
* GNUmakefile: bump version to 1.3 as the new blob marker changes and
postgres quoting changes alter behavior.
Avoid compiler warnings. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@23028 72102866-910b-0410-8b05-ffd578937521
2006-06-04 09:19:28 +00:00
2005-06-04 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: avoid useless compiler warnings.
Updates for string literal escaping in postgres 8.1.4 and later. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@22982 72102866-910b-0410-8b05-ffd578937521
2006-05-25 11:34:03 +00:00
2005-05-25 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Check for new postgres string escaping
* configure: Regenerate
* SQLClient.h: Add quoteString method for subclasses to override
* SQLClient.m: Add new method and change marker for blobs to be
one that shouldn't occur in a quoted string.
* SQLite.m: Use new blob marker
* MySQL.m: Use new blob marker
* config.h.in: Add new postgres escaping function
* Postgres.m: Handle new escaping
* testPostgres.m: Add check for escaping odd characters.
Support quoting of NSArray and NSSet objects git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@22542 72102866-910b-0410-8b05-ffd578937521
2006-02-22 11:15:16 +00:00
2005-02-22 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Support quoting of NSArray and NSSet objects.
Small changes for backwards compatibility with older gnustep-make/base git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@22296 72102866-910b-0410-8b05-ffd578937521
2006-01-11 14:27:36 +00:00
2006-01-11 Nicola Pero <nicola@brainstorm.co.uk>
* configure.ac: Do not source GNUSTEP_CONFIG_FILE if it doesn't
exist, so that the library can be used with older versions of
gnustep-make/gnustep-base too. :-)
* configure: Regenerated.
Added SQLite git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@22085 72102866-910b-0410-8b05-ffd578937521
2005-11-23 10:02:46 +00:00
2005-11-23 Richard Frith-Macdonald <rfm@gnu.org>
Added SQLite backend support.
Simplify library ... move portions into WebServer and Performance libraries git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@22006 72102866-910b-0410-8b05-ffd578937521
2005-11-14 20:37:33 +00:00
2005-11-14 Richard Frith-Macdonald <rfm@gnu.org>
Factor out WebServer into separate library, and timer and caching
stuff into Performance library. Make this library depend on the
Performance library.
Add logging useful for measuring performance. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21890 72102866-910b-0410-8b05-ffd578937521
2005-10-27 16:18:45 +00:00
2005-10-27 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Add more accurate timestamps and implement request
and session duration logging. Also add a unique session ID number
to each log to make it easy to track requests on a session.
Add java wrappings git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21774 72102866-910b-0410-8b05-ffd578937521
2005-10-05 10:15:50 +00:00
2005-09-28 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile.wrapper.objc.preamble: new file
* SQLClient.jigs: new file
* GNUmakefile: Provide java wrappings for SQLClient and friends
Minor performance tweak git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21751 72102866-910b-0410-8b05-ffd578937521
2005-09-28 06:20:43 +00:00
2005-09-28 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: boost performance of quoting a little.
Add -count for transaction git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21752 72102866-910b-0410-8b05-ffd578937521
2005-09-28 06:35:03 +00:00
Provide -count method for transactions.
Minor performance tweak git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21751 72102866-910b-0410-8b05-ffd578937521
2005-09-28 06:20:43 +00:00
Some cleanup git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21746 72102866-910b-0410-8b05-ffd578937521
2005-09-26 11:22:35 +00:00
2005-09-26 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Clean up caching/timestamps.
* SQLClient.m: ditto.
Improve caching git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21734 72102866-910b-0410-8b05-ffd578937521
2005-09-22 08:42:37 +00:00
2005-09-22 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Rewrite caching, and expose cache for external use.
* SQLClient.m: ditto.
Allow changing of values in an SQLRecord git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21731 72102866-910b-0410-8b05-ffd578937521
2005-09-20 12:57:48 +00:00
2005-09-20 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: make SQLRecord modifieable (replace values).
* SQLClient.m: ditto.
Improve code to locate postgres headers git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21719 72102866-910b-0410-8b05-ffd578937521
2005-09-15 08:25:12 +00:00
2005-09-15 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Locate postgres 8.0 on debian
* configure: regenerate
More apple fixups. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21604 72102866-910b-0410-8b05-ffd578937521
2005-08-03 05:39:29 +00:00
2005-08-03 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Add SQLClient_LIBRARIES_DEPEND_UPON for apple as
suggested by Yen-Ju Chen.
* SQLClient.m: Don't call allocation debug functions on apple,
and avoid bogus apple compiler warning.
Fix problem with NSMapRemove() on Apple git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21605 72102866-910b-0410-8b05-ffd578937521
2005-08-03 07:03:28 +00:00
Guard against nil object passed to NSMapRemove() ... the apple
implementation crashes on this.
More apple fixups. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21604 72102866-910b-0410-8b05-ffd578937521
2005-08-03 05:39:29 +00:00
Improve portability for MacOSX git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21596 72102866-910b-0410-8b05-ffd578937521
2005-08-02 10:42:42 +00:00
2005-08-02 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Don't build WebServer stuff on MacOS-X when using the
apple runtime (and presumably foundation).
Various tweaks git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21421 72102866-910b-0410-8b05-ffd578937521
2005-07-07 21:11:04 +00:00
2005-07-07 Richard Frith-Macdonald <rfm@gnu.org>
* MySQL.m:
* SQLClient.m:
* WebServer.h:
* WebServer.m:
Tweaks to keep gcc-4 happy (signedness issues) and add support for
using separate ssl conmfig for different IP addresses.
Expand tildes in paths git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21338 72102866-910b-0410-8b05-ffd578937521
2005-06-21 13:10:55 +00:00
2005-06-21 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Expand tilde in paths searched for backend bundles.
Bugfix for cases where an exception occurs during a disconnect. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21255 72102866-910b-0410-8b05-ffd578937521
2005-05-25 07:57:04 +00:00
2005-05-25 Richard Frith-Macdonald <rfm@gnu.org>
* Postgres.m: Clear connection if an exception occurs while
disconnecting ... otherwise a failed disconnect can prevent
any new connection from being established.
Improve string quoting git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21258 72102866-910b-0410-8b05-ffd578937521
2005-05-25 14:06:19 +00:00
Improve quoting of strings to be a bit more efficient and to
remove nul characters.
Bugfix for cases where an exception occurs during a disconnect. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21255 72102866-910b-0410-8b05-ffd578937521
2005-05-25 07:57:04 +00:00
Add convenience method to encode a form, as a counterpart to the existing method to decode a form. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@21207 72102866-910b-0410-8b05-ffd578937521
2005-05-09 15:35:46 +00:00
2005-05-09 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add method to encode a form from a dictionary
into a data object ... convenience for where form data is needed.
experimental updates for performance and security git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20826 72102866-910b-0410-8b05-ffd578937521
2005-03-02 10:00:24 +00:00
2005-03-02 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add support for basic http authentication either
via username/password pairs in property list or in database table.
* SQLClient.[hm]: Add methods to query database with local caching
of results, for use on systems needing high performance, where
database query (and/or database client-server comms) overheads are
important.
* Version 1.1.0: * GNUmakefile: Add version. * README: Add ftp location. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20795 72102866-910b-0410-8b05-ffd578937521
2005-02-25 18:08:22 +00:00
2005-02-25 Adam Fedor <fedor@gnu.org>
* Version 1.1.0:
* GNUmakefile: Add version.
* README: Add ftp location.
Nasty hacks for system specific linkage problems git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20746 72102866-910b-0410-8b05-ffd578937521
2005-02-19 04:20:13 +00:00
Sat Feb 19 04:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* Makefile: Build two versions of each bundle with different library
linkage for systems where dybnamic linker symbol visibility differs.
* SQLClient.m: Try alternative bundle versions.
Move to version 1.1 git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20667 72102866-910b-0410-8b05-ffd578937521
2005-02-07 15:20:02 +00:00
Mon Jan 07 15:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* Makefile: Bump version.
* SQLClient.h: Improve documentation.
Add method for vending static pages. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20468 72102866-910b-0410-8b05-ffd578937521
2004-12-19 06:15:55 +00:00
Sat Dec 18 06:00:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Fix bug in substitution of nil values into templates.
Add new method to vend static pages.
Fix excessive logging. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20459 72102866-910b-0410-8b05-ffd578937521
2004-12-15 13:14:38 +00:00
Wed Dec 15 13:10:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* MySQL.m, Postgres.m, ECPG.pgm: Do NSLog() logging of field
information only when debug level is greater than 1.
Fix to get bundles to load on darwin git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20434 72102866-910b-0410-8b05-ffd578937521
2004-12-10 10:50:35 +00:00
Fri Dec 10 10:50:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Remove unnecessary libraries from link commands for
bundles. On Darwin, specifying these leads to multiply defined
symbols when an executable attempts to load the bundle.
Various minor improvements in handling incoming requests. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20362 72102866-910b-0410-8b05-ffd578937521
2004-11-19 14:46:42 +00:00
Fri Nov 19 14:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: parse basic authentication infor and set it in extra
headers in request.
* WebServerBundles.m: support handling of paths longer than the
ones set for each bundle.
Fix instlalation dir git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20354 72102866-910b-0410-8b05-ffd578937521
2004-11-16 14:55:17 +00:00
Tue Nov 11 14:48:05 2004 Nicola Pero <n.pero@mi.flashnet.it>
* GNUmakefile (BUNDLE_INSTALL_DIR): install bundles in
GNUSTEP_INSTALLATION_DIR, not GNUSTEP_LOCAL_ROOT.
Added missing changelog entry git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20320 72102866-910b-0410-8b05-ffd578937521
2004-11-09 10:26:05 +00:00
Tue Nov 09 10:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.hm: add ([-append:]) method to merge transactions.
Improve logging/alerting git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20265 72102866-910b-0410-8b05-ffd578937521
2004-10-28 07:50:46 +00:00
Thu Oct 28 08:45:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Don't generate alert about connection with empty
request if we have lready handled a request and reset.
Turn off logging by default. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20259 72102866-910b-0410-8b05-ffd578937521
2004-10-26 15:54:29 +00:00
Tue Oct 26 16:50:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: debug and duration logging should be turned off
by default ... a different value crept in somehow.
Fixed logging transaction duration and statements git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20213 72102866-910b-0410-8b05-ffd578937521
2004-10-09 12:39:36 +00:00
Sat Oct 9 14:29:35 2004 Nicola Pero <n.pero@mi.flashnet.it>
* SQLClient.m ([SQLClient -simpleExecute:]): Fixed logging
durations and statements in transactions.
Added quotef:,... git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20208 72102866-910b-0410-8b05-ffd578937521
2004-10-08 09:29:00 +00:00
Thu Oct 08 10:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Add ([-quotef:,...]) to perform efficient quoting
of a string produced using printf style format and arguments.
Minor optimisations git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20204 72102866-910b-0410-8b05-ffd578937521
2004-10-07 09:30:14 +00:00
Thu Oct 07 10:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Optimise timing operations somewhat.
Fixed insignificantly tiny typo in parameter name git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20201 72102866-910b-0410-8b05-ffd578937521
2004-10-06 14:02:38 +00:00
Wed Oct 06 15:04:23 2004 Nicola Pero <n.pero@mi.flashnet.it>
* WebServer.h: Fixed typo in parameter name.
Improve transaction handling git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20200 72102866-910b-0410-8b05-ffd578937521
2004-10-06 12:10:01 +00:00
Wed Oct 06 13:10:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Allow a database transaction to already have been
begun when [SQLTransactiuon-execute] is called, so we can have
queries in the same database transaction as a list of statements.
Minor tweaks. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20199 72102866-910b-0410-8b05-ffd578937521
2004-10-06 05:21:09 +00:00
Wed Oct 06 06:15:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Make the rollback opoeration a safe no-op if
there is no transaction in progress.
* Postgres.m: Improve exception text by reporting the offending
SQL statement(s).
Improve debugging git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@20078 72102866-910b-0410-8b05-ffd578937521
2004-09-17 14:54:56 +00:00
Fri Sep 17 16:55:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: When reporting the duration of a commit or
rollback, report text of all the statements in the transaction.
Limit maximum incoming connections from any one host. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19929 72102866-910b-0410-8b05-ffd578937521
2004-08-27 08:35:34 +00:00
Fri Aug 28 09:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add support for limiting maximum number of incoming
sessions permitted from mone host.
Support persistent connections for bbetter performance git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19913 72102866-910b-0410-8b05-ffd578937521
2004-08-24 13:28:10 +00:00
Tue Aug 24 14:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.[hm]: Add support for HTTP/1.1 persistent connections.
New method to convert SQLRecord to a dictionary. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19900 72102866-910b-0410-8b05-ffd578937521
2004-08-22 09:34:18 +00:00
Sun Aug 22 10:35:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.[hm]: Add ([SQLRecord-dictionary]) and tidy/comment the
class a bit better.
Add session timeouts. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19835 72102866-910b-0410-8b05-ffd578937521
2004-08-07 13:25:19 +00:00
Sat Aug 07 14:25:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Add session timeouts to kill off idle sessions.
Minor ease of use improvement git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19781 72102866-910b-0410-8b05-ffd578937521
2004-07-27 16:32:02 +00:00
Tue Jul 27 17:30:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Give more help when postgres is not found.
* configure: regenerate
Add SQLTransaction to perform easy, efficient combining of multiple statements into a single transaction. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19775 72102866-910b-0410-8b05-ffd578937521
2004-07-26 08:56:26 +00:00
Mon Jul 26 09:50:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Add -transaction method and SQLTransaction class
* SQLClient.m: Implement -transaction method and SQLTransaction class
to provide a simple convenient mechanism for executing a sequence
of statements as a single transaction.
Thu Jul 15 09:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
Improve logging. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19738 72102866-910b-0410-8b05-ffd578937521
2004-07-15 08:39:07 +00:00
* WebServer.m: ([_didRead:]) more informative logging upon reading
an unexpected end-of-file
Check for PQfformat git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19733 72102866-910b-0410-8b05-ffd578937521
2004-07-14 11:06:39 +00:00
Wed Jul 14 12:07:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* configure.ac: Check for PQfformat in libpq, if it is not there
but the library is there, warn that it is too old.
Add more control over encoding of string values from form. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19673 72102866-910b-0410-8b05-ffd578937521
2004-07-03 09:03:12 +00:00
Thu Jul 02 17:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Add control over character encoding used to
interpret form data.
Minor fix for handling exceptions while processing request git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19670 72102866-910b-0410-8b05-ffd578937521
2004-07-02 12:22:28 +00:00
Thu Jul 02 13:25:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Fix error response when an exception occurs.
Some tests for successful startup. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19664 72102866-910b-0410-8b05-ffd578937521
2004-07-01 16:58:22 +00:00
Thu Jul 01 18:00:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.m: Make ([setPort:secure:]) return a status.
* WebServerBundles.m: Check that web server is able to start.
* WebServer.h: ditto
Fix for initial build git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19653 72102866-910b-0410-8b05-ffd578937521
2004-06-30 04:41:07 +00:00
Wed Jun 30 05:40:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* GNUmakefile: Use ./obj as location for library to link,
for initial case where we link the bundles before installing
the library.
Minor tidyup git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19654 72102866-910b-0410-8b05-ffd578937521
2004-06-30 04:43:38 +00:00
* WebServer.m: Add casts to prevent compiler warning.
Comment out log line git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19657 72102866-910b-0410-8b05-ffd578937521
2004-06-30 09:44:35 +00:00
* Postgres.m: Commented out NSLog() left over from debugging.
Fix for initial build git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19653 72102866-910b-0410-8b05-ffd578937521
2004-06-30 04:41:07 +00:00
Minor bugfixes. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19652 72102866-910b-0410-8b05-ffd578937521
2004-06-29 17:11:10 +00:00
Tue Jun 29 18:10:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.m: Fix code for retrieving reference name ... look in
the config dictionary first, and in user defaults if not found
there.
* SQLClient.h: Document change.
* GNUmakefile: Link bundles with the library to ensure that they
find the SQLRecord class when loaded.
Add framework for standalone web server. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19637 72102866-910b-0410-8b05-ffd578937521
2004-06-28 11:55:09 +00:00
Mon Jun 28 12:55:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* WebServer.h: New file.
* WebServer.m: New file.
* WebServerBundles.m: New file.
* SQLClient.h: Mention WebServer.
* GNUmakefile: Build WebServer classes.
Added framework to make it easy to use SQLClient to produce
standalone http/https applications, such as accepting POST'ed
records for addition to a database.
Tidied and added some logging capability git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19252 72102866-910b-0410-8b05-ffd578937521
2004-05-07 08:16:16 +00:00
Fri May 07 09:15:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
Add methods to log duration of any statements over a certain
limit.
Tidy instance variables ... prefix mprivate ones with underscore.
Install header ... document it. git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19254 72102866-910b-0410-8b05-ffd578937521
2004-05-07 09:34:10 +00:00
Install header!
Tidied and added some logging capability git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19252 72102866-910b-0410-8b05-ffd578937521
2004-05-07 08:16:16 +00:00
Fix URLs git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19212 72102866-910b-0410-8b05-ffd578937521
2004-04-29 14:19:51 +00:00
Thu Apr 29 15:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
* SQLClient.h: Fix URLs in documentation as suggested by Adam.
* SQLClient.html: regenerate
Finish initial checkin git-svn-id: svn+ssh://svn.gna.org/svn/gnustep/libs/sqlclient/trunk@19195 72102866-910b-0410-8b05-ffd578937521
2004-04-26 15:20:46 +00:00
Mon Apr 26 16:20:00 2004 Richard Frith-Macdonald <rfm@gnu.org>
Initial checkin of library.
Reference in a new issue Copy permalink