Add an option of sort order to the dump_table() method
Useful for giving consistent results
Change-Id: Id073e8152280a17e5a991695ab25d64262062e78
diff --git a/db/db.py b/db/db.py
index a361095..9e9b2d8 100644
--- a/db/db.py
+++ b/db/db.py
@@ -675,9 +675,9 @@
return port_id
# Trivial helper function to return all the rows in a given table
- def _dump_table(self, table):
+ def _dump_table(self, table, order):
result = []
- self.cursor.execute("SELECT * FROM %s" % table)
+ self.cursor.execute("SELECT * FROM %s ORDER by %s ASC" % (table, order))
record = self.cursor.fetchone()
while record != None:
result.append(record)
@@ -685,16 +685,16 @@
return result
def all_switches(self):
- return self._dump_table("switch")
+ return self._dump_table("switch", "switch_id")
def all_ports(self):
- return self._dump_table("port")
+ return self._dump_table("port", "port_id")
def all_vlans(self):
- return self._dump_table("vlan")
+ return self._dump_table("vlan", "vlan_id")
def all_trunks(self):
- return self._dump_table("trunk")
+ return self._dump_table("trunk", "trunk_id")
if __name__ == '__main__':
db = VlanDB()