1 files changed, 72 insertions, 0 deletions
diff --git a/django/engagementmanager/tests/test_import_engagement_xls.py b/django/engagementmanager/tests/test_import_engagement_xls.py
new file mode 100755
index 0000000..8513998
--- /dev/null
+++ b/django/engagementmanager/tests/test_import_engagement_xls.py
@@ -0,0 +1,72 @@
+#  
+# ============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 io import StringIO
+import os
+
+from django.core import management
+
+from engagementmanager.management.commands.initial_populate_db import execute_bootstrap_actions
+from engagementmanager.tests.test_base_entity import TestBaseEntity
+
+
+class TestImportEngagementXLSTestCase(TestBaseEntity):
+
+    def childSetup(self):
+        execute_bootstrap_actions()
+        pass
+
+    def initBody(self):
+        pass
+
+    ### TESTS ###
+    def testImportEngagementXLSTestCase(self):
+        self.initBody()
+        xls_path = 'engagementmanager/tests/D2_ICE_Engagements_Import_Example.xlsx'
+
+        if not os.path.exists(xls_path):
+            print("File doesnt exists")
+            return True
+
+        response = StringIO()
+
+        management.call_command('import_xls', xls_path, '2', stdout=response)
+        response = response.getvalue()
+        if response.find('True') != -1:
+            response = True
+        self.assertEqual(response, True)