Skip to content

Instantly share code, notes, and snippets.

@anusha-ctrl
Created December 3, 2024 20:09
Show Gist options
  • Save anusha-ctrl/1377aefc94f5f9eae9ab75441ed28a23 to your computer and use it in GitHub Desktop.
Save anusha-ctrl/1377aefc94f5f9eae9ab75441ed28a23 to your computer and use it in GitHub Desktop.
Script to add bridging pairs.
from app.core.asset.metadata.model.asset_identifier import UniversalAssetId
from app.core.asset.metadata.model.asset_relationship import (
AssetRelationship,
AssetRelationshipInsert,
RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
AssetRelationshipDatabaseModel,
AssetRelationshipRepository,
)
# Top 10 Bridge Pairs Where Assets Change Across Bridge
# crypto_1 crypto_4442
# crypto_4655 crypto_28175
# crypto_2 crypto_4265
# crypto_2444 crypto_18860
# crypto_2444 crypto_27612
# crypto_1067 crypto_22336
# crypto_7801 crypto_13364
# crypto_5495 crypto_17619
# crypto_2444 crypto_23427
# crypto_2444 crypto_21810
def add_bridge_pairs():
inserts = [
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_1"),
second_asset_uaid=UniversalAssetId("crypto_4442"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_4655"),
second_asset_uaid=UniversalAssetId("crypto_28175"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_2"),
second_asset_uaid=UniversalAssetId("crypto_4265"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_2444"),
second_asset_uaid=UniversalAssetId("crypto_18860"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_2444"),
second_asset_uaid=UniversalAssetId("crypto_27612"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_1067"),
second_asset_uaid=UniversalAssetId("crypto_22336"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_7801"),
second_asset_uaid=UniversalAssetId("crypto_13364"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_5495"),
second_asset_uaid=UniversalAssetId("crypto_17619"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_2444"),
second_asset_uaid=UniversalAssetId("crypto_23427"),
relationship=RelationshipPair.BRIDGED,
),
AssetRelationshipInsert(
first_asset_uaid=UniversalAssetId("crypto_2444"),
second_asset_uaid=UniversalAssetId("crypto_21810"),
relationship=RelationshipPair.BRIDGED,
),
]
repository = AssetRelationshipRepository(db_session=db.session)
for insert in inserts:
item = repository.add_pair(insert)
print(item.__dict__)
@anusha-ctrl
Copy link
Author

from app.core.asset.metadata.model.asset_identifier import UniversalAssetId
from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_2444"),
      second_asset_uaid=UniversalAssetId("crypto_38904"),
      relationship=RelationshipPair.BRIDGED,
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

@anusha-ctrl
Copy link
Author

from app.core.asset.metadata.model.asset_identifier import UniversalAssetId
from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_45902"),
      second_asset_uaid=UniversalAssetId("crypto_9529"),
      relationship=RelationshipPair.BRIDGED,
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

@anusha-ctrl
Copy link
Author

anusha-ctrl commented Jan 15, 2025

from app.core.asset.metadata.model.asset_identifier import UniversalAssetId
from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)


"""
crypto_1 | crypto_199485
crypto_5176 | crypto_29459
crypto_5176 | crypto_8508
crypto_5176 | crypto_9021
"""

inserts = [
AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_1"),
      second_asset_uaid=UniversalAssetId("crypto_199485"),
      relationship=RelationshipPair.BRIDGED,
), 
AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_5176 "),
      second_asset_uaid=UniversalAssetId("crypto_29459"),
      relationship=RelationshipPair.BRIDGED,
), 
AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_5176"),
      second_asset_uaid=UniversalAssetId("crypto_8508"),
      relationship=RelationshipPair.BRIDGED,
), 
AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_5176"),
      second_asset_uaid=UniversalAssetId("crypto_9021"),
      relationship=RelationshipPair.BRIDGED,
)]
repository = AssetRelationshipRepository(db_session=db.session)
for insert in inserts:
  item = repository.add_pair(insert)
  print(item.__dict__)

@anusha-ctrl
Copy link
Author

from app.core.asset.metadata.model.asset_identifier import UniversalAssetId
from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_1"),
      second_asset_uaid=UniversalAssetId("blockchain_2507479101"),
      relationship=RelationshipPair.BRIDGED,
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

@anusha-ctrl
Copy link
Author

anusha-ctrl commented Jun 9, 2025

from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_549"),
      second_asset_uaid=UniversalAssetId("crypto_202883"),
      relationship=RelationshipPair.BRIDGED, 
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

@anusha-ctrl
Copy link
Author

anusha-ctrl commented Jun 9, 2025

from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_689"),
      second_asset_uaid=UniversalAssetId("crypto_202884"),
      relationship=RelationshipPair.BRIDGED, 
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

@anusha-ctrl
Copy link
Author

from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_203087"),
      second_asset_uaid=UniversalAssetId("crypto_1581"),
      relationship=RelationshipPair.BRIDGED, 
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

@anusha-ctrl
Copy link
Author

anusha-ctrl commented Jul 1, 2025

from app.core.asset.metadata.model.asset_relationship import (
    AssetRelationship,
    AssetRelationshipInsert,
    RelationshipPair,
)
from app.settings import settings
from app.utils import db
from app.core.asset.metadata.internal.repository.asset_relationship_repository import (
    AssetRelationshipDatabaseModel,
    AssetRelationshipRepository,
)

insert = AssetRelationshipInsert(
      first_asset_uaid=UniversalAssetId("crypto_203086"),
      second_asset_uaid=UniversalAssetId("crypto_3"),
      relationship=RelationshipPair.BRIDGED, 
)
repository = AssetRelationshipRepository(db_session=db.session)
item = repository.add_pair(insert)
print(item.__dict__)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment