国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > Python > 正文

Python如何實現MySQL實例初始化詳解

2020-01-04 16:28:25
字體:
來源:轉載
供稿:網友

前言

相信每位程序員對mysql應該都不陌生,MySQL是一個關系型數據庫管理系統,由瑞典MySQL AB 公司開發,目前屬于 Oracle 旗下產品。我們在日常開發中少不了要接觸mysql。

騰訊云上的mysql實例,初始化的時候,需要自己點擊“初始化按鈕”,然后還要手動輸入16位復雜的密碼,這個操作比較繁瑣,而且如果你一次建立多個實例,這個操作量就很大了,所以必須想辦法提高效率,于是就有了下文,批量調用sdk api來實現。

本文主要給大家介紹了關于Python實現MySQL實例初始化的相關內容,分享出來供大家參考學習,下面話不多說了,來一起看看詳細的介紹吧。

示例代碼

代碼準備:initstance.py

 #!/usr/bin/python/284370.html">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

 [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

 [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

 [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

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

OK,執行成功:

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

總結

以上就是這篇文章的全部內容了,希望本文的內容對大家的學習或者工作具有一定的參考學習價值,如果有疑問大家可以留言交流,謝謝大家對VEVB武林網的支持。


注:相關教程知識閱讀請移步到python教程頻道。
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 金昌市| 朝阳区| 清新县| 通海县| 区。| 浑源县| 涪陵区| 廊坊市| 岑溪市| 特克斯县| 镇赉县| 安平县| 永嘉县| 瓦房店市| 曲阜市| 德清县| 湘阴县| 和平县| 东阳市| 小金县| 乾安县| 郑州市| 青州市| 津市市| 曲沃县| 万全县| 社旗县| 乳源| 高碑店市| 普定县| 桦甸市| 龙江县| 读书| 龙陵县| 福清市| 饶平县| 武定县| 班玛县| 介休市| 清徐县| 伊宁县|