Hallo Gary,
my Database
mysql> DESC archive;
+----------------------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------+------+-----+---------+-------+
| dateTime | int(11) | NO | PRI | NULL | |
| usUnits | int(11) | NO | | NULL | |
| interval | int(11) | NO | | NULL | |
| barometer | double | YES | | NULL | |
| pressure | double | YES | | NULL | |
| altimeter | double | YES | | NULL | |
| inTemp | double | YES | | NULL | |
| outTemp | double | YES | | NULL | |
| inHumidity | double | YES | | NULL | |
| outHumidity | double | YES | | NULL | |
| windSpeed | double | YES | | NULL | |
| windDir | double | YES | | NULL | |
| windGust | double | YES | | NULL | |
| windGustDir | double | YES | | NULL | |
| rainRate | double | YES | | NULL | |
| rain | double | YES | | NULL | |
| dewpoint | double | YES | | NULL | |
| windchill | double | YES | | NULL | |
| heatindex | double | YES | | NULL | |
| ET | double | YES | | NULL | |
| radiation | double | YES | | NULL | |
| UV | double | YES | | NULL | |
| extraTemp1 | double | YES | | NULL | |
| extraTemp2 | double | YES | | NULL | |
| extraTemp3 | double | YES | | NULL | |
| soilTempO1 | double | YES | | NULL | |
| soilTempO2 | double | YES | | NULL | |
| soilTempO3 | double | YES | | NULL | |
| soilTempO4 | double | YES | | NULL | |
| soilTempO5 | double | YES | | NULL | |
| leafTemp1 | double | YES | | NULL | |
| leafTemp2 | double | YES | | NULL | |
| extraHumid1 | double | YES | | NULL | |
| extraHumid2 | double | YES | | NULL | |
| soilMoist1 | double | YES | | NULL | |
| soilMoist2 | double | YES | | NULL | |
| soilMoist3 | double | YES | | NULL | |
| soilMoist4 | double | YES | | NULL | |
| leafWet1 | double | YES | | NULL | |
| leafWet2 | double | YES | | NULL | |
| rxCheckPercent | double | YES | | NULL | |
| txBatteryStatus | double | YES | | NULL | |
| consBatteryVoltage | double | YES | | NULL | |
| hail | double | YES | | NULL | |
| hailRate | double | YES | | NULL | |
| heatingTemp | double | YES | | NULL | |
| heatingVoltage | double | YES | | NULL | |
| supplyVoltage | double | YES | | NULL | |
| referenceVoltage | double | YES | | NULL | |
| windBatteryStatus | double | YES | | NULL | |
| rainBatteryStatus | double | YES | | NULL | |
| outTempBatteryStatus | double | YES | | NULL | |
| lighting | double | YES | | NULL | |
| extraTemp4 | double | YES | | NULL | |
| extraTemp5 | double | YES | | NULL | |
| extraTemp6 | double | YES | | NULL | |
| extraTemp7 | double | YES | | NULL | |
| extraTemp8 | double | YES | | NULL | |
| extraTemp9 | double | YES | | NULL | |
| maxSolarRad | double | YES | | NULL | |
| cloudbase | double | YES | | NULL | |
| humidex | double | YES | | NULL | |
| appTemp | double | YES | | NULL | |
| windrun | double | YES | | NULL | |
| beaufort | double | YES | | NULL | |
| inDewpoint | double | YES | | NULL | |
| inTempBatteryStatus | double | YES | | NULL | |
| sunshinehours | double | YES | | NULL | |
| sunshineS | double | YES | | NULL | |
| snow | double | YES | | NULL | |
| snowRate | double | YES | | NULL | |
| snowTotal | double | YES | | NULL | |
| wetBulb | double | YES | | NULL | |
| cbIndex | double | YES | | NULL | |
| airDensity | double | YES | | NULL | |
| windDruck | double | YES | | NULL | |
| soilTemp1 | double | YES | | NULL | |
| soilTemp2 | double | YES | | NULL | |
| soilTemp3 | double | YES | | NULL | |
| soilTemp4 | double | YES | | NULL | |
| soilTemp5 | double | YES | | NULL | |
+----------------------+---------+------+-----+---------+-------+
81 rows in set (0.00 sec)
My database has been expanded with the time of me and also
the other databases AirQuality Forecast Snow
I'm looking for a version like
"""
For "first Time in weewx-database" to "last Time in weewx-database" step 1:
cursor.execute("UPDATE archive SET maxSolarRad = %s WHERE dateTime = %s",
("123.98", "1394092770"))
cursor.execute("UPDATE archive SET windRun = %s WHERE dateTime = %s",
("233.08", "1394092770"))
cursor.execute("UPDATE archive SET cdIndex = %s WHERE dateTime = %s",
("45.7", "1394092770"))
"""
Hartmut
