I just ran this in the Caribou repl:
(caribou.model/gather :field {:where {:created-at {:<=
(java.util.Date.)} :model-id 1}})
And got a bunch of results. No string coercion necessary! (also, dashes
not underscores!)
We looked at Korma and found it lacking (similar problem as Compojure:
macros). For that reason we built an entire query engine that works on
data directly, so that you can build up queries programmatically just like
you would any other data structure (!)
Check out the section on retrieving content here:
http://caribou.github.io/caribou/docs/content.html
You can do a bunch of cool stuff (logic operations, "in" queries,
conditions that span associations, selecting certain fields, seamless
queries over join tables etc).
Let me know if there is something you expect out of a query engine that
Caribou doesn't do, we will add it (if it makes sense!)
All this stuff is in caribou-core (which you can use independently of the
rest of Caribou): https://github.com/caribou/caribou-core
Maybe I should call it something else to emphasize it is a standalone
library... (and replacement for korma)
On Mon, Nov 18, 2013 at 11:07 AM, Marcus Blankenship
<mar...@creoagency.com>wrote:
> Brian,
>
> Yeah, and I realize I’m going to take darts for this, but coming from
> Django’s ORM / Rails ActiveRecord makes Korma and these other tools feel
> like stone-age tools. I’d rather do it all in SQL than fight something to
> get out of my way, or reveal it’s magic.
>
> I know I’m probably not thinking about the problem right, but here’s an
> example of something that I still can’t get to work in Korma. Grrrr….
>
> *lein-repl commands*
> (use [`advent2.models.db] :reload-all)
> (get-unlocked-videos-for-campaign 1)
>
>
>
> *models/db.clj function*
> (defn format-todays-date []
> (let [date (java.util.Date.)]
> (prn date)
> (str \' (.format (java.text.SimpleDateFormat. "yyyy-MM-dd") date) \'
> )))
>
>
> (defn get-unlocked-videos-for-campaign [campaign]
> (let [c_id (:id campaign)]
> (select videos (where {:unlock_date [<= (format-todays-date)]
> :campaign_id c_id}))))
>
>
>
> *output*
> user=> (get-unlocked-videos-for-campaign 1)
> #inst "2013-11-18T19:06:09.595-00:00"
> Failure to execute query with SQL:
> SELECT "videos".* FROM "videos" WHERE ("videos"."unlock_date" <= ? AND
> "videos"."campaign_id" IS NULL) :: ['2013-11-18']
> PSQLException:
> Message: ERROR: operator does not exist: date <= character varying
> Hint: No operator matches the given name and argument type(s). You might
> need to add explicit type casts.
> Position: 63
> SQLState: 42883
> Error Code: 0
>
> PSQLException ERROR: operator does not exist: date <= character varying
> Hint: No operator matches the given name and argument type(s). You might
> need to add explicit type casts.
> Position: 63
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
> (QueryExecutorImpl.java:2102)
>
>
>
>
>
>
> On Nov 18, 2013, at 10:23 AM, Brian Craft <craft.br...@gmail.com> wrote:
>
> Re: korma, and sql dsls, I've been moving between korma, honeysql, and raw
> sql, without being satisfied with any of them. Desirable traits of the db
> layer in my problem domain are 1) eliminating boilerplate (e.g. setting up
> default keys, and indexes, and performing standard joins across relations),
> 2) isolating view layers from data access layers (so the view doesn't need
> to know if a subselect or a join is required to span some relation, for
> example), 3) ability to progressively optimize by dropping back to sql when
> required, 4) ability to safely expose a general purpose query API over the
> data.
>
> korma eliminates a very, very small part of the boilerplate. It's almost
> not worth the effort. Falling back to raw sql smoothly is difficult in
> korma, and I've had to drop it entirely in places where I need performance.
> Honeysql eliminates no boilerplate, but representing queries with data
> structures does make it easy to expose a sql-like query API with db
> firewalling (by matching on the incoming structure). Korma appears to also
> represent queries as data structures, but it's not part of the documented
> API. You have to reverse-engineer it, and I expect it's subject to change.
>
>
> On Monday, November 18, 2013 8:19:28 AM UTC-8, Marcus Blankenship wrote:
>>
>> Brian, I certainly will. I’ll type up something later this week as we
>> progress. The current pain point is Korma, and generally learning clojure.
>>
>>
>>
>>
>> On Nov 16, 2013, at 10:25 AM, Brian Craft <craft...@gmail.com> wrote:
>>
>> Marcus -- I hope you will post updates to the list with your experiences.
>> It would be very interesting.
>>
>> This thread has drifted a bit from (roughly) "What can you do with
>> clojure web tooling?" toward "What can you imagine some day doing with the
>> clojure web tooling of the future?", which are both interesting questions,
>> but have somewhat different audiences. And the answers inform each other.
>>
>>
>> On Friday, November 15, 2013 8:20:32 AM UTC-8, Marcus Blankenship wrote:
>>>
>>> Me too! Thanks to everyone who’s contributed, it’s been *very* helpful!
>>>
>>> On Nov 14, 2013, at 10:43 AM, Waldemar Schwan <waldema...@googlemail.com>
>>> wrote:
>>>
>>> I just want to say that this is one of the most interesting discussions
>>> I followed on this mailing list.
>>>
>>> Thanks to all participants.
>>>
>>> Am 14.11.2013 um 19:24 schrieb Brian Craft <craft...@gmail.com>:
>>>
>>>
>>>
>>> On Thursday, November 14, 2013 9:42:52 AM UTC-8, Jonathan Irving wrote:
>>>>
>>>> I agree with much of what you write James - I'm paid to write rails and
>>>> node.js code, and I'm finding that node is encouraging me to compose
>>>> small components and basically sidestep a lot of the issues that rails
>>>> is designed to address.
>>>>
>>>
>>> Can you give a concrete example?
>>>
>>> --
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Clojure" group.
>>> To post to this group, send email to clo...@googlegroups.com
>>> Note that posts from new members are moderated - please be patient with
>>> your first post.
>>> To unsubscribe from this group, send email to
>>> clojure+u...@googlegroups.com
>>> For more options, visit this group at
>>> http://groups.google.com/group/clojure?hl=en
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "Clojure" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to clojure+u...@googlegroups.com.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>> --
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Clojure" group.
>>> To post to this group, send email to clo...@googlegroups.com
>>> Note that posts from new members are moderated - please be patient with
>>> your first post.
>>> To unsubscribe from this group, send email to
>>> clojure+u...@googlegroups.com
>>> For more options, visit this group at
>>> http://groups.google.com/group/clojure?hl=en
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "Clojure" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to clojure+u...@googlegroups.com.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>> marcus blankenship
>>> \\\ Partner, Problem Solver, Linear Thinker
>>> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>>>
>>>
>> --
>> --
>> You received this message because you are subscribed to the Google
>> Groups "Clojure" group.
>> To post to this group, send email to clo...@googlegroups.com
>> Note that posts from new members are moderated - please be patient with
>> your first post.
>> To unsubscribe from this group, send email to
>> clojure+u...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/clojure?hl=en
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Clojure" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to clojure+u...@googlegroups.com.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>> marcus blankenship
>> \\\ Partner, Problem Solver, Linear Thinker
>> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>>
>>
> --
> --
> You received this message because you are subscribed to the Google
> Groups "Clojure" group.
> To post to this group, send email to clojure@googlegroups.com
> Note that posts from new members are moderated - please be patient with
> your first post.
> To unsubscribe from this group, send email to
> clojure+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/clojure?hl=en
> ---
> You received this message because you are subscribed to the Google Groups
> "Clojure" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to clojure+unsubscr...@googlegroups.com.
>
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
> marcus blankenship
> \\\ Partner, Problem Solver, Linear Thinker
> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>
> --
> --
> You received this message because you are subscribed to the Google
> Groups "Clojure" group.
> To post to this group, send email to clojure@googlegroups.com
> Note that posts from new members are moderated - please be patient with
> your first post.
> To unsubscribe from this group, send email to
> clojure+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/clojure?hl=en
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "Clojure" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/clojure/ZxUUBlYf1ck/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> clojure+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
