* 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_thumbnail
{
public $__table = 'file_thumbnail'; // table name
public $file_id; // int(4) primary_key not_null
- public $url; // varchar(255) unique_key
- public $filename; // varchar(255)
+ public $url; // varchar(191) unique_key not 255 because utf8mb4 takes more space
+ public $filename; // varchar(191) not 255 because utf8mb4 takes more space
public $width; // int(4) primary_key
public $height; // int(4) primary_key
public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
return array(
'fields' => array(
'file_id' => array('type' => 'int', 'not null' => true, 'description' => 'thumbnail for what URL/file'),
- 'url' => array('type' => 'varchar', 'length' => 255, 'description' => 'URL of thumbnail'),
- 'filename' => array('type' => 'varchar', 'length' => 255, 'description' => 'if stored locally, filename is put here'),
+ 'url' => array('type' => 'varchar', 'length' => 191, 'description' => 'URL of thumbnail'),
+ 'filename' => array('type' => 'varchar', 'length' => 191, 'description' => 'if stored locally, filename is put here'),
'width' => array('type' => 'int', 'description' => 'width of thumbnail'),
'height' => array('type' => 'int', 'description' => 'height of thumbnail'),
'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
}
}
+ /**
+ * Fetch an entry by using a File's id
+ */
+ static function byFile(File $file) {
+ $file_thumbnail = self::getKV('file_id', $file->id);
+ if (!$file_thumbnail instanceof File_thumbnail) {
+ throw new ServerException(sprintf('No File_thumbnail entry for File id==%u', $file->id));
+ }
+ return $file_thumbnail;
+ }
+
/**
* Save a thumbnail record for the referenced file record.
*
return File::path($filename);
}
+ public function getPath()
+ {
+ return self::path($this->filename);
+ }
+
public function getUrl()
{
- if (!empty($this->filename)) {
- // A locally stored file, so let's generate a URL for our instance.
+ if (!empty($this->getFile()->filename)) {
+ // A locally stored File, so let's generate a URL for our instance.
$url = File::url($this->filename);
if ($url != $this->url) {
// For indexing purposes, in case we do a lookup on the 'url' field.