sikuli-driver team mailing list archive

[Muthumanikandan <question653769@xxxxxxxxxxxxxxxxxxxxx>]

Question #653769 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/653769

    Status: Answered => Open

Muthumanikandan is still having a problem:
I debug the code with print statement, my analysis are:

Script:

import xlrd
import datetime
EXCELFILE = "D:\\Muthu\\Datamanipulation\\book2.xlsx"
book = xlrd.open_workbook(EXCELFILE)
sheet = book.sheet_by_index(0)
for rx in range(sheet.nrows):
 value = sheet.cell_value(rx,33)
 print(value) ## till this code prints column 33 all values (col 33 having 2 executable queries)

text_file = open("Output.sql", "w")
text_file.write(value) ## Here i am passing the column 33 values=2 executable queries
text_file.write(Key.ENTER)
text_file.write("/")
text_file.write("\ncommit;")
text_file.close()

batch_file=open("Script.bat","w")
batch_file.write("set NetPath=%~dp0")
batch_file.write("\n@echo off")
batch_file.write("\nsqlplus -L GPCPRD/HEROGPC@DB10:1521/ORCL.CORP.SIERRATEC.COM @%NetPath%/Output.sql")
batch_file.write("\nexit")
batch_file.close()

openApp("Script.bat")
wait(2)
print (value) # issue is here , here script prints only one value column 33 last value

Can anyone help to solve this problem:

text_file.write(value) ## while passing multiple values to DB it accepts
only last value.sometimes empty values passing but commit succesfull.

For screenshots refer below link:  
https://screencast-o-matic.com/watch/cbjni8lB0B

-- 
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.