Table is created without columns

[dompie]

Hello,

I am new to cycle/orm and I decided to go without annotations:

composer require cycle/orm
composer require cycle/schema-builder

My code:

$dbal = new \Cycle\Database\DatabaseManager(
    new \Cycle\Database\Config\DatabaseConfig([
        'databases' => [
            'default' => ['connection' => 'postgres'],
        ],
        'connections' => [
            'postgres' => new \Cycle\Database\Config\PostgresDriverConfig(
                connection: new \Cycle\Database\Config\Postgres\TcpConnectionConfig(
[...]
                ),
[...]
            ),
]]);
$consoleLogger = new \App\Infrastructure\ConsoleLogger();
$dbal->setLogger($consoleLogger);
$registry = new \Cycle\Schema\Registry($dbal);
$entity = new \Cycle\Schema\Definition\Entity();

$entity
    ->setRole('user')
    ->setClass(\App\Entity\ApiUser::class);

$entity->getFields()
    ->set('id', (new \Cycle\Schema\Definition\Field())->setType('string(36)')->setColumn('id')->setPrimary(true))
    ->set('token', (new \Cycle\Schema\Definition\Field())->setType('string(28)')->setColumn('token'));

// register entity
$registry->register($entity);

// associate table
$registry->linkTable($entity, 'default', 'api_user');

$schemaArray = (new \Cycle\Schema\Compiler())->compile($registry);
$orm = new \Cycle\ORM\ORM(new \Cycle\ORM\Factory($dbal), new \Cycle\ORM\Schema($schemaArray));
$dbal->database()->execute('DROP TABLE IF EXISTS api_user');
if (!$dbal->database()->table('api_user')->exists()) {
    /** @var \Cycle\Database\Schema\AbstractTable $table */
    $table = $dbal->database()->table('api_user')->getSchema();
    $table->save();
}

$manager = new \Cycle\ORM\EntityManager($orm);
$manager->persist(new \App\Entity\ApiUser());
$result = $manager->run();

When I take a look in the log, I see the following line (aside from others):

[20:58:26.086267][INFO] CREATE TABLE "public"."api_user" (
    
)

and later on

[20:58:26.093961][INFO] Begin transaction
[20:58:26.094998][ERROR] INSERT INTO "api_user" ("id", "token") VALUES ('265d0e81-4233-4ce9-8119-fad358a353af', '94978622f9e621607d9.10009798') RETURNING "id"
[20:58:26.095010][ALERT] SQLSTATE[42703]: Undefined column: 7 ERROR:  Column »id« on Relation »api_user« does not exist
LINE 1: INSERT INTO "api_user" ("id", "token") VALUES ($1, $2) RETUR...
                                ^
[20:58:26.095028][INFO] Rollback transaction

I also tried with non-dynamic schema building, but I ended up with the same error message. Is this a bug or am I missing something?
I use PHP 8.1 and cycle orm 2.1

[roxblnfk]

$schemaArray = (new \Cycle\Schema\Compiler())->compile($registry);

To compile Registry to Schema you should use Compile Generators. For example:

use Cycle\Schema;

$schemaArray = (new Schema\Compiler())->compile(new Schema\Registry($dbal), [
    new Schema\Generator\GenerateRelations(),       // generate entity relations
    new Schema\Generator\GenerateModifiers(),       // generate changes from schema modifiers
    new Schema\Generator\ValidateEntities(),        // make sure all entity schemas are correct
    new Schema\Generator\RenderTables(),            // declare table schemas
    new Schema\Generator\RenderRelations(),         // declare relation keys and indexes
    new Schema\Generator\RenderModifiers(),         // render all schema modifiers
    new Schema\Generator\SyncTables(),              // sync table changes to database
    new Schema\Generator\GenerateTypecast(),        // typecast non string columns
]);

See: https://cycle-orm.dev/docs/intro-install/2.x/en#define-entity-schema-generation

---

$dbal->database()->execute('DROP TABLE IF EXISTS api_user');
if (!$dbal->database()->table('api_user')->exists()) {
    /** @var \Cycle\Database\Schema\AbstractTable $table */
    $table = $dbal->database()->table('api_user')->getSchema();
    $table->save();
}

DBAL (cycle/database package) doesn't use the compiled Schema. This code will always create an empty table.
If you want to sync tables with ORM schema then use the SyncTables generator.

[dompie]

This example should be improved as it does not use any registry, compiler and generators: https://cycle-orm.dev/docs/basic-no-annotations/2.x/en and produces the empty table error.