public Graph get_network(String NetWorkID, int option)
{
String edgeCol = setting.edgeCol;
String vertexCol = setting.vertexCol;
String vertex_sql = String.Format("SELECT DISTINCT {0} FROM networkvis.allinone ", vertexCol);
DataTable vertex_table = mysql_query(vertex_sql);
vertex_table.Columns.Add("ID", typeof(int));
vertex_table.Columns[vertexCol].ColumnName = "NodeName";
int i = 0;
foreach (DataRow row in vertex_table.Rows)
{
row["ID"] = i++;
}
DataTable edge_table = GraphEdgeGen.EdgeGen(this, vertex_table, vertexCol, edgeCol);
// export_to_db(vertex_table, NetWorkID, "nodes");
// export_to_db(edge_table, NetWorkID, "edges");
// /*Use setting to generate sql and get DataTable*/
DB_Converter conv = new DB_Converter();
return conv.convert_to_graph(vertex_table,edge_table);
}
public Graph get_network(String ID)
{
String edge_sql = String.Format("SELECT * FROM networkvis.edges WHERE NetworkID = \"{0}\"", ID);
String vertex_sql = String.Format("SELECT * FROM networkvis.nodes WHERE NetworkID = \"{0}\"", ID);
DataTable edge_table = mysql_query(edge_sql);
DataTable vertex_table = mysql_query(vertex_sql);
DB_Converter conv = new DB_Converter();
return conv.convert_to_graph(vertex_table, edge_table);
/*Get Group information from group table*/
/*Call DB_Converter to generate graph */
}
