Megatest

Check-in [430f66247c]
Login
Overview
Comment:fixed bug
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | v1.65 | v1.6519
Files: files | file ages | folders
SHA1: 430f66247caec1a031a28b997f05a6f84155adda
User & Date: bjbarcla on 2019-01-23 15:16:50
Other Links: branch diff | manifest | tags
Context
2019-01-25
13:21
pgdb selective sync, copy last update time in tables as is and use the smallest of thoes as area update check-in: ac0148ceaf user: pjhatwal tags: v1.65
2019-01-23
15:16
fixed bug check-in: 430f66247c user: bjbarcla tags: v1.65, v1.6519
12:05
Adding table change_triggers to mt-pg.scm check-in: 1f6bb250f8 user: mrwellan tags: v1.65
Changes

Modified db.scm from [8dc83d05ae] to [911f2e610c].

330
331
332
333
334
335
336


337
338


339
340
341
342
343
344
345
330
331
332
333
334
335
336
337
338


339
340
341
342
343
344
345
346
347







+
+
-
-
+
+







               (write-access (file-write-access? mtdbpath))
	       ;(mtdbmodtime  (if mtdbexists (common:lazy-sqlite-db-modification-time mtdbpath)   #f)) ; moving this before db:open-megatest-db is called. if wal mode is on -WAL and -shm file get created with causing the  tmpdbmodtime timestamp always greater than mtdbmodtime
	       ;(tmpdbmodtime (if dbfexists  (common:lazy-sqlite-db-modification-time tmpdbfname) #f)) 
					;if wal mode is on -WAL and -shm file get created when db:open-megatest-db is called. modtimedelta will always be < 10 so db in tmp not get synced
          ;(tmpdbmodtime (if dbfexists (db:get-last-update-time (car tmpdb)) #f))    
          ;(fmt (file-modification-time tmpdbfname))
	       (modtimedelta (and mtdbmodtime tmpdbmodtime (- mtdbmodtime tmpdbmodtime))))

          (when write-access
          (sqlite3:execute (car mtdb) "drop trigger if exists update_tests_trigger")
          (sqlite3:execute (car mtdb) "drop trigger if exists update_runs_trigger")
            (sqlite3:execute (car mtdb) "drop trigger if exists update_tests_trigger")
            (sqlite3:execute (car mtdb) "drop trigger if exists update_runs_trigger"))
          
         ;(print "mtdbmodtime " mtdbmodtime " tmpdbmodtime " tmpdbmodtime " mtdbpath " mtdbpath " " (conc *toppath* "/megatest.db"))
	        ;;(debug:print-info 13 *default-log-port* "db:open-db>> mtdbpath="mtdbpath" mtdbexists="mtdbexists" and write-access="write-access)
          (if (and dbexists (not write-access))
              (begin
                (set! *db-write-access* #f)
                (dbr:dbstruct-read-only-set! dbstruct #t)))