Code generation tool for SQL schema to Korma entities

Question

Is there a tool to convert a SQL schema to Korma entities?

score 2 · Answer 1 · answered Aug 16 '12 at 09:44

2

Not yet, but you could query you DBMS' Data Dictionary to get you started.

For instance, on MySQL you could start with:

select concat('(defentity ', t.table_name ,')') as defentity
  from information_schema.tables t
  where table_schema = 'mySchema';

answered Aug 16 '12 at 09:44

Henrique Ordine

3,337
4
44
70

Interesting, but using JDBC metadata would be a portable alternative. – Timo Westkämper Aug 16 '12 at 10:56

score 2 · Answer 2 · answered Aug 01 '13 at 20:41

2

This works for me, took some thought to implement. I was a bit blown back that Korma does not have this feature! (note: I ran this against MSSQL)

(defentity INFORMATION_SCHEMA.tables)
(def tables (map #(get % :TABLE_NAME) 
              (select 'INFORMATION_SCHEMA.tables (fields :TABLE_NAME) 
                      (where {:TABLE_TYPE "BASE TABLE"})))) ;notice the quote

(prn tables)
;(map #(def %) tables) ;additional concept
(map #(defentity %) tables) ;not sure this is required anymore

(select (first tables))

answered Aug 01 '13 at 20:41

scape

652
12
27

Looks nice, but you can use :TABLE_NAME as the first argument of the first map call – Timo Westkämper Aug 01 '13 at 21:05
like #{:TABLE_NAME} ? I should try that in a filter maybe – scape Aug 02 '13 at 11:57

Code generation tool for SQL schema to Korma entities

2 Answers2