summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2013-11-25Fix the jdbc query executor for insert/update/delete operationsHEADmasterCarlo Zancanaro
2013-11-25Remove a stupid testing thing, update the README a touchCarlo Zancanaro
2013-11-25Add a 'distinct' operator - still a bug to fix on renamingCarlo Zancanaro
2013-11-12Fix the database type detection in the jdbc executorCarlo Zancanaro
2013-11-12Potentially misleading typoCarlo Zancanaro
2013-11-12Change the query executor model: now it's query local and the interface is ↵Carlo Zancanaro
managed by a protocol.
2013-11-12Fix a minor error in the README.Carlo Zancanaro
2013-11-12Ah, screw it. Have super long lines in the README.Carlo Zancanaro
2013-11-12Fix up the README which I formatted wrong. Whoops!Carlo Zancanaro
2013-11-12Fix grouping - it used to allow for groupings leaving a non-grouped fieldCarlo Zancanaro
Now it takes a third "projection" argument in which one can perform aggregate function over the existing fields. The fields of the resulting query are the union of the grouping fields and the projected fields (with the projected fields taking precedence). If you try to project a field without applying some sort of function to it then you'll get an exception, but at the moment no function calls are actually validated as aggregate functions (in order to do so we'd need a knowledge of all the aggregate functions, which isn't possible in general).
2013-09-30One more whitespace char (same excuse as last time)Carlo Zancanaro
2013-09-30Remove some whitespace (excuse to test jenkins trigger)Carlo Zancanaro
2013-09-30Fix up union/intersection operationsCarlo Zancanaro
Previously the union/intersection operations didn't work when you tried to select/project/sort/drop/whatever on them. Now they just automatically introduce a subquery, which means that they can be used in other operations automatically. (There is a potential for a minor decrease in query speed, but I think it's worthwhile to maintain the abstraction.)
2013-09-30Change the header level on the changelogCarlo Zancanaro
2013-09-30Remove the generated SQL from the README which was added in the last commit ↵Carlo Zancanaro
- it looked ridiculous
2013-09-30Fix an example in the README, and add some expected generated SQLCarlo Zancanaro
2013-09-30Fix a bug relating to table renamingCarlo Zancanaro
When queries were being created their internal aliases were defaulting to the same as their external table names. This would normally have been fine, but in the case of a rename the simplistic implementation of table renames was leading to the external name being changed too. The solution: generate a (unique) random internal name for the table. That way the rename operation will only rename the unique internal name, not the constant external name (it would also, in theory, reduce the need for renames, but that optimisation probably isn't really worth doing for expected work loads).
2013-09-29Due to breaking change, go to 0.2.0-SNAPSHOT instead of 0.1.1-SNAPSHOTCarlo Zancanaro
2013-09-29README indentationCarlo Zancanaro
2013-09-29Add a bit of a changelog to the READMECarlo Zancanaro
2013-09-29Add jdbc as a dependency (to make `lein check` useful)Carlo Zancanaro
2013-09-29Remove `having` from the lsit of vars to pull into core (should have been on ↵Carlo Zancanaro
earlier commit).
2013-09-29Clear up the ambiguous field error messageCarlo Zancanaro
The ambiguous field error message used to specify that it was a case where multiple tables were present, but that's not always true. If you're trying to work on a query that has been "subqueried" then you'll also get the error (arguably that should have a different error message, but I'll come back to that later).
2013-09-29Remove midje as a dependency.Carlo Zancanaro
2013-09-29Remove the `having` function, incorporate into `select`Carlo Zancanaro
The `having` function duplicated the intended functionality of `select`, but in a bad way. It only applied to a restricted case, and its existence meant that `select` provided an escape-hatch with which we could cause some unexpected behaviour. By consolidating the two functions into `select` we remove the escape hatch as well as simplify the model. Selection on grouped queries may now introduce a new subquery, but only in situations where the behaviour is unpredictable (ie. selecting on non-grouped attributes).
2013-07-12A bunch of refactoring in the DSLCarlo Zancanaro
2013-07-12One more.Carlo Zancanaro
2013-07-12Bitbucket syntax highlighting in READMECarlo Zancanaro
2013-07-12Two more minor changes to the README.Carlo Zancanaro
2013-07-12Update the README a bunchCarlo Zancanaro
2013-07-12Remove some scrap code that got committed accidentallyCarlo Zancanaro
2013-07-12Handle parameter types in the compiler betterCarlo Zancanaro
The compiler handled them by converting most things to strings and embedding them in the query, but now I'm trying to put more of them in as query parameters. The advantage is that his handles types that might be database specific, or something. At the moment sequences are handled in the same way as before (with each element being a separate parameter), but this may be changed in future.
2013-07-12Assert in jdbc interface to fail early rather than do the wrong thingCarlo Zancanaro
When converting dotted fields to maps there's one possible case where it can do the wrong thing. This should now throw an AssertionError rather than silently doing the wrong thing.
2013-07-12Expose a few more helper functions in clojure-sql.coreCarlo Zancanaro
2013-07-12Add a rename helper to turn queries into "subobjects" in the result.Carlo Zancanaro
Essentially just prefixes a subobject name in front of all fields in a query, with a dot separating the new prefix and the original name.
2013-07-06Make `sort` able to take expressions rather than just table names.Carlo Zancanaro
2013-07-06Bump the version, put Midje back in as dev dependencyCarlo Zancanaro
2013-07-03Add fields to union/intersection result queriesCarlo Zancanaro
2013-07-03Remove midje dependency and now useless tests (will add tests later)Carlo Zancanaro
2013-07-03Add SCM info to project.cljCarlo Zancanaro
2013-07-03Added tag 0.1.0 release for changeset a04a90ac3937Carlo Zancanaro
2013-07-03Update the README to include a leiningen dependency vectorCarlo Zancanaro
2013-07-01Bump the version number: 0.1.0Carlo Zancanaro
2013-07-01Change the condition for union compatible (require projections first)Carlo Zancanaro
2013-07-01Make fields compile in a deterministic order (necessary for union stuff)Carlo Zancanaro
2013-07-01A bit more readme changingCarlo Zancanaro
2013-07-01Add union/intersection to the dslCarlo Zancanaro
2013-07-01Update the readme some moreCarlo Zancanaro
2013-07-01Remove some extra code that was left sitting aroundCarlo Zancanaro
2013-07-01Update the readmeCarlo Zancanaro