def get_owner_article(article_id): owner_id = None db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_OWNER_ARTICLE', [article_id, owner_id, ]) return result[1]
def get_news(): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_NEWS', [result_cursor, ]) fetchall = result[0] return dictfetchall(fetchall)
def verify_user(email, password): hash_pass = to_md5(password) user_id = None db = get_db_connection() cur = db.cursor() result = cur.callproc('VERIFY_USER', [email, hash_pass, user_id, ]) return int(result[2])
def is_left_like(article_id, user_id): isLeft = 0 db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('IS_LEFT_LIKE', [article_id, user_id, isLeft, ]) return bool(result[2])
def get_numlikes_journ(user_id): numlikes = None db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_NUMLIKES_JOURN', [user_id, numlikes, ]) return result[1]
def is_journalist(user_id): print 'user_id is_journ', user_id numberp = 0 db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('IS_JOURNALIST', [user_id, numberp, ]) return bool(result[1])
def get_name_user(id): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_NAME_USER', [id, result_cursor, ])[1].fetchone() if result is None: return 'Undefined' else: return result[1]
def get_max_id_user(): max_id = None db = get_db_connection() cur = db.cursor() result = cur.callproc('GET_MAX_ID_USER', [max_id, ]) return result[0]
def get_article(article_id): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_ARTICLE', [article_id, result_cursor, ]) return dictfetcone(result[1])
def add_news(user_id, news, header, is_sand): db = get_db_connection() date_str = datetime.now().strftime('%b %d, %Y, %I:%M %p') cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('ADD_NEWS', [date_str, user_id, news, header, 'url Foto', 0, is_sand ])
def inc_numbers_like_journalist(article_id): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('INC_NUMBERS_LIKE_JOURNALIST', [article_id, ])
def get_comments(article_id): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_COMMENTS', [article_id, result_cursor, ]) return dictfetchall(result[1])
def get_news_by_name(user_name): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_NEWS_BY_NAME', [user_name, result_cursor, ]) return dictfetchall(result[1])
def add_like_sql(article_id, user_id): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('ADD_LIKE', [article_id, user_id, ])
def add_comment(news_id, user_id, comment): db = get_db_connection() date_str = datetime.now().strftime('%b %d, %Y, %I:%M %p') cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('ADD_COMMENT', [news_id, user_id, date_str, comment, ])
def has_login(user_name): numberp = 10; db = get_db_connection() cur = db.cursor() result = cur.callproc('HAS_LOGIN', [user_name, numberp ]) return bool(result[1])
def has_email(email): numberp = 10; db = get_db_connection() cur = db.cursor() result = cur.callproc('HAS_EMAIL', [email, numberp ]) return bool(result[1])
def get_childs_articles(): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('GET_CHILDS_ARTICLES', [result_cursor, ]) return dictfetchall(result[0])
def make_journalist(user_id): db = get_db_connection() cur = db.cursor() result_cursor = cur.var(cx_Oracle.CURSOR) result = cur.callproc('MAKE_JOURNALIST', [user_id, ])
def add_user(user_name, password, email, status_id=1): db = get_db_connection() cur = db.cursor() hash_pass = to_md5(password) result = cur.callproc('ADD_USER', [user_name, hash_pass, email, status_id, ])