Download the PHP package sheltie/simp-ddl-db without Composer

On this page you can find all versions of the php package sheltie/simp-ddl-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

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:
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.
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 simp-ddl-db

SimpDdlDb

基于映射文件的数据库DDL操作脚本工具

工具介绍

我开发这个工具是为了解决PHP语言小团队开发过程中,对数据表DDL操作过多细碎又在发布的时候容易忘记的情况。比如将半个月前测试完的分支领导吩咐今天发布到生产的时候会忘了具体是哪个字段的变更、加了索引、建了新表等,又或者功能是组员A开发的,组员B来操作发布,故而并不知道里面的数据表修改。我认为这这很不效率。此工具为解决这个痛点而诞生。在使用工具中如遇到任何bug或者体验优化还请联系我。

注意:本工具不支持删表、删索引、删字段等任何删除操作。

一条命令更新表结构

自定义的命令文件位置运行如下命令,即同步数据表字段的DDL操作到当前环境的数据库

安装

通过 Composer 安装:

使用示例

将demo.php拷贝到项目根目录上,或者复制以下代码在根目录下创建一个php文件,文件名自定义。内容都是一样的。

使用说明

初始化

第一次时候的时候必须要先将数据表生成映射文件

运行成功完成后,在demo.php同级目录下会生成dbMap目录,目录内就是当前数据库链接的所有数据表映射文件。

修改表字段

原来的映射文件内的表结构。表名:df_user_sales,映射文件路径: ./dbMap/df/user/df_user_sales.php

修改后的映射文件表结构

在cli命令行上运行修改命令

或者

会看到命令窗口显示(例)

dbMap映射文件说明

如果您发现了 bug 或者有任何建议,请提交一个 issue 或者 fork 这个项目并提交一个 pull request。


All versions of simp-ddl-db with dependencies

PHP Build Version
Package Version
Requires php Version >=7.2.5
ext-pdo Version *
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package sheltie/simp-ddl-db contains the following files

Loading the files please wait ....