district-server-db

Clojurescript-node.js mount module for a district server, that takes care of database, which usually stores blockchain data in more search-friendly format. This module currently utilises better-sqlite3 for db and honeysql for SQL formatting.

Installation

Latest released version of this library:

Include [district.server.db] in your CLJS file, where you use mount/start

API Overview

Warning: district0x modules are still in early stages, therefore API can change in a future.

district.server.db

Usage

You can pass following args to smart-contracts module:

:path Path to db file in case you don't use in-memory db
:sqlite3-opts Opts passed into Sqlite3 constructor. Default: {:memory true}

  (ns my-district
    (:require [mount.core :as mount]
              [district.server.db :as database :refer [db]]))

  (-> (mount/with-args
        ;; This is default, so not really needed, but here just to show how to pass args to the module
        {:db {:sqlite3-opts {:memory true}}})
    (mount/start))

  (println @db)
  ;; #object[Database [object Database]] (Sqlite3 Database Connection)

  (database/run! {:create-table :my-doggos
                  :with-columns [[[:doggo/years :unsigned :integer]
                                  [:doggo/description :varchar]]]})
  ;; => "{:changes 0, :lastInsertROWID 0}"

  (database/run! {:insert-into :my-doggos
                  :columns [:doggo/years :doggo/description]
                  :values [[1 "Good boy"]]})
  ;; => "{:changes 1, :lastInsertROWID 1}"

  (database/get {:select [:doggo/description]
                 :from [:my-doggos]
                 :where [:= :doggo/years 1]})
  ;; => {:doggo/description "Good boy"}

Note: You can use namespaced keywords for SQL column and table names and also get them back from selects. This is because district.server.db extends honeysql name transformation with munge, demunge functions.

district.server.db also includes honeysql-postgres extensions, so that's why we could use statements such as :create-table in example, which are not supported by honeysql by default. Beware that not all postgres queries are compatible with sqlite3. We may create dedicated one for sqlite3 in future.

Module dependencies

district-server-config

district-server-db can get initial args from config provided by district-server-config/config under the key :db. These args are then merged together by ones passed to mount/with-args.

If you wish to use custom modules instead of dependencies above while still using district-server-db, you can easily do so by mount's states swapping.