<< Back to previous view

[JDBC-5] Adding stropping and qualified identifiers to java.jdbc Created: 24/Apr/11  Updated: 09/Jul/11  Resolved: 09/Jul/11

Status: Resolved
Project: java.jdbc
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Enhancement Priority: Minor
Reporter: Nicolas Buduroi Assignee: Nicolas Buduroi
Resolution: Completed Votes: 0
Labels: None

Attachments: Text File 0001-Added-the-with-stropping-macro-and-the-as-identifier.patch    
Patch: Code
Waiting On: Sean Corfield

 Description   

Following the following discussion:

https://groups.google.com/d/topic/clojure/j7fXdkFMrec/discussion

I've implemented a simple stropping feature that also provide a way to supply qualified identifiers and a function (as-identifier) that can be reused in user code. The implementation can be found there:

https://github.com/budu/java.jdbc/commit/0822d323cd4d267533a88241be68cb184ff9bf28

It's also attached to this issue.

Here's some example of how that feature could be used:

user> (create-table :foo [:bar :integer] [:baz :text])
"CREATE TABLE foo (bar integer, baz text)"
user> (create-table [:schema :foo] [:bar :integer] [:baz :text])
"CREATE TABLE schema.foo (bar integer, baz text)"
user> (with-stropping \" identity (create-table [:schema :foo] [:bar :integer] [:baz :text]))
"CREATE TABLE \"schema\".\"foo\" (\"bar\" integer, \"baz\" text)"
user> (with-stropping [[ ]] identity (create-table [:schema :foo] [:bar :integer] [:baz :text]))
"CREATE TABLE [schema].[foo] ([bar] integer, [baz] text)"



 Comments   
Comment by Sean Corfield [ 24/Apr/11 8:21 PM ]

Duplicate of https://github.com/clojure/java.jdbc/issues/7 - thanx for the patch!

Comment by Sean Corfield [ 09/Jul/11 2:28 PM ]

with-naming-strategy, with-quoted-identifiers, as-quoted-str address this.

Generated at Wed Apr 23 10:08:58 CDT 2014 using JIRA 4.4#649-r158309.