Re: [Sikuli-driver] [Question #214110]: Linking To Postgres
Question #214110 on Sikuli changed: https://answers.launchpad.net/sikuli/+question/214110 Status: Answered = Solved James confirmed that the question is solved: Hi RaiMan, Found Guide here. I dont know if its one you helped with previously. http://www.codingourweb.com/read-and-write-to-a-mysql-database-from- sikuli/ Followed the guide had to paste in an extra file msvcr100.dll (Search on hard drive find it and just paste into jbdc) commands run in dos box C:\JBDCjar xf mysql-connector-java-5.1.18-bin.jar (I didnt know how to extract a jar untill I went and looked it up) C:\JBDCjar uf sikuli-script.jar com C:\JBDCjar uf sikuli-script.jar org Rename the correct sikuli-script.jar in c:\program files\sikuli x\ and paste in the new one. One connection to the data base and was able to read it. Very excited now. Other links used http://docs.oracle.com/javase/tutorial/deployment/jar/unpack.html To get round windows 7 issues I cheated. Installed virtual box(open source) - installed xp on it using my old key. (Virtual machines believe require licenses to run, if you dont have one check a version of linux that is known to work with sikuli). Xamp - Installs apache web server mysql for you. http://www.apachefriends.org/en/xampp.html (Open source product) As you can tell from this I am not a programmer but was able to muddle through. I am not sure what damage I have done to sikuli in doing this I will await the shouting. Dont think I broke any laws in the process of this. Thank you for you help am still giving this a try out but thought I cant be the only one looking at things like this. -- You received this question notification because you are a member of Sikuli Drivers, which is an answer contact for Sikuli. ___ Mailing list: https://launchpad.net/~sikuli-driver Post to : sikuli-driver@lists.launchpad.net Unsubscribe : https://launchpad.net/~sikuli-driver More help : https://help.launchpad.net/ListHelp
Re: [Sikuli-driver] [Question #214110]: Linking To Postgres
Question #214110 on Sikuli changed: https://answers.launchpad.net/sikuli/+question/214110 RaiMan posted a new comment: Congratulations. It is ok, if it works for you. You did not do any damage to Sikuli, you only added some additional class files to the existing sikuli-script.jar (which is only a special compressed version of some Java stuff). Usually one would have done the mysql-connector-java-5.1.18-bin.jar somewhere on the java class path (that's what it is for). So you now have a modified sikuli-script.jar and you have to repeat the whole procedure if you either want to use a new sikuli-script.jar or another db-driver. I do not know, what problems the guy from the mentioned post had with the java class path, that he had to invent this strange way. But if it is ok for you ;-) -- You received this question notification because you are a member of Sikuli Drivers, which is an answer contact for Sikuli. ___ Mailing list: https://launchpad.net/~sikuli-driver Post to : sikuli-driver@lists.launchpad.net Unsubscribe : https://launchpad.net/~sikuli-driver More help : https://help.launchpad.net/ListHelp
[Sikuli-driver] [Question #214110]: Linking To Postgres
New question #214110 on Sikuli: https://answers.launchpad.net/sikuli/+question/214110 The theory behind this one is to push and pull data in and out of Postgres. So connect retrieve next test step expected result perform action connect back to Postgres update fields (time actual result test performed etc) - not in that exact order but you get the idea. Having dug around the reading documents only 2 modules exist that could do this. A jpthon one and a Java driver. I tried downloading these and just dropping them into the sikuli x program folder and importing them. Allows the import with a little fiddling but have been unable to make use of the actual drivers to contact a database. Was trying zxjbdc Does anyone have any guides or documents for doing this? Possible work around is to use something else to push it into spread sheets update the spread sheet and push it back afterwards but is allot of work using third party or custom parts to do this. A little help if you could please. -- You received this question notification because you are a member of Sikuli Drivers, which is an answer contact for Sikuli. ___ Mailing list: https://launchpad.net/~sikuli-driver Post to : sikuli-driver@lists.launchpad.net Unsubscribe : https://launchpad.net/~sikuli-driver More help : https://help.launchpad.net/ListHelp
Re: [Sikuli-driver] [Question #214110]: Linking To Postgres
Question #214110 on Sikuli changed: https://answers.launchpad.net/sikuli/+question/214110 Status: Open = Answered RaiMan proposed the following answer: Depending on what you want to push/pull, your need about persistence and about content preparation/evaluation there are many alternatives that can be supported easily in Jython/Python - csv files or JSON (instead of spreadsheets and db's) - objects/classes and marshalling - key/value stores (or simply a Python dictionary) ... and there we have all these testing frameworks like RobotFrameWork, Cocumber based stuff, ... that might help in that direction. -- You received this question notification because you are a member of Sikuli Drivers, which is an answer contact for Sikuli. ___ Mailing list: https://launchpad.net/~sikuli-driver Post to : sikuli-driver@lists.launchpad.net Unsubscribe : https://launchpad.net/~sikuli-driver More help : https://help.launchpad.net/ListHelp
Re: [Sikuli-driver] [Question #214110]: Linking To Postgres
Question #214110 on Sikuli changed: https://answers.launchpad.net/sikuli/+question/214110 James posted a new comment: Hi RaiMan, Am having a look into http://www.tutorialspoint.com/python/python_dictionary.htm as looked at cocumber and it is not going to be suitable for the interfaces I need to link to. Sorry windows 7 machine has point blank refused a sikuli install so far but hoping to get away without any extra modules being needed for a Python dictionary? Thanks for a quick answer. -- You received this question notification because you are a member of Sikuli Drivers, which is an answer contact for Sikuli. ___ Mailing list: https://launchpad.net/~sikuli-driver Post to : sikuli-driver@lists.launchpad.net Unsubscribe : https://launchpad.net/~sikuli-driver More help : https://help.launchpad.net/ListHelp
Re: [Sikuli-driver] [Question #214110]: Linking To Postgres
Question #214110 on Sikuli changed: https://answers.launchpad.net/sikuli/+question/214110 RaiMan proposed the following answer: --1 if you do not get Sikuli running: faq 2005 --2 you talked about testing, ... ... so I thought you are already using some kind of unittesting support. --3 you need some programming knowledge ... for this kind of approach - according Sikuli either Python or Java So if you can be more concrete, come back for more information. BTW: the connection to Postgress should be possible with the appropriate drivers, if you really need it. -- You received this question notification because you are a member of Sikuli Drivers, which is an answer contact for Sikuli. ___ Mailing list: https://launchpad.net/~sikuli-driver Post to : sikuli-driver@lists.launchpad.net Unsubscribe : https://launchpad.net/~sikuli-driver More help : https://help.launchpad.net/ListHelp
