def update_user(form, username, backend, frontend):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'UPDATE mysql_users SET username=%s, password=%s, active=%s, use_ssl=%s, default_hostgroup=%s, ' \
'default_schema=%s, schema_locked=%s, transaction_persistent=%s, fast_forward=%s, backend=%s, ' \
'frontend=%s, max_connections=%s WHERE username=%s and backend=%s and frontend=%s'
cur.execute(sql, (form.username.data,
form.password.data,
form.active.data,
form.use_ssl.data,
form.default_hostgroup.data,
form.default_schema.data,
form.schema_locked.data,
form.transaction_persistent.data,
form.fast_forward.data,
form.backend.data,
form.frontend.data,
form.max_connections.data,
username,
backend,
frontend
)
)
conn.commit()
conn.close
def cevrimici(a, b, c):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'UPDATE mysql_servers SET status="ONLINE" WHERE hostgroup_id=%s and hostname=%s and port=%s'
cur.execute(sql, (a, b, c))
conn.commit()
def clear(a, b, c):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'DELETE FROM mysql_servers WHERE hostgroup_id=%s and hostname=%s and port=%s'
cur.execute(sql, (a, b, c))
conn.commit()
def offlinehard(a, b, c):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'UPDATE mysql_servers SET status="OFFLINE_HARD" WHERE hostgroup_id=%s and hostname=%s and port=%s'
cur.execute(sql, (a, b, c))
conn.commit()
conn.close()
def remove_proxy(a, b):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'DELETE FROM proxysql_servers WHERE hostname=%s and port=%s'
cur.execute(sql, (a, b))
conn.commit()
conn.close
def user_config_save():
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'SAVE MYSQL USERS TO DISK'
cur.execute(sql)
conn.commit()
conn.close
def rmuser(a, b, c):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'DELETE FROM mysql_users WHERE username=%s and backend=%s and frontend=%s'
cur.execute(sql, (a, b, c))
conn.commit()
conn.close()
def user_config_load():
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'LOAD MYSQL USERS TO RUNTIME'
cur.execute(sql)
conn.commit()
conn.close
def deactiveuser(a, b, c):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'UPDATE mysql_users SET active=0 WHERE username=%s and backend=%s and frontend=%s'
cur.execute(sql, (a, b, c))
conn.commit()
conn.close()
def proxy_print(host):
proxy_list = []
conn = proxy_connect(host)
cur = conn.cursor()
sql = "select *, hostname ||'_' || port as pk from proxysql_servers"
cur.execute(sql)
for k in cur:
proxy_list.append(k)
conn.commit()
return proxy_list
def users_print(host):
user_list = []
conn = proxy_connect(host)
cur = conn.cursor()
sql = "select *, username ||':' || backend || ':' || frontend as pk from mysql_users"
cur.execute(sql)
for j in cur:
user_list.append(j)
conn.commit()
return user_list
def update_proxy(form, a, b):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'UPDATE proxysql_servers SET hostname=%s, port=%s, weight=%s, comment=%s WHERE hostname=%s and port=%s'
cur.execute(sql, (form.hostname.data, form.port.data, form.weight.data,
form.comment.data, a, b))
conn.commit()
conn.close
def add_proxy(form):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'INSERT INTO proxysql_servers (hostname, port, weight, comment) VALUES (%s,%s,%s,%s)'
cur.execute(sql, (form.hostname.data, form.port.data, form.weight.data,
form.comment.data))
conn.commit()
conn.close
def add(form):
x = session.get('host', 'not set')
print("serveroperation x: ")
print(x)
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'INSERT INTO mysql_servers (hostgroup_id, hostname, port, status, weight, compression, max_connections, max_replication_lag,use_ssl, max_latency_ms, comment) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
cur.execute(
sql, (form.hostgroup_id.data, form.hostname.data, form.port.data,
form.status.data, form.weight.data, form.compression.data,
form.max_connections.data, form.max_replication_lag.data,
form.use_ssl.data, form.max_latency_ms.data, form.comment.data))
conn.commit()
def servers_print(host):
server_list = []
conn = proxy_connect(host)
try:
cur = conn.cursor()
sql = "select *, hostgroup_id ||'_' || hostname || '_' || port as pk from mysql_servers"
cur.execute(sql)
for i in cur:
server_list.append(i)
conn.commit()
return server_list
except:
pass
def update_server(form, a, b, c):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'UPDATE mysql_servers SET hostgroup_id=%s, hostname=%s, port=%s, status=%s, weight=%s, compression=%s, ' \
'max_connections=%s, max_replication_lag=%s, use_ssl=%s, max_latency_ms=%s, comment=%s ' \
'WHERE hostgroup_id=%s and hostname=%s and port=%s'
cur.execute(sql, (form.hostgroup_id.data, form.hostname.data,
form.port.data, form.status.data, form.weight.data,
form.compression.data, form.max_connections.data,
form.max_replication_lag.data, form.use_ssl.data,
form.max_latency_ms.data, form.comment.data, a, b, c))
conn.commit()
conn.close
def veri_ekle(form):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = "INSERT INTO author (username,email,password) VALUES (%s,%s,%s)"
try:
cur.execute(sql,
(form.username.data,
form.email.data,
form.password.data
)
)
conn.commit()
except Exception as e:
print("Exception olustu:", e)
conn.rollback()
return False
def adduser(form):
x = session.get('host', 'not set')
conn = proxy_connect(x)
cur = conn.cursor()
sql = 'INSERT INTO mysql_users (username, password, active, use_ssl, default_hostgroup, default_schema, schema_locked, transaction_persistent,fast_forward, backend, frontend, max_connections) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
cur.execute(sql, (form.username.data,
form.password.data,
form.active.data,
form.use_ssl.data,
form.default_hostgroup.data,
form.default_schema.data,
form.schema_locked.data,
form.transaction_persistent.data,
form.fast_forward.data,
form.backend.data,
form.frontend.data,
form.max_connections.data
)
)
conn.commit()
