7 lines
258 B
Bash
7 lines
258 B
Bash
sqlite3 metadata.db <<'SQL'
|
|
BEGIN;
|
|
UPDATE entry SET sourceRotationDegrees = 90 WHERE origin = 1;
|
|
COMMIT;
|
|
SELECT COUNT(*) AS total_origin_1 FROM entry WHERE origin = 1;
|
|
SELECT COUNT(*) AS now_90 FROM entry WHERE origin = 1 AND sourceRotationDegrees = 90;
|
|
SQL
|