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