My logging messages do not show up when SQL Alchemy is using logging to
show its messages. Any way to fix this? My program is below:
#!/usr/bin/env python
# system modules
import logging, pprint, re, sys
# 3rd party modules
import argparse
# local modules
import abstracts, conf, htmlmail, resultgroup, sqlgen, users
sys.path.append('..')
import data.storage
bad_data = [
]
def main():
p = argparse.ArgumentParser(prog='proc.py')
p.add_argument('--test_login', help = 'optional test login')
p.add_argument('--no_send', help = 'optional do not send generated
email')
args = p.parse_args(sys.argv[1:])
sa = conf.sqlalchemy()
ar_users = users.load_all(sa, args.test_login)
for ar_user in ar_users:
if ar_user['userid'] in [ x[0] for x in bad_data ]: continue
"""Email addresses with spaces wreak havoc when I try to write
files
with that name. Solution is here:
http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/4ce6b202d8e231cc/fba2da51d58a4679#fba2da51d58a4679
"""
user_email = re.compile(r'\s+').sub('', ar_user['email'])
logging.info("====================================")
rg = resultgroup.resultgroup(user_email)
logging.info(pprint.pformat(ar_user))
logging.debug('USER_KEYS: %r', ar_user.keys())
user_searches = users.searches(sa, ar_user['userid'])
for user_search in user_searches:
if user_search['search'] is None: continue
logging.info("----------------------------------")
logging.info(pprint.pformat(user_search))
logging.debug("SEARCH_KEYS %r", user_search.keys())
sql, or_snippet = sqlgen.sqlgen(user_search['search'])
new, old = abstracts.fulltext_results(sa, sql)
rg.resultset.append( resultgroup.resultset(or_snippet, new,
old) )
rg.genhtml()
if args.no_send:
logging.info("No send mode... not sending email")
else:
htmlmail.send(rg.htmlfile, user_email)
if __name__ == '__main__':
main()
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/sqlalchemy
-~----------~----~----~----~------~----~------~--~---
