| | |
|---|
| | | public interface RecordInfoDao { |
|---|
| | | |
|---|
| | | @Insert("INSERT INTO recordInfo (app, stream, mediaServerId, createTime, type, deviceId, channelId, name) VALUES" + |
|---|
| | | "('${app}', '${stream}', '${mediaServerId}', datetime('now','localtime')), '${type}', '${deviceId}', '${channelId}', '${name}'") |
|---|
| | | "(#{app}, #{stream}, #{mediaServerId}, datetime('now','localtime')), #{type}, #{deviceId}, #{channelId}, #{name}") |
|---|
| | | int add(RecordInfo recordInfo); |
|---|
| | | |
|---|
| | | @Delete("DELETE FROM user WHERE createTime < '${beforeTime}'") |
|---|
| | | @Delete("DELETE FROM user WHERE createTime < #{beforeTime}") |
|---|
| | | int deleteBefore(String beforeTime); |
|---|
| | | |
|---|
| | | @Select("select * FROM recordInfo") |
|---|
