public static void UpdateUrlTrackerTable()
{
if (UrlTrackerRepository.GetUrlTrackerTableExists())
{
var folderName = GetFolderName();
for (var i = 1; i <= 3; i++)
{
var alreadyAdded = false;
if (DatabaseProvider == DatabaseProviders.SqlServerCE)
{
//Check if columns exists
var query =
EmbeddedResourcesHelper.GetString(string.Concat(folderName, "check-table-" + i + ".sql"));
if (!string.IsNullOrEmpty(query))
{
var ex = ApplicationContext.Current.DatabaseContext.Database.ExecuteScalar <int?>(query);
alreadyAdded = ex == 1;
}
}
if (!alreadyAdded)
{
var query =
EmbeddedResourcesHelper.GetString(string.Concat(folderName, "update-table-" + i + ".sql"));
if (!string.IsNullOrEmpty(query))
{
ApplicationContext.Current.DatabaseContext.Database.Execute(query);
}
}
}
}
}
public static void UpdateUrlTrackerTable()
{
if (UrlTrackerRepository.GetUrlTrackerTableExists())
{
string updateTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.update-table-1.sql");
_sqlHelper.ExecuteNonQuery(updateTableQuery);
updateTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.update-table-2.sql");
_sqlHelper.ExecuteNonQuery(updateTableQuery);
}
}
public static void CreateUrlTrackerTable()
{
if (UrlTrackerRepository.GetUrlTrackerTableExists())
{
throw new Exception("Table already exists.");
}
var folderName = GetFolderName();
var createTableQuery = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "create-table-1.sql"));
_sqlHelper.ExecuteNonQuery(createTableQuery);
}
public static void CreateUrlTrackerTable()
{
if (UrlTrackerRepository.GetUrlTrackerTableExists())
{
throw new Exception("Table already exists.");
}
string createTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.create-table-1.sql");
_sqlHelper.ExecuteNonQuery(createTableQuery);
createTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.create-table-2.sql");
_sqlHelper.ExecuteNonQuery(createTableQuery);
}
public static void UpdateUrlTrackerTable()
{
if (UrlTrackerRepository.GetUrlTrackerTableExists())
{
var folderName = GetFolderName();
for (var i = 1; i <= 3; i++)
{
var alreadyAdded = false;
if (DatabaseProvider == DatabaseProviders.SqlServerCE)
{
//Check if columns exists
var query =
EmbeddedResourcesHelper.GetString(string.Concat(folderName, "check-table-" + i + ".sql"));
if (!string.IsNullOrEmpty(query))
{
var reader = _sqlHelper.ExecuteReader(query);
while (reader.Read())
{
alreadyAdded = true;
}
}
}
if (!alreadyAdded)
{
var query =
EmbeddedResourcesHelper.GetString(string.Concat(folderName, "update-table-" + i + ".sql"));
if (!string.IsNullOrEmpty(query))
{
_sqlHelper.ExecuteNonQuery(query);
}
}
}
}
}
