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, ])
