aidar/SHiNE-server
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

08 01 25

Browse Source 
Помелоги поменял
This commit is contained in:
AidarKC
2026-01-08 23:32:17 +03:00
parent 7a167b470a
commit 4c87207129
7 changed files with 148 additions and 14 deletions
Download Patch File Download Diff File Expand all files Collapse all files
shine-server-db/src/main/java/shine/db/DatabaseInitializer.java
+6 -7
View File
@@ -1,7 +1,6 @@
package shine.db;
import utils.config.AppConfig;
import utils.config.MsgSubType;
import java.io.BufferedReader;
import java.io.IOException;
@@ -371,14 +370,14 @@ public class DatabaseInitializer {
replies_count
)
SELECT
substr(NEW.to_bch_name, 1, length(NEW.to_bch_name) - 3),
substr(NEW.to_bch_name, 1, length(NEW.to_bch_name) - 4),
NEW.to_bch_name,
NEW.to_block_global_number,
NEW.to_block_hashe,
1,
0
WHERE NEW.to_bch_name IS NOT NULL
AND length(NEW.to_bch_name) > 3
AND length(NEW.to_bch_name) > 4
AND NEW.to_block_global_number IS NOT NULL
AND NEW.to_block_hashe IS NOT NULL
ON CONFLICT(to_login, to_bch_name, to_block_global_number, to_block_hash)
@@ -402,14 +401,14 @@ public class DatabaseInitializer {
replies_count
)
SELECT
substr(NEW.to_bch_name, 1, length(NEW.to_bch_name) - 3),
substr(NEW.to_bch_name, 1, length(NEW.to_bch_name) - 4),
NEW.to_bch_name,
NEW.to_block_global_number,
NEW.to_block_hashe,
0,
1
WHERE NEW.to_bch_name IS NOT NULL
AND length(NEW.to_bch_name) > 3
AND length(NEW.to_bch_name) > 4
AND NEW.to_block_global_number IS NOT NULL
AND NEW.to_block_hashe IS NOT NULL
ON CONFLICT(to_login, to_bch_name, to_block_global_number, to_block_hash)
@@ -442,7 +441,7 @@ public class DatabaseInitializer {
edits_count
)
SELECT
substr(NEW.to_bch_name, 1, length(NEW.to_bch_name) - 3),
substr(NEW.to_bch_name, 1, length(NEW.to_bch_name) - 4),
NEW.to_bch_name,
NEW.to_block_global_number,
NEW.to_block_hashe,
@@ -450,7 +449,7 @@ public class DatabaseInitializer {
0,
1
WHERE NEW.to_bch_name IS NOT NULL
AND length(NEW.to_bch_name) > 3
AND length(NEW.to_bch_name) > 4
AND NEW.to_block_global_number IS NOT NULL
AND NEW.to_block_hashe IS NOT NULL
ON CONFLICT(to_login, to_bch_name, to_block_global_number, to_block_hash)
shine-server-db/src/main/java/shine/db/MsgSubType.java
+55
View File
@@ -0,0 +1,55 @@
package shine.db;
/**
* shine.db.MsgSubType — единое место для ВСЕХ subType сообщений (msg_sub_type).
*
* Правило:
* - НИКАКИХ "магических чисел" subType по проекту.
* - В тестах, в body-классах и в SQL-триггерах используем только эти константы.
*
* Важно:
* - Значения менять после релиза нельзя (иначе сломается совместимость).
*/
public final class MsgSubType {
private MsgSubType() {}
/* ===================== TEXT (msg_type=1) ===================== */
/** Новое сообщение (начало ветки). */
public static final short TEXT_NEW = 1;
/** Ответ на сообщение (reply). */
public static final short TEXT_REPLY = 2;
/** Репост (repost). */
public static final short TEXT_REPOST = 3;
/** Редактирование (edit). ВАЖНО: серверное значение = 10. */
public static final short TEXT_EDIT = 10;
/* ===================== REACTION (msg_type=2) ===================== */
/** Лайк (LIKE). */
public static final short REACTION_LIKE = 1;
/* ===================== CONNECTION (msg_type=3) ===================== */
/** Добавить в друзья. */
public static final short CONNECTION_FRIEND = 10;
/** Удалить из друзей. */
public static final short CONNECTION_UNFRIEND = 11;
/** Подписаться (follow). */
public static final short CONNECTION_FOLLOW = 20;
/** Отписаться (unfollow). */
public static final short CONNECTION_UNFOLLOW = 21;
/** Заблокировать. */
public static final short CONNECTION_BLOCK = 30;
/** Разблокировать. */
public static final short CONNECTION_UNBLOCK = 31;
}