def get_hole_details(hole_id):
DB_URL = get_DB_URL()
hole_hist_model = hole_history(DB_URL)
hole_model = hole(DB_URL)
hole_type = hole_model.get_hole_type_by_id(hole_id)
hole_hist = []
temp_hole_hist = hole_hist_model.get_by_holeid(hole_id)
for hh in temp_hole_hist:
hole_hist.append({
'HOLE_ID': hh['HOLE_ID'],
'CLSS_NO': hh['CLSS_NO'],
'ORD_NO': hh['ORD_NO'],
'ACTR_ID': hh['ACTR_ID'],
'ACT_NM': hh['ACT_NM'],
'RSLT_NM': hh['RSLT_NM'],
'ACT_SCRE': hh['ACT_SCRE'],
'DIST_NO': hh['DIST_NO'],
'holeType': hole_type['HOLE_TP']
})
return {'holeDetail': hole_hist}
def get_hole_results(params):
DB_URL = get_DB_URL()
sql_proc = sqlprocedure(DB_URL)
hole_hist_model = hole_history(DB_URL)
hole_results = sql_proc.get_hole_results(params)
response_data = []
for hole in hole_results:
hole_data = {
'HOLE_ID': hole['HOLE_ID'],
'PLER_ID': hole['PLER_ID'],
'HOLE_TP': hole['HOLE_TP'],
'HOLE_DT': hole['HOLE_DT'].strftime("%Y-%m-%d"),
'WK_DY': hole['WK_DY'],
'GRP_TP': hole['GRP_TP'],
'WRKR_1_ID': hole['WRKR_1_ID'],
'WRKR_2_ID': hole['WRKR_2_ID'],
'SCRE_NO': hole['SCRE_NO']
}
# Compute distance
temp_hole_hist = hole_hist_model.get_by_holeid(hole['HOLE_ID'])
distance = []
for temp in temp_hole_hist:
distance.append(temp['DIST_NO'])
hole_data['TTL_DIST_NO'] = round(sum(distance), 2)
response_data.append(hole_data)
return {
'data': response_data,
'leagueInfo': {
'name': params['league_name'],
'startDate': params['start_date'].strftime("%Y-%m-%d"),
'end_date': params['end_date'].strftime("%Y-%m-%d")
}
}
from models.player_group import player_group
from config import get_DB_URL
test = player_group(get_DB_URL())
test.insert_to({
'GAME_ID': 1,
'PLER_ID': 1,
'WRKR_ID': 1,
'PLER_GRP_NM': 'N',
'GRP_CLSS_TP': 'N'
})
# -*- coding: utf-8 -*-
# Description: call procedure
# By Thuong.Tran
# Date: 12 Sept. 2017
from __future__ import division
import datetime as dt
from config import get_DB_URL
from models.sqlprocedure import sqlprocedure
from models.worker import worker
from models.ranking import rank
DB_URL = get_DB_URL()
sql_proc = sqlprocedure(DB_URL)
day_hole = {'Mon': 'hole_1', 'Tue': 'hole_2', 'Wed': 'hole_3', 'Thu': 'hole_4', 'Fri': 'hole_5'}
class notify_game_results():
def __init__(self, league_name, start_date, end_date):
self.league_name = league_name
self.start_date = start_date
self.end_date = end_date
self.week_days = ['Mon', 'Tue', 'Wed', 'Thu', 'Fri']
self.num_weeks = 5
def _get_5_weeks_day(self, worker_id):
weeks_list = []
start_date = self.start_date
end_date = self.end_date
for i in range(self.num_weeks):
weeks_list.append({
'league_name': self.league_name,