있는데요.<br>5건의 데이터를 하나로 합쳐서 보내는데 이게 처음 몇번은 잘 되는데 여러번 반복하다보니까 리스트 범위 초과 오류가 나오더라구요<br><br>Traceback (most recent call last):<br> File "D:\Eclipse workspace\maketempdata\outlet\transoutlet_val_samsung.py", line 111, in <module><br> del result[6]<br>IndexError: list assignment index out of range<br><br>파이썬은 이제 접한지 2주가 되었는데 킁....<br><br>무엇이 잘못 됬는지 좀 알려주세요 ㅠ<br><br>많이 잘못 됬겠지만... 디비 접속 관련 부분은 다 뺐습니다.<br><br>------<br>gate = ('1', '2', '3')<br>plc = ('1', '2', '3', '4')<br>relayn = ('1', '2', '3', '4')<br>resultindex = [0,1,2,3,4,5,6,7]<br>minute = 5<br><br>selectquery = "SELECT * FROM samsung WHERE gatecode = %(gatecode)s AND plccode = %(plccode)s AND relaynum = %(relaynum)s"<br>insertquery = "INSERT INTO samsung (gatecode, plccode, relaynum, date, amp, state, power) VALUES(%(gatecode)s, %(plccode)s, %(relaynum)s, %(date)s, %(amp)s, %(state)s, %(power)s)"<br>searchquery = "SELECT count(*) FROM samsung WHERE gatecode = %(gatecode)s AND plccode = %(plccode)s AND relaynum = %(relaynum)s"<br><br>item_count = 0<br>for gaco in gate:<br> for plccode in plc:<br> for relay in relayn:<br> factor={<br> "gatecode": gaco,<br> "plccode": plccode,<br> "relaynum": relay,<br> }<br> with fromdb.cursor() as cur:<br> cur.execute(searchquery,factor)<br> searchtemp = cur.fetchone()<br> item_count = searchtemp[0]<br> cur.execute(selectquery,factor)<br> temp = cur.fetchmany(minute)<br><br> print(temp)<br> fromdb.commit()<br> <br> with fordb.cursor() as cur:<br> cur.execute(searchquery,factor)<br> searchtemp = cur.fetchone()<br> item_count = searchtemp[0]<br> result = []<br> tempinresult = 0.0<br> while(1):<br> if(item_count < len(temp)):<br> result.insert (0,temp[0][0])<br> result.insert (1,temp[0][1])<br> result.insert (2,temp[0][2])<br> result.insert (3,temp[0][3])<br> result.insert (4,'0')<br> result.insert (5,temp[0][5])<br> result.insert (6,'0')<br> tempinresult = tempinresult + float(temp[item_count][4])<br> print("+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+")<br> item_count = item_count + 1<br> else:<br> del result[4]<br> result.insert(4, "{0:.4f}".format(tempinresult))<br> del result[6]<br> tempinresult = float(tempinresult) * 220 <br> result.insert(6, "{0:.2f}".format(tempinresult))<br> tempinresult = 0.0<br> break<br><br> outlet_val={<br> "gatecode": result[0],<br> "plccode": result[1],<br> "relaynum": result[2],<br> "date": result[3],<br> "amp": result[4],<br> "state": result[5],<br> "power": result[6],<br> }<br> cur.execute(insertquery,outlet_val)<br> fordb.commit()<br> del result[0:6]<br> del result[6]<br>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.