copywriting_production

prefect

# https://docs.prefect.io/v3/how-to-guides/self-hosted/server-cli#use-postgresql
prefect config set PREFECT_API_DATABASE_CONNECTION_URL="postgresql+asyncpg://prefect:prefect123@sv-v2:5435/prefect"
prefect config view
prefect server start --host pc.lan
# http://pc.lan:4200/deployments

uv pip install universal_pathlib

备份数据库

下载： https://www.mongodb.com/try/download/database-tools 文档 ： https://www.mongodb.com/docs/database-tools/

cd G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin

$timestr = Get-Date -Format "yyyyMMdd_HH_mm_ss";G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongodump.exe --uri="mongodb://sv-v2:27017" -o I:\eng\backup\mongo\$timestr

# 首先要加载 env 变量， J:\eng-sftp\nextcloud\eng\my-document\restic.md
restic backup G:\code\amazone\copywriting_production\output\mongodb_backup
restic snapshots -H pc
restic ls -l 04c9313f

备份集合到另一个数据库

G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongodump.exe --uri="mongodb://sv-v2:27017/amazone" --collection=Product -o G:\code\amazone\copywriting_production\output\temp
$timestr = Get-Date -Format "yyyyMMdd_HH_mm_ss"
echo $timestr
# 恢复到 test 数据库
G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongorestore.exe --uri="mongodb://sv-v2:27017/test" "I:\eng\backup\mongo\20250327_01_04_08\amazone\Product.bson"

G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongorestore.exe --uri="mongodb://mrh:123@sv-v2:27017" "I:\eng\backup\mongo\20250331_14_14_17"
G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongorestore.exe --uri="mongodb://sv-v2:27017/backup_amazone" --collection=Product G:\code\amazone\copywriting_production\output\temp
mongoimport --uri="mongodb://sv-v2:27017" --collection=users --file=G:\code\amazone\copywriting_production\output\mongodb_backup\users.json