From e0bccca4eda12405a6fedcaed97762797369892f Mon Sep 17 00:00:00 2001
From: Andrey Kutejko <aku@anahoret.com>
Date: Tue, 20 Jan 2015 16:43:26 +0200
Subject: [PATCH] add example queries to template

---
 src/migrations.php |  4 +++-
 src/template       | 11 +++++++++++
 2 files changed, 14 insertions(+), 1 deletion(-)
 create mode 100644 src/template

diff --git a/src/migrations.php b/src/migrations.php
index cf75a89..94baff6 100644
--- a/src/migrations.php
+++ b/src/migrations.php
@@ -54,7 +54,9 @@ class Migrations
 
         $filename = $path.'/'.$ts.$name.'.php';
 
-        file_put_contents($filename, "<?php\n\nclass Migration_$ts extends \PFF\Migrations\Migration\n{\n    function migrate()\n    {\n    }\n}\n\n");
+        $template = file_get_contents(dirname(__FILE__) . '/template');
+        $content = str_replace('%TS%', $ts, $template);
+        file_put_contents($filename, $content);
 
         return $filename;
     }
diff --git a/src/template b/src/template
new file mode 100644
index 0000000..8ce16eb
--- /dev/null
+++ b/src/template
@@ -0,0 +1,11 @@
+<?php
+
+class Migration_%TS% extends \PFF\Migrations\Migration
+{
+    function migrate()
+    {
+        // $data = $this->query('SELECT * FROM table WHERE param = ?', array('value'));
+        // $this->connection->exec('CREATE TABLE table (id BIGINT AUTO_INCREMENT, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = INNODB');
+    }
+}
+
-- 
2.49.0