{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":607737285,"defaultBranch":"main","name":"database","ownerLogin":"neptune-mutual-blue","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-02-28T15:22:11.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/99390331?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1714579668.0","currentOid":""},"activityList":{"items":[{"before":"920801c0760d55c28c5c3632579bb5ab1dfd06ac","after":"1e2fb29c635a81ab0deb8ef9f603fcfc6974b70a","ref":"refs/heads/main","pushedAt":"2024-05-17T05:52:05.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #73 from flashburst/feat/contract\n\nAdd contract field to transactions table","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2301880220\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/73\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/73/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/73\">#73</a> from flashburst/feat/contract"}},{"before":"93af1f716164bcc1397578f431339e8a93368bde","after":"920801c0760d55c28c5c3632579bb5ab1dfd06ac","ref":"refs/heads/main","pushedAt":"2024-05-07T15:19:55.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #72 from flashburst/update/gcr-pools\n\nUpdated `get_gauge_pools` to return staking token balance","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2283271374\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/72\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/72/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/72\">#72</a> from flashburst/update/gcr-pools"}},{"before":"e80c107e47f561a605b2d61c71ff78e795d65143","after":"93af1f716164bcc1397578f431339e8a93368bde","ref":"refs/heads/main","pushedAt":"2024-05-07T15:18:18.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #71 from flashburst/remove/views\n\nRemoved unnecessary view","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2282553303\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/71\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/71/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/71\">#71</a> from flashburst/remove/views"}},{"before":"37a6005870a8e84bc68f7b5d84af769bb4e4e1a0","after":"e80c107e47f561a605b2d61c71ff78e795d65143","ref":"refs/heads/main","pushedAt":"2024-05-07T15:16:37.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #70 from flashburst/update/volatility\n\nFix volatility of functions","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2282550007\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/70\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/70/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/70\">#70</a> from flashburst/update/volatility"}},{"before":"02e5c0b2c9f11b514eae30df99c0a41184832c46","after":null,"ref":"refs/heads/update/get-gauge-pools","pushedAt":"2024-05-01T16:07:48.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"}},{"before":"0f8a471a7669cec23f75c4e876901f8f33acd89e","after":"37a6005870a8e84bc68f7b5d84af769bb4e4e1a0","ref":"refs/heads/main","pushedAt":"2024-05-01T16:07:44.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #69 from neptune-mutual-blue/update/get-gauge-pools\n\nRefactor get_gauge_pools.sql to simplify and optimize the code","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2268490098\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/69\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/69/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/69\">#69</a> from neptune-mutual-blue/update/get-gauge-pools"}},{"before":null,"after":"02e5c0b2c9f11b514eae30df99c0a41184832c46","ref":"refs/heads/update/get-gauge-pools","pushedAt":"2024-04-29T08:58:12.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"},"commit":{"message":"Refactor get_gauge_pools.sql to simplify and optimize the code","shortMessageHtmlLink":"Refactor get_gauge_pools.sql to simplify and optimize the code"}},{"before":"2916f76008cdfcf9c0c4d9ddbfcc873c352b0708","after":"0f8a471a7669cec23f75c4e876901f8f33acd89e","ref":"refs/heads/main","pushedAt":"2024-04-23T16:48:00.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Merge pull request #68 from ankitkarna99/add-fuji-testnet\n\nAdd Fuji Testnet","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2245501125\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/68\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/68/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/68\">#68</a> from ankitkarna99/add-fuji-testnet"}},{"before":"6cd29e24eb3418c42f03edbc54f0bf2fc64d3ab6","after":null,"ref":"refs/heads/feature/datewise-liquiidty-summary","pushedAt":"2024-04-15T12:37:21.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"}},{"before":"ac4cc322ec2b89a232630bd856208d9c299cacd0","after":"2916f76008cdfcf9c0c4d9ddbfcc873c352b0708","ref":"refs/heads/main","pushedAt":"2024-04-15T12:37:16.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"},"commit":{"message":"Merge pull request #67 from neptune-mutual-blue/feature/datewise-liquiidty-summary\n\n# Added Datewise Liquidity Summary","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2228890326\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/67\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/67/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/67\">#67</a> from neptune-mutual-blue/feature/datewise-liqu…"}},{"before":"4b52fc42aae70b170434e99b72ab905f581531f2","after":"ac4cc322ec2b89a232630bd856208d9c299cacd0","ref":"refs/heads/main","pushedAt":"2024-04-13T10:41:13.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"},"commit":{"message":"Merge pull request #66 from rupak-nm/explorer-filter\n\nAdd _transaction_sender_like argument to get_explorer_home function","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2217533005\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/66\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/66/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/66\">#66</a> from rupak-nm/explorer-filter"}},{"before":"62b4dfa150bd4f02957795183823c6624b1a472b","after":"6cd29e24eb3418c42f03edbc54f0bf2fc64d3ab6","ref":"refs/heads/feature/datewise-liquiidty-summary","pushedAt":"2024-04-05T22:38:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Fixed stale caching issue","shortMessageHtmlLink":"Fixed stale caching issue"}},{"before":null,"after":"62b4dfa150bd4f02957795183823c6624b1a472b","ref":"refs/heads/feature/datewise-liquiidty-summary","pushedAt":"2024-04-05T22:27:00.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"# Added Datewise Liquidity Summary\n\n- Added function `get_datewise_liquidity_summary`\n- For brevity, renamed the function `sum_cover_purchased_during` to `sum_cover_fee_earned_during`\n- Added helper functions `count_cover_purchase_during` and `get_total_covered_till_date`\n- Fixed bug in `get_total_capacity_by_date` function\n\n## Query\n\n```sql\nDO\n$$\nBEGIN\n  IF EXISTS (SELECT 1 FROM pg_proc WHERE proname = 'sum_cover_purchased_during' AND pronargs = 2) THEN\n    ALTER FUNCTION sum_cover_purchased_during(TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) RENAME TO sum_cover_fee_earned_during;\n  END IF;\n\n  IF EXISTS (SELECT 1 FROM pg_proc WHERE proname = 'sum_cover_purchased_during' AND pronargs = 3) THEN\n    ALTER FUNCTION sum_cover_purchased_during(uint256, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) RENAME TO sum_cover_fee_earned_during;\n  END IF;\n\n  IF EXISTS (SELECT 1 FROM pg_proc WHERE proname = 'sum_cover_purchased_during' AND pronargs = 4) THEN\n    ALTER FUNCTION sum_cover_purchased_during(uint256, bytes32, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) RENAME TO sum_cover_fee_earned_during;\n  END IF;\nEND\n$$\nLANGUAGE plpgsql;\n\nALTER FUNCTION sum_cover_fee_earned_during(TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\nALTER FUNCTION sum_cover_fee_earned_during(uint256, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\nALTER FUNCTION sum_cover_fee_earned_during(uint256, bytes32, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\n\nCREATE OR REPLACE FUNCTION get_total_covered_till_date\n(\n  _date                                     TIMESTAMP WITH TIME ZONE\n)\nRETURNS numeric\nSTABLE\nAS\n$$\n  DECLARE _result numeric;\nBEGIN\n  SELECT SUM(get_stablecoin_value(chain_id, amount_to_cover))\n  INTO _result\n  FROM policy.cover_purchased\n  WHERE to_timestamp(expires_on) <= _date;\n\n  RETURN COALESCE(_result, 0);\nEND\n$$\nLANGUAGE plpgsql;\n\nCREATE OR REPLACE FUNCTION get_total_covered_till_date\n(\n  _chain_id                                 uint256,\n  _date                                     TIMESTAMP WITH TIME ZONE\n)\nRETURNS numeric\nSTABLE\nAS\n$$\n  DECLARE _result numeric;\nBEGIN\n  SELECT SUM(get_stablecoin_value(chain_id, amount_to_cover))\n  INTO _result\n  FROM policy.cover_purchased\n  WHERE chain_id = _chain_id\n  AND to_timestamp(expires_on) <= _date;\n\n  RETURN COALESCE(_result, 0);\nEND\n$$\nLANGUAGE plpgsql;\n\nCREATE OR REPLACE FUNCTION get_total_covered_till_date\n(\n  _chain_id                                 uint256,\n  _cover_key                                bytes32,\n  _date                                     TIMESTAMP WITH TIME ZONE\n)\nRETURNS numeric\nSTABLE\nAS\n$$\n  DECLARE _result numeric;\nBEGIN\n  SELECT SUM(get_stablecoin_value(chain_id, amount_to_cover))\n  INTO _result\n  FROM policy.cover_purchased\n  WHERE chain_id = _chain_id\n  AND cover_key = _cover_key\n  AND to_timestamp(expires_on) <= _date;\n\n  RETURN COALESCE(_result, 0);\nEND\n$$\nLANGUAGE plpgsql;\n\nALTER FUNCTION get_total_covered_till_date(TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\nALTER FUNCTION get_total_covered_till_date(uint256, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\nALTER FUNCTION get_total_covered_till_date(uint256, bytes32, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\n\nCREATE OR REPLACE FUNCTION count_cover_purchase_during\n(\n  _start                                      TIMESTAMP WITH TIME ZONE,\n  _end                                        TIMESTAMP WITH TIME ZONE\n)\nRETURNS numeric\nSTABLE\nAS\n$$\n  DECLARE _result numeric;\nBEGIN\n  SELECT COUNT(*)\n  INTO _result\n  FROM policy.cover_purchased\n  WHERE to_timestamp(policy.cover_purchased.block_timestamp) BETWEEN _start AND _end;\n\n  RETURN COALESCE(_result, 0);\nEND\n$$\nLANGUAGE plpgsql;\n\nCREATE OR REPLACE FUNCTION count_cover_purchase_during\n(\n  _chain_id                                   uint256,\n  _start                                      TIMESTAMP WITH TIME ZONE,\n  _end                                        TIMESTAMP WITH TIME ZONE\n)\nRETURNS numeric\nSTABLE\nAS\n$$\n  DECLARE _result numeric;\nBEGIN\n  SELECT COUNT(*)\n  INTO _result\n  FROM policy.cover_purchased\n  WHERE policy.cover_purchased.chain_id = _chain_id\n  AND to_timestamp(policy.cover_purchased.block_timestamp) BETWEEN _start AND _end;\n\n  RETURN COALESCE(_result, 0);\nEND\n$$\nLANGUAGE plpgsql;\n\nCREATE OR REPLACE FUNCTION count_cover_purchase_during\n(\n  _chain_id                                   uint256,\n  _cover_key                                  bytes32,\n  _start                                      TIMESTAMP WITH TIME ZONE,\n  _end                                        TIMESTAMP WITH TIME ZONE\n)\nRETURNS numeric\nSTABLE\nAS\n$$\n  DECLARE _result numeric;\nBEGIN\n  SELECT COUNT(*)\n  INTO _result\n  FROM policy.cover_purchased\n  WHERE policy.cover_purchased.chain_id = _chain_id\n  AND policy.cover_purchased.cover_key = _cover_key\n  AND to_timestamp(policy.cover_purchased.block_timestamp) BETWEEN _start AND _end;\n\n  RETURN COALESCE(_result, 0);\nEND\n$$\nLANGUAGE plpgsql;\n\nALTER FUNCTION count_cover_purchase_during(TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\nALTER FUNCTION count_cover_purchase_during(uint256, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\nALTER FUNCTION count_cover_purchase_during(uint256, bytes32, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE) OWNER TO writeuser;\n\nCREATE OR REPLACE FUNCTION get_datewise_liquidity_summary()\nRETURNS TABLE\n(\n  id                                                        bigint,\n  date                                                      TIMESTAMP WITH TIME ZONE,\n  total_liquidity                                           numeric,\n  total_capacity                                            numeric,\n  total_covered                                             numeric,\n  total_cover_fee                                           numeric,\n  total_purchase_count                                      numeric\n)\nSECURITY DEFINER\nAS\n$$\n  DECLARE _start                                            TIMESTAMP WITH TIME ZONE;\n  DECLARE _end                                              TIMESTAMP WITH TIME ZONE;\nBEGIN\n  CREATE UNLOGGED TABLE IF NOT EXISTS public.datewise_liquidity_summary\n  (\n    id                                                      BIGSERIAL,\n    chain_id                                                integer,\n    date                                                    TIMESTAMP WITH TIME ZONE,\n    total_liquidity                                         numeric,\n    total_capacity                                          numeric,\n    total_covered                                           numeric,\n    total_cover_fee                                         numeric,\n    total_purchase_count                                    numeric\n  );\n\n  ALTER TABLE public.datewise_liquidity_summary OWNER TO writeuser;\n\n  CREATE INDEX IF NOT EXISTS datewise_liquidity_summary_date_inx\n  ON public.datewise_liquidity_summary(date);\n\n  WITH date_ranges\n  AS\n  (\n    SELECT\n      min(block_timestamp) AS min,\n      max(block_timestamp) AS max\n    FROM core.transactions\n  )\n  SELECT to_timestamp(min), to_timestamp(max)\n  INTO _start, _end\n  FROM date_ranges;\n\n  SELECT COALESCE(summary.max_date, _start)\n  INTO _start\n  FROM\n  (\n    SELECT MAX(datewise_liquidity_summary.date) AS max_date\n    FROM datewise_liquidity_summary\n  ) AS summary;\n\n  RAISE NOTICE 'Start date: %. End date: %', _start, _end;\n\n  WITH chains\n  AS\n  (\n    SELECT DISTINCT core.transactions.chain_id\n    FROM core.transactions\n  ),\n  dates\n  AS\n  (\n    SELECT date_trunc('day', dates)::date + interval '1 day' - interval '1 second' AS date\n    FROM generate_series(_start, _end, INTERVAL '1 days') AS dates\n  ),\n  chainwise\n  AS\n  (\n    SELECT DISTINCT chains.chain_id, dates.date\n    FROM chains\n    CROSS JOIN dates\n  )\n  INSERT INTO public.datewise_liquidity_summary(chain_id, date)\n  SELECT chainwise.chain_id, chainwise.date\n  FROM chainwise\n  LEFT JOIN public.datewise_liquidity_summary\n  ON chainwise.chain_id = public.datewise_liquidity_summary.chain_id\n  AND chainwise.date = public.datewise_liquidity_summary.date\n  WHERE public.datewise_liquidity_summary.chain_id IS NULL;\n\n  UPDATE public.datewise_liquidity_summary\n  SET total_liquidity = get_tvl_till_date(public.datewise_liquidity_summary.chain_id, public.datewise_liquidity_summary.date)\n  WHERE public.datewise_liquidity_summary.total_liquidity IS NULL;\n\n  UPDATE public.datewise_liquidity_summary\n  SET total_capacity = get_total_capacity_by_date(public.datewise_liquidity_summary.date)\n  WHERE public.datewise_liquidity_summary.total_capacity IS NULL;\n\n  UPDATE public.datewise_liquidity_summary\n  SET total_covered = get_total_covered_till_date(public.datewise_liquidity_summary.date)\n  WHERE public.datewise_liquidity_summary.total_covered IS NULL;\n\n  UPDATE public.datewise_liquidity_summary\n  SET total_cover_fee = sum_cover_fee_earned_during('-infinity', public.datewise_liquidity_summary.date)\n  WHERE public.datewise_liquidity_summary.total_cover_fee IS NULL;\n\n  UPDATE public.datewise_liquidity_summary\n  SET total_purchase_count = count_cover_purchase_during('-infinity', public.datewise_liquidity_summary.date)\n  WHERE public.datewise_liquidity_summary.total_purchase_count IS NULL;\n\n  RETURN QUERY\n  SELECT\n    row_number() OVER(ORDER BY public.datewise_liquidity_summary.date) AS id,\n    public.datewise_liquidity_summary.date,\n    SUM(public.datewise_liquidity_summary.total_liquidity) AS total_liquidity,\n    SUM(public.datewise_liquidity_summary.total_capacity) AS total_capacity,\n    SUM(public.datewise_liquidity_summary.total_covered) AS total_covered,\n    SUM(public.datewise_liquidity_summary.total_cover_fee) AS total_cover_fee,\n    SUM(public.datewise_liquidity_summary.total_purchase_count) AS total_purchase_count\n  FROM public.datewise_liquidity_summary\n  GROUP BY public.datewise_liquidity_summary.date;\nEND\n$$\nLANGUAGE plpgsql;\n\nALTER FUNCTION get_datewise_liquidity_summary() OWNER TO writeuser;\nALTER TABLE core.transactions owner to writeuser;\nALTER TABLE IF EXISTS public.datewise_liquidity_summary owner to writeuser;\n```","shortMessageHtmlLink":"# Added Datewise Liquidity Summary"}},{"before":"8a863a933ca2778302827d426311c3bb60f708e6","after":"4b52fc42aae70b170434e99b72ab905f581531f2","ref":"refs/heads/main","pushedAt":"2024-03-31T19:04:39.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #65 from flashburst/feature/meta\n\nAdd meta schema and tables","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2216886446\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/65\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/65/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/65\">#65</a> from flashburst/feature/meta"}},{"before":"a1406e1d54af48b007120055655b1459d5422c14","after":null,"ref":"refs/heads/fix/replication","pushedAt":"2024-03-29T14:41:26.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"}},{"before":"446d11a9580c1ce5987c37057d7532c7722bd698","after":"8a863a933ca2778302827d426311c3bb60f708e6","ref":"refs/heads/main","pushedAt":"2024-03-29T14:41:16.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"},"commit":{"message":"Merge pull request #64 from neptune-mutual-blue/fix/replication\n\nFixed Replication Issues","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2214481949\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/64\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/64/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/64\">#64</a> from neptune-mutual-blue/fix/replication"}},{"before":null,"after":"a1406e1d54af48b007120055655b1459d5422c14","ref":"refs/heads/fix/replication","pushedAt":"2024-03-29T02:15:31.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Fixed Replication Issues\n\nFixed replication issue by adding the primary key of the parent table `core.transactions` also to all inherited tables.","shortMessageHtmlLink":"Fixed Replication Issues"}},{"before":"7cb064d6602123aa85e4ed30ef542da0e20f7531","after":null,"ref":"refs/heads/fix/restore-issues","pushedAt":"2024-03-28T23:09:10.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"}},{"before":"89404b3fe551a0d43fcad5e5ca03ea0d5e674492","after":"446d11a9580c1ce5987c37057d7532c7722bd698","ref":"refs/heads/main","pushedAt":"2024-03-28T23:09:06.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #63 from neptune-mutual-blue/fix/restore-issues\n\nFixed Restore Issue","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2214305598\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/63\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/63/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/63\">#63</a> from neptune-mutual-blue/fix/restore-issues"}},{"before":"dccf2e06c651c92e5dc2e7e40cbd7af8d7386173","after":"7cb064d6602123aa85e4ed30ef542da0e20f7531","ref":"refs/heads/fix/restore-issues","pushedAt":"2024-03-28T23:04:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Added `db.sql`","shortMessageHtmlLink":"Added <code>db.sql</code>"}},{"before":null,"after":"dccf2e06c651c92e5dc2e7e40cbd7af8d7386173","ref":"refs/heads/fix/restore-issues","pushedAt":"2024-03-28T23:01:22.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Fixed Restore Issue\n\nUpdated triggers to use fully qualified resource names to fix restore issues","shortMessageHtmlLink":"Fixed Restore Issue"}},{"before":"a0833cfc25e18bcd02b097cf1482cede92b8c6eb","after":"89404b3fe551a0d43fcad5e5ca03ea0d5e674492","ref":"refs/heads/main","pushedAt":"2024-03-25T07:22:17.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Merge pull request #62 from flashburst/fix/gauge-pools\n\nFixed `get_gauge_pools`function","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2205025977\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/62\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/62/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/62\">#62</a> from flashburst/fix/gauge-pools"}},{"before":"8cdcb07732bcb7f87f4387741c9d4339e45d7270","after":"a0833cfc25e18bcd02b097cf1482cede92b8c6eb","ref":"refs/heads/main","pushedAt":"2024-03-24T21:54:36.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #61 from flashburst/gauge-pool-info\n\nAdd info_details column to get_gauge_pools.sql","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2204532902\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/61\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/61/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/61\">#61</a> from flashburst/gauge-pool-info"}},{"before":"04874625f825231b6b32e547e4aac22274541b0a","after":"8cdcb07732bcb7f87f4387741c9d4339e45d7270","ref":"refs/heads/main","pushedAt":"2024-03-24T21:52:13.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rudolfnep","name":null,"path":"/rudolfnep","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/84262876?s=80&v=4"},"commit":{"message":"Merge pull request #60 from flashburst/update/config\n\nUpdated config scripts and views","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2204531405\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/60\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/60/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/60\">#60</a> from flashburst/update/config"}},{"before":"c791d4e016ee48586c1905b054a6490497e3516a","after":"04874625f825231b6b32e547e4aac22274541b0a","ref":"refs/heads/main","pushedAt":"2024-03-22T15:36:58.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Merge pull request #59 from flashburst/update/namespace-trigger\n\nRefactor get_protocol_contracts function to handle namespace conversion","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2202736851\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/59\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/59/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/59\">#59</a> from flashburst/update/namespace-trigger"}},{"before":"7d03f50c64e4cef8ca5774baae8fef5da8ece2fe","after":null,"ref":"refs/heads/fix/bugs","pushedAt":"2024-03-19T20:04:12.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"}},{"before":"ffa3c8bba95f83070668d56c39d708b326826624","after":"c791d4e016ee48586c1905b054a6490497e3516a","ref":"refs/heads/main","pushedAt":"2024-03-19T20:03:57.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"},"commit":{"message":"Merge pull request #58 from neptune-mutual-blue/fix/bugs\n\nBug Fixes","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2194816014\" data-permission-text=\"Title is private\" data-url=\"https://github.com/neptune-mutual-blue/database/issues/58\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/neptune-mutual-blue/database/pull/58/hovercard\" href=\"https://github.com/neptune-mutual-blue/database/pull/58\">#58</a> from neptune-mutual-blue/fix/bugs"}},{"before":null,"after":"7d03f50c64e4cef8ca5774baae8fef5da8ece2fe","ref":"refs/heads/fix/bugs","pushedAt":"2024-03-19T12:18:03.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"binpmxstn","name":"binpmxstn","path":"/binpmxstn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82866095?s=80&v=4"},"commit":{"message":"Bug Fixes\n\n- Fixed the buggy function `get_stablecoin_value`\n- Updated functions to return type `numeric` instead of `uint256`","shortMessageHtmlLink":"Bug Fixes"}},{"before":"637a1f8d2f84b7c670854b13296f1827221e9861","after":null,"ref":"refs/heads/fix/get-stablecoin-value","pushedAt":"2024-03-19T10:58:48.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"}},{"before":"637a1f8d2f84b7c670854b13296f1827221e9861","after":null,"ref":"refs/heads/feature/skip-block","pushedAt":"2024-03-19T10:58:31.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"flashburst","name":null,"path":"/flashburst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/82953782?s=80&v=4"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAETJDdXAA","startCursor":null,"endCursor":null}},"title":"Activity · neptune-mutual-blue/database"}