light dal package
Project description
- banner.connection.Connection(self, host, user, passwd=None, db=None, ssl_key=None, ssl_cert=None, name=None):
Create connection object compatible with banner.queries
raises MySQLError for bad connection
- banner.connection.connections(conns: Dict[str, Connection] = {}):
Getter/Setter for known connections dict
- banner.simple_query(query: str, connection=None, as_df=True) -> pd.DataFrame:
run a simple string query for connection
return data as list of dicts / df (as_df)
connection=None try to get first known connection, raise KeyError if None found
- banner.queries.neware_query(device: int, unit: int, channel: int, test: int, connection: Union[Connection, str] = None, raw=False):
query connection for device, unit, channel, test
connection=None try to get first known connection, raise KeyError if None found
raw=True return data as saved in the db
raw=False compute temp, voltage, current aswell as grouping by auxchl_id
raises Type err if no data exists
- banner.queries.neware_query_by_test(table: str, cell: int, test: int, connection: Union[Connection, str] = None, raw=False):
query connection for device, unit, channel, test, as well as the connection storing the data,
connection=None try to get first known connection, raise KeyError if None found
returns neware_query for result values, the connection has to be an entry in connections()
raises Type err if no data exists
- banner.queries.describe_table(table, connection: Union[Connection, str] = None)
Returns a series of table columns
connection=None try to get first known connection, raise KeyError if None found
- banner.queries.describe(table, connection: Union[Connection, str] = None)
Returns a series of db tables
connection=None try to get first known connection, raise KeyError if None found
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for banner_storedot-1.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 316de611c60a2d0af00c4f0284f2acf4b63702bcd8d5c69aece1abd84836881a |
|
MD5 | 9baa58c1ebd40e2679bb5690b52d0a38 |
|
BLAKE2b-256 | 1f207c8bf2a3e8eff318fe09273c30311c9756ef1ce7267894497e27ab98b6f2 |