Metadata-Version: 2.4
Name: pandasio
Version: 0.0.5.1
Summary: Pandas to_sql/read_sql_query with primary/foreign key support
Author-email: Egil Moeller <em@emeraldgeo.no>
License-Expression: MIT
Project-URL: Homepage, https://github.com/EMeraldGeo/PandasIO
Project-URL: Repository, https://github.com/EMeraldGeo/PandasIO
Requires-Python: >=3.11
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas>=1.1
Requires-Dist: sqlalchemy
Dynamic: license-file

# PandasIO

PandasIO reimplements pandas.DataFrame.to_sql and
pandas.read_sql_query with more control over the SQL side of things
such as adding support for primary and foreign keys as well
serializing extra columns to JSON.

```
pandasio.get_new_ids(table, col, con, count=1)
pandasio.to_sql(df, name, con, keycols=[], references={}, chunksize=4096, method="multi", basecols=None, **kw)
pandasio.read_sql_query(sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, chunksize = None)
```
