spacepaste

Paste details

reply | raw

  1.  
  2. if rdc == True:
  3. sql = "SELECT * FROM INTERVENTIONS_GEO_UNITES_RDC" + arg1
  4. cursor.execute(sql)
  5. rows = cursor.fetchall()
  6. avec_rdc = (row for row in rows if rdc == True)
  7. for row in avec_rdc:
  8. trow = iCur.newRow()
  9. trow.INCIDENT_N = row[0]
  10. trow.DATE_INTER = row[2]
  11. trow.ADRESSE_IN = row[3]
  12. trow.TYPE_INT = row[4]
  13. trow.CAS_NO = row[5]
  14. trow.REGION = row[6]
  15. trow.CATEGORIE = row[7]
  16. trow.SITE_KEY = row[8]
  17. trow.ARRONDISSE = row[9]
  18. trow.LISTE_UNIT = row[11]
  19. trow.LONGITUDE = row[12]
  20. trow.LATITUDE = row[13]
  21. iCur.insertRow(trow)
  24. else:
  25. sql = "SELECT * FROM INTERVENTIONS_GEO_UNITES WHERE " + arg1
  26. cursor.execute(sql)
  27. rows = cursor.fetchall()
  28. sans_rdc = (row for row in rows if rdc == False)
  29. for row in sans_rdc:
  30. trow = iCur.newRow()
  31. trow.INCIDENT_N = row[0]
  32. trow.DATE_INTER = row[1]
  33. trow.ADRESSE_IN = row[2]
  34. trow.TYPE_INT = row[3]
  35. trow.CAS_NO = row[4]
  36. trow.REGION = row[5]
  37. trow.CATEGORIE = row[6]
  38. trow.SITE_KEY = row[7]
  39. trow.ARRONDISSE = row[8]
  40. trow.LISTE_UNIT = row[9]
  41. trow.LONGITUDE = row[10]
  42. trow.LATITUDE = row[11]
  43. iCur.insertRow(trow)
  44.  
Powered by spacepaste. Paste removal.