Ejemplos de mysql5_trigger::get_drop_sql en PHP

Ejemplo n.º 1

Archivo: Mysql5TriggerSQLTest.php Proyecto: williammoran/DBSteward

    public function testOtherFormats()
    {
        $xml = <<<XML
<schema name="public">
  <table name="table"></table>
  <trigger name="trigger" sqlFormat="pgsql8" table="table" when="before" event="insert" function="EXECUTE xyz"/>
</schema>
XML;
        $schema = new SimpleXMLElement($xml);
        $expected = "-- Ignoring pgsql8 trigger 'trigger'";
        $actual = trim(mysql5_trigger::get_creation_sql($schema, $schema->trigger));
        $this->assertEquals($expected, $actual);
        $expected = "-- Ignoring pgsql8 trigger 'trigger'";
        $actual = trim(mysql5_trigger::get_drop_sql($schema, $schema->trigger));
        $this->assertEquals($expected, $actual);
    }