Download the PHP package agashe/sigmaphp-db without Composer
On this page you can find all versions of the php package agashe/sigmaphp-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
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 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.
Informations about the package sigmaphp-db
SigmaPHP-DB
SigmaPHP-DB is a collection of PHP Database Tools. That support primarily MySQL RDBMS (Other RDBMS support will be added in future). Including migrations with rollback , seeding , query builder , ORM and much more , all these features can be used through an elegant CLI script in your terminal.
Installation
Configurations
After installation , you should create a new config file , to include your database connection parameters , and also edit other options like migrations / seeders paths.
To generate new config file , run the following command :
A new config file with name database.php wil be created in the root of your project's directory.
You can simply change the name and the location of the config file , but this will require you , to pass the config file path , when use the CLI script :
Documentation
CLI Usage
In the table below , you can find all available commands :
| Command | Description |
| create:config {path} | Create new config file, if no path was provided , a default config file (database.php) will be created in the root of the project's folder. |
| create:migration {migration name} | Create new migration file. It's recommended for the migration file to follow class naming rules , like using only nouns and PascalCase .. etc. Also no need to add .php extension , "Migration.php". will be appended automatically to the file name. |
| create:model {model name} | Create new model class. In addition this command will generate a migration file for creating the corresponding table. |
| create:seeder {seeder name} | Create new seeder file. Please note that , the same rules for naming the migration file is also applied to the seeder. |
| drop | Drop all tables in the database. A confirmation message will ask you to confirm before executing this command. |
| fresh | Drop all tables in the database. then will run all migrations and seed the database. (will ask for confirmation) |
| help | Print a list by all available commands. |
| migrate {migration name} | Run all migrations files. Optionally you can pass migration file name , to run specific migration. |
| rollback {date} | Rollback latest migration. or choose specific date to rollback to. |
| seed {seeder name} | Run seeders. or run specific seeder. |
| version | Print the current version of SigmaPHP-DB Package. |
| truncate | Delete the data in all tables. (will ask for confirmation) |
And here few examples on how to use the commands:
License
(SigmaPHP-DB) released under the terms of the MIT license.
