[wtr-general] Re: Data driven framework using SQL database
Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Data driven framework using SQL database
you have to download the dbi files and configure them on your machine. On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Data driven framework using SQL database
Hi, Thank you very much.now am able to connect to the database and retrieve the data... Thanks again. On Oct 30, 12:25 pm, SMF SMF shaikm.fi...@gmail.com wrote: you have to download the dbi files and configure them on your machine. On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Data driven framework using SQL database
Hi Pritam, No problem. Could you please do one favor, can you post the steps/configuration you followed to connect to database that will helpful to others also. Thanks, smf On Fri, Oct 30, 2009 at 1:58 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you very much.now am able to connect to the database and retrieve the data... Thanks again. On Oct 30, 12:25 pm, SMF SMF shaikm.fi...@gmail.com wrote: you have to download the dbi files and configure them on your machine. On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Data driven framework using SQL database
Yes, it works, but I have to change Uid as User ID, Pw as password. Thanks. Wesley Chen. For life, the easier, the better. On Fri, Oct 30, 2009 at 4:53 PM, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, No problem. Could you please do one favor, can you post the steps/configuration you followed to connect to database that will helpful to others also. Thanks, smf On Fri, Oct 30, 2009 at 1:58 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you very much.now am able to connect to the database and retrieve the data... Thanks again. On Oct 30, 12:25 pm, SMF SMF shaikm.fi...@gmail.com wrote: you have to download the dbi files and configure them on your machine. On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] New to Watir Scripting
How to pass data from Open office org sheet to a application..Need clear information about the data driven --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: good link on watir.
On Fri, Oct 30, 2009 at 6:44 AM, Pallavi Sharma write2pall...@gmail.com wrote: Anyone seen this link: http://justaddwatir.com/watir/ quite useful and interesting. Pallavi, Thanks for the link, it is already listed at http://watir.com/blogs/ with a few blogs that also post a lot about Watir. Željko -- watir.com - community manager watirpodcast.com - host --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Ci_reporter on watircraft
Hi Graeme, Can you tell me how did you do it for cucumber so that i can get some idea of incorporating the same in watircraft. Regards, Pallavi On Sep 10, 2:53 pm, pallavi shashidhar pals.sha...@gmail.com wrote: Hi, I did update to ci_reporter 1.6.0 and at the command prompt, i give the foll command: rake ci:setup:cucumber features and it gives me the foll errors: rm -rf features/reports c:/ruby/bin/ruby -I c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/lib;lib c: /ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/cucumber --require c:/ruby/li b/ruby/gems/1.8/gems/ci_reporter-1.6.0/lib/ci/reporter/rake/cucumber_loader.rb - -format CI::Reporter::Cucumber test/features/cc_register_complaint.feature test/ features/cc_update_complaint.feature test/features/cell_operator_view_complaint. feature test/features/citizen_register_complaint.feature test/features/citizen_u pdate_complaint.feature test/features/citizen_view_complaint.feature test/featur es/city_official_login.feature test/features/city_official_register_complaint.fe ature test/features/city_official_update_complaint.feature test/features/city_of ficial_view_complaints.feature test/features/city_official_view_status_reports.f eature test/features/GO_update_complaint.feature test/features/GO_update_users_c omplaint.feature test/features/official_change_password.feature undefined method `testcases' for nil:NilClass (NoMethodError) c:/ruby/lib/ruby/gems/1.8/gems/ci_reporter-1.6.0/lib/ci/reporter/rake/../../../c i/reporter/cucumber.rb:93:in `visit_step' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/step_coll ection.rb:15:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/step_coll ection.rb:14:in `each' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/step_coll ection.rb:14:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:75:in `visit_steps' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/backgroun d.rb:30:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:49:in `visit_background' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/feature.r b:23:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:23:in `visit_feature' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:25:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:13:in `each' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:13:in `each' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:24:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:19:in `visit_features' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:9:in `__send__' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:9:in `method_missing' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:8:in `map' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:8:in `method_missing' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/cli/main.rb:5 8:in `execute!' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/cli/main.rb:2 6:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/cucumber:9 rake aborted! Command failed with status (1): [c:/ruby/bin/ruby -I c:/ruby/lib/ruby/gems...] (See full trace by running task with --trace) Is the usage for rake features correct? Regards, Pallavi On Thu, Sep 10, 2009 at 3:14 PM, Graeme Mathieson, Rubaidh Ltd mat...@woss.name wrote: Hi, Our changes to ci_reporter to support cucumber output have been merged back into Nick's upstream version, and released as 1.6.0. No idea why it's not showing up in the master branch, though! We're still using the XML output from ci_reporter for cucumber and rspec features, and it's working well for us. If you have any problems getting it set up, give me a yell and I'll see if I can help. Cheers, Graeme. On Sep 9, 5:43 pm, Charley Baker charley.ba...@gmail.com wrote: It appears there's a forked version of ci_reporter on github that adds support for cucumber output, find out more here: http://github.com/rubaidh/ci_reporter/tree/master I'm not using ci_reporter any longer, just straight html output for cuke and rspec, but the general idea is to set it up in your rake file with the appropriate requires; there's info in the readme on that github repo. According to the 1.6.0 announcement of ci_reporter on rubyforge this appears to be the version they've uploaded as the latest gem. hth, Charley On Tue, Sep 8, 2009 at 11:21 PM, pallavi
[wtr-general] Re: Safriwatir issue with clicking links
On Thu, Oct 29, 2009 at 5:47 PM, QAguy qablogm...@gmail.com wrote: This highlights the link in the browser window yellow but doesn't actual cause the click action to occur, I'm using safariwatir. Really, I reproduced it too: b.link(:id, signout_link).click = nil This is probably a bug. List of open bugs is here: http://jira.openqa.org/browse/WTR/component/10490 This worked for me: browser.link(:text, Sign Out).click You can report the bug: - create openqa account at http://openqa.org/sass/create!input.action, if you do not already have one - log in - go to http://jira.openqa.org/browse/WTR/ - click `CREATE NEW ISSUE` - make sure you select `SafariWatir` in `Component/s` Željko -- watir.com - community manager watirpodcast.com - host --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Safriwatir issue with clicking links
On Fri, Oct 30, 2009 at 11:27 AM, Željko Filipin zeljko.fili...@wa-research.ch wrote: You can report the bug: No need for that, it is already reported: http://jira.openqa.org/browse/WTR-370 You can vote for it. In general, tickets with more votes get fixed first. Željko --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Data driven framework using SQL database
If the sql server port is not the default one 1433, how can we set it? In the connect string, can we set any other attribute? On 10/30/09, Wesley Chen cjq@gmail.com wrote: Yes, it works, but I have to change Uid as User ID, Pw as password. Thanks. Wesley Chen. For life, the easier, the better. On Fri, Oct 30, 2009 at 4:53 PM, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, No problem. Could you please do one favor, can you post the steps/configuration you followed to connect to database that will helpful to others also. Thanks, smf On Fri, Oct 30, 2009 at 1:58 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you very much.now am able to connect to the database and retrieve the data... Thanks again. On Oct 30, 12:25 pm, SMF SMF shaikm.fi...@gmail.com wrote: you have to download the dbi files and configure them on your machine. On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. -- Sent from my mobile device Thanks. Wesley Chen. For life, the easier, the better. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com To unsubscribe from this group, send email to watir-general+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general?hl=en -~--~~~~--~~--~--~---
[wtr-general] Re: Data driven framework using SQL database
Hi All, I have been using this to interact with SQL Server for some time now. ( Somehow I find DBI too confusing at times :-) ) See if it can be of help to anyone of you. It uses win32ole and ADODB to work with SQL Server. Looking forward to some comments about the utility. Thanks, Rohan Ojha Associate Systems Engineer Blue Star Infotech l*+91 900 4955058l * +91 22 6688 6969 l 6 +91 22 6688 6999 l * mailto:rohan.o...@bsil.com rohan.o...@bsil.com http://www.bsil.com/ www.bsil.com - Where Partnerships Are Built on Trust _ From: watir-general@googlegroups.com [mailto:watir-gene...@googlegroups.com] On Behalf Of Wesley Chen Sent: Friday, October 30, 2009 2:41 PM To: watir-general@googlegroups.com Subject: [wtr-general] Re: Data driven framework using SQL database Yes, it works, but I have to change Uid as User ID, Pw as password. Thanks. Wesley Chen. For life, the easier, the better. On Fri, Oct 30, 2009 at 4:53 PM, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, No problem. Could you please do one favor, can you post the steps/configuration you followed to connect to database that will helpful to others also. Thanks, smf On Fri, Oct 30, 2009 at 1:58 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you very much.now am able to connect to the database and retrieve the data... Thanks again. On Oct 30, 12:25 pm, SMF SMF shaikm.fi...@gmail.com wrote: you have to download the dbi files and configure them on your machine. On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote: Hi, Thank you for your reply. I have executed the code that you have given, but i got the following error. C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/ dbd/ADO) (DBI::InterfaceError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in `_get_full_driver' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' from database.rb:5 I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as indicated in the error, and could find only find ODBC and Proxy folders and not ADO. Do i need to download and copy the ADO.rb file in this location in order to access the SQL database? If yes, where can i find this file... Thanks in advance On Oct 29, 4:56 pm, SMF SMF shaikm.fi...@gmail.com wrote: Hi Pritam, Answer to your *question 1.* require 'dbi' DB = Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=pas sword sql = select LoginID from Login WHERE UserName ='xyz' DBI.connect(DBI:ADO:#{DB}) do | dbh | dbh.select_all( sql ) do |row| puts row[0] # the first field #puts row[1] # the second field end end No idea, about framework or architecture Thanks On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote: Hi guys, I am new to ruby programming, and I need help in developing data driven framework which uses sql database for retrieving data. I have seen a lot of examples over internet which showed how to do it using excel and open source applications. To start with I need information for the following. 1. How to connect to a sql database using ruby/watir scripts? 2. What sought of architecture am I looking for? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~--- sqlServerConn.rb Description: Binary data
[wtr-general] Re: Answering incomplete requests
I also monitor the watir tag at stackoverflow.com. There have been very few queries there, and if they are of slightly higher quality than the average question here, I think that it is because of the barriers to entry there (OpenID, website vs email, etc). There is another site that I think might make more sense than stackoverflow. http://testing.stackexchange.com http://testing.stackexchange.com/ is a hosted stackoverflow solution that is specific to testing. It is still young, and does not even have a watir tag yet. I don't think that either of these solutions is capable of replacing watir-general at this time. I am willing to join and contribute to a watir-beginners list. I also wonder whether some sort of FAQ posted on a regular basis, probably mainly pointing to the wiki/documentation, would help with these problems. /\/\ark _ From: watir-general@googlegroups.com [mailto:watir-gene...@googlegroups.com] On Behalf Of Željko Filipin Sent: Thursday, October 29, 2009 6:34 PM To: watir-general@googlegroups.com Subject: [wtr-general] Re: Answering incomplete requests I have been thinking about this for a long time, and it just came to me that it is related to this thread. I think the time has come to take Watir support to the next level. Have you heard about site called Stack Overflow? I use it all the time. Created by Jeff Atwood and Joel Spolsky. If you do not know who they are just google them. How it works? You log in with openid, ask question, tag it with watir. There is a feed for the tag. We subscribe to the feed and answer questions. It is the future of support. It is a very useful merge of support forum, digg and wiki with features like tagging questions, closing duplicate questions (with link to original question), voting on good questions and answers (so good and interesting questions and answers float to the top). Since it is also a wiki, questions and answers can be edited (including adding and removing tags). When you type a title for the question and start typing the body, it automatically searches the site and displays similar questions under the title. Just what we need. No more please search before you ask. The site searches for you. There are some watir questions already there, but not much. I have put some to try things out: http://stackoverflow.com/questions/tagged/watir http://stackoverflow.com/questions/tagged/firewatir Watin folks use it much more: http://stackoverflow.com/questions/tagged/watin You get points for each up vote you get. There are also badges. Makes answering questions more like a game. There is added benefit. If we get a question that is for example more ruby related, we can tag it with ruby (if it is not already tagged) and then all users that follow that tag will see it and probably answer. We could close this group, or leave it only for discussion, and move all support to Stack Overflow. We could make this group moderated, and approve only discussion posts, and reject all support with a note to post ti to Stack Overflow. If we agree on that, I volunteer to do that for the next month, and probably longer if needed. More information: http://stackoverflow.com/ http://blog.stackoverflow.com/ http://blog.stackoverflow.com/category/podcasts/ http://en.wikipedia.org/wiki/Stack_Overflow If anybody wants to know more about it, just ask. If this is not appropriate place to talk about it, sent your question to me directly. What do you think? Has the time to move come? Or do you think we should stay here for now? Željko __ Information from ESET NOD32 Antivirus, version of virus signature database 4556 (20091029) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4557 (20091030) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4558 (20091030) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Answering incomplete requests
Hi Mark, My comments are inline. 2009/10/30 Mark Anderson mander...@drillinginfo.com I also monitor the watir tag at stackoverflow.com. There have been very few queries there, and if they are of slightly higher quality than the average question here, I think that it is because of the barriers to entry there (OpenID, website vs email, etc). I do not think we will get better questions there. We will just have a better tool for dealing with bad questions. Automatic search while entering question might help too. There is another site that I think might make more sense than stackoverflow. http://testing.stackexchange.com is a hosted stackoverflow solution that is specific to testing. I would prefer that we use stackoverflow if we decide to go there. We get more ruby related questions than testing related. I don’t think that either of these solutions is capable of replacing watir-general at this time. Why do you think so? I am willing to join and contribute to a watir-beginners list. I do not think we need such list. watir-general is that list. You are welcome to contribute here. I also wonder whether some sort of FAQ posted on a regular basis, probably mainly pointing to the wiki/documentation, would help with these problems. I have already tried that. One e-mail each month for months. This is just one thread: http://groups.google.com/group/watir-general/browse_thread/thread/6252098614f59822 I did not notice any improvement. Željko --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: New to Watir Scripting
On Fri, Oct 30, 2009 at 02:18:58AM -0700, Anuradha wrote: How to pass data from Open office org sheet to a application..Need clear information about the data driven Please read: * http://wiki.openqa.org/display/WTR/Support * http://tinyurl.com/6x7j35 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Answering incomplete requests
Good suggestion. I just set up a login for that site and will start spending more time there. Bret Željko Filipin wrote: I have been thinking about this for a long time, and it just came to me that it is related to this thread. I think the time has come to take Watir support to the next level. Have you heard about site called Stack Overflow? I use it all the time. Created by Jeff Atwood and Joel Spolsky. If you do not know who they are just google them. How it works? You log in with openid, ask question, tag it with watir. There is a feed for the tag. We subscribe to the feed and answer questions. It is the future of support. It is a very useful merge of support forum, digg and wiki with features like tagging questions, closing duplicate questions (with link to original question), voting on good questions and answers (so good and interesting questions and answers float to the top). Since it is also a wiki, questions and answers can be edited (including adding and removing tags). When you type a title for the question and start typing the body, it automatically searches the site and displays similar questions under the title. Just what we need. No more please search before you ask. The site searches for you. There are some watir questions already there, but not much. I have put some to try things out: http://stackoverflow.com/questions/tagged/watir http://stackoverflow.com/questions/tagged/firewatir Watin folks use it much more: http://stackoverflow.com/questions/tagged/watin You get points for each up vote you get. There are also badges. Makes answering questions more like a game. There is added benefit. If we get a question that is for example more ruby related, we can tag it with ruby (if it is not already tagged) and then all users that follow that tag will see it and probably answer. We could close this group, or leave it only for discussion, and move all support to Stack Overflow. We could make this group moderated, and approve only discussion posts, and reject all support with a note to post ti to Stack Overflow. If we agree on that, I volunteer to do that for the next month, and probably longer if needed. More information: http://stackoverflow.com/ http://blog.stackoverflow.com/ http://blog.stackoverflow.com/category/podcasts/ http://en.wikipedia.org/wiki/Stack_Overflow If anybody wants to know more about it, just ask. If this is not appropriate place to talk about it, sent your question to me directly. What do you think? Has the time to move come? Or do you think we should stay here for now? Željko --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Ci_reporter on watircraft
I think the problem is that watircraft has not been updated to work with the latest version of cucumber. Bret Pals wrote: Hi Graeme, Can you tell me how did you do it for cucumber so that i can get some idea of incorporating the same in watircraft. Regards, Pallavi On Sep 10, 2:53 pm, pallavi shashidhar pals.sha...@gmail.com wrote: Hi, I did update to ci_reporter 1.6.0 and at the command prompt, i give the foll command: rake ci:setup:cucumber features and it gives me the foll errors: rm -rf features/reports c:/ruby/bin/ruby -I c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/lib;lib c: /ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/cucumber --require c:/ruby/li b/ruby/gems/1.8/gems/ci_reporter-1.6.0/lib/ci/reporter/rake/cucumber_loader.rb - -format CI::Reporter::Cucumber test/features/cc_register_complaint.feature test/ features/cc_update_complaint.feature test/features/cell_operator_view_complaint. feature test/features/citizen_register_complaint.feature test/features/citizen_u pdate_complaint.feature test/features/citizen_view_complaint.feature test/featur es/city_official_login.feature test/features/city_official_register_complaint.fe ature test/features/city_official_update_complaint.feature test/features/city_of ficial_view_complaints.feature test/features/city_official_view_status_reports.f eature test/features/GO_update_complaint.feature test/features/GO_update_users_c omplaint.feature test/features/official_change_password.feature undefined method `testcases' for nil:NilClass (NoMethodError) c:/ruby/lib/ruby/gems/1.8/gems/ci_reporter-1.6.0/lib/ci/reporter/rake/../../../c i/reporter/cucumber.rb:93:in `visit_step' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/step_coll ection.rb:15:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/step_coll ection.rb:14:in `each' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/step_coll ection.rb:14:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:75:in `visit_steps' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/backgroun d.rb:30:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:49:in `visit_background' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/feature.r b:23:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:23:in `visit_feature' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:25:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:13:in `each' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:13:in `each' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/features. rb:24:in `accept' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/ast/visitor.r b:19:in `visit_features' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:9:in `__send__' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:9:in `method_missing' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:8:in `map' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/broadcaster.r b:8:in `method_missing' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/cli/main.rb:5 8:in `execute!' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/../lib/cucumber/cli/main.rb:2 6:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/cucumber-0.3.91/bin/cucumber:9 rake aborted! Command failed with status (1): [c:/ruby/bin/ruby -I c:/ruby/lib/ruby/gems...] (See full trace by running task with --trace) Is the usage for rake features correct? Regards, Pallavi On Thu, Sep 10, 2009 at 3:14 PM, Graeme Mathieson, Rubaidh Ltd mat...@woss.name wrote: Hi, Our changes to ci_reporter to support cucumber output have been merged back into Nick's upstream version, and released as 1.6.0. No idea why it's not showing up in the master branch, though! We're still using the XML output from ci_reporter for cucumber and rspec features, and it's working well for us. If you have any problems getting it set up, give me a yell and I'll see if I can help. Cheers, Graeme. On Sep 9, 5:43 pm, Charley Baker charley.ba...@gmail.com wrote: It appears there's a forked version of ci_reporter on github that adds support for cucumber output, find out more here: http://github.com/rubaidh/ci_reporter/tree/master I'm not using ci_reporter any longer, just straight html output for cuke and rspec, but the general idea is to set it up in your rake file with the appropriate requires; there's info in the readme on that github repo. According to
[wtr-general] uninitialized constant Watir::PageContainer::Win32
I am trying to use enabled_popup.rb. I added require 'watir/contrib/ enabled_popup', but when I am starting the server I am getting: C:/ruby/lib/ruby/gems/1.8/gems/watir-1.6.2/lib/watir/contrib/ enabled_popup.rb:5: uninitialized constant Watir::PageContainer::Win32 (NameError) from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require' from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' from C:/Program Files/Genuitec/MyEclipse 7.5/Workspaces/MyEclipse/ c2p_watir/c2p_test_issues_2_menus_dev.rb:18 All the solutions showed to add include Win32 in the rb file, but as I looked it is already there. Any ideas? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: uninitialized constant Watir::PageContainer::Win32
See Bret's comment here (Nov 13, 2008, 12:17 am): http://groups.google.com/group/watir-general/browse_thread/thread/f3d3d8f602 3890cb/016c62b5a5ff6fb6 Tested it locally and it worked for me. -Original Message- From: watir-general@googlegroups.com [mailto:watir- gene...@googlegroups.com] On Behalf Of Shlomit Gazit Sent: Friday, October 30, 2009 6:56 PM To: Watir General Subject: [wtr-general] uninitialized constant Watir::PageContainer::Win32 I am trying to use enabled_popup.rb. I added require 'watir/contrib/ enabled_popup', but when I am starting the server I am getting: C:/ruby/lib/ruby/gems/1.8/gems/watir-1.6.2/lib/watir/contrib/ enabled_popup.rb:5: uninitialized constant Watir::PageContainer::Win32 (NameError) from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require' from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' from C:/Program Files/Genuitec/MyEclipse 7.5/Workspaces/MyEclipse/ c2p_watir/c2p_test_issues_2_menus_dev.rb:18 All the solutions showed to add include Win32 in the rb file, but as I looked it is already there. Any ideas? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---