/// <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="UpdateItemFieldQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
/// <exception cref="ArgumentNullException"><paramref name="connectionPool" /> is <c>null</c>.</exception>
public UpdateItemFieldQuery(DbConnectionPool connectionPool)
{
if (connectionPool == null)
{
throw new ArgumentNullException("connectionPool");
}
_connectionPool = connectionPool;
_fieldQueryCache =
new HashCache <string, InternalUpdateItemFieldQuery>(
x => new InternalUpdateItemFieldQuery(_connectionPool, GetFieldQueryString(x, connectionPool.QueryBuilder)));
QueryAsserts.ArePrimaryKeys(ItemTable.DbKeyColumns, "id");
}
/// <summary>
/// Initializes a new instance of the <see cref="UpdateCharacterStatusEffectQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public UpdateCharacterStatusEffectQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ArePrimaryKeys(CharacterStatusEffectTable.DbKeyColumns, "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="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="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="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>
/// 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="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="SetAccountCurrentIPNullQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SetAccountCurrentIPNullQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ArePrimaryKeys(AccountTable.DbKeyColumns, "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="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="PeerTradingReplaceCashQuery"/> class.
/// </summary>
/// <param name="connectionPool">The <see cref="DbConnectionPool"/> to use for creating connections to execute the query on.</param>
public PeerTradingReplaceCashQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.AreColumns(ActiveTradeCashTable.DbColumns, "character_id", "cash");
}
/// <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="AccountIDCreator"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public AccountIDCreator(DbConnectionPool connectionPool) : base(connectionPool, AccountTable.TableName, "id", 64)
{
QueryAsserts.ArePrimaryKeys(AccountTable.DbKeyColumns, "id");
}
/// <summary>
/// Initializes a new instance of the <see cref="DeleteMapSpawnQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public DeleteMapSpawnQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ArePrimaryKeys(MapSpawnTable.DbKeyColumns, "id");
}
/// <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="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="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="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="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>
/// 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="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="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="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="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="SelectItemTemplateQuery"/> class.
/// </summary>
/// <param name="connectionPool">The connection pool.</param>
public SelectItemTemplateQuery(DbConnectionPool connectionPool)
: base(connectionPool, CreateQuery(connectionPool.QueryBuilder))
{
QueryAsserts.ArePrimaryKeys(ItemTemplateTable.DbKeyColumns, "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="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="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");
}
