From 5e9009ce86a366001616fad5b28cb59dc20ee4df Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= <nicolas@loeuillet.org>
Date: Wed, 5 Apr 2017 22:22:16 +0200
Subject: Added publication date

---
 app/DoctrineMigrations/Version20170405182620.php | 55 ++++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 app/DoctrineMigrations/Version20170405182620.php

(limited to 'app/DoctrineMigrations/Version20170405182620.php')

diff --git a/app/DoctrineMigrations/Version20170405182620.php b/app/DoctrineMigrations/Version20170405182620.php
new file mode 100644
index 00000000..1e020c17
--- /dev/null
+++ b/app/DoctrineMigrations/Version20170405182620.php
@@ -0,0 +1,55 @@
+<?php
+
+namespace Application\Migrations;
+
+use Doctrine\DBAL\Migrations\AbstractMigration;
+use Doctrine\DBAL\Schema\Schema;
+use Symfony\Component\DependencyInjection\ContainerAwareInterface;
+use Symfony\Component\DependencyInjection\ContainerInterface;
+
+/**
+ * Add published_at in `entry` table.
+ */
+class Version20170405182620 extends AbstractMigration implements ContainerAwareInterface
+{
+    /**
+     * @var ContainerInterface
+     */
+    private $container;
+
+    public function setContainer(ContainerInterface $container = null)
+    {
+        $this->container = $container;
+    }
+
+    private function getTable($tableName)
+    {
+        return $this->container->getParameter('database_table_prefix').$tableName;
+    }
+
+    /**
+     * @param Schema $schema
+     */
+    public function up(Schema $schema)
+    {
+        $entryTable = $schema->getTable($this->getTable('entry'));
+
+        $this->skipIf($entryTable->hasColumn('published_at'), 'It seems that you already played this migration.');
+
+        $entryTable->addColumn('published_at', 'datetime', [
+            'notnull' => false,
+        ]);
+    }
+
+    /**
+     * @param Schema $schema
+     */
+    public function down(Schema $schema)
+    {
+        $entryTable = $schema->getTable($this->getTable('entry'));
+
+        $this->skipIf(!$entryTable->hasColumn('published_at'), 'It seems that you already played this migration.');
+
+        $entryTable->dropColumn('published_at');
+    }
+}
-- 
cgit v1.2.3


From 7b0b3622ab2dd909028481b294c91f88a5682671 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= <nicolas@loeuillet.org>
Date: Thu, 6 Apr 2017 09:36:20 +0200
Subject: Added author of article

---
 app/DoctrineMigrations/Version20170405182620.php | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'app/DoctrineMigrations/Version20170405182620.php')

diff --git a/app/DoctrineMigrations/Version20170405182620.php b/app/DoctrineMigrations/Version20170405182620.php
index 1e020c17..c1ae7df9 100644
--- a/app/DoctrineMigrations/Version20170405182620.php
+++ b/app/DoctrineMigrations/Version20170405182620.php
@@ -8,7 +8,7 @@ use Symfony\Component\DependencyInjection\ContainerAwareInterface;
 use Symfony\Component\DependencyInjection\ContainerInterface;
 
 /**
- * Add published_at in `entry` table.
+ * Add published_at and published_by in `entry` table.
  */
 class Version20170405182620 extends AbstractMigration implements ContainerAwareInterface
 {
@@ -39,6 +39,10 @@ class Version20170405182620 extends AbstractMigration implements ContainerAwareI
         $entryTable->addColumn('published_at', 'datetime', [
             'notnull' => false,
         ]);
+
+        $entryTable->addColumn('published_by', 'text', [
+            'notnull' => false,
+        ]);
     }
 
     /**
@@ -51,5 +55,6 @@ class Version20170405182620 extends AbstractMigration implements ContainerAwareI
         $this->skipIf(!$entryTable->hasColumn('published_at'), 'It seems that you already played this migration.');
 
         $entryTable->dropColumn('published_at');
+        $entryTable->dropColumn('published_by');
     }
 }
-- 
cgit v1.2.3


From 3aa655e44a1a41296454d146aa948f2889904f81 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= <nicolas@loeuillet.org>
Date: Mon, 10 Apr 2017 09:26:08 +0200
Subject: Fixed migrations

---
 app/DoctrineMigrations/Version20170405182620.php | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'app/DoctrineMigrations/Version20170405182620.php')

diff --git a/app/DoctrineMigrations/Version20170405182620.php b/app/DoctrineMigrations/Version20170405182620.php
index c1ae7df9..3ef9633f 100644
--- a/app/DoctrineMigrations/Version20170405182620.php
+++ b/app/DoctrineMigrations/Version20170405182620.php
@@ -40,6 +40,8 @@ class Version20170405182620 extends AbstractMigration implements ContainerAwareI
             'notnull' => false,
         ]);
 
+        $this->skipIf($entryTable->hasColumn('published_by'), 'It seems that you already played this migration.');
+
         $entryTable->addColumn('published_by', 'text', [
             'notnull' => false,
         ]);
@@ -55,6 +57,9 @@ class Version20170405182620 extends AbstractMigration implements ContainerAwareI
         $this->skipIf(!$entryTable->hasColumn('published_at'), 'It seems that you already played this migration.');
 
         $entryTable->dropColumn('published_at');
+
+        $this->skipIf(!$entryTable->hasColumn('published_by'), 'It seems that you already played this migration.');
+
         $entryTable->dropColumn('published_by');
     }
 }
-- 
cgit v1.2.3