Каналы: добавить профиль через TEXT_CHANNEL_META

SHiNE-server/shine-server-db/src/main/java/shine/db/DatabaseInitializer.java

@@ -20,9 +20,11 @@ public final class DatabaseInitializer {
     public static final int SCHEMA_VERSION_1 = 1;
     public static final int SCHEMA_VERSION_2 = 2;
     public static final int SCHEMA_VERSION_3 = 3;
+    public static final int SCHEMA_VERSION_4 = 4;
     public static final String POSTGRES_SCHEMA_RESOURCE = "postgres/schema_v1.sql";
     public static final String POSTGRES_MIGRATION_V2_RESOURCE = "postgres/migration_v2.sql";
     public static final String POSTGRES_MIGRATION_V3_RESOURCE = "postgres/migration_v3.sql";
+    public static final String POSTGRES_MIGRATION_V4_RESOURCE = "postgres/migration_v4.sql";
 
     private DatabaseInitializer() {}
 
@@ -31,6 +33,7 @@ public final class DatabaseInitializer {
     public static final short TEXT_REPLY = 20;
     public static final short TEXT_EDIT_REPLY = 21;
     public static final short TEXT_REPOST = 30;
+    public static final short TEXT_CHANNEL_META = 70;
 
     public static final short REACTION_LIKE = 1;
     public static final short REACTION_UNLIKE = 2;
@@ -88,6 +91,10 @@ public final class DatabaseInitializer {
             }
             if (currentVersion < SCHEMA_VERSION_3) {
                 runSqlScript(conn, POSTGRES_MIGRATION_V3_RESOURCE);
+                currentVersion = SCHEMA_VERSION_3;
+            }
+            if (currentVersion < SCHEMA_VERSION_4) {
+                runSqlScript(conn, POSTGRES_MIGRATION_V4_RESOURCE);
             }
         }
     }

SHiNE-server/shine-server-db/src/main/java/shine/db/MsgSubType.java

@@ -33,6 +33,9 @@ public final class MsgSubType {
     /** REPOST — репост сообщения в линии канала (с комментарием и target на оригинал). */
     public static final short TEXT_REPOST = 30;
 
+    /** CHANNEL_META — скрытый технический снимок профиля канала. */
+    public static final short TEXT_CHANNEL_META = 70;
+
     /* ===================== REACTION (msg_type=2) ===================== */
 
     /** Лайк (LIKE). */

SHiNE-server/shine-server-db/src/main/java/shine/db/dao/ChannelNameStateDAO.java

@@ -65,8 +65,12 @@ public final class ChannelNameStateDAO {
                     channel_type_version,
                     channel_root_block_number,
                     channel_root_block_hash,
-                    created_at_ms
-                ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
+                    created_at_ms,
+                    ava_ar,
+                    ava_sha256,
+                    ava_size,
+                    meta_updated_at_ms
+                ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                 """;
         try (PreparedStatement ps = c.prepareStatement(sql)) {
             ps.setString(1, entry.getSlug());
@@ -79,6 +83,34 @@ public final class ChannelNameStateDAO {
             ps.setInt(8, entry.getChannelRootBlockNumber());
             ps.setBytes(9, entry.getChannelRootBlockHash());
             ps.setLong(10, entry.getCreatedAtMs());
+            ps.setString(11, entry.getAvaAr() == null ? "" : entry.getAvaAr());
+            ps.setString(12, entry.getAvaSha256() == null ? "" : entry.getAvaSha256());
+            ps.setLong(13, Math.max(0L, entry.getAvaSize()));
+            ps.setLong(14, Math.max(0L, entry.getMetaUpdatedAtMs()));
+            ps.executeUpdate();
+        }
+    }
+
+    public void updateMeta(Connection c, ChannelNameStateEntry entry) throws SQLException {
+        String sql = """
+                UPDATE channel_names_state
+                SET display_name = ?,
+                    channel_description = ?,
+                    ava_ar = ?,
+                    ava_sha256 = ?,
+                    ava_size = ?,
+                    meta_updated_at_ms = ?
+                WHERE owner_bch_name = ? AND channel_root_block_number = ?
+                """;
+        try (PreparedStatement ps = c.prepareStatement(sql)) {
+            ps.setString(1, entry.getDisplayName() == null ? "" : entry.getDisplayName());
+            ps.setString(2, entry.getChannelDescription() == null ? "" : entry.getChannelDescription());
+            ps.setString(3, entry.getAvaAr() == null ? "" : entry.getAvaAr());
+            ps.setString(4, entry.getAvaSha256() == null ? "" : entry.getAvaSha256());
+            ps.setLong(5, Math.max(0L, entry.getAvaSize()));
+            ps.setLong(6, Math.max(0L, entry.getMetaUpdatedAtMs()));
+            ps.setString(7, entry.getOwnerBlockchainName());
+            ps.setInt(8, entry.getChannelRootBlockNumber());
             ps.executeUpdate();
         }
     }

SHiNE-server/shine-server-db/src/main/java/shine/db/entities/ChannelNameStateEntry.java

@@ -13,6 +13,10 @@ public class ChannelNameStateEntry {
     private int channelRootBlockNumber;
     private byte[] channelRootBlockHash;
     private long createdAtMs;
+    private String avaAr;
+    private String avaSha256;
+    private long avaSize;
+    private long metaUpdatedAtMs;
 
     public String getSlug() {
         return slug;
@@ -93,4 +97,36 @@ public class ChannelNameStateEntry {
     public void setCreatedAtMs(long createdAtMs) {
         this.createdAtMs = createdAtMs;
     }
+
+    public String getAvaAr() {
+        return avaAr;
+    }
+
+    public void setAvaAr(String avaAr) {
+        this.avaAr = avaAr;
+    }
+
+    public String getAvaSha256() {
+        return avaSha256;
+    }
+
+    public void setAvaSha256(String avaSha256) {
+        this.avaSha256 = avaSha256;
+    }
+
+    public long getAvaSize() {
+        return avaSize;
+    }
+
+    public void setAvaSize(long avaSize) {
+        this.avaSize = avaSize;
+    }
+
+    public long getMetaUpdatedAtMs() {
+        return metaUpdatedAtMs;
+    }
+
+    public void setMetaUpdatedAtMs(long metaUpdatedAtMs) {
+        this.metaUpdatedAtMs = metaUpdatedAtMs;
+    }
 }

SHiNE-server/shine-server-db/src/main/resources/postgres/migration_v4.sql

@@ -0,0 +1,15 @@
+BEGIN;
+
+ALTER TABLE channel_names_state
+    ADD COLUMN IF NOT EXISTS ava_ar TEXT NOT NULL DEFAULT '',
+    ADD COLUMN IF NOT EXISTS ava_sha256 TEXT NOT NULL DEFAULT '',
+    ADD COLUMN IF NOT EXISTS ava_size BIGINT NOT NULL DEFAULT 0,
+    ADD COLUMN IF NOT EXISTS meta_updated_at_ms BIGINT NOT NULL DEFAULT 0;
+
+INSERT INTO db_schema_version (id, schema_version, updated_at_ms)
+VALUES (1, 4, CAST(EXTRACT(EPOCH FROM clock_timestamp()) * 1000 AS BIGINT))
+ON CONFLICT (id) DO UPDATE SET
+    schema_version = EXCLUDED.schema_version,
+    updated_at_ms = EXCLUDED.updated_at_ms;
+
+COMMIT;

SHiNE-server/shine-server-db/src/main/resources/postgres/schema_v1.sql

@@ -536,7 +536,11 @@ CREATE TABLE IF NOT EXISTS channel_names_state (
     channel_type_version      INTEGER NOT NULL DEFAULT 1,
     channel_root_block_number INTEGER NOT NULL,
     channel_root_block_hash   BYTEA NOT NULL,
-    created_at_ms             BIGINT NOT NULL
+    created_at_ms             BIGINT NOT NULL,
+    ava_ar                    TEXT NOT NULL DEFAULT '',
+    ava_sha256                TEXT NOT NULL DEFAULT '',
+    ava_size                  BIGINT NOT NULL DEFAULT 0,
+    meta_updated_at_ms        BIGINT NOT NULL DEFAULT 0
 );
 
 CREATE UNIQUE INDEX IF NOT EXISTS uq_channel_names_state_owner_type_slug