Index: Makefile ================================================================== --- Makefile +++ Makefile @@ -300,10 +300,19 @@ chmod a+x $@ $(PREFIX)/bin/mtrunner : utils/mtrunner $(INSTALL) $< $@ chmod a+x $@ + +$(PREFIX)/bin/mt-old-to-new.sh : utils/mt-old-to-new.sh + $(INSTALL) $< $@ + chmod a+x $@ + +$(PREFIX)/bin/mt-new-to-old.sh : utils/mt-new-to-old.sh + $(INSTALL) $< $@ + chmod a+x $@ + deploytarg/nbfake : utils/nbfake $(INSTALL) $< $@ chmod a+x $@ @@ -346,10 +355,11 @@ install : $(PREFIX)/bin/.$(ARCHSTR) $(PREFIX)/bin/.$(ARCHSTR)/mtest $(PREFIX)/bin/megatest \ $(PREFIX)/bin/.$(ARCHSTR)/dboard $(PREFIX)/bin/dashboard $(HELPERS) $(PREFIX)/bin/nbfake \ $(PREFIX)/bin/.$(ARCHSTR)/mtexec $(PREFIX)/bin/mtexec $(PREFIX)/bin/serialize-env \ $(PREFIX)/bin/nbfind $(PREFIX)/bin/mtrunner $(PREFIX)/bin/viewscreen $(PREFIX)/bin/mt_xterm \ + $(PREFIX)/bin/mt-old-to-new.sh $(PREFIX)/bin/mt-new-to-old.sh \ $(PREFIX)/share/docs/megatest_manual.html $(PREFIX)/bin/remrun \ $(PREFIX)/share/docs/megatest_manual.html $(PREFIX)/bin/remrun $(PREFIX)/bin/mtutil \ $(PREFIX)/bin/tcmt $(PREFIX)/share/db/mt-pg.sql \ $(PREFIX)/share/js/jquery-3.1.0.slim.min.js \ $(PREFIX)/bin/.$(ARCHSTR)/lib/libpangox-1.0.so \ ADDED utils/mt-new-to-old.sh Index: utils/mt-new-to-old.sh ================================================================== --- /dev/null +++ utils/mt-new-to-old.sh @@ -0,0 +1,8 @@ +#!/bin/bash + +cp .db/main.db megatest.db + +for db in $(ls .db/?.db); do + echo $db + sqlite3 $db "SELECT * FROM tests" | sqlite3 megatest.db ".import /dev/stdin tests" +done ADDED utils/mt-old-to-new.sh Index: utils/mt-old-to-new.sh ================================================================== --- /dev/null +++ utils/mt-old-to-new.sh @@ -0,0 +1,28 @@ +#!/bin/bash + +mkdir -p .db +cp megatest.db .db/main.db +sqlite3 .db/main.db << END_SQL +delete from tests; +delete from test_steps; +END_SQL +version_id=$(sqlite3 .db/main.db "select id from metadat where var = 'MEGATEST_VERSION'") +current_version=$(megatest -version) +sqlite3 .db/main.db "replace into metadat (id,var,val) values($version_id,'MEGATEST_VERSION','$current_version')" + + +sqlite3 megatest.db 'select id from runs' > runs.txt +for run in $(cat runs.txt) +do + dbnum=$(($run%100)) + cp megatest.db .db/$dbnum.db + sqlite3 .db/$dbnum.db << END_SQL + delete from tests where run_id != $run; + delete from test_data; + delete from test_meta; + delete from test_rundat; + delete from test_steps where not exists ( select id from tests where tests.id = test_steps.test_id); + replace into metadat (id,var,val) values($version_id,'MEGATEST_VERSION','$current_version'); +END_SQL +done +