/// <summary>
/// 初始化数据库连接工厂
/// </summary>
public virtual void InitConnectionFactory()
{
var connectionFactory = new SqlConnectionFactory();
//TODO fix compilation warning (below)
#pragma warning disable 0618
Database.DefaultConnectionFactory = connectionFactory;
}
public void Should_be_able_to_recreate_a_database()
{
string connectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
IDbConnectionFactory connection = new SqlConnectionFactory(connectionString);
Database.DefaultConnectionFactory = connection;
Database.SetInitializer(new BlogDbInitializer());
var context = new BlogContext(connectionString);
Assert.IsTrue(context.Posts.Any());
}
public static void PreStart()
{
MiniProfiler.Settings.SqlFormatter = new MvcMiniProfiler.SqlFormatters.SqlServerFormatter();
var sqlConnectionFactory = new SqlConnectionFactory(ConfigurationManager.ConnectionStrings["NuGetGallery"].ConnectionString);
var profiledConnectionFactory = new MvcMiniProfiler.Data.ProfiledDbConnectionFactory(sqlConnectionFactory);
Database.DefaultConnectionFactory = profiledConnectionFactory;
DynamicModuleUtility.RegisterModule(typeof(MiniProfilerStartupModule));
GlobalFilters.Filters.Add(new ProfilingActionFilter());
}
public void SqlConnectionFactory_handles_provider_factory_returning_null_connection()
{
var mockProviderFactory = new Mock <DbProviderFactory>();
mockProviderFactory.Setup(m => m.CreateConnection()).Returns <DbConnection>(null);
var factory = new SqlConnectionFactory
{
ProviderFactory = name => mockProviderFactory.Object
};
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.Equal(typeof(SqlConnection), connection.GetType());
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}
public void SqlConnectionFactory_uses_db_provider_factory()
{
var mockProviderFactory = new Mock <DbProviderFactory>();
var mockConnection = new Mock <DbConnection>();
mockConnection.SetupProperty(c => c.ConnectionString);
mockProviderFactory.Setup(m => m.CreateConnection()).Returns(mockConnection.Object);
var factory = new SqlConnectionFactory
{
ProviderFactory = name => mockProviderFactory.Object
};
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.Same(mockConnection.Object, connection);
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}
public void DeleteTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName);
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
storage.Initialize();
storage.Reset();
Assert.That(storage.Count(), Is.EqualTo(0));
var doc1 = new Fixture().Create<TestDocument>();
storage.Upsert("key1", doc1, new[] {"en-US"});
var doc2 = new Fixture().Create<TestDocument>();
storage.Upsert("key2", doc1, new[] {"en-US"});
var doc3 = new Fixture().Create<TestDocument>();
storage.Upsert("key1", doc1, new[] {"en-GB"});
Assert.That(storage.Count(), Is.EqualTo(3));
var result1 = storage.Delete("key1", new[] {"en-US"}); // removes only key1 + en-US
Assert.That(result1, Is.EqualTo(StorageAction.Deleted));
Assert.That(storage.Count(), Is.EqualTo(2));
var result2 = storage.Delete("key1"); // removes all with key1
Assert.That(result2, Is.EqualTo(StorageAction.Deleted));
Assert.That(storage.Count(), Is.EqualTo(1));
var result3 = storage.Delete("key2"); // removes all with key2
Assert.That(result3, Is.EqualTo(StorageAction.Deleted));
Assert.That(storage.Count(), Is.EqualTo(0));
}
public virtual void InitConnectionFactory()
{
var connectionFactory = new SqlConnectionFactory();
}
/// <summary>
/// sqlserver 连接工厂
/// </summary>
public virtual void InitConnectionFactory()
{
var connectionFactory = new SqlConnectionFactory();
Database.DefaultConnectionFactory = connectionFactory;
}
public void PagingAndSortingTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName)
{
DefaultTakeSize = 3,
MaxTakeSize = 5,
DefaultSortColumn = SortColumn.TimestampDescending
};
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
MiniProfiler.Start();
var mp = MiniProfiler.Current;
MassInsertTest(connectionName, databaseName, schemaName, 20, true);
var docs1 = storage.LoadValues(new[] { "en-US" }).ToList();
Assert.That(docs1, Is.Not.Null);
Assert.That(docs1.Any(), Is.True);
Assert.That(docs1.Count, Is.EqualTo(options.DefaultTakeSize));
foreach(var doc in docs1)
Log.Debug($"doc1: {doc.Id}, {doc.Name}");
var docs2 = storage.LoadValues(new[] { "en-US" }, skip:0, take:10).ToList();
Assert.That(docs2, Is.Not.Null);
Assert.That(docs2.Any(), Is.True);
Assert.That(docs2.Count, Is.EqualTo(options.MaxTakeSize));
foreach (var doc in docs2)
Log.Debug($"doc2: {doc.Id}, {doc.Name}");
Log.Debug($"trace: {mp.RenderPlainText()}");
MiniProfiler.Stop();
}
public void UpsertTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName);
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
MiniProfiler.Start();
var mp = MiniProfiler.Current;
storage.Reset();
var key = DateTime.Now.Epoch() + new Random().Next(10000, 99999);
using (mp.Step("insert "))
{
var newDoc = new Fixture().Create<TestDocument>();
var result1 = storage.Upsert(key, newDoc, new[] {"en-US"});
Assert.That(result1, Is.EqualTo(StorageAction.Inserted));
Log.Debug("newDoc: " + newDoc.Name);
newDoc.Name = Guid.NewGuid().ToString();
var result2 = storage.Upsert(key, newDoc, new[] {"en-US"});
Assert.That(result2, Is.EqualTo(StorageAction.Updated));
Log.Debug("newDoc: " + newDoc.Name);
var updatedDoc = storage.LoadValues(key, new[] {"en-US"}).ToList();
Assert.That(updatedDoc, Is.Not.Null);
Assert.That(updatedDoc.Any(), Is.True);
Assert.That(updatedDoc.Count(), Is.EqualTo(1));
Assert.That(updatedDoc.First().Name, Is.Not.Null);
Assert.That(updatedDoc.First().Name, Is.EqualTo(newDoc.Name));
Log.Debug("updatedDoc: " + updatedDoc.First().Name);
}
Log.Debug($"trace: {mp.RenderPlainText()}");
MiniProfiler.Stop();
}
public void MassInsertTest(string connectionName, string databaseName, string schemaName, int docCount, bool reset)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName);
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
MiniProfiler.Start();
var mp = MiniProfiler.Current;
if (reset) storage.Reset();
Log.Debug($"pre count: {storage.Count(new[] {"en-US"})}");
var key = DateTime.Now.Epoch() + new Random().Next(10000, 99999);
for (var i = 1; i <= docCount; i++)
{
Log.Debug($"+{i}");
var doc = new Fixture().Create<TestDocument>();
doc.Id = i;
storage.Upsert(key + i, doc, new[] {"en-US"}, timestamp: DateTime.Now.AddMinutes(i));
}
Log.Debug($"post count: {storage.Count(new[] {"en-US"})}");
Log.Debug($"trace: {mp.RenderPlainText()}");
MiniProfiler.Stop();
}
public void InsertTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName);
//var options = new StorageOptions(new ConnectionStrings().Get("XtricateTestSqlLocalDb"), databaseName: databaseName, schemaName: "StorageTests");
//var connectionFactory = new SqlLocalDbConnectionFactory();
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
MiniProfiler.Start();
var mp = MiniProfiler.Current;
storage.Reset();
var preCount = storage.Count(new[] {"en-US"});
Log.Debug($"pre count: {preCount}");
var key = DateTime.Now.Epoch() + new Random().Next(10000, 99999);
for (var i = 1; i < 5; i++)
{
Log.Debug($"+{i}");
using (mp.Step("insert " + i))
{
var doc1 = new Fixture().Create<TestDocument>();
//doc1.Name = "Routing wide joints (≥ 4 mm, e.g. between natural stone tiles)öoäa®r¼4èe";
doc1.Name = "NEU!Kreissägeblätter Expert for Steel NOUVEAU˜!Lames de scies circulaires Expert for Steel °˛˝˙°ˆˇ! ˘ Expert for Steel";
var result1 = storage.Upsert("key1", doc1, new[] {"en-US"});
// Assert.That(result1, Is.EqualTo(StorageAction.Updated));
//}
//using (mp.Step("upsert string"))
//{
var result2 = storage.Upsert(Guid.NewGuid(), new Fixture().Create<TestDocument>(), new[] {"en-US"});
//Assert.That(result2, Is.EqualTo(StorageAction.Inserted));
//}
//using (mp.Step("upsert int"))
//{
var result3 = storage.Upsert(key + i, new Fixture().Create<TestDocument>(), new[] {"en-US"});
//Assert.That(result3, Is.EqualTo(StorageAction.Inserted));
}
}
for (var i = 1; i <= 5; i++)
{
using (mp.Step("load " + i))
{
var result = storage.LoadValues(new[] {"en-US"}).Take(100);
//Assert.That(result, Is.Not.Null);
//Assert.That(result, Is.Not.Empty);
Log.Debug($"loaded count: {result.Count()}");
Log.Debug($"first: {result.FirstOrDefault().Id}");
//result.ForEach(r => Trace.Write(r.Id));
//result.ForEach(r => Assert.That(r, Is.Not.Null));
result.ForEach(r => Log.Debug(r.Name));
}
}
using (mp.Step("post count"))
{
var postCount = storage.Count(new[] {"en-US"});
Log.Debug($"post count: {postCount}");
//Assert.That(storage.Count(), Is.GreaterThan(preCount));
}
Log.Debug($"trace: {mp.RenderPlainText()}");
MiniProfiler.Stop();
}
public void InsertDataTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName);
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
MiniProfiler.Start();
var mp = MiniProfiler.Current;
storage.Reset();
var preCount = storage.Count(new[] {"en-US"});
Log.Debug($"pre count: {preCount}");
var key1 = DateTime.Now.Epoch() + new Random().Next(10000, 99999);
var inStream1 = File.OpenRead(@"c:\tmp\cat.jpg");
storage.Upsert(key1, inStream1, new[] { "en-US" });
var outStreams1 = storage.LoadData(key1, new[] {"en-US"});
Assert.That(outStreams1, Is.Not.Null);
Assert.That(outStreams1.Any());
foreach (var outStream in outStreams1)
{
Assert.That(outStream, Is.Not.Null);
File.WriteAllBytes($@"c:\tmp\cat_{key1}.jpg", outStream.ToBytes());
}
var result1 = storage.Upsert(key1, new Fixture().Create<TestDocument>(), new[] { "en-US" });
Assert.That(result1, Is.EqualTo(StorageAction.Updated));
var key2 = DateTime.Now.Epoch() + new Random().Next(10000, 99999);
var inStream2 = File.OpenRead(@"c:\tmp\test.log");
storage.Upsert(key2, inStream2, new[] { "en-US" });
var outStreams2 = storage.LoadData(key2, new[] { "en-US" });
Assert.That(outStreams2, Is.Not.Null);
Assert.That(outStreams2.Any());
foreach (var outStream in outStreams2)
{
Assert.That(outStream, Is.Not.Null);
File.WriteAllBytes($@"c:\tmp\test_{key1}.log", outStream.ToBytes());
}
var result2 = storage.Upsert(key2, new Fixture().Create<TestDocument>(), new[] { "en-US" });
Assert.That(result2, Is.EqualTo(StorageAction.Updated));
}
public void InitializeTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName);
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
storage.Reset();
Assert.That(storage.Count(), Is.EqualTo(0));
}
public void FindTest(string connectionName, string databaseName, string schemaName)
{
var options = new StorageOptions(new ConnectionStrings().Get(connectionName), databaseName: databaseName, schemaName: schemaName) { BufferedLoad = false};
var connectionFactory = new SqlConnectionFactory();
var indexMap = TestDocumentIndexMap;
var storage = new DocStorage<TestDocument>(connectionFactory, options, new SqlBuilder(),
new JsonNetSerializer(), new Md5Hasher(), indexMap);
MiniProfiler.Start();
var mp = MiniProfiler.Current;
Log.Debug($"pre count: {storage.Count(new[] {"en-US"})}");
var key = DateTime.Now.Epoch() + new Random().Next(10000, 99999) + "c";
var name = "NEWNAME" + key;
var sku = "";
using (mp.Step("insert "))
{
var document = new Fixture().Create<TestDocument>();
document.Name = name;
sku = document.Skus.FirstOrDefault().Sku;
dynamic dDocument = document;
dDocument.Dyn = "dynamic property";
var result1 = storage.Upsert(key, document, new[] {"en-US"});
Assert.That(result1, Is.EqualTo(StorageAction.Inserted));
Log.Debug("newDoc: " + document.Name);
}
var count = storage.Count(new[] { "en-US" });
var keys = storage.LoadKeys(new[] { "en-US" }).ToList();
Assert.That(keys, Is.Not.Null);
Assert.That(keys.Any(), Is.True);
Assert.That(count, Is.EqualTo(keys.Count()));
5.Times(i =>
{
using (mp.Step("find no non-existing by SKU criteria/tags " + i))
{
var criterias = new List<Criteria> { new Criteria("sku", CriteriaOperator.Eq, "XYZ_SKU") };
var result = storage.LoadValues(new[] { "en-US" }, criterias).ToList();
Assert.That(result, Is.Null.Or.Empty);
}
});
5.Times(i =>
{
using (mp.Step("find by KEY/tags " + i))
{
var result = storage.LoadValues(key, new[] {"en-US"}).ToList();
Assert.That(result, Is.Not.Null);
Assert.That(result.Any(), Is.True);
Assert.That(result.FirstOrDefault().Name, Is.EqualTo(name));
}
});
5.Times(i =>
{
using (mp.Step("find by NAME criteria/tags " + i))
{
var criterias = new List<Criteria> {new Criteria("name", CriteriaOperator.Eq, name)};
var result = storage.LoadValues(new[] {"en-US"}, criterias).ToList();
Assert.That(result, Is.Not.Null);
Assert.That(result.Any(), Is.True);
Assert.That(result.FirstOrDefault().Name, Is.EqualTo(name));
}
});
5.Times(i =>
{
using (mp.Step("find by NAME with sql delimiter character " + i))
{
var criterias = new List<Criteria> { new Criteria("name", CriteriaOperator.Eq, "'") };
var result = storage.LoadValues(new[] { "en-US" }, criterias).ToList();
Assert.That(result, Is.Null.Or.Empty);
}
});
5.Times(i =>
{
using (mp.Step("find by SKU criteria/tags " + i))
{
var criterias = new List<Criteria> {new Criteria("sku", CriteriaOperator.Contains, sku)};
var result = storage.LoadValues(new[] {"en-US"}, criterias).ToList();
Assert.That(result, Is.Not.Null);
Assert.That(result.Any(), Is.True);
Assert.That(result.FirstOrDefault().Skus.FirstOrDefault().Sku, Is.EqualTo(sku));
}
});
5.Times(i =>
{
using (mp.Step("find by timestamp " + i))
{
var result = storage.LoadValues(new[] { "en-US" }, fromDateTime:DateTime.Now.AddMonths(-1), tillDateTime:DateTime.Now).ToList();
Assert.That(result, Is.Not.Null);
Assert.That(result.Any(), Is.True);
}
});
Log.Debug($"trace: {mp.RenderPlainText()}");
MiniProfiler.Stop();
}