2 * Copyright 2016-2017, Nokia Corporation
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
17 package org.onap.vfc.nfvo.driver.vnfm.svnfm.db.mapper;
19 import java.util.List;
21 import org.apache.ibatis.annotations.Delete;
22 import org.apache.ibatis.annotations.Insert;
23 import org.apache.ibatis.annotations.Mapper;
24 import org.apache.ibatis.annotations.Result;
25 import org.apache.ibatis.annotations.Results;
26 import org.apache.ibatis.annotations.Select;
27 import org.onap.vfc.nfvo.driver.vnfm.svnfm.db.bean.VnfmJobExecutionInfo;
28 import org.onap.vfc.nfvo.driver.vnfm.svnfm.db.bean.VnfmSubscriptionInfo;
31 public interface VnfmSubscriptionsMapper {
32 @Select("SELECT * FROM vnfm_subscription_info")
34 @Result(property = "id", column = "id"),
36 List<VnfmSubscriptionInfo> getAll();
38 @Select("SELECT * FROM vnfm_subscription_info WHERE id = #{id}")
40 @Result(property = "id", column = "id"),
42 VnfmSubscriptionInfo findOne(String id);
44 // @Insert("INSERT INTO vnfm_subscription_info(id) VALUES(#{id})")
45 // void insert(VnfmJobExecutionInfo user);
47 @Insert("INSERT INTO vnfm_subscription_info(id) VALUES(#{id})")
48 void insert(String id);
50 @Delete("DELETE FROM vnfm_subscription_info WHERE id =#{id}")
51 void delete(String id);