sikuli-driver team mailing list archive

[Fabian <question216578@xxxxxxxxxxxxxxxxxxxxx>]

New question #216578 on Sikuli:
https://answers.launchpad.net/sikuli/+question/216578

Hi all,

I want to run a command via os.popen but I have some issue with quote.
I want to launch this following command : osql -S bsgen810ciiw -d GenesysMCR -U sa -P sa -Q "delete from interactions where media_type='chat';update interaction set status=3 where mediatypeid='chat'"

So in Sikuli, I tried following FAQ (https://answers.launchpad.net/sikuli/+faq/1739) :
import os
os.popen(r'osql -S bsgen810ciiw -d GenesysMCR -U sa -P sa -Q "delete from interactions where media_type='chat';update interaction set status=3 where mediatypeid='chat'"')

and I get :
"[error] Message d'erreur : SyntaxError: ("no viable alternative at input 'chat'", ('C:\\DOCUME~1\\genesys\\LOCALS~1\\Temp\\sikuli-tmp2163128831477251045.py', 2, 105, 'os.popen(r\'osql -S bsgen810ciiw -d GenesysMCR -U sa -P sa -Q "delete from interactions where media_type=\'chat\';update interaction set status=3 where mediatypeid=\'chat\'"\')\n'))"

Is someone has any idea ?


-- 
You received this question notification because you are a member of
Sikuli Drivers, which is an answer contact for Sikuli.