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,