Example #1
0
def insertAdvMaxMin(advMaxMinlist):
    applyfordate=datetime.datetime.now().strftime('%Y-%m-%d')
    remarks = ''
    verifydate = ''
    if len(advMaxMinlist)>0:
        for line in advMaxMinlist:
            confsql.insertAdvMaxMin(line[0], line[1], line[2], line[3], line[4], line[5], applyfordate, verifydate, remarks)
Example #2
0
def updateMaxMin(datalist):
    remarks = 'save'
    verifydate = datetime.datetime.now().strftime('%Y-%m-%d')

    for x in datalist:        
        confsql.maxmin_update(x[1], x[3], x[5], x[6], x[7], x[8])
        confsql.insertAdvMaxMin(x[1], x[3], x[5], x[6], x[7], x[8], x[9], verifydate, remarks)
Example #3
0
def updateMaxMin(datalist):
    remarks = 'save'
    verifydate = datetime.datetime.now().strftime('%Y-%m-%d')

    for x in datalist:
        confsql.maxmin_update(x[1], x[3], x[5], x[6], x[7], x[8])
        confsql.insertAdvMaxMin(x[1], x[3], x[5], x[6], x[7], x[8], x[9],
                                verifydate, remarks)
Example #4
0
def setadvMaxMin(datalist):
    remarks = 'del'
    verifydate = datetime.datetime.now().strftime('%Y-%m-%d')

    for x in datalist:

        #cachedAdvMaxMin(x[1], x[3], x[5], x[6], x[7], x[8])
        confsql.insertAdvMaxMin(x[1], x[3], x[5], x[6], x[7], x[8], x[9], verifydate, remarks)
Example #5
0
def insertAdvMaxMin(advMaxMinlist):
    applyfordate = datetime.datetime.now().strftime('%Y-%m-%d')
    remarks = ''
    verifydate = ''
    if len(advMaxMinlist) > 0:
        for line in advMaxMinlist:
            confsql.insertAdvMaxMin(line[0], line[1], line[2], line[3],
                                    line[4], line[5], applyfordate, verifydate,
                                    remarks)
Example #6
0
def setadvMaxMin(datalist):
    remarks = 'del'
    verifydate = datetime.datetime.now().strftime('%Y-%m-%d')

    for x in datalist:

        #cachedAdvMaxMin(x[1], x[3], x[5], x[6], x[7], x[8])
        confsql.insertAdvMaxMin(x[1], x[3], x[5], x[6], x[7], x[8], x[9],
                                verifydate, remarks)