SQLColumn CreateForeignKey(SQLTable table, string colName, SQLTable fkTable)
{
SQLColumn col = CreateColumn(table, colName);
col.ForeignKey = fkTable.PrimaryKey;
return(col);
}
void BuildHRSchema()
{
SQLTable table;
//tDevDepts
SQLTable deptTable = CreateTable("tDevDepts", "DeptId");
CreateColumn(deptTable, "DeptDesc");
//hr_tEmployees
SQLTable empTable = CreateTable("hr_tEmployees", "Emp_Id");
CreateForeignKey(empTable, "DeptId", deptTable);
{
//hr_tCustomerPlannerHed
SQLTable hedTable = CreateTable("hr_tCustomerPlannerHed", "hedid");
CreateColumn(hedTable, "descr");
//hr_tCustomerPlannerDet
table = CreateTable("hr_tCustomerPlannerDet", "detid");
CreateParentKey(table, "hedid", hedTable);
CreateForeignKey(table, "Emp_Id", empTable);
}
}
SQLColumn CreateColumn(SQLTable table, string colName)
{
SQLColumn col = new SQLColumn(table);
col.Name = colName;
return(col);
}
SQLColumn CreateParentKey(SQLTable table, string colName, SQLTable parentTable)
{
SQLColumn col = CreateColumn(table, colName);
table.ParentKey = col;
col.ForeignKey = parentTable.PrimaryKey;
return(col);
}
SQLTable CreateTable(string tableName, string primaryKey)
{
SQLTable table;
table = new SQLTable();
table.Name = tableName;
m_Tables.Add(tableName, table);
CreatePrimaryKey(table, primaryKey);
return(table);
}
public SQLColumn GetForeignKeyTo(SQLTable table)
{
SQLColumn fk = null;
foreach (var pair in Columns)
{
SQLColumn column = pair.Value;
if (column.ForeignKey != null && column.ForeignKey.Table == table)
{
fk = column;
break;
}
}
return(fk);
}
public SQLColumn(SQLTable table)
{
Table = table;
}
SQLColumn CreatePrimaryKey(SQLTable table, string colName)
{
table.PrimaryKey = CreateColumn(table, colName);
return(table.PrimaryKey);
}
public SQLTable FindTable(string tableName)
{
SQLTable rv = m_Tables[tableName];
return(rv);
}
public FreehandSQLColumn(SQLTable table) : base(table)
{
}