io.soabase.sql.attributes

Interface AttributeEntityMapper

@CacheNamespace
public interface AttributeEntityMapper

Method Summary

Modifier and Type	Method and Description
int	createTable()
int	delete(AttributeEntity attribute)
int	insert(AttributeEntity attribute)
List<AttributeEntity>	selectAll()
int	update(AttributeEntity attribute)

Method Detail

selectAll

@Select(value="SELECT * FROM SoaAttributes")
List<AttributeEntity> selectAll()

createTable

@Update(value="CREATE TABLE SoaAttributes (fKEY VARCHAR(255) NOT NULL, fSCOPE VARCHAR(255) NOT NULL, fVALUE VARCHAR(65535), fTIMESTAMP VARCHAR(255) NOT NULL, PRIMARY KEY (fKEY, fSCOPE))")
int createTable()

insert

@Insert(value="INSERT INTO SoaAttributes (fKEY, fSCOPE, fVALUE, fTIMESTAMP) VALUES (#{fKEY}, #{fSCOPE}, #{fVALUE}, #{fTIMESTAMP})")
int insert(AttributeEntity attribute)

update

@Update(value="UPDATE SoaAttributes SET fVALUE = #{fVALUE} WHERE fKEY = #{fKEY} AND fSCOPE = #{fSCOPE}")
int update(AttributeEntity attribute)

delete

@Delete(value="DELETE FROM SoaAttributes WHERE fKEY = #{fKEY} AND fSCOPE = #{fSCOPE}")
int delete(AttributeEntity attribute)