18689677366

Committed 21 Oct 2025 03:48PM UTC coverage: 37.226% (-0.007%) from 37.233%

Build # 18689677366

Build Type

Pull #13119

github

Committed by

web-flow

Commit Message

Merge e255e068f into 40a502422

Pull Request Pull Request #13119: Add claim tx dates

Run Details

1987 of 5750 branches covered (34.56%)

Branch coverage included in aggregate %.

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

11 existing lines in 3 files now uncovered.

3480 of 8936 relevant lines covered (38.94%)

44.7 hits per line

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

0.0

/libs/model/src/aggregates/token-allocation/GetClaimAddress.query.ts

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

export function GetClaimAddress(): Query<typeof schemas.GetClaimAddress> {
  return {
    ...schemas.GetClaimAddress,
    auth: [],
    secure: true,
    body: async ({ actor }) => {
      const claimAddress = await models.sequelize.query<
        z.infer<typeof schemas.ClaimAddressView>
      >(
        `
          SELECT
            A.user_id,
            A.address,
            A.magna_allocation_id,
            A.magna_synced_at,
            A.magna_claimed_at,
            A.magna_claim_tx_hash,
            A.magna_claim_tx_at,
            A.magna_cliff_claimed_at,
            A.magna_cliff_claim_tx_hash,
            A.magna_cliff_claim_tx_at,
            COALESCE(HA.token_allocation, 0)::numeric 
            + COALESCE(AA.token_allocation, 0)::numeric
            + COALESCE(NA.total_token_allocation, 0)::numeric as tokens
          FROM
            "ClaimAddresses" A
            LEFT JOIN "HistoricalAllocations" HA ON A.user_id = HA.user_id
            LEFT JOIN "AuraAllocations" AA ON A.user_id = AA.user_id
            LEFT JOIN "NftSnapshot" NA ON A.user_id = NA.user_id
          WHERE
            A.user_id = :user_id
          LIMIT 1;
        `,
        {
          type: QueryTypes.SELECT,
          replacements: {
            user_id: actor.user.id,
          },
        },
      );

      if (!claimAddress || claimAddress.length === 0) return null;
      if (claimAddress.length > 1) {
        // this will never happen but included for type-narrowing
        throw new InvalidState('Duplicate claim addresses found');
      }

      return {
        ...claimAddress[0],
        token: config.MAGNA?.TOKEN || '',
        description: config.MAGNA?.EVENT_DESC || '',
        initial_percentage: config.MAGNA?.INITIAL_PERCENTAGE || 0,
        cliff_date: config.MAGNA?.CLIFF_DATE || new Date(),
      };
    },
  };
}

1	import { InvalidState, type Query } from '@hicommonwealth/core';
2	import * as schemas from '@hicommonwealth/schemas';
3	import { QueryTypes } from 'sequelize';
4	import z from 'zod';
5	import { config } from '../../config';
6	import { models } from '../../database';
7
8	export function GetClaimAddress(): Query<typeof schemas.GetClaimAddress> {
9	return {	×
10	...schemas.GetClaimAddress,
11	auth: [],
12	secure: true,
13	body: async ({ actor }) => {
14	const claimAddress = await models.sequelize.query<	×
15	z.infer<typeof schemas.ClaimAddressView>
16	>(
17	`
18	SELECT
19	A.user_id,
20	A.address,
21	A.magna_allocation_id,
22	A.magna_synced_at,
23	A.magna_claimed_at,
24	A.magna_claim_tx_hash,
25	A.magna_claim_tx_at,
26	A.magna_cliff_claimed_at,
27	A.magna_cliff_claim_tx_hash,
28	A.magna_cliff_claim_tx_at,
29	COALESCE(HA.token_allocation, 0)::numeric
30	+ COALESCE(AA.token_allocation, 0)::numeric
31	+ COALESCE(NA.total_token_allocation, 0)::numeric as tokens
32	FROM
33	"ClaimAddresses" A
34	LEFT JOIN "HistoricalAllocations" HA ON A.user_id = HA.user_id
35	LEFT JOIN "AuraAllocations" AA ON A.user_id = AA.user_id
36	LEFT JOIN "NftSnapshot" NA ON A.user_id = NA.user_id
37	WHERE
38	A.user_id = :user_id
39	LIMIT 1;
40	`,
41	{
42	type: QueryTypes.SELECT,
43	replacements: {
44	user_id: actor.user.id,
45	},
46	},
47	);
48
UNCOV 49	if (!claimAddress \|\| claimAddress.length === 0) return null;	×
UNCOV 50	if (claimAddress.length > 1) {	×
51	// this will never happen but included for type-narrowing
52	throw new InvalidState('Duplicate claim addresses found');	×
53	}
54
UNCOV 55	return {	×
56	...claimAddress[0],
57	token: config.MAGNA?.TOKEN \|\| '',	×
58	description: config.MAGNA?.EVENT_DESC \|\| '',	×
59	initial_percentage: config.MAGNA?.INITIAL_PERCENTAGE \|\| 0,	×
60	cliff_date: config.MAGNA?.CLIFF_DATE \|\| new Date(),	×
61	};
62	},
63	};
64	}

hicommonwealth / commonwealth / 18689677366

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