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.14.tar.gz
(4.6 kB
view hashes)
Built Distribution
Close
Hashes for basacommons-0.0.14-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8dcc0d76f3bf9840f43220ad4ad7ceb362cd0ed9dfe36cf9fe96674b13ebbd04 |
|
MD5 | e4a5829ad9d409fe957dbdefcdce2304 |
|
BLAKE2b-256 | 615cd4f1cf671d8035c15a22ddccdf98251603c398d0fdc3d269b3b0edf767cc |