diff options
| -rw-r--r-- | plugins/GNUsocialPhotos/GNUsocialPhotosPlugin.php | 7 | ||||
| -rw-r--r-- | plugins/GNUsocialPhotos/classes/gnusocialphoto.php | 4 | ||||
| -rw-r--r-- | plugins/GNUsocialPhotos/classes/gnusocialphotoalbum.php | 94 |
3 files changed, 104 insertions, 1 deletions
diff --git a/plugins/GNUsocialPhotos/GNUsocialPhotosPlugin.php b/plugins/GNUsocialPhotos/GNUsocialPhotosPlugin.php index f67cfec34..8aa10c7f7 100644 --- a/plugins/GNUsocialPhotos/GNUsocialPhotosPlugin.php +++ b/plugins/GNUsocialPhotos/GNUsocialPhotosPlugin.php @@ -54,6 +54,7 @@ class GNUsocialPhotosPlugin extends Plugin } include_once $dir . '/classes/gnusocialphoto.php'; + include_once $dir . '/classes/gnusocialphotoalbum.php'; return true; } @@ -63,9 +64,13 @@ class GNUsocialPhotosPlugin extends Plugin $schema->ensureTable('GNUsocialPhoto', array(new ColumnDef('notice_id', 'int(11)', null, false), new ColumnDef('album_id', 'int(11)', null, false), - //new ColumnDef('album_name', 'varchar(30)', null, false), new ColumnDef('uri', 'varchar(512)', null, false), new ColumnDef('thumb_uri', 'varchar(512)', null, false))); + $schema->ensureTable('GNUsocialPhotoAlbum', + array(new ColumnDef('album_id', 'int(11)', null, false, 'PRI', null, null, true), + new ColumnDef('profile_id', 'int(11)', null, false), + new ColumnDef('album_name', 'varchar(256)', null, false))); + } function onRouterInitialized($m) diff --git a/plugins/GNUsocialPhotos/classes/gnusocialphoto.php b/plugins/GNUsocialPhotos/classes/gnusocialphoto.php index 3ff0e494d..1b5a54587 100644 --- a/plugins/GNUsocialPhotos/classes/gnusocialphoto.php +++ b/plugins/GNUsocialPhotos/classes/gnusocialphoto.php @@ -62,6 +62,10 @@ class GNUsocialPhoto extends Memcached_DataObject return parent::delete(); } */ + + /* + * TODO: Foriegn key on album_id. + */ function table() { return array('notice_id' => DB_DATAOBJECT_INT + DB_DATAOBJECT_NOTNULL, diff --git a/plugins/GNUsocialPhotos/classes/gnusocialphotoalbum.php b/plugins/GNUsocialPhotos/classes/gnusocialphotoalbum.php new file mode 100644 index 000000000..853854e42 --- /dev/null +++ b/plugins/GNUsocialPhotos/classes/gnusocialphotoalbum.php @@ -0,0 +1,94 @@ +<?php +/** + * GNU Social + * Copyright (C) 2010, Free Software Foundation, Inc. + * + * PHP version 5 + * + * LICENCE: + * 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/>. + * + * @category Widget + * @package GNU Social + * @author Ian Denhardt <ian@zenhack.net> + * @author Sean Corbett <sean@gnu.org> + * @copyright 2010 Free Software Foundation, Inc. + * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html AGPL 3.0 + */ + +if (!defined('STATUSNET')) { + exit(1); +} + +require_once INSTALLDIR . '/classes/Memcached_DataObject.php'; + +class GNUsocialPhotoAlbum extends Memcached_DataObject +{ + public $__table = 'GNUsocialPhotoAlbum'; + public $album_id; // int(11) -- Unique identifier for the album + public $profile_id; // int(11) -- Profile ID for the owner of the album + public $album_name; // varchar(256) -- Title for this album + + + function staticGet($k,$v=NULL) + { + return Memcached_DataObject::staticGet('GNUsocialPhotoAlbum',$k,$v); + } + + + /* TODO: Primary key on both album_id, profile_id / foriegn key on profile_id */ + function table() + { + return array('album_id' => DB_DATAOBJECT_INT + DB_DATAOBJECT_NOTNULL, + 'profile_id' => DB_DATAOBJECT_INT + DB_DATAOBJECT_NOTNULL, + 'album_name' => DB_DATAOBJECT_STR + DB_DATAOBJECT_NOTNULL); + } + + function keys() + { + return array_keys($this->keyTypes()); + } + + + /* Using album_id as the primary key for now.. */ + function keyTypes() + { + return array('album_id' => 'K'); + } + + function sequenceKey() + { + return array(false, false, false); + } + + static function newAlbum($profile_id, $album_name) + { + //TODO: Should use foreign key instead... + if (!Profile::staticGet('id', $profile_id)){ + //Is this a bit extreme? + throw new ServerException(_m('No such user exists with id ' . $profile_id . ', couldn\'t create album.')); + } + + $album = new GNUsocialPhotoAlbum(); + //TODO: Should autoincrement.. + $album->profile_id = $profile_id; + $album->album_name = $album_name; + + if ($album->insert() == false){ + common_log_db_error($album, 'INSERT', __FILE__); + throw new ServerException(_m('Error creating new album.')); + } + } + +} |