]> source.dussan.org Git - iciql.git/log
iciql.git
11 years agoFix encodings on some source files and confirm by compiling as UTF-8
James Moger [Tue, 22 Jan 2013 13:00:30 +0000 (08:00 -0500)]
Fix encodings on some source files and confirm by compiling as UTF-8

11 years agoPreliminary MSSQL dialect
Alex Telepov [Mon, 31 Dec 2012 14:42:20 +0000 (09:42 -0500)]
Preliminary MSSQL dialect

11 years agoAllows to gain full control of transactions
bartolomiew [Sun, 28 Oct 2012 07:41:27 +0000 (08:41 +0100)]
Allows to gain full control of transactions

11 years agoreturn SQL error code even if uncharacterized
bartolomiew [Sat, 27 Oct 2012 17:31:00 +0000 (19:31 +0200)]
return SQL error code even if uncharacterized

12 years agoAdded drop reference table test (fails on H2)
James Moger [Mon, 15 Oct 2012 16:17:02 +0000 (12:17 -0400)]
Added drop reference table test (fails on H2)

Unfortunately, it looks like H2 1.3.168 has a bug which allows you to
drop a table even though there are active constraints referencing it.
HSQL, Derby, MySQL, and PostgreSQL all throw a constraint violation
exception, as expected, but H2 does not.

12 years agoCleanup tables after test
James Moger [Mon, 15 Oct 2012 14:56:27 +0000 (10:56 -0400)]
Cleanup tables after test

12 years agoFix name collissions on indexes, unique keys, and foreign keys
James Moger [Mon, 15 Oct 2012 14:55:47 +0000 (10:55 -0400)]
Fix name collissions on indexes, unique keys, and foreign keys

12 years agoEliminate redundant methods
James Moger [Mon, 15 Oct 2012 14:50:32 +0000 (10:50 -0400)]
Eliminate redundant methods

12 years agoFixed create view exception in MySQL
James Moger [Mon, 15 Oct 2012 14:44:14 +0000 (10:44 -0400)]
Fixed create view exception in MySQL

12 years agoCleanup stray tables & views for each test
James Moger [Mon, 15 Oct 2012 14:40:25 +0000 (10:40 -0400)]
Cleanup stray tables & views for each test

12 years agoSpelling correction
James Moger [Mon, 15 Oct 2012 14:39:28 +0000 (10:39 -0400)]
Spelling correction

12 years agoadd foreign key constraint annotation 3/head
bartolomiew [Fri, 12 Oct 2012 15:25:40 +0000 (17:25 +0200)]
add foreign key constraint annotation
add unique constraint annotation
fix small bug in build.xml for java source destination

12 years agoFixed case-sensitivity bug on setting a compound primary key from an annotation ...
James Moger [Thu, 27 Sep 2012 20:34:30 +0000 (16:34 -0400)]
Fixed case-sensitivity bug on setting a compound primary key from an annotation (issue 12)

12 years agoSupport for read-only views (issue 8)
James Moger [Tue, 25 Sep 2012 22:05:13 +0000 (18:05 -0400)]
Support for read-only views (issue 8)

12 years agoEnsure that field definition of current class is used instead of identical field...
James Moger [Tue, 25 Sep 2012 13:43:18 +0000 (09:43 -0400)]
Ensure that field definition of current class is used instead of identical field in parent class

12 years agoSupport inheritance of IQVersion for DbUpgrader implementations (issue 10)
James Moger [Fri, 21 Sep 2012 12:18:25 +0000 (08:18 -0400)]
Support inheritance of IQVersion for DbUpgrader implementations (issue 10)

12 years agoFixed order of DEFAULT in create table statement (issue 11)
James Moger [Fri, 21 Sep 2012 11:59:04 +0000 (07:59 -0400)]
Fixed order of DEFAULT in create table statement (issue 11)

12 years agoDocumentation
James Moger [Tue, 18 Sep 2012 12:23:02 +0000 (08:23 -0400)]
Documentation

12 years agoFixed password bug in model generator tool (issue 7)
James Moger [Tue, 18 Sep 2012 12:22:50 +0000 (08:22 -0400)]
Fixed password bug in model generator tool (issue 7)

12 years agoReset build identifiers for next release
James Moger [Mon, 20 Aug 2012 14:18:06 +0000 (10:18 -0400)]
Reset build identifiers for next release

12 years agoPrepare 1.1.0 release v1.1.0
James Moger [Mon, 20 Aug 2012 14:16:31 +0000 (10:16 -0400)]
Prepare 1.1.0 release

12 years agoUpdated unit-tested databases
James Moger [Mon, 20 Aug 2012 14:11:08 +0000 (10:11 -0400)]
Updated unit-tested databases

12 years agoUse savepoints for all bulk ops (insert all, update all, delete all)
James Moger [Mon, 20 Aug 2012 13:59:00 +0000 (09:59 -0400)]
Use savepoints for all bulk ops (insert all, update all, delete all)

12 years agoReset build identifiers for next release
James Moger [Sat, 14 Jul 2012 22:17:45 +0000 (18:17 -0400)]
Reset build identifiers for next release

12 years agoPrepare 1.0.0 release v1.0.0
James Moger [Sat, 14 Jul 2012 22:17:07 +0000 (18:17 -0400)]
Prepare 1.0.0 release

12 years agoFixed unit test for MySQL wrt IN queries
James Moger [Sat, 14 Jul 2012 21:41:48 +0000 (17:41 -0400)]
Fixed unit test for MySQL wrt IN queries

12 years agoDocumentation
James Moger [Sat, 14 Jul 2012 20:18:54 +0000 (16:18 -0400)]
Documentation

12 years agoUse the upgrade check to skip unnecessary table create statements
James Moger [Sat, 14 Jul 2012 20:09:52 +0000 (16:09 -0400)]
Use the upgrade check to skip unnecessary table create statements

12 years agoRestored build properties with an is available check
James Moger [Tue, 19 Jun 2012 01:47:48 +0000 (21:47 -0400)]
Restored build properties with an is available check

12 years agoFix to Issue 5. 2/head
kc5nra [Mon, 18 Jun 2012 23:32:44 +0000 (18:32 -0500)]
Fix to Issue 5.

http://code.google.com/p/iciql/issues/detail?id=5

12 years agoDraft support for "where xxx in(select bbb from...)"
James Moger [Mon, 7 May 2012 17:46:59 +0000 (13:46 -0400)]
Draft support for "where xxx in(select bbb from...)"

12 years agoMerge pull request #1 from backpaper0/master
James Moger [Mon, 9 Apr 2012 12:52:20 +0000 (05:52 -0700)]
Merge pull request #1 from backpaper0/master

Added support for left outer join.

12 years agoRefactoring. 1/head
Taichi Uragami [Fri, 6 Apr 2012 15:13:05 +0000 (00:13 +0900)]
Refactoring.

12 years agoAdded support for left outer join.
Taichi Uragami [Fri, 6 Apr 2012 14:52:39 +0000 (23:52 +0900)]
Added support for left outer join.

12 years agoFixed index out of bounds exception in parsing a default string value v0.7.10
James Moger [Fri, 27 Jan 2012 20:53:00 +0000 (15:53 -0500)]
Fixed index out of bounds exception in parsing a default string value

12 years agoAdded toParameter() to update/set commands v0.7.9
James Moger [Tue, 24 Jan 2012 13:19:31 +0000 (08:19 -0500)]
Added toParameter() to update/set commands

Also allow generation of parameterized update statements for reuse.

12 years agoGenerate SELECT T0.* type statements v0.7.8
James Moger [Wed, 11 Jan 2012 14:20:51 +0000 (09:20 -0500)]
Generate SELECT T0.* type statements

* Fixed negative rollover bug in the AS counter.
* Replaced the non-threadsafe AS counter with an AtomicInteger.
* Added an optional alias parameter to Query.toSQL() and
  QueryWhere.toSQL() to force SELECT T0.* select lists
* Fixed bug with Query.select(Z z) which assumed that z is always an
  anonymous inner class.

12 years agoPrepare 0.7.7 release v0.7.7
James Moger [Thu, 5 Jan 2012 14:24:42 +0000 (09:24 -0500)]
Prepare 0.7.7 release

12 years agoDisallow multiple instances of an enum within a model class
James Moger [Thu, 5 Jan 2012 03:12:56 +0000 (22:12 -0500)]
Disallow multiple instances of an enum within a model class

12 years agoAdded methods to generate static, reusable, parameterized sql statements
James Moger [Thu, 5 Jan 2012 01:48:04 +0000 (20:48 -0500)]
Added methods to generate static, reusable, parameterized sql statements

12 years agoAttempt defaultValue instantiation if object is null && spec'd NOT NULL v0.7.6
James Moger [Wed, 21 Dec 2011 20:20:42 +0000 (15:20 -0500)]
Attempt defaultValue instantiation if object is null && spec'd NOT NULL

This is only attempted on db.insert and db.update.

12 years agoCorrected performance regression. Tweaked dynamic query results. v0.7.5
James Moger [Tue, 13 Dec 2011 20:24:43 +0000 (15:24 -0500)]
Corrected performance regression. Tweaked dynamic query results.

12 years agoPrepare next release
James Moger [Fri, 9 Dec 2011 21:55:13 +0000 (16:55 -0500)]
Prepare next release

12 years agoColumns mapped by name in result set instead of index. Disallow multiple
James Moger [Fri, 9 Dec 2011 21:42:59 +0000 (16:42 -0500)]
Columns mapped by name in result set instead of index. Disallow multiple
primitive bools in a model WITH explicit referencing.

12 years agoAdded alternative method signatures to avoid subtle varargs bugs
James Moger [Thu, 8 Dec 2011 19:27:23 +0000 (14:27 -0500)]
Added alternative method signatures to avoid subtle varargs bugs

12 years agoFixed join into custom type of primitives v0.7.3
James Moger [Tue, 6 Dec 2011 17:45:11 +0000 (12:45 -0500)]
Fixed join into custom type of primitives

12 years agoImproved fluent/type-safety of join statements
James Moger [Tue, 6 Dec 2011 13:51:45 +0000 (08:51 -0500)]
Improved fluent/type-safety of join statements

12 years agoFixed bug in primitive group by clauses
James Moger [Tue, 6 Dec 2011 12:57:51 +0000 (07:57 -0500)]
Fixed bug in primitive group by clauses

12 years agoFixed joins on primitives
James Moger [Mon, 5 Dec 2011 22:01:37 +0000 (17:01 -0500)]
Fixed joins on primitives

12 years agoUpdated readme markdown with H2 and HSQL updated info
James Moger [Fri, 2 Dec 2011 17:46:14 +0000 (12:46 -0500)]
Updated readme markdown with H2 and HSQL updated info

12 years agoUpdated H2 1.3.162 and HSQL 2.2.6 v0.7.2
James Moger [Thu, 1 Dec 2011 03:21:49 +0000 (22:21 -0500)]
Updated H2 1.3.162 and HSQL 2.2.6

13 years agoInclude debug information in built jars.
James Moger [Fri, 2 Sep 2011 21:45:19 +0000 (17:45 -0400)]
Include debug information in built jars.

13 years agoGenerated models are now serializable.
James Moger [Fri, 2 Sep 2011 21:44:53 +0000 (17:44 -0400)]
Generated models are now serializable.

13 years agoPrepare 0.7.1 release v0.7.1
James Moger [Wed, 31 Aug 2011 18:04:33 +0000 (14:04 -0400)]
Prepare 0.7.1 release

13 years agoFixes to model generation. Fixes to default SQL dialect.
James Moger [Wed, 31 Aug 2011 17:59:20 +0000 (13:59 -0400)]
Fixes to model generation. Fixes to default SQL dialect.

13 years agoUndeprecated interface configuration. Added more Define methods.
James Moger [Tue, 30 Aug 2011 23:26:27 +0000 (19:26 -0400)]
Undeprecated interface configuration. Added more Define methods.

I've revised my thinking about interface configuration.  I think its a
good option and should be supported.  Field scope is now ignored across
the board.  If the developer does not want to map a field and is using
the interface configuration approach, then the field should be annotated
with IQIgnore.

13 years agoAdjustment to PostgreSQL dialect for creating autoincrement columns.
James Moger [Tue, 30 Aug 2011 20:41:01 +0000 (16:41 -0400)]
Adjustment to PostgreSQL dialect for creating autoincrement columns.

13 years agoDocumentation.
James Moger [Fri, 26 Aug 2011 14:21:00 +0000 (10:21 -0400)]
Documentation.

13 years agoLaunch H2 and HSQL servers in test suite and include tcp benchmarks.
James Moger [Wed, 17 Aug 2011 20:26:14 +0000 (16:26 -0400)]
Launch H2 and HSQL servers in test suite and include tcp benchmarks.

13 years agoRenamed logger. Improved test suite. Added Apache Commons and DBCP. v0.7.0
James Moger [Wed, 17 Aug 2011 17:30:40 +0000 (13:30 -0400)]
Renamed logger. Improved test suite. Added Apache Commons and DBCP.

13 years agoAdded support for PostgreSQL. Passes all but the boolean-as-int tests.
James Moger [Wed, 17 Aug 2011 12:02:23 +0000 (08:02 -0400)]
Added support for PostgreSQL.  Passes all but the boolean-as-int tests.

13 years agoRefactoring.
James Moger [Tue, 16 Aug 2011 19:45:29 +0000 (15:45 -0400)]
Refactoring.

13 years agoFinished MySQL dialect; v5.0.51b 100% tested. Added Db.dropTable(T)
James Moger [Tue, 16 Aug 2011 19:32:56 +0000 (15:32 -0400)]
Finished MySQL dialect; v5.0.51b 100% tested. Added Db.dropTable(T)

13 years agoPrepare 0.6.6 release. v0.6.6
James Moger [Mon, 15 Aug 2011 22:06:15 +0000 (18:06 -0400)]
Prepare 0.6.6 release.

13 years agoImproving performance documentation.
James Moger [Mon, 15 Aug 2011 21:40:48 +0000 (17:40 -0400)]
Improving performance documentation.

13 years agoAdded Derby dialect. Finished HSQL dialect. Documentation.
James Moger [Mon, 15 Aug 2011 20:44:14 +0000 (16:44 -0400)]
Added Derby dialect. Finished HSQL dialect. Documentation.

* Improved DEFAULT value specifications.
* Fixed bug in buildObjects where the ResultSet could be closed by the
automatic create table attempt.
* DbInspector now uses the dialect's reported DATETIME class preference.
* Improved IciqlException SQLState code checks.
* Integrated LIMIT and OFFSET expression appending in dialects.
* Updated to H2 1.3.159
* Allow reopening of a memory database in the test suite.

13 years agoFixed bug in delete() and update() where primary key is a primitive. v0.6.5
James Moger [Fri, 12 Aug 2011 19:41:42 +0000 (15:41 -0400)]
Fixed bug in delete() and update() where primary key is a primitive.

13 years agoDocumentation. Source cleanup. Prepare 0.6.4 release. v0.6.4
James Moger [Fri, 12 Aug 2011 18:55:02 +0000 (14:55 -0400)]
Documentation. Source cleanup. Prepare 0.6.4 release.

13 years agoAlways enforce strict type mapping.
James Moger [Fri, 12 Aug 2011 18:15:57 +0000 (14:15 -0400)]
Always enforce strict type mapping.

13 years agoRenamed @IQTable.createIfRequired to @IQTable.create
James Moger [Fri, 12 Aug 2011 18:07:53 +0000 (14:07 -0400)]
Renamed @IQTable.createIfRequired to @IQTable.create

13 years agoPrimitive default: NOT NULL. Autoincrement primitive = 0 skip on insert.
James Moger [Fri, 12 Aug 2011 18:05:54 +0000 (14:05 -0400)]
Primitive default: NOT NULL. Autoincrement primitive = 0 skip on insert.

13 years agoFull primitives support.
James Moger [Fri, 12 Aug 2011 17:04:29 +0000 (13:04 -0400)]
Full primitives support.

13 years agoDocumentation. Added another unmapped field case.
James Moger [Thu, 11 Aug 2011 18:38:02 +0000 (14:38 -0400)]
Documentation. Added another unmapped field case.

13 years agoRestructured test suite to run against multiple databases.
James Moger [Thu, 11 Aug 2011 18:10:28 +0000 (14:10 -0400)]
Restructured test suite to run against multiple databases.

13 years agoAdded support for HSQL database. Revised dialects some more.
James Moger [Thu, 11 Aug 2011 18:04:01 +0000 (14:04 -0400)]
Added support for HSQL database. Revised dialects some more.

Moved CREATE TABLE and CREATE INDEX statement generation to the dialect.
Added DECIMAL(length, scale) support.
Improved automatic dialect detection.
Unspecified length string is now CLOB instead of TEXT.
Boolean now maps to BOOLEAN instead of BIT.
Expressions on unmapped fields will throw an IciqlException.
Improved exception reporting.

13 years agoMoved dialects back to main package. Registered MySQL dialect.
James Moger [Wed, 10 Aug 2011 13:18:43 +0000 (09:18 -0400)]
Moved dialects back to main package. Registered MySQL dialect.

13 years agoDialect refinements.
James Moger [Wed, 10 Aug 2011 13:01:04 +0000 (09:01 -0400)]
Dialect refinements.

13 years agoAll columns are assumed NULLABLE. IQColumn.allowNull->IQColumn.nullable
James Moger [Tue, 9 Aug 2011 17:56:44 +0000 (13:56 -0400)]
All columns are assumed NULLABLE. IQColumn.allowNull->IQColumn.nullable

13 years agoIQTable.primaryKey is now an array. Default values from objects.
James Moger [Tue, 9 Aug 2011 15:28:48 +0000 (11:28 -0400)]
IQTable.primaryKey is now an array. Default values from objects.

Also fixed an error with allowing null objects. Noted rapid churn of
iciql in documentation. Changed build constants for next release.

13 years agoFix build date.
James Moger [Mon, 8 Aug 2011 16:48:12 +0000 (12:48 -0400)]
Fix build date.

13 years agoDo not generate primitive mappings. Prepare v0.6.3 release. v0.6.3
James Moger [Mon, 8 Aug 2011 16:43:46 +0000 (12:43 -0400)]
Do not generate primitive mappings. Prepare v0.6.3 release.

13 years agoDocumentation. Moved dialects into separate package.
James Moger [Mon, 8 Aug 2011 16:25:12 +0000 (12:25 -0400)]
Documentation. Moved dialects into separate package.

13 years agoFixed first enum constant special case. (issue 4)
James Moger [Mon, 8 Aug 2011 16:03:10 +0000 (12:03 -0400)]
Fixed first enum constant special case. (issue 4)

13 years agoDocumentation. EnumType default is NAME.
James Moger [Mon, 8 Aug 2011 15:12:50 +0000 (11:12 -0400)]
Documentation. EnumType default is NAME.

13 years agoSimplified dialect lookup.
James Moger [Mon, 8 Aug 2011 13:40:16 +0000 (09:40 -0400)]
Simplified dialect lookup.

13 years agoFully support H2 UUID type. Cleanup imports for generated models.
James Moger [Mon, 8 Aug 2011 13:32:30 +0000 (09:32 -0400)]
Fully support H2 UUID type. Cleanup imports for generated models.

13 years agoPartial primitives support: insert, update, and select but NOT where.
James Moger [Mon, 8 Aug 2011 12:35:24 +0000 (08:35 -0400)]
Partial primitives support: insert, update, and select but NOT where.

13 years agoRefinement to BETWEEN to feel more like the rest of the API.
James Moger [Mon, 8 Aug 2011 11:54:28 +0000 (07:54 -0400)]
Refinement to BETWEEN to feel more like the rest of the API.

13 years agoQuick implementation of BETWEEN, IS NULL, and IS NOT NULL.
James Moger [Sun, 7 Aug 2011 20:10:43 +0000 (16:10 -0400)]
Quick implementation of BETWEEN, IS NULL, and IS NOT NULL.

13 years agoFinished enum query support (issue 4)
James Moger [Sun, 7 Aug 2011 19:53:18 +0000 (15:53 -0400)]
Finished enum query support (issue 4)

13 years agoIndexValidation was broken for single-indexes or non-standard indexes. v0.6.2
James Moger [Fri, 5 Aug 2011 21:15:45 +0000 (17:15 -0400)]
IndexValidation was broken for single-indexes or non-standard indexes.

13 years agoDocumentation.
James Moger [Fri, 5 Aug 2011 20:45:31 +0000 (16:45 -0400)]
Documentation.

13 years agoImportant fix to _iq_versions create mechanism to work with H2 1.3.158+ v0.6.1
James Moger [Fri, 5 Aug 2011 20:40:48 +0000 (16:40 -0400)]
Important fix to _iq_versions create mechanism to work with H2 1.3.158+

13 years agoRelease 0.6.0. APIv2 v0.6.0
James Moger [Fri, 5 Aug 2011 19:18:44 +0000 (15:18 -0400)]
Release 0.6.0. APIv2

13 years agoDocumentation. Don't double-wrap IciqlException.
James Moger [Fri, 5 Aug 2011 19:18:02 +0000 (15:18 -0400)]
Documentation. Don't double-wrap IciqlException.

13 years agoSimplified annotations. Interchangeable int-boolean runtime mapping.
James Moger [Fri, 5 Aug 2011 15:04:29 +0000 (11:04 -0400)]
Simplified annotations. Interchangeable int-boolean runtime mapping.

13 years agoCustomizable enumId() mapping (issue 2)
James Moger [Fri, 5 Aug 2011 02:22:24 +0000 (22:22 -0400)]
Customizable enumId() mapping (issue 2)

13 years agoBLOB support (issue 1) and Enum support (issue 2). Documentation.
James Moger [Thu, 4 Aug 2011 21:58:22 +0000 (17:58 -0400)]
BLOB support (issue 1) and Enum support (issue 2). Documentation.

13 years agoOverhauling annotations.
James Moger [Thu, 4 Aug 2011 18:10:59 +0000 (14:10 -0400)]
Overhauling annotations.

* @IQSchema(name="public") -> @IQSchema("public")
* @IQDatabase(version=2) -> @IQVersion(2)
* @IQTable(version=2) -> @IQVersion(2)
* @IQIndex annotation simplified to be used for one index definition and
expanded to specify index name
* added @IQIndexes annotation to specify multiple IQIndex annotations

13 years agoChange identifiers for next release.
James Moger [Thu, 4 Aug 2011 17:51:26 +0000 (13:51 -0400)]
Change identifiers for next release.