public void UpdateDataBaseSchema()
{
ISchemaHandler handler = this.GetSchemaHandler();
string script = null;
try
{
script = handler.CreateUpdateDDLScript(null);
}
catch
{
bool throwException = false;
try
{
handler.CreateDatabase();
script = handler.CreateDDLScript();
}
catch
{
throwException = true;
}
if (throwException)
{
throw;
}
}
if (string.IsNullOrEmpty(script) == false)
{
handler.ExecuteDDLScript(script);
}
}
public OmletSchemaHandler(ISchemaHandler handler)
{
if (handler != null)
{
onRequest = handler.OnBrokenRequest;
onResponse = handler.OnBrokerResponse;
}
onRequest = onRequest ?? OnRequestFallback;
onResponse = onResponse ?? OnResponseFallback;
}
private static void EnsureDB(ISchemaHandler schemaHandler)
{
string script = null;
if (schemaHandler.DatabaseExists())
{
script = schemaHandler.CreateUpdateDDLScript(null);
}
else
{
schemaHandler.CreateDatabase();
script = schemaHandler.CreateDDLScript();
}
if (!string.IsNullOrEmpty(script))
{
schemaHandler.ExecuteDDLScript(script);
}
}
private static string GenerateScript(ISchemaHandler handler, TextWriter log)
{
string ddlScript = string.Empty;
if (!handler.DatabaseExists())
{
TryLogMessage(log, "Creating database script...");
ddlScript = handler.CreateDDLScript();
}
else
{
TryLogMessage(log, "Database exists, creating migration script...");
ddlScript = handler.CreateUpdateDDLScript(
new Telerik.OpenAccess.SchemaUpdateProperties());
}
return(ddlScript);
}
private static void EnsureDB(ISchemaHandler schemaHandler)
{
string script = null;
if (schemaHandler.DatabaseExists())
{
script = schemaHandler.CreateUpdateDDLScript(null);
}
else
{
schemaHandler.CreateDatabase();
script = schemaHandler.CreateDDLScript();
}
if (!string.IsNullOrEmpty(script))
{
schemaHandler.ExecuteDDLScript(script);
}
}
private static void ExecuteScript(string ddlScript, ISchemaHandler handler, TextWriter log)
{
if (!string.IsNullOrEmpty(ddlScript))
{
if (!handler.DatabaseExists())
{
TryLogMessage(log, "Database does not exist, creating database..");
handler.CreateDatabase();
}
TryLogMessage(log, "Updating database schema...");
//This is the call that modifies the databaschema. Use with care.
handler.ExecuteDDLScript(ddlScript);
}
else
{
TryLogMessage(log, "No changes to make.");
}
}
public void UpdateSchema()
{
ISchemaHandler schemaHandler = GetSchemaHandler();
string script = null;
if (schemaHandler.DatabaseExists())
{
script = schemaHandler.CreateUpdateDDLScript(null);
}
else
{
schemaHandler.CreateDatabase();
script = schemaHandler.CreateDDLScript();
}
if (!string.IsNullOrEmpty(script))
{
schemaHandler.ExecuteDDLScript(script);
}
}
