Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2625 Zobrazení

Actually I'm trying to fetch data in listview from mssql server

My python code

 @api.depends('bio')
def _get_chk_out(self):
for record in self:
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=OWNER-PC\SQLEXPRESS;DATABASE=etimetracklite;UID=test;PWD=rimt')
cr = conn.cursor()
b_id=record.bio
current=datetime.datetime.now().date()
back_thirty=current-datetime.timedelta(days=30)
back_thirty=back_thirty.strftime("%Y-%m-%d")

cr.execute("select OutTime from AttendanceLogs where EmployeeId=? AND AttendanceDate Between ? AND ?", b_id,str(back_thirty),str(current))

if(cr.fetchone()==None):
record.chk_out='-'
else:
rows = cr.fetchall()

_logger.info('INFO GG %s',rows)
for i in rows:
record.chk_out = i[0]

but it display only one row in listview...

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
čvc 22
9177
1
čvn 21
2452
2
úno 21
299
5
zář 20
14352
4
čvn 20
49747