public function __construct() { //TODO: Logging self::$Configuration = new DataContextConfigurationHandler(dirname(__FILE__) . "/Configuration.xml"); /* $url = (string)Setup::$Configuration->DataBaseUrl; $username = (string)Setup::$Configuration->UserName; $password = (string)Setup::$Configuration->Password; //Open a connection to the DB server $mysql = mysql_connect($url, $username, $password); //Select the databse $database = (string)Setup::$Configuration->Database; $bool = mysql_select_db($database, $mysql); $error = mysql_error($mysql); //Create the API keys table $query = "CREATE TABLE IF NOT EXISTS coreapikeys (apikey VARCHAR( 50 ) NOT NULL) CHARACTER SET utf8 COLLATE utf8_unicode_ci ;"; $bool = mysql_query($query, $mysql); $error = mysql_error($mysql); //Create the channelprocessingjobs table $query = "CREATE TABLE IF NOT EXISTS channelprocessingjobs ( id LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , type VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , parameters LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , updateperiod INT NOT NULL , nextrun DATETIME NOT NULL, lastrun DATETIME NULL , lastSuccess DATETIME NULL , timesrun INT NOT NULL, active TINYINT NOT NULL ) CHARACTER SET utf8 COLLATE utf8_unicode_ci "; $bool = mysql_query($query, $mysql); $error = mysql_error($mysql); mysql_close($mysql); * */ //initiate the redbean framework RedBeanController::RedBean(); }
/** * Given a set of content items, this method will persist * them to the data store, if they already exists then this * method should update the values in the data store. * * @param \Swiftriver\Core\ObjectModel\Content[] $content */ public static function SaveContent($content) { //initiate the redbean dal contoller $rb = RedBeanController::RedBean(); //loop throught each oitem of content foreach ($content as $item) { $potentials = RedBeanController::Finder()->where("contentitems", "textid = :id limit 1", array(":id" => $item->GetId())); if (isset($potentials) && is_array($potentials)) { //set the content to be the one from the DB $i = $potentials[1]; //1 base - how silly ?!?!?! } else { //tell the dal what table we are dealing with $i = $rb->dispense("contentitems"); //copy over the properties $i->textId = $item->GetId(); } $i->state = $item->GetState(); $i->title = $item->GetTitle(); $i->link = $item->GetLink(); //comit the content to the DB $rb->store($i); //First remove all existing text $textToRemove = RedBeanController::GetRelatedBeans($i, "content_text"); if (isset($textToRemove) && is_array($textToRemove)) { foreach ($textToRemove as $ttr) { $rb->trash($ttr); } } //Then add the nest text foreach ($item->GetText() as $text) { //initiare the db table $t = $rb->dispense("content_text"); //extratc the text $t->text = $text; //store the text $rb->store($t); //Assocate the text with the content RedBeanController::Associate($t, $i); } //first remove the existing tags $tagsToRemove = RedBeanController::GetRelatedBeans($i, "content_tags"); if (isset($tagsToRemove) && is_array($tagsToRemove)) { foreach ($tagsToRemove as $ttr) { $rb->trash($ttr); } } //then add all new tags foreach ($item->GetTags() as $tag) { //initiate the tags db table $t = $rb->dispense("content_tags"); //get the tag properties $t->type = $tag->GetType(); $t->text = $tag->GetText(); //store the tag $rb->store($t); //Associate the tag with the content RedBeanController::Associate($t, $i); } //first remove all existing difcollection and their difs $difCollectionsToRemove = RedBeanController::GetRelatedBeans($i, "dif_collections"); if (isset($difCollectionsToRemove) && is_array($difCollectionsToRemove)) { foreach ($difCollectionsToRemove as $dctr) { $rb->trash($dctr); } } //loop through the DFICollections foreach ($item->GetDifs() as $collection) { //initiate the dif collection db table $c = $rb->dispense("dif_collections"); //Get the properties $c->name = $collection->GetName(); //store the collection $rb->store($c); //Associate the collection with the contet RedBeanController::Associate($c, $i); //Loop through the difs foreach ($collection->GetDifs() as $dif) { //initiate the dif db table $d = $rb->dispense("difs"); //Get the properties $d->type = $dif->GetType(); $d->value = $dif->GetValue(); //store the dif $rb->store($d); //associate the dif with the collection RedBeanController::Associate($d, $c); } } } }
/** * This method redords the fact that a marker (sweeper) has changed the score * of a source by marking a content items as either 'acurate', 'chatter' or * 'inacurate' * * @param string $sourceId * @param string $markerId * @param int $change */ public static function RecordSourceScoreChange($sourceId, $markerId, $change, $reason = null) { $logger = \Swiftriver\Core\Setup::GetLogger(); $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::RecordSourceScoreChange [Method invoked]", \PEAR_LOG_DEBUG); //get the red bean $rb = RedBeanController::RedBean(); //create a new entry $entry = $rb->dispense("trustlog_sourcescorechange"); //add the properties $entry->sourceId = $sourceId; $entry->markerId = $markerId; $entry->change = $change; if ($reason != null) { $entry->reason = $reason; } //save the entry $rb->store($entry); $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::RecordSourceScoreChange [Method finished]", \PEAR_LOG_DEBUG); }