Hi Kris, I am not sure about that. On the other hand, it will be boring to write 20 query in 20 different files.
Could you please check: https://developers.google.com/closure/templates/docs/helloworld_js Here comment contains meta data for core part. Similarly, query'd contain meta data in comment part. Query will be identified based on meta data (def query {:name-of-the-file {:name "named-of-the-query" :query "query-body" :doc "doc"}}) Please find sql file example in bellow: -- {:doc "Counts the users in a given country." :name "by_controry_code" :query SELECT count(*) AS count FROM user WHERE country_code = :country_code -- } -- {:doc "Counts the users in a given country." :name "by_id" :query SELECT count(*) AS count FROM user WHERE id = :id -- } Hi Mamun, > Hmm...I hadn't planned on it, but I could see it would suit some people's > development style. (It could get messy, but so can Clojure namespaces if > you're undisciplined. The developer should be allowed to take > responsibility.) > > The tricky parts would be: > > - How would you delimit the various queries? In a clear, portable way > that allowed for docstrings? > - How would you refer to the individual queries? Some kind of > mandatory '-- NAME: foo-query' syntax? > > Any thoughts? > > Kris > > On Monday, 11 November 2013 14:46:55 UTC, Mamun wrote: >> >> Hi Kris, >> >> It's look fine. Is is possible to to add more query in one sql file? I >> mean- I'd like to create one sql file and store all query on that file. >> >> BR, >> Mamun >> >> >> >> On Monday, November 11, 2013 2:38:27 PM UTC+1, Kris Jenkins wrote: >>> >>> Thanks David, that's nice of you to say. I know exactly what you mean - >>> I didn't want to be the guy to write yet another Clojure/SQL library - but >>> when I figured out why none of the existing ones was working for me, I had >>> no choice. :-D >>> >>> There's still plenty that can be done with the implementation, but >>> hopefully the world will look kindly on the design, and it can evolve from >>> there... >>> >>> Kris >>> >>> On Monday, 11 November 2013 11:45:21 UTC, David Della Costa wrote: >>>> >>>> I was about to be like, "oh no, not another one!" and then I read the >>>> README and I thought, "oh, interesting... >>>> >>>> So, kudos on thinking outside the box. I certainly agree with a lot of >>>> the points you've made. I'll definitely be playing around with this. >>>> >>>> Cheers, >>>> DD >>>> >>>> (2013/11/11 20:10), Kris Jenkins wrote: >>>> > https://github.com/krisajenkins/yesql >>>> > >>>> > Yesql is a simple library for blending SQL & Clojure together, >>>> cleanly. >>>> > Here's how it works <https://github.com/krisajenkins/yesql#rationale>, >>>> >>>> > and how to use it < >>>> https://github.com/krisajenkins/yesql#example-usage>. >>>> > >>>> > Feedback welcomed, >>>> > Kris >>>> > >>>> > -- >>>> > -- >>>> > 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 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.
