Could the issue be that the IDs for the trial records in the target DB are
different than those in the source DB (I know some are, because in the
target they are sequential but in the source they are not)?
If this is the issue, what would be the preferred way to consolidate the
IDs in the source DB (which would presumably address the problem)?
- Scott
Note: I am not using the cpdb.py script to do this because it was never
able to find DAL, even when I gave it a full path to the gluon directory
On Wednesday, March 8, 2017 at 4:52:58 AM UTC-5, Scott Hunter wrote:
>
> When I try to load a MySQL DB on pythonanywhere from a CSV generated from
> a SQLite DB using (literally) the same schema, I get the following:
>
> >>> db.import_from_csv_file(open("trials_export.csv","rb"))
>
> Traceback (most recent call last): File
> "<console>", line 1, in <module> File
> "/home/ukitms/web2py/gluon/packages/dal/pydal/base.py", line 1116, in
> import_from_csv_file *args, **kwargs) File
> "/home/ukitms/web2py/gluon/packages/dal/pydal/objects.py", line 978, in
> import_from_csv_file new_id = self.insert(**dict(items)) File
> "/home/ukitms/web2py/gluon/packages/dal/pydal/objects.py", line 726, in
> insert ret = self._db._adapter.insert(self, self._listify(fields))
> File "/home/ukitms/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 746, in insert raise eIntegrityError: (1452, 'Cannot add or
> update a child row: a foreign key constraint fails
> (`ukitms$trials`.`t_classlevel`, CONSTRAINT `t_classlevel_ibfk_1` FOREIGN
> KEY (`f_Trial`) REFERENCES `t_trial` (`id`) ON DELETE CASCADE)')>>>
>
> The relevant part of the schema is:
>
> db.define_table( 't_classlevel',
> Field( 'f_Trial', 'reference t_trial' ),
>
>
>
> Table `t_trial` does appear in the CSV before `t_classlevel`; I checked
> that the `f_Trial` field in every record has a corresponding `t_trial`
> record.
>
> Is there some way to identify what line of the CSV is causing this? How
> could this constraint be violated if the values all correspond to valid
> records?
>
> - Scott
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
