in case creation is empty

Signed-off-by: Maxence Lange <maxence@artificial-owl.com>

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();