public void TestFixtureSetUp()
{
if (!SqlLocalDbApi.IsLocalDBInstalled())
{
throw new Exception("LocalDB is not installed!");
}
this.databaseName = "SqlServerUserManagerTests_" + Guid.NewGuid().ToString("N");
// Configure dapper to support datetime2
SqlMapper.AddTypeMap(typeof(DateTime), DbType.DateTime2);
// Create test instance
this.instance = TemporarySqlLocalDbInstance.Create(deleteFiles: true);
// Seed test data
using (var connection = this.instance.CreateConnection())
{
connection.Open();
try
{
connection.Execute("CREATE DATABASE " + this.databaseName);
connection.Execute("USE " + this.databaseName);
connection.Execute("CREATE TABLE Users (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), UserId VARCHAR(255) NOT NULL, Password VARCHAR(MAX) NOT NULL, FirstName NVARCHAR(255) NOT NULL, LastName NVARCHAR(255) NOT NULL, LastLogin DATETIMEOFFSET)");
connection.Execute("INSERT INTO Users (UserId, Password, FirstName, LastName) VALUES ('azzlack', '10000:gW7zpVeugKl8IFu7TcpPskcgQjy4185eAwBk9fFlZK6JNd1I45tLyCYtJrzWzE+kVCUP7lMSY8o808EjUgfavBzYU/ZtWypcdCdCJ0BMfMcf8Mk+XIYQCQLiFpt9Rjrf5mAY86NuveUtd1yBdPjxX5neMXEtquNYhu9I6iyzcN4=:Lk2ZkpmTDkNtO/tsB/GskMppdAX2bXehP+ED4oLis0AAv3Q1VeI8KL0SxIIWdxjKH0NJKZ6qniRFkfZKZRS2hS4SB8oyB34u/jyUlmv+RZGZSt9nJ9FYJn1percd/yFA7sSQOpkGljJ6OTwdthe0Bw0A/8qlKHbO2y2M5BFgYHY=', 'Ove', 'Andersen')");
}
finally
{
connection.Close();
}
}
base.TestFixtureSetUp();
}
/// <summary>
/// Ensures that SQL Server LocalDB is installed on the current machine.
/// </summary>
/// <remarks>
/// Any unit test calling this method is marked as Inconclusive if SQL
/// Server LocalDB is not installed on the local machine.
/// </remarks>
public static void EnsureLocalDBInstalled()
{
if (!SqlLocalDbApi.IsLocalDBInstalled())
{
Assert.Inconclusive("SQL Server LocalDB is not installed on {0}.", Environment.MachineName);
}
}
public override void TestFixtureSetUp()
{
if (!SqlLocalDbApi.IsLocalDBInstalled())
{
throw new Exception("LocalDB is not installed!");
}
this.databaseName = "SqlTokenRepositoryTests" + Guid.NewGuid().ToString("N");
// Configure dapper to support datetime2
SqlMapper.AddTypeMap(typeof(DateTime), DbType.DateTime2);
// Create test instance
this.instance = TemporarySqlLocalDbInstance.Create(true);
// Seed test data
using (var connection = this.instance.CreateConnection())
{
connection.Open();
connection.Execute($"CREATE DATABASE [{this.databaseName}]");
connection.Execute($"USE [{this.databaseName}]");
connection.Execute("CREATE TABLE AccessTokens (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), ClientId VARCHAR(255) NOT NULL, Ticket VARCHAR(MAX) NOT NULL, Token VARCHAR(MAX) NOT NULL, Subject NVARCHAR(255) NOT NULL, RedirectUri VARCHAR(MAX), Scope NVARCHAR(MAX), ValidTo DATETIMEOFFSET, Created DATETIMEOFFSET)");
connection.Execute("CREATE TABLE RefreshTokens (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), ClientId VARCHAR(255) NOT NULL, Token VARCHAR(MAX) NOT NULL, Subject NVARCHAR(255) NOT NULL, RedirectUri VARCHAR(MAX), Scope NVARCHAR(MAX), ValidTo DATETIMEOFFSET, Created DATETIMEOFFSET)");
connection.Execute("CREATE TABLE AuthorizationCodes (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), ClientId VARCHAR(255) NOT NULL, Ticket VARCHAR(MAX) NOT NULL, Code VARCHAR(MAX) NOT NULL, Subject NVARCHAR(255) NOT NULL, Scope NVARCHAR(MAX), RedirectUri VARCHAR(MAX), ValidTo DATETIMEOFFSET, Created DATETIMEOFFSET)");
}
base.TestFixtureSetUp();
}
public void Does_Not_Throw_PlatformNotSupportedException()
{
// Arrange
using var actual = new SqlLocalDbApi(_loggerFactory);
// Act and Assert
actual.DefaultInstanceName.ShouldBe(string.Empty);
actual.IsLocalDBInstalled().ShouldBeFalse();
actual.Versions.ShouldBeEmpty();
}
public SharedDatabaseFixture()
{
var isLocalDBInstalled = false;
using (var localDB = new SqlLocalDbApi())
{
isLocalDBInstalled = localDB.IsLocalDBInstalled();
}
Connection = isLocalDBInstalled
? new SqlConnection(ConnectionStringLocalDb)
: new SqlConnection(ConnectionStringDocker);
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
if (SqlLocalDbApi.IsLocalDBInstalled())
{
Application.Run(new Main());
}
else
{
Application.Run(new BadForm());
}
}
private void wizDatabaseValidate_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
lblError.Visible = false;
using (var localDB = new SqlLocalDbApi())
{
if (!localDB.IsLocalDBInstalled())
{
lblError.Text = "LocalDb is not installed, please install LocalDb 2012 or higher for Placeless to work.";
lblError.Visible = true;
}
else if (string.IsNullOrWhiteSpace(localDB.GetDefaultInstance().Name))
{
lblError.Text = "Could not determine default instance name.";
lblError.Visible = true;
}
}
}
public void TestFixtureSetUp()
{
if (!SqlLocalDbApi.IsLocalDBInstalled())
{
throw new Exception("LocalDB is not installed!");
}
this.databaseName = "SqlServerUserManagerTests_" + Guid.NewGuid().ToString("N");
// Configure dapper to support datetime2
SqlMapper.AddTypeMap(typeof(DateTime), DbType.DateTime2);
// Create test instance
this.instance = TemporarySqlLocalDbInstance.Create(deleteFiles: true);
// Seed test data
using (var connection = this.instance.CreateConnection())
{
connection.Open();
try
{
connection.Execute("CREATE DATABASE " + this.databaseName);
connection.Execute("USE " + this.databaseName);
connection.Execute("CREATE TABLE Users (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), UserId VARCHAR(255) NOT NULL, Password VARCHAR(MAX) NOT NULL, Enabled BIT NULL, FirstName NVARCHAR(255) NOT NULL, LastName NVARCHAR(255) NOT NULL, LastLogin DATETIMEOFFSET, Created DATETIMEOFFSET)");
connection.Execute("INSERT INTO Users (UserId, Password, FirstName, LastName, Enabled) VALUES ('azzlack', '10000:gW7zpVeugKl8IFu7TcpPskcgQjy4185eAwBk9fFlZK6JNd1I45tLyCYtJrzWzE+kVCUP7lMSY8o808EjUgfavBzYU/ZtWypcdCdCJ0BMfMcf8Mk+XIYQCQLiFpt9Rjrf5mAY86NuveUtd1yBdPjxX5neMXEtquNYhu9I6iyzcN4=:Lk2ZkpmTDkNtO/tsB/GskMppdAX2bXehP+ED4oLis0AAv3Q1VeI8KL0SxIIWdxjKH0NJKZ6qniRFkfZKZRS2hS4SB8oyB34u/jyUlmv+RZGZSt9nJ9FYJn1percd/yFA7sSQOpkGljJ6OTwdthe0Bw0A/8qlKHbO2y2M5BFgYHY=', 'Ove', 'Andersen', 'true')");
connection.Execute("CREATE TABLE UserApiKeys (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), UserId VARCHAR(255) NOT NULL, ApiKey VARCHAR(MAX) NOT NULL, Name VARCHAR(255) NOT NULL, Description VARCHAR(MAX) NOT NULL, Created DATETIMEOFFSET, LastUsed DATETIMEOFFSET)");
connection.Execute("INSERT INTO UserApiKeys (UserId, ApiKey, Name, Description) VALUES ('azzlack', 'PFJTQUtleVZhbHVlPjxNb2R1bHVzPnlidFpyM0pWS0p1L2hlUFMrV0Zla1kyYmRYVDlJMU1MeHZheTlIMW9IenRwRmI4QzJtQmUzY1EzVDhjUzE0ajJ4bk9lRkt2YVZ4Ukw5S2ozd0tOL1B3PT08L01vZHVsdXM+PEV4cG9uZW50PkFRQUI8L0V4cG9uZW50PjwvUlNBS2V5VmFsdWU+', 'Test', 'This is a test')");
connection.Execute("CREATE TABLE Clients (Id bigint NOT NULL PRIMARY KEY IDENTITY(1,1), ClientId VARCHAR(255) NOT NULL, ClientSecret VARCHAR(MAX) NOT NULL, PublicKey VARCHAR(MAX) NULL, RedirectUri NVARCHAR(2083) NOT NULL, Name NVARCHAR(255) NOT NULL, Enabled bit, LastUsed DATETIMEOFFSET, Created DATETIMEOFFSET)");
connection.Execute("INSERT INTO Clients (ClientId, ClientSecret, PublicKey, RedirectUri, Name, Enabled) VALUES ('NUnit', '10000:gW7zpVeugKl8IFu7TcpPskcgQjy4185eAwBk9fFlZK6JNd1I45tLyCYtJrzWzE+kVCUP7lMSY8o808EjUgfavBzYU/ZtWypcdCdCJ0BMfMcf8Mk+XIYQCQLiFpt9Rjrf5mAY86NuveUtd1yBdPjxX5neMXEtquNYhu9I6iyzcN4=:Lk2ZkpmTDkNtO/tsB/GskMppdAX2bXehP+ED4oLis0AAv3Q1VeI8KL0SxIIWdxjKH0NJKZ6qniRFkfZKZRS2hS4SB8oyB34u/jyUlmv+RZGZSt9nJ9FYJn1percd/yFA7sSQOpkGljJ6OTwdthe0Bw0A/8qlKHbO2y2M5BFgYHY=', 'PFJTQUtleVZhbHVlPjxNb2R1bHVzPnFKMEtXaXZWSjUxUWtKWGdIU1hidkxOTEJsa09rOE9uSWtvRTljU1FrRzhOZm5VYXBrWHpkTlEvb3FLZE9BSWxYK1hFMnNwN0xFcS9KRnJMaDRNblhRPT08L01vZHVsdXM+PEV4cG9uZW50PkFRQUI8L0V4cG9uZW50PjwvUlNBS2V5VmFsdWU+', 'http://localhost', 'NUnit Test', 1)");
}
finally
{
connection.Close();
}
}
base.TestFixtureSetUp();
}
/// <summary>
/// The main entry point to the application.
/// </summary>
/// <param name="args">The command-line arguments passed to the application.</param>
internal static void Main(string[] args)
{
PrintBanner();
var options = new SqlLocalDbOptions()
{
AutomaticallyDeleteInstanceFiles = true,
StopOptions = StopInstanceOptions.NoWait,
};
var services = new ServiceCollection().AddLogging((p) => p.AddConsole().SetMinimumLevel(LogLevel.Debug));
var loggerFactory = services.BuildServiceProvider().GetRequiredService <ILoggerFactory>();
var localDB = new SqlLocalDbApi(options, loggerFactory);
if (!localDB.IsLocalDBInstalled())
{
Console.WriteLine(SR.SqlLocalDbApi_NotInstalledFormat, Environment.MachineName);
return;
}
if (args?.Length == 1 &&
(string.Equals(args[0], "/deleteuserinstances", StringComparison.OrdinalIgnoreCase) ||
string.Equals(args[0], "--delete-user-instances", StringComparison.OrdinalIgnoreCase)))
{
localDB.DeleteUserInstances(deleteFiles: true);
}
IReadOnlyList <ISqlLocalDbVersionInfo> versions = localDB.GetVersions();
Console.WriteLine(Strings.Program_VersionsListHeader);
Console.WriteLine();
foreach (ISqlLocalDbVersionInfo version in versions)
{
Console.WriteLine(version.Name);
}
Console.WriteLine();
IReadOnlyList <ISqlLocalDbInstanceInfo> instances = localDB.GetInstances();
Console.WriteLine(Strings.Program_InstancesListHeader);
Console.WriteLine();
foreach (ISqlLocalDbInstanceInfo instanceInfo in instances)
{
Console.WriteLine(instanceInfo.Name);
}
Console.WriteLine();
string instanceName = Guid.NewGuid().ToString();
ISqlLocalDbInstanceInfo instance = localDB.CreateInstance(instanceName);
var manager = new SqlLocalDbInstanceManager(instance, localDB);
manager.Start();
try
{
if (IsCurrentUserAdmin())
{
manager.Share(Guid.NewGuid().ToString());
}
try
{
using (SqlConnection connection = manager.CreateConnection())
{
connection.Open();
try
{
using (SqlCommand command = new SqlCommand("create database [MyDatabase]", connection))
{
command.ExecuteNonQuery();
}
using (SqlCommand command = new SqlCommand("drop database [MyDatabase]", connection))
{
command.ExecuteNonQuery();
}
}
finally
{
connection.Close();
}
}
}
finally
{
if (IsCurrentUserAdmin())
{
manager.Unshare();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
manager.Stop();
localDB.DeleteInstance(instance.Name);
}
Console.WriteLine();
Console.Write(Strings.Program_ExitPrompt);
Console.ReadKey();
}
/// <summary> /// Returns whether SQL LocalDB is installed on the current machine. /// </summary> /// <returns> /// <see langword="true"/> if SQL Server LocalDB is installed on the /// current machine; otherwise <see langword="false"/>. /// </returns> public virtual bool IsLocalDBInstalled() => SqlLocalDbApi.IsLocalDBInstalled();
