clojureql
clojureql copied to clipboard
LauJensen
ClojureQL is superior SQL integration for Clojure
Incanter rely on `clojureql` to use `incanter.sql`. But currently `clojureql`'s jdbc dependency is really old. Hi, @LauJensen , sorry for this disturbtion, but can you update jdbc dependency version to...
#+begin_src clojure (use 'clojureql.core) #+end_src ``` 2. Unhandled clojure.lang.Compiler$CompilerException Error compiling clojureql/core.clj at (1:1) core.clj: 5807 clojure.core/throw-if core.clj: 5893 clojure.core/load-lib core.clj: 5868 clojure.core/load-lib RestFn.java: 142 clojure.lang.RestFn/applyTo core.clj: 659 clojure.core/apply core.clj:...
I've committed a failing test that shows the SQL I need to output. If there is already syntax to support this query, I can't work it out. We need to...
https://github.com/LauJensen/clojureql/issues/124
jdata is referenced twice, and it is not entirely clear why
Presently there is no way to determine the order of fields retrieved out of any SQL that was executed, because the row data is slotted into a hash-map, and the...
user> (use 'clojureql.core) WARNING: distinct already refers to: #'clojure.core/distinct in namespace: user, being replaced by: #'clojureql.core/distinct WARNING: conj! already refers to: #'clojure.core/conj! in namespace: user, being replaced by: #'clojureql.core/conj! WARNING:...
Database server: MySQL There are two tables 'items' and 'users' each of them having a common column name 'id'. 'items.user' is a foreign key referring to 'users.id' ``` clojure (->...
``` clojure (-> (project items [:content :id :user_id]) (join users (where (= :items.user_id :users.id))) (rename {:items.id :idx})) ``` generates ``` sql SELECT items.content,items.id,items.user_id,users.* FROM items AS items(content,idx,user_idx) JOIN users ON...
I'm using clojureql 1.0.3 and MySQL database. This code ``` @(-> (join (table :users) (table :cities) (where (= :users.city :cities.id))) (rename {:cities.name :city})) ``` throws following exception: ``` You have...
