io

Database data/Local File I/O module.

sqlalchemy_mate.io.sql_to_csv(stmt, engine: Engine, filepath: str, chunksize: int = 1000, overwrite: bool = False)

Export sql stmt result to csv file.

Parameters:

• stmt – sqlalchemy.sql.selectable.Select instance.

• engine – sqlalchemy.engine.base.Engine.

• filepath – file path.

• chunksize – number of rows write to csv each time.

• overwrite – bool, if True, avoid to overite existing file.

中文文档

将执行sql的结果中的所有数据, 以生成器的方式(一次只使用一小部分内存), 将 整个结果写入csv文件。

sqlalchemy_mate.io.table_to_csv(table: Table, engine: Engine, filepath, chunksize: int = 1000, overwrite: bool = False)

Export entire table to a csv file.

Parameters:

• table – sqlalchemy.Table instance.

• engine – sqlalchemy.engine.base.Engine.

• filepath – file path.

• chunksize – number of rows write to csv each time.

• overwrite – bool, if True, avoid to overite existing file.

中文文档

将整个表中的所有数据, 写入csv文件。