sanderstad / pstsqlttestgenerator Goto Github PK

Leave a comment what kind of test you're missing and how you would like this to be implemented.

Keep in mind about the following:

1. The test should be able to be parameterized
2. The test should be a basic test. It should not be an integration test with other components

You're test generator assume an index being present. Although this is a recommended practice, it is not always the case.
Maybe the code can check the existence of the index before creating the file.

Opearting systems do not like it when you have more than 10,000 files in a single directory.

There needs to be a parameter (and preferably a check) that when the directory has a certain amount of files it splits it in directories.

Maybe even fore that to happen because the user may not know that so many objects are being created.

The ViewColumnTest.template file references a 't' alias that isn't used in the from clause.
Probably you need to use the 'v' alias in the SQL Query part.

The command should get all the data from a table and assert the table

First get all the existing data and generatevthebjnsert statements for the expected table.
In the assert select the actual values.

Create a command to create a unit test that tests a specific query.
Get the first run time, then execute the query X times to get an average.

DECLARE @t1 DATETIME;
DECLARE @t2 DATETIME;

SET @t1 = GETDATE();
SELECT /* query one */ 1 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

SET @t1 = GETDATE();
SELECT /* query two */ 2 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms

The test class now defaults to "TestBasic". That should be changeable

• - database credentials
• - database options
• - generic database scoped configuration option
• - users
• - roles
• - application roles
• - role memberships
• - filegroups
• - full-text catalogs
• - assemblies
• - certificates
• - asymmetric keys
• - symmetric keys
• - encrypted symmetric keys
• - schemas
• - XML schema collections
• - user-defined data types
• - user-defined types
• - table types
• - unique keys for table types
• - primary keys for table types
• - indexes for table types
• - check constraints for table types
• - default constraints for table types
• - partition functions
• - partition schemes
• - functions
• - encrypted functions
• - aggregates
• - procedures
• - encrypted procedures
• - tables
• - primary keys
• - unique constraints
• - foreign keys
• - default constraints
• - check constraints
• - views
• - encrypted views
• - indexes
• - statistics
• - full-text index stoplists
• - search property lists
• - search properties
• - full-text indexes
• - column store indexes
• - spatial indexes
• - XML indexes
• - Selective XML indexes
• - encrypted triggers
• - triggers
• - encrypted and clr ddl triggers
• - ddl triggers
• - synonyms
• - defaults
• - data constraint uddt bindings
• - rules
• - data constraint uddt bindings
• - message types
• - queues
• - contracts
• - services
• - event notifications
• - remote service bindings
• - broker priorities
• - signatures
• - data compression options
• - sequence types
• - security policies
• - Gather column encryption keys
• - column master keys
• - external data sources
• - external file formats
• - external tables
• - extended properties
• - credentials
• - logins
• - server audits