1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| private function updateDB()
{
// on se connecte à MySQL on sélectionne la base
$dbmy = mysql_connect($localhost, $root, $'') or die ("Impossible de se connecter : " . mysql_error());
mysql_select_db($sugarcrm,$dbmy);
// on se connecte à PostgreSQL et on selectionne la base
$dbpg = pg_connect("host=localhost port=5432 dbname=terp user=tinypg password=password")or die ("Impossible de se connecter : " . pg_last_error());
//requete
$query1 = 'CREATE TRIGGER account_my AFTER INSERT OR DELETE OR UPDATE ON account FOR EACH ROW
BEGIN
END;';
$query2 = 'CREATE TRIGGER account_pg AFTER INSERT OR DELETE OR UPDATE ON account FOR EACH ROW
BEGIN
END;';
$result1 = mysql_query($dbmy,$query1);
$result2 = pg_query($dbpg,$query2);
} |
Partager