public int CreateTable(string tableName, params SQLiteFieldAffinity[] fieldAffinities)
{
StringBuilder cmdBuilder = new StringBuilder();
cmdBuilder.Append("CREATE TABLE ");
cmdBuilder.Append(tableName);
cmdBuilder.Append(" (");
for (int i = 0; i < fieldAffinities.Length; ++i)
{
SQLiteFieldAffinity fieldAffinity = fieldAffinities[i];
cmdBuilder.Append($"{fieldAffinity.columnName} {fieldAffinity.type}");
if (i < fieldAffinities.Length - 1)
{
cmdBuilder.Append(",");
}
}
cmdBuilder.Append(");");
return(ExecuteNonQuery(cmdBuilder.ToString()));
}
public int CreateColumn(string tableName, SQLiteFieldAffinity memberInfo)
{
string cmdText = $"ALTER TABLE {tableName} ADD COLUMN {memberInfo.columnName} {memberInfo.type.ToString()};";
return(ExecuteNonQuery(cmdText));
}