-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathcreate.py
More file actions
49 lines (48 loc) · 1.62 KB
/
create.py
File metadata and controls
49 lines (48 loc) · 1.62 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
#!/bin/env python
# _*_coding:utf-8_*_
'''
Created on Dec 30, 2015
@author: Derek
'''
import pymysql
import json
import sys
def databases():
conn = pymysql.Connect(host='192.168.0.59', user='root', passwd='vrvim', charset="utf8",cursorclass=pymysql.cursors.DictCursor)
cur = conn.cursor()
Recoue = cur.execute("SHOW DATABASES;")
data = cur.fetchall()
for i in data:
yield i
cur.close()
conn.close()
def tables():
for i in databases():
conn = pymysql.Connect(host='192.168.0.59', user='root', passwd='vrvim', db=i["Database"], charset="utf8",cursorclass=pymysql.cursors.DictCursor)
cur = conn.cursor()
Recoue = cur.execute("show tables;")
data = cur.fetchall()
for j in data:
yield {i["Database"]:j.values()[0]}
cur.close()
conn.close()
def values():
for i in tables():
conn = pymysql.Connect(host='192.168.0.59', user='root', passwd='vrvim', db=i.keys()[0], charset="utf8",cursorclass=pymysql.cursors.DictCursor)
cur = conn.cursor()
Recoue = cur.execute("SHOW FULL COLUMNS FROM " + i.values()[0] + ";")
data = cur.fetchall()
list = []
dict={}
all={}
for h in data:
del h["Privileges"]
del h["Key"]
list.append(h)
dict={i.keys()[0]:{i.values()[0]:list}}
if dict.keys()[0] != "performance_schema" and dict.keys()[0] != "mysql" and dict.keys()[0] != "information_schema":
yield json.dumps(dict,encoding="UTF-8",ensure_ascii=False)
cur.close()
conn.close()
for i in values():
print i