/// <summary> /// /// </summary> public TableParams() { TableName = "Anonymous Table"; GameType = GameTypeEnum.Holdem; Variant = "Texas Hold'Em"; MinPlayersToStart = 2; MaxPlayers = 10; WaitingTimes = new ConfigurableWaitingTimes(); MoneyUnit = 10; Lobby = new LobbyOptionsQuickMode(); Blind = new BlindOptionsNone() { MoneyUnit = MoneyUnit }; Limit = new LimitOptionsPot(); }
/// <summary> /// Adds limits to the command builder. /// </summary> /// <param name="skip">The number of rows to skip.</param> /// <param name="take">Number of rows to take.</param> /// <param name="limitOptions">The limit options.</param> /// <param name="seed">The seed for repeatable reads. Only applies to random sampling</param> /// <returns></returns> protected override TableDbCommandBuilder <OleDbCommand, OleDbParameter, SqlServerLimitOption> OnWithLimits(int?skip, int?take, LimitOptions limitOptions, int?seed) { m_Seed = seed; m_Skip = skip; m_Take = take; m_LimitOptions = (SqlServerLimitOption)limitOptions; return(this); }
/// <summary> /// Adds limits to the command builder. /// </summary> /// <param name="skip">The number of rows to skip.</param> /// <param name="take">Number of rows to take.</param> /// <param name="limitOptions">The limit options.</param> /// <param name="seed">The seed for repeatable reads. Only applies to random sampling</param> /// <returns>TableDbCommandBuilder<NpgsqlCommand, NpgsqlParameter, PostgreSqlLimitOption>.</returns> protected override TableDbCommandBuilder <NpgsqlCommand, NpgsqlParameter, PostgreSqlLimitOption> OnWithLimits(int?skip, int?take, LimitOptions limitOptions, int?seed) { m_Seed = seed; m_Skip = skip; m_Take = take; m_LimitOptions = (PostgreSqlLimitOption)limitOptions; return(this); }
/// <summary> /// Adds limits to the command builder. /// </summary> /// <param name="skip">The number of rows to skip.</param> /// <param name="take">Number of rows to take.</param> /// <param name="limitOptions">The limit options.</param> /// <param name="seed">The seed for repeatable reads. Only applies to random sampling</param> /// <returns></returns> protected override TableDbCommandBuilder <OleDbCommand, OleDbParameter, AccessLimitOption> OnWithLimits(int?skip, int?take, LimitOptions limitOptions, int?seed) { if (skip.HasValue) { throw new NotSupportedException("Row skipping isn't supported by Access"); } if (seed.HasValue) { throw new NotSupportedException("Seed values are not supported by Access"); } //m_Seed = seed; //m_Skip = skip; m_Take = take; m_LimitOptions = (AccessLimitOption)limitOptions; return(this); }
ITableDbCommandBuilder ITableDbCommandBuilder.WithLimits(int take, LimitOptions limitOptions, int?seed) { return(OnWithLimits(null, take, limitOptions, seed)); }
/// <summary> /// Adds limits to the command builder. /// </summary> /// <param name="skip">The number of rows to skip.</param> /// <param name="take">Number of rows to take.</param> /// <param name="limitOptions">The limit options.</param> /// <param name="seed">The seed for repeatable reads. Only applies to random sampling</param> /// <returns></returns> protected abstract TableDbCommandBuilder <TCommand, TParameter, TLimit> OnWithLimits(int?skip, int?take, LimitOptions limitOptions, int?seed);
public static void Compare(LimitOptions l, LimitOptions dl) { Assert.AreEqual(l.GetType(), dl.GetType()); }
public async Task ToTable_WithLimit_Async(string dataSourceName, DataSourceType mode, string tableName, LimitOptions limitOptions) { var dataSource = await DataSourceAsync(dataSourceName, mode); try { var table = dataSource.DatabaseMetadata.GetTableOrView(tableName); var prep = ((ICrudDataSource)dataSource).From(tableName).WithLimits(10, limitOptions); switch (limitOptions) { case LimitOptions.RowsWithTies: case LimitOptions.PercentageWithTies: prep = prep.WithSorting(table.Columns[0].SqlName); break; } var result = await prep.ToTable().ExecuteAsync(); //Assert.IsTrue(result.Rows.Count <= 10, $"Row count was {result.Rows.Count}"); Assert.AreEqual(table.Columns.Count, result.ColumnNames.Count); } finally { Release(dataSource); } }
/// <summary> /// Adds limits to the command builder. /// </summary> /// <param name="skip">The number of rows to skip.</param> /// <param name="take">Number of rows to take.</param> /// <param name="limitOptions">The limit options.</param> /// <param name="seed">The seed for repeatable reads. Only applies to random sampling</param> /// <returns></returns> protected override TableDbCommandBuilder <SQLiteCommand, SQLiteParameter, SQLiteLimitOption> OnWithLimits(int?skip, int?take, LimitOptions limitOptions, int?seed) { //m_Seed = seed; m_Skip = skip; m_Take = take; m_LimitOptions = (SQLiteLimitOption)limitOptions; return(this); }
public void ToTable_WithLimit(string assemblyName, string dataSourceName, DataSourceType mode, string tableName, LimitOptions limitOptions) { var dataSource = DataSource(dataSourceName, mode); WriteLine($"Table {tableName}, Limit Option {limitOptions}"); try { var table = dataSource.DatabaseMetadata.GetTableOrView(tableName); var prep = ((IClass1DataSource)dataSource).From(tableName).WithLimits(10, limitOptions); switch (limitOptions) { case LimitOptions.RowsWithTies: case LimitOptions.PercentageWithTies: prep = prep.WithSorting(table.Columns[0].SqlName); break; } var result = prep.ToTable().Execute(); //Assert.True(result.Rows.Count <= 10, $"Row count was {result.Rows.Count}"); Assert.Equal(table.Columns.Count, result.ColumnNames.Count); } finally { Release(dataSource); } }
/// <summary> /// Adds limits to the command builder. /// </summary> /// <param name="skip">The number of rows to skip.</param> /// <param name="take">Number of rows to take.</param> /// <param name="limitOptions">The limit options.</param> /// <param name="seed">The seed for repeatable reads. Only applies to random sampling</param> /// <returns></returns> TableDbCommandBuilder <TCommand, TParameter, TLimit, TObject> OnWithLimitsTyped(int?skip, int?take, LimitOptions limitOptions, int?seed) => (TableDbCommandBuilder <TCommand, TParameter, TLimit, TObject>)OnWithLimits(skip, take, limitOptions, seed);
ITableDbCommandBuilder <TObject> ITableDbCommandBuilder <TObject> .WithLimits(int take, LimitOptions limitOptions, int?seed) => OnWithLimitsTyped(null, take, limitOptions, seed);