Comments (4)
This is great, I'm the same for testing so this will be really handy
from vba-ide-code-export.
@mattpalermo are you able to give details/documentation on what you think should go in there?
Example:
Project1.xlsb
Microsoft Excel Objects
|-Sheet1 (TestSheet)
Forms
|-fromTestForm.frm
Modules
|-modTestModule.bas
Class Modules
|-clsTestClass.cls
Project2.xlsb
Microsoft Excel Objects
|-Sheet1 (TestSheet)
Forms
|-fromTestForm.frm
Modules
|-modTestModule.bas
Class Modules
|-clsTestClass.cls
What needs to go into them for the tests? and why does there need to be more than one?
from vba-ide-code-export.
Thinking about the purpose of testing, we want to make sure that all the 'features' (or perhaps 'use cases') of CodeExport work as expected. An obvious way get started with this would be to create a 'comprehensive' project which uses as many 'features' as possible (e.g. forms, classes, modules, use basepath, use relative paths, use references).
For a more comprehensive integration test suite, we may want to have more than one test case that tests different use cases (e.g. not using the basepath property or using absolute file paths). We may also want to test that the program fails in the correct way in certain situations (e.g. just complete gibberish in the config file). However, there is a huge (perhaps infinite) number of possible test cases possible because of the combinatoric explosion of possible ways the program could be used, so we have to be smart about what is worth testing.
It would be nice to eventually also use unit testing so we can have more confidence about all those subtle edge cases.
I can get started on creating a 'comprehensive' test case using as many features as possible in the way that I think would be the common way to use code export. I am thinking that this would include:
- Simple form, class, modules, worksheet class and workbook class
- An empty sheet to make sure that it is not added to the configuration automatically.
- Paths specified relatively
- Use the basepath property
- Use the VBA project name property
- Use some reference(s)
For fun it might have some novel functionality...?
An accompanying 'readme' file will describe what is expected to happen when CodeExport is used on that project.
from vba-ide-code-export.
Closing this with reference to PR #72
from vba-ide-code-export.
Related Issues (20)
- Tidy file structure HOT 12
- Syntax error in JSON configuration will raise an error
- Cannot run import twice in a row HOT 4
- Code "formatter" to fix whitespace issues
- Ribbon UI HOT 1
- CustomUI.xml (Ribbon UI) injection HOT 5
- Command line interface HOT 3
- Store Excel workbooks as Unpacked stack of XML files HOT 8
- README Improvements HOT 4
- Keep a changelog HOT 7
- Build a wiki HOT 6
- Set VBAProject Name on Make Config File HOT 2
- Recommend using .gitattributes, .editorconfig and .gitignore files HOT 6
- XML to Excel
- `Add References` clearly detailed in the code HOT 1
- Deletion of macros' components after export of code HOT 6
- Installer is missing HOT 5
- File type check before Excel to XML
- Error 57101 - Can't remove default reference
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vba-ide-code-export.