def get_group_data(group_id):
logging.debug("Fetching group data from DB")
if group_id:
query = """SELECT index, groupme_group_id, message_num, message_limit,
num_past_transactions, league_data, status, messaging_status, bot_id, members
FROM groupme_yahoo WHERE groupme_group_id = %s"""
values = (group_id, )
results = db.fetch_one(query, values)
if results:
group_data = {
'index': results[0],
'message_num': results[2],
'message_limit': results[3],
'transaction_num': results[4],
'status': int(results[6]),
'messaging_status': int(results[7]),
'bot_id': results[8],
'groupme_group_id': results[1],
'members': results[9] if results[9] else {}
}
group_data['triggers'] = load_triggers(group_data['index'])
delete_messages(group_data['groupme_group_id'])
return group_data
logging.error("No Group Found in fetch_group_data")
return {}
def blog_main(request):
"""
This is the main blog entry point. It;
- gets config data
- sets up nav and other options based on the config data
- returns the templated page
"""
context = wegblob_settings.config
entry_id = request.GET.get("entry_id")
if entry_id is not None:
entry_id = int(entry_id)
context['entry'] = db.fetch_one(blog_id=entry_id)
context['entry']['base_path'] = "/static/content/"
context['entry']['template'] = context['entry']['rel_path'] + "/index.html"
"""
A bit of code to set up the nav panels to the right of the content area
"""
for nav in wegblob_settings.config['nav_panels']:
# Recent posts if entry_id = None, else show related posts >>>
# ============================================================
if nav['title'] == wegblob_settings.NAV_PANEL_LAST_POSTS and nav[
'display']:
num_posts = 5 if 'num_posts' not in nav else nav['num_posts']
if entry_id is None:
context['recent_related_title'] = "LAST POSTS"
context['last_entries'] = db.fetch_last_entries(num_posts,
exclude=0)
else:
context['recent_related_title'] = "RELATED POSTS"
context['last_entries'] = db.fetch_related_entries(
entry_id, num_posts)
# Tag cloud >>>
# =============
elif nav['title'] == wegblob_settings.NAV_PANEL_TAGS and nav['display']:
context['tags'] = _format_post_tags(
context['entry']['tags']) #db.get_tags()
return render_to_response('wegblob-main.html',
context,
context_instance=RequestContext(request))
def blog_main(request):
"""
This is the main blog entry point. It;
- gets config data
- sets up nav and other options based on the config data
- returns the templated page
"""
context = wegblob_settings.config
entry_id = request.GET.get("entry_id")
if entry_id is not None:
entry_id = int(entry_id)
context["entry"] = db.fetch_one(blog_id=entry_id)
context["entry"]["base_path"] = "/static/content/"
context["entry"]["template"] = context["entry"]["rel_path"] + "/index.html"
"""
A bit of code to set up the nav panels to the right of the content area
"""
for nav in wegblob_settings.config["nav_panels"]:
# Recent posts if entry_id = None, else show related posts >>>
# ============================================================
if nav["title"] == wegblob_settings.NAV_PANEL_LAST_POSTS and nav["display"]:
num_posts = 5 if "num_posts" not in nav else nav["num_posts"]
if entry_id is None:
context["recent_related_title"] = "LAST POSTS"
context["last_entries"] = db.fetch_last_entries(num_posts, exclude=0)
else:
context["recent_related_title"] = "RELATED POSTS"
context["last_entries"] = db.fetch_related_entries(entry_id, num_posts)
# Tag cloud >>>
# =============
elif nav["title"] == wegblob_settings.NAV_PANEL_TAGS and nav["display"]:
context["tags"] = _format_post_tags(context["entry"]["tags"]) # db.get_tags()
return render_to_response("wegblob-main.html", context, context_instance=RequestContext(request))
def set_personal_information_mobile(user_fbid, input_data):
'''把使用者資料上傳到資料庫
Args:
user_fbid: 使用者唯一的fbid
input_data:包含使用者資料的list
'''
fbuser_pk = db.fetch_one('select id from fbuser where fbid = %s',
[user_fbid])
if not fbuser_pk:
print('{0} Fb user pk not find'.format(fbuser_pk))
return
if input_data['education_data']:
for data in input_data['education_data']:
if data['type'] and data['type'] != '':
fbpage_pk = db.fetch_one('call add_fbpage_with_type(%s,%s)',
[data['name'], data['type']])
else:
fbpage_pk = db.fetch_one('call add_fbpage(%s)', [data['name']])
if data['fbid']:
db.exec(
'update fbpage set fbid = %s ,url = %s where id = %s ;',
[data['fbid'], data['url'], fbpage_pk])
# 建立user 於何時就讀的關聯
fbuser_has_education_exist = db.exec(
'select 1 from fbuser_has_fbpage '
'where fbuser_id = %s and fbpage_id = %s',
[fbuser_pk, fbpage_pk])
# TODO year_graduation
if not fbuser_has_education_exist:
db.exec(
'insert into fbuser_has_fbpage(fbuser_id,fbpage_id,type,ctype,begin,end)'
' values (%s,%s,%s,%s,%s,%s)', [
fbuser_pk, fbpage_pk, 'edu', '學歷', data['begin'],
data['end']
])
if input_data['work_data']:
for data in input_data['work_data']:
fbpage_pk = db.fetch_one('call add_fbpage(%s)', [data['name']])
if data['fbid']:
db.exec(
'update fbpage set fbid = %s ,url = %s where id = %s ;',
[data['fbid'], data['url'], fbpage_pk])
try:
# 建立user 於何時就讀的關聯
fbuser_has_work_exist = db.exec(
'select 1 from fbuser_has_fbpage '
'where fbuser_id = %s and fbpage_id = %s',
[fbuser_pk, fbpage_pk])
# TODO year_graduation
if not fbuser_has_work_exist:
db.exec(
'insert into fbuser_has_fbpage(fbuser_id,fbpage_id,type,ctype,begin,end,postion)'
' values (%s,%s,%s,%s,%s,%s,%s)', [
fbuser_pk, fbpage_pk, 'work', '工作經歷',
data['begin'], data['end'], data['position']
])
except:
print(sys.exc_info()[0])
print(sys.exc_info()[1])
print('++++++++++++++++++++++++++++++++++++++++')
print(input_data['work_data'])
print('++++++++++++++++++++++++++++++++++++++++')
try:
db.exec(
"update fbuser set gender = %s"
", hometown = %s, relationship = %s, birthday = %s, ename = %s, cname = %s,"
" bloodtype = %s, last_update = %s, current_city =%s where id = %s",
[
input_data['gender'], input_data['hometown'],
input_data['relationship'], input_data['birthday'],
input_data['ename'], input_data['cname'],
input_data['bloodtype'],
datetime.now(), input_data['current_city'], fbuser_pk
])
db.exec(
'update fbuser_ext set religious = %s, political_view = %s, other = %s, quotes = %s '
'where fbuser_id = %s', [
input_data['religious'], input_data['political_view'],
input_data['other'], input_data['quotes'], fbuser_pk
])
except:
print(sys.exc_info()[0])
print(sys.exc_info()[1])
print(input_data)
db.commit()
def get_user(user_id):
return fetch_one("SELECT * FROM users WHERE id = %s" % user_id)
def get_application_status():
query = """SELECT * FROM application_data"""
monitoring_status, messaging_status = db.fetch_one(query)
return monitoring_status, messaging_status
def get_league_data(group_data):
query = "SELECT league_data FROM groupme_yahoo WHERE index = %s;"
values = (str(group_data['groupme_group_id']), )
results = db.fetch_one(query, values)
logging.warn("league data found: %s" % (results))
return results