bowtie8904/btdatabase

A database utility library to connect to and use Apache Derby databases.

btdatabase's Issues

Implement OFFSET expression.

Implement MERGE statement.

Create a way to add functions to SqlPredicate structure

I should implement a way to easily add functions to the SqlPredictae structure so that they can be used within the parsed sql string.

Implement onSuccess handle methods.

Implement create sequence.

Create table as copy of another table.

Make it possible to use a

create table table1_copy as select * from table1;

syntax to create an exact copy of table1.

Implement create synonym.

Implement check constraints.

For both table and column checks.

Implement foreign keys.

Implement CASE WHEN expression.

Rework statement preparation.

Rework statement preparation to allow prepared statement in subselects etc.

Evaluate if 3 join classes are really needed

Rework order by.

Rework order by to allow the specification of the order direction for each given column.

Remove default implementation for onDuplicateKey, onFreignKeyViolation and onCheckViolation.

The default implementations will cover up the onFail method, even if the user only specified onFail and did not explicitly add an onDuplicateKey etc.

Implement UNION and UNION ALL feature into SqlResultSet.

Since the feature in SelectStatement requires the appended selects to be unprepared, this feature should also be added to the resultsets, so that they can be easily combined without having to execute everything unprepared.

Implement generated as.

Implement savepoints.

Implement BETWEEN logic into ConditionalClause.

Implement cross join

Currently only inner, left and right joins are supported.

Implement create function.

Implement ALL, ANY and SOME conditionals.

Implement UNION syntax.

UNION and UNION ALL are supported by Derby and should be implemented into the SelectStatement.

Implement EXISTS and NOT EXISTS conditionals.

Create remaining SqlFunction implementations.