public static string LoadIdByField(this IDBConnection connection, ColumnSpec column, string value)
{
List <string> ids = connection.LoadIdsByConditions(
column.table,
new ComparisonCondition(
column,
ComparisonType.EQUAL,
value
),
Diapasone.unlimited
);
if (ids.Count > 1)
{
throw new CriticalException("not unique");
}
else if (ids.Count == 1)
{
return(ids[0]);
}
else
{
throw new NotFoundInDBException(column, value);
}
}
public JoinSpec(ColumnSpec mainColumn, ITableSpec additionalTable, string alias)
{
this.mainColumn = mainColumn;
this.additionalTableRaw = additionalTable;
this.additionalTable = new TableSpec(additionalTable, alias);
}
public static ColumnOrValue createColumn(ColumnSpec column)
{
return(new ColumnOrValue {
_isColumn = true, _column = column
});
}
public SortSpec(ColumnSpec column, bool ascending)
{
this.column = column;
this.ascending = ascending;
}
public static List <string> LoadIdsByConditions(this IDBConnection connection, ITableSpec table, AbstractCondition conditions, Diapasone diapasone, ColumnSpec idSpec, params SortSpec[] sorts)
{
return(connection.LoadIdsByConditions(table, conditions, diapasone, new JoinSpec[0], sorts, idSpec, false));
}
