def METHOD_NAME():  # TODO: make this name automatic - wrapper?
    commit_collection_sql = s.sql.text("""
        SELECT
            r.repo_id,
            r.repo_path,
            r.repo_name,
            r.repo_git,
		    c.facade_status as repo_status
        FROM
            repo r,
			collection_status c
        WHERE
			r.repo_id = c.repo_id
		AND
			c.facade_status = 'Success';
    """)
    results = pd.read_sql(commit_collection_sql,  engine)
    data = results.to_json(
        orient="records", date_format='iso', date_unit='ms')
    return Response(response=data,
                    status=200,
                    mimetype="application/json")