Executing tests automatically

[Thorsten Huss]

Hi,

 

we're currently looking into dbfit to find out if we can use it for our purposes and one thing we can't really figure out is how tó run our test suites/pages automatically, e.g. via command line.

Our goal would probably be something like a possibility to start the tests from MS Sql Server Integration Services.

 

However, the command line methods I found on google don't really seem to work.

 

So, basically, the question here is:

With the newest complete dbfit install from github, how can I run my tests without having to manually press the test button on my wiki pages?

 

Any help is greatly appreciated!

 

Kind regards,

Thorsten

[Jake Benilov]

Hi Thorsten,

What you're looking for is offered by FitNesse, the test framework that powers DbFit. Check out the FitNesse docs:

http://fitnesse.org/FitNesse.UserGuide.ExecutingTestsOutsideTheUserInterface

Hope that helps,

Jake

--
You received this message because you are subscribed to the Google Groups "dbfit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+un...@googlegroups.com.
To post to this group, send email to db...@googlegroups.com.
Visit this group at http://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/groups/opt_out.

[Thorsten Huss]

Hi Jake,

had already looked over that and in the meantime I actually got it to work.
The command line command you're link refers to worked after I put the fitnesse-standalone.jar from the newest dbfit release in the same folder as the .bat files instead of the \lib where it is stored by default. Don't know if that is how it's supposed to be or not though.

Anyways, thanks for your answer!

[Yavor Nikolov]

Hi Thorsten,

There is a dbfit specific tweak here: instead of calling "java -jar fitnesse-standalone.jar", you better run startFitnesse.{bat, sh}. E.g.:

${dbfit_home}/startFitnesse -o -d "${project-dir-parent-of-FitNesseRoot}" -c MySuite?suite&format=text

> I put the fitnesse-standalone.jar from the newest dbfit release in the same folder as the .bat files instead of the \lib

Don't do that: it will complicate your dbfit upgrades. (fitnesse jar file is now stamped with date of the release: instead if renaming/moving it - you just call the bat/shell script and it fill know where to find it).

Regards,
Yavor

[Thorsten Huss]

Hi Yavor,

sorry for responding this late. I will definitely try that one out when I have some time and will post if it worked for me. Thanks!

Kind regards,
Thorsten

[Thorsten Huss]

So I tried that, but all I got was this output:

C:\Users\(MyUsername)\Desktop\dbfit>java -cp "lib\dbfit-docs.jar;lib\*" fitnesseMain.FitNesseMain -p 8085 -e 0 -o MyFirstTestSuite?suite

Usage: java -jar fitnesse.jar [-vpdrleoab]
        -p <port number> {80}
        -d <working directory> {.}
        -r <page root directory> {FitNesseRoot}
        -l <log directory> {no logging}
        -f <config properties file> {plugins.properties}
        -e <days> {14} Number of days before page versions expire
        -o omit updates
        -a {user:pwd | user-file-name} enable authentication.
        -i Install only, then quit.
        -c <command> execute single command.
        -b <filename> redirect command output.
        -v {off} Verbose logging

C:\Users\(MyUsername)\Desktop\dbfit>pause
Press any key to continue . . .
Invalid drive specification.


My only guess is that I'm not pointing to the right path at ${project-dir-parent-of-FitnesseRoot}. I used the same path as for the startFitnesse.bat, as they are stored at the same level. Tried \lib as well (as there is another FitnesseRoot directory), same output. Any idea?

[Yavor Nikolov]

You're missing "-c" before your suite name.

Yavor

--

You received this message because you are subscribed to the Google Groups "dbfit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+un...@googlegroups.com.
To post to this group, send email to db...@googlegroups.com.
Visit this group at http://groups.google.com/group/dbfit.

For more options, visit https://groups.google.com/d/optout.

[Thorsten Huss]

Yes, seems you're right, it's working now. Kind of embarrassing that I did not recognize that ;)

[erin larsen]

I have another question related to this.  Is it possible to run a suite of suites?  I am able to run a single suite from the command line, but it gets tripped up when I go a level above that to run a suite of suites.  Any suggestions?

[Yavor Nikolov]

Yes, it should be possible to run suite with nested sub-suites: http://fitnesse.996250.n3.nabble.com/Nested-suites-td3126.html

To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+unsubscribe@googlegroups.com.

To post to this group, send email to db...@googlegroups.com.

Visit this group at https://groups.google.com/group/dbfit.

[Geeme Buddha]

Hi yavor,

I tried as per below command

/bin/dbfit-complete-3.2.0/startFitnesse.sh -p 8085 -o -d "/bin/dbfit-complete-3.2.0/FitNesseRoot" -c "FrontPage.PostgraceConnectionTest.UserActivity?test&format=text"

I am getting error :

Jun 29, 2017 2:03:17 PM fitnesse.ConfigurationParameter loadProperties

INFO: No configuration file found (/usr/bin/dbfit-complete-3.2.0/FitNesseRoot/plugins.properties)

Bootstrapping FitNesse, the fully integrated standalone wiki and acceptance testing framework.

root page: fitnesse.wiki.fs.FileSystemPage at /bin/dbfit-complete-3.2.0/FitNesseRoot/FitNesseRoot#latest

logger: none

authenticator: fitnesse.authentication.PromiscuousAuthenticator

page factory: fitnesse.html.template.PageFactory

page theme: bootstrap

Starting FitNesse on port: 8085

Executing command: FrontPage.PostgraceConnectionTest.UserActivity?test&format=text

-----Command Output-----

java.lang.Exception: error loading page: 404

        at fitnesse.FitNesse.executeSingleCommand(FitNesse.java:91)

        at fitnesseMain.FitNesseMain.executeSingleCommand(FitNesseMain.java:121)

        at fitnesseMain.FitNesseMain.launch(FitNesseMain.java:95)

        at fitnesseMain.FitNesseMain.launchFitNesse(FitNesseMain.java:75)

        at fitnesseMain.FitNesseMain.launchFitNesse(FitNesseMain.java:54)

        at fitnesseMain.FitNesseMain.main(FitNesseMain.java:34)

am i executing incorrect command?

Cheers,

mahesh

[Yavor Nikolov]

Hi Mahesh,

http://fitnesse.org/FitNesse.FullReferenceGuide.UserGuide.AdministeringFitNesse.CommandLineArguments

http://fitnesse.org/FitNesse.FullReferenceGuide.UserGuide.AdministeringFitNesse.ControllingFitNesseFromTheCommandLine

* I think `-d` is supposed to point not to FitNesseRoot but to its parent.

* It might be good to also specify `-f` for loading a plugin file.

Best Regards,

Yavor

To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+unsubscribe@googlegroups.com.

To post to this group, send email to db...@googlegroups.com.

Visit this group at https://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/d/optout.

[Geeme Buddha]

Hi Yavor,

Thanks for responding back.

i removed -o and -d options and added -f and it worked.

/bin/dbfit-complete-3.2.0/startFitnesse.sh -p 8085 -f "/bin/dbfit-complete-3.2.0/FitNesseRoot" -c "FrontPage.PostgraceConnectionTest.UserActivity?test&format=text"

Cheers,

Mahesh