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