反英雄 / 挂载最后数据库包
用于挂载来自远程SMB/SFTP服务器的最新.gz sql备份文件的Symfony扩展包。包含备份当前数据库、挂载当前数据库以及将当前数据库复制到测试数据库的命令。
0.3.3
2024-07-15 16:17 UTC
Requires
- php: >=8.1
- ext-ftp: *
- ext-mysqli: *
- ext-zlib: *
- doctrine/doctrine-bundle: 2.*
- doctrine/orm: ^2.16|^3
- icewind/smb: ^3.5
- symfony/config: ^5.4|6.*
- symfony/console: ^5.4|6.*
- symfony/dependency-injection: ^5.4|6.*
- symfony/dotenv: ^5.4|6.*
- symfony/framework-bundle: ^5.4|6.*
- symfony/http-client: ^5.4|6.*
- symfony/http-kernel: ^5.4|6.*
- symfony/process: ^5.4|6.*
Requires (Dev)
- phpstan/phpstan: ^1.10
- symfony/flex: ^2.3
README
Symfony扩展包用于
- 从远程SMB或FTPS服务器挂载最新的.gz sql备份文件并执行。可选执行模式:删除模式(doctrine: schema: drop --force)和迁移执行(d:m:m)
- 复制当前数据库到测试数据库。测试数据库的名称由curDbName + dbSuffix设置。在测试时最好使用与doctrine.yaml中相同的数据库后缀。
- 备份或挂载本地数据库
安装
composer require antihero/mount-last-db-bundle
配置
mount_last_db:
srv_type: ftps|smb
dest_dir: _dump (relative to project root)
file_filter: lhyo_ocf
srv_uri: 192.168.0.92
srv_path: backups
srv_user: USER
srv_pwd: PASS
srv_share: mysql_backups (only for smb)
srv_workgroup: workgroup (only for smb)
php bin/console debug:config mount_last_db
用法
php bin/console ah:mount-last-db
php bin/console ah:mount-db
php bin/console ah:dump-db
php bin/console ah:copy-db-to-test DBSUFFIX