Push Big XL sheet in MySQL database table
Project description
___ ___ _______ _______ ___ _______ __ __
| Y .--.--| _ | _ | | | _ | |--.-----.-----| |_
|. | | | 1___|. | |. | | 1___| | -__| -__| _|
|. \_/ |___ |____ |. | |. |___ |____ |__|__|_____|_____|____|
|: | |_____|: 1 |: 1 |: 1 ||: 1 |
|::.|:. | |::.. . |::.. |::.. . ||::.. . |
`--- ---' `-------`----|:.`-------'`-------'
`--'
[!] MySQL Sheet.
usage: mysqlsheet.py [-h] -f FILE [-b BUFFER] [-u USER] [-p PASSWORD] [--host HOST] [--port PORT] -d DATABASE -t TABLE [-m MAX]
dump big xlsheet in mysql table
optional arguments:
-h, --help show this help message and exit
-f FILE, --file FILE big xlsheet file path
-b BUFFER, --buffer BUFFER
file buffuer in bytes default buffer size is 4096
-u USER, --user USER mysql username default user is root
-p PASSWORD, --password PASSWORD
mysql password default is empty
--host HOST mysql hostname default is localhost
--port PORT database port number default is 3306
-d DATABASE, --database DATABASE
mysql database name
-t TABLE, --table TABLE
mysql table name
-m MAX, --max MAX max record push concurrently in msyql
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mysqlsheet-1.1.0.tar.gz
(4.1 kB
view details)
Built Distribution
File details
Details for the file mysqlsheet-1.1.0.tar.gz
.
File metadata
- Download URL: mysqlsheet-1.1.0.tar.gz
- Upload date:
- Size: 4.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/52.0.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.9.1
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 690af5a96d9855d185aef27ccfd51a9a8713cd60eeff853a6edd7f0640e36bdc |
|
MD5 | 1199510eef2e3763768ec0498c0858f5 |
|
BLAKE2b-256 | 75205a6225e069ba9d29b7f9d4d5dec1264c9a1a69792ecfa882d218627ff0ea |
File details
Details for the file mysqlsheet-1.1.0-py3-none-any.whl
.
File metadata
- Download URL: mysqlsheet-1.1.0-py3-none-any.whl
- Upload date:
- Size: 15.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/52.0.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.9.1
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 40d6996b7b61df2be87a2cfd136d05c2776c41f18021036e5ed5487463c77df1 |
|
MD5 | 6cd0ecca37c097c2114ed199e8342f3f |
|
BLAKE2b-256 | ad9e843e72aaf5ba1e30afe08b41b7fcfdeab54bf015b7e2c8580cb3f4cab059 |