print "-------------------------------------------------------"
print "DataReadWrite.insertCrucibleMeasurement()"
value = DataReadWrite.insertCrucibleMeasurement(i_runID,i_positionNumber,f_weight,v_status,f_temperature,f_humidity,f_pressure,f_light, total_count,d_datetime)
test += 1
if value is False:
print "FAIL"
else:
print "PASS"
passed += 1
print "-------------------------------------------------------"
v_status="Prefire"
# Now do an insert for tblSample for each sample include--- from here on we can then just update the record.
sampleID = DataReadWrite.insertNewSample(i_runID,i_positionNumber,v_description,d_datetime,
v_locationCode,i_preOrPost,i_loggingInterval,f_temperature,
f_humidity,v_status,i_preMeasurementTimeInterval,i_repetitions)
print ("insertNewSample(",i_runID,",",i_positionNumber,",",v_description,",",d_datetime,",",
v_locationCode,",",i_preOrPost,",",i_loggingInterval,",",f_temperature,",",
f_humidity,",",v_status,",",i_preMeasurementTimeInterval,",",i_repetitions,")")
print "insertNewSample() -- results: Sample ID: ",sampleID
test += 1
if sampleID>0:
print "PASS"
passed += 1
else:
print "FAIL"
weight=12.2091
def go_preFire():
dbName=DATABASENAME.get()
dbDir=DBDIRECTORY.get()
value=DataReadWrite.openDatabase(dbDir,dbName)
if value is False:
logger.error("There has been an error since openDatabase returned FALSE")
alert.deiconify()
Message(alert,text="There has been a problem. Cannot create database", bg='red', fg='ivory', relief=GROOVE)
runID=int(RUNID.get())
if (runID<1):
alert.deiconify()
alert.title("Alert: No RunID Number!")
Message(alert,text="You must have a RunID to continue.", bg='red', fg='ivory', relief=GROOVE).grid(row=0,column=0,sticky=E+W+N+S)
##Button(alert, text="Continue", command=backToMainWindow).grid(row=1,column=0)
##Button(alert, text="Quit", command=KillProgram).grid(row=1,column=1)
logger.debug("You must have a RunID entered in order to continue.")
return False;
preOrPost=1
status="prefire"
setInitials=str(INITIALS.get())
startPosition=int(START_POSITION.get())
setName=str(NAME.get())
setLocation=str(LOCATION.get())
intervalsec=int(INTERVAL.get())
numberOfSamples=int(NUMBEROFSAMPLES.get())
repetitions=int(REPS.get())
duration=int(DURATION.get())
setTemperature=float(TEMP.get())
setHumidity=float(HUMIDITY.get())
standardTemp=float(RHTEMP2000TEMP.get())
standardRH=float(RHTEMP2000HUMIDITY.get())
temp=xyzRobot.getTemperature()
humidity=xyzRobot.getHumidity()
tempCorrection=standardTemp-temp
rhCorrection=standardRH-humidity
now = datetime.today()
today = now.strftime("%m-%d-%y %H:%M:%S")
if (startPosition==""):
startPosition=1
runID=DataReadWrite.updateRunPreFire(runID,setInitials,setName,today,
setLocation,preOrPost,intervalsec,setTemperature,setHumidity,
status,duration,numberOfSamples,repetitions,startPosition)
if (runID == False):
logger.error("There has been an error since updateRunPreFire returned FALSE")
alert.deiconify()
Message(alert,text="There has been a problem. The arm has returned to Home.", bg='red', fg='ivory', relief=GROOVE).grid(row=0,column=0,sticky=W+E+N+S)
##Button(alert, text="Continue", command=backToMainWindow).grid(column=1,row=0)
##Button(alert, text="Quit", command=KillProgram).grid(row=1,column=1)
count=1
repeat=0
while (count < (numberOfSamples+1)):
(meanWeight, stdevWeight) = DataReadWrite.getCrucibleWeightStats(runID,count)
# Now do an insert for tblSample for each sample include--- from here on we can then just update the record.
sampleID = DataReadWrite.insertNewSample(runID,count,setName,now,setLocation,preOrPost,intervalsec,setTemperature,setHumidity,status,duration,repetitions,meanWeight,stdevWeight)
if (sampleID is False):
logger.error("There has been an error since insertNewSample returned FALSE")
alert.deiconify()
Message(alert,text="There has been a problem. The arm has returned to Home.", bg='red', fg='ivory', relief=GROOVE).grid(row=0,column=0,sticky=W+E+N+S)
##Button(alert, text="Continue", command=backToMainWindow).grid(column=1,row=0)
##Button(alert, text="Quit", command=KillProgram).grid(row=1,column=1)
break
count += 1
repeat=0
## repeat as many times as asked (all of the crucibles)
while repeat < repetitions:
weighAllSamplesPreFire(runID,duration,intervalsec,
numberOfSamples,startPosition,standardTemp,
standardRH,repeat,
robotStatus,POSITION,MCOUNT,CURRENTSTEP,
STATUS,DURATION,LOGGERINTERVAL,RUNID,
NUMBEROFSAMPLES,TIMEREMAINING,CYCLE,MEAN,STDEV,VARIANCE)
repeat += 1
#prefire.update_windows()
prefire.withdraw()
return True
