ORM CRUD — Semitexa Demo

Feature Guide

A quick orientation block that answers the essential questions: what this feature does, how it works, why it matters, and the key concepts behind it.

What this does

Define your schema once with attributes — reads, writes, and soft-deletes are handled by the ORM.

Repository Snapshot

Current product set

A small working dataset backed by the ORM. Create and delete actions update this view.

8 Visible rows

demo Tenant scope

Name	Price	Status
Portable Monitor	$249.99	active
Refactoring	$49.99	active
Power Bank	$59.99	active
Domain-Driven Design	$54.99	active
Head First Design Patterns	$49.99	active
Linen Shirt	$54.99	active
Winter Jacket	$149.99	active
Ergonomic Chair	$299.99	active

#[FromTable] #[Column] HasUuidV7 HasTimestamps SoftDeletes DomainRepository

1<?php23declare(strict_types=1);45namespace App\Application\Db\Model;67use Semitexa\Orm\Attributes\Column;8use Semitexa\Orm\Attributes\FromTable;910#[FromTable(name: 'products')]11final class ProductResource12{13    #[Column(type: 'uuid')]14    public string $id;1516    #[Column(type: 'varchar', length: 255)]17    public string $name;1819    #[Column(type: 'decimal', precision: 10, scale: 2)]20    public string $price;2122    #[Column(type: 'varchar', length: 32)]23    public string $status;24}25

<?php

declare(strict_types=1);

namespace App\Application\Db\Model;

use Semitexa\Orm\Attributes\Column;
use Semitexa\Orm\Attributes\FromTable;

#[FromTable(name: 'products')]
final class ProductResource
{
    #[Column(type: 'uuid')]
    public string $id;

    #[Column(type: 'varchar', length: 255)]
    public string $name;

    #[Column(type: 'decimal', precision: 10, scale: 2)]
    public string $price;

    #[Column(type: 'varchar', length: 32)]
    public string $status;
}

1<?php23declare(strict_types=1);45namespace App\Application\Db\Repository;67use App\Application\Db\Model\ProductResource;8use App\Domain\Catalog\ProductReadRepositoryInterface;910final class ProductRepository implements ProductReadRepositoryInterface11{12    /**13     * @return list<ProductResource>14     */15    public function findForCatalog(object $criteria): array16    {17        return [];18    }19}20

<?php

declare(strict_types=1);

namespace App\Application\Db\Repository;

use App\Application\Db\Model\ProductResource;
use App\Domain\Catalog\ProductReadRepositoryInterface;

final class ProductRepository implements ProductReadRepositoryInterface
{
    /**
     * @return list<ProductResource>
     */
    public function findForCatalog(object $criteria): array
    {
        return [];
    }
}

1<?php23declare(strict_types=1);45namespace App\Application\Handler\Data;67use App\Application\Payload\Data\ProductCatalogPayload;8use App\Application\Resource\Page\ProductCatalogResource;9use App\Domain\Catalog\ProductReadRepositoryInterface;10use Semitexa\Core\Attribute\AsPayloadHandler;11use Semitexa\Core\Attribute\InjectAsReadonly;12use Semitexa\Core\Contract\TypedHandlerInterface;1314#[AsPayloadHandler(payload: ProductCatalogPayload::class, resource: ProductCatalogResource::class)]15final class ProductCatalogHandler implements TypedHandlerInterface16{17    #[InjectAsReadonly]18    protected ProductReadRepositoryInterface $products;1920    public function handle(ProductCatalogPayload $payload, ProductCatalogResource $resource): ProductCatalogResource21    {22        return $resource->fromProducts($this->products->findForCatalog($payload));23    }24}25

<?php

declare(strict_types=1);

namespace App\Application\Handler\Data;

use App\Application\Payload\Data\ProductCatalogPayload;
use App\Application\Resource\Page\ProductCatalogResource;
use App\Domain\Catalog\ProductReadRepositoryInterface;
use Semitexa\Core\Attribute\AsPayloadHandler;
use Semitexa\Core\Attribute\InjectAsReadonly;
use Semitexa\Core\Contract\TypedHandlerInterface;

#[AsPayloadHandler(payload: ProductCatalogPayload::class, resource: ProductCatalogResource::class)]
final class ProductCatalogHandler implements TypedHandlerInterface
{
    #[InjectAsReadonly]
    protected ProductReadRepositoryInterface $products;

    public function handle(ProductCatalogPayload $payload, ProductCatalogResource $resource): ProductCatalogResource
    {
        return $resource->fromProducts($this->products->findForCatalog($payload));
    }
}