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.1.tar.gz
(4.7 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pandasio-0.0.5.1.tar.gz.
File metadata
- Download URL: pandasio-0.0.5.1.tar.gz
- Upload date:
- Size: 4.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.12.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
0fd4d0f4576284ada02f50c25023c60a580312c9f35c8c7ced183699cbaa8d65
|
|
| MD5 |
6adcf8bcf51cbb965bbae9d6c220c186
|
|
| BLAKE2b-256 |
7c7d18ee0c509b5e232cdaeee46ca7f1944736f603b57819e31dbcc453d4d61e
|
File details
Details for the file pandasio-0.0.5.1-py3-none-any.whl.
File metadata
- Download URL: pandasio-0.0.5.1-py3-none-any.whl
- Upload date:
- Size: 5.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.12.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2817f1f0aa691c495b32d8c2b8bbf2c5fde5927b6abdd73313f668e34fb53ec2
|
|
| MD5 |
25839210d0224c47fb92b49f069b87ff
|
|
| BLAKE2b-256 |
c15fb23afbb42830c8b8ecfa3c614310805285e54fbe9f50c92aafabc21d5a41
|
