Python脚本对数据库操作

最新推荐文章于 2025-04-09 08:43:39 发布

tidewang2k

最新推荐文章于 2025-04-09 08:43:39 发布

阅读量213

点赞数

CC 4.0 BY-SA版权

分类专栏： python 文章标签： automation test python tool

本文链接：https://blog.youkuaiyun.com/tidewang2k/article/details/42491303

python 专栏收录该内容

22 篇文章

订阅专栏

本文介绍了一个脚本用于数据库配置更新、服务启用、账户信息添加和系统设置修改，适用于自动化数据库管理和服务配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import MySQLdb

ACCS1 = [87, 88, 89, 90, 91, 92, 93]
ACCS2 = [95, 96]

class SetDBConfigs(object):

def update_cfg(self, sql):
try:
conn = MySQLdb.connect(host='cfg', user='webserv', db='blackspider', port=3306)
cur = conn.cursor()
print sql
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
except MySQLdb.Error, e:
print e
pass

def enable_mdmi_hosted(self, flag='wdAV,wdCategories,mobile,MDMi-AW', ACCS=ACCS1):
try:
for acc in ACCS:
sql = "update Accounts set EnabledServices='%s' where ID=%s" %(flag, acc)
self.update_cfg(sql)
except Exception, e:
print(e.message)

def enable_mdmi_hybrid(self, flag='hyPE,hyAV,MDMi-AW', ACCS=ACCS2):
try:
for acc in ACCS:
sql = "update Accounts set EnabledServices='%s' where ID=%s" %(flag, acc)
self.update_cfg(sql)
except Exception, e:
print(e.message)

def add_aw_info(self, host='partnerbetaenroll.awmdm.com', key='1YXLJEBAAAG6A7NAAEQA', user='qaadmin', pwd='Wsws1234'):
try:
for acc in ACCS1:
sql = 'delete from MDMAccountDetails where AccountID=%s' % acc
self.update_cfg(sql)
sql = "insert into MDMAccountDetails VALUES (NULL, %s, '%s', '%s', '%s', '%s')" %(acc, host, key, user, pwd)
self.update_cfg(sql)

for acc in ACCS2:
sql = 'delete from MDMAccountDetails where AccountID=%s' % acc
self.update_cfg(sql)
sql = "insert into MDMAccountDetails VALUES (NULL, %s, '%s', '%s', '%s', '%s')" %(acc, host, key, user, pwd)
self.update_cfg(sql)

except Exception, e:
print(e.message)

def enable_usergroup_sync(self, value='yes', identifier='EnableSync'):
try:
sql = "update SystemSettings set Value='%s' where Identifier='%s'" %(value, identifier)
self.update_cfg(sql)
except Exception, e:
print(e.message)

def enable_deltabus_flag(self, value='yes', identifier='MDMiLocalNetworkAccessChangeEnabled'):
try:
sql = "delete from SystemSettings where Identifier='%s'" % identifier
self.update_cfg(sql)
sql = "insert into SystemSettings(Identifier, Value) values('%s', '%s')" %(identifier, value)
self.update_cfg(sql)
except Exception, e:
print(e.message)

if __name__ == '__main__':
sdbc = SetDBConfigs()
sdbc.enable_usergroup_sync()
sdbc.enable_deltabus_flag()
sdbc.enable_deltabus_flag(identifier='MDMiEmailAddressChangeEnabled')
sdbc.enable_mdmi_hosted()
sdbc.enable_mdmi_hybrid()
sdbc.add_aw_info()