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; }