Add test by SqlLite

7k8m · 7k8m · commit a45ba4b79e43 · 2018-11-21T22:39:06.000+09:00
diff --git a/DirectSQL.sln b/DirectSQL.sln
@@ -5,6 +5,8 @@ VisualStudioVersion = 15.0.28307.102
 MinimumVisualStudioVersion = 10.0.40219.1
 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "DirectSQL", "DirectSQL\DirectSQL.csproj", "{A6636FD9-B9C3-44A0-A000-B49FB7161005}"
 EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "TestSqlLiteDatabase", "TestSqlLiteDatabase\TestSqlLiteDatabase.csproj", "{7374B388-0BA1-49FD-8051-F17044D01C39}"
+EndProject
 Global
 	GlobalSection(SolutionConfigurationPlatforms) = preSolution
 		Debug|Any CPU = Debug|Any CPU
@@ -15,6 +17,10 @@ Global
 		{A6636FD9-B9C3-44A0-A000-B49FB7161005}.Debug|Any CPU.Build.0 = Debug|Any CPU
 		{A6636FD9-B9C3-44A0-A000-B49FB7161005}.Release|Any CPU.ActiveCfg = Release|Any CPU
 		{A6636FD9-B9C3-44A0-A000-B49FB7161005}.Release|Any CPU.Build.0 = Release|Any CPU
+		{7374B388-0BA1-49FD-8051-F17044D01C39}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{7374B388-0BA1-49FD-8051-F17044D01C39}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{7374B388-0BA1-49FD-8051-F17044D01C39}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{7374B388-0BA1-49FD-8051-F17044D01C39}.Release|Any CPU.Build.0 = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(SolutionProperties) = preSolution
 		HideSolutionNode = FALSE
diff --git a/DirectSQL/Database.cs b/DirectSQL/Database.cs
@@ -7,9 +7,10 @@ namespace DirectSQL
     public abstract class Database
     {
 
-        public delegate Task SqlExecution(IDbConnection connection, IDbTransaction transaction);
+        public delegate void SqlExecution(IDbConnection connection, IDbTransaction transaction);
+        public delegate Task AsyncSqlExecution(IDbConnection connection, IDbTransaction transaction);
 
-        public async Task ProcessAsync(SqlExecution execute)
+        public async Task ProcessAsync(AsyncSqlExecution execute)
         {
 
             using ( var connection = CreateConnection())
@@ -36,7 +37,8 @@ public async Task ProcessAsync(SqlExecution execute)
 
         public void Process(SqlExecution execute)
         {
-            Task task = ProcessAsync(execute);
+            Task task = 
+                ProcessAsync( async( connection, transaction ) => { execute(connection, transaction); });
             task.Wait();
 
             if (task.Exception == null)
diff --git a/TestSqlLiteDatabase/ConnectionTest.cs b/TestSqlLiteDatabase/ConnectionTest.cs
@@ -0,0 +1,22 @@
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+
+using System.Data;
+using DirectSQL.SqlLite;
+
+using System.Threading.Tasks;
+
+namespace TestSqlLiteDatabase
+{
+    [TestClass]
+    public class ConnectionTest
+    {
+        [TestMethod]
+        public void TestConnect()
+        {
+            SqlLiteDatabase db = new SqlLiteDatabase("Data Source=:memory:");
+            db.Process( async (connection, transaction) =>
+            {
+            });
+        }
+    }
+}
diff --git a/TestSqlLiteDatabase/TestSqlLiteDatabase.csproj b/TestSqlLiteDatabase/TestSqlLiteDatabase.csproj
@@ -0,0 +1,20 @@
+<Project Sdk="Microsoft.NET.Sdk">
+
+  <PropertyGroup>
+    <TargetFramework>netcoreapp2.1</TargetFramework>
+
+    <IsPackable>false</IsPackable>
+  </PropertyGroup>
+
+  <ItemGroup>
+    <PackageReference Include="Microsoft.NET.Test.Sdk" Version="15.9.0" />
+    <PackageReference Include="MSTest.TestAdapter" Version="1.3.2" />
+    <PackageReference Include="MSTest.TestFramework" Version="1.3.2" />
+    <PackageReference Include="System.Data.SQLite.Core" Version="1.0.109.2" />
+  </ItemGroup>
+
+  <ItemGroup>
+    <ProjectReference Include="..\DirectSQL\DirectSQL.csproj" />
+  </ItemGroup>
+
+</Project>

Original file line number	Diff line number	Diff line change
`@@ -7,9 +7,10 @@ namespace DirectSQL`
`7`	`7`	`public abstract class Database`
`8`	`8`	`{`
`9`	`9`
`10`		`- public delegate Task SqlExecution(IDbConnection connection, IDbTransaction transaction);`
	`10`	`+ public delegate void SqlExecution(IDbConnection connection, IDbTransaction transaction);`
	`11`	`+ public delegate Task AsyncSqlExecution(IDbConnection connection, IDbTransaction transaction);`
`11`	`12`
`12`		`- public async Task ProcessAsync(SqlExecution execute)`
	`13`	`+ public async Task ProcessAsync(AsyncSqlExecution execute)`
`13`	`14`	`{`
`14`	`15`
`15`	`16`	`using ( var connection = CreateConnection())`
`@@ -36,7 +37,8 @@ public async Task ProcessAsync(SqlExecution execute)`
`36`	`37`
`37`	`38`	`public void Process(SqlExecution execute)`
`38`	`39`	`{`
`39`		`- Task task = ProcessAsync(execute);`
	`40`	`+ Task task =`
	`41`	`+ ProcessAsync( async( connection, transaction ) => { execute(connection, transaction); });`
`40`	`42`	`task.Wait();`
`41`	`43`
`42`	`44`	`if (task.Exception == null)`