2022-08-30 datascript | Clojure Slack Archive

datascript

Drew Verlee 2022-08-30T20:25:41.319809Z

I'm trying to understand what this error is telling me i need to do

;; => #error {:message "Conflicting upsert: \"-12\" resolves both to 4 and 25", :data {:error :transact/upsert}}

-12 is a temporary id, are 4 and 25 supposed to be entity ids?

Drew Verlee 2022-08-30T20:27:08.220139Z

is it saying that -12 has matched two entities that it should be associated with?

Drew Verlee 2022-08-30T20:31:16.186279Z

yeah, that would seem to be the case...

Drew Verlee 2022-08-30T20:35:18.487989Z

I was hoping that two entities with different tempids but a shared unique identity attribute (e.g server.db/id would merge, rather then confict.

;; => [[:db/add "-12" :user/roles :sponsor 536870913 true]
  ;;     [:db/add "-12" :centriq.sync.remote.server.db/id "316659348808228"]]

  ;; => [[:db/add "-4" :user/roles :admin 536870913 true]
  ;;     [:db/add "-4" :centriq.sync.remote.server.db/id "316659348808228"]]

  ;; => [[:db/add
  ;;      "-25"
  ;;      :user/roles
  ;;      :centriq-web.data-browser/edit-field
  ;;      536870913
  ;;      true]
  ;;     [:db/add "-25" :centriq.sync.remote.server.db/id "316659348808228"]]

Drew Verlee 2022-08-30T20:37:18.177669Z

i guess another way to do this is to just map the server ids to shorter ids on the client. then map back when i send to the server.

Drew Verlee 2022-08-30T20:41:46.169519Z

Though, if i just transact that information by itself, not as part of the much larger transaction that throws, it doesnt throw.

(def a-tx (concat
             [[:db/add "-12" :user/roles :sponsor 536870913 true]
              [:db/add "-12" :centriq.sync.remote.server.db/id "316659348808228"]]

             [[:db/add "-4" :user/roles :admin 536870913 true]
              [:db/add "-4" :centriq.sync.remote.server.db/id "316659348808228"]]

             [[:db/add
               "-25"
               :user/roles
               :centriq-web.data-browser/edit-field
               536870913
               true]
              [:db/add "-25" :centriq.sync.remote.server.db/id "316659348808228"]]))

  a-tx

  (def after
    (d/transact! connection
                 a-tx))

  (:tx-data after)
  ;; results...
    [#datascript/Datom [1 :user/roles :sponsor 536870914 true]
     #datascript/Datom [1 :centriq.sync.remote.server.db/id "316659348808228" 536870914 true]
     #datascript/Datom [1 :user/roles :admin 536870914 true]
     #datascript/Datom [1 :user/roles :centriq-web.data-browser/edit-field 536870914 true]]

Drew Verlee 2022-08-30T20:48:32.821809Z

if the temp ids are out of order then it fails ...

(def a-tx (concat
             [[:db/add "-12" :user/roles :sponsor 536870913 true]
               ]
     
             [[:db/add "-4" :user/roles :admin 536870913 true]
              [:db/add "-12" :centriq.sync.remote.server.db/id "316659348808228"] ;;<--- out of order
              [:db/add "-4" :centriq.sync.remote.server.db/id "316659348808228"]]

             [[:db/add
               "-25"
               :user/roles
               :centriq-web.data-browser/edit-field
               536870913
               true]
              [:db/add "-25" :centriq.sync.remote.server.db/id "316659348808228"]]))

Drew Verlee 2022-08-30T21:16:09.913489Z

if i sort them, it works though. so ok, i can do that 🙂

seepel 2022-08-31T21:43:08.425199Z

I'm curious what you mean by sorting them, do you mean to say that this works?

[[:db/add "-4" :user/roles :admin 536870913 true]
 [:db/add "-4" :centriq.sync.remote.server.db/id "316659348808228"]
 [:db/add "-12" :user/roles :sponsor 536870913 true]
 [:db/add "-12" :centriq.sync.remote.server.db/id "316659348808228"]]

but this doesn't?

[[:db/add "-12" :user/roles :sponsor 536870913 true]
 [:db/add "-12" :centriq.sync.remote.server.db/id "316659348808228"]
 [:db/add "-4" :user/roles :admin 536870913 true]
 [:db/add "-4" :centriq.sync.remote.server.db/id "316659348808228"]]

seepel 2022-08-31T21:53:02.297639Z

For what it's worth, the way I am handling this is that if I am trying to send datoms to the client from the server, I loop through the datoms collecting a mapping of tempid to serverid. What I send to the client is to first set the :server/id for the set of tempids that I'm working with, then in the datoms themselves I use a lookup by :server/id.

(datoms->client 
  [[316659348808228 :user/roles :admin 536870913 true]
   [316659348808228 :user/roles :sponsor 536870913 true]])
=> [[:db/add -1 :server/id 316659348808228]
    [:db/add [:server/id 316659348808228] :user/roles :admin 536870913 true]
    [:db/add [:server/id 316659348808228] :user/roles :sponsor 536870913 true]]

I also need to make sure I look at the schema to see if I also need to convert any values that are :db.type/ref

[:db/add [:server/id 316659348808228] :some/ref [:server/id 316659348808229]]

Also note that a ref could appear in a tuple, I've been avoiding using tuples for anything other than uniqueness because I haven't sorted out how that should work in datascript yet.

seepel 2022-08-31T21:57:27.874159Z

Btw, I use the lookup because you can't retract a tempid like this

[:db/retract -1 :user/roles]

Lots of details 🙂

Drew Verlee 2022-08-31T22:52:26.078279Z

@sean888 When i said "out of order" i should have said "not grouped" (as it's more specific). So "1 1 2" will work but not "1 2 1". I think i was rather tried when i typed that message, and the error was eating up 90% of my brain.

seepel 2022-09-01T00:44:41.172019Z

> When i said "out of order" i should have said "not grouped" (as it's more specific). So "1 1 2" will work but not "1 2 1". So both of my examples work? > I think i was rather tried when i typed that message, and the error was eating up 90% of my brain. Oh yeah, I've been there 🙂

Drew Verlee 2022-09-01T00:48:11.034889Z

Yes, i believe both would work. But i didn't check.

seepel 2022-09-01T01:23:59.521989Z

Got it, thanks! I'm always wondering what kind of idiosyncrasies I'm going to find between datascript and datomic.

Clojurians Log v2

datascript