<?php

require_once('odb.class.php');

// Base of our DB -- Holds the DB connection
class db extends odb {
  function __construct() {
    //parent::__construct();
    $this->conn = Creole::getConnection(array(
      'username'       => "SWCAIntranetUser",
      'password'       => "s4e13c11",
      'database'       => "SWCAIntranetDEV",
      'hostspec'       => "MyServer2k",
      'phptype'        => "mssql",
    ));
  }
}

class person extends db {
  function __construct($id = NULL) {
    parent::__construct();
    $this->table = 'odbtest_person';

    $this->columns = array('first_name','last_name','birth_date');

    $this->has_many = array(
      'addresses' => array(
        'table' => 'address',
        'key' => 'person_id',
      ),
    );

    if(isset($id)) {
      return $this->get($id);
    }
  }
}

class address extends db {
  function __construct($id = NULL) {
    parent::__construct();

    $this->table = 'odbtest_address';

    $this->columns = array('street','city','state','zip', 'person_id');

    $this->has_a = array(
      'owner' => array(
        'table' => 'person',
        'key' => 'person_id',
      )
    );

    if(isset($id)) {
      return $this->get($id);
    }
  }
}

?>