public override void EndTableLoad(IDbConnection connection, TableSchema table)
{
foreach (var column in table.Columns)
{
// Update sequence to make sure that next generated value
// will not cause a constraint violation.
//
if (!column.AutoIncrement)
continue;
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = @"SELECT MAX(" + MakeDdlElementName(column.Name) +
@") FROM " + MakeDdlElementName(table.Name);
cmd.CommandTimeout = 0;
var maxValue = Convert.ToInt32(cmd.ExecuteScalar());
if (maxValue <= 0)
continue;
var genName = ParseName(_generatorPrefix, table.Name, column.Name);
var dbsmGenerator = new DBGenerator {Name = genName, StartValue = maxValue};
cmd.CommandText = MakeDdlGeneratorSet(dbsmGenerator);
cmd.ExecuteNonQuery();
}
}
base.EndTableLoad(connection, table);
}
private static List <DBGenerator> GetGenerators(FbConnection con)
{
using (var cmd = con.CreateCommand())
{
var generators = new List <DBGenerator>();
string[] restrict4 = { null, null, null, null };
restrict4[0] = null;
restrict4[1] = null;
restrict4[2] = null;
restrict4[3] = null;
var dtGenerators = con.GetSchema("Generators", restrict4);
for (var i = 0; i < dtGenerators.Rows.Count; i++)
{
var trRow = dtGenerators.Rows[i];
if (Convert.ToBoolean(trRow["IS_SYSTEM_GENERATOR"], CultureInfo.InvariantCulture))
{
continue;
}
var eGenerator = new DBGenerator
{
Name = trRow["GENERATOR_NAME"].ToString()
};
cmd.CommandText = string.Format("SELECT gen_id(\"{0}\", 0) FROM rdb$database", eGenerator.Name);
eGenerator.StartValue = Convert.ToInt32(cmd.ExecuteScalar(), CultureInfo.InvariantCulture);
generators.Add(eGenerator);
}
return(generators);
}
}
// Use this for initialization
void Start()
{
// Get the dodgeball generator
_dBGenerator = GameObject.FindGameObjectWithTag("DBGenerator").GetComponent <DBGenerator>();
_controller = Controller.GetComponent <Controller>();
// Get an array of all the dodgeballs that have changes to be sent
// Balls should only be updated when there is a change otherwise it can make the dodgeballs movement choppy
_updatedBalls = _dBGenerator.BallUpdates;
_networkManager = GameObject.FindGameObjectWithTag("NetworkManager").GetComponent <NetworkManager>();
Players = 0;
_temp = 0.0f;
}
public override void EndTableLoad(IDbConnection connection, TableSchema table)
{
foreach (var column in table.Columns)
{
// Update sequence to make sure that next generated value
// will not cause a constraint violation.
//
if (!column.AutoIncrement)
{
continue;
}
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = @"SELECT MAX(" + MakeDdlElementName(column.Name) +
@") FROM " + MakeDdlElementName(table.Name);
cmd.CommandTimeout = 0;
var maxValue = Convert.ToInt32(cmd.ExecuteScalar());
if (maxValue <= 0)
{
continue;
}
var genName = ParseName(_generatorPrefix, table.Name, column.Name);
var dbsmGenerator = new DBGenerator {
Name = genName, StartValue = maxValue
};
cmd.CommandText = MakeDdlGeneratorSet(dbsmGenerator);
cmd.ExecuteNonQuery();
}
}
base.EndTableLoad(connection, table);
}
private static List<DBGenerator> GetGenerators(FbConnection con)
{
using (var cmd = con.CreateCommand())
{
var generators = new List<DBGenerator>();
string[] restrict4 = {null, null, null, null};
restrict4[0] = null;
restrict4[1] = null;
restrict4[2] = null;
restrict4[3] = null;
var dtGenerators = con.GetSchema("Generators", restrict4);
for (var i = 0; i < dtGenerators.Rows.Count; i++)
{
var trRow = dtGenerators.Rows[i];
if (Convert.ToBoolean(trRow["IS_SYSTEM_GENERATOR"], CultureInfo.InvariantCulture))
continue;
var eGenerator = new DBGenerator
{
Name = trRow["GENERATOR_NAME"].ToString()
};
cmd.CommandText = $"SELECT gen_id(\"{eGenerator.Name}\", 0) FROM rdb$database";
eGenerator.StartValue = Convert.ToInt32(cmd.ExecuteScalar(), CultureInfo.InvariantCulture);
generators.Add(eGenerator);
}
return generators;
}
}
private string MakeDdlGeneratorSet(DBGenerator gen)
{
return(string.Format(@"SET GENERATOR {0} TO {1}",
MakeDdlElementName(gen.Name),
gen.StartValue));
}
private string MakeDdlGeneratorSet(DBGenerator gen)
{
return string.Format(@"SET GENERATOR {0} TO {1}",
MakeDdlElementName(gen.Name),
gen.StartValue);
}
private string MakeDdlGeneratorSet(DBGenerator gen)
{
return $@"SET GENERATOR {MakeDdlElementName(gen.Name)} TO {gen.StartValue}";
}
