Pandas to_sql/read_sql_query with primary/foreign key support
Project description
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)
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pandasio-0.0.5.2.tar.gz
(4.7 kB
view details)
File details
Details for the file pandasio-0.0.5.2.tar.gz.
File metadata
- Download URL: pandasio-0.0.5.2.tar.gz
- Upload date:
- Size: 4.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.14.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
de0dee34ce23fda28047f556d911139f3df2381c5f79c75d514eb52d5f0f0ca6
|
|
| MD5 |
4b4b90a8580dd3d8215289dd2762a1b3
|
|
| BLAKE2b-256 |
3151fc8c1ea415738df21a043ea3e65b8f0507fd9096a52ca1154fb14081664d
|
