67 lines
2.5 KiB
C#
67 lines
2.5 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data.SqlClient;
|
|||
|
|
using System.Data;
|
|||
|
|
using NUnit.Framework;
|
|||
|
|
|
|||
|
|
namespace DatabaseUnitTesting
|
|||
|
|
{
|
|||
|
|
[TestFixture]
|
|||
|
|
public class DASTests : TestSetups
|
|||
|
|
{
|
|||
|
|
// NOTES:
|
|||
|
|
// DAS must have serial number
|
|||
|
|
|
|||
|
|
// [Test]
|
|||
|
|
// ============================================================
|
|||
|
|
// DELETE DAS
|
|||
|
|
// Call sp_DASDelete with a known DAS hardware ID
|
|||
|
|
// Verify all DAS channels associated with the hardware ID no longer exists in dbo.DAS table.
|
|||
|
|
// ============================================================
|
|||
|
|
|
|||
|
|
|
|||
|
|
// [Test]
|
|||
|
|
// =============================================================
|
|||
|
|
// GET DAS
|
|||
|
|
// Start with a known already entered DAS. Call sp_DASGet for the hardware.
|
|||
|
|
// Verify known DAS is returned
|
|||
|
|
// =============================================================
|
|||
|
|
|
|||
|
|
|
|||
|
|
//[Test]
|
|||
|
|
// ============================================================
|
|||
|
|
// INSERT DAS
|
|||
|
|
// Call sp_CalculatedChannelsUpdateInsert with parameters for a new valid
|
|||
|
|
// DAS and compare all fields.
|
|||
|
|
// Pass if all fields in dbo.DAS table are entered.
|
|||
|
|
// ============================================================
|
|||
|
|
|
|||
|
|
|
|||
|
|
//[Test]
|
|||
|
|
// ============================================================
|
|||
|
|
// INSERT DAS: VERIFY ONLY ONE NEW ROW IS ADDED
|
|||
|
|
// Call sp_DASCUpdateInsert with parameters for a new valid
|
|||
|
|
// DAS and verify a new row is created in dbo.DAS table.
|
|||
|
|
//
|
|||
|
|
// ============================================================
|
|||
|
|
|
|||
|
|
|
|||
|
|
//[Test]
|
|||
|
|
// ============================================================
|
|||
|
|
// UPDATE DAS
|
|||
|
|
// Send valid DAS parameters to sp_DASInUpdateInsert for a DAS
|
|||
|
|
// that already is in the database and compare all fields.
|
|||
|
|
// Pass if all fields in dbo.DAS table are entered.
|
|||
|
|
// ============================================================
|
|||
|
|
|
|||
|
|
//[Test]
|
|||
|
|
// ============================================================
|
|||
|
|
// UPDATE DAS: VERIFY NO NEW ROW IS ADDED
|
|||
|
|
// Send valid DAS parameters to sp_DASInUpdateInsert for a DAS
|
|||
|
|
// that already is in the database and verify no new row is created in dbo.DAS table.
|
|||
|
|
//
|
|||
|
|
// ============================================================
|
|||
|
|
}
|
|||
|
|
}
|