chinook — com.fooheads/chinook-edn 0.1.11

Clojure data/edn version of the chinook database.

Extracts the data from the SQLite version of the database. For more info, see https://github.com/lerocha/chinook-database

db-url clj

The url to the copy of the SQLite db in the resources folder

ds clj

The datasource to the SQLite database in resources. Don't do any writes to this datasource.

edn clj

edn data from the chinook database as a map of vectors

edn-with-sets clj

edn data from the chinook database as a map of sets

make-edn clj

(make-edn ds)

(make-edn ds to)

(make-edn ds to opts)

Creates a map of collections from the database. Default is a map of vectors in the shape of

{:genre [{:genre/genre-id 1 :genre/name "Rock"} {:genre/genre-id 2 :genre/name "Jazz"} {:genre/genre-id 3 :genre/name "Metal"}]}

but if you want another collection type for the table data (set, list, ...), you can provide an empty collection of that type as to.

schema clj

table-data clj

(table-data ds table-name)

(table-data ds table-name opts)

Extracts the table data for a given table. opts are the opts passed on to next-jdbc/execute! and can be used for changing the shape of the result set. Default opts is typical clojure kebab-maps.

table-k clj

table-names clj

(table-names ds)

Gets the table names from the database