32 lines
645 B
Python
32 lines
645 B
Python
import json
|
|
from typing import List
|
|
|
|
from mev_inspect.models.swaps import SwapModel
|
|
from mev_inspect.schemas.swaps import Swap
|
|
|
|
from .shared import delete_by_block_range
|
|
|
|
|
|
def delete_swaps_for_blocks(
|
|
db_session,
|
|
after_block_number: int,
|
|
before_block_number: int,
|
|
) -> None:
|
|
delete_by_block_range(
|
|
db_session,
|
|
SwapModel,
|
|
after_block_number,
|
|
before_block_number,
|
|
)
|
|
db_session.commit()
|
|
|
|
|
|
def write_swaps(
|
|
db_session,
|
|
swaps: List[Swap],
|
|
) -> None:
|
|
models = [SwapModel(**json.loads(swap.json())) for swap in swaps]
|
|
|
|
db_session.bulk_save_objects(models)
|
|
db_session.commit()
|