添加dockerfile,修改torrent表结构,实现原文件名存储,修改post表结构,关联torrent_id
Change-Id: Ie82f559d859e378b5991eb90880e95a0ffcf775d
diff --git a/src/main/resources/mapper/TorrentMapper.xml b/src/main/resources/mapper/TorrentMapper.xml
index 9b53d29..243fd92 100644
--- a/src/main/resources/mapper/TorrentMapper.xml
+++ b/src/main/resources/mapper/TorrentMapper.xml
@@ -4,8 +4,8 @@
<mapper namespace="com.example.g8backend.mapper.TorrentMapper">
<insert id="insertTorrent" >
- INSERT INTO torrents (user_id, torrent_name, info_hash, file_size)
- VALUES (#{userId}, #{torrentName}, UNHEX(#{infoHash}), #{fileSize})
+ INSERT INTO torrents (user_id, torrent_name, file_path, info_hash, file_size)
+ VALUES (#{userId}, #{torrentName}, #{filePath}, UNHEX(#{infoHash}), #{fileSize})
</insert>
<select id="getTorrentByInfoHash" resultType="com.example.g8backend.entity.Torrent">
@@ -13,6 +13,7 @@
torrent_id,
user_id,
torrent_name,
+ file_path,
HEX(info_hash) AS infoHash,
file_size
FROM torrents
@@ -24,6 +25,7 @@
torrent_id,
user_id,
torrent_name,
+ file_path,
HEX(info_hash) AS infoHash,
file_size
FROM torrents