io¶
Database data/Local File I/O module.
- sqlalchemy_mate.io.sql_to_csv(stmt, engine: sqlalchemy.engine.base.Engine, filepath: str, chunksize: int = 1000, overwrite: bool = False)[source]¶
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, engine, filepath, chunksize=1000, overwrite=False)[source]¶
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文件。