latavin243/db_connection_info.org

Last active June 6, 2024 07:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/latavin243/5524a5c53252db3ba0a8fe1ffd83f35d.js"></script>
Save latavin243/5524a5c53252db3ba0a8fe1ffd83f35d to your computer and use it in GitHub Desktop.

org-mode DB connection table to mycli commands / JDBC url

Raw

Desc	Host	Port	User	Pwd	DB
test	test_host	3306	test_user	test_pwd	test_db
prod	prod_host	3306	marketplace_uat	prod_pwd	test_db

for row in tab:
    desc, host, port, user, pwd, db = tuple(row)
    print(f'[{desc}]')
    print(f'mycli -h {host} -P {port} -u {user} -p {pwd} -D {db} # mysql')
    print(f'jdbc:mysql://{host}:{port}/{db}?autoReconnect=true&timeout=60s&collation=utf8mb4_unicode_ci&readTimeout=60s&writeTimeout=60s&timeout=60s')