private static void AddProteinColumns(SQLiteConnection connection)
{
using (var adder = new SQLiteColumnAdder(SqlTableCommandDictionary[SqlTable.WuHistory].TableName, connection))
{
adder.AddColumn("WorkUnitName", "VARCHAR(30)");
adder.AddColumn("KFactor", "FLOAT");
adder.AddColumn("Core", "VARCHAR(20)");
adder.AddColumn("Frames", "INT");
adder.AddColumn("Atoms", "INT");
adder.AddColumn("Credit", "FLOAT");
adder.AddColumn("PreferredDays", "FLOAT");
adder.AddColumn("MaximumDays", "FLOAT");
adder.Execute(false);
}
}
private void AddProteinColumns()
{
using (var connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
using (var adder = new SQLiteColumnAdder(SqlTableCommandDictionary[SqlTable.WuHistory].TableName, connection))
{
adder.AddColumn("WorkUnitName", "VARCHAR(30)");
adder.AddColumn("KFactor", "FLOAT");
adder.AddColumn("Core", "VARCHAR(20)");
adder.AddColumn("Frames", "INT");
adder.AddColumn("Atoms", "INT");
adder.AddColumn("Credit", "FLOAT");
adder.AddColumn("PreferredDays", "FLOAT");
adder.AddColumn("MaximumDays", "FLOAT");
adder.Execute();
}
}
}
private static string SetDefaultValue(string columnDef)
{
return(String.Format(CultureInfo.InvariantCulture, columnDef, SQLiteColumnAdder.GetDefaultValue(columnDef)));
}
private void UpgradeWuHistory1()
{
var adder = new SQLiteColumnAdder
{
TableName = SqlTableCommandDictionary[SqlTable.WuHistory].TableName,
Connection = Connection
};
adder.AddColumn("WorkUnitName", "VARCHAR(30)");
adder.AddColumn("KFactor", "FLOAT");
adder.AddColumn("Core", "VARCHAR(20)");
adder.AddColumn("Frames", "INT");
adder.AddColumn("Atoms", "INT");
adder.AddColumn("SlotType", "VARCHAR(20)");
adder.AddColumn("Credit", "FLOAT");
adder.AddColumn("PreferredDays", "FLOAT");
adder.AddColumn("MaximumDays", "FLOAT");
adder.Execute();
}
