Ilan
Ilan

Reputation: 579

CakePHP ORM :: Disconnect database

I'm using the CakePHP ORM package inside a Gearman Worker. Package : https://packagist.org/packages/cakephp/orm

$connectionObject = ConnectionManager::get('Backend');
$usersTable = TableRegistry::get('Users', ['connection' => $connectionObject]);
$countActiveUsers = $usersTable->find()->where(['active' => 1])->count();

I'm trying to find a way to disconnect the database when a job finish to be processed because now, even if there is no job in the queue, the connection between the worker and the database remains open.

Thanks in advance!

Upvotes: 0

Views: 1267

Answers (1)

jeremyharris
jeremyharris

Reputation: 7882

You can use disconnect() on the Connection object.

$connectionObject->disconnect();

See: http://api.cakephp.org/3.2/source-class-Cake.Database.Connection.html#190-198

Upvotes: 1

Related Questions