Download the PHP package jcbowen/mysql-helper-yii2 without Composer
On this page you can find all versions of the php package jcbowen/mysql-helper-yii2. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download jcbowen/mysql-helper-yii2
More information about jcbowen/mysql-helper-yii2
Files in jcbowen/mysql-helper-yii2
Download jcbowen/mysql-helper-yii2
More information about jcbowen/mysql-helper-yii2
Files in jcbowen/mysql-helper-yii2
Vendor jcbowen
Package mysql-helper-yii2
Short Description 基于yii2的mysql维护助手，可以将表结构以数组方式储存下来，也可以轻松实现表的差异对比及生成对应的修复sql语句
License MIT
Package mysql-helper-yii2
Short Description 基于yii2的mysql维护助手，可以将表结构以数组方式储存下来，也可以轻松实现表的差异对比及生成对应的修复sql语句
License MIT
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package mysql-helper-yii2
MySQL Helper Yii2
基于 Yii2 的 MySQL 维护助手，提供数据库表结构管理、差异对比、修复 SQL 生成等功能。支持多模块项目的模型目录配置，适用于复杂的 Yii2 高级模板项目。
功能特性
- 🔍 数据库结构管理 - 获取、存储和比较数据库表结构
- 🔄 差异检测 - 自动检测表结构变化并生成修复 SQL
- 📝 SQL 生成 - 生成建表、修改、删除等 SQL 语句
- 🎯 多目录支持 - 支持配置多个模型目录（适用于 Yii2 高级模板）
- 🛠️ 命令行工具 - 提供便捷的命令行操作接口
- 🔒 向后兼容 - 保持与现有配置的兼容性
系统要求
- PHP >= 7.2.0
- Yii2 >= 2.0.11
- jcbase-yii2 >= 0.28.0
安装
快速开始
1. 基本使用
2. 表结构比较和修复
3. 命令行工具
详细功能
MysqlHelper 类
数据库操作
表结构操作
差异对比和修复
数据操作
MakeController 类
配置选项
多目录配置示例
使用场景
1. 数据库结构版本管理
2. 多模块项目支持
3. 自定义数据插入
命令行选项
make/check 命令
make/db 命令
注意事项
- 表前缀处理：工具会自动处理 Yii2 的表前缀配置
- 字段默认值：已有字段如果之前被设置为 NULL，后续在设置基准表时，一定不要设置为 NOT NULL，否则会报错
- 目录验证：多目录配置会自动验证目录存在性，不存在的目录会被跳过并显示警告
- 性能考虑：大量目录可能影响扫描性能，建议合理配置
错误处理
当遇到目录不存在时，会显示类似以下的警告信息：
该警告不会中断程序执行，会继续扫描其他有效目录。
示例和文档
- 基本使用示例 - PHP 代码使用示例
- 命令行使用示例 - 命令行工具使用指南
- 项目功能概览 - 详细的功能和架构说明
贡献
欢迎提交 Issue 和 Pull Request 来改进这个项目。
许可证
本项目基于 MIT 许可证开源。
作者
- Bowen - [email protected]
更新日志
v0.x-dev
- ✨ 新增多模型目录支持功能
- 🔧 优化表结构扫描逻辑
- 📝 完善文档和注释
- 🐛 修复向后兼容性问题
- 📚 新增详细的使用示例和文档
All versions of mysql-helper-yii2 with dependencies
PHP Build Version
Package Version
Requires
php Version
>=7.2.0 <8.0.0
yiisoft/yii2 Version ^2.0.11
jcbowen/jcbase-yii2 Version ^0.x-dev || >=0.30.3
yiisoft/yii2 Version ^2.0.11
jcbowen/jcbase-yii2 Version ^0.x-dev || >=0.30.3
The package jcbowen/mysql-helper-yii2 contains the following files
Loading the files please wait ...