<?php /* Test unit para comprobar los metodos de la clase DBManager * Puede generar un monton de usuarios dummys que deberan de ser eliminados en su dia * Felipe Vieira */ require "DBManager.php"; $man = new DBManager(); function say_error($correct) { if ($correct) { echo "creacion realizada correctamente<br/>"; } else { echo "Ya existia un dato asi en la base de datos<br/>"; } } if ($man->connect()) { say_error($man->insertarRol("rolDummy1", "rol de test unit")); say_error($man->insertarFun("funDummy1", "funcion de test unit")); say_error($man->insertarPag("pagDummy1", "pagina de test unit")); say_error($man->insertarUser("userDummy1", "12345", "usuario de test unit", "dummy@dummy")); say_error($man->insertarRol("rolDummy2", "rol de test unit")); say_error($man->insertarFun("funDummy2", "funcion de test unit")); say_error($man->insertarPag("pagDummy2", "pagina de test unit")); say_error($man->insertarUser("userDummy2", "12345", "usuario de test unit", "dummy@dummy")); $result = $man->listRolesByUser("userDummy1"); $result = $man->listRolesByFun("userDummy1"); $result = $man->listUsersByRol("rolDummy1"); foreach ($result as $item) { echo $item; } }
print 'No Notifier Selected.'; break; } $objNotifier->notify(); print "</br>"; /*---------- Design Patterns: Strategy Pattern ----------*/ //$MM = new MySQLManager(); //$MM->setHost("localhost"); //$MM->setDB("db"); //$MM->setUserName("user"); //$MM->setPassword("password"); //$MM->connect(); // ... do all this to other database drivers ... $DM = new DBManager(); $DM->setDriver('mysql'); $DM->connect('host', 'database', 'user_mysql', 'admin'); /*---------- Design Patterns: Abstract Pattern ----------*/ $manager = new MySQLManagerAbstract(); $manager->setUserName('wdarking'); $manager->connect(); /*---------- Design Patterns: Singleton Pattern ----------*/ $a = new MySQLManager(); $b = new MySQLManager(); $c = new MySQLManager(); $d = new MySQLManager(); $e = new MySQLManager(); /*---------- Design Patterns: Iterator Pattern ----------*/ /*$blogposts = getAllPosts(); $posts = new Posts($blogposts); foreach ($posts as $post) { echo($post->getTitle());
$db->setHost("192.168.1.11"); $db->setUser("admin"); $db->setPassword("admin"); $db->setDBName("mambo"); $db->connect(); $SQLCmd = "select id, menutype, name from mos_menu"; */ /* $db = new DBManager($DB_MANAGER->DB_ORACLE8); $db->parseURL("db.oci8://reward:reward2005@flexim"); $db->connect(); $SQLCmd = "select * from watch"; */ $db = new DBManager($DB_MANAGER->DB_POSTGRES); $db->parseURL("db.postgres://*****:*****@127.0.0.1:5432/flextor"); $db->connect(); $SQLCmd = "SELECT * FROM ipm_sc.modules"; if (!$db->isConnect) { echo "not connected<br>"; echo $db->getHost() . "<br>"; echo $db->getPort() . "<br>"; echo $db->getUser() . "<br>"; echo $db->getPassword() . "<br>"; } /* Querying Database */ //$resultsets = new ResultSet(); $resultsets = new ResultSet(); $resultsets = $db->query($SQLCmd); echo "Result Count = " . $resultsets->size() . " column = " . $resultsets->columnSize() . "<br>"; $counter = 0; while ($resultsets->next()) {