脚本之家,脚本语言编程技术及教程分享平台!
分类导航

Python|VBS|Ruby|Lua|perl|VBA|Golang|PowerShell|Erlang|autoit|Dos|bat|

服务器之家 - 脚本之家 - Python - Python如何实现MySQL实例初始化详解

Python如何实现MySQL实例初始化详解

2020-12-16 00:18黄杉 Python

这篇文章主要给大家介绍了关于Python如何实现MySQL实例初始化的相关资料,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧。

前言

相信每位程序员对mysql应该都不陌生,MySQL是一个关系型数据库管理系统,由瑞典MySQL AB 公司开发,目前属于 Oracle 旗下产品。我们在日常开发中少不了要接触mysql。

腾讯云上的mysql实例初始化的时候,需要自己点击“初始化按钮”,然后还要手动输入16位复杂的密码,这个操作比较繁琐,而且如果你一次建立多个实例,这个操作量就很大了,所以必须想办法提高效率,于是就有了下文,批量调用sdk api来实现。

本文主要给大家介绍了关于Python实现MySQL实例初始化的相关内容,分享出来供大家参考学习,下面话不多说了,来一起看看详细的介绍吧。

示例代码

代码准备:initstance.py

?
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
#!/usr/bin/python
from src.QcloudApi.qcloudapi import QcloudApi
from time import ctime,sleep
from getpwd import get_password
 
def initinstance(cdbid,no):
module = 'cdb'
action = 'CdbMysqlInit'
config = {
 'Region': 'ap-shanghai',
 'secretId': 'AKIDTsEEl8ZK9mHcotf4OYk2A7uYxxxxxxxx',
 'secretKey': 'IOI0Zw87vYDvhR6a5QZXouomxxxxxxxx',
 'method': 'get'
}
 
pwd=get_password(16)
params = {
 'cdbInstanceId': cdbid,
 'charset': 'utf8mb4',
 'port': 3306,
 'lowerCaseTableNames': 1,
 'password': pwd
}
 
print params
try:
 service = QcloudApi(module, config)
 print service.generateUrl(action, params)
 print service.call(action, params)
except Exception, e:
 print 'exception:', e
 
def main():
# 这里添加 N多实例id,可以批量进行初始化,不用再界面点击操作了。
cdbids_hermes=["cdb-1hz14ogho","cdb-1417ds7su"]
for index,value in enumerate(cdbids_hermes):
 initinstance(value,str((index+1)).zfill(2))
 sleep(1)
 
if __name__ == '__main__':
main()

初始化实例脚本initstance.py,准备执行代码:

调试报错,需要安装qcloudapi-sdk-python-master.zip

?
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
50
51
52
53
54
[hy@orcl ] /data0/dbj1st$ python initstance.py
Traceback (most recent call last):
File "initstance.py", line 2, in <module>
from src.QcloudApi.qcloudapi import QcloudApi
ImportError: No module named src.QcloudApi.qcloudapi
[hy@orcl ] /data0/dbj1st$
 
[hy@orcl ] /data0/dbj1st/promotion$ unzip qcloudapi-sdk-python-master.zip
Archive: qcloudapi-sdk-python-master.zip
e6cb9ff252cdb125e516525a2bb62d3410723adf
creating: qcloudapi-sdk-python-master/
extracting: qcloudapi-sdk-python-master/.gitignore
inflating: qcloudapi-sdk-python-master/README.md
inflating: qcloudapi-sdk-python-master/demo.py
creating: qcloudapi-sdk-python-master/src/
creating: qcloudapi-sdk-python-master/src/QcloudApi/
extracting: qcloudapi-sdk-python-master/src/QcloudApi/__init__.py
creating: qcloudapi-sdk-python-master/src/QcloudApi/common/
extracting: qcloudapi-sdk-python-master/src/QcloudApi/common/__init__.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/common/request.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/common/sign.py
creating: qcloudapi-sdk-python-master/src/QcloudApi/modules/
extracting: qcloudapi-sdk-python-master/src/QcloudApi/modules/__init__.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/account.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/base.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/bill.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/bm.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cbs.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cdb.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cdn.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cmem.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cvm.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/dfw.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/eip.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/image.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/lb.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/live.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/market.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/monitor.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/redis.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/scaling.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/sec.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/snapshot.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/tdsql.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/trade.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/vod.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/vpc.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/wenzhi.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/yunsou.py
inflating: qcloudapi-sdk-python-master/src/QcloudApi/qcloudapi.py
extracting: qcloudapi-sdk-python-master/src/__init__.py
[hy@orcl ] /data0/dbj1st/promotion$ ll
[hy@orcl ] /data0/dbj1st/promotion$ cp -r qcloudapi-sdk-python-master/src .
[hy@orcl ] /data0/dbj1st/promotion$

需要安装cassdk

?
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
[hy@orcl ] /data0/dbj1st/promotion$ python initstance.py
6
exception: No module named requests
[hy@orcl ] /data0/dbj1st/promotion$
[hy@orcl ] /data0/dbj1st/promotion$
[hy@orcl ] /data0/dbj1st/promotion$ sudo su
[root@dbj4st] /data0/dbj1st/promotion$ pip install cassdk
Collecting cassdk
Downloading cassdk-1.0.2.tar.gz
Building wheels for collected packages: cassdk
Running setup.py bdist_wheel for cassdk ... error
Complete output from command /bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-1_XMv6/cassdk/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpzGF2_Dpip-wheel- --python-tag cp27:
usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
 or: -c --help [cmd1 cmd2 ...]
 or: -c --help-commands
 or: -c cmd --help
 
error: invalid command 'bdist_wheel'
 
----------------------------------------
Failed building wheel for cassdk
Running setup.py clean for cassdk
Failed to build cassdk
Installing collected packages: cassdk
Running setup.py install for cassdk ... done
Successfully installed cassdk-1.0.2
[root@dbj4st] /data0/dbj1st/promotion$

需要安装requests

?
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
[hy@orcl ] /data0/dbj1st/promotion$ python initstance.py
6
exception: No module named requests
[hy@orcl ] /data0/dbj1st/promotion$ sudo su
[root@dbj4st] /data0/dbj1st/promotion$ sudo pip install --upgrade urllib3
Collecting urllib3
Downloading urllib3-1.22-py2.py3-none-any.whl (132kB)
100% |████████████████████████████████| 133kB 186kB/s
Installing collected packages: urllib3
Successfully installed urllib3-1.22
[root@dbj4st] /data0/dbj1st/promotion$
 
[hy@orcl ] /data0/dbj1st/promotion$ sudo su
[root@dbj4st] /data0/dbj1st/promotion$ sudo pip install --upgrade requests
Collecting requests
Downloading requests-2.18.4-py2.py3-none-any.whl (88kB)
100% |████████████████████████████████| 92kB 9.9kB/s
Collecting certifi>=2017.4.17 (from requests)
Downloading certifi-2017.7.27.1-py2.py3-none-any.whl (349kB)
100% |████████████████████████████████| 358kB 36kB/s
Collecting chardet<3.1.0,>=3.0.2 (from requests)
Downloading chardet-3.0.4-py2.py3-none-any.whl (133kB)
100% |████████████████████████████████| 143kB 18kB/s
Collecting idna<2.7,>=2.5 (from requests)
Downloading idna-2.6-py2.py3-none-any.whl (56kB)
100% |████████████████████████████████| 61kB 16kB/s
Requirement already up-to-date: urllib3<1.23,>=1.21.1 in /usr/lib/python2.7/site-packages (from requests)
Installing collected packages: certifi, chardet, idna, requests
Found existing installation: chardet 2.2.1
Uninstalling chardet-2.2.1:
 Successfully uninstalled chardet-2.2.1
Successfully installed certifi-2017.7.27.1 chardet-3.0.4 idna-2.6 requests-2.18.4
[root@dbj4st] /data0/dbj1st/promotion$

需要安装DependencyWarning

?
1
2
3
4
[laobanzhang@dbj1st] ~/dbj1st/promotion$ python initstance.py
6
exception: cannot import name DependencyWarning
[laobanzhang@dbj1st] ~/dbj1st/promotion$

OK,执行成功:

?
1
2
3
4
5
[hy@orcl ] /data0/dbj1st/promotion$ python initstance.py
6
7
{"code":0,"message":"","codeDesc":"Success","jobId":51783}
[hy@orcl ] /data0/dbj1st/promotion$

总结

以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作具有一定的参考学习价值,如果有疑问大家可以留言交流,谢谢大家对服务器之家的支持。

原文链接:http://blog.csdn.net/mchdba/article/details/78453115

延伸 · 阅读

精彩推荐