1 files changed, 65 insertions, 0 deletions
diff --git a/django/engagementmanager/migrations/0021_generate_excel_overview_sheet_procedure_20170110.py b/django/engagementmanager/migrations/0021_generate_excel_overview_sheet_procedure_20170110.py
new file mode 100755
index 0000000..b902df4
--- /dev/null
+++ b/django/engagementmanager/migrations/0021_generate_excel_overview_sheet_procedure_20170110.py
@@ -0,0 +1,65 @@
+#  
+# ============LICENSE_START========================================== 
+# org.onap.vvp/engagementmgr
+# ===================================================================
+# Copyright © 2017 AT&T Intellectual Property. All rights reserved.
+# ===================================================================
+#
+# Unless otherwise specified, all software contained herein is licensed
+# under the Apache License, Version 2.0 (the “License”);
+# you may not use this software except in compliance with the License.
+# You may obtain a copy of the License at
+#
+#             http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+#
+#
+# Unless otherwise specified, all documentation contained herein is licensed
+# under the Creative Commons License, Attribution 4.0 Intl. (the “License”);
+# you may not use this documentation except in compliance with the License.
+# You may obtain a copy of the License at
+#
+#             https://creativecommons.org/licenses/by/4.0/
+#
+# Unless required by applicable law or agreed to in writing, documentation
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+# ============LICENSE_END============================================
+#
+# ECOMP is a trademark and service mark of AT&T Intellectual Property.
+from __future__ import unicode_literals
+
+import os
+
+from django.db import migrations, connection
+
+import engagementmanager
+
+
+def forwards(apps, schema_editor):
+    if not schema_editor.connection.alias == 'default':
+        return
+
+    cursor = connection.cursor()
+    cursor.execute(open(os.path.join(os.path.dirname(engagementmanager.__file__),
+                                     'sql-scripts/generate_excel_overview_sheet_procedure.sql'), "r").read())
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('engagementmanager', '0020_add_indexes_20170108'),
+    ]
+
+    operations = [
+        migrations.RunPython(forwards),
+    ]