CHANGELOG ========= 0.7.0 (2016-05-14) ------------------ * Add new/final importing framework, with full test coverage. * Refactor ``import-rattail`` and ``import-rattail-bulk`` per new framework. * Add ``AdminUser`` import model, for use with ``import-rattail``. 0.6.26 (2016-05-11) ------------------- * Pseudo-release to work around PyPI bug? 0.6.25 (2016-05-11) ------------------- * Remove unused 'ignore role changes' flag for data change recorder. * Grow size of "change key" columns to 255 chars. * Refactor "record changes" mechanism to allow custom behavior. 0.6.24 (2016-05-07) ------------------- * Fix bug when importing new Employee record. 0.6.23 (2016-05-06) ------------------- * Remove alembic import from ``db.util`` module. 0.6.22 (2016-05-05) ------------------- * Refactor scheduled/worked shift models to share some logic. * Make 'tests' a proper subpackage again; add some tests. 0.6.21 (2016-05-03) ------------------- * Fix bug in ``format_phone_number()`` function. 0.6.20 (2016-05-03) ------------------- * Fix line endings for email templates. * Add ``--timeout`` arg support to ``datasync wait`` command. * Refactor where phone number normalization logic lives. 0.6.19 (2016-05-02) ------------------- * Add basic user feedback email template. * Add ``.gitattributes`` file to enforce DOS line endings for mail templates. * Rename original ``ImportSubcommand`` to ``OldImportSubcommand``. * Add support for 'normalized_number' field in phone importer. 0.6.18 (2016-04-29) ------------------- * Add empty ``Watcher.process_changes()`` method for datasync. 0.6.17 (2016-04-28) ------------------- * Add ``RattailConfig.workdir()`` convenience method. * Add ``time.get_sunday()`` convenience function. * Add ``ScheduledShift`` model to schema. 0.6.16 (2016-04-26) ------------------- * Tweak default behavior for importer-based datasync consumer. 0.6.15 (2016-04-26) ------------------- * Tweak when we add new data instance to session, to avoid premature flushes. 0.6.14 (2016-04-25) ------------------- * Add ``WorkedShift`` data model to schema, importer. * Add bulk Rattail importer, plus various tweaks. 0.6.13 (2016-04-24) ------------------- * Add ``add_mail_alias()`` fabric function. * Add ``Watcher.setup()`` method for datasync. * Add ``Consumer.setup()`` method for datasync. * Skip data sync for "empty" host record, in importer-based consumers. * Add ``config.parse_bool()`` function. * Add ``model_mapper`` and ``model_table`` attributes to base importer class. * Add base importer and handler for PostgreSQL "bulk copy" importing. .* Add ``--start-date`` and ``--end-date`` args to importer command. * Add ``RattailConfig.production()`` method. * Add multi-batch change transaction support for datasync consumers. * Provide method by which importers may prevent create/update/delete. * Add ``data`` kwarg to ``Importer.cache_instance_data()`` method. * Alter ``make_utc()`` function to allow returning zone-aware time. * Add initial begin/rollback/commit abstraction to import handlers. * Add ``invoke_importer()`` method to datasync import consumers. 0.6.12 (2016-04-12) ------------------- * Fix bug where ``usedb`` flag wasn't being set from ``make_config()``. 0.6.11 (2016-04-06) ------------------- * Fix bug in ProductCode importer when new records are created. 0.6.10 (2016-04-05) ------------------- * Fix config bug for recording changes in rattail db. 0.6.9 (2016-04-05) ------------------ * Tweak import logging and warning email templates; add runtime etc. * Tweak some logging when initial/basic changes are recorded. * Improve the core importer class to better allow non-SQLAlchemy targets. * Add new importer-based datasync consumer class. * Make a copy of the ``RecordRenderer`` class for new importer framework. * Add host session to main transaction, when importing from SQLAlchemy. * Add mechanism to record changes only for sessions on certain engines. * Add ``Importer.get_single_instance()`` for easier customization. 0.6.8 (2016-03-11) ------------------ * Fix ``cmp(GPC)`` behavior when ``other`` is None etc. 0.6.7 (2016-02-27) ------------------ * Add initial color-coded diffs to data import warning emails. * Fix bug with importing of customer first/last name. * Tweak ``unicode(Employee)`` output. 0.6.6 (2016-02-27) ------------------ * Add ``date_argument`` back to ``rattail.commands`` root. 0.6.5 (2016-02-27) ------------------ * Make ``commands`` subpackage, add ``rattail-dev`` command. * Tweak logging wording when datasync threads die from error. 0.6.4 ----- * Make sure message recipients are unique. * Tweak some wording on data import warnings email template. 0.6.3 ----- * Tweak logging, warning template for new data importers. 0.6.2 ----- * Make config object's underlying db session somewhat configurable. 0.6.1 ----- * Fix bug in Rattail->Rattail import handler. 0.6.0 ----- * Add new importing framework, yay! * Fix support for 'full_name' field in employee data importer. * Tweak some ORM mappings, to support cascading deletes. * Add ``Message.has_recipient()`` method. 0.5.36 ------ * Tweak how changes are sorted by class name, in Rattail datasync consumer. * Add ``metadata`` kwarg to the topographical sortkey function maker. 0.5.35 ------ * Change how we sort dependencies when processing datasync changes for rattail. * Tweak how ``Person.display_name`` is handled during data import. 0.5.34 ------ * Check for null password before attempting bcrypt authentication. * Add recursion support to table dependency sorter function. 0.5.33 ------ * Increase field size for ``Change.class_name``. 0.5.32 ------ * Sort department associations by name, by default. * Add ``EmployeeStore`` association model, with import. * Record change on employee when store/dept association are deleted. 0.5.31 ------ * Give vendor catalog rows a default description of empty string. * Tweak how vendor catalog parsers interpret decimal values. * Change how a vendor catalog batch gets its vendor (parser needn't declare one). * Make upgrade of pip optional when doing ``mkvirtualenv()`` via fabric. 0.5.30 ------ * Add temp hack to avoid ``Person.modified`` when doing a data dump. * Only compare 'effective' fields when checking data diff during import. * Add import normalizers for Department and Employee models. * Add new ``EmployeeDepartment`` model, and importer. 0.5.29 ------ * Bugfix; remove ``progress`` kwarg from (another) importing ``setup()`` method. 0.5.28 ------ * Add ``Importer.normalizer_class`` default attribute. 0.5.27 ------ * Add ``User.employee`` convenience attribute. * Remove Python 2.6 from supported versions in trove classifiers. * Don't use db when fetching timezone from config. * Remove ``progress`` kwarg from db importing ``setup()`` methods. * Change how 'ignored' models are handled for rattail datasync consumers. * Add 'normalizer' concept to data importer. * Add initial 'messages' support in schema/import. * Add initial rattail->rattail data importer. 0.5.26 ------ * Move "process warnings" logic for importers, to handler for simpler overriding. 0.5.25 ------ * Add ``Person.middle_name`` and ``Person.modified``. * Make datasync errors cause the parent thread to terminate. 0.5.24 ------ * Add ``str(RattailError)`` logic. * Tweak ``repr(Change)`` output, to add ``deleted`` flag. * Make a more generic dependency sorting function, for datasync. * Add ``Email.invalid`` flag. * Record change for Person when email/phone is being deleted. * Add ``MailingAddress`` to schema. * Tweak cache API to allow caller to specify query, and prevent duplicate keys. * Add support for importing ``CustomerPhoneNumber`` data. * Tweak ORM relationship for ``CustomerPerson.customer``. * Add ``teardown()`` method for cleanup after data importing. * Add support for "preferred" pseudo-field when importing phone/email data. 0.5.23 ------ * Add ``Category.products`` backref. 0.5.22 ------ * Add ``uid`` param to ``bootstrap_rattail()`` fablib function. * Add delete-orphan cascade for ``Person._customers`` relation. 0.5.21 ------ * Don't warn when sending HTML-only email messages. * Log debug instead of warning when duplicate cache key found. * Return email/phone when adding to person. 0.5.20 ------ * Add warning in ``db.cache.cache_model()`` when duplicate keys are found. * Raise custom exception when no templates found for email. 0.5.19 ------ * Add attachment support to ``mail.send_email()`` function. * Add "wait for changes" support to datasync command. 0.5.18 ------ * Replace ``rsync()`` function in fablib. * Add ``Email.abstract`` attribute, and tweak fallback key. 0.5.17 ------ * Overhaul email framework. 0.5.16 ------ * Add support for 'primary' pseudo-field when importing product codes. 0.5.15 ------ * Fix possible bug when importing cost preferences. * Fix bug in importer, when there are no source data records. 0.5.14 ------ * Add ``files.move_lpt()`` function, remove ``minimal_move()``. 0.5.13 ------ * Fix the db 'dump' function to use unicode and utf-8 file encoding. * Add ``files.minimal_move()`` function, for "moving" files to LPT ports. 0.5.12 ------ * Install ndg-httpsclient also, when installing pip site-wide. * Fix edge case bug when importing $0 product prices. 0.5.11 ------ * Add ``download_db()`` fablib functions for mysql, postgresql. * Add ``configure_virtualenvwrapper()`` to fablib, for adding per-user config. * Add ``Deployer`` class to fablib, for ``deploy.sudoers()`` support. * Always install/upgrade pip and friends when making a new virtualenv. * Check for existence of MySQL database before dropping it, in fablib. * Add "watcher consumes self" concept to datasync daemon. * Add time zone coercion to logged timestamps, if configuring logging in general. 0.5.10 ------ * Add ``default.enabled`` config logic for ``rattail.mail``. * Add ``ErrorTestConsumer`` for testing datasync error handling. * General overhaul of ``rattail.fablib`` subpackage, to support online docs. * Add Mako support to ``deploy()`` functions. * Add ``rsync()`` function. * Add ``bootstrap_rattail()`` function. * Add ``get_debian_version()`` function. * Fix subtle bug if email template not found. * Revamp the ``initdb`` command a bit. * Add ``db_model`` property to ``Command`` class. * Add docs to ``release`` task. 0.5.9 ----- * Add ability to disable emails on a per-type basis. * Add basic exception logging to datasync daemon. * Clean up some logging calls when recording instance changes. * Improve ``repr(Change)`` output. * Add some more custom units of measure (packets, doses). * Tweak startup logic involving config and logging. 0.5.8 ----- * Grow ``DataSyncChange.payload_type`` column. 0.5.7 ----- * Add ``Change.uuid`` as new primary key for the table. * Add 'datasync' daemon. * Add ``clonedb`` command. * Remove version restriction for SQLAlchemy-Utils. * Improve the ``localtime()`` function a bit. * Tweak 'settings' API functions so they don't require a session. 0.5.6 ----- * Fix manifest to include email templates. 0.5.5 ----- * Add temporary hack for sake of WinCE label batches. 0.5.4 ----- * Add config to old ``BatchExecutor`` constructor. * Add ``--no-extend-config`` arg to command line system, for sake of tests. * Add support for "fallback key" when sending mail with config. * Add ``ImportHandler`` class, update ``ImportSubcommand`` to use it etc. 0.5.3 ----- * Configure logging when initializing Windows services. 0.5.2 ----- * Fix another dang bug in ``config.get_user_dir()``. 0.5.1 ----- * Fix bug in ``config.get_user_file()`` signature. 0.5.0 ----- The main reason for the version bump here, is the removal of the 'edbob' dependency. This has been a long-anticipated event. * Fix cascade rules for user/role relationships. * Add default ``repr()`` behavior to data model classes. * Fix type bug in ``db.api.get_department()``. * Add custom errors for when SA / Python for Windows Extensions not installed. * Remove some unused/unwanted command line arguments. * Move some config-related functions to ``rattail.db.config``. * Overhaul config system, finally replacing edbob (yay!). * Remove support for certain deprecated (edbob) config settings. * Remove ``make-config`` command, and edbob dependency! * Add ``config`` arg to ``labels.LabelFormatter`` constructor. * Refactor guts of ``sil.consume_batch_id()`` function. * Add optional ``progress`` arg to ``BatchHandler.execute()`` method. 0.4.30 ------ * Add ``core.UNSPECIFIED`` convenience object. * Fix data bug in ``user_x_role`` table. 0.4.29 ------ * Add config for recycling IMAP connection in bouncer daemon. 0.4.28 ------ * Add 2nd version of UNFI catalog parser. 0.4.27 ------ * Ignore warnings about running on Python 2.6, we know it's an issue. 0.4.26 ------ * Add version restriction for SQLAlchemy-Utils. 0.4.25 ------ * Add initial support for email bounce schema, daemon etc. 0.4.24 ------ * Add ``files.locking_copy_old()`` function...for now. 0.4.23 ------ * Add ``get_store()`` API function. * Add row to batch prior to cognizing the row. (If cognize fails, remove row from batch.) 0.4.22 ------ * Fix bug in KeHe invoice parser, if row has no UPC. 0.4.21 ------ * Set default filename for file-based batches if it's safe to do so. * Add ``MakeFileBatch`` generic filemon action. * Add ``BatchHandler.executable()`` method, for sake of UI. * In batch handlers, let ``cognize_row()`` return ``False`` to skip the row. * Add ``date-organize`` command for help with archiving data files etc. 0.4.20 ------ * Add support for configurable Reply-To address when sending email. * Always upgrade pip (and install wheel) when "installing" pip. * Add 'key' as 3rd positional / 1st keyword arg to ``cache_model()`` function. * Give commands a proper ``RattailConfig`` object instance. * Add ``RattailConfig.getint()`` method to allow a default value. * Change behavior of ``files.locking_copy()`` function. 0.4.19 ------ * Add basic support for email attachments. 0.4.18 ------ * Don't normalize ``Employee.display_name`` to null, in importer. 0.4.17 ------ * Don't change mode for 'app/log' folder in ``mkvirtualenv()``. * Add config setting to globally disable sending of emails. * Add ``User.get_email_address()`` and ``User.email_address``. * Add ``mail.get_template()``; allow override of subject and recipients. * Allow override of UID when creating system user via Fabric. * Add ``grant_mysql_access()`` function for Fabric. * Fix bug in ``create_mysql_user()`` Fabric function. * Don't normalize customer name fields to ``None`` when importing. 0.4.16 ------ * Add some SSH config stuff for Fabric. * Add ``get_product_by_vendor_code()`` API function. * Add ``PathNotFound`` exception, normalize to it within ``locking_copy_test()``. 0.4.15 ------ * Add ``--max-updates`` arg to import commands. 0.4.14 ------ * Don't normalize ``Product.size`` to null when importing. 0.4.13 ------ * Fix constructors etc. for old-style batch providers. 0.4.12 ------ * Normalize duplicate source records during data import. * Make config a required arg to ``BatchProvider`` constructor. * Tweak ``locking_copy_test()`` to assume destination is always a folder. 0.4.11 ------ * Add ``Person.employee`` relationship and ``User.employee`` convenience property. * Change how customer phone data is handled in importer. * Add ``get_department()`` API function. * Tweak filemon and dbsync init scripts to avoid issue of root-owned log file. * Add ``files.locking_copy_test()`` function. 0.4.10 ------ * Don't normalize simple instance fields unless they're involved in the import. * Log warning when duplicate key is detected during import. 0.4.9 ----- * Add ``UnicodeDictWriter`` and ``csvutil`` API docs. * Various changes to allow custom commands to sit in front of non-Rattail database. * Tweak case quantity in Albert's invoice parser. * Add ``--warnings`` flag to base import command. * Fix phone number normalization for customer importer. * Add ``DataProvider.int_()`` method for importers. * Add supposed optimization for simple fields within importer. 0.4.8 ----- * Add unit of measure for cubic feet. 0.4.7 ----- * Stop normalizing some fields on data import. * Catch import error when configuring db in command startup. 0.4.6 ----- * Add deposit links, taxes, product organic flag. * Improve product and vendor schema some more. * Revert to simple names and descriptions for model ``unicode()``. * Add ``GPC.pretty()`` method. * Add ``order_by`` kwarg to ``db.cache.cache_model()`` function. * Add ``get_subdepartment()`` API function. * Add duplicate UPC warning in ``ProductCost`` importer. * Hopefully fix ``install_pip`` Fabric function. 0.4.5 ----- * Add ``status_text`` field to batch row tables. * Add ``BatchHandler.make_batch()`` method. * Add ``FileBatchHandler`` class. * Add ``repr()`` for batch models. * Add vendor catalog batch importer. * Add vendor invoice batch importer. * Add some docs for new batch system. * Add initial ``RattailConfig`` class. * Make sure ``unzip`` is installed when fabricating POD stuff. * Fix some string formatting for Python 2.6. 0.4.4 ----- * Make ``Employee.person`` column unique. * Try again to make database stuff an optional dependency... * Increase size of ``ProductCost.code`` column. * Add ``Product.case_pack`` column. * Add ``encoding_errors`` kwarg to ``UnicodeWriter`` class constructor. 0.4.3 ----- * Fix Alembic ``env.py`` script to accommodate Continuum. * Add ``Product.deleted`` column. 0.4.2 ----- * Fix password prompt on Windows for ``make-user`` command. 0.4.1 ----- * Rework how Continuum versioning is configured. 0.4.0 ----- This version primarily got the bump it did because of the addition of the data import framework and support for SQLAlchemy-Continuum versioning. There were several other minor changes as well. * Allow Fabric ``env`` to override POD download URL. * Quote packages when installing via Fabric ``pip()`` function. * Add ``time.make_utc()`` function. * Add ``db.util.maxlen()`` function. * Add ``set_regular_price()`` and ``set_current_sale_price()`` API functions. * Add ``db.cache.cache_model()`` function. * Add ``csvutil.UnicodeWriter`` class. * Add ``db.importing`` subpackage. * Add ``ImportSubcommand`` as base class for data import subcommands. * Add ``import-csv`` command. * Fix encoding issue when sending email with non-ASCII chars in message. * Increase length of ``Vendor.name`` column. * Add encoding support to ``files.count_lines()``. * Add initial versioning support with SQLAlchemy-Continuum. 0.3.50 ------ * Add Alembic files to the manifest. 0.3.49 ------ * Make all constraint and index names explicit. * Add core Alembic migration repository. 0.3.48 ------ * Fix filemon fallback watcher to ignore things which aren't files. 0.3.47 ------ * Pause execution within filemon action loops (fix CPU usage). * Add fallback watcher feature for filemon on Windows. 0.3.46 ------ * Add ``Product.pretty_upc`` and improve ``unicode(Product)``. * Make ``Vendor.id`` unique; add ``get_vendor()`` API function. * Change default batch purge date to 60 days out instead of 90. * Make SIL writer use a temp path if caller doesn't provide one. * Add ``Product.cost_for_vendor()`` method. * New batch mixin system... * Split ``db.model`` into subpackage. 0.3.45 ------ * Quote PG username when setting password via Fabric. * Allow override of progress text in ``sil.Writer.write_rows()``. * Move bcrypt requirement into 'auth' extra feature. 0.3.44 ------ * Fix some string literal bugs. 0.3.43 ------ * Add ``shell=False`` arg to some Fabric calls for PostgreSQL. 0.3.42 ------ * Add ``consume_batch_id()`` convenience method to ``sil.Writer`` class. * Add mail alias option to ``make_system_user()`` Fabric function. * Add virtualenvwrapper to profile script for root and current user. * Make alembic a core requirement, for now... 0.3.41 ------ * Add ``fablib`` subpackage. * Add ``obfuscate_url_pw()`` to ``db.util`` module. * Add ``temp_path()`` method to ``rattail.sil.Writer`` class. 0.3.40 ------ * Allow overriding key used to determine mail template name. * Add ``Store.database_key`` column. * Move some function logic to ``db.util``. * Add ``csvutil.UnicodeDictReader`` class. 0.3.39 ------ * Let mail template paths be specified as relative to a Python package. 0.3.38 ------ * Tweak ``BatchProvider`` constructor, to prepare for edbob removal. * Email notification rewrite. * Improve Unicode handling within some label printing logic. 0.3.37 ------ * Add ``Product.not_for_sale`` flag. 0.3.36 ------ * Add ``time`` module. 0.3.35 ------ * Fix bug in SIL writer (make sure all writes use instance method). 0.3.34 ------ * Add error handling when attempting user authentication with non-ASCII characters. * Add timeout to ``locking_copy()``. 0.3.33 ------ * Add ``User.active`` and disallow authentication for inactive users. 0.3.32 ------ * Add ``ReportCode`` and ``Product.report_code`` to schema. * Fix ``Product.family`` relationship. * Add ``rattail.config`` module, currently with ``parse_list()`` function only. 0.3.31 ------ * Fix unicode bug in filemon config parsing on Python 2.6. 0.3.30 ------ * File Monitor overhaul! * New configuration syntax (old syntax still supported but deprecated). * Class-based actions. * Configure keyword arguments to action callables. * Configure retry for actions. * Add (some) tests, docs. 0.3.29 ------ * Add support for older SQLAlchemy (0.6.3 specifically). 0.3.28 ------ * Accept config section name within ``rattail.db.util.get_engines()`` and ``rattail.db.util.get_default_engine()``. * Remove deprecated ``record_changes`` option in ``[rattail.db]`` config section. * Remove deprecated ``rattail.db.init()`` function stub. 0.3.27 ------ * Don't require bcrypt unless 'db' feature is requested. 0.3.26 ------ * Add ``filemon.util.raise_exception`` for simple file monitor testing. * Add tox support; fix several test oddities. * Fix thread naming bug in Windows file monitor. 0.3.25 ------ * Require process elevation for ``make-user`` command. * Use 64-bit registry key when hiding user account on 64-bit Windows. * Refactor to remove namespace structure. 0.3.24 ------ * Stop using ``logging.get_logger()`` adapter wrapper, until we know how to do it right. 0.3.23 ------ * Use ``find_packages()`` again, as the last build was broken. (But still exclude tests.) 0.3.22 ------ * Add some error checking when starting Linux daemons. * Add ``'uid'`` and ``'username'`` to logger adapter context dict. * Add initial POD integration module. * Stop using ``find_packages()``; it was including tests. * Add "lock" support to Windows file monitor. 0.3.21 ------ * Add custom ``LoggerAdapter`` implementation; used by file monitor. Hopefully this does a better job and avoids some wheel reinvention. 0.3.20 ------ * Better leverage config when initializing Win32 services. 0.3.19 ------ * Define ``Command`` and ``Subcommand`` classes. These are (finally) no longer borrowed from ``edbob``, yay. * Add SQLAlchemy to core dependencies. * Database config/init overhaul. This contains some not-very-atomic changes: * Get rid of ``get_session_class()`` function and return to global ``Session`` class approach. * Primary database ``Session`` is now configured as part of command initialization, by default. * Make ``config`` object available to subcommands, and ``Daemon`` instances (the beginning of the end for ``edbob.config``!). * Add ``--stdout`` and ``--stderr`` arguments to primary ``Command``. These are in turn made available to subcommands. * Overhauled some subcommand logic per new patterns. * Get rid of a few other random references to ``edbob``. * Added and improved several tests. * Added ability to run tests using arbitrary database engine. 0.3.18 ------ * Populate ``rattail.db.model.__all__`` dynamically. * Add ``util.load_entry_points()``. 0.3.17 ------ * Add SQLAlchemy engine poolclass awareness to config file. 0.3.16 ------ * Make ``get_sync_engines()`` require a config object. * Add ``getset_factory()`` to ``rattail.db.core``. * Dont auto-import ``core`` and ``changes`` from ``rattail.db``. * Handle keyboard interrupt when running dbsync on Linux console. * Make ``rattail.db.model`` the true home for all models. 0.3.15 ------ * Removed global ``Session`` from ``rattail.db``. A Session class may now be had via ``get_session_class()``. * Removed reliance on ``edbob.db.engines``. * Added initial docs (barely, mostly for testing Buildbot). * Updated tests to work on Python 2.6. * Improved init scripts to create PID file parent directory as needed. * Allow Windows file monitor installation with custom user account. 0.3.14 ------ * Improve ``make-user`` command somewhat. Allow username etc. to be overridden; add sanity check if running on platform other than win32. 0.3.13 ------ * Fix ``ChangeRecorder.is_deletable_orphan()`` for SQLAlchemy 0.7. Apparently ``Mapper.relationships`` is not available until SQLAlchemy 0.8 and later... 0.3.12 ------ * Add ``deleted`` attribute to ``repr(Change)``. * Add "deletable orphan" awareness when recording changes. Turns out there was a long-standing bug where orphans which were deleted from the host would be marked as "changed" (instead of deleted), causing the store databases to keep the orphan. 0.3.11 ------ * Added ``mail.send_message()`` etc. 0.3.10 ------ * Altered ``dump`` command to allow easy overriding of data model. 0.3.9 ----- * Add all of ``data`` folder to manifest. * Replaced ``insserv`` calls with ``update-rc.d`` in Fabric script. * Fixed bug in ``price_check_digit()``; added tests. * Fixed bug in ``upce_to_upca()``; added tests. * Added ``get_employee_by_id()`` convenience function. * Refactored model imports, etc. This is in preparation for using database models only from ``rattail`` (i.e. no ``edbob``). Mostly the model and enum imports were affected. * Added remaining values from ``edbob.enum`` to ``rattail.enum``. * Added ``get_setting()`` and ``save_setting()`` to ``db.api``. 0.3.8 ----- * Overhauled db sync somewhat; made a little more customizable, added tests. 0.3.7 ----- * Fixed db sync to properly handle ``Family`` deletions. 0.3.6 ----- * Fixed bug in ``Product.full_description``. * Added ``core.Object`` class. * Made ``enum`` module available from root namespace upon initial import. * Added ``util`` module, for ``OrderedDict`` convenience. * Add ``Family`` and ``Product.family``. 0.3.5 ----- * Declare dependencies instead of relying on edbob. * Added ``db.auth`` module. * Added ``initdb`` command. * Added the ``adduser`` command. * Pretend ``commands.Subcommand`` is defined in ``rattail``. 0.3.4 ----- * Fixed ``Customer._people`` relationship cascading. 0.3.3 ----- * Fixed bugs with ``CustomerGroupAssignment``. Now orphaned records should no longer be allowed. * Fixed ``CustomerPerson`` to require customer and person. * Added ``--do-not-daemonize`` flag to ``dbsync`` command on Linux. * Overhauled some database stuff; added tests. * Added some ``CustomerEmailAddress`` tests, removed some unused tests. 0.3.2 ----- * Fixed bug in ``csvutil.DictWriter``; added tests. 0.3.1 ----- * Added ``Product.full_description`` convenience attribute. * Added ``--do-not-daemonize`` arg to ``filemon`` command on Linux. * Added ``dump`` command. 0.3a43 ------ * Added unicode-aware CSV reader. 0.3a42 ------ * Fixed dbsync bug when deleting a ``CustomerGroup``. Any customer associations which still existed were causing database integrity errors. 0.3a41 ------ * Added ``get_product_by_code()`` API function. 0.3a40 ------ * Added proper ``init.d`` support to Linux dbsync daemon. * Added ``--pidfile`` argument to ``dbsync`` command. * Added ``configure_dbsync`` Fabric command. * Added ``files.overwriting_move()`` convenience function. * Added ``--all`` argument to ``purge-batches`` command. * Added ``ProductCode``, ``Product.codes`` to data model. * Fixed ``db.cache`` module so as not to require initialization. 0.3a39 ------ * Added ``make-user`` command for creating Windows system user account. * Added avatar image, who knows when that will be useful. This was created in the hopes it could be used to programmatically set the Windows user "tile" image; but that proved unfruitful. * Changed Linux file monitor to leverage local code instead of ``edbob``. * Added ``Batch.rows`` property, deprecated ``Batch.iter_rows()``. * Improved ``sil.Writer.write_rows()``. This method now allows explicitly specifying the row count, and accepts a progress factory. 0.3a38 ------ * Changed home folder of system user account to ``/var/lib/rattail``. * Slight overhaul of Linux file monitor. This includes the following: * "More native" Linux file monitor (i.e. less reliant on ``edbob``; current code is more or less copied from that project). * Addition of ``--pidfile`` command argument on Linux. * Added (Linux) file monitor configuration to Fabric script. Also improved ``create_user`` to allow overwriting some settings. * Fixed file monitor service registration on Windows with ``--auto-start``. * Fixed "process elevation check" on Windows XP. * Overhaul of Windows file monitor. This includes: * "More native" Windows file monitor (i.e. less reliant on ``edbob``; current code is more or less copied from that project). * Improve base class for services, to handle the case where the Windows event log is full and can't be written to. (This prevented the file monitor from starting on a machine where the log was full.) 0.3a37 ------ * Added ``temp_path()`` function in ``files`` module. 0.3a36 ------ * Fixed lingering issues from ``Vendor.contacts`` mapping tweak. 0.3a35 ------ * Updated ``repr()`` output for model classes. * Improved ``find_diffs()`` function. * Added ``db.model`` module. * Tweaked some ORM mappings. 0.3a34 ------ * [feature] Changed some logging instances from ``INFO`` to ``DEBUG``. I was just getting tired of the noise. * [feature] Added ``create_user`` Fabric command. This creates the ``rattail`` user on a Linux environment. Probably needs some improvement but it's a start. * [bug] Fixed ``instances_differ()`` function for SQLAlchemy < 0.8. Presumably the use of ``Mapper.column_attrs`` was not a good idea anyway. I'm not quite sure what functionality it adds over ``.columns``. (fixes #9) 0.3a33 ------ * [general] Tweaked Fabric script to remove egg info before building a release. * [feature] Added ``mail`` module; delegates to ``edbob``. * [feature] Added ``Session`` to ``db`` module; delegates to ``edbob``. * [feature] Added ``db.diffs`` module. 0.3a32 ------ - Made product cache include *all* costs if so requested. (Silly oversight.) 0.3a31 ------ - [bug] Made change recorder better able to handle new "sets" of related objects. A situation occurred where multiple related objects were being introduced to the database within the same session. Somehow a dependent object was being processed first, and its UUID value could not be determined since its "upstream" object did yet have one either. This commit improves this situation so that the upstream object will be given an UUID value first, if it doesn't yet have one. The dependent object will then reuse the upstream object's UUID as normal. 0.3a30 ------ - [feature] Added ``console`` module. For now this only delegates to ``edbob.console``. - [feature] Added ``get_product_cache()`` function to ``db.cache`` module. This is probably the first of many such convenience functions. 0.3a29 ------ - [feature] Made Palm conduit unregistration more graceful. Now this will "succeed" even if the conduit isn't actually registered. fixes #7 - [feature] Improved Palm conduit (un)registration logic. Now this can handle the case where Hotsync Manager is not installed on the local machine. The code was refactored to make things cleaner also. fixes #8 - [feature] Added admin rights check for Palm conduit registration. Now the registration process is checked for an "elevated token" and if none is found, a message is displayed and it exits without attempting the registration. fixes #3 - [feature] Added admin rights check for Windows file monitor registration. Now the registration process is checked for an "elevated token" and if none is found, a message is displayed and it exits without attempting the registration. fixes #5 - [feature] Added ``make-config`` command. This may need some work yet, to better handle the namespace package situation. - [feature] Added ``Employee.user`` association proxy attribute. - [feature] Pretend all models and enumerations from ``edbob`` are part of ``rattail``. Some day this will actually be the case. Client code should be able to avoid the ``edbob`` namespace now so that porting will be easier. - [bug] Fixed issue with recording changes when SQLAlchemy >= 0.8.0. Apparently ``RelationshipProperty.remote_side`` is now a ``set`` and doesn't support indexing. 0.3a28 ------ - [feature] Added ``csvutil`` module. Currently this only adds some better ``DictWriter`` support for Python versions older than 2.7. - [feature] Added Palm OS app interface. This adds the Palm HotSync conduit, which is used to create CSV files when a handheld running the Rattail app is synced with its desktop PC. - [feature] Added ``files`` module. This will eventually supercede ``edbob.files``, but for now this commit adds only three functions. These just so happened to be ones needed to support some code involving inventory count batches. - [feature] Added ``wince`` module. This module is used to interface with the Rattail app for Windows CE handheld devices. - [feature] Added new batch system, which will eventually replace the old one. Hopefully they can play nicely in parallel, in the meantime. - [feature] Added `purge-batches` command. This command will delete forever all batches whose purge date has passed. It is meant to be run on a scheduled basis, e.g. nightly. - [feature] Added "case" value to ``UNIT_OF_MEASURE`` enumeration. 0.3a27 ------ - [feature] Added custom `Thread` implementation. This overrides the default behavior of `threading.Thread` by ensuring the system exception hook is invoked in case an error occurs within the thread. 0.3a26 ------ - [feature] Added `get_product_by_upc()` API function. This is a convenience function which will return a single `Product` instance, or `None`. It is the first of hopefully many API functions. - [feature] Added SIL columns `F188`, `R71` and `R72`. These have been added to support inventory count batches. - [bugfix] Fixed `Batch.drop_table()` to handle case where row table doesn't exist. While theoretically this method *shouldn't* encounter a missing table, in practice it does happen occasionally. Now this situation is handled gracefully instead of raising an exception. 0.3a25 ------ - [bug] Fixed ``Vendor.contacts`` relationship (added 'delete-orphan'). - [feature] Added ``Department.subdepartments`` relationship. 0.3a24 ------ - [feature] Added ``__eq__()`` and ``__ne__()`` methods to ``GPC`` class. - [general] Moved ``GPCType`` SQLAlchemy type class to ``rattail.db`` module. This was necessary to make the ``GPC`` class more generally available to callers who don't want or need SQLAlchemy to be installed. - [general] Moved enumerations from database extension to "core" ``enum`` module. This is mostly for convenience to callers. - [bug] Fixed a few bugs with label batches. These existed mostly because this feature hasn't been used in production... - [feature] Added ``default_format`` attribute to ``LabelFormatter`` class. Now when a label profile is edited, this default format is used if no format is provided by the user. - [feature] Changed ``LabelProfile.get_formatter()`` method so that it assigns the formatter's ``format`` attribute using the value from the profile. The formatter is free to use or ignore this value, at its discretion. - [feature] Improved the database synchronizer so that it is *somewhat* tolerant of database server restarts. This likely will need further improvement as more testing is done. The current implementation wraps the entire sync loop in a ``try/catch`` block and when a disconnect is detected, will wait 5 seconds before re-entering the loop and trying again. 0.3a23 ------ - [general] Fixed namespace packages, per ``setuptools`` documentation. - [feature] Added connection timeout support to ``CommandNetworkPrinter``. 0.3a22 ------ - [feature] Added ``LabelProfile.visible`` field. - [feature] Added generic ``CommandNetworkPrinter`` label printer class. This class sends textual commands directly to a networked printer. 0.3a21 ------ - [feature] Refactored database synchronization logic into a proper class, which can be overridden based on configuration. 0.3a20 ------ - [feature] Tweaked the SIL writer so that it doesn't quote row values when they're of data type ``float``. - [bug] Fixed database sync to properly handle ``Vendor`` deletions. Now any associated ``ProductCost`` records are also deleted, so no more foreign key violations. 0.3a19 ------ - [bug] Fixed "price toggle" bug in database sync. It was noticed that whenever a product's regular price did not change, yet the product instance itself *did* have a change, the regular price association was being removed in one sync, then reestablished in the next sync (then removed, etc.). The sync operation now ensures the relationship is removed only when it really should be, and that it remains intact when that is appropriate. 0.3a18 ------ - [bug] Added special delete logic to the database sync. Currently, only the Department and Subdepartment classes are affected. When deletions of these classes are to be synced between databases, some effort is made to ensure that associations with any dependent objects (e.g. Product) are removed before the primary instance (e.g. Department) is deleted. 0.3a17 ------ - [bug] Added 'delete, delete-orphan' to cascade on ``Product.costs`` relationship. This was causing an error when syncing databases. 0.3a16 ------ - [bug] Added 'delete, delete-orphan' to cascade on ``Product.prices`` relationship. This was causing an error when syncing databases. 0.3a15 ------ - [bug] Fixed database sync logic to ensure ``Product`` changes are processed before ``ProductPrice`` changes. Since the underlying tables are mutually dependent, the ``dependency_sort()`` call can't *quite* take care of it. Now a lexical sort is applied to the class names before the dependency sort happens. This is somewhat of a hack, merely taking advantage of the fact that "Product" comes before "ProductPrice" when lexically sorted. If other mutually-dependent tables come about in the future, this approach may need to be revised if their class names don't jive. 0.3a14 ------ - [bug] Fixed database synchonization logic to properly handle merging ``Product`` instances between database sessions. Since ``Product`` is so interdependent on ``ProductPrice``, a pretty custom merge hack is required. 0.3a13 ------ - [bugfix] Fixed ``rattail.db.record_changes()`` so that it also ignores ``UserRole`` instance changes if configuration dictates that ``Role`` changes are to be ignored. 0.3a12 ------ - [bugfix] Fixed foreign key uuid handling in ``rattail.db.record_changes()``. Some tables are meant to be used solely as providers of "association proxy" fields, the ``uuid`` column is not only a primary key, but also a *foreign key* to the "primary" entity table. In such cases, the uuid value was not present at session flush time, so a new one was being generated. Unfortunately this meant that the ``Change`` record would point to a nonexistent entity record, so the sync would not work. Now uuid fields are inspected to determine if a foreign key is present, in which case the relationship is traversed and the true uuid value is used. - [feature] Added "extra classes" configuration for the ``load-host-data`` command. This is necessary when initially populating a "store" (er, "non-host") database instance if custom schema extensions are in use (and need to be synchronized with the host). 0.3a11 ------ - Add R49 SIL column. - Add ``rattail.pricing`` module. 0.3a10 ------ - Ignore batch data when recording changes. 0.3a9 ----- - Bump edbob dependency. 0.3a8 ----- - Tweak database sync. - Tweak batch processing. 0.3a7 ----- - Add ``Vendor.special_discount``. 0.3a6 ----- - Bump edbob dependency. 0.3a5 ----- - Added ``Store`` and related models. - Added ``Customer.email_preference`` field. - Added ``load-host-data`` command. - Added database changes/synchronization framework. - Fixed batch table create/drop. 0.3a4r1 ------- - Added ``Product.cost``, ``Product.vendor``. - Added basic one-up label printing support. - Added initial batch support, with ``PrintLabels`` provider. - Added GPC data type. - Changed internal name of file monitor Windows service. - Added progress support for label printing. - Label profiles moved from config to database model. - Removed ``rattail.db.init_database()`` function. - Moved some enum values from db extension to core (``rattail.enum`` module). - Improved SIL support: moved ``rattail.sil`` to subpackage, added ``Writer`` class etc. - Fixed file monitor in Linux. - Added ``delete-orphan`` to ``Vendor.contacts`` relationship cascade. 0.3a4 ----- - Update file monitor per changes in ``edbob``. 0.3a3 ----- - Move database extension to subdir (``rattail.db.extension``). - Make database extension require ``auth`` extension. - Fix ``rattail.db.init()``. - Add lots of classes to database extension model. - Add ``rattail.labels`` module. - Add ``rattail.db.cache`` module. - Add SIL output functions. - Remove some batch code (for now?). 0.3a2 ----- - Added Windows file monitor service. 0.3a1 ----- - Refactored to rely on `edbob `_. (Most of Rattail's "guts" now live there instead.)