1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| import MySQLdb
db = MySQLdb.connect('localhost', 'admin', 'adminadmin', 'boursinfo')
curs = db.cursor()
varcondition = 'SELECT a.id_histo, a.valeur_cloture,a.instrument_id FROM Historique a, memumtum b WHERE substr( a.Date, 1, 10 ) = curdate( ) AND b.histo_id = (SELECT max( c.histo_id ) FROM memumtum c WHERE c.instrument_id = a.instrument_id )'
curs.execute(varcondition)
curscondition = curs.fetchall()
for row in curscondition:
idhisto = float(row[0])
volday = float(row[1])
instrid= float(row[2])
valeur13='SELECT a.valeur_cloture FROM Historique a, memumtum b WHERE substr( a.Date, 1, 10 ) = curdate( ) - INTERVAL 15 DAY AND b.histo_id = (SELECT max( c.histo_id ) FROM memumtum c WHERE c.instrument_id = a.instrument_id)'
resultat= volday-valeur13
print valeur13
print volday
print resultat
print instrid
print idhisto
curs.close()
db.commit()
db.close() |
Partager