将联接与 CSV writerow 相结合的 Pythonic 方式

Question

我有两个 CSV 行，我只想迭代一次。请注意，它们结合了两个模型:库存和 Material 。如何将两个表合并为一个 csv 导出？

表:

[outcsv.writerow([getattr(curr, column.name) for column in Inventory.__mapper__.columns]) for curr in records]

加入:

[outcsv.writerow([getattr(curr.material, column.name) for column in Material.__mapper__.columns]) for curr in records]

Answer 1

哦，这很简单。

[outcsv.writerow([getattr(curr, column.name) for column in Inventory.__mapper__.columns] + [getattr(curr.material, column.name) for column in Material.__mapper__.columns]) for curr in records]