1 files changed, 52 insertions, 0 deletions
diff --git a/nokia/vnfmdriver/vfcadaptorservice/vfcadaptor/src/main/java/org/onap/vfc/nfvo/driver/vnfm/svnfm/db/mapper/VnfmSubscriptionsMapper.java b/nokia/vnfmdriver/vfcadaptorservice/vfcadaptor/src/main/java/org/onap/vfc/nfvo/driver/vnfm/svnfm/db/mapper/VnfmSubscriptionsMapper.java
new file mode 100644
index 00000000..6840cf39
--- /dev/null
+++ b/nokia/vnfmdriver/vfcadaptorservice/vfcadaptor/src/main/java/org/onap/vfc/nfvo/driver/vnfm/svnfm/db/mapper/VnfmSubscriptionsMapper.java
@@ -0,0 +1,52 @@
+/*
+ * Copyright 2016-2017, Nokia Corporation
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file 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.
+ */
+ 
+package org.onap.vfc.nfvo.driver.vnfm.svnfm.db.mapper;
+
+import java.util.List;
+
+import org.apache.ibatis.annotations.Delete;
+import org.apache.ibatis.annotations.Insert;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Result;
+import org.apache.ibatis.annotations.Results;
+import org.apache.ibatis.annotations.Select;
+import org.onap.vfc.nfvo.driver.vnfm.svnfm.db.bean.VnfmJobExecutionInfo;
+import org.onap.vfc.nfvo.driver.vnfm.svnfm.db.bean.VnfmSubscriptionInfo;
+
+@Mapper
+public interface VnfmSubscriptionsMapper {
+	@Select("SELECT * FROM vnfm_subscription_info")
+    @Results({
+        @Result(property = "id",  column = "id"),
+    })
+    List<VnfmSubscriptionInfo> getAll();
+
+    @Select("SELECT * FROM vnfm_subscription_info WHERE id = #{id}")
+    @Results({
+    	@Result(property = "id",  column = "id"),
+    })
+    VnfmSubscriptionInfo findOne(String id);
+
+//    @Insert("INSERT INTO vnfm_subscription_info(id) VALUES(#{id})")
+//    void insert(VnfmJobExecutionInfo user);
+    
+    @Insert("INSERT INTO vnfm_subscription_info(id) VALUES(#{id})")
+    void insert(String id);
+
+    @Delete("DELETE FROM vnfm_subscription_info WHERE id =#{id}")
+    void delete(String id);
+}