light dal package
Project description
- banner.connection:
- Connection(Object):
ABS class
- CacheConnection(Connection):
ABS class
- MySqlConnection(Connection)(host, user, passwd, db, ssl_key, ssl_cert, name):
Create Connection object compatible with banner.queries
raises MySQLError for bad connection
- RedisConnection(CacheConnection)(host, port, passwd, db, ssl_key, ssl_cert, name, ttl):
Create CacheConnection object compatible with banner.queries
- connections(conns: Dict[str, Connection] = {}):
Getter/Setter for known(default) Connections dict
- cache_connection(con: CacheConnection = None):
Getter/Setter for known(default) CacheConnection
- banner.queries:
- simple_query(query: str, connection=None, cache_connection=None, ttl=None) -> pd.DataFrame:
run a simple string query for Connection
connection=None try to get first known connection, raise KeyError if None found
Cache the result if cache_connection or banner.connection.cache_connection exists (ttl if provided otherwise use cache_connection.ttl)
- neware_query(device: int, unit: int, channel: int, test: int, connection: Union[Connection, str] = None, cache_connection=None, ttl=None, raw=False, dqdv=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
dqdv=True -> banner.neware.calc_dq_dv
Cache the result if cache_connection or banner.connection.cache_connection exists (ttl if provided otherwise use cache_connection.ttl)
raises Type err if no data exists
- neware_query_by_test(table: str, cell: int, test: int, connection: Union[Connection, str] = None, cache_connection=None, ttl=None, raw=False, dqdv=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
raw=True return data as saved in the db
raw=False compute temp, voltage, current aswell as grouping by auxchl_id
dqdv=True -> banner.neware.calc_dq_dv
Cache the result if cache_connection or banner.connection.cache_connection exists (ttl if provided otherwise use cache_connection.ttl)
returns neware_query for result values, the connection has to be an entry in connections()
raises Type err if no data exists
- 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
- 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
- banner.neware:
- -calc_neware_cols(data: pd.DataFrame):
calculate neware columns for a valid neware DataFrame
- calc_dq_dv(data: pd.DataFrame, raw=False):
Calculate DQ/DV for a valid neware df
raw=False: remove outliers
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.2.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 256a4667ada0c0c8e79d423741f45eea155391ee6975810bfb24fbbd66a5ae80 |
|
MD5 | f0f991ed4767769460306d8ccff4969f |
|
BLAKE2b-256 | db16541f58d9e4487535f2b4b4b61f4cabbe222c9f4f5f89c08acbcfa74654b4 |