classes/Foreign_link.php

   1 <?php
   2 /**
   3  * Table Definition for foreign_link
   4  */
   5 require_once 'DB/DataObject.php';
   6
   7 class Foreign_link extends DB_DataObject
   8 {
   9     ###START_AUTOCODE
  10     /* the code below is auto generated do not remove the above tag */
  11
  12     public $__table = 'foreign_link';                    // table name
  13     public $user_id;                         // int(4)  primary_key not_null
  14     public $foreign_id;                      // int(4)  primary_key not_null
  15     public $service;                         // int(4)  primary_key not_null
  16     public $credentials;                     // varchar(255)
  17     public $noticesync;                      // tinyint(1)   not_null default_1
  18     public $friendsync;                      // tinyint(1)   not_null default_2
  19     public $profilesync;                     // tinyint(1)   not_null default_1
  20     public $created;                         // datetime()   not_null
  21     public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
  22
  23     /* Static get */
  24     function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Foreign_link',$k,$v); }
  25
  26     /* the code above is auto generated do not remove the tag below */
  27     ###END_AUTOCODE
  28
  29         // XXX:  This only returns a 1->1 single obj mapping.  Change?  Or make
  30         // a getForeignUsers() that returns more than one? --Zach
  31         static function getForeignLink($user_id, $service) {
  32                 $flink = new Foreign_link();
  33                 $flink->whereAdd("service = $service");
  34                 $flink->whereAdd("user_id = $user_id");
  35                 $flink->limit(1);
  36
  37                 if ($flink->find()) {
  38                         $flink->fetch();
  39                         return $flink;
  40                 }
  41
  42                 return NULL;
  43         }
  44
  45         // Convenience method
  46         function getForeignUser() {
  47                 $fuser = new Foreign_user();
  48                 $fuser->whereAdd('service = ' . $this->service);
  49                 $fuser->whereAdd('id = ' . $this->foreign_id);
  50                 $fuser->limit(1);
  51
  52                 if ($fuser->find()) {
  53                         $fuser->fetch();
  54                         return $fuser;
  55                 }
  56
  57                 return NULL;
  58         }
  59
  60 }