private static Dictionary <string, DbUtility> LoadDatabaseList()
{
DatabaseList list =
SerializerProvider.SerializerHelper <DatabaseList> .LoadFromXmlFile(Configer.ServerListFileLocation);
if (list == null || list.Databases == null || list.Databases.Length == 0)
{
throw new DatabaseNotSpecifiedException();
}
var hashtable = new Dictionary <string, DbUtility>(list.Databases.Length);
foreach (DatabaseMajor instance in list.Databases)
{
DbUtility database = VisitorFactory.CreateComDataVisitor(instance.Connection.DataProvider.Value);
database.Provider = instance.Connection.DataProvider.Value;
database.DataServer = instance.Connection.DataServer.Value;
database.DataSource = instance.Connection.DataSource.Value;
database.UserID = instance.Connection.DataUserID.Value;
database.Password = instance.Connection.DataPassword.Value;
database.Initialize();
//TODO:此处应解析Password
hashtable.Add(instance.Name.ToUpper(), database);
}
return(hashtable);
}
public ActionResult GetTaskInfoStrList()
{
DatabaseList da = DatabaseList.GetData();
var list = CompontInfoManage.GetTaskInfo(da, 0, "");
return(Json(CompontInfoManage.GetAllTaskInfoStr(list), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Initializes a new instance of the MainViewModel class.
/// </summary>
public MainViewModel(IDataService dataService)
{
try
{
_dataService = dataService;
LoadCommand = new RelayCommand(Load);
SaveCommand = new RelayCommand(Save);
SelectionChangedCommand = new RelayCommand <IList>(SelectionChanged);
var dbList = new DatabaseList();
if (IsInDesignMode)
{
_sourceDb = dbList.First(d => d.name == "TARIF");
_targetDb = dbList.First(d => d.name == "SMODEV");
}
else
{
string[] args = Environment.GetCommandLineArgs();
if (args.Length < 2)
{
throw new Exception("Nombre d'argument insuffisant");
}
_sourceDb = dbList.First(d => d.name == args[1]);
_targetDb = dbList.First(d => d.name == args[2]);
}
_dataService.SetDatabases(_targetDb, _sourceDb);
ObjectNameList = _dataService.GetSyncablesObjects();
_dataService.Log += Log;
CurrentObjectName = "ARTICLE";
Title = $"Synchronisation de {_sourceDb.name} vers {_targetDb.name}";
}
catch (Exception ex)
{
Messenger.Default.Send(ex.Message, "LambdaMessage");
}
}
private void settingsControl1_ServerChanged(object sender, string serverName, string username, string password, AuthenticationType authType)
{
Connection.ConnectionData oldConnData = new Connection.ConnectionData();
this.connData.Fill(oldConnData);
this.Cursor = Cursors.WaitCursor;
this.connData.SQLServerName = serverName;
if (!string.IsNullOrWhiteSpace(username) && (!string.IsNullOrWhiteSpace(password)))
{
this.connData.UserId = username;
this.connData.Password = password;
}
this.connData.AuthenticationType = authType;
this.connData.ScriptTimeout = 5;
try
{
DatabaseList dbList = SqlSync.DbInformation.InfoHelper.GetDatabaseList(this.connData);
//this.LookUpTable_Load(null, EventArgs.Empty);
}
catch
{
MessageBox.Show("Error retrieving database list. Is the server running?", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.connData = oldConnData;
this.settingsControl1.Server = oldConnData.SQLServerName;
}
this.Cursor = Cursors.Default;
}
public RebuildForm(Connection.ConnectionData connData, DatabaseList databaseList)
{
this.dbList = databaseList;
this.connData = connData;
InitializeComponent();
ddDatabases.Items.AddRange(databaseList.ToArray());
}
/// <summary>
/// 获取所有任务信息
/// </summary>
/// <returns></returns>
public ActionResult GetTaskInfoCreate()
{
DatabaseList da = DatabaseList.GetData();
var list = CompontInfoManage.GetTaskInfoCreate(da, 0, "");
return(Json(list, JsonRequestBehavior.AllowGet));
}
internal void SetConnection()
{
try
{
this.ddDatabase.Items.Clear();
ConnectionData connData = new ConnectionData();
connData.SQLServerName = this.ddServers.Text;
connData.UserId = this.txtUser.Text;
connData.Password = this.txtPassword.Text;
connData.AuthenticationType = this.AuthenticationType;
connData.ScriptTimeout = 10;
bool hasError;
this.databaseList = InfoHelper.GetDatabaseList(connData, out hasError);
if (hasError)
{
MessageBox.Show("Unable to connect to specified SQL Server.\r\nPlease select another server.", "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (this.ServersEnumerated != null)
{
this.ServersEnumerated(this, new ServersEnumeratedEventArgs(new string[0], "Connection error. Please re-select."));
}
this.Cursor = Cursors.Default;
return;
}
for (int i = 0; i < databaseList.Count; i++)
{
this.ddDatabase.Items.Add(databaseList[i].DatabaseName);
}
if (ddDatabase.Visible)
{
this.ddDatabase.Sorted = true;
if (this.ddDatabase.Items.Count > 0)
{
this.ddDatabase.SelectedIndex = 0;
this.ddDatabase.Enabled = true;
}
else
{
this.ddDatabase.Enabled = false;
this.ddDatabase.Text = "<No databases found>";
}
}
if (this.ServerConnected != null)
{
UtilityHelper.UpdateRecentServerList(this.ddServers.Text, this.txtUser.Text, this.txtPassword.Text, this.AuthenticationType);
this.ServerConnected(this, new ServerConnectedEventArgs(true, this.AuthenticationType));
}
this.Cursor = Cursors.Default;
}
catch (Exception err)
{
this.Cursor = Cursors.Default;
MessageBox.Show(err.Message, "Error");
}
}
private Series LoadCpuSeries(WorkloadAnalysis analysis, OxyColor color, double baseOffset)
{
if (analysis == null)
{
return(null);
}
LineSeries cpuSeries = new LineSeries()
{
StrokeThickness = 2,
MarkerSize = 3,
MarkerStroke = OxyColor.Parse("#FF0000"), //Red
MarkerType = MarkerType.None,
CanTrackerInterpolatePoints = false,
Title = analysis.Name,
Color = color,
Smooth = false
};
if (baseOffset == 0)
{
cpuSeries.TrackerFormatString = "Offset: {2:0}\n{0}: {4:0}";
}
var Table = from t in analysis.Points
where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) &&
HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) &&
DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) &&
LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName)
group t by new
{
offset = t.OffsetMinutes
}
into grp
orderby grp.Key.offset
select new
{
offset_minutes = grp.Key.offset,
cpu = grp.Sum(t => t.SumCpuUs)
};
foreach (var p in Table)
{
double xValue = 0;
if (baseOffset > 0)
{
xValue = DateTimeAxis.ToDouble(DateTimeAxis.ToDateTime(baseOffset).AddMinutes(p.offset_minutes));
}
else
{
xValue = p.offset_minutes;
}
cpuSeries.Points.Add(new DataPoint(xValue, p.cpu));
}
return(cpuSeries);
}
private DatabaseList GetDatabases(Boolean refresh)
{
if (_databases.IsNull() || refresh)
{
_databases = DatabaseManagerTest.GetAllDatabases();
}
return(_databases);
}
//public ScriptConfigCtrl(ref SqlSyncBuildData.ScriptRow scriptConfig, string[] databaseList)
//{
// InitializeComponent();
// this.scriptConfig = scriptConfig;
// this.databaseList = databaseList;
// SetUp();
//}
public void SetConfigData(ref SqlSyncBuildData.ScriptRow scriptConfig, DatabaseList databaseList, List <string> tagList, bool tagRequired)
{
this.scriptConfig = scriptConfig;
this.databaseList = databaseList;
this.tagList = tagList;
this.tagRequired = tagRequired;
SetUp();
}
public ConfigurationViaQueryForm(ConnectionData connData, DatabaseList dbList) : this()
{
if (connData.SQLServerName != null && connData.SQLServerName.Length > 0)
{
this.connData = connData;
}
this.databaseList = dbList;
this.showPreviewButton = true;
}
public static void Disconnect()
{
if (_mongoClient != null)
{
_mongoClient = null;
}
Databases = null;
}
private void loadDatabase(byte[] data)
{
var db = new DatabaseList(data);
if (db.Slot.Count > 0)
{
Database.Add(db);
}
}
private void ObjectValidation_Load(object sender, System.EventArgs e)
{
DatabaseList dbs = SqlSync.DbInformation.InfoHelper.GetDatabaseList(connData);
for (int i = 0; i < dbs.Count; i++)
{
ddDatabaseList.Items.Add(dbs[i].DatabaseName);
}
this.settingsControl1.Server = this.connData.SQLServerName;
}
private void BindDatabaseListDropDown(DatabaseList databaseList)
{
this.ddDatabase.Items.Clear();
for (int i = 0; i < databaseList.Count; i++)
{
this.ddDatabase.Items.Add(databaseList[i].DatabaseName);
}
this.ddDatabase.SelectedIndex = 0;
ddDatabase_SelectionChangeCommitted(null, EventArgs.Empty);
}
private void ServerList_SelectedIndexChanged(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
server = ServerList.Text;
procedures.Clear();
SPSQL.Clear();
SPTextBox.Text = string.Empty;
AllProceduresCheckbox.Checked = false;
if (!string.IsNullOrEmpty(server))
{
DatabaseList.Enabled = ServerList.SelectedIndex != -1;
DatabaseList.Text = string.Empty;
DatabaseList.Items.Clear();
// Setup database list.
var connectionString = @"Server=" + server + ";Initial Catalog=master;Integrated Security=SSPI";
using (var conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
var sql = @"";
using (var cmd = new SqlCommand("SELECT name FROM master..sysdatabases WHERE name LIKE '%_App'", conn))
{
using (var result = cmd.ExecuteReader())
{
if (result.HasRows)
{
while (result.Read())
{
DatabaseList.Items.Add(result["name"]);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
finally
{
conn.Close();
this.Cursor = Cursors.Default;
}
}
DatabaseList.Focus();
}
}
private void Window_Initialized
(
object sender,
EventArgs e
)
{
string initialDatabase = null;
using (IrbisConnection connection = GetConnection())
{
IniFile iniFile = connection.IniFile;
string listFile = "dbnam1.mnu";
if (!ReferenceEquals(iniFile, null))
{
iniFile.GetValue("MAIN", "DBNNAMECAT", "dbnam1.mnu");
string ext = System.IO.Path.GetExtension(listFile);
if (string.IsNullOrEmpty(ext))
{
listFile += ".mnu";
}
initialDatabase = iniFile.GetValue("MAIN", "CURDBN", null);
}
databases = connection.ListDatabases(listFile);
foreach (DatabaseInfo database in databases)
{
DatabaseList.Items.Add(database);
}
}
int initialIndex = 0;
if (!string.IsNullOrEmpty(initialDatabase))
{
for (int i = 0; i < databases.Length; i++)
{
if (initialDatabase.SameString(databases[i].Name))
{
initialIndex = i;
break;
}
}
}
if (initialIndex >= 0 && initialIndex < databases.Length)
{
DatabaseList.SelectedIndex = initialIndex;
object selectedItem = DatabaseList.SelectedItem;
if (!ReferenceEquals(selectedItem, null))
{
DatabaseList.ScrollIntoView(selectedItem);
}
}
}
private NewBuildScriptForm(DatabaseList databaseList, List <string> tagList, string lastDatabase, string baseFilePath)
{
this.InitializeComponent();
this.tagList = tagList;
this.baseFilePath = baseFilePath;
this.ddInfer.SelectedIndex = 0;
this.ddDatabaseList.SetData(databaseList, lastDatabase);
for (int i = 0; i < this.tagList.Count; i++)
{
cbTag.Items.Add(this.tagList[i]);
}
}
private void AddNewServerItem(string serverName, DatabaseList dbList)
{
ListViewItem item = new ListViewItem(serverName);
ServerData dat = new ServerData();
dat.ServerName = serverName;
dat.Databases = dbList;
item.Tag = dat;
lstServers.Items.Add(item);
SwitchSelectedServer(item.Index);
}
public void DatabasesTest()
{
ServerData target = new ServerData();
DatabaseList expected = new DatabaseList();
expected.Add(new DatabaseItem());
DatabaseList actual;
target.Databases = expected;
actual = target.Databases;
Assert.AreEqual(expected, actual);
Assert.AreEqual(1, actual.Count);
}
private void KeyBox_TextChanged
(
object sender,
TextChangedEventArgs e
)
{
TextBox textBox = sender as TextBox;
if (ReferenceEquals(textBox, null))
{
return;
}
string text = textBox.Text.Trim();
if (string.IsNullOrEmpty(text))
{
return;
}
DatabaseInfo found = null;
foreach (DatabaseInfo database in databases)
{
string name = database.Name;
if (!string.IsNullOrEmpty(name))
{
if (Contains(name, text))
{
found = database;
break;
}
}
string description = database.Description;
if (!string.IsNullOrEmpty(description))
{
if (Contains(description, text))
{
found = database;
break;
}
}
}
if (!ReferenceEquals(found, null))
{
DatabaseList.SelectedItem = found;
DatabaseList.ScrollIntoView(found);
}
}
/// <summary>
/// Method to return an item sent in as a ModelViewModelType as a ModelType
/// </summary>
/// <typeparam name="ModelType">The type to be returned</typeparam>
/// <typeparam name="ModelViewModelType">The type to get the value from</typeparam>
/// <param name="Instance">The current instance needed to get the right item</param>
/// <returns>The sent in item as the desired model type</returns>
public ModelType GetSelectedItemAsModelType <ModelType, ModelViewModelType>(ModelViewModelType Instance)
{
// casting the database result to a queryable list
var ModelTypeList = DatabaseList.Cast <ModelType>().ToList();
// casting the view model version to a queryable list
var ModelViewModelList = CurrentList.Cast <ModelViewModelType>().ToList();
// getting the index of the chosen item
int index = ModelViewModelList.IndexOf(Instance);
// return the same item but as a Model Type
return(ModelTypeList[index]);
}
public static async Task <DatabaseList> SetListDescription(TwitterList list)
{
var dbl = new DatabaseList
{
Id = list.Id,
UserId = list.User.Id,
Name = list.Name,
FullName = list.FullName,
Slug = list.Slug
};
await Database.ListCrud.InsertAsync(dbl).ConfigureAwait(false);
return(dbl);
}
public ActionResult SearchSubmit()
{
try
{
var str = Request["str"];
DatabaseList da = DatabaseList.GetData();
var list = CompontInfoManage.GetTaskInfo(da, 0, "");
var res = CompontInfoManage.SearchSubmit(list, str, false);
return(Json(res, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public MultiDbRunForm(ConnectionData connData, List <string> defaultDatabases, DatabaseList databaseList, string buildZipFileName, string projectFilePath, ref SqlSyncBuildData buildData)
: this()
{
//perform real copy to prevent data slipping back into main form
string[] tmp = new string[defaultDatabases.Count];
defaultDatabases.CopyTo(tmp);
this.defaultDatabases = new List <string>(tmp);
this.databaseList = databaseList;
this.server = connData.SQLServerName;
this.DialogResult = DialogResult.Cancel;
this.buildZipFileName = buildZipFileName;
this.buildData = buildData;
this.projectFilePath = projectFilePath;
this.connData = connData;
}
private void mnuChangeSqlServer_Click(object sender, EventArgs e)
{
ConnectionForm frmConnect = new ConnectionForm("Sql Build Manager");
DialogResult result = frmConnect.ShowDialog();
if (result == DialogResult.OK)
{
this.connData = frmConnect.SqlConnection;
this.databaseList = frmConnect.DatabaseList;
this.lblServer.Text = this.connData.SQLServerName;
this.SetDatabaseList(frmConnect.SqlConnection.SQLServerName, "");
}
}
public void ReadDatabases()
{
using (SqlConnection connection = new SqlConnection(GetSqlConString()))
{
SqlCommand command = new SqlCommand("select NAME from SYS.DATABASES", connection);
command.Connection.Open();
using (var oReader = command.ExecuteReader())
{
while (oReader.HasRows && oReader.Read())
{
DatabaseList.Add((string)oReader["NAME"]);
}
}
}
}
public void SquareBracketOperator()
{
Int32 databaseIndex;
DatabaseList newDatabaseList, oldDatabaseList;
oldDatabaseList = GetDatabases(true);
newDatabaseList = new DatabaseList();
for (databaseIndex = 0; databaseIndex < oldDatabaseList.Count; databaseIndex++)
{
newDatabaseList.Add(oldDatabaseList[oldDatabaseList.Count - databaseIndex - 1]);
}
for (databaseIndex = 0; databaseIndex < oldDatabaseList.Count; databaseIndex++)
{
Assert.AreEqual(newDatabaseList[databaseIndex], oldDatabaseList[oldDatabaseList.Count - databaseIndex - 1]);
}
}
private void changeSqlServerConnectionToolStripMenuItem_Click(object sender, EventArgs e)
{
ConnectionForm frmConnect = new ConnectionForm("Build File Reconstructor");
DialogResult result = frmConnect.ShowDialog();
if (result == DialogResult.OK)
{
this.connData = frmConnect.SqlConnection;
this.settingsControl1.Server = this.connData.SQLServerName;
this.dbList = frmConnect.DatabaseList;
ddDatabases.Items.Clear();
ddDatabases.Items.AddRange(dbList.ToArray());
//bgWorker.RunWorkerAsync();
}
}
private Series LoadBatchesSeries(WorkloadAnalysis analysis, OxyColor color)
{
if (analysis == null)
{
return(null);
}
LineSeries batchesSeries = new LineSeries()
{
StrokeThickness = 2,
MarkerSize = 3,
MarkerStroke = OxyColor.Parse("#FF0000"), //Red
MarkerType = MarkerType.None,
CanTrackerInterpolatePoints = false,
TrackerFormatString = "Offset: {2:0}\n{0}: {4:0}",
Title = analysis.Name,
Color = color,
Smooth = false
};
var Table = from t in analysis.Points
where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) &&
HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) &&
DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) &&
LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName)
group t by new
{
offset = t.OffsetMinutes
}
into grp
orderby grp.Key.offset
select new
{
offset_minutes = grp.Key.offset,
execution_count = grp.Sum(t => t.ExecutionCount / ((t.DurationMinutes == 0 ? 1 : t.DurationMinutes) * 60))
};
foreach (var p in Table)
{
batchesSeries.Points.Add(new DataPoint(p.offset_minutes, p.execution_count));
}
return(batchesSeries);
}
internal static void LoadDatabaseInfo()
{
DatabaseList dbList = ConfigHelper.LoadDatabaseListFile();
if (dbList != null && dbList.DatabaseInstances != null && dbList.DatabaseInstances.Length > 0)
{
List <string> tmp = new List <string>(dbList.DatabaseInstances.Length);
foreach (var db in dbList.DatabaseInstances)
{
if (tmp.Contains(db.Name))
{
throw new ApplicationException("Duplidated database name '" + db.Name + "' in configuration file '" + ConfigHelper.DatabaseListFilePath + "'.");
}
tmp.Add(db.Name);
ConnectionStringManager.SetConnectionString(db.Name, Decrypt(db.ConnectionString), db.Type);
}
}
}
public DatabaseStoreTests()
{
var mongoClientMock = new Mocks.MongoClient();
DatabaseList = new DatabaseList(mongoClientMock);
}
public static void Connect(IMongoClient client)
{
_mongoClient = client;
Databases = new DatabaseList(client);
}
private void loadDatabase(byte[] data)
{
var db = new DatabaseList(data);
if (db.Slot.Count > 0)
Database.Add(db);
}
