datomic composite index

gistfile1.clj

(ns experiments.datomic
  (:require
   [datomic.api :as d]))

(comment
  (def db-uri "datomic:mem://hello")

  (d/create-database db-uri)

  (def conn (d/connect db-uri))

  @(d/transact conn [{:db/ident       :post/uuid
                      :db/valueType   :db.type/uuid
                      :db/cardinality :db.cardinality/one
                      :db/unique      :db.unique/identity}
                     {:db/ident       :post/published-at
                      :db/valueType   :db.type/instant
                      :db/cardinality :db.cardinality/one}
                     {:db/ident       :post/status
                      :db/doc         "note: try to use enums: https://docs.datomic.com/schema/schema-modeling.html#enums"
                      :db/valueType   :db.type/keyword
                      :db/cardinality :db.cardinality/one} 
                     {:db/ident       :post/status+published-at
                      :db/valueType   :db.type/tuple
                      :db/tupleAttrs  [:post/status :post/published-at]
                      :db/cardinality :db.cardinality/one
                      :db/index       true}])

  @(d/transact conn [{:post/uuid #uuid "00000000-0000-0000-0000-000000000001"
                      :post/status :published
                      :post/published-at #inst "2024-11-30T21:00:01+04:00"}
                     {:post/uuid #uuid "00000000-0000-0000-0000-000000000002"
                      :post/status :published
                      :post/published-at #inst "2024-11-30T21:00:02+04:00"}
                     {:post/uuid #uuid "00000000-0000-0000-0000-000000000003"
                      :post/status :draft
                      :post/published-at #inst "2024-11-30T21:00:03+04:00"}])


  (d/index-pull (d/db conn)
                {:index :avet
                 :selector '[:post/uuid]
                 :start [:post/status+published-at
                         [:published #inst "2024-11-30T21:00:00+04:00"]]})
  ;; => (#:post{:uuid #uuid "00000000-0000-0000-0000-000000000001"}
  ;;     #:post{:uuid #uuid "00000000-0000-0000-0000-000000000002"})
,,,)