public override bool Update(SyncJob job)
{
if (this.SyncJobExists(job.Name, job.ID))
{
throw new SyncJobNameExistException(String.Format(m_ResourceManager.GetString("err_syncjobCreated"), job.Name));
}
SQLiteSyncSourceProvider provider = (SQLiteSyncSourceProvider)SyncClient.GetSyncSourceProvider(job.IntermediaryStorage.Path);
if (provider.GetSyncSourceCount() > 2)
{
throw new SyncSourcesNumberExceededException(m_ResourceManager.GetString("err_onlyTwoSyncSourceFolders"));
}
// Update a profile requires update 2 tables at the same time,
// If one update on a table fails, the total update action must fail too.
string updateProfileText = "UPDATE " + SYNCJOB_TABLE +
" SET " + COL_METADATA_SOURCE_LOCATION + " = @mdSource, " +
COL_SYNCJOB_NAME + " = @name WHERE " + COL_SYNCJOB_ID + " = @id;";
SqliteParameterCollection paramList = new SqliteParameterCollection();
// Add parameters for 1st Update statement
paramList.Add(new SqliteParameter("@mdSource", System.Data.DbType.String)
{
Value = job.IntermediaryStorage.Path
});
paramList.Add(new SqliteParameter("@name", System.Data.DbType.String)
{
Value = job.Name
});
paramList.Add(new SqliteParameter("@id", System.Data.DbType.String)
{
Value = job.ID
});
SQLiteAccess db = new SQLiteAccess(Path.Combine(this.StoragePath, DATABASE_NAME), false);
using (SqliteConnection con = db.NewSQLiteConnection())
{
if (con == null)
{
throw new DatabaseException(String.Format(m_ResourceManager.GetString("err_somethingNotFound"), Path.Combine(this.StoragePath, DATABASE_NAME)));
}
SqliteTransaction transaction = (SqliteTransaction)con.BeginTransaction();
try
{
SQLiteSyncSourceProvider.Update(job.SyncSource, con);
db.ExecuteNonQuery(updateProfileText, paramList);
transaction.Commit();
return(true);
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
public bool Add(SyncJob job, SqliteConnection con)
{
if (this.SyncJobExists(job.Name, job.ID))
{
throw new SyncJobNameExistException(String.Format(m_ResourceManager.GetString("err_syncjobCreated"), job.Name));
}
using (SqliteCommand cmd = con.CreateCommand())
{
cmd.CommandText = "INSERT INTO " + SYNCJOB_TABLE +
" (" + COL_SYNCJOB_ID + ", " + COL_SYNCJOB_NAME +
" ," + COL_METADATA_SOURCE_LOCATION + ", " + COL_SYNC_SOURCE_ID +
") VALUES (@id, @name, @meta, @source)";
cmd.Parameters.Add(new SqliteParameter("@id", System.Data.DbType.String)
{
Value = job.ID
});
cmd.Parameters.Add(new SqliteParameter("@name", System.Data.DbType.String)
{
Value = job.Name
});
cmd.Parameters.Add(new SqliteParameter("@meta", System.Data.DbType.String)
{
Value = job.IntermediaryStorage.Path
});
cmd.Parameters.Add(new SqliteParameter("@source", System.Data.DbType.String)
{
Value = job.SyncSource.ID
});
cmd.ExecuteNonQuery();
}
SQLiteSyncSourceProvider.Add(job.SyncSource, con);
return(true);
}
public override bool Add(SyncJob job)
{
if (this.SyncJobExists(job.Name, job.ID))
{
throw new SyncJobNameExistException(String.Format(m_ResourceManager.GetString("err_syncjobCreated"), job.Name));
}
SQLiteAccess dbAccess1 = new SQLiteAccess(Path.Combine(this.StoragePath, Configuration.DATABASE_NAME), false);
SQLiteAccess dbAccess2 = new SQLiteAccess(Path.Combine(job.IntermediaryStorage.Path, Configuration.DATABASE_NAME), false);
SqliteConnection con1 = dbAccess1.NewSQLiteConnection();
SqliteConnection con2 = dbAccess2.NewSQLiteConnection();
if (con1 == null)
{
throw new DatabaseException(String.Format(m_ResourceManager.GetString("err_somethingNotFound"), Path.Combine(this.StoragePath, DATABASE_NAME)));
}
if (con2 == null)
{
throw new DatabaseException(String.Format(m_ResourceManager.GetString("err_somethingNotFound"), Path.Combine(job.IntermediaryStorage.Path, Configuration.DATABASE_NAME)));
}
SqliteTransaction transaction1 = (SqliteTransaction)con1.BeginTransaction();
SqliteTransaction transaction2 = (SqliteTransaction)con2.BeginTransaction();
try
{
string insertJobText = "INSERT INTO " + SYNCJOB_TABLE +
" (" + COL_SYNCJOB_ID + ", " + COL_SYNCJOB_NAME +
" ," + COL_METADATA_SOURCE_LOCATION + ", " + COL_SYNC_SOURCE_ID +
") VALUES (@id, @name, @meta, @source)";
SqliteParameterCollection paramList = new SqliteParameterCollection();
paramList.Add(new SqliteParameter("@id", System.Data.DbType.String)
{
Value = job.ID
});
paramList.Add(new SqliteParameter("@name", System.Data.DbType.String)
{
Value = job.Name
});
paramList.Add(new SqliteParameter("@meta", System.Data.DbType.String)
{
Value = job.IntermediaryStorage.Path
});
paramList.Add(new SqliteParameter("@source", System.Data.DbType.String)
{
Value = job.SyncSource.ID
});
dbAccess1.ExecuteNonQuery(insertJobText, paramList);
SQLiteSyncSourceProvider.Add(job.SyncSource, con1);
SQLiteSyncSourceProvider provider = (SQLiteSyncSourceProvider)SyncClient.GetSyncSourceProvider(job.IntermediaryStorage.Path);
if (provider.GetSyncSourceCount() == 2)
{
throw new SyncSourcesNumberExceededException(m_ResourceManager.GetString("err_onlyTwoSyncSourceFolders"));
}
SQLiteSyncSourceProvider.Add(job.SyncSource, con2);
transaction1.Commit();
transaction2.Commit();
return(true);
}
catch (Exception)
{
transaction1.Rollback();
transaction2.Rollback();
throw;
}
finally
{
if (con1 != null)
{
con1.Dispose();
}
if (con2 != null)
{
con2.Dispose();
}
}
}
public static void CreateDataStore(string pathToJobFolder, SyncSource syncSource, IntermediaryStorage metaDataSource)
{
if (!Directory.Exists(pathToJobFolder))
{
Directory.CreateDirectory(pathToJobFolder);
}
if (!Directory.Exists(metaDataSource.Path))
{
Directory.CreateDirectory(metaDataSource.Path);
}
SqliteConnection con1 = null;
SqliteConnection con2 = null;
SqliteTransaction transaction1 = null;
SqliteTransaction transaction2 = null;
try
{
SQLiteAccess dbAccess1 = new SQLiteAccess(Path.Combine(pathToJobFolder, Configuration.DATABASE_NAME), true);
SQLiteAccess dbAccess2 = new SQLiteAccess(Path.Combine(metaDataSource.Path, Configuration.DATABASE_NAME), true);
con1 = dbAccess1.NewSQLiteConnection();
con2 = dbAccess2.NewSQLiteConnection();
if (con1 == null)
{
throw new DatabaseException(String.Format(m_ResourceManager.GetString("err_somethingNotFound"), Path.Combine(pathToJobFolder, Configuration.DATABASE_NAME)));
}
if (con2 == null)
{
throw new DatabaseException(String.Format(m_ResourceManager.GetString("err_somethingNotFound"), Path.Combine(metaDataSource.Path, Configuration.DATABASE_NAME)));
}
transaction2 = (SqliteTransaction)con2.BeginTransaction();
transaction1 = (SqliteTransaction)con1.BeginTransaction();
//Create schema for source info table in job folder
SQLiteSyncSourceProvider.CreateSchema(con1);
//Create schema for profile table in job folder
SQLiteSyncJobManager.CreateSchema(con1);
//create schema for source info table in intermediate storage folder
SQLiteSyncSourceProvider.CreateSchema(con2);
//create schema for metadata table in intermediate storage folder
SQLiteMetaDataProvider mdProvider = (SQLiteMetaDataProvider)SyncClient.GetMetaDataProvider(metaDataSource.Path, Configuration.DATABASE_NAME);
mdProvider.CreateSchema(con2);
//create schema for action table in intermediate storage folder
SQLiteSyncActionsProvider actionProvider = (SQLiteSyncActionsProvider)SyncClient.GetSyncActionsProvider(metaDataSource.Path);
actionProvider.CreateSchema(con2);
transaction2.Commit();
transaction1.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (transaction2 != null)
{
transaction2.Rollback();
}
if (transaction1 != null)
{
transaction1.Rollback();
}
throw new DatabaseException(m_ResourceManager.GetString("err_databaseException"));
}
finally
{
if (con1 != null)
{
con1.Dispose();
}
if (con2 != null)
{
con2.Dispose();
}
}
}
