Saturday, March 28, 2015

Continued to try to get 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)  
[u'DELETE FROM "addresses_address";', ... u'DELETE FROM "users_user";']