torm - GitLite

KO | EN

gitlite — search

#react-native #agent #cloud-native #awesome-list #privacy #pdf #computer-vision #list #editor #mysql

torm

(★ 93)

Just another simple PHP ORM. You can use it, but don't ask me why I made it. :-)

File Explorer

ZIP Download

- another_test.sqlite3
- test.sqlite3
- mysql.php
- oracle.php
- postgresql.php
- sqlite.php
- account.php
- another_user.php
- bill.php
- ticket.php
- user.php
- user_namespaced.php
- BelongsTo.php
- Builder.php
- Cache.php
- Callbacks.php
- Collection.php
- Connection.php
- Dirty.php
- Driver.php
- Errors.php
- Factory.php
- Finders.php
- HasMany.php
- HasOne.php
- Inflections.php
- Log.php
- Model.php
- Persistence.php
- Scopes.php
- Sequences.php
- Storage.php
- Util.php
- Validation.php
- Validations.php
- - account.php
  - ticket.php
  - user.php
- cacheTest.php
- factoryTest.php
- inflectionsTest.php
- logTest.php
- modelTest.php
- run
- torm.yml
.gitignore
.travis.yml
composer.json
LICENSE
README.md
torm.php

# Use via CDN

jsDelivr

jsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.

Version

File

Link

Example

Command Glossary

Commands referenced in this DOCs, explained below.

🔍

`composer`

View Details ▼

A package-based dependency manager for PHP projects.

composer init

Interactively create a `composer.json` file:

composer require {{user/package}}

Add a package as a dependency for this project, adding an entry to `composer.json`:

composer install

Install all the dependencies in this project's `composer.json` and create `composer.lock`:

🔍

`php`

View Details ▼

PHP command-line interface.

php {{path/to/file}}

Parse and execute a PHP script:

php {{[-l|--syntax-check]}} {{path/to/file}}

Check syntax on (i.e. [l]int) a PHP script:

php {{[-a|--interactive]}}

Run PHP inter[a]ctively:

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

| :warning: **WARNING** This software is [abandonware](https://en.wikipedia.org/wiki/Abandonware). As the creator and maintainer, I don't even use PHP _for years_, so, I can't support it anymore. It should work ok for PHP untill version 7, but seems that with 8.1 there are some alerts. Feel free to fork it and keep it going. |
| --- |

Just another simple ORM for PHP. You can use it, but don't ask why I made it. Right? :-)

## Usage

Take a look on the [Github Wiki](https://github.com/taq/torm/wiki) for documentation, but let me show the basics here:

```php
<?php
// open the PDO connection and set it
$con = new PDO("sqlite:database.sqlite3");
TORM\Connection::setConnection($con);
TORM\Connection::setDriver("sqlite");

// define your models - an User class will connect to an users table
class User extends TORM\Model {};
class Ticket extends TORM\Model {};

// create some validations
User::validates("name",  ["presence"     => true]);
User::validates("email", ["presence"     => true]);
User::validates("email", ["uniqueness"   => true]);
User::validates("id",    ["numericality" => true]);

// create some relations
User::hasMany("tickets");
User::hasOne("account");
Ticket::belongsTo("user");

// this will create a new user
$user = new User();
$user->name  = "John Doe";
$user->email = "john@doe.com";
$user->level = 1;
$user->save();

// this will find the user using its primary key
$user = User::find(1);

// find some users
$users = User::where(["level" => 1]);

// find some users, using more complex expressions
// the array first element is the query, the rest are values
$users = User::where(["level >= ?", 1]);

// updating users
User::where(["level" => 1])->updateAttributes(["level" => 3]);

// using fluent queries
$users = User::where(["level" => 1])->limit(5)->order("name desc");

// listing the user tickets
foreach($user->tickets as $ticket) {
   echo $ticket->description;
}

// show user account info
echo $user->account->number; 
?>
```

## Testing

### SQLite

First, use `composer update` to make sure everything is ok with all the
packages. Then, go to the `test` directory and run `run`. It will requires the
[SQLite driver](http://php.net/manual/en/ref.pdo-sqlite.php) so make sure it is
available. If not, check the `php.ini` dir found with

```bash
$ php -r 'phpinfo();' | grep 'php.ini'
Configuration File (php.ini) Path => /etc/php/7.1/cli
Loaded Configuration File => /etc/php/7.1/cli/php.ini
```

and, if not found there or on the `conf.d` on the same location the `php.ini`
file is, it can be installed, on Ubuntu, using:

```bash
$ sudo apt install php-sqlite3
```

### Multibyte strings, locale and YAML

```
$ sudo apt install php-mbstring php-intl php-yaml
```