call function in etl.convert is not working

[BouchaaraAdil]

Minimal, reproducible code sample, a copy-pastable example if possible

            temp_table1 = etl.convert(temp_table, 'startTimeTS', lambda v, row: self.calc_starttime(row.created_at, row.startTime), pass_row=True)

Problem description

I'm working on data migration from MySQL to Postgres and wanted to convert NULL fields for rows I coded a separated function that I need to call in etl.convert,

• calc_starttime is not taking effect at all the, although that it's called but when i verify the data using et.head(..) still column is null

Version and installation information

• Value of petl==1.3.0
• Version of Python interpreter Python 3.7.4
• Operating system (Linux/Windows/Mac) linux
• How petl was installed (e.g., "using pip into virtual environment", or "using conda"): in django project(Pipfile)

[alimanfoo]

Hi @BouchaaraAdil, you could try:

temp_table1 = etl.convert(temp_table, 'startTimeTS', lambda v, row: self.calc_starttime(row.created_at, row.startTime), pass_row=True, failonerror=True)

This will cause petl to propagate an except if one is raised by the conversion function.

[alimanfoo]

The failonerror argument can be False (default), True (raise any exception immediately) or "inline" (use exceptions as values in the table). If you want to set the behaviour globally, you can do:

petl.config.failonerror = True

[juarezr]

Reopening: not related to #484