protected override void ExtractColumnInfo(DataRow dr, out string forParent, out string name, out string schemaName, out string tableName, out decimal sequence, out string databaseDataType, out decimal length, out string defaultValue, out bool nullable, out bool primaryKey)
{
forParent = dr.TryGetValue<string>(QueryConstants.Column.For);
name = dr.TryGetValue<string>(QueryConstants.Column.Name);
schemaName = dr.TryGetValue<string>(QueryConstants.TableOrView.SchemaName);
tableName = dr.TryGetValue<string>(QueryConstants.TableOrView.Name);
sequence = dr.TryGetValue<decimal>(QueryConstants.Column.Sequence);
databaseDataType = dr.TryGetValue<string>(QueryConstants.Column.DataType);
length = dr.TryGetValue<decimal>(QueryConstants.Column.Length);
defaultValue = dr.TryGetValue<string>(QueryConstants.Column.DefaultValue);
nullable = YesNoToBool(dr.TryGetValue<string>(QueryConstants.Column.Nullable));
primaryKey = YesNoToBool(dr.TryGetValue<string>(QueryConstants.Column.PrimaryKey));
}
protected virtual void ExtractTableInfo(DataRow dr, out string schemaName, out string name)
{
schemaName = dr.TryGetValue<string>(QueryConstants.TableOrView.SchemaName);
name = dr.TryGetValue<string>(QueryConstants.TableOrView.Name);
}
protected virtual void ExtractUniqueIndexInfo(DataRow dr, out string name, out string schemaName, out string tableName, out string columnName)
{
name = dr.TryGetValue<string>(QueryConstants.Index.Name);
schemaName = dr.TryGetValue<string>(QueryConstants.TableOrView.SchemaName);
tableName = dr.TryGetValue<string>(QueryConstants.TableOrView.Name);
columnName = dr.TryGetValue<string>(QueryConstants.Column.Name);
}
protected virtual void ExtractForeignKeyInfo(DataRow dr, out string name, out string parentTableSchemaName, out string parentTableName, out string parentColumnName, out string referencedTableSchemaName, out string referencedTableName, out string referencedColumnName)
{
name = dr.TryGetValue<string>(QueryConstants.ForeignKey.Name);
parentTableSchemaName = dr.TryGetValue<string>(QueryConstants.ForeignKey.ParentTableSchemaName);
parentTableName = dr.TryGetValue<string>(QueryConstants.ForeignKey.ParentTableName);
parentColumnName = dr.TryGetValue<string>(QueryConstants.ForeignKey.ParentColumnName);
referencedTableSchemaName = dr.TryGetValue<string>(QueryConstants.ForeignKey.ReferencedTableSchemaName);
referencedTableName = dr.TryGetValue<string>(QueryConstants.ForeignKey.ReferencedTableName);
referencedColumnName = dr.TryGetValue<string>(QueryConstants.ForeignKey.ReferencedColumnName);
}