public static void Initialize()
{
VerifySqlServer.Enable();
VerifierSettings.ModifySerialization(settings =>
{
settings.AddExtraSettings(serializerSettings =>
serializerSettings.TypeNameHandling = TypeNameHandling.Objects);
});
SqlHelper.EnsureDatabaseExists(Connection.ConnectionString);
using var sqlConnection = Connection.OpenConnection();
var manager = new QueueManager("error", sqlConnection);
manager.Create().Await();
}
public static void Init()
{
VerifySqlServer.Enable();
}
static Tests()
{
#region Enable
VerifySqlServer.Enable();
#endregion
sqlInstance = new(
"VerifySqlServer",
connection =>
{
Server server = new(new ServerConnection((SqlConnection)connection));
server.ConnectionContext.ExecuteNonQuery(@"
CREATE TABLE
MyTable(Value int);
GO
CREATE INDEX MyIndex
ON MyTable (Value);
GO
INSERT INTO MyTable (Value)
VALUES (42);
GO
CREATE TRIGGER MyTrigger
ON MyTable
AFTER UPDATE
AS RAISERROR ('Notify Customer Relations', 16, 10);
GO
CREATE VIEW MyView
AS
SELECT Value
FROM MyTable
WHERE (Value > 10);
GO
create synonym synonym1
for MyTable;
GO
CREATE PROCEDURE MyProcedure
AS
BEGIN
SET NOCOUNT ON;
SELECT Value
FROM MyTable
WHERE (Value > 10);
END;
GO
CREATE FUNCTION MyFunction(
@quantity INT,
@list_price DEC(10,2),
@discount DEC(4,2)
)
RETURNS DEC(10,2)
AS
BEGIN
RETURN @quantity * @list_price * (1 - @discount);
END;");
return(Task.CompletedTask);
});
}