AccUnit - User contributions [en]

Getting started

Sten Schmidt — Wed, 23 May 2012 19:15:48 GMT

Sten Schmidt:

[[de:Erste_Schritte]]

[http://en.wikipedia.org/wiki/Software_testing Software testing] is a important part of software development.

During earlier tests at the end of the software development cycle as an acceptance condition,
today's approach is to write the test before programming the logic of the application ([http://en.wikipedia.org/wiki/Test-driven_development TDD]).

Many actual programming languages provide appropriate tools for automated test execution. The [http://en.wikipedia.org/wiki/Visual_Basic_for_Applications VBA] programming language
unfortunately only contains rudimentary functionality to test the code (Debug.Print, Debug.Assert).

AccUnit now offers the possibility to run automated tests on MS Access. It uses the SimplyVBUnit, an Unit Testing Framework written in VB6.

The following pages will help you to write the first tests for your application.

Getting started

Sten Schmidt — Wed, 23 May 2012 19:14:06 GMT

Sten Schmidt:

Getting started

Sten Schmidt — Wed, 23 May 2012 19:07:24 GMT

Sten Schmidt:

Getting started

Sten Schmidt — Wed, 23 May 2012 19:07:04 GMT

Sten Schmidt:

[[de:Erste_Schritte]]

[http://en.wikipedia.org/wiki/Software_testing Software testing] is a important part of software development.

During earlier tests at the end of the software development cycle as an acceptance condition,
today's approach is to write the test before programming the logic of the application ([http://en.wikipedia.org/wiki/Test-driven_development TDD]).

Many actual programming languages provide appropriate tools for automated test execution.

The [http://en.wikipedia.org/wiki/Visual_Basic_for_Applications VBA] programming language
unfortunately only contains rudimentary functionality to test the code (Debug.Print, Debug.Assert).

Getting started

Sten Schmidt — Wed, 23 May 2012 19:03:41 GMT

Sten Schmidt:

Getting started

Sten Schmidt — Wed, 23 May 2012 19:00:46 GMT

Sten Schmidt:

UsageWithoutAddIn

Sten Schmidt — Wed, 23 May 2012 18:24:19 GMT

Sten Schmidt: /* remove */

[[de:Nutzung ohne Add-In]]

=== Using AccUnit without Add-In ===
(is not recommended)

The following comments are not required for use with the Add-In.
==== AccUnit support for the Debug-Window====
===== Configure the access application =====
====== activate ======
Input values to the Debug-Window: <code>CreateObject("AccUnit.Configurator").Init VBE.ActiveVBProject</code>

Result:
* references to AccUnit and SimplyVBUnit will be activated
* the HelperClass ''TestSuiteStarter'' and the Module ''_AccUnitObjects'' will be created

====== remove ======
Input values to the Debug-Window: <code>CreateObject("AccUnit.Configurator").Remove VBE.ActiveVBProject</code>

UsageWithoutAddIn

Sten Schmidt — Wed, 23 May 2012 18:23:35 GMT

Sten Schmidt: /* activate */

[[de:Nutzung ohne Add-In]]

=== Using AccUnit without Add-In ===
(is not recommended)

The following comments are not required for use with the Add-In.
==== AccUnit support for the Debug-Window====
===== Configure the access application =====
====== activate ======
Input values to the Debug-Window: <code>CreateObject("AccUnit.Configurator").Init VBE.ActiveVBProject</code>

Result:
* references to AccUnit and SimplyVBUnit will be activated
* the HelperClass ''TestSuiteStarter'' and the Module ''_AccUnitObjects'' will be created

====== remove ======
nput values to the Debug-Window: <code>CreateObject("AccUnit.Configurator").Remove VBE.ActiveVBProject</code>

UsageWithoutAddIn

Sten Schmidt — Wed, 23 May 2012 18:23:12 GMT

Sten Schmidt:

[[de:Nutzung ohne Add-In]]

=== Using AccUnit without Add-In ===
(is not recommended)

The following comments are not required for use with the Add-In.
==== AccUnit support for the Debug-Window====
===== Configure the access application =====
====== activate ======
Input values to the Debug-Window: <code>CreateObject("AccUnit.Configurator").Init VBE.ActiveVBProject</code>

Result:
* references to AccUnit and SimplyVBUnit will be aktivated
* the HelperClass ''TestSuiteStarter'' and the Module ''_AccUnitObjects'' will be created

====== remove ======
nput values to the Debug-Window: <code>CreateObject("AccUnit.Configurator").Remove VBE.ActiveVBProject</code>

UsageWithoutAddIn

Sten Schmidt — Wed, 23 May 2012 18:22:41 GMT

Sten Schmidt:

[[de:Nutzung ohne Add-In]]

=== Using AccUnit without Add-In ===
(is not recommended)

The following comments are not required for use with the Add-In.
==== AccUnit support for the Debug-Window====
===== Configure the access application =====
====== activate ======
Input values in the Debug-Window: <code>CreateObject("AccUnit.Configurator").Init VBE.ActiveVBProject</code>

Result:
* references to AccUnit and SimplyVBUnit will be aktivated
* the HelperClass ''TestSuiteStarter'' and the Module ''_AccUnitObjects'' will be created

====== remove ======
nput values in the Debug-Window: <code>CreateObject("AccUnit.Configurator").Remove VBE.ActiveVBProject</code>

UsageWithoutAddIn

Sten Schmidt — Wed, 23 May 2012 18:14:03 GMT

Sten Schmidt: Created page with 'de:Nutzung ohne Add-In === Using AccUnit without Add-In ==='

[[de:Nutzung ohne Add-In]]

=== Using AccUnit without Add-In ===

Basics

Sten Schmidt — Wed, 23 May 2012 18:06:53 GMT

Sten Schmidt:

[[de:Grundlagen]]
Software testing means to determine whether the software meets the requirements.

Requirements in natural language, however, are not suitable as the basis of a test. ("Well, the thing must not crash" or "If I enter 100, a particular result must be calculated").

Moreover, it is not possible to precisely describe complex applications.

To test software, it is important to split the large complexity of an application into small testable fragments (= functions / procedures). These fragments should then perform exactly ONE task. You then describe:

- which fragment ( Module, Class, Function, Sub ) do I test
- which input value( preconditions ) do I need
- which output value ( postconditions ) do I expect

It may be necessary to revise existing sourcecode and split it into smaller testable parts.

Basics

Sten Schmidt — Wed, 23 May 2012 18:06:35 GMT

Sten Schmidt:

Basics

Sten Schmidt — Wed, 23 May 2012 18:02:59 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 22:09:00 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 22:08:22 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 22:04:42 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 22:00:53 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 21:49:13 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 21:48:38 GMT

Sten Schmidt:

Basics

Sten Schmidt — Tue, 22 May 2012 21:43:53 GMT

Sten Schmidt:

[[de:Grundlagen]]
Software testing means to determine whether the software meets the requirements.

User Interface

Sten Schmidt — Tue, 22 May 2012 18:29:25 GMT

Sten Schmidt:

[[de:Benutzeroberfläche]] __NOTOC__
[[Image:AccUnit_VBE.png]]

==== Toolbar ====

[[Image:AccUnit_AddIn_Commandbar_Beschreibung.png]]

==== Menu items ====

[[Image:AccUnit_AddIn_Menu_Tools.png]]
[[Image:AccUnit_AddIn_Menu_View.png]]

==== VBE-Windows ====
[[Image:AccUnit_AddIn_Testauswahl.png]]

[[Image:AccUnit_AddIn_Testergebnis.png]]

==== Dialogs ====
[[Image:AccUnit_AddIn_TestImport.png]]
[[Image:AccUnit_AddIn_TestExport.png]]

[[Image:AccUnit_AddIn_UserSettings.png]]

[[Shortcuts]]