Skip to content

Instantly share code, notes, and snippets.

@seantempesta

seantempesta/posh-not-updating.cljs

Created July 9, 2016 15:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save seantempesta/7575b72192767a48e0b6f40fba495063 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save seantempesta/7575b72192767a48e0b6f40fba495063 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
posh-not-updating.cljs
(def sample-data '(#datascript/Datom [1 :attendance/checkInTime "2016-07-08T08:27:50.778Z" "536870913" true] #datascript/Datom [1 :attendance/group 16 "536870913" true] #datascript/Datom [1 :attendance/participant 17 "536870913" true] #datascript/Datom [2 :group/absentAfterMinutes 15 "536870913" true] #datascript/Datom [2 :group/endTimeHour 2 "536870913" true] #datascript/Datom [2 :group/endTimeMinute 51 "536870913" true] #datascript/Datom [2 :group/latePickupAfterMinutes 15 "536870913" true] #datascript/Datom [2 :group/name "Group 1" "536870913" true] #datascript/Datom [2 :group/participants 3 "536870913" true] #datascript/Datom [2 :group/participants 8 "536870913" true] #datascript/Datom [2 :group/participants 38 "536870913" true] #datascript/Datom [2 :group/participants 45 "536870913" true] #datascript/Datom [2 :group/participants 58 "536870913" true] #datascript/Datom [2 :group/startTimeHour 1 "536870913" true] #datascript/Datom [2 :group/startTimeMinute 51 "536870913" true] #datascript/Datom [3 :participant/dateAdded "2016-04-11T12:39:59.857Z" "536870913" true] #datascript/Datom [3 :participant/firstName "Nico" "536870913" true] #datascript/Datom [3 :participant/grade 10 "536870913" true] #datascript/Datom [3 :participant/lastName "Wisozk" "536870913" true] #datascript/Datom [3 :participant/parentEmail "[email protected]" "536870913" true] #datascript/Datom [3 :participant/parentFirstName "Perry" "536870913" true] #datascript/Datom [3 :participant/parentLastName "Parker" "536870913" true] #datascript/Datom [3 :participant/parentPhone "(362) 629-0245" "536870913" true] #datascript/Datom [3 :participant/photo "https://s3.amazonaws.com/uifaces/faces/twitter/sgaurav_baghel/128.jpg" "536870913" true] #datascript/Datom [3 :participant/school "School Name Goes Here" "536870913" true] #datascript/Datom [3 :participant/teacherEmail "[email protected]" "536870913" true] #datascript/Datom [3 :participant/teacherFirstName "Xzavier" "536870913" true] #datascript/Datom [3 :participant/teacherLastName "Johnson" "536870913" true] #datascript/Datom [3 :participant/teacherPhone "(862) 942-7241" "536870913" true] #datascript/Datom [4 :group/absentAfterMinutes 15 "536870913" true] #datascript/Datom [4 :group/endTimeHour 3 "536870913" true] #datascript/Datom [4 :group/endTimeMinute 53 "536870913" true] #datascript/Datom [4 :group/latePickupAfterMinutes 15 "536870913" true] #datascript/Datom [4 :group/name "Group 2" "536870913" true] #datascript/Datom [4 :group/participants 5 "536870913" true] #datascript/Datom [4 :group/participants 8 "536870913" true] #datascript/Datom [4 :group/participants 10 "536870913" true] #datascript/Datom [4 :group/participants 12 "536870913" true] #datascript/Datom [4 :group/participants 15 "536870913" true] #datascript/Datom [4 :group/participants 17 "536870913" true] #datascript/Datom [4 :group/participants 24 "536870913" true] #datascript/Datom [4 :group/participants 27 "536870913" true] #datascript/Datom [4 :group/participants 33 "536870913" true] #datascript/Datom [4 :group/participants 43 "536870913" true] #datascript/Datom [4 :group/participants 49 "536870913" true] #datascript/Datom [4 :group/participants 50 "536870913" true] #datascript/Datom [4 :group/participants 51 "536870913" true] #datascript/Datom [4 :group/participants 55 "536870913" true] #datascript/Datom [4 :group/startTimeHour 2 "536870913" true] #datascript/Datom [4 :group/startTimeMinute 53 "536870913" true] #datascript/Datom [5 :participant/dateAdded "2015-12-09T12:34:30.917Z" "536870913" true] #datascript/Datom [5 :participant/firstName "Pearline" "536870913" true] #datascript/Datom [5 :participant/grade 1 "536870913" true] #datascript/Datom [5 :participant/lastName "Johnston" "536870913" true] #datascript/Datom [5 :participant/parentEmail "[email protected]" "536870913" true] #datascript/Datom [5 :participant/parentFirstName "Chesley" "536870913" true] #datascript/Datom [5 :participant/parentLastName "Hegmann" "536870913" true] #datascript/Datom [5 :participant/parentPhone "(341) 996-1578" "536870913" true] #datascript/Datom [5 :participant/photo "https://s3.amazonaws.com/uifaces/faces/twitter/sandywoodruff/128.jpg" "536870913" true] #datascript/Datom [5 :participant/school "School Name Goes Here" "536870913" true] #datascript/Datom [5 :participant/teacherEmail "[email protected]" "536870913" true] #datascript/Datom [5 :participant/teacherFirstName "Gia" "536870913" true] #datascript/Datom [5 :participant/teacherLastName "Dare" "536870913" true] #datascript/Datom [5 :participant/teacherPhone "(924) 502-1240" "536870913" true] #datascript/Datom [6 :attendance/checkInTime "2016-07-08T08:27:50.762Z" "536870913" true] #datascript/Datom [6 :attendance/group 4 "536870913" true] #datascript/Datom [6 :attendance/participant 5 "536870913" true] #datascript/Datom [7 :attendance/checkInTime "2016-07-08T08:27:50.765Z" "536870913" true] #datascript/Datom [7 :attendance/group 4 "536870913" true] #datascript/Datom [7 :attendance/participant 8 "536870913" true] #datascript/Datom [8 :participant/dateAdded "2015-11-23T23:03:42.906Z" "536870913" true] #datascript/Datom [8 :participant/firstName "Nigel" "536870913" true] #datascript/Datom [8 :participant/grade 8 "536870913" true] #datascript/Datom [8 :participant/lastName "Gorczany" "536870913" true] #datascript/Datom [8 :participant/parentEmail "[email protected]" "536870913" true] #datascript/Datom [8 :participant/parentFirstName "Caterina" "536870913" true] #datascript/Datom [8 :participant/parentLastName "Schamberger" "536870913" true] #datascript/Datom [8 :participant/parentPhone "(411) 052-3083" "536870913" true] #datascript/Datom [8 :participant/photo "https://s3.amazonaws.com/uifaces/faces/twitter/michaelbrooksjr/128.jpg" "536870913" true] #datascript/Datom [8 :participant/school "School Name Goes Here" "536870913" true] #datascript/Datom [8 :participant/teacherEmail "[email protected]" "536870913" true] #datascript/Datom [8 :participant/teacherFirstName "Karianne" "536870913" true] #datascript/Datom [8 :participant/teacherLastName "Nicolas" "536870913" true] #datascript/Datom [8 :participant/teacherPhone "(945) 356-2608" "536870913" true] #datascript/Datom [9 :attendance/checkInTime "2016-07-08T08:27:50.767Z" "536870913" true] #datascript/Datom [9 :attendance/group 4 "536870913" true] #datascript/Datom [9 :attendance/participant 10 "536870913" true] #datascript/Datom [10 :participant/dateAdded "2016-04-10T19:27:16.873Z" "536870913" true] #datascript/Datom [10 :participant/firstName "Reymundo" "536870913" true] #datascript/Datom [10 :participant/grade 6 "536870913" true] #datascript/Datom [10 :participant/lastName "Brown" "536870913" true] #datascript/Datom [10 :participant/parentEmail "[email protected]" "536870913" true] #datascript/Datom [10 :participant/parentFirstName "Meggie" "536870913" true] #datascript/Datom [10 :participant/parentLastName "Balistreri" "536870913" true] #datascript/Datom [10 :participant/parentPhone "(189) 156-4582" "536870913" true] #datascript/Datom [10 :participant/photo "https://s3.amazonaws.com/uifaces/faces/twitter/joaoedumedeiros/128.jpg" "536870913" true] #datascript/Datom [10 :participant/school "School Name Goes Here" "536870913" true] #datascript/Datom [10 :participant/teacherEmail "[email protected]" "536870913" true] #datascript/Datom [10 :participant/teacherFirstName "Jessy" "536870913" true] #datascript/Datom [10 :participant/teacherLastName "Rempel" "536870913" true])
(def query '[:find ?e ?pfn ?pln ?pf ?pda
:where
[?e :participant/firstName ?pfn]
[?e :participant/lastName ?pln]
[?e :participant/photo ?pf]
[?e :participant/dateAdded ?pda]])
(def conn (d/create-conn config/shared-schema))
(posh! conn)
(def before-data (q query conn)) ; #{}
(print (d/q query @conn)) ; #{}. DB is confirmed empty, no results
(d/transact! conn sample-data) ; load some data in
(print @before-data) ; #{}
(print (d/q query @conn)) ; #{[3 "Nico" "Wisozk" ...} Data is there
(def after (q query conn)) ; #{}
(print @after) ; #{}
(def query2 '[:find ?e ?pfn ?pln ?pf ?CHANGED
:where
[?e :participant/firstName ?pfn]
[?e :participant/lastName ?pln]
[?e :participant/photo ?pf]
[?e :participant/dateAdded ?CHANGED]])
(def changed-query (q query2 conn)) ; #{[3 "Nico" "Wisozk" ...} now this works
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment