[sequel pro] python3格式化sql

基于python3的command

 

#!/usr/bin/python3
#coding=utf-8

import urllib.request
import urllib.parse,ssl
import json
import sys

sql = sys.stdin.read()
context = ssl._create_unverified_context()
params = {'sql': sql, 'reindent': 1, 'keyword_case': 'upper', 'identifier_case': 'lower'}
response = urllib.request.urlopen('https://sqlformat.org/api/v1/format', data=urllib.parse.urlencode(params).encode('utf-8'),context=context)
data = json.loads(response.read())
print(data['result'])