diff options
-rw-r--r-- | lib/Migration/Version0002Date20190506000001.php | 19 |
1 files changed, 15 insertions, 4 deletions
diff --git a/lib/Migration/Version0002Date20190506000001.php b/lib/Migration/Version0002Date20190506000001.php index a115997c..59aa6a5e 100644 --- a/lib/Migration/Version0002Date20190506000001.php +++ b/lib/Migration/Version0002Date20190506000001.php @@ -32,9 +32,12 @@ namespace OCA\Social\Migration; use Closure; +use DateTime; use Doctrine\DBAL\Types\Type; +use Exception; use OCA\Social\Db\CoreRequestBuilder; use OCP\DB\ISchemaWrapper; +use OCP\DB\QueryBuilder\IQueryBuilder; use OCP\IDBConnection; use OCP\Migration\IOutput; use OCP\Migration\SimpleMigrationStep; @@ -1172,7 +1175,6 @@ class Version0002Date20190506000001 extends SimpleMigrationStep { $cursor = $qb->execute(); while ($data = $cursor->fetch()) { $this->insertInto($dest, $fields, $data); - } $cursor->closeCursor(); @@ -1183,6 +1185,8 @@ class Version0002Date20190506000001 extends SimpleMigrationStep { * @param string $table * @param array $fields * @param array $data + * + * @throws Exception */ private function insertInto(string $table, array $fields, array $data) { $insert = $this->connection->getQueryBuilder(); @@ -1196,9 +1200,16 @@ class Version0002Date20190506000001 extends SimpleMigrationStep { $value = hash('sha512', $this->get('id', $data, '')); } - $insert->setValue( - $field, $insert->createNamedParameter($value) - ); + if ($field === 'creation' && $value === '') { + $insert->setValue( + 'creation', + $insert->createNamedParameter(new DateTime('now'), IQueryBuilder::PARAM_DATE) + ); + } else { + $insert->setValue( + $field, $insert->createNamedParameter($value) + ); + } } $insert->execute(); |