Changes between Version 6 and Version 7 of members/GRIP-UQAM/PHP/Packages


Ignore:
Timestamp:
Jan 18, 2017, 8:26:18 AM (5 years ago)
Author:
https://id.mayfirst.org/gripuqam
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • members/GRIP-UQAM/PHP/Packages

    v6 v7  
    410410
    411411=== Features ===
    412 * The schema manager creates FOREIGN KEY CONSTRAINTs with ALTER TABLE.
     412* Database insert seems better handled by (dbal 2.5.8)
     413{{{#!php
     414$conn->insert($TaxoTable->getName(), ['term' => 'dbal']);
     415}}}
     416than by
     417{{{#!php
     418$queryBuilder = $conn->createQueryBuilder();
     419$queryBuilder
     420    ->insert($UrlTable->getName())
     421    ->values(['url' => "xyz"])
     422;
     423echo $queryBuilder->getSQL() . "<br>\n";
     424$conn->executeUpdate($queryBuilder->getSQL());
     425// $queryBuilder->execute();
     426// Does not work because the value is not between "" in the produced SQL.
     427}}}
     428* The schema manager creates FOREIGN KEY CONSTRAINTs with ALTER TABLE. (This seems to be solved in 2.5.8)
    413429 * This allows to create the associated index before the foreign key constraint. This can be useful to create a named index before it is already automatically created by some databases.
    414430 * It is not sure if it can work with sqlite. It seems it should not. [https://www.sqlite.org/lang_altertable.html SQL As Understood By SQLite: ALTER TABLE] [https://www.sqlite.org/syntax/foreign-key-clause.html foreign-key-clause]