# Create object for Zendesk queries
zd = ZendeskTask(config.zenURL, config.zenAgent, config.zenPass, config.zenToken)
# Create object for internal database methods (mySQL)
zendeskDb = MySqlTask(config.zendeskMySql['username'],
config.zendeskMySql['password'],
config.zendeskMySql['host'],
config.zendeskMySql['database'])
zendeskDb.connect()
# Grab the last time Accounts were successfully updated
start_time = zendeskDb.pull_job_timestamp("INCREMENTAL_EXPORT")
logging.info("INCREMENTAL_EXPORT: start_time={0}".format(start_time))
try:
tickets = zd.get_tickets(start_time)
except Exception, err:
logging.exception(err)
#print tickets
dbQuery = ("INSERT INTO tickets "
"VALUES (%(ticket_id)s, %(generated_timestamp)s, "
"%(req_name)s, %(req_id)s, %(req_external_id)s, "
"%(req_email)s, %(submitter_name)s, %(assignee_name)s, "
"%(group_name)s, %(subject)s, %(current_tags)s, "
"%(priority)s, %(via)s, %(ticket_type)s, %(created_at)s, "
"%(updated_at)s, %(assigned_at)s, %(organization_name)s, "
"%(due_date)s, %(initially_assigned_at)s, %(solved_at)s, "
"%(resolution_time)s, %(satisfaction_score)s, %(group_stations)s, "
"%(assignee_stations)s,%(reopens)s, %(replies)s, "
