/// <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"); }