summaryrefslogtreecommitdiff
path: root/plugins/RSSCloud/RSSCloudSubscription.php
blob: 595af884468ac4aad7d441fe6dff8fd22dc25a96 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<?php
/*
 * StatusNet - the distributed open-source microblogging tool
 * Copyright (C) 2008, 2009, StatusNet, Inc.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

if (!defined('STATUSNET') && !defined('LACONICA')) {
    exit(1);
}

/**
 * Table Definition for rsscloud_subscription
 */

require_once INSTALLDIR . '/classes/Memcached_DataObject.php';

class RSSCloudSubscription extends Memcached_DataObject {

    var $__table='rsscloud_subscription'; // table name
    var $subscribed;                      // int    primary key user id
    var $url;                             // string primary key
    var $failures;                        // int
    var $created;                         // datestamp()
    var $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP

    function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('DataObjects_Grp',$k,$v); }

    function table()
    {

        $db = $this->getDatabaseConnection();
        $dbtype = $db->phptype;

        $cols = array('subscribed' => DB_DATAOBJECT_INT + DB_DATAOBJECT_NOTNULL,
                      'url'        => DB_DATAOBJECT_STR + DB_DATAOBJECT_NOTNULL,
                      'failures'   => DB_DATAOBJECT_INT,
                      'created'    => DB_DATAOBJECT_STR + DB_DATAOBJECT_DATE + DB_DATAOBJECT_TIME + DB_DATAOBJECT_NOTNULL,
                      'modified'  => ($dbtype == 'mysql' || $dbtype == 'mysqli') ?
                      DB_DATAOBJECT_MYSQLTIMESTAMP + DB_DATAOBJECT_NOTNULL :
                      DB_DATAOBJECT_STR + DB_DATAOBJECT_DATE + DB_DATAOBJECT_TIME
                      );

        return $cols;
    }

    function keys()
    {
        return array('subscribed' => 'N', 'url' => 'N');
    }

    static function getSubscription($subscribed, $url)
    {
        $sub = new RSSCloudSubscription();
        $sub->whereAdd("subscribed = $subscribed");
        $sub->whereAdd("url = '$url'");
        $sub->limit(1);

        if ($sub->find()) {
            $sub->fetch();
            return $sub;
        }

        return false;
    }
}