Exemple #1
0
def add_data_VMI(SPEC):
    if len(str(SPEC)) != 4:
        return 'SPEC LENGTH ERROR, PLEASE CHECK'

    conn = sqlite3.Connection(
        'c:/users/sxchen/desktop/PartsChangeInformation/main.db')
    conn.text_factory = lambda x: unicode(x, "utf-8", "ignore")
    cur = conn.cursor()

    #COUNT could find records of database,but the row [SPEC,0,0,0,0,0,0,0,0] also need to handle
    sql = "SELECT * FROM tb1 WHERE SPEC = '%s'" % SPEC
    sql2 = "SELECT COUNT(*) FROM tb1"
    sql3 = "SELECT COUNT(*) FROM tb1 WHERE SPEC = %s" % SPEC
    sql4 = '''INSERT INTO tb1 (SPEC,MACHINE_TYPE,DIM,CENTER_DECK,PUSHOVER_CAN,SIDE_RING,BT_ADD,TRANSFER_RING,BO_PUSH_CAN)
              VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s');'''
    sql5 = '''UPDATE tb1
              SET SPEC='%s',
                  MACHINE_TYPE='%s',
                  DIM='%s',
                  CENTER_DECK='%s',
                  PUSHOVER_CAN='%s',
                  SIDE_RING='%s',
                  BT_ADD='%s',
                  TRANSFER_RING='%s',
                  BO_PUSH_CAN='%s'
              WHERE (MACHINE_TYPE='VMI'
              AND SPEC='%s');'''

    num, = cur.execute(sql3).fetchall()[0]

    res = extra_info(SPEC)
    res2 = []
    res2.extend(res)
    res2.append(SPEC)

    #print res2
    if num > 0:
        print SPEC, 'ALREADY EXISTED\n'
        print 'TRYING TO UPDATE...'
        cur.execute(sql5 % tuple(res2))
        print 'UPDATED!'
    else:
        cur.execute(sql4 % tuple(res))

    #cur.close()
    conn.commit()
def add_data_VMI(SPEC):
    if len(str(SPEC)) != 4:
        return "SPEC LENGTH ERROR, PLEASE CHECK"

    conn = sqlite3.Connection("c:/users/sxchen/desktop/PartsChangeInformation/main.db")
    conn.text_factory = lambda x: unicode(x, "utf-8", "ignore")
    cur = conn.cursor()

    # COUNT could find records of database,but the row [SPEC,0,0,0,0,0,0,0,0] also need to handle
    sql = "SELECT * FROM tb1 WHERE SPEC = '%s'" % SPEC
    sql2 = "SELECT COUNT(*) FROM tb1"
    sql3 = "SELECT COUNT(*) FROM tb1 WHERE SPEC = %s" % SPEC
    sql4 = """INSERT INTO tb1 (SPEC,MACHINE_TYPE,DIM,CENTER_DECK,PUSHOVER_CAN,SIDE_RING,BT_ADD,TRANSFER_RING,BO_PUSH_CAN)
              VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s');"""
    sql5 = """UPDATE tb1
              SET SPEC='%s',
                  MACHINE_TYPE='%s',
                  DIM='%s',
                  CENTER_DECK='%s',
                  PUSHOVER_CAN='%s',
                  SIDE_RING='%s',
                  BT_ADD='%s',
                  TRANSFER_RING='%s',
                  BO_PUSH_CAN='%s'
              WHERE (MACHINE_TYPE='VMI'
              AND SPEC='%s');"""

    num, = cur.execute(sql3).fetchall()[0]

    res = extra_info(SPEC)
    res2 = []
    res2.extend(res)
    res2.append(SPEC)

    # print res2
    if num > 0:
        print SPEC, "ALREADY EXISTED\n"
        print "TRYING TO UPDATE..."
        cur.execute(sql5 % tuple(res2))
        print "UPDATED!"
    else:
        cur.execute(sql4 % tuple(res))

    # cur.close()
    conn.commit()
    def add_data_VMI(self, SPEC):
        if len(str(SPEC)) != 4:
            return 'SPEC LENGTH ERROR, PLEASE CHECK'

        #COUNT could find records of database,but the row [SPEC,0,0,0,0,0,0,0,0] also need to handle
        sql = "SELECT * FROM tb1 WHERE SPEC = '%s'" % SPEC
        sql2 = "SELECT COUNT(*) FROM tb1"
        sql3 = "SELECT COUNT(*) FROM tb1 WHERE SPEC = %s" % SPEC
        sql4 = '''INSERT INTO tb1 (SPEC,MACHINE_TYPE,DIM,CENTER_DECK,PUSHOVER_CAN,SIDE_RING,BT_ADD,TRANSFER_RING,BO_PUSH_CAN)
	              VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s');'''
        sql5 = '''UPDATE tb1
	              SET SPEC='%s',
	                  MACHINE_TYPE='%s',
	                  DIM='%s',
	                  CENTER_DECK='%s',
	                  PUSHOVER_CAN='%s',
	                  SIDE_RING='%s',
	                  BT_ADD='%s',
	                  TRANSFER_RING='%s',
	                  BO_PUSH_CAN='%s'
	              WHERE (MACHINE_TYPE='VMI'
	              AND SPEC='%s');'''

        num, = self.cur.execute(sql3).fetchall()[0]

        res = extra_info(SPEC)
        res2 = []
        res2.extend(res)
        res2.append(SPEC)

        #print res2
        if num > 0:
            print SPEC, 'ALREADY EXISTED\n'
            print 'TRYING TO UPDATE...'
            self.cur.execute(sql5 % tuple(res2))
            print 'UPDATED!'
        else:
            self.cur.execute(sql4 % tuple(res))
def api(SPEC):
    data = extra_info(SPEC)
    return render_template('api.html',data = data)
def api(SPEC):
    data = extra_info(SPEC)
    return render_template('api.html', data=data)