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