crs.execute('USE wiki')
# Fetch link data
crs.execute('SELECT fromPageId, toPageId FROM links LIMIT 15')
# Construct directed graph
for link in crs.fetchall():
fromPageId = Se.getUrl(link[0])[6:]
toPageId = Se.getUrl(link[1])[6:]
edge = pydot.Edge(fromPageId, toPageId)
graph.add_edge(edge)
# Find a link
nodes = Se.getLinks(1)
targetPageId = 3000
pageIds = Se.BFS(targetPageId)
# Color the link of choice
node_a = pydot.Node(Se.getUrl(pageIds[0])[6:],
style="filled",
fillcolor="#F1948A")
node_b = pydot.Node(Se.getUrl(pageIds[1])[6:],
style="filled",
fillcolor="#EC7063")
node_c = pydot.Node(Se.getUrl(pageIds[2])[6:],
style="filled",
fillcolor="#E74C3C")
node_d = pydot.Node(Se.getUrl(pageIds[3])[6:],
style="filled",
fillcolor="#CB4335")
node_e = pydot.Node(Se.getUrl(pageIds[4])[6:],
