Skip to content

Instantly share code, notes, and snippets.

@greatwhole
greatwhole / convert_to_cmd.py
Last active July 18, 2018 06:11
convert connection string to cmd
from sqlalchemy.engine.url import make_url
def convert_to_cmd(connection_string):
url = make_url(connection_string)
pattern = 'mysql -u {username} -h {host} -P {port} -D {database} -p{password}'
cmd = pattern.format(username=url.username, host=url.host, port=url.port, database=url.database, password=url.password)
return cmd
@greatwhole
greatwhole / download_file.py
Last active December 5, 2018 12:01
requests_download
import os
import requests
RAISE = 1
DO_NOTHING = 2
RE_DOWNLOAD = 3
def download(url, path, action_on_exist=RAISE):
if os.path.exists(path):