/// <summary>
/// Initializes a new instance of the <see cref="SelectGuildMembersListQuery"/> class.
/// </summary>
/// <param name="connectionPool">DbConnectionPool to use for creating connections to execute the query on.</param>
public SelectGuildMembersListQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ArePrimaryKeys(CharacterTable.DbKeyColumns, "id");
QueryAsserts.ContainsColumns(CharacterTable.DbColumns, "name");
QueryAsserts.ContainsColumns(GuildMemberTable.DbColumns, "rank", "character_id", "guild_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectCharacterEquippedBodiesQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectCharacterEquippedBodiesQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(ItemTable.DbColumns, "id", "equipped_body");
QueryAsserts.ContainsColumns(CharacterEquippedTable.DbColumns, "item_id", "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectAccountCharacterNamesQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectAccountCharacterNamesQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterTable.DbColumns, "name", "id");
QueryAsserts.ContainsColumns(AccountCharacterTable.DbColumns, "account_id", "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectQuestValuesQueryBase{T}"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectQuestRequireFinishCompleteQuestsQuery(DbConnectionPool connectionPool)
: base(connectionPool, QuestRequireFinishQuestTable.TableName)
{
QueryAsserts.ContainsColumns(QuestRequireFinishQuestTable.DbColumns, "req_quest_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="CountAccountCharactersByIDQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public CountAccountCharactersByIDQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(ViewUserCharacterTable.DbColumns, "id");
QueryAsserts.ContainsColumns(AccountCharacterTable.DbColumns, "account_id", "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="InsertWorldStatsCountItemSellQuery"/> class.
/// </summary>
/// <param name="connectionPool">The <see cref="DbConnectionPool"/> to use for creating connections to execute the query on.</param>
/// <exception cref="ArgumentNullException"><paramref name="connectionPool"/> is null.</exception>
public InsertWorldStatsCountItemSellQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(WorldStatsCountItemSellTable.DbColumns, "item_template_id", "count");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectGuildByTagQuery"/> class.
/// </summary>
/// <param name="connectionPool">DbConnectionPool to use for creating connections to execute the query on.</param>
public SelectGuildByTagQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(GuildTable.DbColumns, "tag");
}
/// <summary>
/// Initializes a new instance of the <see cref="UpdateAccountPermissionsQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public UpdateAccountPermissionsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(AccountTable.DbColumns, "id", "permissions");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectAccountCharacterInfoQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectAccountCharacterInfoQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(ViewUserCharacterTable.DbColumns, "name", "body_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="PeerTradingGetLostCashQuery"/> class.
/// </summary>
/// <param name="connectionPool">The <see cref="DbConnectionPool"/> to use for creating connections to execute the query on.</param>
public PeerTradingGetLostCashQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(ActiveTradeCashTable.DbColumns, "cash");
QueryAsserts.ArePrimaryKeys(ActiveTradeCashTable.DbKeyColumns, "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="DeleteCharacterSkillQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public DeleteCharacterSkillQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterSkillTable.DbColumns, "character_id", "skill_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="InsertWorldStatsCountShopBuyQuery"/> class.
/// </summary>
/// <param name="connectionPool">The <see cref="DbConnectionPool"/> to use for creating connections to execute the query on.</param>
/// <exception cref="ArgumentNullException"><paramref name="connectionPool"/> is null.</exception>
public InsertWorldStatsCountShopBuyQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(WorldStatsCountShopBuyTable.DbColumns, "shop_id", "count");
}
/// <summary>
/// Initializes a new instance of the <see cref="InsertGuildMemberQuery"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public InsertGuildMemberQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(GuildMemberTable.DbColumns, "character_id", "guild_id", "rank", "joined");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectCharacterQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectCharacterQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterTable.DbColumns, "name");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectCompletedQuestsQuery"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public SelectCompletedQuestsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterQuestStatusTable.DbColumns, "quest_id", "completed_on", "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectGuildEventsQuery"/> class.
/// </summary>
/// <param name="connectionPool">DbConnectionPool to use for creating connections to execute the query on.</param>
public SelectGuildEventsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(GuildEventTable.DbColumns, "guild_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="DeleteGuildMemberQuery"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public DeleteGuildMemberQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(GuildMemberTable.DbColumns, "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="CreateAccountQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public CreateAccountQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(AccountTable.DbColumns, "name", "password", "email", "time_created", "time_last_login",
"creator_ip");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectGuildMemberByNameQuery"/> class.
/// </summary>
/// <param name="connectionPool">DbConnectionPool to use for creating connections to execute the query on.</param>
public SelectGuildMemberByNameQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(GuildMemberTable.DbColumns, "character_id");
QueryAsserts.ContainsColumns(CharacterTable.DbColumns, "id", "name");
}
/// <summary>
/// Initializes a new instance of the <see cref="InsertWorldStatsCountUserKillNPCQuery"/> class.
/// </summary>
/// <param name="connectionPool">The <see cref="DbConnectionPool"/> to use for creating connections to execute the query on.</param>
/// <exception cref="ArgumentNullException"><paramref name="connectionPool"/> is null.</exception>
public InsertWorldStatsCountUserKillNPCQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(WorldStatsCountUserKillNpcTable.DbColumns, "user_id", "npc_template_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="UpdateTimeLastLoginQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public UpdateTimeLastLoginQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(AccountTable.DbColumns, "id", "time_last_login");
}
/// <summary>
/// Initializes a new instance of the <see cref="DbQueryNonReader{T}"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public InsertCharacterQuestStatusStartQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterQuestStatusTable.DbColumns, "character_id", "quest_id", "started_on");
}
/// <summary>
/// Initializes a new instance of the <see cref="DeleteCharacterQuestStatusKillsQuery"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public DeleteCharacterQuestStatusKillsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterQuestStatusKillsTable.DbColumns, "character_id", "quest_id");
}
/// <summary>
/// DbQueryReader constructor.
/// </summary>
/// <param name="connectionPool">DbConnectionPool to use for creating connections to execute the query on.</param>
public TrySetAccountIPIfNullQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(AccountTable.DbColumns, "id", "time_last_login", "current_ip");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectCharacterStatusEffectsQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectCharacterStatusEffectsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(CharacterStatusEffectTable.DbColumns, "character_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="DbQueryNonReader"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public UpdateGuildQuery(DbConnectionPool connectionPool) : base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ArePrimaryKeys(GuildTable.DbKeyColumns, "id");
QueryAsserts.ContainsColumns(GuildTable.DbColumns, "name", "tag", "id");
}
/// <summary>
/// Initializes a new instance of the <see cref="UpdateAccountUnBanQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public UpdateAccountUnBanQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(AccountBanTable.DbColumns, "account_id", "end_time", "issued_by", "expired");
}
/// <summary>
/// Initializes a new instance of the <see cref="SelectRepeatableQuestsQuery"/> class.
/// </summary>
/// <param name="connectionPool"><see cref="DbConnectionPool"/> to use for creating connections to
/// execute the query on.</param>
public SelectRepeatableQuestsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(QuestTable.DbColumns, "id", "repeatable");
}
/// <summary>
/// Initializes a new instance of the <see cref="PeerTradingGetLostItemsQuery"/> class.
/// </summary>
/// <param name="connectionPool">The <see cref="DbConnectionPool"/> to use for creating connections to execute the query on.</param>
public PeerTradingGetLostItemsQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(ActiveTradeItemTable.DbColumns, "character_id", "item_id");
}
/// <summary>
/// Initializes a new instance of the <see cref="CountRecentlyCreatedAccounts"/> class.
/// </summary>
/// <param name="connectionPool">DbConnectionPool to use for creating connections to execute the query on.</param>
public CountRecentlyCreatedAccounts(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ContainsColumns(AccountTable.DbColumns, "creator_ip", "time_created");
}