public void Should_Return_DbUri_After_Creating_New_Database(string name, string uri, string prefix, string dbUri)
{
var localDb = new LocalDb(name, uri, prefix);
Assert.AreEqual(localDb.DbUri, dbUri);
localDb.Destroy();
}
private static void CreateDb()
{
LocalDb = new LocalDb(version: "mssqllocaldb");
using (var conn = new SqlConnection(LocalDb.ConnectionString))
{
conn.Execute(@"
CREATE TABLE [User] (
Id int PRIMARY KEY IDENTITY(1, 1),
FirstName nvarchar(250),
LastName nvarchar(250),
Age int,
Gender bit,
RowVersion rowversion,
IsDeleted bit not null default(0)
)
CREATE TABLE [Group] (
Id int PRIMARY KEY IDENTITY(1, 1),
Name nvarchar(250),
RowVersion rowversion,
IsDeleted bit not null default(0)
)
CREATE TABLE [UserGroup] (
UserId int,
GroupId int,
RowVersion rowversion,
IsDeleted bit not null default(0)
)");
}
}
public void CaptureChanges()
{
using (var cn = LocalDb.GetConnection(dbName))
{
var emp = new Employee()
{
LastName = "Herbert",
FirstName = "Yavad",
HireDate = new DateTime(1990, 1, 1),
IsExempt = true
};
// need to make sure record doesn't exist
try { cn.Execute("TRUNCATE TABLE [changes].[RowVersion]"); } catch { /*do nothing */ }
try { cn.Execute("TRUNCATE TABLE [changes].[ColumnHistory]"); } catch { /* do nothing */ }
cn.Execute("DELETE [dbo].[Employee] WHERE [FirstName]=@firstName AND [LastName]=@lastName", emp);
var provider = new SqlServerCrudProvider <int>((id) => Convert.ToInt32(id));
provider.SaveAsync(cn, emp).Wait();
LoggedChangeTracker <Employee, long> ct = GetLoggedChangeTracker(cn, emp);
emp.FirstName = "Javad";
emp.Status = Status.Inactive;
provider.SaveAsync(cn, emp, ct).Wait();
Assert.IsTrue(cn.RowExistsAsync("[changes].[RowVersion] WHERE [TableName]='Employee' AND [RowId]=1 AND [Version]=1").Result);
Assert.IsTrue(cn.RowExistsAsync("[changes].[ColumnHistory] WHERE [TableName]='Employee' AND [RowId]=1 AND [Version]=1 AND [ColumnName]='FirstName' AND [OldValue]='Yavad' AND [NewValue]='Javad'").Result);
Assert.IsTrue(cn.RowExistsAsync("[changes].[ColumnHistory] WHERE [TableName]='Employee' AND [RowId]=1 AND [Version]=1 AND [ColumnName]='Status' AND [OldValue]='Active' AND [NewValue]='Inactive'").Result);
}
}
public List <AppDataManager.DataDesc> GetHistoryUpdateSpeaker(string length, string sender)
{
LocalDb _HistoryDB = new LocalDb("TextHistory");
//List<TextDataManager.TextDataDesc> FetchedData = new List<TextDataManager.TextDataDesc>();
List <AppDataManager.DataDesc> FetchedData = new List <AppDataManager.DataDesc>();
System.Data.IDataReader reader = _HistoryDB.getHistDataUpdate(int.Parse(length), sender);
while (reader.Read())
{
HistoryEntity entity = new HistoryEntity(reader[0].ToString(),
reader[1].ToString(),
reader[2].ToString(),
reader[3].ToString(),
reader[4].ToString());
FetchedData.Add(new TextDataManager.TextDataDesc(int.Parse(entity._id), entity._Speaker, entity._Content, entity._isPlayer, int.Parse(entity._sitID)));
}
_HistoryDB.close();
return(FetchedData);
}
// It's internal because `Umbraco.Core.Persistence.LocalDb` is internal
internal LocalDbTestDatabase(TestDatabaseSettings settings, ILoggerFactory loggerFactory, LocalDb localDb, string filesPath, IUmbracoDatabaseFactory dbFactory)
{
_loggerFactory = loggerFactory;
_databaseFactory = dbFactory;
_settings = settings;
_localDb = localDb;
s_filesPath = filesPath;
Instance = this; // For GlobalSetupTeardown.cs
var counter = 0;
var schema = Enumerable.Range(0, _settings.SchemaDatabaseCount)
.Select(x => TestDbMeta.CreateWithoutConnectionString($"{DatabaseName}-{++counter}", false));
var empty = Enumerable.Range(0, _settings.EmptyDatabasesCount)
.Select(x => TestDbMeta.CreateWithoutConnectionString($"{DatabaseName}-{++counter}", true));
_testDatabases = schema.Concat(empty).ToList();
s_localDbInstance = _localDb.GetInstance(InstanceName);
if (s_localDbInstance != null)
{
return;
}
if (_localDb.CreateInstance(InstanceName) == false)
{
throw new Exception("Failed to create a LocalDb instance.");
}
s_localDbInstance = _localDb.GetInstance(InstanceName);
}
public void LocalDb_InstanceName_defaults_to_V11()
{
using (var db = new LocalDb())
{
Assert.Equal("v" + LocalDb.Versions.V11, db.InstanceName);
}
}
public void MarkSitFinish(int id)
{
LocalDb _SitDB = new LocalDb("Situation");
_SitDB.setSitFinished(id.ToString());
_SitDB.close();
}
public void GetEmployeeWhereLambda()
{
using (var cn = LocalDb.GetConnection("DapperCX"))
{
string lastName = "Yarga";
var emp = new EmployeeCustom()
{
FirstName = lastName,
LastName = GetLastName(),
IsExempt = true,
HireDate = DateTime.Today,
Value = OtherEnum.Other
};
var provider = GetProvider();
int id = provider.SaveAsync(cn, emp).Result;
emp = provider.GetWhereAsync <EmployeeCustom>(cn,
e => e.FirstName == lastName,
e => e.LastName == GetLastName()).Result;
Assert.IsTrue(emp.Id == id);
}
}
private static void DeleteWorkspace(string name)
{
using (var cn = LocalDb.GetConnection(DbName))
{
cn.Execute("DELETE [dbo].[Workspace] WHERE [Name]=@name", new { name });
}
}
public void BuildSampleModel()
{
using (var cn = LocalDb.GetConnection("Hs5"))
{
var model = new SqlServerModelBuilder().GetDataModelAsync(cn).Result;
}
}
static void ProcessSinglePatient(int id)
{
//DbMapper db = new DbMapper();
LocalDb db = new LocalDb();
Patient p = new Patient();
p = db.GetPatientTSD(id);
Console.WriteLine("Patient : {0}", p.ToString());
Console.WriteLine("Patient result count: {0}", p.TSDataPoints.Count());
RuleStack rs = new RuleStack();
rs.Execute(p);
Console.WriteLine("Age calc done: {3},Patient Age: {0}, Invalid Age Flag:{1}, Alive: {2}", p.Age, p.Status.FlagInvalidAge, p.Status.Alive, p.Status.FlagCalculatedAge);
foreach (var n in p.Notifications)
{
Console.WriteLine("--> {0}: {1} |", n.TimeStamp, n.Message);
}
Console.WriteLine("--------------------------------------------------");
// rules
//write back to reporting
//db.InsertPatientReport(p);
}
public override async Task <Job> GetAsync(int key)
{
using (var cn = LocalDb.GetConnection(DbName))
{
return(await cn.GetAsync <Job>(key));
}
}
public void SyncCallNoParams()
{
using (var cn = LocalDb.GetConnection(DbName))
{
var dataTable = cn.QueryTable("SELECT * FROM [sys].[tables]");
}
}
public static void Initialize(TestContext context)
{
LocalDb.TryDropDatabase(dbName, out _);
using (var cn = LocalDb.GetConnection(dbName, SampleObjects()))
{
var tdg = new TestDataGenerator();
tdg.Generate <TypicalQueryResult>(1000, (result) =>
{
result.FirstName = tdg.Random(Source.FirstName);
result.SomeDate = tdg.RandomInRange(-1000, 1000, (i) => DateTime.Today.AddDays(i));
result.Weight = tdg.RandomInRange <decimal>(50, 150, (d) => d);
result.Notes = RandomPhrase(4, 8);
}, (results) =>
{
// AppVeyor seems to need this
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
var dataTable = results.ToDataTable();
BulkInsert.ExecuteAsync(dataTable, cn as SqlConnection, DbObject.Parse("dbo.SampleTable"), 50, new BulkInsertOptions()
{
SkipIdentityColumn = "Id"
}).Wait();
});
}
}
public void LocalDB_has_localdb_in_name()
{
using (var db = new LocalDb())
{
Assert.Contains("localdb", db.DatabaseName);
}
}
private static LocalDb CreateNewDb()
{
var db = new LocalDb(version: "mssqllocaldb");
IDbConnection conn = db.OpenConnection();
conn.Execute(
@"
CREATE TABLE [User] (
Id int PRIMARY KEY IDENTITY,
FirstName nvarchar(250),
LastName nvarchar(250),
Age int,
Gender bit
)
CREATE TABLE [Data] (
Blob varbinary(100)
)
CREATE TABLE [Anon] (
Foo nvarchar(250),
Bar int,
Baz datetime2
)
CREATE TABLE [WithNullable] (
Id int NOT NULL,
Data int NULL,
)
");
return(db);
}
public void LocalDb_defaults_to_V11()
{
using (var db = new LocalDb())
{
Assert.Equal(LocalDb.Versions.V11, db.Version);
}
}
private void Drop(TestDbMeta meta)
{
using (var connection = new SqlConnection(_settings.SQLServerMasterConnectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
SetCommand(command, "select count(1) from sys.databases where name = @0", meta.Name);
var records = (int)command.ExecuteScalar();
if (records == 0)
{
return;
}
var sql = $@"
ALTER DATABASE {LocalDb.QuotedName(meta.Name)}
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE";
SetCommand(command, sql);
command.ExecuteNonQuery();
SetCommand(command, $@"DROP DATABASE {LocalDb.QuotedName(meta.Name)}");
command.ExecuteNonQuery();
}
}
}
public void MarkClusterFinish(int id)
{
LocalDb _ClusterDB = new LocalDb("Cluster");
_ClusterDB.setClusterFinished(id.ToString());
_ClusterDB.close();
}
public void Init()
{
ResourceStorage.DecompressMidiBundle();
jsonStorage = new JsonStorage();
jsonStorage.Load();
uiState = jsonStorage.Get(JsonStorageKeys.V1.UI_STATE, Storage.Protos.Json.V1.UiStateProto.CreateDefault());
midiSynthConfigs = jsonStorage.Get(JsonStorageKeys.V1.MIDI_SYNTH_CONFIGS, Storage.Protos.Json.V1.MidiSynthConfigsProto.CreateDefault());
gameplayConfig = jsonStorage.Get(JsonStorageKeys.V1.GAMEPLAY_CONFIG, Storage.Protos.Json.V1.GameplayConfigProto.CreateDefault());
appConfig = jsonStorage.Get(JsonStorageKeys.V1.APP_CONFIG, Storage.Protos.Json.V1.AppConfigProto.CreateDefault());
localDb = new LocalDb();
localDb.Init();
username = PlayerPrefs.GetString("TEMP_USERNAME", null);
password = PlayerPrefs.GetString("TEMP_PASSWORD", null);
netManager = new NetManager();
netManager.Init(this);
translationSevice = new TranslationService();
translationSevice.Init(netManager);
translationSevice.Load();
translationSevice.lang = appConfig.displayLang;
resourceStorage = new ResourceStorage();
resourceStorage.Init(this);
InitAudioConfig();
ApplyAppAudioConfig();
}
public void WriteData(List <AppDataManager.DataDesc> data)
{
LocalDb _HistoryDB = new LocalDb("TextHistory");
foreach (TextDataManager.TextDataDesc d in data)
{
string temp = "False";
if (d.sentByPlayer)
{
temp = "True";
}
System.Data.IDataReader reader = _HistoryDB.getLatestID("TextHistory");
int TempID = 0;
while (reader.Read())
{
TempID = int.Parse(reader[0].ToString());
}
TempID += 1;
HistoryEntity history = new HistoryEntity(TempID.ToString(), d.situationId.ToString(), temp, d.sender, d.message);
_HistoryDB.appendTableFromBottom("TextHistory", history);
}
_HistoryDB.close();
}
public void can_get_animals_using_explicit_relationship_between_animal_and_enclosure()
{
using (var sandbox = new LocalDb())
{
Runner.MigrateToLatest(sandbox.ConnectionString);
using (var context = new ZooDbContext(sandbox.ConnectionString))
{
var enclosure = new Enclosure()
{
Id = 1, Name = "Kenya", Location = "Africa", Environment = "Sahara"
};
var animal = new Animal()
{
Name = "Nala", Species = "Lion", EnclosureId = 1
};
context.Animals.Add(animal);
context.Enclosures.Add(enclosure);
context.SaveChanges();
var controller = new HomeController()
{
Database = context
};
var result = controller.Index() as ViewResult;
var model = result == null ? new IndexViewModel() : result.Model as IndexViewModel;
Assert.Equal(1, model.Animals.Count());
Assert.Equal("Nala", model.Animals.First().AnimalName);
}
}
}
public List <AppDataManager.DataDesc> GetEmailUpdate()
{
LocalDb _MailDB = new LocalDb("MailHistory");
List <AppDataManager.DataDesc> FetchedData = new List <AppDataManager.DataDesc>();
System.Data.IDataReader reader = _MailDB.getMailDataUpdate();
while (reader.Read())
{
MailEntity entity = new MailEntity(reader[0].ToString(),
reader[1].ToString(),
reader[2].ToString(),
reader[3].ToString(),
reader[4].ToString(),
reader[5].ToString(),
"",
"",
"",
"",
"",
"",
"");
bool sentByPlayer = entity._isPlayer.Equals("True") ? true : false;
FetchedData.Add(new EmailDataManager.EmailDataDesc(int.Parse(entity._id), entity._speaker, sentByPlayer, entity._subject, entity._content, int.Parse(entity._sitID)));
}
_MailDB.close();
return(FetchedData);
}
public void Can_throw_an_exception()
{
using (var sandbox = new LocalDb())
{
Runner.MigrateToLatest(sandbox.ConnectionString);
using (var one = new ZooDbContext(sandbox.ConnectionString))
{
var enclosure = new Enclosure {
Environment = "Here", Name = "One", Location = "Here"
};
one.Enclosures.Add(enclosure);
one.SaveChanges();
using (var two = new ZooDbContext(sandbox.ConnectionString))
{
var change = two.Enclosures.Find(enclosure.Id);
change.Name = "Changed";
two.SaveChanges();
}
enclosure.Name = "Last Time";
Assert.Throws <DbUpdateConcurrencyException>(() => one.SaveChanges());
}
}
}
public static void InitializeDb(TestContext context)
{
LocalDb.TryDropDatabaseIfExists(dbName, out _);
DataModel.CreateTablesAsync(new Type[]
{
typeof(Item),
typeof(Workspace),
typeof(WorkspaceUser),
typeof(UserProfile),
typeof(ColumnHistory),
typeof(RowVersion)
}, LocalDb.GetConnection(dbName)).Wait();
using (var cn = LocalDb.GetConnection(dbName))
{
GetProvider().Insert(cn, new Workspace()
{
Name = wsName,
CreatedBy = userName,
DateCreated = DateTime.UtcNow
});
GetProvider().Insert(cn, GetUser());
}
}
public void Can_CreateLocalDB_With_V13()
{
using (var db = new LocalDb(version: LocalDb.Versions.V13))
{
Assert.NotNull(db);
}
}
public static void Initialize(TestContext context)
{
using (var cn = LocalDb.GetConnection(dbName))
{
LocalDb.ExecuteInitializeStatements(cn, DbObjects.CreateObjects());
}
}
public void Can_CreateLocalDB_With_V13_And_InstanceName()
{
using (var db = new LocalDb(version: LocalDb.Versions.V13, instanceName: "Test", tryInstallingInstanceIfNotExists: true))
{
Assert.NotNull(db);
}
}
public void Delete_Customer_In_Customers_Collection(string name, string dbName)
{
this.Destroy($@"E:\Git\c-sharp-libs\tests\dbs\{dbName}.db");
var localDb = new LocalDb(dbName, @"E:\Git\c-sharp-libs\tests\dbs");
var col = localDb.GetCollection <Customer>(name);
col.EnsureIndex(x => x.Name, true);
var customer = new Customer
{
Name = "John Doe",
Phones = new string[] { "8000-0000", "9000-0000" },
Age = 39,
IsActive = true
};
localDb.InsertDocument <Customer>(col, customer);
var results = col.Find(x => x.Name == customer.Name);
Assert.AreEqual(results.ToArray().Count(), 1);
var cust = (Customer)results.ToArray()[0];
localDb.DeleteDocument <Customer>(col, cust._id);
var newResults = col.Find(x => x.Name == customer.Name);
Assert.AreEqual(newResults.ToArray().Count(), 0);
}
public override void Init(SongSelectLevelScheduler level)
{
base.Init(level);
net = game.netManager;
web = WebCache.instance;
res = game.resourceStorage;
db = game.localDb;
}
