SHA256
Не допускать повторный CreateChannel
This commit is contained in:
@@ -71,22 +71,6 @@ public final class ChannelNameStateDAO {
|
|||||||
ava_size,
|
ava_size,
|
||||||
meta_updated_at_ms
|
meta_updated_at_ms
|
||||||
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
|
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
|
||||||
ON CONFLICT (owner_bch_name, channel_type_code, slug) DO UPDATE SET
|
|
||||||
display_name = EXCLUDED.display_name,
|
|
||||||
channel_description = EXCLUDED.channel_description,
|
|
||||||
owner_login = EXCLUDED.owner_login,
|
|
||||||
channel_type_version = EXCLUDED.channel_type_version,
|
|
||||||
channel_root_block_number = EXCLUDED.channel_root_block_number,
|
|
||||||
channel_root_block_hash = EXCLUDED.channel_root_block_hash,
|
|
||||||
created_at_ms = EXCLUDED.created_at_ms,
|
|
||||||
ava_ar = EXCLUDED.ava_ar,
|
|
||||||
ava_pr = EXCLUDED.ava_pr,
|
|
||||||
ava_size = EXCLUDED.ava_size,
|
|
||||||
meta_updated_at_ms = EXCLUDED.meta_updated_at_ms,
|
|
||||||
is_deleted = FALSE,
|
|
||||||
deleted_at_ms = 0,
|
|
||||||
deleted_block_number = NULL
|
|
||||||
WHERE EXCLUDED.channel_root_block_number > channel_names_state.channel_root_block_number
|
|
||||||
""";
|
""";
|
||||||
try (PreparedStatement ps = c.prepareStatement(sql)) {
|
try (PreparedStatement ps = c.prepareStatement(sql)) {
|
||||||
ps.setString(1, entry.getSlug());
|
ps.setString(1, entry.getSlug());
|
||||||
|
|||||||
+1
-1
@@ -1,2 +1,2 @@
|
|||||||
client.version=1.20.67
|
client.version=1.20.67
|
||||||
server.version=1.16.36
|
server.version=1.16.37
|
||||||
|
|||||||
Reference in New Issue
Block a user