def sql(args):
from definitions import get_definition
for item in args.items:
print '\n\nSQL for %s\n' % item
info = get_definition(item)
sql = info.get('sql')
tables = info.get('tables')
ts = {}
for index, table in enumerate(tables):
ts['t%s' % (index + 1)] = '"%s"' % table
print sql.format(**ts)
def build_views_and_summaries(items, all=False, verbose=0, force=False, dependencies=True):
updates = []
if not dependencies:
updates = items
if items and dependencies:
# FIXME would be nice to move this to top of page
from dependencies import dependencies_manager
updates = dependencies_manager.updates_for(items)
if all:
updates = definitions.get_all_definition_names()
for item in updates:
info = definitions.get_definition(item)
try:
if info.get('as_view'):
time_fn(_build_view, args=[info], verbose=verbose, kw={'force': force})
else:
time_fn(_build_summary, args=[info], verbose=verbose)
except Exception as e:
print 'failed %s' % item
print str(e)
continue
