light weight package for populating mongo database and query it with energy data
Project description
Local Database
Description:
Popluate and query local mongo server with energy api data
Populate Database Section
Sample Usage
Batch insertion:
create_db = CreateDb(db_name='example_db')
create_db.batch_insert('folder_path')
Single insert:
create = CreateDb(db_name='example_db')
create.single_insert(time_collection='time_(1_sec|1_min|15_min)', data_file_dir='data folder path', meta_file_dir='metadata folder path')
Query Database Section
Sample Usage
Query with filter
query = QueryDb(db_name='example_db')
query_param = ['nest', 'grid', 'solar', 'clotheswasher1', 'dishwasher1']
data, id_list = query.query_df(query_param, 'time_15_min', db_op='OR', city=['all'])
try:
data = QueryDb.filter_by(data, dataid='6139', city='austin')
except Exception as e:
print(e)
Query with dictionary parameter
query = QueryDb(db_name='example_db')
query_param = ['air1', 'nest', {'first_floor_square_footage': 2148}]
data, id_list = query.query_df(
query_param,
time_collection='time_15_min',
db_op='AND',
city=['all']
first_floor_sqft_tol=0
)
Test scripts
Must have test json files to implement this.
note: commands must be implemented from command line ./local_db directory
python -m unittest tester.TestCreateDbClass.test_db_server
python -m unittest tester.TestCreateDbClass.test_batch_insert
python -m unittest tester.TestCreateDbClass.test_query_error_check
python -m unittest tester.TestCreateDbClass.test_query_empty
python -m unittest tester.TestCreateDbClass.test_query_db_op
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
local_db-lasdot-0.0.1.tar.gz
(7.7 kB
view hashes)
Built Distribution
Close
Hashes for local_db_lasdot-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2d3176f2f6695bcc0843c864e451fda0bd0e8bd3624cfd97601cfd3c7c3a9568 |
|
MD5 | 189882ee325d032d8b11adbf98421d5e |
|
BLAKE2b-256 | 792d7a616bed40654fb3aef60126a7db46c29e15d3c7011b183ca9163a02903c |