/// <summary>
/// Add a column definition into the provided schema at the given column location
/// </summary>
private string InsertColumnInSchema(SQLiteConnection connection, string tableName, int newColumnNumber, ColumnDefinition newColumn)
{
List<string> columnDefinitions = this.GetColumnDefinitions(connection, tableName);
columnDefinitions.Insert(newColumnNumber, newColumn.ToString());
return String.Join(", ", columnDefinitions);
}
// This method will create a column in a table of type TEXT, where it is added to its end
// It assumes that the value, if not empty, should be treated as the default value for that column
public void AddColumnToEndOfTable(string tableName, ColumnDefinition columnDefinition)
{
this.ExecuteNonQuery("ALTER TABLE " + tableName + " ADD COLUMN " + columnDefinition.ToString());
}