} $c = new Criteria(); $c->add(OppPoliticoPeer::ID, 999999); $existing_records = OppPoliticoPeer::doSelect($c); foreach ($existing_records as $rec) { $t->diag('Cleaning record ' . get_class($rec) . "(" . $rec->getId() . ")"); $rec->delete(); } $t->diag('Create the test act object'); $obj = new OppAtto(); $obj->setTipoAttoId(1); $obj->setParlamentoId(999999); $obj->setRamo('S'); $obj->setNumFase(914); $obj->setDataPres('2008-11-01'); $obj->setDescrizione("Una descrizione di prova"); $obj->save(); $related_news = getRelatedNews($obj); $n_related_news = count($related_news); $first_news = $related_news[0]; $t->ok($n_related_news == 1, 'One news related to the act was generated'); dumpNews($t, "news related to the act", $related_news); $t->diag('Create a non-final votation: two more news expected (group and detail)'); $vot = OppVotazionePeer::retrieveByPK(9900); $vot_att = new OppVotazioneHasAtto(); $vot_att->setOppVotazione($vot); $vot_att->setOppAtto($obj); $vot_att->save(); $related_news = getRelatedNews($obj); $n_related_news = count($related_news); $t->ok($n_related_news == 3, 'Now there are two more news related to the act');
$t->diag('Cleaning record ' . get_class($rec) . "(" . $rec->getId() . ")"); $rec->delete(); } $c = new Criteria(); $c->add(OppVotazionePeer::NUMERO_VOTAZIONE, 999999); $existing_records = OppVotazionePeer::doSelect($c); foreach ($existing_records as $rec) { $t->diag('Cleaning record ' . get_class($rec) . "(" . $rec->getId() . ")"); $rec->delete(); } $t->diag('Create the act object'); $obj_atto = new OppAtto(); $obj_atto->setTipoAttoId(1); $obj_atto->setParlamentoId(999999); $obj_atto->setDataPres('2008-11-01'); $obj_atto->setDescrizione("Un'atto di test"); $obj_atto->save(); $prefix = sfConfig::get(sprintf('propel_behavior_wikifiableBehavior_%s_prefix', get_class($obj_atto))); $t->ok($prefix == 'atto', 'The prefix was correctly read from the behavior configuration'); $wiki_page = nahoWikiPagePeer::retrieveByName($prefix . "_" . $obj_atto->getId()); $t->ok($wiki_page instanceof nahoWikiPage, 'a wiki page was just created for this object'); $c = new Criteria(); $c->add(nahoWikiRevisionPeer::REVISION, 1); $wiki_revisions = $wiki_page->getRevisions($c); $wiki_revision = $wiki_revisions[0]; $t->ok(count($wiki_revisions) == 1 && $wiki_revision instanceof nahoWikiRevision, 'a wiki revision was added'); $wiki_content = $wiki_revision->getnahoWikiContent(); $t->ok($wiki_content instanceof nahoWikiContent, 'a wiki content was also added'); $t->ok($wiki_revision->getComment() == 'Creazione Automatica' && $wiki_revision->getContent() == 'Descrizione wiki, a cura degli utenti.', 'comment and content were correctly inserted'); $atto_page_id = $wiki_page->getId(); $atto_revision_num = $wiki_revision->getRevision();
<?php define('SF_ROOT_DIR', realpath(dirname(__FILE__) . '/..')); define('SF_APP', 'fe'); define('SF_ENVIRONMENT', 'dev'); define('SF_DEBUG', false); require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php'; sfContext::getInstance(); $ddls = OppDdlPeer::doSelect(new Criteria()); foreach ($ddls as $ddl) { $atto = new OppAtto(); $atto->setId($ddl->getId()); $atto->setParlamentoId($ddl->getParlamentoId()); $atto->setTipoAttoId($ddl->getTipo()); $atto->setRamo($ddl->getRamo()); $atto->setNumfase($ddl->getNumfase()); $atto->setLegislatura($ddl->getLegislatura()); $atto->setDataPres($ddl->getDataPres()); $atto->setDataAgg($ddl->getDataAgg()); $atto->setTitolo($ddl->getTitolo()); $atto->setIniziativa($ddl->getIniziativa()); $atto->setCompleto($ddl->getCompleto()); $atto->setDescrizione($ddl->getDescrizione()); $atto->setSeduta($ddl->getSeduta()); $atto->setIter($ddl->getIter()); $atto->setDataIter($ddl->getDataIter()); $atto->save(); print "atto: " . $atto->getId() . "...\n"; } print "done.\n";
$t->diag('Tests beginning'); // clean the database $t->diag('Cleaning previously created test records'); $c = new Criteria(); $c->add(OppAttoPeer::PARLAMENTO_ID, 999999); $existing_records = OppAttoPeer::doSelect($c); foreach ($existing_records as $rec) { $t->diag('Cleaning record ' . $rec->getId()); $rec->delete(); } $t->diag('Preparing a longvarchar variable'); $longvarchar = ''; for ($i = 0; $i < 15000; $i++) { $longvarchar .= 'pippo '; } $var_length = strlen($longvarchar); $t->diag('Long variable created: length=' . $var_length); $t->diag('Create the test OppAtto object'); $obj = new OppAtto(); $obj->setTipoAttoId(1); $obj->setParlamentoId(999999); $obj->setDescrizione($longvarchar); $obj->save(); $c = new Criteria(); $c->add(OppAttoPeer::PARLAMENTO_ID, 999999); $read_obj = OppAttoPeer::doSelectOne($c); $read_var = $read_obj->getDescrizione(); $read_length = strlen($read_var); $t->diag('Long variable read from DB: length=' . $read_length); $t->ok($read_var == $longvarchar, 'the variable was set correctly'); $t->ok($read_length == $var_length, 'the length is ok');