public static void Main()
{
var dbGenerator = new DbGenerator();
var db = new Database();
var orderDbEntities = from d in dbGenerator.GetSequence(1000)
select d;
db.AddRange(orderDbEntities);
var items = db.FindBy("Jack", "Johnson");
var ages = db.FindBy(30);
var orderDbEntities1 = from d in dbGenerator.GetSequence()
select d;
db.AddRange(orderDbEntities1);
var items1 = db.FindBy("Charlie", "Smith");
Console.WriteLine($"items: {items.Count}\titems1: {items1.Count}");
var ages1 = db.FindBy(30);
Console.WriteLine($"ages: {ages.Count}\tages1: {ages1.Count}");
}
public Generator(uint idMap, uint idMonster, ushort usX, ushort usY, ushort usCx, ushort usCy)
{
m_dbGen = new DbGenerator
{
Mapid = idMap,
BoundX = usX,
BoundY = usY,
BoundCx = usCx,
BoundCy = usCy,
Npctype = idMonster,
MaxNpc = 0,
MaxPerGen = 0
};
if (!ServerKernel.Maps.TryGetValue(m_dbGen.Mapid, out m_pMap))
{
ServerKernel.Log.SaveLog(string.Format("Could not load map ({0}) for generator ({1})", m_dbGen.Mapid,
m_dbGen.Id));
return;
}
if (!ServerKernel.Monsters.TryGetValue(m_dbGen.Npctype, out m_dbMonster))
{
ServerKernel.Log.SaveLog(string.Format("Could not load monster ({0}) for generator ({1})",
m_dbGen.Npctype, m_dbGen.Id));
return;
}
m_pCenter = new Point(m_dbGen.BoundX + (m_dbGen.BoundCx / 2), m_dbGen.BoundY + (m_dbGen.BoundCy / 2));
Collection = new ConcurrentDictionary <uint, Monster>();
FirstGeneration();
}
public ReportServicesTests()
{
this.db = DbGenerator.GetDbContext();
DbSeeder.SeedNormalUsers(this.db);
DbSeeder.SeedGames(this.db);
this.reportService = new ReportService(this.db, new GameService(this.db));
}
public static void Main()
{
var dbGenerator = new DbGenerator();
foreach (var item in dbGenerator.GetSequence(100))
{
Console.WriteLine(item);
}
}
static void CompileDb(Config.ConfigSettings appConfig, string dbname)
{
var db = OpenDatabase(appConfig, dbName: dbname);
var basePath = appConfig.Database.BasePath;
var gen = new DbGenerator(db, removeAll: false);
gen.CompilePagers();
gen.Compile();
}
public static void Main(string[] args)
{
var host = CreateWebHostBuilder(args).Build();
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
var context = services.GetRequiredService <BlogContext>();
DbGenerator.Inicialize(services);
}
host.Run();
}
public DrawingServiceTests()
{
this.db = DbGenerator.GetDbContext();
DbSeeder.SeedNormalUsers(this.db);
DbSeeder.SeedGames(this.db);
var imageService = new Mock <IImageService>();
imageService
.Setup(s => s.SaveGameDrawing(It.IsAny <string>(), It.IsAny <int>(), It.IsAny <string>()))
.Returns(() => Task.FromResult(ImageUrl));
this.drawingService = new DrawingService(this.db, imageService.Object);
}
public static void Main()
{
var dbGenerator = new DbGenerator();
var db = new Database();
db.AddRange(dbGenerator.GetSequence(10000));
var items = db.FindBy("Jack", "Jones");
Console.WriteLine(items.Count);
var items2 = db.FindBy(30);
Console.WriteLine(items2.Count);
}
static void GenerateInitialDbData(
Config.ConfigSettings appConfig,
string dbname,
DbSchemaConfigType dbConfig,
string zipfile
)
{
var basePath = appConfig.Database.BasePath;
var jsonfilepath = $"{basePath}\\{dbname}\\bin\\__tables.init.json";
var db = CsvDb.CsvDb.CreateFromJson(jsonfilepath, dbConfig);
var gen = new DbGenerator(db, $@"{basePath}{zipfile}", removeAll: false);
gen.Generate();
}
public Generator(DbGenerator dbGen)
{
m_dbGen = dbGen;
}
private FrogMine GetMine()
{
_dbGenerator = new DbGenerator(DbFilename);
return(new FrogMine(_dbGenerator.CreateDb("FrogId")));
}
private FrogLayer GetLayer()
{
_dbGenerator = new DbGenerator();
return(new FrogLayer(_dbGenerator.CreateDb()));
}
public WeixinResLogic(DbGenerator dao)
{
this._dao = dao;
}
public GameServiceTests()
{
this.db = DbGenerator.GetDbContext();
DbSeeder.SeedNormalUsers(this.db);
this.gameService = new GameService(this.db);
}
static void JsonSchemas()
{
var schema = DbGenerator.Schema();
Console.WriteLine(schema);
}
private FrogLayer GetLayer()
{
_dbGenerator = new DbGenerator(DbFilename);
return(new FrogLayer(_dbGenerator.CreateDb("FrogId")));
}
public async Task General()
{
const int recordCount = 10;
using (var dbGenerator = new DbGenerator())
{
var dbInterface = new SqlInterface(dbGenerator.CreateDb());
const string insertSql = "INSERT INTO Frog (Name, DateOfBirth) VALUES (@Name, @DateOfBirth);" +
"SELECT CAST(SCOPE_IDENTITY() AS INT);";
const string readSingleSql = "SELECT * FROM Frog WHERE Id = @Id";
const string readAllSql = "SELECT * FROM Frog";
const string updateSql = "UPDATE Frog SET Name = @NewName WHERE Id BETWEEN @FromId AND @ToId";
var ids = new List <int>();
for (var i = 1; i <= recordCount; i++)
{
var nameParam = new SqlParameter("@Name", $"Kermit{i}");
var dateOfBirthParam = new SqlParameter("@DateOfBirth", DateTime.Today.AddDays(-i));
var statement = new SqlStatement(insertSql, nameParam, dateOfBirthParam);
var id = (int)(await dbInterface.ExecuteScalarAsync(statement).ConfigureAwait(false));
// it's a new DB so should be the case, depending on this for following tests
Assert.Equal(i, id);
ids.Add(id);
}
Assert.Equal(recordCount, ids.Count);
foreach (var id in ids)
{
var idParam = new SqlParameter("@Id", id);
var statement = new SqlStatement(readSingleSql, idParam);
using (var reader = await dbInterface.GetReaderAsync(statement).ConfigureAwait(false))
{
Assert.True(await reader.ReadAsync().ConfigureAwait(false));
Assert.Equal(id, reader["Id"]);
Assert.Equal($"Kermit{id}", reader["Name"]);
Assert.Equal(DateTime.Today.AddDays(-id), Convert.ToDateTime(reader["DateOfBirth"]));
}
}
var updateStatement = new SqlStatement(updateSql, new SqlParameter("@NewName", "Frank"),
new SqlParameter("@FromId", 5), new SqlParameter("@ToId", 8));
var affected = await dbInterface.ExecuteNonQueryAsync(updateStatement).ConfigureAwait(false);
Assert.Equal(4, affected);
var readAllStatement = new SqlStatement(readAllSql);
using (var reader = await dbInterface.GetReaderAsync(readAllStatement).ConfigureAwait(false))
{
var count = 0;
while (await reader.ReadAsync().ConfigureAwait(false))
{
count++;
var id = (int)reader["Id"];
if (id >= 5 && id <= 8)
{
Assert.Equal("Frank", reader["Name"]);
}
else
{
Assert.Equal($"Kermit{id}", reader["Name"]);
}
}
Assert.Equal(recordCount, count);
}
}
}
