def dump()

in bugbot/db.py [0:0]

• 32 lines of code
• 10 McCabe index (conditional complexity)

    def dump(path=""):
        res = session.query(Email).join(Email.tool).join(Email.user)
        ext = os.path.splitext(path)[1]
        if ext == ".csv":
            with open(path, "w") as Out:
                writer = csv.writer(Out, delimiter=",")
                writer.writerow(["Tool", "User", "Date", "Extra", "Result"])
                for x in res:
                    extra = x.extra.extra if x.extra else ""
                    res = "Success" if x.result != 0 else "Failure"
                    writer.writerow(
                        [x.tool.name, x.user.email, str(x.get_date()), extra, res]
                    )
        elif ext == ".json":
            with open(path, "w") as Out:
                data = []
                for x in res:
                    extra = x.extra.extra if x.extra else ""
                    res = "Success" if x.result != 0 else "Failure"
                    data.append(
                        {
                            "tool": x.tool.name,
                            "user": x.user.email,
                            "date": str(x.get_date()),
                            "extra": extra,
                            "result": res,
                        }
                    )
                json.dump(data, Out)
        else:
            for x in res:
                print(x)