def form_to_dao(self, team_id):
team = None
players = []
if team_id is not None and len(team_id) > 1:
team = self.teamDao.get_record(long(team_id))
else:
team = Team()
team.name = self.form.name.data
team.alias = utils.slugify(self.form.name.data)
team.sport = self.form.sport.data
team.category = self.form.category.data
players = self.upload_players()
sel_player = self.request.get_all('player')
logger.debug('sel_player: ' + str(sel_player))
if len(sel_player) > 0:
players_count = len(sel_player)
logger.debug('No of Selected Players %s' % players_count)
for x in xrange(players_count):
players.append(self.profileDao.get_record(sel_player[x]).key)
logger.info('Total No of Players Mapped %s' % len(players))
logger.debug('Total Players Data: ' + str(players))
team.players = players
return team
def form_to_dao_business(self, **update):
business = Business()
business.name = update['name']
#Create an automatic alias for the business
business.alias = utils.slugify(update['name'])
business.description = update['description']
business = self.form_to_dao_contact_info_import(business, **update)
return business
def form_to_dao_team_auto(self, player):
try:
team = Team()
team.name = self.form.teamName.data
#Create an automatic alias for the team
team.alias = utils.slugify(self.form.teamName.data)
team.sport = self.form.sport.data
except StandardError as e:
logger.error('Error occured, %s, for %s:%s' % (str(e), type, update['name']))
raise
return team
def post(self):
logging.info(self.request.body)
id = self.request.get("pk")
team = Team.get_by_id(long(id))
team.name = utils.stringify(self.request.get("value"))
team.alias = utils.slugify(self.request.get("value"))
logger.info('Id: %s Value: %s' % (id, team.name))
team.put()
logger.debug('Team Data: ' + str(team))
#return json.dumps(result) #or, as it is an empty json, you can simply use return "{}"
return
def form_to_dao(self, business_id):
business = None
if business_id is not None and len(business_id) > 1:
business = self.businessDao.get_record(long(business_id))
logger.debug('business ' + str(business))
else:
business = Business()
logger.debug('business 2 ' + str(business))
business.name = self.form.name.data
#Create an automatic alias for the business
business.alias = utils.slugify(self.form.name.data)
business.description = self.form.description.data
return cms_utils.form_to_dao_contact_info(self.form, business)
def form_to_dao(self, childevent_id):
childevent = None
if childevent_id is not None and len(childevent_id) > 1:
childevent = self.childeventDao.get_record(long(childevent_id))
else:
childevent = Event()
childevent.name = self.form.name.data
#Create an automatic alias for the childevent
childevent.alias = utils.slugify(self.form.name.data)
childevent.description = self.form.description.data
childevent.start_datetime = self.form.start_datetime.data
childevent.end_datetime = self.form.end_datetime.data
childevent = cms_utils.form_to_dao_contact_info(self.form, childevent)
return childevent
def form_to_dao(self, playground_id):
playground = None
if playground_id is not None and len(playground_id) > 1:
playground = self.playgroundDao.get_record(long(playground_id))
else:
playground = Playground()
playground.name = self.form.name.data
playground.sport = self.form.sport.data.lower()
#Create an automatic alias for the playground
playground.alias = utils.slugify(self.form.name.data)
playground.description = self.form.description.data
playground.featured = self.form.featured.data
self.form.address.locality.data = self.form.locality.data #for locality from basic info to address
self.form.address.city.data = self.form.city.data #for city from basic info to address
playground = cms_utils.form_to_dao_address(self.form, playground)
playground = cms_utils.form_to_dao_contact_info(self.form, playground)
return playground
def form_to_dao(self, trainingcentre_id):
trainingcentre = None
if trainingcentre_id is not None and len(trainingcentre_id) > 1:
trainingcentre = self.trainingCentreDao.get_record(long(trainingcentre_id))
else:
trainingcentre = TrainingCentre()
trainingcentre.name = self.form.name.data
trainingcentre.sport = self.form.sport.data
#Create an automatic alias for the trainingcentre
trainingcentre.alias = utils.slugify(self.form.name.data)
trainingcentre.description = self.form.description.data
trainingcentre.featured = self.form.featured.data
self.form.address.locality.data = self.form.locality.data #for locality from basic info to address
self.form.address.city.data = self.form.city.data #for city from basic info to address
trainingcentre = cms_utils.form_to_dao_address(self.form, trainingcentre)
trainingcentre = cms_utils.form_to_dao_contact_info(self.form, trainingcentre)
return trainingcentre
def form_to_dao(self, event_id):
event = None
if event_id is not None and len(event_id) > 1:
event = self.eventDao.get_record(long(event_id))
else:
event = Event()
event.name = self.form.name.data
event.sport = self.form.sport.data
#Create an automatic alias for the event
event.alias = utils.slugify(self.form.name.data)
event.caption = self.form.caption.data
event.description = self.form.description.data
event.featured = self.form.featured.data
event.start_datetime = datetime(*(self.form.start_datetime.data.timetuple()[:6]))
event.end_datetime = datetime(*(self.form.end_datetime.data.timetuple()[:6]))
self.form.address.city.data = self.form.city.data #for city from basic info to address
event = cms_utils.form_to_dao_address(self.form, event)
event = cms_utils.form_to_dao_contact_info(self.form, event)
return event
def post(self, player_id=None):
params = {}
if not self.form.validate():
if player_id is not None and len(player_id) > 0:
return self.get(player_id)
else:
return self.get()
continue_url = self.request.get('continue').encode('ascii', 'ignore')
player = self.form_to_dao(player_id)
logger.debug('player populated ' + str(player))
team_alias_name = utils.slugify(self.request.get('teamName'))
if team_alias_name != '':
team_exist = self.teamDao.query_by_team_alias(team_alias_name, self.user_info)
logger.info('Exist Team for player: ' + str(team_exist))
if team_exist is None:
team_import_data = self.form_to_dao_team_auto(player)
team_key = self.teamDao.persist(team_import_data, self.user_info)
logger.info('New Team Created for %s with key %s' % (team_alias_name, team_key))
player.teams = team_key
else:
player.teams = team_exist.key
key = self.playerDao.persist(player, self.user_info)
logger.debug('key ' + str(key))
if key is not None:
logger.info('player succesfully created/updated')
message = ('player succesfully created/updated.')
self.add_message(message, 'success')
if continue_url:
return self.redirect(continue_url)
else:
return self.redirect_to('dashboard', **params)
logger.error('player creation failed')
message = ('player creation failed.')
self.add_message(message, 'error')
self.form = forms.NewPlayerForm(self)
return self.render_template('/cms/create_player.html', **params)
def form_to_dao(self, match_id):
match = None
if match_id is not None and len(match_id) > 1:
match = self.matchDao.get_record(long(match_id))
else:
match = Match()
match.name = self.form.name.data
match.sport = self.form.sport.data
#Create an automatic alias for the match
match.alias = utils.slugify(self.form.name.data)
match.start_datetime = self.form.start_datetime.data
match.end_datetime = self.form.end_datetime.data
match.result = self.form.result.data
match.summary = self.form.summary.data
match.participant_type = self.form.participant_type.data
sel_team = self.request.get_all('team')
sel_player = self.request.get_all('player')
logger.debug('sel_team: ' + str(sel_team))
logger.debug('sel_player: ' + str(sel_player))
if match.participant_type == 'team':
if len(sel_team) > 0:
teams = []
teams_count = len(sel_team)
logger.debug('Teams Count: ' + str(teams_count))
for x in xrange(teams_count):
teams.append(self.teamDao.get_record(sel_team[x]).key)
logger.debug('Participants ' + str(teams))
match.participants = teams
else:
if len(sel_player) > 0:
players = []
players_count = len(sel_player)
logger.debug('Teams Count: ' + str(players_count))
for x in xrange(players_count):
players.append(
self.playerDao.get_record(sel_player[x]).key)
logger.debug('Participants ' + str(players))
match.participants = players
return match
def process_csv(self, blob_info, start_record):
update = {}
upload_count = 0
row_count = 0
blob_reader = blobstore.BlobReader(blob_info.key())
datareader = csv.reader(blob_reader)
for row in datareader:
row_count += 1
if row_count >= (start_record + 1): #to skip the header row
logger.info('Starting to parse %s, %s' % (row_count, row[1]))
entity_type = row[0].lower()
update['name'] = utils.stringify(row[1])
# Name is mandatory for all entities
if update['name'] == '':
logger.error('Name is empty. Skipping this record')
continue
update['locality'] = utils.stringify(row[5]).lower()
update['city'] = utils.stringify(row[8]).lower()
#Locality and city mandatory for playground and trainingcentre
if entity_type != 'event':
if update['locality'] == '' or update['city'] == '':
logger.error(
'Locality or city is empty. Skipping this record')
continue
alias_name = utils.slugify(update['name'].lower())
try:
update['description'] = utils.stringify(row[2])
update['sport'] = utils.stringify(row[3]).lower()
update['person_name'] = utils.stringify(row[10])
update['phone'] = utils.stringify(row[11])
update['email'] = utils.stringify(row[12])
update['website'] = utils.stringify(row[13])
update['facebook'] = utils.stringify(row[18])
update['twitter'] = utils.stringify(row[19])
update['youtube'] = utils.stringify(row[20])
update['gplus'] = utils.stringify(row[21])
update['line1'] = utils.stringify(row[6])
update['line2'] = utils.stringify(row[7])
update['pin'] = int(
row[9].strip()) if row[9] != '' else None
#update['start_datetime'] = row[22]
#update['end_datetime'] = row[23]
logger.debug('Constructed Structure for upload ' +
str(update))
logger.info('Entity type to be created, ' + entity_type)
if entity_type == 'ground':
import_data = self.form_to_dao_ground(
alias_name, **update)
elif entity_type == 'club':
import_data = self.form_to_dao_center(
alias_name, **update)
elif entity_type == 'event':
import_data = self.form_to_dao_event(
alias_name, **update)
# for add locality table
if import_data.address.locality != '':
place_name = import_data.address.locality
logger.info('Place: %s' % place_name)
newfeed_url = 'https://maps.googleapis.com/maps/api/place/autocomplete/xml?types=(regions)&input=' + urllib.quote(
place_name) + '&key=' + constants.PLACES_API_KEY
logging.info('newfeed url %s' % newfeed_url)
newroot = self.parse(newfeed_url)
auto_status = newroot.getElementsByTagName(
'status')[0].firstChild.data
logger.info('Auto Status: %s ' % auto_status)
if auto_status == 'OK':
items = newroot.getElementsByTagName(
'prediction')[0]
place_id = items.getElementsByTagName(
'place_id')[0].firstChild.data
place_name = items.getElementsByTagName(
'value')[0].firstChild.data #description
logger.info('Place Name: %s Place Id: %s ' %
(place_name, place_id))
import_data.address.locality_id = place_id
logger.info('Locality Id: %s ' %
import_data.address.locality_id)
locality_add = self.process_locality(
place_name, place_id, constants.PLACES_API_KEY)
#if import_data.address.latlong == '':
#locality = self.importDao.query_by_place_id(place_id)
#import_data.address.latlong = locality.latlong
#logger.info('Geo Location New: %s ' % import_data.address.latlong)
else:
logger.error('Error: %s' % auto_status)
logger.debug('Populated File Data ' + str(import_data))
business_key = self.create_or_update_business(
alias_name, import_data)
import_data.business_id = business_key
if entity_type == 'ground':
ground = self.playgroundDao.query_by_alias(alias_name)
if ground is not None:
self.playgroundDao.copy_playground_model(
ground, import_data)
key = self.playgroundDao.persist(
ground, self.user_info)
upload_count += 1
logger.info(
'Playground updated for %s with key %s' %
(alias_name, key))
else:
key = self.playgroundDao.persist(
import_data, self.user_info)
upload_count += 1
logger.info('New playground created for %s' %
(update['name']))
elif entity_type == 'club':
tc = self.trainingCentreDao.query_by_alias(alias_name)
if tc is not None:
self.trainingCentreDao.copy_trainingCentre_model(
tc, import_data)
key = self.trainingCentreDao.persist(
tc, self.user_info)
upload_count += 1
logger.info(
'TrainingCentre updated for %s with key %s' %
(alias_name, key))
else:
key = self.trainingCentreDao.persist(
import_data, self.user_info)
upload_count += 1
logger.info('New training centre created for %s' %
(update['name']))
elif entity_type == 'event':
event = self.eventDao.query_by_alias(alias_name)
if event is not None:
self.eventDao.copy_event_model(event, import_data)
key = self.eventDao.persist(event, self.user_info)
upload_count += 1
logger.info('Event updated for %s with key %s' %
(alias_name, key))
else:
key = self.eventDao.persist(
import_data, self.user_info)
upload_count += 1
logger.info('Event created for %s' %
(update['name']))
if key is not None:
logger.info(
str(entity_type) + ' succesfully created/updated')
else:
logger.error('Already Exist of %s:%s' %
(entity_type, update['name']))
except StandardError as e:
#skipping to next record
logger.error('Error occured, %s, for %s' %
(str(e), alias_name))
else:
logger.info("skipping record number, %s " % row_count)
return upload_count
def process_csv(self, blob_info, start_record, event_id=None):
update = {}
upload_count = 0
row_count = 0
blob_reader = blobstore.BlobReader(blob_info.key())
datareader = csv.reader(blob_reader)
for row in datareader:
row_count += 1
if row_count >= (start_record + 1): #to skip the header row
logger.info('Starting to parse %s, %s' % (row_count, row[1]))
entity_type = row[0].lower()
update['name'] = utils.stringify(row[1])
# Name is mandatory for all entities
if update['name'] == '':
logger.error('Name is empty. Skipping this record')
continue
alias_name = utils.slugify(update['name'].lower())
# Event Id check for matches
if event_id is not None and len(event_id) > 1:
event_data = self.eventDao.get_record(event_id)
event_alias_name = event_data.alias
else:
event_alias_name = ''
try:
update['sport'] = utils.stringify(row[2]).lower()
if entity_type == 'match':
update['start_datetime'] = datetime.strptime(
row[3], '%d-%m-%Y %I:%M%p')
update['end_datetime'] = datetime.strptime(
row[4], '%d-%m-%Y %I:%M%p')
update['result'] = utils.stringify(row[5])
event_alias_name = utils.slugify(row[6].lower(
)) if row[6] != '' else event_alias_name
update['participant_type'] = utils.stringify(
row[7]).lower()
elif entity_type == 'player':
update['email'] = utils.stringify(row[3])
update['phone'] = utils.stringify(row[4])
update['teamName'] = utils.stringify(row[5])
team_alias_name = utils.slugify(
update['teamName'].lower())
logger.debug('Constructed Structure for upload ' +
str(update))
logger.info('Entity type to be created, ' + entity_type)
if entity_type == 'match':
import_data = self.form_to_dao_match(
alias_name, **update)
elif entity_type == 'team':
import_data = self.form_to_dao_team(
alias_name, **update)
elif entity_type == 'player':
import_data = self.form_to_dao_player(
alias_name, **update)
logger.debug('Populated File Data ' + str(import_data))
if entity_type == 'match':
event = self.eventDao.query_by_alias(event_alias_name)
if event is not None:
match_exist = self.matchDao.query_by_alias(
alias_name, event.key, update['sport'])
if match_exist is None:
import_data.event_id = event.key
key = self.matchDao.persist(
import_data, self.user_info)
upload_count += 1
logger.info(
'New Match Created for %s with key %s' %
(alias_name, key))
else:
logger.error('Already Exist of %s:%s' %
(entity_type, update['name']))
else:
logger.error('Event Name %s doesnot exist' %
(event_alias_name))
elif entity_type == 'team':
team_exist = self.teamDao.query_by_alias(
alias_name, update['sport'])
logger.info('Team Exist Data: ' + str(team_exist))
if team_exist is None:
key = self.teamDao.persist(import_data,
self.user_info)
upload_count += 1
logger.info('New Team Created for %s with key %s' %
(alias_name, key))
else:
logger.error('Already Exist of %s:%s' %
(entity_type, update['name']))
elif entity_type == 'player':
player_exist = self.playerDao.query_by_email(
update['email'])
logger.info('Player Exist Data: ' + str(player_exist))
if player_exist is None:
team_exist = self.teamDao.query_by_team_alias(
team_alias_name, self.user_info)
logger.info('Exist Team for player: ' +
str(team_exist))
if team_exist is None:
team_import_data = self.form_to_dao_team_auto(
team_alias_name, **update)
team_key = self.teamDao.persist(
team_import_data, self.user_info)
logger.info(
'New Team Created for %s with key %s' %
(team_alias_name, team_key))
import_data.teams = team_key
else:
import_data.teams = team_exist.key
key = self.playerDao.persist(
import_data, self.user_info)
upload_count += 1
logger.info(
'New Player Created for %s with key %s' %
(alias_name, key))
else:
logger.error('Already Exist of %s:%s' %
(entity_type, update['name']))
if key is not None:
logger.info(
str(entity_type) + ' succesfully created/updated')
else:
logger.error('Already Exist of %s:%s' %
(entity_type, update['name']))
except StandardError as e:
#skipping to next record
logger.error('Error occured, %s, for %s' %
(str(e), alias_name))
else:
logger.info("skipping record number, %s " % row_count)
return upload_count