Return dynamically generated URLs for thumbnails for all locally stored entries

[quix0rs-gnu-social.git] / classes / File_to_post.php

diff --git a/classes/File_to_post.php b/classes/File_to_post.php
index 530921adcb05aacdf2422d20f108cb0069484eff..bf201756f493b8630a4a7f702bad96451f4339fe 100644 (file)
--- a/classes/File_to_post.php
+++ b/classes/File_to_post.php
@@ -17,15 +17,13 @@
  * along with this program.     If not, see <http://www.gnu.org/licenses/>.
  */
 
-if (!defined('STATUSNET') && !defined('LACONICA')) { exit(1); }
-
-require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
+if (!defined('GNUSOCIAL')) { exit(1); }
 
 /**
  * Table Definition for file_to_post
  */
 
-class File_to_post extends Memcached_DataObject
+class File_to_post extends Managed_DataObject
 {
     ###START_AUTOCODE
     /* the code below is auto generated do not remove the above tag */
@@ -35,35 +33,82 @@ class File_to_post extends Memcached_DataObject
     public $post_id;                         // int(4)  primary_key not_null
     public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
 
-    /* Static get */
-    function staticGet($k,$v=NULL) { return Memcached_DataObject::staticGet('File_to_post',$k,$v); }
-
     /* the code above is auto generated do not remove the tag below */
     ###END_AUTOCODE
 
-    function processNew($file_id, $notice_id) {
+    public static function schemaDef()
+    {
+        return array(
+            'fields' => array(
+                'file_id' => array('type' => 'int', 'not null' => true, 'description' => 'id of URL/file'),
+                'post_id' => array('type' => 'int', 'not null' => true, 'description' => 'id of the notice it belongs to'),
+                'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
+            ),
+            'primary key' => array('file_id', 'post_id'),
+            'foreign keys' => array(
+                'file_to_post_file_id_fkey' => array('file', array('file_id' => 'id')),
+                'file_to_post_post_id_fkey' => array('notice', array('post_id' => 'id')),
+            ),
+            'indexes' => array(
+                'file_id_idx' => array('file_id'),
+                'post_id_idx' => array('post_id'),
+            ),
+        );
+    }
+
+    static function processNew(File $file, Notice $notice) {
         static $seen = array();
-        if (empty($seen[$notice_id]) || !in_array($file_id, $seen[$notice_id])) {
 
-            $f2p = File_to_post::pkeyGet(array('post_id' => $notice_id,
-                                               'file_id' => $file_id));
-            if (empty($f2p)) {
+        $file_id = $file->getID();
+        $notice_id = $notice->getID();
+        if (!array_key_exists($notice_id, $seen)) {
+            $seen[$notice_id] = array();
+        }
+
+        if (empty($seen[$notice_id]) || !in_array($file_id, $seen[$notice_id])) {
+            try {
+                $f2p = File_to_post::getByPK(array('post_id' => $notice_id,
+                                                   'file_id' => $file_id));
+            } catch (NoResultException $e) {
                 $f2p = new File_to_post;
                 $f2p->file_id = $file_id;
                 $f2p->post_id = $notice_id;
                 $f2p->insert();
+                
+                $file->blowCache();
             }
 
-            if (empty($seen[$notice_id])) {
-                $seen[$notice_id] = array($file_id);
-            } else {
-                $seen[$notice_id][] = $file_id;
-            }
+            $seen[$notice_id][] = $file_id;
         }
     }
 
-    function pkeyGet($kv)
+    static function getNoticeIDsByFile(File $file)
     {
-        return Memcached_DataObject::pkeyGet('File_to_post', $kv);
+        $f2p = new File_to_post();
+
+        $f2p->selectAdd();
+        $f2p->selectAdd('post_id');
+
+        $f2p->file_id = $file->getID();
+
+        $ids = array();
+
+        if (!$f2p->find()) {
+            throw new NoResultException($f2p);
+        }
+
+        return $f2p->fetchAll('post_id');
+    }
+
+    function delete($useWhere=false)
+    {
+        try {
+            $f = File::getByID($this->file_id);
+            $f->blowCache();
+        } catch (NoResultException $e) {
+            // ...alright, that's weird, but no File to delete anyway.
+        }
+
+        return parent::delete($useWhere);
     }
 }