JobSkillRequirement.SkillCode=?
""", [skill_code] )
job_names = []
for j in jobs:
job_names.append(j['Name'])
row.append( len(job_names) )
row.append( ", ".join(job_names) )
row.append( job_usage['ValSum'] )
partner_usage = DataManager.getRow( "SELECT COUNT(*) AS Cnt, SUM(Value) AS ValSum FROM PartnerSkillRequirement WHERE SkillCode=?", [skill_code] )
partners = DataManager.getRows( """
SELECT
Partner.Name
FROM
Partner
INNER JOIN PartnerSkillRequirement ON PartnerSkillRequirement.PartnerCode = Partner.PartnerCode
WHERE
PartnerSkillRequirement.SkillCode=?
""", [skill_code] )
row.append(job_usage['Cnt'])
row.append(job_usage['ValSum'])
csvOut.append(row)
print csvOut
csvOutFile = open( DataManager.setting('dbReportOutCsvPath'), 'wb' )
wr = csv.writer( csvOutFile, quoting=csv.QUOTE_ALL )
for row in csvOut:
wr.writerow(row)
csvOutFile.close()
