public function delete() { if (empty($this->id)) { return; } $strTableName = strtolower(get_class($this)); App_Db::write("DELETE FROM {$strTableName} WHERE id = :id", [':id' => $this->id]); unset($this); }
public function markMessageAllRead(User $objSender) { App_Db::write("UPDATE message SET unread=0 WHERE sender_id = :sender_id AND recipient_id = :recipient_id", [':recipient_id' => $this->getId(), ':sender_id' => $objSender->getId()]); }
public function run() { App::debug(['Drop table user']); App_Db::write('DROP TABLE IF EXISTS `user`'); App::debug(['Creating table user']); App_Db::write('CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `login` varchar(50) NOT NULL DEFAULT \'\', `first_name` varchar(100) NOT NULL DEFAULT \'\', `last_name` varchar(100) NOT NULL DEFAULT \'\', `admin` TINYINT(1) NOT NULL DEFAULT 0, `ban` TINYINT(1) NOT NULL DEFAULT 0, `password` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8'); App::debug(["Add users"]); App_Db::write('INSERT INTO `user` VALUES ( 1, "admin", "John", "Doe", 1, 0, "admin" ), ( 2, "james_g", "James", "Grisham", 0, 0, "john_g" ), ( 3, "robin_c", "Robin", "Cook", 0, 1, "robin_c" )'); App::debug(['Drop table message']); App_Db::write('DROP TABLE IF EXISTS `message`'); App::debug(['Creating table message']); App_Db::write(' CREATE TABLE `message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sender_id` int(11) NOT NULL, `recipient_id` int(11) NOT NULL, `unread` TINYINT(1) NOT NULL DEFAULT 1, `message` text NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, KEY `i_sender_id` (`sender_id`), KEY `i_recipient_id` (`recipient_id`), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8'); App::debug(["Add messages"]); App_Db::write('INSERT INTO `message` VALUES ( 1, 1, 2, 1, "Test message 1", CURRENT_TIMESTAMP ), ( 2, 2, 1, 1, "Test message 2", CURRENT_TIMESTAMP ), ( 3, 1, 2, 1, "Test message 3", CURRENT_TIMESTAMP )'); }