17754204432

Committed 16 Sep 2025 04:08AM UTC coverage: 37.656%. Remained the same

Build # 17754204432

Build Type

push

github

Committed by

web-flow

Commit Message

Integrated postcoin display with launchpad tokens display in explore page (#12992)

* integrated postcoin display with launchpad tokens display in explore page views

* fix

Run Details

1949 of 5590 branches covered (34.87%)

Branch coverage included in aggregate %.

0 of 14 new or added lines in 2 files covered. (0.0%)

6 existing lines in 2 files now uncovered.

3438 of 8716 relevant lines covered (39.44%)

45.01 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/libs/model/src/aggregates/token/GetTokenStats.query.ts

import { type Query } from '@hicommonwealth/core';
import * as schemas from '@hicommonwealth/schemas';
import { QueryTypes } from 'sequelize';
import { models } from '../../database';

export function GetTokenStats(): Query<typeof schemas.GetTokenStats> {
  return {
    ...schemas.GetTokenStats,
    auth: [],
    secure: false,
    async body({ payload }) {
      const { token_address } = payload;

      const tokenTypeQuery = `
        SELECT 
          CASE 
            WHEN EXISTS(SELECT 1 FROM "LaunchpadTokens" WHERE token_address = :token_address) 
            THEN 'launchpad'
            WHEN EXISTS(SELECT 1 FROM "ThreadTokens" WHERE token_address = :token_address)
            THEN 'postcoin'
            ELSE 'unknown'
          END as token_type
      `;

      const [tokenTypeRow] = await models.sequelize.query<{
        token_type: string;
      }>(tokenTypeQuery, {
        replacements: { token_address },
        type: QueryTypes.SELECT,
      });

      const tokenType = tokenTypeRow?.token_type;

      if (tokenType === 'unknown') {
        return {
          holder_count: 0,
          volume_24h: 0,
        };
      }

      const sql =
        tokenType === 'launchpad'
          ? `
        SELECT
          COUNT(DISTINCT trader_address) AS holder_count,
          COALESCE(
            SUM(
              CASE 
                WHEN timestamp >= EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - INTERVAL '24 hours')
                THEN price * community_token_amount 
                ELSE 0 
              END
            ),
            0
          ) AS volume_24h
        FROM "LaunchpadTrades" 
        WHERE token_address = :token_address
      `
          : `
        SELECT
          COUNT(DISTINCT trader_address) AS holder_count,
          COALESCE(
            SUM(
              CASE 
                WHEN timestamp >= EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - INTERVAL '24 hours')
                THEN price * community_token_amount 
                ELSE 0 
              END
            ),
            0
          ) AS volume_24h
        FROM "ThreadTokenTrades" 
        WHERE token_address = :token_address
      `;

      const [row] = await models.sequelize.query<{
        holder_count: number;
        volume_24h: string;
      }>(sql, {
        replacements: { token_address },
        type: QueryTypes.SELECT,
      });

      return {
        holder_count: parseInt(row?.holder_count as unknown as string) || 0,
        volume_24h: parseFloat(row?.volume_24h || '0'),
      };
    },
  };
}

1	import { type Query } from '@hicommonwealth/core';
2	import * as schemas from '@hicommonwealth/schemas';
3	import { QueryTypes } from 'sequelize';
4	import { models } from '../../database';
5
6	export function GetTokenStats(): Query<typeof schemas.GetTokenStats> {
7	return {	×
8	...schemas.GetTokenStats,
9	auth: [],
10	secure: false,
11	async body({ payload }) {
12	const { token_address } = payload;	×
13
NEW 14	const tokenTypeQuery = `	×
15	SELECT
16	CASE
17	WHEN EXISTS(SELECT 1 FROM "LaunchpadTokens" WHERE token_address = :token_address)
18	THEN 'launchpad'
19	WHEN EXISTS(SELECT 1 FROM "ThreadTokens" WHERE token_address = :token_address)
20	THEN 'postcoin'
21	ELSE 'unknown'
22	END as token_type
23	`;
24
NEW 25	const [tokenTypeRow] = await models.sequelize.query<{	×
26	token_type: string;
27	}>(tokenTypeQuery, {
28	replacements: { token_address },
29	type: QueryTypes.SELECT,
30	});
31
NEW 32	const tokenType = tokenTypeRow?.token_type;	×
33
NEW 34	if (tokenType === 'unknown') {	×
NEW 35	return {	×
36	holder_count: 0,
37	volume_24h: 0,
38	};
39	}
40
41	const sql =
NEW 42	tokenType === 'launchpad'	×
43	? `
44	SELECT
45	COUNT(DISTINCT trader_address) AS holder_count,
46	COALESCE(
47	SUM(
48	CASE
49	WHEN timestamp >= EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - INTERVAL '24 hours')
50	THEN price * community_token_amount
51	ELSE 0
52	END
53	),
54	0
55	) AS volume_24h
56	FROM "LaunchpadTrades"
57	WHERE token_address = :token_address
58	`
59	: `
60	SELECT
61	COUNT(DISTINCT trader_address) AS holder_count,
62	COALESCE(
63	SUM(
64	CASE
65	WHEN timestamp >= EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - INTERVAL '24 hours')
66	THEN price * community_token_amount
67	ELSE 0
68	END
69	),
70	0
71	) AS volume_24h
72	FROM "ThreadTokenTrades"
73	WHERE token_address = :token_address
74	`;
75
UNCOV 76	const [row] = await models.sequelize.query<{	×
77	holder_count: number;
78	volume_24h: string;
79	}>(sql, {
80	replacements: { token_address },
81	type: QueryTypes.SELECT,
82	});
83
UNCOV 84	return {	×
85	holder_count: parseInt(row?.holder_count as unknown as string) \|\| 0,	×
86	volume_24h: parseFloat(row?.volume_24h \|\| '0'),	×
87	};
88	},
89	};
90	}

hicommonwealth / commonwealth / 17754204432

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous