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 hashes)
Built Distribution
mysqlsheet-1.1.0-py3-none-any.whl
(15.7 kB
view hashes)
Close
Hashes for mysqlsheet-1.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 40d6996b7b61df2be87a2cfd136d05c2776c41f18021036e5ed5487463c77df1 |
|
MD5 | 6cd0ecca37c097c2114ed199e8342f3f |
|
BLAKE2b-256 | ad9e843e72aaf5ba1e30afe08b41b7fcfdeab54bf015b7e2c8580cb3f4cab059 |