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) { if (IsNew) { // Create a new column using parameters in the dialog DcSpace space = mainVM.Space; DcColumn column = space.CreateColumn(ColumnName, Table, SelectedOutputTable, IsKey); column.GetData().Formula = ColumnFormula; column.GetData().IsAppendData = true; Column = column; } else { // Update the column using parameters in the dialog Column.Name = ColumnName; Column.Output = SelectedOutputTable; Column.GetData().Formula = ColumnFormula; } ((Column)Column).NotifyPropertyChanged(""); this.DialogResult = true; }