finpandas.core.connections module

finpandas base module.

class DatabaseConnection(database: str, username: str = 'finpandas', password: Optional[str] = None, _host: str = 'database-blacktip.cpeql2xeyjqq.us-east-2.rds.amazonaws.com', _port: int = 3306)

Bases: object

Establish a connection with the database.

Parameters

  • username (str) – your username

  • password (str) – your password

database: str
dispose()

closes the database connection

password: str = None
query(command: str)

query information directly from the database

Parameters

command (str) – the string mySQL command to execute

Returns

the results of the query

Return type

sqlalchemy.engine.Result

username: str = 'finpandas'