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.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 56116a63858e84e7c9f7fd277cd0b6825d4b588d4d48b630203c8773e754f9bb |
|
MD5 | 9853425de9d056aee2c589d644edbd0b |
|
BLAKE2b-256 | 41d4cd16f493c107e4ab8d412ae4e790d7f1e782abc5b1de9a53ea0e7aa9ac2f |