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" : []}
