public void TestGetNetWorkFromDatabase()
{
DB_Manager db = new DB_Manager("networkvis");
Graph g = db.get_network("ABC");
Assert.AreEqual(true, g != null);
db.close();
}
public static DataTable EdgeGen(DB_Manager dbm, DataTable Vertex, String first, String second)
{
DataTable group = dbm.mysql_query(String.Format("SELECT {0},{1} FROM networkvis.allinone GROUP BY {2};", first, second, first));
DataTable result = new DataTable();
result.Columns.Add("FromID", typeof(int));
result.Columns.Add("ToID", typeof(int));
for (int id = 0; id < group.Rows.Count;id++)
{
DataRow row = group.Rows[id];
String Content = row[second].ToString();
for (int id2 = 0; id2 < id; id2++)
{
DataRow data = group.Rows[id2];
//Console.WriteLine(data[second].ToString() + " " + Content);
if (Content.Equals(data[second].ToString()))
{
DataRow edge = result.NewRow();
edge["FromID"] = id;
edge["ToID"] = id2;
result.Rows.Add(edge);
break;
}
}
}
return result;
}
public NetworkID(DB_Manager db, EventHandler<IgraphGenerateEvent> _e)
{
InitializeComponent();
loadNetwork(listView1, db.list_network());
GraphGenerated = _e;
db.close();
}
public GenerateGraph(DB_Manager _dbm, EventHandler<IgraphGenerateEvent> _e)
{
dbm = _dbm;
GraphGenerated = _e;
InitializeComponent();
loadVertexFields(listView1);
loadEdgeFields(listView2, preview_vertex.getFirst());
comboBox1.SelectedIndex = 0;
}
public void Testlist_net()
{
DB_Manager db = new DB_Manager("networkvis");
DataTable dt = db.list_network();
String[] post = db.list_post_schema();
db.list_post_like_schema();
Assert.AreEqual(true, dt != null);
Assert.AreEqual(true, post.Length > 0);
db.close();
}
public PreviewVertex(DB_Manager dbm)
{
String[] fields = dbm.list_post_schema();
list_set = new ListViewItem[fields.Length];
for (int i = 0; i < fields.Length; i++)
{
list_set[i] = new ListViewItem(fields[i], 0);
append(dbm.mysql_query(String.Format("select {0} from networkvis.allinone WHERE ({1} is not null and {2} != '') limit 10", fields[i], fields[i], fields[i])));
}
list_set[0].Selected = true;
}
public void TestGetNetWorkFromImporter()
{
DB_Manager db = new DB_Manager("networkvis");
String[] post = db.list_post_schema();
Assert.AreEqual(true, post.Length > 1);
db.setting.vertexCol = post[0];
db.setting.edgeCol = post[1];
Graph g = db.get_network("ABC",0);
Assert.AreEqual(true, g != null);
db.close();
}
public void testConstructor()
{
EventHandler<IgraphGenerateEvent> handler = new System.EventHandler<IgraphGenerateEvent>(this.gen_graph_call_back);
EventHandler<statusEventHandler> handler2 = new System.EventHandler<statusEventHandler>(this.get_network_call_back);
DB_Manager db = new DB_Manager("networkvis");
NetworkID UI_1 = new NetworkID(db, handler);
GenerateGraph UI_2 = new GenerateGraph(db, handler);
AskNetWorkID UI_3 = new AskNetWorkID(handler2);
Assert.AreEqual(true, UI_1 != null);
Assert.AreEqual(true, UI_2 != null);
Assert.AreEqual(true, UI_3 != null);
}
private void button1_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
Console.WriteLine(listView1.SelectedItems[0].Text);
String ID = listView1.SelectedItems[0].Text;
DB_Manager dbm = new DB_Manager("networkvis");
this.Close();
GraphGenerated(this, new IgraphGenerateEvent(dbm.get_network(ID)));
/*TODO: Make query to generate graph*/
}
}
private void button1_Click(object sender, EventArgs e)
{
DB_Manager db = new DB_Manager("networkvis");
DataTable dt = db.mysql_query(String.Format("SELECT DISTINCT NetworkID FROM networkvis.nodes WHERE NetworkID = '{0}'", textBox1.Text));
if (dt.Rows.Count > 0)
{
return;
}
else
{
this.Close();
inputGet(this, new statusEventHandler(1, textBox1.Text));
}
}
private void generateFromDBToolStripMenuItem_Click(object sender, EventArgs e)
{
EventHandler<IgraphGenerateEvent> handler = new System.EventHandler<IgraphGenerateEvent>(this.SetAndShowGraph);
DB_Manager dbm = new DB_Manager("networkvis");
GenerateGraph genGraph = new GenerateGraph(dbm, handler);
genGraph.Show(this);
}
private void loadFromDBToolStripMenuItem_Click(object sender, EventArgs e)
{
EventHandler<IgraphGenerateEvent> handler = new System.EventHandler<IgraphGenerateEvent>(this.SetAndShowGraph);
DB_Manager dbm = new DB_Manager("networkvis");
NetworkID nid = new NetworkID(dbm, handler);
nid.Show(this);
}
