amphp/sql

What's Changed

• Fix acceptance of escaped spaces in connection strings

Full Changelog: v2.1.0...v2.1.1

What's Changed

• Added support for quoted strings within connection strings, e.g. "host=localhost port=5432 options='--client_encoding=UTF8'"

Full Changelog: v2.0.1...v2.1.0

What's Changed

• Added PHP 8.4 compatibility by @Bilge in #9

New Contributors

• @Bilge made their first contribution in #9

Full Changelog: v2.0.0...v2.0.1

Stable release compatible with AMPHP v3 and fibers! 🎉

As with other libraries compatible with AMPHP v3, most cases of parameters or returns of Promise<ResolutionType> have been replaced with ResolutionType.

• Added template types to interfaces for better type expression on implementations and extensions.
• All classes now start with Sql as a prefix to avoid name collisions with other libraries.
• Combined ResultSet and CommandResult into a single interface, SqlResult.
• SqlTransaction now extends SqlLink instead of SqlExecutor to support nested transactions.
• Added onCommit() and onRollback() methods to SqlTransaction. These methods attach callbacks after the transaction is either committed or rolled back, respectively.
• Removed the methods createSavepoint(), rollbackTo(), and releaseSavepont() from SqlTransaction. Use nested transactions through SqlTransaction::beginTransaction() instead.
• SqlPool now extends SqlConnection instead of SqlLink. SqlPool::extractConnection() returns an instance of SqlConnection instead of SqlLink.
• Added SqlResult::fetchRow(), which will return a single row (associative array) from the result set on each call until no further rows remain in the result.
• SqlTransientResource and now extends Amp\Closable.
• Added SqlTransactionIsolation and an enum-based implementation, SqlTransactionIsolationLevel.
• Renamed ConnectionConfig to SqlConfig.
• Renamed FailureException to SqlException.

What's Changed

• The Transaction interface now extends Link, adding nested transaction functionality through beginTransaction() on a transaction object.
• Added Connection interface with methods to retrieve the config and get/set the current transaction isolation.
• The TransactionIsolation argument of Link::beginTransaction() has been removed. Transaction isolation is now set on the connection in the new Connection interface.
• Pool now extends Connection instead of Link. Pool::extractConnection() returns an instance of Connection instead of Link.
• SqlConnector::connect() returns an instance of Connection instead of Link.
• Renamed Transaction::getIsolationLevel() to getIsolation().
• Removed the methods createSavepoint(), rollbackTo(), and releaseSavepont() from Transaction. Use nested transactions through beginTransaction() instead.
• Added onCommit() and onRollback() methods to Transaction. These methods attach callbacks when the transaction is either committed or rolled back, respectively.

Full Changelog: v2.0.0-beta.5...v2.0.0-beta.6

• Fixed return type by @danog in #8

• Removed PoolError
• Updated several docblock types to be non-empty-string instead of string

• Added Result::fetchRow(), which will return a single row (associative array) from the result set on each call until no further rows remain in the result.

// Iterate over result rows with a simple while loop
while ($row = $result->fetchRow()) {
    // ...
}

// Also useful if you know your result will contain only a single row
$id = $result->fetchRow()['id'] ?? throw new Exception('Item not found');

• Fix template type restriction in Amp\Sql\Pool.

• Fix a deprecation notice on PHP 8.1 if a configuration key does not have a value.