public static void CreateTable <T1, T2, T3, T4>(string connectionText)
{
NSqliteTableInfo.CreateTableInfo <T1>(connectionText);
NSqliteTableInfo.CreateTableInfo <T2>(connectionText);
NSqliteTableInfo.CreateTableInfo <T3>(connectionText);
NSqliteTableInfo.CreateTableInfo <T4>(connectionText);
}
public static void CreateTable <T1, T2, T3, T4, T5, T6, T7, T8>(string connectionText)
{
NSqliteTableInfo.CreateTableInfo <T1>(connectionText);
NSqliteTableInfo.CreateTableInfo <T2>(connectionText);
NSqliteTableInfo.CreateTableInfo <T3>(connectionText);
NSqliteTableInfo.CreateTableInfo <T4>(connectionText);
NSqliteTableInfo.CreateTableInfo <T5>(connectionText);
NSqliteTableInfo.CreateTableInfo <T6>(connectionText);
NSqliteTableInfo.CreateTableInfo <T7>(connectionText);
NSqliteTableInfo.CreateTableInfo <T8>(connectionText);
}
public static void CreateTable <Table1, Table2, Table3>(string connectionText)
{
NSqliteTableInfo.CreateTableInfo <Table1>(connectionText);
NSqliteTableInfo.CreateTableInfo <Table2>(connectionText);
NSqliteTableInfo.CreateTableInfo <Table3>(connectionText);
}
/// <summary>
/// 建立資料表
/// </summary>
/// <typeparam name="Table">目標資料表</typeparam>
/// <param name="connectionText">資料庫連線</param>
public static void CreateTable <Table>(string connectionText)
{
NSqliteTableInfo.CreateTableInfo <Table>(connectionText);
}
internal static void CreateTableInfo <T>(string connectionText)
{
var type = typeof(T);
var tableAttr = type.GetCustomAttribute <SqliteTableAttribute>();
if (tableAttr is null)
{
throw new Exception($"{type.Name} 需要有 Table 標籤 e.g. [SqliteTable(\"{type.Name}\")]");
}
// 取得有效的欄位資訊
var props = type.GetProperties(NSqlite.BINDING_FLAGS);
var fieldInfos = new NSqliteFieldInfo[props.Length];
int len = 0;
foreach (var prop in props)
{
if (prop.GetCustomAttribute <SqliteFieldAttribute>() != null)
{
fieldInfos[len++] = new NSqliteFieldInfo(prop);
}
}
Array.Resize(ref fieldInfos, len);
// 資料庫端驗證
using (var conn = new SqliteConnection(connectionText))
{
StringBuilder CreateSchema()
{
var queryBuilder = new StringBuilder($"CREATE TABLE {tableAttr.Name} (");
foreach (var field in fieldInfos)
{
var attributes = field.Info.GetCustomAttributes <SqliteConstraintAttribute>(true);
queryBuilder
.Append(field.Name, ' ', field.Type, ' ') // 欄位資料
.Append(attributes, " ") // 欄位約束
.Append(",");
}
queryBuilder.Length--;
queryBuilder.Append(")"); // 因為 Sqlite 回傳的沒有分號，所以不加
return(queryBuilder);
}
conn.Open();
using (var cmd = conn.CreateCommand())
{
// 若 Sqlite 無同名的資料表，新增之
if (cmd.ExecuteScalar($"SELECT name FROM sqlite_master WHERE type='table' AND name='{tableAttr.Name}';") is null)
{
var query = CreateSchema().Append(';').ToString();
cmd.ExecuteNonQuery(query);
}
// 若 Sqlite 有同名的資料表，驗證之
else if (NSqlite.Option.HasFlag(NSqliteOption.CheckSchema))
{
var sqliteSchema = cmd.ExecuteScalar($"SELECT sql FROM sqlite_master WHERE name == '{tableAttr.Name}'").ToString();
if (sqliteSchema != CreateSchema().ToString())
{
throw new Exception("C# 與 Sqlite 端的資料表架構不相同");
}
}
}
}
// 儲存資料表快取
tableInfos[type] = new NSqliteTableInfo(tableAttr.Name, fieldInfos, connectionText);
}