from Routing import Routing
from Store import store


class RoutingFactory(object):

        def new(self):
            return Routing()

        def getRoutes(self):
            return store.fetchObjectsOfClass(Routing)

        def getRoutingBySerialNum(self, serialNum):
            return store.fetchObject(Routing, serialNum)

        def getRoutingsByBOMSerialNum(self, serialNum):
            return store.fetchObjectsOfClass(Routing, clauses="WHERE itemObjId='%s' ORDER BY number+'0',number" % serialNum)