Ticdat

- docs/pydocmd.yml updated for 0.2.22 newer documentation
- example code has minor improvements
- fixed minor bug in `write_schema` for PG so that default values are written to PG even when `include_ancillary_info` is False.
- changed `write_schema` so that a `datetime` data typed column with a string default and a text PG column type will retain the default.
- `write_data` accepts table specific context manager (`roundoff_helper` issue [10](https://github.com/decision-spot/roundoff_helper/issues/10))

Following summarizes all the changes since the 0.2.21 Release.

- bytea field type support added to PostGres functionality, to support `pickle`d objects being serialized in a PG DB.
- `TicDat.__init__` called with `pandas.DataFrame` will use default values to fill in missing data fields data fields 149
* `clone_` functions added to `TicDatFactory` and `PanDatFactory` to support the following schema manipulations via cloning.
* Adding a table. (Removing a table has been available for a while with the `table_restrictions` argument of the vanilla `clone`.
* Adding a column.
* Removing a column.
* Renaming a column.
* `duplicates_ticdat_init` flag available to better manage the duplicate rows when initializing `TicDat` objects. (151)
* munging speed improvement for infinity io flag (131)
* `-r` command line support for Roundoff. 159
* Enframe support removed.
* `-e` command line argument now used for data integrity errors report. (164).
* `dat_restricted` `sln_restricted` removed from `ticdat`. (These are super-easy to re-create manually is anyone needs them for backwards compatibility).
* Fixed empty-string bug when checking a `datetime` data type. (162)
* `tooltips` added to `TicDatFactory`, `PanDatFactory` for better schema documentation. (156)
* `TicDatFactory` and `PanDatFactory` now consistent in terms of always json-dumping an empty list for an empty table.
* `get_row_predicates` added to `TicDatFactory`, `PanDatFactory` to allow easier programmatic assessment of current row predicates.
* `remove_parameter` added to `TicDatFactory`, `PanDatFactory`.
* `TicDatFactory` now allows default values for primary key fields.
* `TicDatFactory` and `PanDatFactory` now share the same default JSON format. List-of-lists is succinct and human readable.
* `add_implied_foreign_keys` added to `TicDatFactory` (which now longer creates implied foreign keys by default).
* `PanDat.__init__` uses defaults to handle missing columns.
* In general, more robust initialization of `TicDat`, `PanDat` from `pandas.DataFrame`.
* `TicDatFactory`/`PanDatFactory` `clone` made safer
* Minor bug fix re: string munging when writing parameters table.

- -e argument should dump out a a set of empty tables if no integrity errors are found 167
- TicDat.__init__ from pandas.DataFrame doesn't fill in data fields 149

* `clone_` functions added to `TicDatFactory` and `PanDatFactory` to support the following schema manipulations via cloning.
* Adding a table. (Removing a table has been available for a while with the `table_restrictions` argument of the vanilla `clone`.
* Adding a column.
* Removing a column.
* Renaming a column.
* `duplicates_ticdat_init` flag available to better manage the duplicate rows when initializing `TicDat` objects. (151)
* munging speed improvement for infinity io flag (131)
* `-r` command line support for Roundoff. 159
* Enframe support removed.
* `-e` command line argument now used for something else.
* `dat_restricted` `sln_restricted` removed from `ticdat`. (These are super-easy to re-create manually is anyone needs them for backwards compatibility).
* Fixed empty-string bug when checking a `datetime` data type. (162)
* `tooltips` added to `TicDatFactory`, `PanDatFactory` for better schema documentation. (156)
* `-e` command line argument now supports creation of data integrity errors report. (164).
* `TicDatFactory` and `PanDatFactory` now consistent in terms of always json-dumping an empty list for an empty table.
* `get_row_predicates` added to `TicDatFactory`, `PanDatFactory` to allow easier programmatic assessment of current row predicates.
* `remove_parameter` added to `TicDatFactory`, `PanDatFactory`.
* `TicDatFactory` now allows default values for primary key fields.

* `TicDatFactory` and `PanDatFactory` now share the same default JSON format. List-of-lists is succinct and human readable.
* `add_implied_foreign_keys` added to `TicDatFactory` (which now longer creates implied foreign keys by default).
* `PanDat.__init__` uses defaults to handle missing columns.
* In general, more robust initialization of `TicDat`, `PanDat` from `pandas.DataFrame`.
* `TicDatFactory`/`PanDatFactory` `clone` made safer
* Minor bug fix re: string munging when writing parameters table.

Following summarizes all the changes since the 0.2.20 Release.

- Fixing a slow data load problem for `TicDatFactory` and Excel files. Should have been fixed with 0.2.19.6 but I overlooked Excel.
- Performance improvement for Excel reading with `PanDatFactory`
- Uses `openpyxl` for reading .xlsx files (latest `xlrd` no longer works for this).
- This includes some work to prune trailing all-empty rows, which were previously auto-pruned by the `xlrd` code.
- Ancient branches with example code finally got merged in.
- Fixed a minor bug re: setting up PG schemas.
- Fixed a minor bug re: initialing `PanDat` objects with empty lists for the named arguments.
- Made the csv example data a little more challenging to import.
- better `clone` functionality (easier to customize a clone to a slightly different schema)
- fixed deployment problem for sparse Pythons
- minor bug fix in examples
- minor bug fix re: `PanDatFactory` and long Excel sheet names
- Progress tracking for pd pg uploading.