private void TryMigrateToLocalUsersTable(ManagedConnection connection)
{
try
{
connection.RunQueries(new[]
{
"INSERT INTO LocalUsersv2 (guid, data) SELECT guid,data from users"
});
}
catch (Exception ex)
{
Logger.LogError(ex, "Error migrating users database");
}
}
private void SetInitialDatabseValues(ManagedConnection connection)
{
try
{
connection.RunQueries(new[]
{
"INSERT INTO Groups VALUES (NULL, 'Cliente')",
"INSERT INTO Groups VALUES (NULL, 'Administrador')",
"INSERT INTO Groups VALUES (NULL, 'Revendedor Master')",
"INSERT INTO Groups VALUES (NULL, 'Revendedor')",
"INSERT INTO Plains VALUES (NULL, 'Básico', 1)",
"INSERT INTO Plains VALUES (NULL, 'Padrão', 2)",
"INSERT INTO Plains VALUES (NULL, 'Premium', 4)"
});
}
catch (Exception ex)
{
Logger.LogError(ex, "Error inserting initial data to database");
}
}
