Sigist Presentation 091208 V2.0

Feb 1, 20091 like325 views

The document introduces database regression testing using DbFit. It discusses why databases need to be tested, including areas like schema, stored procedures, and data values. It provides an overview of DbFit, highlighting how it allows creating and executing database tests through a wiki interface without extensive programming knowledge. The document demonstrates DbFit by example, showing how tests can validate database metadata, business logic, and data in an easy to use and repeatable manner.

Database Regression Testing made easy with DbFit. Presented to the BCS - SIGIST Conference, London : Dec 2008 Colin Moore-Hill Senior Technical Test Analyst @ RWE IT UK

Introduction. Database Regression testing. >Why Test Databases >How to test the database DbFit >Background >Wiki design An Act of Regression >Worked Example of the Regression Testing Closing >Future Links and learning opportunities. Regression Testing Databases Overview:

What! Test the Database? Why? That’s what DBA’s are for !! DBA’s, no more than Developers, are human and prone to error and while the examples shown later on are quite simple, some SQL queries and commands can be programmed in themselves. Having a simple repeatable test requiring little programming knowledge to create would be of great assistance. Why test the Database? For a lot of businesses today, the data held on the database are the most vital commercial asset they have. Business Critical functions will run off this data so surely it is logical to have regression tests to validate that the data is being stored correctly. Regression Testing Databases Database Regression testing .

What should we Test. There are two main areas of concern around the database: White Box – Code internally within the Database. Existence checks for database schema (Tables) Triggers, Views Constraints, Referential Integrity and Existing Data Quality. Black Box – At the Interfaces Stored Procedure Functions Data values - Persistence Data values – Retrieved Regression Testing Databases Database Regression testing .

What is this Db FIT? Developed out of the Fitnesse Acceptance testing framework for unit testing and acceptance testing. It also gives DBA a neat tool to express and manage tests in a relational language without knowledge of .net or Java. How is it Easier than unit testing? As it is built on a Wiki interface, the creation of tests are quite straight forward and could almost be written by business analysts or even the client themselves. Why do I promote its use? Purely because I find it to be quite a useful tool and wish to spread the word around Regression Testing Databases DbFit .

Showing by example: Testing the Metadata, The physical structure of the database tables. Testing the Business logic, Usually implemented through Stored Procedures, Triggers and the Like. Testing the Data, both derived and static Easy Execution of Tests and Suites of tests. Regression Testing Databases DbFit in “An Act of Regression” .

Home Page – DbFit Server Home Page of the DbFit Server Regression Testing made easy with DbFit.

Properties Page - DbFit Server Properties Page of the DbFit Server Regression Testing made easy with DbFit. Properties Page - DbFit Server

Quickly find out the structure of Procedures and Tables. Quickly find out the structure of Procedures and Tables. Regression Testing made easy with DbFit.

A complete Suite of tests A complete Suite of tests Regression Testing made easy with DbFit.

A single Suite of tests A single Suite of tests Regression Testing made easy with DbFit.

A single design of a test A single design of a test Regression Testing made easy with DbFit.

Successful test for the structure of the Database Metadata. Successful test for the structure of the Database Metadata. Regression Testing made easy with DbFit.

A correction made to Test A correction made to Test....(Int changed to a Char) Regression Testing made easy with DbFit.

Regression execution of the test, showing the change as an error Regression execution of the test shows the Change as an error Regression Testing made easy with DbFit.

? DbFit Homepage – Fitnesse.org ? In the Head Sessions – www.skillsmatter.com ? Gojko Adzic – gojko.net ? The Hairy Tester - HairyTester.mazota.com (Currently Offline) Opportunities for futher knowledge:

THANK YOU VERY MUCH FOR YOUR ATTENTION. Any Questions?

The document provides an overview of different types of database testing including front end database testing, structural backend testing, functional backend testing, database migration testing, data warehouse testing, and batch job execution testing. It describes the key aspects to test for each type, such as verifying database schemas, stored procedures, triggers, data integrity, security, performance, and more. Screenshots are also included to exemplify some of the testing processes.

IBM ConnectED 2015 - MAS103 XPages Performance and ScalabilityPaul Withers

Qtp manual testing tutorials by QuontraSolutionsQUONTRASOLUTIONS

The document discusses Quick Test Professional automation testing software. It describes the Quick Test testing process which consists of 7 phases: preparing to record, recording a session, enhancing the test, debugging, running the test, analyzing results, and reporting defects. It also discusses test object modeling, parameterization, checkpoints, transactions, and dividing tests into reusable actions.

In Memory Unit Testing with Apache DbUnitMohammad Sabir Khan

This document discusses in-memory unit testing using Apache DbUnit and HSQL DB. It outlines the need for in-memory testing for speed and isolation. The architecture loads an in-memory database for each test. Tools needed are a database like HSQLDB, DbUnit for data operations, and a test framework like JUnit. Steps include connecting to the in-memory DB, loading data from XML files before each test, running tests, and deleting the in-memory DB after. Challenges include differences between the in-memory DB and production DB schemas and difficulties including schema names in test data XML files.

JMeter Post-ProcessorsLoadium

JMeter Processors are utilized to transform the Samplers in their scope. There are two types of processors in JMeter as JMeter Post-processors and JMeter Pre-processors. In this presentation, we’ll go through post-processors. Jmeter Post-processors are taking actions after the Sampler is done with its request. You can get the response or gather data into a variable for later use. It is up to your scenario. Read on to learn more.

3 know more_about_rational_performance_tester_8-1-snehamoy_kIBM

Rational Performance Tester (RPT) is a tool for performance testing web applications. It can simulate thousands of virtual users to test an application's performance and scalability. RPT works with many web technologies and protocols. It allows recording and playback of tests, monitoring of system resources, and real-time reporting of performance metrics. The presentation provided an overview of RPT's features and capabilities. It also included tips and best practices for creating tests, configuring agents and drivers, and optimizing performance.

Testing the UntestableMark Baker

What is UFT? HP's unified functional testing.Confiz

Unified Functional Testing (UFT) is HP's main automated functional testing tool that allows users to integrate QuickTest Pro with Service Test. UFT enables automated functional testing of applications. It provides various panes like the Solution Explorer, Toolbox, Canvas, and Output panes to design and run tests. Users can create simple tests with activities like Replace String and Concatenate String, connect the test steps, and map data from multiple sources to test functionality.

Performance testing using Jmeter for apps which needs authenticationJay Jha

The document provides an overview of performance testing using JMeter. It discusses different types of performance testing like load testing, stress testing, and spike testing. It then describes how to install and configure JMeter, including downloading JMeter, installing Java, adding HTTP requests, CSV data sets, listeners, and more. The document walks through recording a test plan in JMeter and provides an example of comparing the performance of an application under 5 users versus 50 users.

Web service testing using QTP (UFT)NaveenKumar Namachivayam

Some useful tips with qtpSandeep

1) The document provides solutions to common issues in QuickTest Professional (QTP), including how to add constants to a datatable, check if a parameter or checkpoint exists, validate checkpoints without failing tests, and the difference between actions and functions. 2) It also discusses when to use recovery scenarios versus error handling, how to use environment variables, the files in a QTP test, and how to rename checkpoints. 3) Finally, it addresses questions about browser support, resolving issues with Windows Media Player when running QTP, the purpose of the lservrc file, and ensuring QTP can run from Quality Center.

Advance Sql Server Store procedure PresentationAmin Uddin

This document discusses stored procedures in SQL, including: 1. What stored procedures are and how they improve performance over dynamic SQL. 2. How to create stored procedures with parameters and return values. 3. How to call/execute stored procedures and examples of inserting, updating, and deleting data using stored procedures. 4. The process of stored procedure compilation and recompilation, including when recompilation may be needed due to changes in data or indexes.

Into The Box 2018 | Assert control over your legacy applicationsOrtus Solutions, Corp

This document discusses how to add tests to legacy code using the TestBox testing framework for ColdFusion applications. It defines unit testing and different types of tests like unit, integration, and end-to-end tests. TestBox allows writing automated tests for ColdFusion code and isolating dependencies using test doubles. The document outlines best practices for test-driven development including writing tests before code, using life cycle methods, and refactoring code without changing external behavior. Implementing a testing framework like TestBox helps assert control over legacy applications by adding tests and the ability to refactor code safely.

Sql storeprocedureftz 420

This document discusses store procedures including: 1. What a store procedure is and how it improves performance over dynamic SQL. 2. The key differences between store procedures and functions. 3. How to create, call, and execute store procedures including examples of creating procedures to insert, update, delete records. 4. The processing that occurs when a store procedure is created including resolution, compilation, and execution. 5. How query plans are built and stored for procedures.

Apache JMeter - A Brief Introductionagilitator

This document provides a basic introduction to load and stress testing with Apache JMeter. It explains the objectives of performance, load, and stress testing. It then guides the user through downloading and installing JMeter, creating a simple test plan with a thread group and HTTP request sampler, adding a listener to view results, running the test, and interpreting basic results from the summary report. While this only scratches the surface of JMeter's capabilities, it is intended to demonstrate the basic functionality and get users started with creating and running their first simple test plan.

Effective Test Driven Database Developmentelliando dias

The document discusses best practices for testing database code including: - Running integration tests inside database transactions to make them repeatable and isolated - Preparing all necessary data for each test in the setup rather than relying on order or shared state - Having a separate database instance for each developer and the build server to allow tests to modify data - Generating SQL scripts to reduce test replication and make database operations self-contained - Using tools like DbFit that integrate with testing frameworks and allow directly manipulating and verifying database contents in tests

Testing regressionRichie Lee

To prevent regressions during testing: - New features and modified old features must be tested thoroughly as bugs may be introduced in these areas. Verify old features still work properly after changes. - Regression testing ensures any changes have not negatively impacted application functionality or performance. - Testing databases poses challenges like verifying query plans do not regress when data, hardware, or database settings change.

Test-Driven Development with DbFit and Oracle database, BGOUG Conference, 201...Yavor Nikolov

This document discusses test-driven development (TDD) with DbFit and Oracle. It begins with an agenda that includes concepts of testing and TDD, an overview of DbFit, and a demo. It then covers various testing concepts like unit tests, integration tests, and acceptance tests. It also discusses challenges of database testing and how DbFit addresses these challenges by enabling the manipulation of database objects and definition of tests in tabular form. Finally, it demonstrates basic DbFit commands and features like connecting to a database, executing queries and procedures, storing and comparing queries, and different working modes.

见守りサービス惭颈颈尘补ミーマ　资料kaisya_account

Deliberate Practice (Agile Slovenia 2015)Peter Kofler

The document discusses deliberate practice as a way for software professionals to continuously improve. It proposes that traditional training methods are not enough and advocates for code katas, coding dojos, and code retreats where developers can practice specific skills in a low-pressure environment. These practices are presented as a way to overcome weaknesses in software engineering education and on-the-job training by providing structured, repetitive practice opportunities to develop expertise.

Hands on training on DbFit Part-IIBabul Mirdha

DbFit fixtures can operate in either "flow mode" or "standalone mode", with flow mode automatically rolling back transactions between tests for repeatability and standalone mode giving the user more control over transaction management; fixtures connect to a database by calling Connect and specify the connection details, and transactions are committed or rolled back by using the Commit or Rollback tables respectively. Fixtures also allow storing values in "symbols" that can be accessed across tables to share data between steps of a test.

Open Source BI Overview Alex Meadows

Trivadis TechEvent 2016 A few thoughts on the subject Continuous integration ...Trivadis

Continuous Integration (CI) is existing in the frontend development for quite some time and is part of the daily standard. As part of the PL/SQL development CI is only slightly developed as for many developers it shows up being expensive and complicated. Using Unit-Test errors are detected in an early stage and speeds up the development of error-free software. My presentation will demonstrate the advantages of the continuous quality assurance approach as well as introducing a method being implemented at VW FS for automating unit testing and quality assurance

Agile WTFNaresh Jain

Lynn Winterboer : Test automation AgileDenver

This document summarizes a presentation on test automation for agile data warehousing and business intelligence teams. It discusses why test automation is important for agile teams, challenges to test automation adoption, and provides an overview of a path to test automation including starting with unit tests and regression tests. It also demonstrates a simple approach to data warehouse test automation using test queries, expected and actual results, and test execution.

Agile Methods and Data Warehousing (2016 update)Kent Graziano

All you need to know about regression testing | David TzemachDavid Tzemach

TDD - Test Driven Dvelopment | Test First DesignQuang Nguy?n Bá

Test Driven Development (TDD) is a software development process that relies on the repetition of short development cycles called "red-green-refactor" cycles. Each cycle begins with writing an automated test that defines a new function or improves an existing function. The test is then run to verify it fails ("red"). Code is then written to implement the new function or change ("green"). Finally, code is refactored to improve design and readability without changing functionality. TDD results in code that is well-tested, loosely coupled, and easy to maintain or modify. Popular TDD tools include JUnit, NUnit, and PHPUnit.

Data Base Testing Interview QuestionsRita Singh

The document discusses database testing interview questions and answers. It includes questions about database testing concepts like data validity testing, data integrity testing, and database performance testing. It also contains questions that ask how to test databases manually, test procedures and triggers, perform data-driven testing, and invoke triggers on demand. The document provides detailed answers to each question explaining database testing concepts and processes.

More Related Content

What's hot (8)

What is UFT? HP's unified functional testing.Confiz

Performance testing using Jmeter for apps which needs authenticationJay Jha

Web service testing using QTP (UFT)NaveenKumar Namachivayam

Some useful tips with qtpSandeep

Advance Sql Server Store procedure PresentationAmin Uddin

Into The Box 2018 | Assert control over your legacy applicationsOrtus Solutions, Corp

Sql storeprocedureftz 420

Apache JMeter - A Brief Introductionagilitator

What is UFT? HP's unified functional testing.Confiz

Performance testing using Jmeter for apps which needs authenticationJay Jha

Web service testing using QTP (UFT)NaveenKumar Namachivayam

Some useful tips with qtpSandeep

Advance Sql Server Store procedure PresentationAmin Uddin

Into The Box 2018 | Assert control over your legacy applicationsOrtus Solutions, Corp

Sql storeprocedureftz 420

Apache JMeter - A Brief Introductionagilitator

Viewers also liked (13)

Effective Test Driven Database Developmentelliando dias

Testing regressionRichie Lee

Test-Driven Development with DbFit and Oracle database, BGOUG Conference, 201...Yavor Nikolov

见守りサービス惭颈颈尘补ミーマ　资料kaisya_account

Deliberate Practice (Agile Slovenia 2015)Peter Kofler

Hands on training on DbFit Part-IIBabul Mirdha

Open Source BI Overview Alex Meadows

Trivadis TechEvent 2016 A few thoughts on the subject Continuous integration ...Trivadis

Agile WTFNaresh Jain

Lynn Winterboer : Test automation AgileDenver

Agile Methods and Data Warehousing (2016 update)Kent Graziano

All you need to know about regression testing | David TzemachDavid Tzemach

TDD - Test Driven Dvelopment | Test First DesignQuang Nguy?n Bá

Effective Test Driven Database Developmentelliando dias

Testing regressionRichie Lee

Test-Driven Development with DbFit and Oracle database, BGOUG Conference, 201...Yavor Nikolov

见守りサービス惭颈颈尘补ミーマ　资料kaisya_account

Deliberate Practice (Agile Slovenia 2015)Peter Kofler

Hands on training on DbFit Part-IIBabul Mirdha

Open Source BI Overview Alex Meadows

Trivadis TechEvent 2016 A few thoughts on the subject Continuous integration ...Trivadis

Agile WTFNaresh Jain

Lynn Winterboer : Test automation AgileDenver

Agile Methods and Data Warehousing (2016 update)Kent Graziano

All you need to know about regression testing | David TzemachDavid Tzemach

TDD - Test Driven Dvelopment | Test First DesignQuang Nguy?n Bá

Similar to Sigist Presentation 091208 V2.0 (20)

Data Base Testing Interview QuestionsRita Singh

Testing database content with DBUnit. My experience.Serhii Kartashov

The document discusses testing the database layer in a smarter way than usual. It proposes using multiple databases for development, QA, and production environments. The best practice is to initialize test data, call the API, compare the actual database data to the expected data from a file. This can be done using the DBUnit framework which provides components for connecting to a database, representing test data sets, and performing database operations for testing purposes.

Database continuous integration, unit test and functional testHarry Zheng

DB2 Real-Time Analytics Meeting Wayne, PA 2015 - IDAA & DB2 Tools UpdateBaha Majid

This document discusses IBM's DB2 tools and solutions including the DB2 Performance Solution Pack, DB2 Utilities Solution Pack, IBM DB2 Analytics Accelerator (IDAA), and QMF for z/OS. It provides an overview of each solution's components and capabilities for optimizing DB2 performance, managing utilities, identifying accelerated queries, and workload analysis. The document also demonstrates how IBM tools like Query Monitor can identify eligible queries for acceleration with IDAA and quantify the potential CPU savings.

Revolutionizing the Data Abstraction Layer with IBM Optim pureQuery and DB2Vladimir Bacvanski, PhD

Vladimir Bacvanski and Dan Galvin Looking for a more flexible and efficient way for Java programs to access the database? Join us as we explore how you can bridge the gap between Java and relational databases. Enhance your Java environment with access layer generation, data access best practices, traceability between Java packages and SQL statements, improved impact analysis and more. And most importantly, see how new technology can improve not only new development, but existing applications as well. Be prepared to see designs and code samples!

Testing Big Data solutions fast and furiouslyKatherine Golovinova

DMYTRO SOBKO, Lead automation QA engineer @EPAM. We are well aware of how to test the REST API with N endpoints, with relational and non-relational (NonSQL) databases. Same thing with UI testing. Frameworks like Selenium, Selenide, Selenoid are not a mystery to anyone. Moreover, creating a reliable, extensible and really cool automated test framework for such applications from scratch is not difficult. But what about BigData projects that have no back-end or front-end in the classical sense? How can we test them? What parts should we cover with tests in the first place? And, besides, how do we introduce automation and make it an effective way for such projects? Dmytro will show you how to create a test framework for Cloud Big Data projects from scratch and to develop it in the most optimal way using the most interesting technologies.

Db As Behaving Badly... Worst Practices For Database Administrators Rod Colledgesqlserver.co.il

This document discusses worst practices for database administrators (DBAs). It covers issues related to disaster recovery planning, backups and restores, change control, storage configuration, file configuration, indexing, and administration techniques. Specifically, it highlights not having service level agreements, not testing disaster recovery plans, relying only on backups without verifying them, insufficient test environments, no performance baselines, capacity-centric rather than performance-centric storage design, manual rather than automated administration, and not defining alerts or checklists. The goal is to help DBAs avoid these pitfalls and instead follow best practices for database management and high availability.

High Performance JdbcSam Pattsin

Sybase job interview_preparation_guideNV Suresh Kumar

Sybase interview questions and answers guide provides information about Sybase and its products. The document discusses Sybase's focus on mobilizing and managing information. It provides example questions and answers about Sybase's database management products, features of ASE and IQ, tools like replication server and mainframe connect, and data integration software. The guide aims to help with preparing for a Sybase job interview.

Tdd on play frameworkvuhaininh88

This document discusses using test-driven development (TDD) with the Play Framework. It covers: I. An overview of TDD, including the benefits like producing clean, working code and discovering issues early. II. How to implement TDD with the Play Framework, including running tests with SBT and modifying configuration files. III. Examples of unit testing different parts of a Play application, including models, repositories, controllers, and views.

Building a Testable Data Access LayerTodd Anglin

All developers understand the theoretical value of unit testing, but with data driven applications, figuring out how to create tests can be hard. In this session, you will learn how to design and build a data layer that can be tested. We will introduce data layer architecture practices and methodologies that make testing possible, and cover the basics of unit test mocking. You will also be guided through various types of testing, including unit, integration, and functional testing. Leave this session with the basics needed to start creating tests for application data layers, including those powered by LinqToSQL and Entity Framework.

Test-Driven Development IntroductionSamsung Electronics

Test-driven development (TDD) involves writing unit tests before writing application code to satisfy the tests and ensure functionality. Unit tests are automated tests that are independent, fast, and repeatable. TDD promotes code testability, good programming practices like loose coupling and encapsulation. It can be challenging to test components at the "edge" of systems like user interfaces and web services due to dependencies, so mock objects are used to replace unpredictable dependencies and allow isolation in tests. While TDD has advantages, it also has challenges to set up and maintain additional classes needed for mocking.

Evaluating Test Driven Development And Parameterized Unit Testing In Dot Net ...mdfachowdhury

This document evaluates test driven development (TDD) and parameterized unit testing (PUT) in the .NET web platform. It covers topics such as TDD in the .NET environment, database unit testing with DBUnit and DB Pro, automated web testing with Selenium and Visual Studio, unit testing with NUnit and Microsoft Test, and load testing. The document also discusses MVC .NET testing, Microsoft PEX for parameterized unit testing, and the strengths and limitations of various testing tools.

App Dyanmics & SOASTA Testing & Monitoring Coverage, March 2012SOASTA

Liquibase – a time machine for your dataNeev Technologies

Neev Technologies is an IT services and product development company established in 2005 with offices in India, USA, Sweden, and Singapore. It has over 250 employees with expertise in mobile app development, web development, cloud consulting, and quality assurance. Neev uses Liquibase for database version control to manage schema changes across sprints of agile projects. Liquibase allows tracking database changes, rolling back changes, and generating change logs from existing databases. Neev follows best practices like organizing change logs by application version and providing change set IDs.

BDD and Test Automation in Evalutionary Product SuiteLasantha Ranaweera

QA Fest 2019. Дмитрий Собко. Testing Big Data solutions fast and furiouslyQAFest

Нам хорошо известно, как тестировать REST API с N эндпоинтами, с реляционными и нереляционными (NonSQL) базами данных. То же самое и с тестированием UI. Такие фреймворки как Selenium, Selenide, Selenoid ни для кого не загадка. Более того, создать с нуля надежный, расширяемый и действительно крутой автоматизированный тестовый фреймворк для таких приложений не составляет труда. Но как же насчет BigData проектов, которые не имеют ни back-end ни front-end в классическом понимании? Как их тестировать? Какие части покрыть тестами в первую очередь? И, кроме того, как внедрить автоматизацию и сделать ее эффективным способом для таких проектов. Я покажу вам, как с этим жить. Как создать тестовый фреймворк для Cloud Big Data проектов с нуля. И разработать его самым оптимальным способом с использованием самых интересных технологий.

TechDays 2013 Juhani Lind: Acceptance Test Driven Development With VS 2012Tieturi Oy

This document discusses acceptance test-driven development (ATDD) and how it can be used with SpecFlow and Fit frameworks. ATDD uses examples to collaboratively specify requirements and drive development. SpecFlow and Fit allow writing tests in a business-readable format and automatically generating test code. They integrate tests into development to validate functionality frequently. Overall, ATDD provides an executable specification, living documentation, and feedback to aid development.

2010/09 - Database Architechs - Performance & Tuning ToolDatabase Architechs

10 Tips for Configuring Your Builds with Bamboo SpecsAtlassian

Bamboo 6 lets every team manage their plans through code. But it's only the start of a journey. At Atlassian, we now configure the vast majority of our builds and deployments with code. Whether you're a new starter or already a user of Bamboo Specs, you're (or will be) facing questions such as "How do I test my Spec before update?", "Can I safely modify this reused Spec component?", or "How do I make Specs more accessible to non-Java teams?". Join Przemek Bruski, the architect of Bamboo to hear how our teams solved these - and more - problems. Apart from practical tips, we'll also talk about jump-starting your Specs with our exporter, latest additions to the Specs feature, and support for Bitbucket Cloud Pipelines configuration files.

Data Base Testing Interview QuestionsRita Singh

Testing database content with DBUnit. My experience.Serhii Kartashov

Database continuous integration, unit test and functional testHarry Zheng

DB2 Real-Time Analytics Meeting Wayne, PA 2015 - IDAA & DB2 Tools UpdateBaha Majid

Revolutionizing the Data Abstraction Layer with IBM Optim pureQuery and DB2Vladimir Bacvanski, PhD

Testing Big Data solutions fast and furiouslyKatherine Golovinova

Db As Behaving Badly... Worst Practices For Database Administrators Rod Colledgesqlserver.co.il

High Performance JdbcSam Pattsin

Sybase job interview_preparation_guideNV Suresh Kumar

Tdd on play frameworkvuhaininh88

Building a Testable Data Access LayerTodd Anglin

Test-Driven Development IntroductionSamsung Electronics

Evaluating Test Driven Development And Parameterized Unit Testing In Dot Net ...mdfachowdhury

App Dyanmics & SOASTA Testing & Monitoring Coverage, March 2012SOASTA

Liquibase – a time machine for your dataNeev Technologies

BDD and Test Automation in Evalutionary Product SuiteLasantha Ranaweera

QA Fest 2019. Дмитрий Собко. Testing Big Data solutions fast and furiouslyQAFest

TechDays 2013 Juhani Lind: Acceptance Test Driven Development With VS 2012Tieturi Oy

2010/09 - Database Architechs - Performance & Tuning ToolDatabase Architechs

10 Tips for Configuring Your Builds with Bamboo SpecsAtlassian

Sigist Presentation 091208 V2.0

1. Database Regression Testing made easy with DbFit. Presented to the BCS - SIGIST Conference, London : Dec 2008 Colin Moore-Hill Senior Technical Test Analyst @ RWE IT UK

2. Introduction. Database Regression testing. >Why Test Databases >How to test the database DbFit >Background >Wiki design An Act of Regression >Worked Example of the Regression Testing Closing >Future Links and learning opportunities. Regression Testing Databases Overview:

3. What! Test the Database? Why? That’s what DBA’s are for !! DBA’s, no more than Developers, are human and prone to error and while the examples shown later on are quite simple, some SQL queries and commands can be programmed in themselves. Having a simple repeatable test requiring little programming knowledge to create would be of great assistance. Why test the Database? For a lot of businesses today, the data held on the database are the most vital commercial asset they have. Business Critical functions will run off this data so surely it is logical to have regression tests to validate that the data is being stored correctly. Regression Testing Databases Database Regression testing .

4. What should we Test. There are two main areas of concern around the database: White Box – Code internally within the Database. Existence checks for database schema (Tables) Triggers, Views Constraints, Referential Integrity and Existing Data Quality. Black Box – At the Interfaces Stored Procedure Functions Data values - Persistence Data values – Retrieved Regression Testing Databases Database Regression testing .

5. What is this Db FIT? Developed out of the Fitnesse Acceptance testing framework for unit testing and acceptance testing. It also gives DBA a neat tool to express and manage tests in a relational language without knowledge of .net or Java. How is it Easier than unit testing? As it is built on a Wiki interface, the creation of tests are quite straight forward and could almost be written by business analysts or even the client themselves. Why do I promote its use? Purely because I find it to be quite a useful tool and wish to spread the word around Regression Testing Databases DbFit .

6. Showing by example: Testing the Metadata, The physical structure of the database tables. Testing the Business logic, Usually implemented through Stored Procedures, Triggers and the Like. Testing the Data, both derived and static Easy Execution of Tests and Suites of tests. Regression Testing Databases DbFit in “An Act of Regression” .

7. Home Page – DbFit Server Home Page of the DbFit Server Regression Testing made easy with DbFit.

8. Properties Page - DbFit Server Properties Page of the DbFit Server Regression Testing made easy with DbFit. Properties Page - DbFit Server

9. Quickly find out the structure of Procedures and Tables. Quickly find out the structure of Procedures and Tables. Regression Testing made easy with DbFit.

10. A complete Suite of tests A complete Suite of tests Regression Testing made easy with DbFit.

11. A single Suite of tests A single Suite of tests Regression Testing made easy with DbFit.

12. A single design of a test A single design of a test Regression Testing made easy with DbFit.

13. Successful test for the structure of the Database Metadata. Successful test for the structure of the Database Metadata. Regression Testing made easy with DbFit.

14. A correction made to Test A correction made to Test....(Int changed to a Char) Regression Testing made easy with DbFit.

15. Regression execution of the test, showing the change as an error Regression execution of the test shows the Change as an error Regression Testing made easy with DbFit.

16. ? DbFit Homepage – Fitnesse.org ? In the Head Sessions – www.skillsmatter.com ? Gojko Adzic – gojko.net ? The Hairy Tester - HairyTester.mazota.com (Currently Offline) Opportunities for futher knowledge:

17. THANK YOU VERY MUCH FOR YOUR ATTENTION. Any Questions?

狠狠撸

Sigist Presentation 091208 V2.0

Recommended

More Related Content

What's hot (8)

Viewers also liked (13)

Similar to Sigist Presentation 091208 V2.0 (20)

Sigist Presentation 091208 V2.0