public bool PostNewTable([FromBody] AddNewTableDTO dto)
{
if (dto.Column.Count != dto.DataType.Count || string.IsNullOrWhiteSpace(dto.TblName))
{
return(false);
}
_sql.CreateTableByArgument(dto);
return(true);
}
public void CreateTableByArgument(AddNewTableDTO dto)
{
string sql = $"CREATE TABLE {dto.TblName}(ID INTEGER PRIMARY KEY AUTOINCREMENT";
for (int i = 0; i < dto.Column.Count; i++)
{
sql += $", {dto.Column[i]} {dto.DataType[i].ToUpper()}";
}
sql += ");";
conn = new SQLiteConnection("Data Source=semanticdatabase.sqlite;Version=3;");
conn.Open();
cmd = new SQLiteCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
