All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
- Add params to .query(); allow placeholders, dynamic queries
- Change default connection parameter names specified in .env to postgres parameter names
- Forgot to update init file, to import create_database()
- Added create_database() function
- Added common.py in tests
- Broke some more complex tests like for upsert() to specific files for better organization.
- Reverted code for colname_snip() as it was not allowing for auto-index creation. '::' is not allowed in index name.
- Fix snippet module refernce to iterable_difference. from wrapg import util vs from util import iterable_difference.
- Add more tests for wrapg functions
- Add exclude_update parameter to update() and upsert() functions
- Fix colname_snip() to properly cast types if date() passed; it was affecting upsert with index=False
- Fixed exisitng snippet tests due to type casting issue on colname_snip()
- Add insert_snip() to resuse insert code
- Improve regex to better detect functions in column
- Add 'use_index' to upsert(); set to False to upsert without use of unique index
- Add more tests on util.py and snippet.py
- Fix sqlfunc() to properly cast a timestamp to date()
- Fix update() with ' AND '
- Add code for delete() which takes dictionary for where clause parmeters
- The column name can be wrapped with sql function like upsert and update functions
- Add clear_table() to quickly clear all data in specified table
- Add code to accept sql functions on column keys for upsert() and ignore_insert() functions. ie. upsert(keys=['name', 'Date(ts_column)'])
- Change .env PG_USERNAME variable to PG_USER to better match postgres user connection parameter.
- Added some examples to readme.md
- Escape create_table() column names
- Upsert() not working due to bad code.