PDO One ORM: Access SQL database tables as object using PDO

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not yet rated by the users				Total: 18		All time: 11,390 This week: 206

Version		License		PHP version		Categories
`pdooneorm` 1.0		GNU Lesser Genera...		5		PHP 5, Databases, Code Generation

Description

Author

Jorge Castro

This package can access SQL database tables as objects using PDO.

It can generate classes that can perform operations to manipulate table records as if they were objects, like creating and retrieving, updating, and deleting table records.

The package can also perform database table alterations using parameters to define the table fields and indexes.

Jorge Castro

Performance

Level

Level 4

Innovation award

Nominee: 14x

Winner: 2x

Example


<?php /** @noinspection ForgottenDebugOutputInspection */



use eftec\examples\example1\repo\FilmTextRepo;

use eftec\PdoOneORM;

use eftec\tests\sakila2021\CityRepo;



include '../../vendor/autoload.php';



include __DIR__.'/phpconf.php';

/** @noinspection PhpUndefinedVariableInspection */

$pdo=PdoOneORM::factoryFromArray($pdoOneConfig);

$pdo->connect();

$pdo->logLevel=3;



echo "<h1>Dropping table</h1>";

FilmTextRepo::dropTable();

echo "<h1>Creating table</h1>";

FilmTextRepo::createTable();

echo "<h1>Truncating table</h1>";

FilmTextRepo::truncate(true);



echo "<h1>Listing paged</h1>";

var_dump(CityRepo::page(2,5)->toList());



echo "<h1>Listing join</h1>";

var_dump(CityRepo::innerjoin('country on city.country_id=country.country_id')->toList());

echo "<h1>Listing table</h1>";

var_dump(CityRepo::recursive(['/_country_id'])->toList());

echo "<h1>Listing cache (if available)</h1>";

var_dump(CityRepo::useCache(0)->toList());

Files (126)

File	Role	Description
`examples` (2 directories)
`lib` (4 files, 1 directory)
`tests` (4 files, 1 directory)
`composer.json`	Data	Auxiliary data
`LICENSE`	Lic.	License text
`README.md`	Doc.	Read me

File	Role	Description
`example1` (5 files, 1 directory)
`example2` (4 files, 1 directory)

File	Role	Description
`repo` (33 files)
`config.config.php`	Aux.	Auxiliary script
`config2.config.php`	Aux.	Auxiliary script
`generate.bat`	Data	Auxiliary data
`phpconf.php`	Aux.	Auxiliary script
`test.php`	Example	Example script

File	Role	Description
`AbstractActorRepo.php`	Class	Class source
`AbstractAddresRepo.php`	Class	Class source
`AbstractCategoryRepo.php`	Class	Class source
`AbstractCityRepo.php`	Class	Class source
`AbstractCountryRepo.php`	Class	Class source
`AbstractCustomerRepo.php`	Class	Class source
`AbstractFilmActorRepo.php`	Class	Class source
`AbstractFilmCategoryRepo.php`	Class	Class source
`AbstractFilmRepo.php`	Class	Class source
`AbstractFilmTextRepo.php`	Class	Class source
`AbstractInventoryRepo.php`	Class	Class source
`AbstractLanguageRepo.php`	Class	Class source
`AbstractPaymentRepo.php`	Class	Class source
`AbstractRentalRepo.php`	Class	Class source
`AbstractStaffRepo.php`	Class	Class source
`AbstractStoreRepo.php`	Class	Class source
`ActorRepo.php`	Class	Class source
`AddresRepo.php`	Class	Class source
`CategoryRepo.php`	Class	Class source
`CityRepo.php`	Class	Class source
`CountryRepo.php`	Class	Class source
`CustomerRepo.php`	Class	Class source
`FilmActorRepo.php`	Class	Class source
`FilmCategoryRepo.php`	Class	Class source
`FilmRepo.php`	Class	Class source
`FilmTextRepo.php`	Class	Class source
`InventoryRepo.php`	Class	Class source
`LanguageRepo.php`	Class	Class source
`PaymentRepo.php`	Class	Class source
`RentalRepo.php`	Class	Class source
`Sakila.php`	Class	Class source
`StaffRepo.php`	Class	Class source
`StoreRepo.php`	Class	Class source

File	Role	Description
`repo` (33 files)
`config.config.php`	Aux.	Auxiliary script
`config2.config.php`	Aux.	Auxiliary script
`exercise1.php`	Example	Example script
`phpconfig.php`	Aux.	Auxiliary script

File	Role	Description
`AbstractActorRepo.php`	Class	Class source
`AbstractAddresRepo.php`	Class	Class source
`AbstractCategoryRepo.php`	Class	Class source
`AbstractCityRepo.php`	Class	Class source
`AbstractCountryRepo.php`	Class	Class source
`AbstractCustomerRepo.php`	Class	Class source
`AbstractFilmActorRepo.php`	Class	Class source
`AbstractFilmCategoryRepo.php`	Class	Class source
`AbstractFilmRepo.php`	Class	Class source
`AbstractFilmTextRepo.php`	Class	Class source
`AbstractInventoryRepo.php`	Class	Class source
`AbstractLanguageRepo.php`	Class	Class source
`AbstractPaymentRepo.php`	Class	Class source
`AbstractRentalRepo.php`	Class	Class source
`AbstractStaffRepo.php`	Class	Class source
`AbstractStoreRepo.php`	Class	Class source
`ActorRepo.php`	Class	Class source
`AddresRepo.php`	Class	Class source
`CategoryRepo.php`	Class	Class source
`CityRepo.php`	Class	Class source
`CountryRepo.php`	Class	Class source
`CustomerRepo.php`	Class	Class source
`FilmActorRepo.php`	Class	Class source
`FilmCategoryRepo.php`	Class	Class source
`FilmRepo.php`	Class	Class source
`FilmTextRepo.php`	Class	Class source
`InventoryRepo.php`	Class	Class source
`LanguageRepo.php`	Class	Class source
`PaymentRepo.php`	Class	Class source
`RentalRepo.php`	Class	Class source
`Sakila.php`	Class	Class source
`StaffRepo.php`	Class	Class source
`StoreRepo.php`	Class	Class source

File	Role	Description
`template` (6 files)
`pdooneorm`	Example	Example script
`PdoOneORM.php`	Class	Class source
`PdoOneORMCli.php`	Class	Class source
`_BasePdoOneRepo.php`	Class	Class source

File	Role	Description
`template_abstractclassrepo.php`	Aux.	Auxiliary script
`template_abstractmodel.php`	Aux.	Auxiliary script
`template_abstractrepo.php`	Aux.	Auxiliary script
`template_base.php`	Aux.	Auxiliary script
`template_classrepo.php`	Aux.	Auxiliary script
`template_model.php`	Aux.	Auxiliary script

File	Role	Description
`sakila2021` (34 files)
`dBug.php`	Class	Class source
`PdoOne_mysql_sakila2021_Test.php`	Class	Class source
`running_sakila.md`	Data	Auxiliary data
`sakila2021.config.php`	Aux.	Auxiliary script

File	Role	Description
`AbstractActorRepo.php`	Class	Class source
`AbstractAddresRepo.php`	Class	Class source
`AbstractCategoryRepo.php`	Class	Class source
`AbstractCityRepo.php`	Class	Class source
`AbstractCountryRepo.php`	Class	Class source
`AbstractCustomerRepo.php`	Class	Class source
`AbstractFilmActorRepo.php`	Class	Class source
`AbstractFilmCategoryRepo.php`	Class	Class source
`AbstractFilmRepo.php`	Class	Class source
`AbstractFilmTextRepo.php`	Class	Class source
`AbstractInventoryRepo.php`	Class	Class source
`AbstractLanguageRepo.php`	Class	Class source
`AbstractPaymentRepo.php`	Class	Class source
`AbstractRentalRepo.php`	Class	Class source
`AbstractStaffRepo.php`	Class	Class source
`AbstractStoreRepo.php`	Class	Class source
`ActorRepo.php`	Class	Class source
`AddresRepo.php`	Class	Class source
`CategoryRepo.php`	Class	Class source
`CityRepo.php`	Class	Class source
`CountryRepo.php`	Class	Class source
`CustomerRepo.php`	Class	Class source
`FilmActorRepo.php`	Class	Class source
`FilmCategoryRepo.php`	Class	Class source
`FilmRepo.php`	Class	Class source
`FilmTextRepo.php`	Class	Class source
`InventoryRepo.php`	Class	Class source
`LanguageRepo.php`	Class	Class source
`PaymentRepo.php`	Class	Class source
`RentalRepo.php`	Class	Class source
`Sakila.php`	Class	Class source
`Sakila_lite.php`	Class	Class source
`StaffRepo.php`	Class	Class source
`StoreRepo.php`	Class	Class source

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.

Install with Composer

	pdooneorm-2023-03-15.zip 419KB
	pdooneorm-2023-03-15.tar.gz 133KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

100%

Total:	18
This week:	0

All time:	11,390
This week:	206

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.