PublicPlaceTableSync::SearchResult PublicPlaceTableSync::Search(
Env& env,
optional<RegistryKeyType> cityId,
optional<string> name,
int first /*= 0*/,
optional<std::size_t> number /*= 0*/,
LinkLevel linkLevel
){
SelectQuery<PublicPlaceTableSync> query;
if(cityId)
{
query.addWhereField(COL_CITYID, *cityId);
}
if(name)
{
query.addWhereField(COL_NAME, *name, ComposedExpression::OP_LIKE);
}
if (number)
query.setNumber(*number + 1);
if (first > 0)
query.setFirst(first);
return LoadFromQuery(query, env, linkLevel);
}
TimetableRowGroupItemTableSync::SearchResult TimetableRowGroupItemTableSync::Search(
util::Env& env,
boost::optional<util::RegistryKeyType> timetableRowGroupId,
boost::optional<size_t> rank,
int first,
boost::optional<std::size_t> number,
bool orderByRank,
bool raisingOrder,
util::LinkLevel linkLevel
){
SelectQuery<TimetableRowGroupItemTableSync> query;
if (timetableRowGroupId)
{
query.addWhereField(SimpleObjectFieldDefinition<TimetableRowGroup>::FIELD.name, *timetableRowGroupId);
}
if(rank)
{
query.addWhereField(SimpleObjectFieldDefinition<Rank>::FIELD.name, *rank);
}
if(orderByRank)
{
query.addOrderField(SimpleObjectFieldDefinition<Rank>::FIELD.name, raisingOrder);
}
if (number)
{
query.setNumber(*number + 1);
if (first > 0)
query.setFirst(first);
}
return LoadFromQuery(query, env, linkLevel);
}
InterSYNTHESESlaveTableSync::SearchResult InterSYNTHESESlaveTableSync::Search(
Env& env,
std::string name
, int first /*= 0*/,
boost::optional<std::size_t> number
, bool orderByName
, bool raisingOrder,
LinkLevel linkLevel
){
SelectQuery<InterSYNTHESESlaveTableSync> query;
if (!name.empty())
{
query.addWhereField(SimpleObjectFieldDefinition<Name>::FIELD.name, name, ComposedExpression::OP_LIKE);
}
if (orderByName)
{
query.addOrderField(SimpleObjectFieldDefinition<Name>::FIELD.name, raisingOrder);
}
if (number)
{
query.setNumber(*number + 1);
}
if (first > 0)
{
query.setFirst(first);
}
return LoadFromQuery(query, env, linkLevel);
}
TimetableRowTableSync::SearchResult TimetableRowTableSync::Search(
Env& env,
optional<RegistryKeyType> timetableId
, bool orderByTimetable
, bool raisingOrder
, int first
, boost::optional<std::size_t> number,
LinkLevel linkLevel
){
SelectQuery<TimetableRowTableSync> query;
// Selection
if (timetableId)
{
query.addWhereField(COL_TIMETABLE_ID, *timetableId);
}
// Ordering
if (orderByTimetable)
{
query.addOrderField(COL_TIMETABLE_ID, raisingOrder);
query.addOrderField(COL_RANK, raisingOrder);
}
// Size
if (number)
query.setNumber(*number + 1);
if (first > 0)
query.setFirst(first);
return LoadFromQuery(query, env, linkLevel);
}
MapSourceTableSync::SearchResult MapSourceTableSync::Search(
util::Env& env,
optional<string> name,
size_t first /*= 0*/,
optional<size_t> number /*= boost::optional<std::size_t>()*/,
bool orderByName,
bool raisingOrder,
util::LinkLevel linkLevel
){
SelectQuery<MapSourceTableSync> query;
if(name)
{
query.addWhereField(COL_NAME, *name, ComposedExpression::OP_LIKE);
}
if(orderByName)
{
query.addOrderField(COL_NAME, raisingOrder);
}
if (number)
{
query.setNumber(*number + 1);
}
if (first > 0)
{
query.setFirst(first);
}
return LoadFromQuery(query, env, linkLevel);
}
DriverAllocationTemplateTableSync::SearchResult DriverAllocationTemplateTableSync::Search(
util::Env& env,
boost::gregorian::date date /*= boost::gregorian::date(not_a_date_time)*/,
size_t first /*= 0*/,
boost::optional<std::size_t> number /*= boost::optional<std::size_t>()*/,
bool orderByDate /*= true*/,
bool raisingOrder /*= true*/,
util::LinkLevel linkLevel /*= util::UP_LINKS_LOAD_LEVEL */
) {
SelectQuery<DriverAllocationTemplateTableSync> query;
if (!date.is_not_a_date())
{
query.addWhereField(SimpleObjectFieldDefinition<Date>::FIELD.name, to_iso_extended_string(date));
}
if (orderByDate)
{
query.addOrderField(SimpleObjectFieldDefinition<Date>::FIELD.name, raisingOrder);
}
if (number)
{
query.setNumber(*number + 1);
}
if (first > 0)
{
query.setFirst(first);
}
return LoadFromQuery(query, env, linkLevel);
}
RoadChunkTableSync::SearchResult RoadChunkTableSync::Search(
Env& env,
optional<RegistryKeyType> roadId,
int first /*= 0*/,
boost::optional<std::size_t> number /*= 0*/,
LinkLevel linkLevel
){
SelectQuery<RoadChunkTableSync> query;
if(roadId)
{
query.addWhereField(COL_ROADID, *roadId);
}
if (number)
query.setNumber(*number + 1);
if (first > 0)
query.setFirst(first);
return LoadFromQuery(query, env, linkLevel);
}
