I really wish I'd added a :db/unique :db.unique/identity to an attribute but it's too late as there are multiple values in the current set of database assertions -- I tried retracting all but one of those assertions but to no avail, is there anything I can do ?

have you seen https://docs.datomic.com/cloud/schema/schema-change.html#sec-5?

does you attribute use :db.cardinality/one?

yes, but the 2nd condition in the green box is not met

is there any reason you cannot remove the duplicate values?

as I said - I tried retracting them

and the values are unique afterwards?

Has anyone setup CI to push/deploy Ions yet? If so, anything to watch out for? How do you do auth for the CLI in the CI env?

ok - I think I've found a way: I renamed the offending attribute :old-attribute-name and asserted the attribute again with the unique constraint, which works, thereafter one has only has the small inconvenience of having to specify the attribute in one's queries (to prevent assertions for the old one appearing)

and naturally I have to assert the latest values of the old attribute on the new one

but that's ok

really dumb question, but I’m drawing a blank today: how do you programmatically build a query that takes a UUID string as parameter?

(d/q '{:find [?n] :in [$ ?uuid] :where [[?n :uuid ?uuid]]} (d/db conn) uuid)

- programmatically manipulate the map as you wish

looks like what I’m trying, but that doesn’t work. I can run it in the console with [?e :org/id #uuid "string"] , but without the reader tag in my query it won’t match.

try (UUID/fromString uuid-string)

I think that’s what I’m looking for, but somehow that’s not working.

(d/q '[:find ?org .
                   :in $ ?orgId
                   :where [?org :organization/id (UUID/fromString ?orgId)]]
                 db orgId )

do the UUID/fromString outside the query

outside the :where clause I mean

db (UUID/fromString orgId)

or pass in a UUID not a string

right. That works! Thanks!

better to pass in UUIDs

unfortunately coming in from graphql /js so it’ll be a string, but easily managed.

convert elsewhere before using in query

cleaner

stillsuit has a custom scalar for that https://github.com/workframers/stillsuit/blob/51064573edab7a3f03f54f23c632aeb87f243fa4/resources/stillsuit/base-schema.edn#L40

hmmm… wonder why stillsuit isn’t picking it up right then

I’m having trouble getting a postgres backend setup. the jdbc uri looks ok but when I try to backup from s3 computer says no

bin/datomic -Xmx1g -Xms1g restore-db  'jdbc:'
java.lang.IllegalArgumentException: :db.error/invalid-db-uri Invalid database URI jdbc:

datomic:sql://{db-name}?{jdbc-url}

and IIRC the jdbc-url has to be URL-encoded

👍 solved it - was missing the datomic:sql://? before jdbc…

argg. I managed to restore the database under the name '' (empty string) and I can’t restore it again. Struggling to delete or rename it. :restore/collision The database already exists under the name ''

you can delete the postgres table and recreate it