Example #1
0
    def get(self, identifiers):

        if not isinstance(identifiers, (list)):
            identifiers = [identifiers]

        db = get_session()
        return_list = []

        for identifier in identifiers:

            if self.status_cached.get(identifier):
                return_list.append(self.status_cached.get(identifier))
                continue

            s = db.query(Status).filter_by(identifier = identifier).first()
            if not s:
                s = Status(
                    identifier = identifier,
                    label = toUnicode(identifier.capitalize())
                )
                db.add(s)
                db.commit()

            status_dict = s.to_dict()

            self.status_cached[identifier] = status_dict
            return_list.append(status_dict)

        return return_list if len(identifiers) > 1 else return_list[0]
Example #2
0
    def get(self, identifiers):

        if not isinstance(identifiers, list):
            identifiers = [identifiers]

        try:
            db = get_session()
            return_list = []

            for identifier in identifiers:

                if self.status_cached.get(identifier):
                    return_list.append(self.status_cached.get(identifier))
                    continue

                s = db.query(Status).filter_by(identifier = identifier).first()
                if not s:
                    s = Status(
                        identifier = identifier,
                        label = toUnicode(identifier.capitalize())
                    )
                    db.add(s)
                    db.commit()

                status_dict = s.to_dict()

                self.status_cached[identifier] = status_dict
                return_list.append(status_dict)

            return return_list if len(identifiers) > 1 else return_list[0]
        except:
            log.error('Failed: %s', traceback.format_exc())
            db.rollback()
        finally:
            db.close()
Example #3
0
    def get(self, identifiers):

        if not isinstance(identifiers, (list)):
            identifiers = [identifiers]

        db = get_session()
        return_list = []

        for identifier in identifiers:

            if self.status_cached.get(identifier):
                return_list.append(self.status_cached.get(identifier))
                continue

            s = db.query(Status).filter_by(identifier=identifier).first()
            if not s:
                s = Status(identifier=identifier, label=toUnicode(identifier.capitalize()))
                db.add(s)
                db.commit()

            status_dict = s.to_dict()

            self.status_cached[identifier] = status_dict
            return_list.append(status_dict)

        return return_list if len(identifiers) > 1 else return_list[0]
Example #4
0
    def get(self, identifiers):

        if not isinstance(identifiers, list):
            identifiers = [identifiers]

        try:
            db = get_session()
            return_list = []

            for identifier in identifiers:

                if self.status_cached.get(identifier):
                    return_list.append(self.status_cached.get(identifier))
                    continue

                s = db.query(Status).filter_by(identifier=identifier).first()
                if not s:
                    s = Status(identifier=identifier,
                               label=toUnicode(identifier.capitalize()))
                    db.add(s)
                    db.commit()

                status_dict = s.to_dict()

                self.status_cached[identifier] = status_dict
                return_list.append(status_dict)

            return return_list if len(identifiers) > 1 else return_list[0]
        except:
            log.error('Failed: %s', traceback.format_exc())
            db.rollback()
        finally:
            db.close()
Example #5
0
    def fill(self):

        db = get_session()

        for identifier, label in self.statuses.iteritems():
            s = db.query(Status).filter_by(identifier=identifier).first()
            if not s:
                log.info("Creating status: %s", label)
                s = Status(identifier=identifier, label=toUnicode(label))
                db.add(s)

            s.label = toUnicode(label)
            db.commit()
Example #6
0
    def fill(self):

        db = get_session()

        for identifier, label in self.statuses.iteritems():
            s = db.query(Status).filter_by(identifier=identifier).first()
            if not s:
                log.info('Creating status: %s', label)
                s = Status(identifier=identifier, label=toUnicode(label))
                db.add(s)

            s.label = toUnicode(label)
            db.commit()
Example #7
0
    def add(self, identifier):

        db = get_session()

        s = db.query(Status).filter_by(identifier=identifier).first()
        if not s:
            s = Status(identifier=identifier, label=identifier.capitalize())
            db.add(s)
            db.commit()

        status_dict = s.to_dict()

        return status_dict
Example #8
0
    def add(self, identifier):

        db = get_session()

        s = db.query(Status).filter_by(identifier = identifier).first()
        if not s:
            s = Status(
                identifier = identifier,
                label = toUnicode(identifier.capitalize())
            )
            db.add(s)
            db.commit()

        status_dict = s.to_dict()

        return status_dict
Example #9
0
    def fill(self):

        try:
            db = get_session()

            for identifier, label in self.statuses.items():
                s = db.query(Status).filter_by(identifier=identifier).first()
                if not s:
                    log.info('Creating status: %s', label)
                    s = Status(identifier=identifier, label=toUnicode(label))
                    db.add(s)

                s.label = toUnicode(label)
                db.commit()
        except:
            log.error('Failed: %s', traceback.format_exc())
            db.rollback()
        finally:
            db.close()
Example #10
0
    def fill(self):

        try:
            db = get_session()

            for identifier, label in self.statuses.items():
                s = db.query(Status).filter_by(identifier = identifier).first()
                if not s:
                    log.info('Creating status: %s', label)
                    s = Status(
                        identifier = identifier,
                        label = toUnicode(label)
                    )
                    db.add(s)

                s.label = toUnicode(label)
                db.commit()
        except:
            log.error('Failed: %s', traceback.format_exc())
            db.rollback()
        finally:
            db.close()