SQLite

安装 SQLite 。

新建文件

# book.ps1

sqlite3 'C:\ecs-user\dev.db' '.mode json' 'SELECT COUNT(*) AS cnt FROM book WHERE status = 1;'

sqlite3 'C:\ecs-user\dev.db' '.mode json' 'SELECT id, bookName FROM book WHERE status = 1;' > 'C:\ecs-user\book.json'

运行文件

pwsh book.ps1

有 SQL 文件

-- update.sql

UPDATE book SET status = 2, updatedAt = '2049-01-01T12:00:00.000Z' WHERE id = 1;
UPDATE book SET status = 2, updatedAt = '2049-01-01T12:00:00.000Z' WHERE id = 2;
UPDATE book SET status = 2, updatedAt = '2049-01-01T12:00:00.000Z' WHERE id = 3;

修改数据库

sqlite3 'C:\ecs-user\dev.db' < 'C:\ecs-user\update.sql'