Project

General

Profile

Actions
Copy link

Task #10991

closed

Feature (development) #10649: Database changes

database migration followup check

Added by Andrej Ondrejovic about 2 years ago. Updated almost 2 years ago.

Status:
Done
Priority:
Normal
Assignee:
Blin Bakija
Category:
Backend
Target version:
WWW - V3 - integrated custody L10
Start date:
04/17/2023
Due date:
% Done:

100%

Estimated time:
custom category:
Backend
Pull Request:
Co-assignee:

Description

  • in trm there is no count

trm is migrating 5200 assets

1 materialized view in TRM and MARKET(before the migration)

  • sum of assets where location is not nitro and asset_type_id is not 30 or 1,42,100,101,110 (5200)
  • for market sum of count

1 materialized view in Nitro

  • sum of count - 1000

1 view per MKT/TRM

  • sum of assets where migrated is true 5200

1 view in nitro

  • sum of count 6200
Actions
Copy link
 #1

Updated by Blin Bakija about 2 years ago

Market materialized view -
CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select sum(assets.count) from assets

Market View

CREATE VIEW view_asset_count AS
select sum(assets.count) from assets

Actions
Copy link
 #2

Updated by Blin Bakija about 2 years ago

TRM materialized view -

CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = false and location !='nitro' and asset_type_id != 30 and asset_type_id != 1

TRM view -
CREATE VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = true and location !='nitro' and asset_type_id != 30 and asset_type_id != 1

Actions
Copy link
 #3

Updated by Blin Bakija about 2 years ago

Nitro materialized view -
CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select sum(assets.count) from assets

Nitro View

CREATE VIEW view_asset_count AS
select sum(assets.count) from assets

Actions
Copy link
 #4

Updated by Blin Bakija about 2 years ago

Blin Bakija wrote in #note-2:

TRM materialized view -

CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = false and location !='nitro' and asset_type_id NOT IN (1,42,100,101,110)

TRM view -
CREATE VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = true and location !='nitro' and asset_type_id NOT IN (1,42,100,101,110)

Actions
Copy link
 #5

Updated by Blin Bakija about 2 years ago

  • Status changed from New to Code Review
Actions
Copy link
 #6

Updated by Ondrej Grman about 2 years ago

  • Sprint changed from #1 custody in frontend (Mar 20 - Apr 03) to #1 running to custody (Mar 20 - Apr 03)
  • Category set to Backend
  • Status changed from Code Review to Testing
  • % Done changed from 0 to 100
  • Parent task set to #10649
Actions
Copy link
 #7

Updated by Andrej Ondrejovic almost 2 years ago

  • Status changed from Testing to Done
Actions
Copy link

Also available in: Atom PDF