* 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 */
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
+ 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(
+ 'post_id_idx' => array('post_id'),
+ ),
+ );
+ }
+
function processNew($file_id, $notice_id) {
static $seen = array();
if (empty($seen[$notice_id]) || !in_array($file_id, $seen[$notice_id])) {
$f2p->file_id = $file_id;
$f2p->post_id = $notice_id;
$f2p->insert();
+
+ $f = File::getKV($file_id);
+
+ if (!empty($f)) {
+ $f->blowCache();
+ }
}
if (empty($seen[$notice_id])) {
}
}
- function pkeyGet($kv)
+ function delete($useWhere=false)
{
- return Memcached_DataObject::pkeyGet('File_to_post', $kv);
+ $f = File::getKV('id', $this->file_id);
+ if (!empty($f)) {
+ $f->blowCache();
+ }
+ return parent::delete($useWhere);
}
}
-