Updating dependencies Your requirements could not be resolved to an installable set of packages.

Problem 1 - cycle/database 2.0.0 requires spiral/core ^2.9 -> found spiral/core[dev-master, 2.9.x-dev (alias of dev-master)] but it does not match your minimum-stability. - cycle/orm v2.0.0 requires cycle/database ^2.0 -> satisfiable by cycle/database[2.0.0]. - Root composer.json requires cycle/orm ^2.0 -> satisfiable by cycle/orm[v2.0.0].

You can also try re-running composer require with an explicit version constraint, e.g. "composer require cycle/orm:*" to figure out if any version is installable, or "composer require cycle/orm:^2.1" if you know which you need.

Steps to reproduce

1. composer install --no-dev
2. Running the below example code will complain

example.php

<?php

require_once "vendor/autoload.php";

use Cycle\Database\DatabaseManager;
use Cycle\Database\Driver;      // unused import here
use Cycle\Database\Config;

$dbal = new DatabaseManager(new Config\DatabaseConfig([
    'databases' => [
        'default' => [
            'driver' => 'runtime'
        ],
    ],
    'connections' => [
        'runtime' => new Config\SQLiteDriverConfig(
            connection: new Config\SQLite\FileConnectionConfig(
                database: __DIR__ . './runtime/database.sqlite'
            ),
            queryCache: true,
        ),
    ],
]));

Error message

PHP Warning:  Uncaught Error: Interface "Psr\Log\LoggerAwareInterface" not found in ../cycle/database/src/Driver/Driver.php:36

Another way to reproduce is to require cycle/orm and do not require cycle/annotated and try to setup as per above example file.

I have an idea!

There is some config:

new DatabaseConfig([
        'default' => 'default',

        'databases' => [
            'default' => [
                'connection' => 'mysql',
            ],
        ],

        'connections' => [
            'sqlite' => new \Cycle\Database\Config\SQLiteDriverConfig(
                connection: new \Cycle\Database\Config\SQLite\MemoryConnectionConfig(),
                driver: \Cycle\Database\Driver\SQLite\SQLiteDriver::class,
                queryCache: true,
            ),

            'mysql' => new \Cycle\Database\Config\MySQLDriverConfig(
                connection: new \Cycle\Database\Config\MySQL\TcpConnectionConfig(
                    database: 'project_name',
                    host: '127.0.0.1',
                    port: 3306,
                    user: 'test',
                    password: 'secret',
                ),
                queryCache: true,
            ),
        ],
    ]),

It would be good if these settings will be cached. It works well with var_export. But it cannot be recovered because driver configs don't have __set_state methods.

I have a suggestion to add default method __set_state to \Cycle\Database\Config\DriverConfig and override in another configs when it's required. I can create pull request if this idea will be accepted.

No duplicates 🥲.

• [X] I have searched for a similar issue in our bug tracker and didn't find any solutions.

Database

PostgreSQL

What happened?

A bug happened!

Sometimes this error occurred:

General error: 7 server closed the connection unexpectedly \tThis probably means the server terminated abnormally \tbefore or while processing the request

Perhaps this error should be mapped as ConnectionException and statement must be retried.

Version

database 14.2
PHP 8.1

No duplicates 🥲.

• [X] I have searched for a similar issue in our bug tracker and didn't find any solutions.

Database

MySQL

What happened?

When I put a where-statement like where('ball', '<', 'water'), I'm being presented with an error like:

Type: TypeError Code: 0 Message: strtoupper(): Argument #1 ($string) must be of type string, int given File: D:\websites\slim.local\vendor\cycle\database\src\Query\Traits\TokenTrait.php Line: 171

I have the impression it has something to do with the operator value of '<'. But that isn't an int, is it?

Obviously I didn't expect an error. Or am I doing something wrong?

Version

database 2.0
PHP 8.1

PHP8.1.1 Cycle 1.8

PHP Deprecated: Return type of Spiral\Core\InjectableConfig::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /app/vendor/spiral/core/src/InjectableConfig.php on line 108 PHP Deprecated: Return type of Spiral\Core\InjectableConfig::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /app/vendor/spiral/core/src/InjectableConfig.php on line 64 PHP Deprecated: Return type of Spiral\Core\InjectableConfig::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /app/vendor/spiral/core/src/InjectableConfig.php on line 72

Now you can set specific schemas as string or array in PostgresDriver.

new PostgresDriver([
    'connection' => 'pgsql:host=127.0.0.1;port=15432;dbname=spiral',
    'username'   => 'postgres',
    'password'   => 'postgres',
    'schema'     => 'private'
]);
// or
new PostgresDriver([
    'connection' => 'pgsql:host=127.0.0.1;port=15432;dbname=spiral',
    'username'   => 'postgres',
    'password'   => 'postgres',
    'schema'     => ['private', 'public']
]);

see https://github.com/cycle/schema-builder/issues/12

Cover connection exceptions Added PDOStatementInterface for PDOStatement mocking

Related with https://github.com/cycle/database/issues/75

Include CI optimization

Now you don't need to wrap an array value in the Parameter injection.

$database->select()
    ->from(['users'])
    ->where([
        'status' => [
            'IN' => ['active', 'blocked']
        ],
        'name' => [
            'NOT IN' => ['foo', 'bar']
        ],
    ]);

Now you don't need to wrap an array value in the Parameter injection.

$database->select()
    ->from(['users'])
    ->where('status', 'NOT IN', ['active', 'blocked']);

Now you don't need to wrap an array value in the Parameter injection.

$database->select()
    ->from(['users'])
    ->where('status', 'IN', ['active', 'blocked']);

I have an idea!

CREATE TABLE Customers
(
  Age INT DEFAULT 18 CHECK(Age >0 AND Age < 100),
)

Or

CREATE TABLE Customers
(
    Age INT DEFAULT 18,
    CHECK((Age >0 AND Age<100) AND (Email !='') AND (Phone !=''))
);

See

No duplicates 🥲.

• [X] I have searched for a similar issue in our bug tracker and didn't find any solutions.

Database

MySQL

What happened?

When introspecting an existing database, one of the columns was marked as of "unknown" type. The column is declared as

`Groups` set('A','B','C',…) DEFAULT NULL COMMENT 'Группы',

$column->getEnumValues() returns an empty array.

Version

database 2.2.2
PHP 8.0
MariaDB 10

I have an idea!

Problem:

\Cycle\Database\ColumnInterface doesn't have something like getComment() method. Also no one Driver directory contains comment keyword :)

So the idea is to have a getComment() method inside ColumnInterface to be able to introspect as more properties as we can.

I think it should be configurable via indexCreate only. Right now in cycle/database (1.0.3, and I think in latest versions) if indexCreate = false, index is beeing created anyway.

I think it should be removed to skip creation of unneeded indexes.

No duplicates 🥲.

• [X] I have searched for a similar issue in our bug tracker and didn't find any solutions.

Database

MySQL

What happened?

I have the query columns a bug happened!

$result = $database
    ->select([
        'table1.id as t.id'
    ])
    ->from('table1')
    ->fetchAll();

I need this result

select `table1`.`id` as `t.id` from `table1`;

The actual result is

select `table1`.`id` as `t`.`id` from `table1`;

Result in query error： You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

Version

database 2.0
PHP 8.1