<?php
require_once "/etc/apache2/capstone-mysql/encrypted-config.php";
$pdo = connectToEncryptedMySQL("/etc/apache2/data-design/dmartinez337.ini");
$tweet = new Tweet(null, 1, "this is from PHP");
$tweet->insert($pdo);
$tweet->setTweetContent("now I changed the message");
$tweet->update($pdo);
$tweet->delete($pdo);
/**
* test deleting a Tweet that does not exist
*
* @expectedException PDOException
**/
public function testDeleteInvalidTweet()
{
// create a Tweet and try to delete it without actually inserting it
$tweet = new Tweet(null, $this->profile->getProfileId(), $this->VALID_TWEETCONTENT, $this->VALID_TWEETDATE);
$tweet->update($this->getPDO());
}
$applications = DBObject::glob('Application', 'SELECT * FROM shine_applications ORDER BY name');
if (isset($_GET['refresh'])) {
include 'tweet-cron.php';
}
if (isset($_GET['delete'])) {
$t = new Tweet($_GET['delete']);
$t->deleted = 1;
$t->new = 0;
$t->update();
}
if (isset($_GET['reply'])) {
$t = new Tweet($_GET['reply']);
$t->replied_to = 1;
$t->reply_date = dater();
$t->new = 0;
$t->update();
redirect("http://twitter.com/home?status=@{$t->username}%20&in_reply_to={$t->tweet_id}");
}
$sql = '';
$app_id = '';
$group = '';
if (isset($_GET['id']) && !empty($_GET['id'])) {
$sql = 'AND app_id = ' . intval($_GET['id']);
$app_id = intval($_GET['id']);
} else {
$group = ' GROUP BY tweet_id ';
}
if (isset($_GET['read'])) {
$db = Database::getDatabase();
$db->query("UPDATE shine_tweets SET new = 0 WHERE 1 = 1 {$sql}");
redirect("tweets.php?id={$app_id}");