rendered paste body$self->{'doc_update'}->execute(sportsml_date2sql_date($date_time),
$self->{'content_update'}->execute($abstract, $sportsml, $doc_id);
$self->{'doc_insert'}->execute($doc_id, sportsml_date2sql_date($date_time),
$self->{'content_insert'}->execute($doc_id, $abstract, $sportsml);
$self->{'xtoss_doc_update'}->execute(
$self->{'xtoss_document_contents_update'}->execute($abstract, $sportsml, $document_id);
$self->{'xtoss_doc_insert'}->execute(
$self->{'xtoss_document_contents_insert'}->execute($document_id, $abstract, $sportsml);
$self->{'map_revision_document_delete'}->execute($doc_id);
$self->{'map_revision_document_update'}->execute($doc_id, $revision_id);
$self->{'map_revision_document_insert'}->execute($revision_id, $doc_id);
$self->{'xtoss_latest_revisions_delete'}->execute($document_id);
$self->{'xtoss_latest_revisions_update'}->execute($document_id, $revision_id);
$self->{'xtoss_latest_revisions_insert'}->execute($revision_id, $document_id);
$self->{'exists_doc'}->execute($doc_id);
$self->{'xtoss_publisher_exists'}->execute($publisher_key);
$self->{'xtoss_publisher_insert'}->execute(
$self->{'xtoss_publisher_exists'}->execute($publisher_key);
# my $lastid = $self->{'xtoss_publisher_exists'}->execute($publisher_key)->insertid('xtoss_publisher_exists');
$self->{'xtoss_document_fixture_exists'}->execute($publisher_id, $fixture_key);
$self->{'xtoss_document_fixtures_insert'}->execute(
$self->{'xtoss_document_fixture_exists'}->execute($publisher_id, $fixture_key);
$self->{'xtoss_document_class_exists'}->execute($publisher_key, $document_class);
$self->{'xtoss_document_class_insert'}->execute(
$self->{'xtoss_latest_document_classes'}->execute();
$self->{'xtoss_doc_exists'}->execute($doc_id);
$self->{'map_doc_level_insert'}->execute($doc_id, $key, $val);
$self->{'xtoss_affiliations_documents_delete'}->execute($document_id);
$self->{'xtoss_teams_documents_delete'}->execute($document_id);
$self->{'xtoss_event_document_delete'}->execute($document_id);
$self->{'xtoss_persons_documents_delete'}->execute($document_id);
$self->{'xtoss_teams_select'}->execute($val, $publisher_id);
$self->{'xtoss_teams_documents_insert'}->execute(@arr->[0], $document_id);
$self->{'xtoss_teams_insert'}->execute($val, $publisher_id);
$self->{'xtoss_latest_teams'}->execute();
$self->{'xtoss_display_names_insert'}->execute('en-US', @new_team_id->[0], 'teams', $name);
$self->{'xtoss_teams_documents_insert'}->execute(@new_team_id->[0], $document_id);
$self->{'xtoss_persons_select'}->execute($val, $publisher_id);
$self->{'xtoss_persons_documents_insert'}->execute(@arr->[0], $document_id);
$self->{'xtoss_persons_insert'}->execute($val, $publisher_id);
$self->{'xtoss_latest_persons'}->execute();
$self->{'xtoss_display_names_insert'}->execute('en-US', @new_person_id->[0], 'persons', $name);
$self->{'xtoss_persons_documents_insert'}->execute(@new_person_id->[0], $document_id);
$self->{'xtoss_affiliations_select'}->execute($key, $val, $publisher_id);
$self->{'xtoss_affiliations_documents_insert'}->execute(@arr->[0], $document_id);
$self->{'xtoss_affiliations_insert'}->execute($val, $key, $publisher_id);
$self->{'xtoss_latest_affiliations'}->execute();
$self->{'xtoss_display_names_insert'}->execute('en-US', @new_affiliation_id->[0], 'affiliations', $name);
$self->{'xtoss_affiliations_documents_insert'}->execute(@new_affiliation_id->[0], $document_id);
$self->{'map_event_subscore_delete'}->execute($event_id);
$self->{'map_event_award_delete'}->execute($event_id);
$self->{'xtoss_event_exists'}->execute($event_key);
$self->{'xtoss_event_document_exists'}->execute($event_id, $document_id);
$self->{'xtoss_event_document_insert'}->execute($event_id, $document_id);
$self->{'xtoss_site_exists'}->execute($site_key, $publisher_id);
$self->{'xtoss_site_insert'}->execute($site_key, $publisher_id, $location_id);
$self->{'xtoss_event_exists'}->execute($event_key, $publisher_id);
$self->{'xtoss_event_select'}->execute($event_id);
$self->{'xtoss_event_insert'}->execute(
$self->{'xtoss_event_update'}->execute(
$self->{'refdyn_player_insert'}->execute($player_key,
$self->{injuries_pending}->execute('pending', $team_key, 'current');
$self->{injuries_insert}->execute(@values);
$self->{injuries_healthy}->execute($sql_date_time, 'archival', $team_key, 'pending');
$self->{"map_event_fixture_delete"}->execute($event_id, $fixture_key);
$self->{"map_event_fixture_insert"}->execute($event_id, $fixture_key,
$self->{"xtoss_document_fixtures_events_delete"}->execute($xtoss_event_id, $document_fixture_id);
$self->{"xtoss_document_fixtures_events_insert"}->execute($xtoss_event_id, $document_fixture_id, $document_id, $sql_date_time);
$self->{'xtoss_affiliations_events_delete'}->execute($xtoss_event_id);
$self->{'event_insert'}->execute(@values);
$self->{'map_event_level_insert'}->execute($event_id, $hi_level, $val);
$self->{'xtoss_affiliations_select'}->execute($hi_level, $val, $publisher_id);
$self->{'xtoss_affiliations_events_insert'}->execute(@arr->[0], $xtoss_event_id);
$self->{'xtoss_affiliations_insert'}->execute($val, $hi_level, $publisher_id);
$self->{'xtoss_latest_affiliations'}->execute();
$self->{'xtoss_display_names_insert'}->execute('en-US', @new_affiliation_id->[0], 'affiliations', $name);
$self->{'xtoss_affiliations_events_insert'}->execute(@new_affiliation_id->[0], $xtoss_event_id);
$self->{'xtoss_event_leagues_select'}->execute($xtoss_event_id);
$self->{'xtoss_season_select'}->execute($season_key,$publisher_id,$local_event_league_id);
$self->{'xtoss_sub_season_select'}->execute($sub_season_key,$local_season_id);
$self->{'xtoss_sub_season_insert'}->execute($sub_season_key, $local_season_id, $sub_season_type);
$self->{'xtoss_latest_sub_season'}->execute();
$self->{'xtoss_season_insert'}->execute($season_key, $publisher_id, $local_event_league_id);
$self->{'xtoss_latest_season'}->execute();
$self->{'xtoss_sub_season_insert'}->execute($sub_season_key, $local_season_id, $sub_season_type);
$self->{'xtoss_latest_sub_season'}->execute();
$self->{'xtoss_events_sub_seasons_delete'}->execute($xtoss_event_id);
$self->{'xtoss_events_sub_seasons_insert'}->execute($xtoss_event_id,$local_sub_season_id);
$self->{'map_event_level_insert'}->execute($event_id,
# $self->{'map_event_level_insert'}->execute($event_id, $hi_level, $hi_level_key);
$self->{'xtoss_affiliations_select'}->execute($hi_level, $hi_level_key, $publisher_id);
$self->{'xtoss_affiliations_events_insert'}->execute(@arr->[0], $xtoss_event_id);
$self->{'xtoss_affiliations_insert'}->execute($hi_level_key, $hi_level, $publisher_id);
$self->{'xtoss_latest_affiliations'}->execute();
$self->{'xtoss_display_names_insert'}->execute('en-US', @new_affiliation_id->[0], 'affiliations', 'Full Affiliation Name');
$self->{'xtoss_affiliations_events_insert'}->execute(@new_affiliation_id->[0], $xtoss_event_id);
$self->{'xtoss_teams_select'}->execute($team_key, $publisher_id);
$self->{'xtoss_teams_insert'}->execute($team_key, $publisher_id);
$self->{'xtoss_latest_teams'}->execute();
$self->{'xtoss_display_names_insert'}->execute('en-US', @new_team_id->[0], 'teams', $name);
$self->{map_event_weather_update}->execute($prediction, $comment, $event_id);
$self->{map_event_weather_insert}->execute($event_id, $prediction, $comment);
$self->{'xtoss_teams_select'}->execute($hi_level_key, $publisher_id);
# $self->{'participants_events_delete'}->execute($xtoss_event_id);
$self->{'participants_events_update'}->execute(
$self->{'participants_events_insert'}->execute(
$self->{'map_event_result_insert'}->execute($event_id,
$self->{'xtoss_teams_select'}->execute($hi_level_key, $publisher_id);
$self->{'xtoss_periods_delete'}->execute($participant_event_id);
$self->{'map_event_subscore_insert'}->execute($event_id,
$self->{'xtoss_period_insert'}->execute($participant_event_id, $period_value, $score);
$self->{'map_event_award_insert'}->execute($event_id,
$self->{"${table}_delete"}->execute($bookmaker_key,
$self->{"${table}_insert"}->execute($bookmaker_key, $event_id,
my $arr_ref = $dbh->selectrow_arrayref($sql);
my $exists = $self->{'dbh'}->selectrow_arrayref($self->{'map_revision_document_exists'},
my $exists = $self->{'dbh'}->selectrow_arrayref($self->{'xtoss_latest_revisions_exists'},
if (!$self->{'dbh'}->selectrow_arrayref($self->{'map_doc_level_select'},
my $ref = $self->{dbh}->selectrow_arrayref($self->{'later_events_select'},
my $ref = $self->{dbh}->selectrow_arrayref($self->{'xtoss_later_events_select'},
my $ref = $self->{dbh}->selectrow_arrayref($self->{'later_event_fixtures_select'},
my $ref = $self->{dbh}->selectrow_arrayref($self->{'later_xtoss_document_fixtures_events_select'},
my $cur_rec = $self->{'dbh'}->selectrow_arrayref($self->{'injuries_current'},
my $arr_ref = $self->{'dbh'}->selectrow_arrayref($self->{'refdyn_player_exists'},
my $cnt_ref = $self->{'dbh'}->selectrow_arrayref($self->{'event_count'},
my $ref = $self->{'dbh'}->selectrow_arrayref($self->{'map_event_level_select'},
my $ref = $self->{'dbh'}->selectrow_arrayref($self->{'map_event_level_select'},
my $ref = $self->{'dbh'}->selectrow_arrayref($self->{'xtoss_affiliations_events_select'},
my $exists = $self->{'dbh'}->selectrow_arrayref($self->{'map_event_weather_exists'}, undef, $event_id);
my $participants_events_row = $self->{'dbh'}->selectrow_arrayref($self->{'xtoss_participants_events_exists'},
my $participants_events_row = $self->{'dbh'}->selectrow_arrayref($self->{'xtoss_participants_events_exists'},
my $exists = $self->{'dbh'}->selectrow_arrayref($self->{'map_event_result_exists'},
my $rec = $self->{dbh}->selectrow_arrayref(