medeamelana / sirenial

Automatically exported from code.google.com/p/sirenial

Sirenial

Sirenial aims:

• to provide Haskell programmers with a moderately type-safe way to construct and execute SQL queries;
• to use simple types, resulting in friendly type errors;
• to generate simple, predictable SQL;
• to transparently combine similar queries into one query.

The first two aims bite each other: more type-safety means more involved types, while more involved types result in more daunting type errors. Sirenial aims to find the perfect balance.

sirenial's Issues

Support for JOINs

The Select monad should support the creation of INNER, LEFT and RIGHT joins.

Original issue reported on code.google.com by [email protected] on 20 Apr 2010 at 9:34

Transactions

Look into transactions: does HDBC support them, and how? Offer an API for this.

Original issue reported on code.google.com by [email protected] on 27 Apr 2010 at 6:31

Grouping and aggregate functions

The Select monad should support GROUPing. Current idea is to provide a single 
function:

group :: Select ()

that marks the query as grouping.

To make this useful, expressions should be able to model aggregate functions 
such as COUNT, 
MAX, MIN and AVG.

Original issue reported on code.google.com by [email protected] on 20 Apr 2010 at 9:35

Testing and code coverage

It'd be nice to have a test setup that starts with an empty database and then 
fires some queries 
through the API, testing various properties in between.

Then using {{{hpc}}} we can measure code coverage, striving for 100%.

Original issue reported on code.google.com by [email protected] on 20 Apr 2010 at 9:38

Bring alias in scope in ExecUpdate

Currently in ExecUpdate only the condition Expr Bool may use the alias. But the 
SetFields should 
also be able to use it, to be able to express queries like:

update t set a = a + 1;

Original issue reported on code.google.com by [email protected] on 21 Apr 2010 at 11:39