public void CreateSampleSchema(DcSchema schema)
{
DcSpace space = schema.Space;
DcColumn d1, d2, d3, d4;
DcTable departments = space.CreateTable(DcSchemaKind.Dc, "Departments", schema.Root);
d1 = space.CreateColumn("name", departments, schema.GetPrimitiveType("String"), true);
d2 = space.CreateColumn("location", departments, schema.GetPrimitiveType("String"), false);
DcTableWriter writer;
writer = departments.GetData().GetTableWriter();
writer.Open();
writer.Append(new DcColumn[] { d1, d2 }, new object[] { "SALES", "Dresden" });
writer.Append(new DcColumn[] { d1, d2 }, new object[] { "HR", "Walldorf" });
writer.Close();
DcTable employees = space.CreateTable(DcSchemaKind.Dc, "Employees", schema.Root);
d1 = space.CreateColumn("name", employees, schema.GetPrimitiveType("String"), true);
d2 = space.CreateColumn("age", employees, schema.GetPrimitiveType("Double"), false);
d3 = space.CreateColumn("salary", employees, schema.GetPrimitiveType("Double"), false);
d4 = space.CreateColumn("dept", employees, departments, false);
DcTable managers = space.CreateTable(DcSchemaKind.Dc, "Managers", employees);
d1 = space.CreateColumn("title", managers, schema.GetPrimitiveType("String"), false);
d2 = space.CreateColumn("is project manager", managers, schema.GetPrimitiveType("Boolean"), false);
}
public static void CreateSampleSchema(DcSchema schema)
{
DcSpace space = schema.Space;
// Table 1
DcTable t1 = space.CreateTable(DcSchemaKind.Dc, "Table 1", schema.Root);
DcColumn c11 = space.CreateColumn("Column 11", t1, schema.GetPrimitiveType("Integer"), true);
DcColumn c12 = space.CreateColumn("Column 12", t1, schema.GetPrimitiveType("String"), true);
DcColumn c13 = space.CreateColumn("Column 13", t1, schema.GetPrimitiveType("Double"), false);
DcColumn c14 = space.CreateColumn("Column 14", t1, schema.GetPrimitiveType("Decimal"), false);
// Table 2
DcTable t2 = space.CreateTable(DcSchemaKind.Dc, "Table 2", schema.Root);
DcColumn c21 = space.CreateColumn("Column 21", t2, schema.GetPrimitiveType("String"), true);
DcColumn c22 = space.CreateColumn("Column 22", t2, schema.GetPrimitiveType("Integer"), true);
DcColumn c23 = space.CreateColumn("Column 23", t2, schema.GetPrimitiveType("Double"), false);
DcColumn c24 = space.CreateColumn("Table 1", t2, t1, false);
}
private void OkCommand_Executed(object state)
{
DcSpace space = mainVM.Space;
if (IsNew)
{
// Create a new table using parameters in the dialog
TableCsv table = (TableCsv)space.CreateTable(DcSchemaKind.Csv, TableName, Schema.Root);
table.GetData().WhereFormula = TableFormula;
table.FilePath = FilePath;
table.HasHeaderRecord = HasHeaderRecord;
table.Delimiter = Delimiter;
table.CultureInfo.NumberFormat.NumberDecimalSeparator = Decimal;
// Load (read-only) column descriptions from CSV to schema
//var columns = table.LoadSchema();
//var columns = ((SchemaCsv)Schema).LoadSchema(table);
Table = table;
}
else
{
TableCsv table = (TableCsv)Table;
table.Name = TableName;
table.GetData().WhereFormula = TableFormula;
table.FilePath = FilePath;
table.HasHeaderRecord = HasHeaderRecord;
table.Delimiter = Delimiter;
table.CultureInfo.NumberFormat.NumberDecimalSeparator = Decimal;
foreach (DcColumn col in table.Columns.ToArray())
{
if (!col.IsSuper)
{
space.DeleteColumn(col);
}
}
// Load (read-only) column descriptions from CSV to schema
//var columns = table.LoadSchema();
//var columns = ((SchemaCsv)Schema).LoadSchema(table);
}
((Com.Schema.Table)Table).NotifyPropertyChanged("");
this.DialogResult = true;
}
private void OkCommand_Executed(object state)
{
DcSpace space = mainVM.Space;
if (IsNew)
{
// Create a new table using parameters in the dialog
DcTable table = space.CreateTable(DcSchemaKind.Dc, TableName, Schema.Root);
table.GetData().WhereFormula = TableFormula;
Table = table;
}
else
{
Table.Name = TableName;
Table.GetData().WhereFormula = TableFormula;
}
((Com.Schema.Table)Table).NotifyPropertyChanged("");
this.DialogResult = true;
}
