Skip to content

Instantly share code, notes, and snippets.

@daveray
Created March 27, 2012 02:08
Show Gist options
  • Save daveray/2211743 to your computer and use it in GitHub Desktop.
Save daveray/2211743 to your computer and use it in GitHub Desktop.
clojure.pprint/print-table is a gem
user=> (use 'korma.core)
nil
user=> (use 'korma.db)
nil
user=> (defdb dev (sqlite3 {:classname "org.sqlite.JDBC"
:subprotocol "sqlite"
:subname "db/dev.sqlite3"}))
{:pool #<Delay@4471dfd7: :pending>, :options {:naming {:keys #<core$identity clojure.core$identity@76612ef6>, :fields #<core$identity clojure.core$identity@76612ef6>}, :delimiters ["\"" "\""]}}
user=> (defentity users)
#'user/users
user=> (insert users (values {:name "Foo"}))
{:last_insert_rowid() 1}
user=> (insert users (values {:name "Bar"}))
{:last_insert_rowid() 2}
user=> (select users)
[{:id 1, :name "Foo"} {:id 2, :name "Bar"}]
user=> (use 'clojure.pprint)
nil
user=> (print-table (select users))
===========
:id | :name
===========
1 | Foo
2 | Bar
===========
nil
user=>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment