115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
|
+
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
-
-
+
+
-
-
+
+
-
-
+
+
|
(define (db:run-id->first-num run-id)
(let* ((s (number->string run-id))
(l (string-length s)))
(substring s (- l 1) l)))
;; 1234 => 4/1234.db
;; #f => 0/main.db
;; (abandoned the idea of num/db)
;;
(define (db:run-id->path run-id)
(let ((firstnum (if run-id
(db:run-id->first-num run-id)
"0")))
(conc *toppath* "/.dbs/"firstnum"/"(or run-id "main")".db")))
(define (db:run-id->path apath run-id)
(conc apath"/"(db:run-id->dbname run-id)))
(define (db:dbname->path apath dbname)
(conc apath"/"dbname))
;; (let ((firstnum (if run-id
;; (db:run-id->first-num run-id)
;; "0")))
;; (conc *toppath* "/.dbs/" ;; firstnum"/"
;; (or run-id "main")".db")))
(define (db:run-id->dbname run-id)
(if (number? run-id)
(conc ".db/" (modulo run-id 100) ".db")
(conc ".db/main.db")))
;; record for keeping state,status and count for doing roll-ups in
;; iterated tests
;;
(defstruct dbr:counts
(state #f)
(status #f)
(count 0))
;; Retrieve a dbdat given run-id, open and setup both inmemory and
;; db file if needed
;;
;; if run-id => get run specific db
;; if #f => get main.db
;; if db already open - return inmem
;; if db not open, open inmem, rundb and sync then return inmem
;; inuse gets set automatically for rundb's
;;
(define (db:get-dbdat dbstruct run-id)
(define (db:get-dbdat dbstruct apath run-id)
(let ((dbdat (dbr:dbstruct-get-dbdat dbstruct run-id)))
(if dbdat
dbdat
(let* ((dbfile (db:run-id->path run-id))
(newdbdat (db:open-dbdat run-id db:initialize-db)))
(let* ((dbfile (db:run-id->path apath run-id))
(newdbdat (db:open-dbdat apath run-id db:initialize-db)))
(dbr:dbstruct-dbdat-put! dbstruct run-id newdbdat)
newdbdat))))
;; get the inmem db for actual db operations
;;
(define (db:get-inmem dbstruct run-id)
(dbr:dbdat-inmem (db:get-dbdat dbstruct run-id)))
;; get the handle for the on-disk db
;;
(define (db:get-ddb dbstruct run-id)
(dbr:dbdat-db (db:get-dbdat dbstruct run-id)))
(define (db:get-ddb dbstruct apath run-id)
(dbr:dbdat-db (db:get-dbdat dbstruct apath run-id)))
;; open or create the disk db file
;; create and fill the inmemory db
;; assemble into dbr:dbdat struct and return
;;
(define (db:open-dbdat run-id dbinit-proc)
(let* ((dbfile (db:run-id->path run-id))
(define (db:open-dbdat apath run-id dbinit-proc)
(let* ((dbfile (db:run-id->path apath run-id))
(db (db:open-run-db dbfile dbinit-proc))
(inmem (db:open-inmem-db dbinit-proc))
(dbdat (make-dbr:dbdat
db: db
inmem: inmem
run-id: run-id
fname: dbfile)))
|
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
|
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
|
-
+
-
-
+
+
|
;; sync disk db to inmem
;;
;; called in http-transport and replicated in rmt.scm for *local* access.
;;
(define (db:setup run-id)
(assert *toppath* "FATAL: db:setup called before toppath is available.")
(let* ((dbstruct (make-dbr:dbstruct)))
(db:get-dbdat dbstruct run-id)
(db:get-dbdat dbstruct *toppath* run-id)
(set! *dbstruct-db* dbstruct)
dbstruct))
;;======================================================================
;; setting/getting a lock on the db for only one server per db
;;
;; NOTE:
;; These operate directly on the disk file, NOT on the inmemory db
;; The lockname is the filename (can have many to one, run-id to fname
;;======================================================================
(define (db:get-iam-server-lock dbstruct run-id)
(let* ((dbh (db:get-ddb dbstruct run-id))
(define (db:get-iam-server-lock dbstruct apath run-id)
(let* ((dbh (db:get-ddb apath dbstruct run-id))
(dbfname (db:run-id->path run-id)))
(sqlite3:with-transaction
dbh
(lambda ()
(let* ((locked (db:get-locker dbh dbfname)))
(if (not locked)
(db:take-lock dbh dbfname)))))))
|