f1 = $f1; $this->f2 = $f2; } } interface T1DatabaseAccess { public function get_one($f2); public function get_all(); public function put($o); public function remove($f1); } class T1DatabaseAccessDoctrine implements T1DatabaseAccess { private $em; public function __construct($conattr) { // connect to server, select database and setup mapping $mapping = Setup::createXMLMetadataConfiguration(array(__DIR__)); $this->em = EntityManager::create($conattr, $mapping); } public function get_one($f2) { // execute query builder $qb = $this->em->createQueryBuilder(); $qb->select('t1')->from('T1', 't1')->where('t1.f2=:f2'); $q = $qb->getQuery(); $q->setParameter('f2', $f2); $res = $q->getResult(); // return value if(count($res) > 0) { return $res[0]; } else { die("$f2 not found"); } } public function get_all() { // execute query builder $qb = $this->em->createQueryBuilder(); $qb->select('t1')->from('T1', 't1'); $q = $qb->getQuery(); $res = $q->getResult(); // return collection with rows return $res; } public function put($o) { // persist and flush $this->em->persist($o); $this->em->flush(); } public function remove($f1) { // find, remove and flush $entity = $this->em->find('T1', $f1); $this->em->remove($entity); $this->em->flush(); } } class T1DatabaseAccessFactory { const DOCTRINE = 'DOCTRINE'; public static function get_database_access($id, $conattr) { if($id === T1DatabaseAccessFactory::DOCTRINE) { return new T1DatabaseAccessDoctrine($conattr); } else { throw new Exception("Unknown T1DatabaseAccess id: $id"); } } } interface T1Presenter { public function display($data); } class T1PresenterHtmlTable implements T1Presenter { public function display($data) { $rows = ""; foreach($data as $row) { $f1 = $row->f1; $f2 = $row->f2; $rows .= sprintf("
F1 | \r\nF2 | \r\n
---|