web3research.eth.EthereumProvider ================================= .. py:class:: web3research.eth.EthereumProvider(api_token, backend: Optional[str] = None, database: str = 'ethereum', settings: Optional[Dict[str, Any]] = None, generic_args: Optional[Dict[str, Any]] = None, **kwargs) Bases: :py:obj:`web3research.db.ClickhouseProvider` EthereumProvider is a provider for fetching data on Ethereum from the backend. .. py:attribute:: database :value: 'ethereum' .. py:method:: blocks(where: Optional[str], order_by: Optional[Dict[str, bool]] = {'number': True}, limit: Optional[int] = 100, offset: Optional[int] = 0, parameters: Optional[Dict[str, Any]] = None) -> Generator[Dict[str, Any], None, None] Get blocks from the database. Args: where (str): The WHERE clause. order_by (Dict[str, bool], optional): The ORDER BY clause. Defaults to number ascending. limit (int, optional): The LIMIT clause. Defaults to 100. offset (int, optional): The OFFSET clause. Defaults to 0. parameters (Dict[str, Any], optional): The query parameters. Defaults to None. Returns: Generator[Dict[str, Any], None, None]: A generator of blocks. .. py:method:: transactions(where: Optional[str], order_by: Optional[Dict[str, bool]] = {'blockNumber': True, 'transactionIndex': True}, limit: Optional[int] = 100, offset: Optional[int] = 0, parameters: Optional[Dict[str, Any]] = None) -> Generator[Dict[str, Any], None, None] Get transactions from the database. Args: where (str): The WHERE clause. order_by (Dict[str, bool], optional): The ORDER BY clause. Defaults to blockNumber and transactionIndex ascending. limit (int, optional): The LIMIT clause. Defaults to 100. offset (int, optional): The OFFSET clause. Defaults to 0. parameters (Dict[str, Any], optional): The query parameters. Defaults to None. Returns: Generator[Dict[str, Any], None, None]: A generator of transactions. .. py:method:: traces(where: Optional[str], order_by: Optional[Dict[str, bool]] = {'blockNumber': True, 'blockPos': True}, limit: Optional[int] = 100, offset: Optional[int] = 0, parameters: Optional[Dict[str, Any]] = None) -> Generator[Dict[str, Any], None, None] Get traces from the database. Args: where (str): The WHERE clause. order_by (Dict[str, bool], optional): The ORDER BY clause. Defaults to blockNumber and blockPos ascending. limit (int, optional): The LIMIT clause. Defaults to 100. offset (int, optional): The OFFSET clause. Defaults to 0. parameters (Dict[str, Any], optional): The query parameters. Defaults to None. Returns: Generator[Dict[str, Any], None, None]: A generator of traces. .. py:method:: events(where: Optional[str], order_by: Optional[Dict[str, bool]] = {'blockNumber': True, 'transactionIndex': True, 'logIndex': True}, limit: Optional[int] = 100, offset: Optional[int] = 0, parameters: Optional[Dict[str, Any]] = None) -> Generator[Dict[str, Any], None, None] Get events from the database. Args: where (str): The WHERE clause. order_by (Dict[str, bool], optional): The ORDER BY clause. Defaults to blockNumber, transactionIndex, and logIndex ascending. limit (int, optional): The LIMIT clause. Defaults to 100. offset (int, optional): The OFFSET clause. Defaults to 0. parameters (Dict[str, Any], optional): The query parameters. Defaults to None. Returns: Generator[Dict[str, Any], None, None]: A generator of events.