Nutra

Added
~~~~~

- Limit search & sort results to top ``n`` results (e.g. top 10 or top 100)
- Enhanced terminal sizing (buffer termination).
- ``Pydoc`` ``PAGING`` flag via ``--no-pager`` command line argument
(with ``set_flags()`` method).
- Check for appropriate ``ntsqlite`` database version.
- ``[DEVELOPMENT]`` Special ``file_or_dir_path`` and ``file_path``
custom type validators for ``argparse``.
- ``[DEVELOPMENT]`` Added special requirements files for
(``test``, ``lint``, ``optional: Levenshtein``,
and ``win_xp-test`` [Python 3.4]).
- ``[DEVELOPMENT]`` Added ``CHANGELOG.md`` file.

Changed
~~~~~~~

- Print ``exit_code`` in DEBUG mode (`--debug` flag/argument).
- Moved ``subparsers`` module in ``ntclient.argparser`` to ``__init__``.
- Moved tests out of ``ntclient/`` and into ``tests/`` folder.

Added
~~~~~

- Python 3.4 support (Windows XP and Ubuntu 16.04).
- Debug flag (``--debug | -d``) for all commands.

Changed
~~~~~~~

- Overall structure with main file and ``argparse`` methods.
- Use soft pip requirements ``~=`` instead of ``==``.
- ``DEFAULT`` and ``OVER`` colors.

Removed
~~~~~~~

- ``guid`` columns from ``ntsqlite`` submodule.

Added
~~~~~

- SQLite support for ``usda`` and ``nt`` schemas
(removed API calls to remote server).
- Preliminary support for ``recipe`` and ``bio`` sub-commands.
- On-boarding process with ``init`` sub-command.
- Support for ``argcomplete`` on ``bash`` (Linux/macOS).
- Tests in the form of a sole ``test_cli.py`` file.

Added
~~~~~

- Support for analysis of "day" ``CSV`` files.


***********
Changelog
***********

All notable changes to this project will be documented in this file.

The format is based on `Keep a Changelog <https://keepachangelog.com/en/1.1.0/>`_,
and this project adheres to `Semantic Versioning <https://semver.org/spec/v2.0.0.html>`_.



`[Unreleased] <https://github.com/nutratech/nt-sqlite/compare/0.0.5...HEAD>`_

Changed
~~~~~~~

- Replace grams with ``msre_id`` and ``amt`` in ``food_log`` table
- Rename to use ``.sqlite3`` extension, instead of ``nt.sqlite``

Development
~~~~~~~~~~~

- Enhance lint tools
- Use ``__main__.py`` & ``python -m sql`` to package and build sqlite3 file

Added
~~~~~

- SQL tables ``bug`` and ``msg``, for bug reports & pushed message queue

Added
~~~~~

- Empty ``__init__.py`` file to make packageable with ``cli`` repo
(as a ``git submodule``)
- SQL table ``custom_foods`` and respective ``cf_dat``

Changed
~~~~~~~

- Build with ``python sql/__init__.py`` (removed top-level script ``build.py``)
- Rename pre-populated ``meals`` table to ``meal_name``

Fixed
~~~~~

- Slight bash inconvenience when using ``export.sh``

Removed
~~~~~~~

- ``food_costs`` table
- ``biometrics`` ad related tables