Hallo Hartmut,
Good. You definitely have the 3 fields in your archive.
I have just re-read your earlier posts to see where we are at and now I am
a little confused. Am I correct in believing you have two databases? Are
you now trying to copy maxSolarRad, cloudbase and windrun data from one
database to the other? Sorry, but is important to understand exactly what
you have and what you are trying to do so that I don't give you incorrect
advice.
By the way, don't worry that your English is not good, my German is not
good either!
Gary
On Tuesday, 7 March 2017 15:49:10 UTC+10, Hartmut Schweidler wrote:
>
> 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
>
>
>
>
>
