Download the PHP package patabugen/laravel-mssql-changes without Composer

On this page you can find all versions of the php package patabugen/laravel-mssql-changes. 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?

Example code of patabugen/laravel-mssql-changes

Informations about the package laravel-mssql-changes

A package to manage Change Tracking and view changes in Microsoft's SQL Server (2008) from Laravel

Latest Version on Packagist GitHub Tests Action Status GitHub Code Style Action Status Total Downloads

Manage tracked changes in Microsoft SQLServer, letting you list changes from Artisan and inside your Laravel application.

This package was written to read tracked changes from MSSQL 2008 and has not been tested on other versions.

Note: This library is for Change Tracking which is distinct from Change Data Capture (CDC).

Installation

You can install the package via composer:

You can publish the config file with:

Usage

The package provides artisan commands as well as a programmatic interface.

Usage - PHP

Features are provided by Actions, which are used by Artisan commands to give us CLI access.

See the asCommand method on each action for real-life examples of calling the library from PHP.

Get all changes for a table

Get all changes for a table filtered by version

Usage - Artisan

Note: This package is in it's early stages, these commands may not work yet.

The default database from your config will be used, or set environment variable MSSQL_CHANGES_CONNECTION to the name of the connection to use.

Enable change tracking for the database

artisan mssql:enable-database-change-tracking

Enable change tracking for a table

artisan mssql:enable-table-change-tracking {TableName}

Disable change tracking for a table

artisan mssql:disable-table-change-tracking {TableName}

Lists all changes in all tables.

artisan mssql:show-changes

Filter Changes by table

artisan mssql:show-table-changes {tableName}

Filter changes by Version

Use --from and/or --to to only show changes before or after a given change (inclusive).

artisan mssql:show-changes --from=200 --to=209 artisan mssql:show-table-changes --from=200 --to=209

Todo

I'd like to add these commands or features:

Testing

You'll need a running instance of SQL server with a database already created, see phpunit.xml.dist for default values. Copy it to phpunit.xml to customise the tests.

If you have not already, you may need to take extra steps to allow your PHP to connect to MSSQL.

Note: At the time of writing the tests are not fully functional because I've started getting them to create a test database, but not finished it. You may be able to remove the migrations/setup from TestCase and manually create a table called "Contacts" with tracking enabled.

The tests also have some hard-coded numbers which mean they'll break often. That can be solved by finishing the above so RefreshDatabase works, or by using GetVersion to filter the results within each test before making assertions.

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

This package has been created to solve a specific issue in a one-off project so is not likely to receive long term updates.

I've released it as a package in case it might help somebody else one day.

Pull requests are very welcome, especially if they include tests or round out existing/core features. Feel free to submit an issue to discuss a change you'd like.

Credits

License

The MIT License (MIT). Please see License File for more information.

All versions of laravel-mssql-changes with dependencies

PHP Build Version
Package Version
Requires php Version ^8.0
illuminate/contracts Version ^9.0|^10.0
lorisleiva/laravel-actions Version ^2.4
spatie/laravel-package-tools Version ^1.13.0
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 patabugen/laravel-mssql-changes contains the following files

Loading the files please wait ....