Basic project utilities
Project description
This project joins some useful scripts designed to speed up project development.
Main scripts are:
configuration.py
This script generates a configparser.configuration instance.
Configuration load from different sources:
AWS Systems manager parameter store
- Given that AWS CLI is configured and credentials loaded
configuration = load_config('ssm',environment)
SSM variable key must have format: /$environment/$section and value in json format
Key | Value |
---|---|
/pre/ddbb | {"host":"localhost","port":3306,"username":"root","password":"changeit"} |
Local file
configuration = load_config('file',environment, file_name)
File expected in standard INI file structure.
[ddbb]
host=localhost
port=3306
username=root
password=changeit
Environment variables.
configuration = load_config('env',environment, projectname)
Variables should have the following format: $projectname_$environemnt_$sectionname
MYPROJECT_PRO_DDBB_HOST=localhost
MYPROJECT_PRO_DDBB_PORT=3306
MYPROJECT_PRO_DDBB_USERNAME=root
MYPROJECT_PRO_DDBB_PASSWORD=changeit
Database.py
Database connection and query execution
database = Database.ofConfiguration(configuration)
To execute query, use method Database.run_query
records = database.run_query('SELECT * FROM table WHERE mycolumn = %s AND myothercolumn = '%s',('value1', 'value2' ))
Pagination is supported using class database.Page:
page_number = 1
page_size = 50
page = Database.Page(page_number, page_size)
records = database.run_query('SELECT * FROM table WHERE mycolumn = %s AND myothercolumn = '%s', ('value1', 'value2' ), page)
alerts.py
Alert sending, via AWS simple email service.
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
basacommons-0.0.16.tar.gz
(4.7 kB
view hashes)
Built Distribution
Close
Hashes for basacommons-0.0.16-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ff842574f859a3aa96c2b4d952b65918e626b948698164c2fc1da1e1f4f06abd |
|
MD5 | 08cafe0c73127d210a305eb750135a68 |
|
BLAKE2b-256 | 206d1f82456581e9f3eb38c179e8630f4ff8aca3856f076576583285b3b75a9a |