Skip to content

Commit a49ffe0

Browse files
author
root
committed
remodified
1 parent 75091da commit a49ffe0

30 files changed

Lines changed: 47502 additions & 47 deletions

‎cdn/cdn_createCdn.py‎

Lines changed: 3 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -25,16 +25,14 @@ def get_sig_request(params, secretkey, baseurl):
2525
secretkey = user_config.secretkey
2626

2727

28-
# download/streaming
2928
# ip address / storage container name
3029
# direct / storage
31-
# jpn / central
3230

3331
name='mystreaming'
34-
servicetype='streaming'
32+
servicetype='streaming' # download/streaming
3533
addr='container1'
36-
origintype='storage'
37-
zonenm='central'
34+
origintype='storage' # ip address / storage container name, storage cantainer must be opened to public
35+
zonenm='central' # jpn / central
3836

3937
if apikey != "":
4038
request={}

‎cdn/cdn_deleteCdn.py‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -30,7 +30,7 @@ def get_sig_request(params, secretkey, baseurl):
3030
# direct / storage
3131
# jpn / central
3232

33-
cdnid='ws4110'
33+
cdnid=''
3434

3535
if apikey != "":
3636
request={}

‎cdn/cdn_statusCdnService.py‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -24,6 +24,7 @@ def get_sig_request(params, secretkey, baseurl):
2424
apikey = user_config.apikey
2525
secretkey = user_config.secretkey
2626

27+
2728
if apikey != "":
2829
request={}
2930
request['command']='statusCdnService'

‎cdn/cdn_stopCdn.py‎

Lines changed: 1 addition & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -25,12 +25,7 @@ def get_sig_request(params, secretkey, baseurl):
2525
secretkey = user_config.secretkey
2626

2727

28-
# download/streaming
29-
# ip address / storage container name
30-
# direct / storage
31-
# jpn / central
32-
33-
cdnid='ws4110'
28+
cdnid=''
3429

3530
if apikey != "":
3631
request={}

‎config/url_config.py‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,3 +9,4 @@
99
db_url='https://api.ucloudbiz.olleh.com/db/v1/client/api?'
1010
cdn_url='https://api.ucloudbiz.olleh.com/cdn/v1/client/api?'
1111
storage_url='https://api.ucloudbiz.olleh.com/storage/v1/auth'
12+
fabric_url="https://uclouddb.ucloudbiz.olleh.com:443/fabric/rest?grpcode="

‎db/db_connect_sample‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
mysql --host=1.1.1.1 --port=1111 --user=root --password
2+
mysql --host=1.1.1.1 --port=1111 --user=root --password < sakila-schema.sql
3+
mysql --host=1.1.1.1 --port=1111 --user=root --password < sakila-data.sql

‎db/db_createHaGroup.py‎

Lines changed: 52 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,52 @@
1+
#!/usr/bin/python
2+
3+
import sys
4+
sys.path.insert(0, "../config/")
5+
import urllib2
6+
import urllib
7+
import hashlib
8+
import hmac
9+
import base64
10+
import urlparse
11+
import linecache
12+
import url_config
13+
import user_config
14+
15+
def get_sig_request(params, secretkey, baseurl):
16+
request_str='&'.join(['='.join([k,urllib.quote_plus(params[k])]) for k in params.keys()])
17+
sig_str='&'.join(['='.join([k.lower(),urllib.quote_plus(params[k].lower().replace('+','%20'))])for k in sorted(params.iterkeys())])
18+
sig=urllib.quote_plus(base64.encodestring(hmac.new(secretkey,sig_str,hashlib.sha1).digest()).strip())
19+
return baseurl+request_str+'&signature='+sig
20+
21+
22+
baseurl = url_config.db_url
23+
apikey = user_config.apikey
24+
secretkey = user_config.secretkey
25+
26+
27+
instanceid='' # existing database instance id
28+
slavecount='1' # 0~2
29+
hamode='Y' # Y=auto, N=manual
30+
semisync='N' # when hamode=N and semisync=N, async mode is enabled
31+
hagroupname='edu_ucloudbiz_XX_hagroup!' # 12~30 character with !@#%^*, this is key for query.
32+
33+
34+
if apikey != "":
35+
request={}
36+
request['command']='createHaGroup'
37+
request['instanceid']=instanceid
38+
request['slavecount']=slavecount
39+
request['hamode']=hamode
40+
request['semisync']=semisync
41+
request['hagroupname']=hagroupname
42+
request['response']='xml'
43+
request['apikey']=apikey
44+
45+
req_url=get_sig_request(request, secretkey, baseurl)
46+
print "Request URL = %s\n" % req_url
47+
#res=urllib2.urlopen(final_req)
48+
#print res.read()
49+
#res.close()
50+
else:
51+
print ""
52+

‎db/db_createInstance.py‎

Lines changed: 69 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,69 @@
1+
#!/usr/bin/python
2+
3+
import sys
4+
sys.path.insert(0, "../config/")
5+
import urllib2
6+
import urllib
7+
import hashlib
8+
import hmac
9+
import base64
10+
import urlparse
11+
import linecache
12+
import url_config
13+
import user_config
14+
15+
def get_sig_request(params, secretkey, baseurl):
16+
request_str='&'.join(['='.join([k,urllib.quote_plus(params[k])]) for k in params.keys()])
17+
sig_str='&'.join(['='.join([k.lower(),urllib.quote_plus(params[k].lower().replace('+','%20'))])for k in sorted(params.iterkeys())])
18+
sig=urllib.quote_plus(base64.encodestring(hmac.new(secretkey,sig_str,hashlib.sha1).digest()).strip())
19+
return baseurl+request_str+'&signature='+sig
20+
21+
22+
baseurl = url_config.db_url
23+
apikey = user_config.apikey
24+
secretkey = user_config.secretkey
25+
26+
27+
import string
28+
import random
29+
def id_generator(size=6, chars=string.ascii_uppercase + string.digits):
30+
return ''.join(random.choice(chars) for _ in range(size))
31+
32+
instancename=id_generator()
33+
storagesize='50' # 10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300 (GB)
34+
perfclass='2x2' # 0.37X0.5, 1X1, 1X2, 2X2, 2X4, 4X4, 4X8, 8X8, 8X16, 8X32, 12X16, 12X32 (vCoreXGB)
35+
maintenanceweekday='sun' # sunday
36+
parametergroupid='21' # 21 = mysql5.6.24_default1_small, 22 = mysql5.6.25_default_medium, 23 = mysql5.6.24_default1_large
37+
dbmastername='root' # mysql admin account
38+
dbmasterpassword='admin12345' # mysql admin password
39+
dbname='sakila' # mysql database name
40+
dbengineversion='5.6.24' # mysql version
41+
usageplantype='hourly' # billing period = hourly, monthly
42+
zone='kr-2' # kr-0 (Seoul-M), kr-1 (Central-A), kr-2 (Central-B)
43+
44+
45+
if apikey != "":
46+
request={}
47+
request['command']='createInstance'
48+
request['instancename']=instancename
49+
request['perfclass']=perfclass
50+
request['storagesize']=storagesize
51+
request['maintenanceweekday']=maintenanceweekday
52+
request['parametergroupid']=parametergroupid
53+
request['dbmastername']=dbmastername
54+
request['dbmasterpassword']=dbmasterpassword
55+
request['dbname']=dbname
56+
request['dbengineversion']=dbengineversion
57+
request['usageplantype']=usageplantype
58+
request['zone']=zone
59+
request['response']='xml'
60+
request['apikey']=apikey
61+
62+
req_url=get_sig_request(request, secretkey, baseurl)
63+
print "Request URL = %s\n" % req_url
64+
#res=urllib2.urlopen(final_req)
65+
#print res.read()
66+
#res.close()
67+
else:
68+
print ""
69+

‎db/db_getDBInfo.py‎

Lines changed: 57 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,57 @@
1+
#!/usr/bin/python
2+
3+
import sys
4+
sys.path.insert(0, "../config/")
5+
import urllib2
6+
import urllib
7+
import hashlib
8+
import hmac
9+
import base64
10+
import urlparse
11+
import linecache
12+
import url_config
13+
import ast
14+
15+
def get_sig_request(params, secretkey, baseurl):
16+
request_str='&'.join(['='.join([k,urllib.quote_plus(params[k])]) for k in params.keys()])
17+
sig_str='&'.join(['='.join([k.lower(),urllib.quote_plus(params[k].lower().replace('+','%20'))])for k in sorted(params.iterkeys())])
18+
sig=urllib.quote_plus(base64.encodestring(hmac.new(secretkey,sig_str,hashlib.sha1).digest()).strip())
19+
return baseurl+request_str+'&signature='+sig
20+
21+
22+
fabricurl=url_config.fabric_url
23+
24+
hagroupname='edu_ucloudbiz_XX_hagroup!'
25+
sec='1' # sec : 1 (public), 0 (private)
26+
mode='3' # mode : 2 (Read), 3 (Read/Write)
27+
28+
finalurl = fabricurl + hagroupname + "&sec=" + sec + "&mode=" + mode
29+
res=urllib2.urlopen(finalurl)
30+
codes = res.read().replace('\u0000','').replace('null','').replace('(', '').replace(')', '')
31+
result=ast.literal_eval(codes)
32+
lst=result['code'].split(':')
33+
res.close()
34+
35+
import MySQLdb as mdb
36+
import sys
37+
38+
hostip=lst[0]
39+
portno=int(lst[1])
40+
username='root'
41+
password='admin12345'
42+
database='sakila'
43+
sql="select title, release_year from film limit 5"
44+
45+
print
46+
print "Host IP = %s" % hostip
47+
print "Host Port = %s" % portno
48+
print
49+
50+
con = mdb.connect(host=hostip, port=portno, user=username, passwd=password, db=database);
51+
cur = con.cursor()
52+
cur.execute(sql)
53+
rows = cur.fetchall()
54+
for row in rows:
55+
print row
56+
con.close()
57+
print

‎db/db_listHaGroups.py‎

Lines changed: 40 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,40 @@
1+
#!/usr/bin/python
2+
3+
import sys
4+
sys.path.insert(0, "../config/")
5+
import urllib2
6+
import urllib
7+
import hashlib
8+
import hmac
9+
import base64
10+
import urlparse
11+
import linecache
12+
import url_config
13+
import user_config
14+
15+
def get_sig_request(params, secretkey, baseurl):
16+
request_str='&'.join(['='.join([k,urllib.quote_plus(params[k])]) for k in params.keys()])
17+
sig_str='&'.join(['='.join([k.lower(),urllib.quote_plus(params[k].lower().replace('+','%20'))])for k in sorted(params.iterkeys())])
18+
sig=urllib.quote_plus(base64.encodestring(hmac.new(secretkey,sig_str,hashlib.sha1).digest()).strip())
19+
return baseurl+request_str+'&signature='+sig
20+
21+
22+
baseurl = url_config.db_url
23+
apikey = user_config.apikey
24+
secretkey = user_config.secretkey
25+
26+
27+
if apikey != "":
28+
request={}
29+
request['command']='listHaGroups'
30+
request['response']='xml'
31+
request['apikey']=apikey
32+
33+
req_url=get_sig_request(request, secretkey, baseurl)
34+
print "Request URL = %s\n" % req_url
35+
#res=urllib2.urlopen(final_req)
36+
#print res.read()
37+
#res.close()
38+
else:
39+
print ""
40+

0 commit comments

Comments
 (0)