SoFunction
Updated on 2024-11-13

Django wraps interactive interface code

I'll cut to the chase, so let's get right to the code~

# !/usr/bin/env python 
# -*- coding:utf-8 -*-
__author__ = '_X.xx_'
__date__ = '2018/7/18 16:44'
 
from  import JsonResponse
 
class HttpCode(object):
 ok = 200
 paramserror = 400
 unantu = 401
 methoderror = 405
 servererror = 500
 
def ok():
 return result()
 
def result(code=, message='', data=None, kwargs=None):
 json_dict = {'code': code, 'message': message, 'data': data}
 if kwargs and isinstance(kwargs, dict) and ():
  json_dict.update(kwargs)
 return JsonResponse(json_dict)
 
def params_error(message='', data=None):
 return result(code=, message=message, data=data)
 
def unauth(message='', data=None):
 return result(code=, message=message, data=data)
 
def method_error(message='', data=None):
 return result(code=, message=message, data=data)
 
def server_error(message='', data=None):
 return result(code=, message=message, data=data)

Additional knowledge:python deployment of galery clusters

Contents of the document

import pexpect
import os
import configparser

HOSTNAME_DB1='db1'
HOSTNAME_DB2='db2'
HOSTNAME_DB3='db3'
DB1 = '192.168.254.24'
DB2 = '192.168.254.27'
DB3 = '192.168.254.36'
PORT = 22
USERNAME = 'root'
PASSWORD = 'root'

server3_cnf = 'sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc//;sed -i "s/wsrep_node_address = %s/wsrep_node_address = %s/g" /etc//' % (DB1,DB3)
server2_cnf = 'sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc//;sed -i "s/wsrep_node_address = %s/wsrep_node_address = %s/g" /etc//' % (DB1,DB3)
def config_parse():
 config = ()
 ("/etc//", encoding="utf-8")
 ('galera','wsrep_on','ON')
 ('galera','wsrep_provider','/usr/lib64/galera/libgalera_smm.so')
 ('galera','wsrep_cluster_address','"gcomm://%s,%s,%s"' % (DB1, DB2, DB3))
 ('galera','wsrep_node_name','%s' % HOSTNAME_DB1 )
 ('galera','wsrep_node_address','%s' % DB1)
 ('galera','binlog_format','row')
 ('galera','default_storage_engine','InnoDB')
 ('galera','innodb_autoinc_lock_mode','2')
 ('galera','wsrep_slave_threads','1')
 ('galera','innodb_flush_log_at_trx_commit','1')
 ('galera','innodb_buffer_pool_size','120M')
 ('galera','wsrep_sst_method','rsync')
 ('galera','wsrep_causal_reads','ON')
 (open('/etc//','w'))
def cp_server_cnf():
 child1 = ('scp /etc// %s@%s:/etc//' % (USERNAME,DB2))
 ('password:')
 (PASSWORD)
 ()
 ()
 child2 = ('scp /etc// %s@%s:/etc//' % (USERNAME,DB3))
 ('password:')
 (PASSWORD)
 ()

 ()
def conn_db(ip,cnf):
 child3 = ('ssh %s@%s' % (USERNAME, ip))
 ('password:')
 ('root')
 ('#')
 (cnf)
 ('#')
 ('systemctl restart mariadb > /dev/null')
 ('exit')
 ()
 ()
def init_cmd():
 res1 = ('service mariadb stop')
 res2 = ('mysqld_safe --wsrep_cluster_address=gcomm://%s,%s,%s >/dev/null &' % (DB1, DB2, DB3))
 res3 = ('galera_new_cluster &>/dev/null')
 if res2 == 0:
  print('galera initialization complete')
  if res3 == 0:
   print('The galera cluster has been started')
  else:
   print('galera cluster startup failed')
 else:
  print('galera initialization failed!')
def main():
 config_parse()
 cp_server_cnf()
 init_cmd()
 conn_db(DB2,server2_cnf)
 conn_db(DB3,server3_cnf)

if __name__ == '__main__':
 main()

Above this Django encapsulated interactive interface code is all I have to share with you, I hope to give you a reference, and I hope you support me more.