1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
|
(lambda (dbdat db)
(sqlite3:execute (db:get-cache-stmth dbdat db "DELETE FROM metadat WHERE var=?;") var))))
;;======================================================================
;; no-sync.db - small bits of data to be shared between servers
;;======================================================================
(define (db:no-sync-db db-in)
(if db-in
db-in
(if *no-sync-db*
*no-sync-db*
(begin
(mutex-lock! *db-access-mutex*)
(let ((dbpath (common:get-db-tmp-area))
(db (dbfile:open-no-sync-db dbpath)))
(set! *no-sync-db* db)
(mutex-unlock! *db-access-mutex*)
db)))))
(define (with-no-sync-db proc)
(let* ((db (db:no-sync-db *no-sync-db*)))
(proc db)))
(define (db:open-no-sync-db)
(dbfile:open-no-sync-db (db:dbfile-path)))
(define (db:no-sync-close-db db stmt-cache)
(db:safely-close-sqlite3-db db stmt-cache))
;; use a global for some primitive caching, it is just silly to
;; re-read the db over and over again for the keys since they never
|
>
>
>
>
>
>
>
|
|
|
|
|
|
|
|
|
>
|
|
|
|
|
|
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
|
(lambda (dbdat db)
(sqlite3:execute (db:get-cache-stmth dbdat db "DELETE FROM metadat WHERE var=?;") var))))
;;======================================================================
;; no-sync.db - small bits of data to be shared between servers
;;======================================================================
(define (db:get-dbsync-path)
(case (rmt:transport-mode)
((http)(common:get-db-tmp-area))
((tcp) (conc *toppath*"/.megatest"))
((nfs) (conc *toppath*"/.megatest"))
(else "/tmp/dunno-this-gonna-exist")))
;; (define (db:no-sync-db db-in)
;; (if db-in
;; db-in
;; (if *no-sync-db*
;; *no-sync-db*
;; (begin
;; (mutex-lock! *db-access-mutex*)
;; (let ((dbpath (db:get-dbsync-path))
;; (db (dbfile:open-no-sync-db dbpath)))
;; (assert (sqlite3:database? db) "FATAL: db:no-sync-db failed to open a database")
;; (set! *no-sync-db* db)
;; (mutex-unlock! *db-access-mutex*)
;; db)))))
(define (with-no-sync-db proc)
(let* ((db (db:open-no-sync-db)))
(proc db)))
(define (db:open-no-sync-db)
(dbfile:open-no-sync-db (db:get-dbsync-path)))
(define (db:no-sync-close-db db stmt-cache)
(db:safely-close-sqlite3-db db stmt-cache))
;; use a global for some primitive caching, it is just silly to
;; re-read the db over and over again for the keys since they never
|