(no commit message)

[edu/osp-wiki.git] / student / dendimar / index.mdwn

diff --git a/student/dendimar/index.mdwn b/student/dendimar/index.mdwn
index 62549185d6f5eb6e0a2ae8ab21f8cd9e0854fcb1..c9fc71b9fdb2e9781b1efddc30141df554ae7706 100644 (file)
--- a/student/dendimar/index.mdwn
+++ b/student/dendimar/index.mdwn
@@ -7,10 +7,28 @@ Assignment
 
 I'd like to help fix some bugs in database layout I've discovered
 
-1. [Quick access to real row count](https://sourceforge.net/p/phpmyadmin/feature-requests/1448/)
-2. [Easy access to SHOW CREATE](https://sourceforge.net/p/phpmyadmin/feature-requests/1445/)
-3. [Remove the distinct query window](https://sourceforge.net/p/phpmyadmin/feature-requests/1492/)
-4. [Support InnoDB for database Query by example](https://sourceforge.net/p/phpmyadmin/feature-requests/1491/)
+(a) If I have in database column with type time/timeint, database layout will return it's values as instance of class DateInterval. But when I want to insert or update this column, database layout can't process DateInterval & crashes.
+See the example:
+
+>     // This works just fine
+>     $actRow = $this->connection->table('test')->insert(array('time' => '1:30:00'));
+> 
+>     // But this will crash, because database layout can't deal with class DateInterval on insert or update
+>     $actRow = $this->connection->table('test')->insert(array('time' => new \DateInterval('PT1H30M')));
+> 
+>     // On the other hand
+>     $actRow = $this->connection->table('test')->insert(array('time' => '1:30:00'));
+>     echo $actRow['time'] instanceof \DateInterval ? 'Yes' : 'No'; // Will print Yes
+
+(b) If I'm working with ActivRow and I want to update column which is defined as primary key the app crashes. It's because after each update of ActiveRow database layout fetches (refreshes) row from database, but with old values of primary keys. Seethe example:
+
+>     // In database I have in table test defined column id as primary key
+>     $actRow = $this->connection->table('test')->insert(array('username' => 'marek'));
+>
+>     // This operation will fail, the data in the database has been modified
+>     // But after update, database layout will try to refresh ActiveRow from database 
+>     // and use old primary key 'marek' instead of new one 'ondra' so no record is found and exception is thrown
+>     $actRow->update(array('username' => 'ondra'));
 
 and maybe some others...
  
@@ -37,3 +55,5 @@ For example:
 
 
   [1]: https://sourceforge.net/p/phpmyadmin/feature-requests/1491/
+
+