123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105 |
- <?php
- defined('GNUSOCIAL') || die();
- require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
- class Oauth_application_user extends Managed_DataObject
- {
-
-
- public $__table = 'oauth_application_user';
- public $profile_id;
- public $application_id;
- public $access_type;
- public $token;
- public $created;
- public $modified;
-
-
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'user of the application'),
- 'application_id' => array('type' => 'int', 'not null' => true, 'description' => 'id of the application'),
- 'access_type' => array('type' => 'int', 'size' => 'tiny', 'default' => 0, 'description' => 'access type, bit 1 = read, bit 2 = write'),
- 'token' => array('type' => 'varchar', 'length' => 191, 'description' => 'request or access token'),
- 'created' => array('type' => 'datetime', 'not null' => true, 'default' => '0000-00-00 00:00:00', 'description' => 'date this record was created'),
- 'modified' => array('type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('profile_id', 'application_id'),
- 'foreign keys' => array(
- 'oauth_application_user_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
- 'oauth_application_user_application_id_fkey' => array('oauth_application', array('application_id' => 'id')),
- ),
- );
- }
- public static function getByUserAndToken($user, $token)
- {
- if (empty($user) || empty($token)) {
- return null;
- }
- $oau = new Oauth_application_user();
- $oau->profile_id = $user->id;
- $oau->token = $token;
- $oau->limit(1);
- $result = $oau->find(true);
- return empty($result) ? null : $oau;
- }
- public function updateKeys(&$orig)
- {
- $this->_connect();
- $parts = array();
- foreach (array('profile_id', 'application_id', 'token', 'access_type') as $k) {
- if (strcmp($this->$k, $orig->$k) != 0) {
- $parts[] = $k . ' = ' . $this->_quote($this->$k);
- }
- }
- if (count($parts) == 0) {
-
- return true;
- }
- $toupdate = implode(', ', $parts);
- $table = $this->tableName();
- $tableName = $this->escapedTableName();
- $qry = 'UPDATE ' . $tableName . ' SET ' . $toupdate .
- ' WHERE profile_id = ' . $orig->profile_id .
- ' AND application_id = ' . $orig->application_id .
- " AND token = '" . $orig->token . "'";
- $orig->decache();
- $result = $this->query($qry);
- if ($result) {
- $this->encache();
- }
- return $result;
- }
- }
|