You can use the ORM engine without attributes. You can either declare a mapping schema via configuration or use
the cycle/schema-builder extension to compile it on the fly via OOP wrappers.
There are multiple examples of using the ORM with manually defined mapping schema:
We can demonstrate how to create an ORM instance which maps objects User and Profile with a HasOne relation
between them. Such setup does not require any caching as the schema is defined in code:
<?php declare(strict_types=1);
include 'vendor/autoload.php';
use Cycle\Database;
use Cycle\Database\Config;
use Cycle\ORM;
use Cycle\ORM\Schema;
use Cycle\ORM\Relation;
$dbal = new Database\DatabaseManager(
new Database\Config\DatabaseConfig([
'default' => 'default',
'databases' => [
'default' => ['connection' => 'sqlite']
],
'connections' => [
'sqlite' => new Config\SQLiteDriverConfig(
connection: new SQLite\MemoryConnectionConfig(),
queryCache: true,
),
]
])
);
$orm = new ORM\ORM(new ORM\Factory($dbal), new Schema([
'user' => [
Schema::ENTITY => User::class,
Schema::MAPPER => ORM\Mapper\Mapper::class,
Schema::DATABASE => 'default',
Schema::TABLE => 'user',
Schema::PRIMARY_KEY => 'id',
Schema::COLUMNS => [
'id' => 'id',
'email' => 'email',
'balance' => 'balance',
],
Schema::TYPECAST => [
'id' => 'int',
'balance' => 'float',
],
Schema::RELATIONS => [
'profile' => [
Relation::TYPE => Relation::HAS_ONE,
Relation::TARGET => 'profile',
Relation::SCHEMA => [
Relation::CASCADE => true,
Relation::INNER_KEY => 'id',
Relation::OUTER_KEY => 'user_id',
],
],
],
],
'profile' => [
Schema::ENTITY => Profile::class,
Schema::MAPPER => ORM\Mapper\Mapper::class,
Schema::DATABASE => 'default',
Schema::TABLE => 'profile',
Schema::PRIMARY_KEY => 'id',
Schema::COLUMNS => [
'id' => 'id',
'user_id' => 'user_id',
'image' => 'image',
],
Schema::TYPECAST => [
'id' => 'int',
'user_id' => 'int',
],
Schema::RELATIONS => [],
],
]));
print_r($orm->getRepository(User::class)->findOne());