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

Timestamp:

Jan 18, 2017, 1:26:18 PM (9 years ago)

Author:

Grip Uqam

Comment:

--

members/GRIP-UQAM/PHP/Packages

@@ -410 +410 @@
 
 === Features ===
-* The schema manager creates FOREIGN KEY CONSTRAINTs with ALTER TABLE.
+* Database insert seems better handled by (dbal 2.5.8)
+{{{#!php
+$conn->insert($TaxoTable->getName(), ['term' => 'dbal']);
+}}}
+than by
+{{{#!php
+$queryBuilder = $conn->createQueryBuilder();
+$queryBuilder
+    ->insert($UrlTable->getName())
+    ->values(['url' => "xyz"])
+;
+echo $queryBuilder->getSQL() . "<br>\n";
+$conn->executeUpdate($queryBuilder->getSQL());
+// $queryBuilder->execute();
+// Does not work because the value is not between "" in the produced SQL.
+}}}
+* The schema manager creates FOREIGN KEY CONSTRAINTs with ALTER TABLE. (This seems to be solved in 2.5.8)
  * 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.
  * 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]