Download the PHP package trehinos/thor-pdo-table without Composer
On this page you can find all versions of the php package trehinos/thor-pdo-table. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download trehinos/thor-pdo-table
More information about trehinos/thor-pdo-table
Files in trehinos/thor-pdo-table
Download trehinos/thor-pdo-table
More information about trehinos/thor-pdo-table
Files in trehinos/thor-pdo-table
Vendor trehinos
Package thor-pdo-table
Short Description A simple table abstraction for PDO.
License MIT
Package thor-pdo-table
Short Description A simple table abstraction for PDO.
License MIT
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package thor-pdo-table
Thor PDO Table
Lightweight utilities to map plain PHP objects (rows) to SQL tables using PHP 8 attributes, with a thin CRUD helper and optional in-memory caching.
This package builds on trehinos/thor-pdo-extension to provide:
- Declarative table and column metadata via PHP attributes
- A CrudHelper to perform typed CRUD operations and hydrate objects
- Drivers to generate DDL (CREATE TABLE/INDEX) for MySQL and SQLite
- A small write-back cache to batch updates
Requirements
- PHP 8.1+
- ext-pdo enabled and a PDO driver (mysql or sqlite)
- trehinos/thor-pdo-extension (installed automatically by Composer)
Installation
Install via Composer:
Core concepts
- Row and RowInterface: a Row represents a table row; hydration/serialization is handled by PdoRowTrait.
- Attributes: use PHP 8 attributes (Table, Column, Index) to describe the table schema.
- Primary keys: single or composite primary keys are supported via the Table(primaryKeys: [...]) declaration.
- Traits: HasIdTrait adds an auto-increment integer id; HasPublicIdTrait adds a GUID-like public_id suitable for exposure.
- CrudHelper: thin helper around ArrayCrud to perform create/read/update/delete and to instantiate rows.
Quick start
1) Define a row class with attributes
Row already provides helper methods through PdoRowTrait to convert to/from arrays.
2) Use CrudHelper
3) Optional cache
Schema generation
Use SchemaHelper with a driver (MySQL or SQLite) to create/drop tables from your attributes. Debug mode returns SQL instead of executing it.
Drivers
Two drivers help you generate DDL from your attributes:
- MySql: generates CREATE TABLE and related statements for MySQL
- Sqlite: generates CREATE TABLE and CREATE INDEX for SQLite
Both rely on AttributesReader to parse your row class.
Tips and gotchas
- Composite keys: pass ordered values to CrudHelper::readOne([...]) in the same order as declared in Table(primaryKeys: [...]).
- Public ID: when using HasPublicIdTrait, remember to call generatePublicId() before insert if you need a deterministic public_id.
- Requester access: CrudHelper::getRequester() lets you run custom queries alongside CRUD operations.
Development
- PHP 8.1+
- Run tests with PHPUnit if present in your project
- This package depends on trehinos/thor-pdo-extension
License
MIT Copyright (c) 2021-2025 Sébastien Geldreich
All versions of thor-pdo-table with dependencies
PHP Build Version
Package Version
The package trehinos/thor-pdo-table contains the following files
Loading the files please wait ...