def delete(user_id, title):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
deleted = mysql_db.execute(
"DELETE FROM articles WHERE user_id= '%d' and title='%d'" %
(str(user_id), str(title)))
return deleted
def delete(user_id):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "DELETE FROM user_info WHERE USER_ID = %d" % (user_id)
deleted = db_cursor.execute(sql)
mysql_db.commit()
return deleted
def delete(user_id):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "DELETE FROM user_info WHERE user_id= %d " % (user_id)
deleted = db_cursor.execute(sql)
mysql_db.commit() #mysql에 데이터 변형이 일어나는 것이므로 커밋을 하는 게 좋다.
return deleted
def find(user_id):
mysql_db = conn_mysqldb()
user = mysql_db.execute("SELECT * FROM user_info WHERE USER_ID='%s'" %
str(user_id)).fetchone()
if not user:
return None
user = User(user_id=user[1], password=user[2], user_name=user[3])
return user
def create(user_id, password, user_name):
user = User.find(user_id)
if user == None:
mysql_db = conn_mysqldb()
mysql_db.execute(
"INSERT INTO user_info(user_id,password, user_name) VALUES ('%s','%s','%s')"
% (str(user_id), str(password), str(user_name)))
return User.find(user_id)
else:
return None
def get(user_id):
mysql_db = conn_mysqldb()
param = {'user_id': user_id}
user = mysql_db.execute(
text("SELECT * FROM user_info WHERE USER_ID=:user_id"),
param).fetchone()
if not user:
return None
user = User(user_id=user[1], password=user[2], user_name=user[3])
return user
def get(user_id):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "SELECT * FROM user_info WHERE USER_ID = '" + str(user_id) + "'"
db_cursor.execute(sql)
user = db_cursor.fetchone()
if not user:
return None
user = User(user_id=user[0], user_email=user[1], blog_id=user[2])
return user
def create(user_email, blog_id):
user = User.find(user_email)
if user == None:
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "INSERT INTO user_info(USER_EMAIL, BLOG_ID) VALUES('%s', '%s')" % (str(user_email), str(blog_id))
db_cursor.execute(sql)
mysql_db.commit()
return User.find(user_email)
else:
return user
def find(user_email):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "SELECT * FROM user_info WHERE USER_EMAIL = '" + str(user_email) + "' "
db_cursor.execute(sql)
user = db_cursor.fetchone()
if not user:
return None
user = User(user[0], user[1], user[2])
return user
def create(user_name, user_password):
user = User.find(user_name, user_password)
if user == None:
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "INSERT INTO user_info(name, password) VALUES('%s', '%s')" % (
str(user_name), str(user_password))
db_cursor.execute(sql)
mysql_db.commit()
return User.find(user_name)
else:
return user
def find(user_name, user_password):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "SELECT * FROM user_info WHERE NAME = '%s' and PASSWORD = '******'" % (
user_name, user_password)
db_cursor.execute(sql)
user = db_cursor.fetchone()
if not user:
return None
user = User(user[0], user[1], user[2])
return user
def find(user_email):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
sql = "SELECT * FROM user_info WHERE USER_EMAIL='" + str(
user_email) + "'"
#print(sql) 터미널 등에서 코드상으로 확인후 작업하는게 좋다. 에러가 잘뜬단다.
db_cursor.execute(sql)
user = db_cursor.fetchone()
if not user:
return None
user = User(user_id=user[0], user_email=user[1], blog_id=user[2])
return user
def delete(user_id):
mysql_db = conn_mysqldb()
db_cursor = mysql_db.cursor()
deleted = mysql_db.execute(
"DELETE FROM user_info WHERE user_id= '%d' " % (user_id))
return deleted
def write_post(user_id, title, context):
mysql_db = conn_mysqldb()
a = mysql_db.execute(
"INSERT INTO articles(user_id, title, context) VALUES ('%s','%s','%s')"
% (str(user_id), str(title), str(context)))
return a
def get_home_board():
mysql_db = conn_mysqldb()
rows = mysql_db.execute(
"SELECT * FROM articles ORDER BY create_at DESC limit 5").fetchall(
)
return rows
