========================
Saturday, March 28, 2015
========================

Continued to try to get :manage:`initdb` to work on InnoDB. No
success, but the error report is more detailed::

    Traceback (most recent call last):
      ...
      File ".../lino/lino/management/commands/initdb_demo.py", line 32, in handle
        super(Command, self).handle(*args, **options)
      File ".../lino/lino/management/commands/initdb.py", line 172, in handle
        pending = self.try_sql(cursor, pending)
      File ".../lino/lino/management/commands/initdb.py", line 101, in try_sql
        raise Exception(msg)
    Exception: 13 pending SQL statements failed:
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `users_user`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.OperationalError'> :
      ALTER TABLE `countries_place` DROP FOREIGN KEY `parent_id_refs_id_998565a6`;
      (1025, "Error on rename of './ylle/countries_place' to './ylle/#sql2-6948-5c7' (errno: 152)")
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `countries_place`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `countries_country`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.OperationalError'> :
      ALTER TABLE `contacts_partner` DROP FOREIGN KEY `invoice_recipient_id_refs_id_6900f480`;
      (1025, "Error on rename of './ylle/contacts_partner' to './ylle/#sql2-6948-5c7' (errno: 152)")
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `contacts_partner`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `accounts_account`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `accounts_group`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `accounts_chart`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `ledger_voucher`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `ledger_journal`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `vat_paymentterm`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    <class 'django.db.utils.IntegrityError'> :
      DROP TABLE `declarations_declaration`;
      (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
    INFO Done manage.py initdb_demo --traceback --noinput (PID 22830)




>>> import os
>>> os.environ['DJANGO_SETTINGS_MODULE'] = 'lino.projects.min2.settings.demo'
>>> from django.core.management.sql import sql_delete, sql_flush
>>> from django.core.management.color import no_style
>>> from django.db import connections, transaction, DEFAULT_DB_ALIAS
>>> conn = connections[DEFAULT_DB_ALIAS]
>>> sql_delete('contacts', no_style(), conn)
[]
>>> sql_flush(no_style(), conn, only_django=False)  # doctest: +ELLIPSIS
[u'DELETE FROM "addresses_address";', ... u'DELETE FROM "users_user";']