nokia/vnfmdriver/vfcadaptorservice/vfcadaptor/src/main/java/org/onap/vfc/nfvo/driver/vnfm/svnfm/db/mapper/VnfmSubscriptionsMapper.java

   1 /*
   2  * Copyright 2016-2017, Nokia Corporation
   3  *
   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
   7  *
   8  *     http://www.apache.org/licenses/LICENSE-2.0
   9  *
  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.
  15  */
  16
  17 package org.onap.vfc.nfvo.driver.vnfm.svnfm.db.mapper;
  18
  19 import java.util.List;
  20
  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;
  29
  30 @Mapper
  31 public interface VnfmSubscriptionsMapper {
  32         @Select("SELECT * FROM vnfm_subscription_info")
  33     @Results({
  34         @Result(property = "id",  column = "id"),
  35     })
  36     List<VnfmSubscriptionInfo> getAll();
  37
  38     @Select("SELECT * FROM vnfm_subscription_info WHERE id = #{id}")
  39     @Results({
  40         @Result(property = "id",  column = "id"),
  41     })
  42     VnfmSubscriptionInfo findOne(String id);
  43
  44 //    @Insert("INSERT INTO vnfm_subscription_info(id) VALUES(#{id})")
  45 //    void insert(VnfmJobExecutionInfo user);
  46
  47     @Insert("INSERT INTO vnfm_subscription_info(id) VALUES(#{id})")
  48     void insert(String id);
  49
  50     @Delete("DELETE FROM vnfm_subscription_info WHERE id =#{id}")
  51     void delete(String id);
  52 }