def load_into_db(self,):
dict_ = {
'email': self.email,
'password': self.password,
'name': self.name,
'type_account': self.type_account,
'mute_status': self.mute_status,
'ban_status': self.ban_status
}
# sql_query = """UPDATE player SET email=%(email); UPDATE player SET name=%(name)s;
# UPDATE player SET password=%(password); UPDATE player SET type_account=%(type_account);
# UPDATE player mute_status=%(mute_status); UPDATE player ban_status=$(ban_status)"""
sql_query = """INSERT INTO `player` (`email`, `password`, `name`, `type_account`, `mute_status`, `ban_status`)
VALUES (%(email)s, %(password)s, %(name)s, %(type_account)s, %(mute_status)s, %(ban_status)s);
"""
with con:
cur = con.cursor()
cur.execute(sql_query, dict_)
result = "load into db successful"
return result
def load_into_db(self, ):
dict_ = {
'email': self.email,
'password': self.password,
'name': self.name,
'type_account': self.type_account,
'mute_status': self.mute_status,
'ban_status': self.ban_status
}
# sql_query = """UPDATE player SET email=%(email); UPDATE player SET name=%(name)s;
# UPDATE player SET password=%(password); UPDATE player SET type_account=%(type_account);
# UPDATE player mute_status=%(mute_status); UPDATE player ban_status=$(ban_status)"""
sql_query = """INSERT INTO `player` (`email`, `password`, `name`, `type_account`, `mute_status`, `ban_status`)
VALUES (%(email)s, %(password)s, %(name)s, %(type_account)s, %(mute_status)s, %(ban_status)s);
"""
with con:
cur = con.cursor()
cur.execute(sql_query, dict_)
result = "load into db successful"
return result
import MySQLdb
from connection_sys import con
r = ''
with con:
cur = con.cursor()
cur.execute("SELECT * FROM player")
for row in cur.fetchall():
r += str(row)
print r
sql_query = 'delete FROM players.player where id_player = %(id)s'
sql_data = {'id': r[1]}
with con:
cur = con.cursor()
cur.execute(sql_query, sql_data)