public virtual void Start()
{
audioSource = GetComponent<AudioSource>();
announcer = GameObject.FindGameObjectWithTag("MainCamera").GetComponent<Announcer>();
camFocus = GameObject.FindGameObjectWithTag("MainCamera").GetComponent<CameraFocus>();
gameManager = GameObject.FindGameObjectWithTag("MainCamera").GetComponent<GameManager>();
rbody = GetComponent<Rigidbody>();
Ability2BaseCD = Ability2Cooldown;
Ability3BaseCD = Ability3Cooldown;
Ability4BaseCD = Ability4Cooldown;
AbilityTime1 = -0.002f;
AbilityTime2 = -0.002f;
AbilityTime3 = -0.002f;
AbilityTime4 = -0.002f;
}
protected void AddLocalizedGameString(Announcer announcer)
{
GameStringWriter.AddAnnouncerName(announcer.Id, announcer.Name);
GameStringWriter.AddAnnouncerSortName(announcer.Id, announcer.SortName);
GameStringWriter.AddAnnouncerDescription(announcer.Id, GetTooltip(announcer.Description, FileOutputOptions.DescriptionType));
}
public override void BeginTransaction()
{
Announcer.Say("Beginning Transaction");
Transaction = Connection.BeginTransaction();
}
void Awake()
{
Instance = this;
board = FindObjectOfType<Board>();
sounds = FindObjectOfType<Sounds>();
audioSource = gameObject.GetComponent<AudioSource>();
scoreAudioSource = gameObject.AddComponent<AudioSource>();
crowd = FindObjectOfType<Crowd>();
announcer = FindObjectOfType<Announcer>();
}
/// <summary>
/// Updates the localized gamestrings to the selected <see cref="Localization"/>.
/// </summary>
/// <param name="announcer">The data to be updated.</param>
/// <param name="gameStringDocument">Instance of a <see cref="GameStringDocument"/>.</param>
/// <exception cref="ArgumentNullException"><paramref name="gameStringDocument"/> is null.</exception>
public static void UpdateGameStrings(this Announcer announcer, GameStringDocument gameStringDocument)
{
ArgumentNullException.ThrowIfNull(gameStringDocument, nameof(gameStringDocument));
gameStringDocument.UpdateGameStrings(announcer);
}
public void AnnounceUsing(Announcer announcer)
{
}
public void Process(PerformDBOperationExpression expression)
{
Announcer.Say("Performing DB Operation");
}
public override void CommitTransaction()
{
base.CommitTransaction();
Announcer.Sql("COMMIT TRANSACTION");
}
private static void RunMigrations(string databaseKey)
{
var cs = SqlConnections.GetConnectionString(databaseKey);
var connection = cs.ConnectionString;
string serverType = cs.Dialect.ServerType;
bool isSqlServer = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase);
bool isOracle = serverType.StartsWith("Oracle", StringComparison.OrdinalIgnoreCase);
bool isFirebird = serverType.StartsWith("Firebird", StringComparison.OrdinalIgnoreCase);
string databaseType = isOracle ? "OracleManaged" : serverType;
using (var sw = new StringWriter())
{
Announcer announcer = isOracle || isFirebird ?
new TextWriterAnnouncer(sw)
{
ShowSql = true
} :
new TextWriterWithGoAnnouncer(sw)
{
ShowSql = true
};
var runner = new RunnerContext(announcer)
{
Database = databaseType,
Connection = cs.ConnectionString,
TargetAssemblies = new[] { typeof(DataMigrations).GetAssembly() },
Task = "migrate:up",
WorkingDirectory = Path.GetDirectoryName(typeof(DataMigrations).GetAssembly().Location),
Namespace = "FruitCorrect.Migrations." + databaseKey + "DB",
Timeout = 90
};
var culture = CultureInfo.CurrentCulture;
try
{
if (isFirebird)
{
CultureInfo.CurrentCulture = CultureInfo.InvariantCulture;
}
new TaskExecutor(runner)
{
ConnectionString = cs.ConnectionString
}.Execute();
}
catch (Exception ex)
{
throw new Exception("Error executing migration:\r\n" +
sw.ToString(), ex);
}
finally
{
if (isFirebird)
{
CultureInfo.CurrentCulture = culture;
}
}
}
}
private void Awake()
{
SingletonInstanceGuard();
announce = GameAnnouncer.AnnounceTo(Announcer.TextComponent(m_UIText), Announcer.Log(this));
}
private static void RunMigrations(string databaseKey)
{
var cs = SqlConnections.GetConnectionString(databaseKey);
var connection = cs.ConnectionString;
string serverType = cs.Dialect.ServerType;
bool isSqlServer = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase);
bool isOracle = !isSqlServer && serverType.StartsWith("Oracle", StringComparison.OrdinalIgnoreCase);
// safety check to ensure that we are not modifying an arbitrary database.
// remove these lines if you want Serene migrations to run on your DB.
if (!isOracle && cs.ConnectionString.IndexOf(typeof(SiteInitialization).Namespace +
@"_" + databaseKey + "_v1", StringComparison.OrdinalIgnoreCase) < 0)
{
SkippedMigrations = true;
return;
}
string databaseType = isOracle ? "OracleManaged" : serverType;
var connectionString = cs.ConnectionString;
using (var sw = new StringWriter())
{
Announcer announcer = isOracle ?
new TextWriterAnnouncer(sw)
{
ShowSql = true
} :
new TextWriterWithGoAnnouncer(sw)
{
ShowSql = true
};
var runner = new RunnerContext(announcer)
{
Database = databaseType,
Connection = connectionString,
Targets = new string[] { typeof(SiteInitialization).Assembly.Location },
Task = "migrate:up",
WorkingDirectory = Path.GetDirectoryName(typeof(SiteInitialization).Assembly.Location),
Namespace = "Serene.Migrations." + databaseKey + "DB",
Timeout = 90
};
try
{
new TaskExecutor(runner).Execute();
}
catch (Exception ex)
{
var output = sw.ToString().Trim();
if (output.StartsWith("/*"))
{
var idx = output.IndexOf("*/");
output = output.Substring(idx + 2);
}
throw new Exception("Error executing migration:\r\n" +
output, ex);
}
}
}
void Awake()
{
announcer = this;
text = GetComponent <Text> ();
}
public void Process(Builders.Execute.PerformDBOperationExpression expression)
{
Announcer.Say("Performing DB Operation");
}
public DiscordEventDispatcher(DiscordShardedClient client, CommandHandling commandHandler, OctoGameReaction octoGameReaction, LoginFromConsole log, Global global, ServerActivityLogger serverActivityLogger, UserSkatisticsCounter userSkatisticsCounter, LvLing lvLing, GiveRoleOnJoin giveRoleOnJoin, CheckIfCommandGiveRole checkIfCommandGiveRole, Announcer announcer, CheckForVoiceChannelStateForVoiceCommand checkForVoiceChannelStateForVoiceCommand)
{
_client = client;
_commandHandler = commandHandler;
_octoGameReaction = octoGameReaction;
_log = log;
_global = global;
_serverActivityLogger = serverActivityLogger;
_userSkatisticsCounter = userSkatisticsCounter;
_lvLing = lvLing;
_giveRoleOnJoin = giveRoleOnJoin;
_checkIfCommandGiveRole = checkIfCommandGiveRole;
_announcer = announcer;
_checkForVoiceChannelStateForVoiceCommand = checkForVoiceChannelStateForVoiceCommand;
}
protected void Process(string sql)
{
Announcer.Sql(sql);
}
public override void BeginTransaction()
{
base.BeginTransaction();
Announcer.Sql("BEGIN TRANSACTION");
}
private static void RunMigrations(string databaseKey)
{
var cs = SqlConnections.GetConnectionString(databaseKey);
var connection = cs.ConnectionString;
string serverType = cs.Dialect.ServerType;
bool isSqlServer = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase);
bool isOracle = serverType.StartsWith("Oracle", StringComparison.OrdinalIgnoreCase);
bool isFirebird = serverType.StartsWith("Firebird", StringComparison.OrdinalIgnoreCase);
// safety check to ensure that we are not modifying an arbitrary database.
// remove these lines if you want Serenity migrations to run on your DB.
if (!isOracle && cs.ConnectionString.IndexOf(typeof(DataMigrations).Namespace +
@"_" + databaseKey + "_v1", StringComparison.OrdinalIgnoreCase) < 0)
{
SkippedMigrations = true;
return;
}
string databaseType = isOracle ? "OracleManaged" : serverType;
using (var sw = new StringWriter())
{
Announcer announcer = isOracle || isFirebird ?
new TextWriterAnnouncer(sw)
{
ShowSql = true
} :
new TextWriterWithGoAnnouncer(sw)
{
ShowSql = true
};
var runner = new RunnerContext(announcer)
{
Database = databaseType,
Connection = cs.ConnectionString,
TargetAssemblies = new[] { typeof(DataMigrations).GetAssembly() },
Task = "migrate:up",
WorkingDirectory = Path.GetDirectoryName(typeof(DataMigrations).GetAssembly().Location),
Namespace = "Serenity.Migrations." + databaseKey + "DB",
Timeout = 90
};
var culture = CultureInfo.CurrentCulture;
try
{
if (isFirebird)
{
CultureInfo.CurrentCulture = CultureInfo.InvariantCulture;
}
new TaskExecutor(runner)
{
ConnectionString = cs.ConnectionString
}.Execute();
}
catch (Exception ex)
{
throw new Exception("Error executing migration:\r\n" +
sw.ToString(), ex);
}
finally
{
if (isFirebird)
{
CultureInfo.CurrentCulture = culture;
}
}
}
}
public override void RollbackTransaction()
{
base.RollbackTransaction();
Announcer.Sql("ROLLBACK TRANSACTION");
}
public void AnnounceUsing(Announcer announcer)
{
//announcer.Say(ToString());
}
private Announcer GetAnnouncerData(string announcerId, JsonElement announcerElement)
{
Announcer announcer = new Announcer()
{
Id = announcerId,
};
if (announcerElement.TryGetProperty("name", out JsonElement name))
{
announcer.Name = name.GetString();
}
if (announcerElement.TryGetProperty("hyperlinkId", out JsonElement hyperlinkId))
{
announcer.HyperlinkId = hyperlinkId.GetString();
}
if (announcerElement.TryGetProperty("attributeId", out JsonElement attributeId))
{
announcer.AttributeId = attributeId.GetString();
}
if (announcerElement.TryGetProperty("rarity", out JsonElement rarityElement) && Enum.TryParse(rarityElement.GetString(), out Rarity rarity))
{
announcer.Rarity = rarity;
}
if (announcerElement.TryGetProperty("category", out JsonElement category))
{
announcer.CollectionCategory = category.GetString();
}
if (announcerElement.TryGetProperty("gender", out JsonElement gender))
{
announcer.Gender = gender.GetString();
}
if (announcerElement.TryGetProperty("heroId", out JsonElement heroId))
{
announcer.HeroId = heroId.GetString();
}
if (announcerElement.TryGetProperty("releaseDate", out JsonElement releaseDateElement) && DateTime.TryParse(releaseDateElement.GetString(), out DateTime releaseDate))
{
announcer.ReleaseDate = releaseDate;
}
if (announcerElement.TryGetProperty("sortName", out JsonElement sortName))
{
announcer.SortName = sortName.GetString();
}
if (announcerElement.TryGetProperty("description", out JsonElement description))
{
announcer.Description = SetTooltipDescription(description.GetString(), Localization);
}
if (announcerElement.TryGetProperty("image", out JsonElement image))
{
announcer.ImageFileName = image.GetString();
}
GameStringDocument?.UpdateGameStrings(announcer);
return(announcer);
}
void Awake()
{
announcer = GameObject.FindObjectOfType<Announcer>();
}
void Start()
{
Announcer = FindObjectOfType <Announcer>();
Announcer.Announce("Toddler Counting!", 0.0f, 1.1f);
StartCoroutine(CallToAction());
}
public static GameAnnouncer AnnounceTo(Announcer strategy)
{
var instance = CreateInstance<GameAnnouncer>();
instance.strategy = strategy;
return instance;
}
private static void RunMigrations(string databaseKey)
{
var cs = SqlConnections.GetConnectionString(databaseKey);
var connection = cs.ConnectionString;
string serverType = cs.Dialect.ServerType;
bool isSqlServer = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase);
bool isOracle = serverType.StartsWith("Oracle", StringComparison.OrdinalIgnoreCase);
bool isFirebird = serverType.StartsWith("Firebird", StringComparison.OrdinalIgnoreCase);
// safety check to ensure that we are not modifying an arbitrary database.
// remove these lines if you want MovieTutorial migrations to run on your DB.
//if (!isOracle && cs.ConnectionString.IndexOf(typeof(DataMigrations).Namespace +
// @"_" + databaseKey + "_v1", StringComparison.OrdinalIgnoreCase) < 0)
//{
// SkippedMigrations = true;
// return;
//}
string databaseType = isOracle ? "OracleManaged" : serverType;
using (var sw = new StringWriter())
{
Announcer announcer = isOracle || isFirebird ?
new TextWriterAnnouncer(sw)
{
ShowSql = true
} :
new TextWriterWithGoAnnouncer(sw)
{
ShowSql = true
};
var runner = new RunnerContext(announcer)
{
Database = databaseType,
Connection = cs.ConnectionString,
#if COREFX
TargetAssemblies = new[] { typeof(DataMigrations).Assembly },
#else
Targets = new string[] { typeof(DataMigrations).Assembly.Location },
#endif
Task = "migrate:up",
WorkingDirectory = Path.GetDirectoryName(typeof(DataMigrations).Assembly.Location),
Namespace = "MovieTutorial.Migrations." + databaseKey + "DB",
Timeout = 90
};
var culture = CultureInfo.CurrentCulture;
try
{
if (isFirebird)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
}
new TaskExecutor(runner)
{
#if COREFX
ConnectionString = cs.ConnectionString
#endif
}.Execute();
}
catch (Exception ex)
{
var output = sw.ToString().Trim();
if (output.StartsWith("/*"))
{
var idx = output.IndexOf("*/");
output = output.Substring(idx + 2);
}
throw new Exception("Error executing migration:\r\n" +
output, ex);
}
finally
{
if (isFirebird)
{
Thread.CurrentThread.CurrentCulture = culture;
}
}
}
}
public override void Process(Expressions.AlterColumnExpression expression)
{
truncator.Truncate(expression);
CheckColumn(expression.TableName, expression.Column.Name);
FirebirdSchemaProvider schema = new FirebirdSchemaProvider(this);
FirebirdTableSchema table = schema.GetTableSchema(expression.TableName);
ColumnDefinition colDef = table.Definition.Columns.First(x => x.Name == expression.Column.Name);
//Change nullable constraint
if (colDef.IsNullable != expression.Column.IsNullable)
{
PerformDBOperationExpression unSet = new PerformDBOperationExpression();
unSet.Operation = (connection, transaction) =>
{
string sql = (Generator as FirebirdGenerator).GenerateSetNull(colDef);
Announcer.Sql(sql);
using (var cmd = Factory.CreateCommand(sql, connection, transaction))
{
cmd.CommandTimeout = Options.Timeout;
cmd.ExecuteNonQuery();
}
};
FirebirdProcessedExpressionBase fbExpression = new FirebirdProcessedExpression <AlterColumnExpression>(expression, this);
fbExpression.AddUndoExpression(unSet);
RegisterExpression(fbExpression);
InternalProcess((Generator as FirebirdGenerator).GenerateSetNull(expression.Column));
}
//Change default value
if (!FirebirdGenerator.DefaultValuesMatch(colDef, expression.Column))
{
IMigrationExpression defaultConstraint;
IMigrationExpression unsetDefaultConstraint;
if (expression.Column.DefaultValue is ColumnDefinition.UndefinedDefaultValue)
{
defaultConstraint = new DeleteDefaultConstraintExpression()
{
SchemaName = expression.SchemaName,
TableName = expression.TableName,
ColumnName = expression.Column.Name
};
}
else
{
defaultConstraint = new AlterDefaultConstraintExpression()
{
ColumnName = expression.Column.Name,
DefaultValue = expression.Column.DefaultValue,
TableName = expression.TableName,
SchemaName = expression.SchemaName
};
}
if (colDef.DefaultValue is ColumnDefinition.UndefinedDefaultValue)
{
unsetDefaultConstraint = new DeleteDefaultConstraintExpression()
{
ColumnName = colDef.Name,
TableName = expression.TableName,
SchemaName = expression.SchemaName
};
}
else
{
unsetDefaultConstraint = new AlterDefaultConstraintExpression()
{
ColumnName = colDef.Name,
DefaultValue = colDef.DefaultValue,
TableName = expression.TableName,
SchemaName = expression.SchemaName
};
}
FirebirdProcessedExpressionBase fbExpression = new FirebirdProcessedExpression(defaultConstraint, defaultConstraint.GetType(), this);
fbExpression.AddUndoExpression(unsetDefaultConstraint);
RegisterExpression(fbExpression);
if (defaultConstraint is DeleteDefaultConstraintExpression)
{
InternalProcess(Generator.Generate(defaultConstraint as DeleteDefaultConstraintExpression));
}
else if (defaultConstraint is AlterDefaultConstraintExpression)
{
InternalProcess(Generator.Generate(defaultConstraint as AlterDefaultConstraintExpression));
}
else
{
throw new InvalidOperationException("No expression generated for alter default constraint");
}
}
//Change type
if (!FirebirdGenerator.ColumnTypesMatch(colDef, expression.Column))
{
PerformDBOperationExpression unSet = new PerformDBOperationExpression();
unSet.Operation = (connection, transaction) =>
{
string sql = (Generator as FirebirdGenerator).GenerateSetType(colDef);
Announcer.Sql(sql);
using (var cmd = Factory.CreateCommand(sql, connection, transaction))
{
cmd.CommandTimeout = Options.Timeout;
cmd.ExecuteNonQuery();
}
};
FirebirdProcessedExpressionBase fbExpression = new FirebirdProcessedExpression <AlterColumnExpression>(expression, this);
fbExpression.AddUndoExpression(unSet);
RegisterExpression(fbExpression);
InternalProcess((Generator as FirebirdGenerator).GenerateSetType(expression.Column));
}
bool identitySequenceExists = SequenceExists(String.Empty, GetSequenceName(expression.TableName, expression.Column.Name));
//Adjust identity generators
if (expression.Column.IsIdentity)
{
if (!identitySequenceExists)
{
CreateSequenceForIdentity(expression.TableName, expression.Column.Name);
}
}
else
{
if (identitySequenceExists)
{
DeleteSequenceForIdentity(expression.TableName, expression.Column.Name);
}
}
}
void Start()
{
announcer = GameObject.FindGameObjectWithTag("MainCamera").GetComponent<Announcer>();
doors = GameObject.FindGameObjectsWithTag("Door");
enemiesLeftText = GameObject.Find("RemainingEnemies").GetComponent<Text>();
if (isLevel0)
{
StartCoroutine(announcer.AnnounceMessage("Welcome to the lobby! \n Prepare for battle..."));
}
}
private static void RunMigrations(string databaseKey)
{
var cs = SqlConnections.GetConnectionString(databaseKey);
var connection = cs.ConnectionString;
bool isOracle = cs.Dialect.GetType() == typeof(OracleDialect);
// safety check to ensure that we are not modifying an arbitrary database.
// remove these lines if you want MeetingManagement migrations to run on your DB.
if (!isOracle && cs.ConnectionString.IndexOf(typeof(SiteInitialization).Namespace +
@"_" + databaseKey + "_v1", StringComparison.OrdinalIgnoreCase) < 0)
{
SkippedMigrations = true;
return;
}
string databaseType = "SqlServer";
if (String.Equals(cs.ProviderName, "npgsql", StringComparison.OrdinalIgnoreCase))
{
databaseType = "Postgres";
}
else if (String.Equals(cs.ProviderName, "MySql.Data.MySqlClient", StringComparison.OrdinalIgnoreCase))
{
databaseType = "MySql";
}
else if (isOracle)
{
databaseType = "OracleManaged";
}
using (var sw = new StringWriter())
{
Announcer announcer = isOracle ?
new TextWriterAnnouncer(sw)
{
ShowSql = true
} :
new TextWriterWithGoAnnouncer(sw)
{
ShowSql = true
};
var runner = new RunnerContext(announcer)
{
Database = databaseType,
Connection = cs.ConnectionString,
Targets = new string[] { typeof(SiteInitialization).Assembly.Location },
Task = "migrate:up",
WorkingDirectory = Path.GetDirectoryName(typeof(SiteInitialization).Assembly.Location),
Namespace = "MeetingManagement.Migrations." + databaseKey + "DB"
};
try
{
new TaskExecutor(runner).Execute();
}
catch (Exception ex)
{
throw new Exception("Error executing migration:\r\n" +
sw.ToString(), ex);
}
}
}
public static MultiAnnouncer New(Announcer[] announcers)
{
var c = CreateInstance<MultiAnnouncer>();
c.announcers = new List<Announcer>(announcers);
return c;
}
private IMigrationProcessor CreateMigrationProcessor(Announcer announcer)
{
var options = new ProcessorOptions
{
PreviewOnly = false, // set to true to see the SQL
Timeout = 60,
};
EnsureConnectionAvailable(_connectionString);
var factory = new SqlServer2012ProcessorFactory();
IMigrationProcessor processor = factory.Create(_connectionString, announcer, options);
return processor;
}
