def getTarget(*args): # returns the users who's email is being analyzed #todo: read from file or config target = getOpt('target') stmt = ( " select e.email_addr, e.community, e.community_id, e.group_id, e.total_received, e.total_sent, e.rank " " from email_addr e " " where e.email_addr = %s ") tangelo.content_type("application/json") with newman_connector() as read_cnx: with execute_query(read_cnx.conn(), stmt, target) as qry: rtn = [[str(val) for val in row] for row in qry.cursor()] return {"email": rtn}
def getTarget(*args): # returns the users who's email is being analyzed #todo: read from file or config target = getOpt('target') stmt = ( " select e.email_addr, e.community, e.community_id, e.group_id, e.total_received, e.total_sent, e.rank " " from email_addr e " " where e.email_addr = %s " ) tangelo.content_type("application/json") with newman_connector() as read_cnx: with execute_query(read_cnx.conn(), stmt, target) as qry: rtn = [[str(val) for val in row] for row in qry.cursor()] return { "email" : rtn }
def buildExportable(*args): webroot = cherrypy.config.get("webroot") target = getOpt('target') base_src = "{}/emails/{}".format(webroot, target) tmp_dir = os.path.abspath("{}/../tmp/".format(webroot)) download_dir = "{}/downloads/".format(webroot) tar_gz = "export_{}".format(fmtNow()) base_dest = os.path.abspath("{}/../tmp/newman_dl".format(webroot)) if os.path.exists(base_dest): rmrf(base_dest) if not os.path.exists(download_dir): mkdir(download_dir) mkdir(base_dest) # Get list of paths... stmt = (" SELECT id, dir FROM email WHERE exportable='true' ") msg = '' paths_to_copy = [] tangelo.content_type("application/json") with newman_connector() as read_cnx: with execute_query(read_cnx.conn(), stmt) as qry: for email_id, val in qry.cursor(): src = "{}/{}/".format(base_src, val) dest = "{}/{}/".format(base_dest, val) shutil.copytree(src, dest) # compress dir shutil.make_archive("{}/{}".format(tmp_dir, tar_gz), "gztar", root_dir=base_dest) # move to web downloads mv("{}/{}.tar.gz".format(tmp_dir, tar_gz), "{}/{}.tar.gz".format(download_dir, tar_gz)) return {"file": "downloads/{}.tar.gz".format(tar_gz)}
def buildExportable(*args): webroot = cherrypy.config.get("webroot") target = getOpt('target') base_src = "{}/emails/{}".format(webroot,target) tmp_dir = os.path.abspath("{}/../tmp/".format(webroot)) download_dir = "{}/downloads/".format(webroot) tar_gz = "export_{}".format(fmtNow()) base_dest = os.path.abspath("{}/../tmp/newman_dl".format(webroot)) if os.path.exists(base_dest): rmrf(base_dest) if not os.path.exists(download_dir): mkdir(download_dir) mkdir(base_dest) # Get list of paths... stmt = ( " SELECT id, dir FROM email WHERE exportable='true' " ) msg = '' paths_to_copy = [] tangelo.content_type("application/json") with newman_connector() as read_cnx: with execute_query(read_cnx.conn(), stmt) as qry: for email_id, val in qry.cursor(): src = "{}/{}/".format(base_src,val) dest = "{}/{}/".format(base_dest, val) shutil.copytree(src, dest) # compress dir shutil.make_archive("{}/{}".format(tmp_dir, tar_gz), "gztar", root_dir=base_dest) # move to web downloads mv("{}/{}.tar.gz".format(tmp_dir, tar_gz), "{}/{}.tar.gz".format(download_dir, tar_gz)) return { "file" : "downloads/{}.tar.gz".format(tar_gz) }
def getTarget(*args, **kwargs): target = getOpt('target') tangelo.content_type("application/json") return {"email": []}
def getTarget(*args, **kwargs): target = getOpt('target') tangelo.content_type("application/json") return { "email" : []}