โค้ด: เลือกทั้งหมด
con = psycopg2.connect(host='localhost', database='testppp', user='postgres', password='')
cur = con.cursor()
sql = "SELECT name,amount FROM hr_payslip_line WHERE employee_id = '%s' " % id
try:
cur.execute(sql)
con.commit()
money = cur.fetchall()
#print(money)
c = canvas.Canvas("payslip.pdf")
c.setFont("THSarabunNew", 18)
for row in money:
print(row[0])
c.drawString(1.1 * inch, 9.6 * inch, row[0])
c.showFullScreen0()
c.showPage()
c.save()
except:
con.rollback()