TORM

  <?php
    // include TORM 
    include "torm.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", array("presence" => true));
    User::validates("email", array("presence" => true));
    User::validates("email", array("uniqueness" => true));
    User::validates("id", array("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(array("level" => 1));

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

    // using fluent queries
    $users = User::where(array("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; 
  ?>