Laravel SQLAnyWhere

Adds an Sybase driver to Laravel 5.7 and above (tested with 5.7, 6.0 and 7.0) usable with Fluent and Eloquent.

Attention

The latest version only works with Laravel 5.7 and higher. For lower version use version 1.4.1.

Todo

• Migrate integration is not 100%
• Find bugs

Installation

Add emericklaw/laravel-sqlanywhere as a requirement to composer.json:

{
    "require": {
        ...
        "emericklaw/sql-anywhere-client": "dev-master",
        "emericklaw/laravel-sqlanywhere": "dev-master"
    },
    "repositories": [
        {
            "type": "package",
            "package": {
                "name": "emericklaw/sql-anywhere-client",
                "version": "dev-master",
                "dist": {
                    "url": "https://github.com/emericklaw/sql-anywhere-client/zipball/master",
                    "type": "zip"
                },
                "autoload": {
                    "psr-0": { "emericklaw": "src/" }
                }
            }
        },
        {
            "type": "package",
            "package": {
                "name": "emericklaw/laravel-sqlanywhere",
                "version": "dev-master",
                "dist": {
                    "url": "https://github.com/emericklaw/laravel-sqlanywhere/zipball/master",
                    "type": "zip"
                },
                "autoload": {
                    "psr-0": { "emericklaw\\SQLAnywhere": "src/" }
                }
            }
        }
    ],
}

Update your packages with composer update or install with composer install.

Once Composer has installed or updated your packages you need to register LaravelODBC and the package it uses (extradb) with Laravel itself. Open up config/app.php and find the providers key towards the bottom.

Add the following to the list of providers:

emericklaw\SQLAnywhere\SQLAnywhereServiceProvider::class,

You won't need to add anything to the aliases section.

Configuration

The login parameters could be set inside the .env file.

DB_SQLA_HOST     = hostname
DB_SQLA_PORT     = 2638
DB_SQLA_SERVER   = dbdemo
DB_SQLA_DATABASE = dbname
DB_SQLA_USERNAME = dbuser
DB_SQLA_PASSWORD = dbpwd

Just add a new array to the connections array in config/database.php.

'sqlanywhere' => [
    'host'        => env('DB_SQLA_HOST', 'localhost'),
    'port'        => env('DB_SQLA_PORT', '2638'),
    'dbserver'    => env('DB_SQLA_SERVER', 'dbdemo'),
    'database'    => env('DB_SQLA_DATABASE', 'dbname'),
    'username'    => env('DB_SQLA_USERNAME', 'dbuser'),
    'password'    => env('DB_SQLA_PASSWORD', 'dbpwd'),
    'charset'     => 'utf8',
    'prefix'      => '',
    'auto_commit' => true,
    'persintent'  => false,
]

Don't forget to update your default database connection.