def test_constructs_single_query_no_deps(self):
code = SqlCode("select company_name, company_id from companies", "companies")
repo = Repository()
repo.add_queries(code.queries)
qg = QueryGenerator(repo)
output = qg.generate_query("companies")
self.assertEqual(output.lower(), "select company_name, company_id from companies")
def export(self, query: Query):
qg = QueryGenerator(self.repo)
output_sql_text = qg.generate_query(query.name)
fields = self.format_fields(query.columns)
output_text = self.base.format(query.name.replace("looker_", ""), query.columns[0].name, output_sql_text, fields)
with open(self.file_name, "w") as file_open:
file_open.write(output_text)
def export(self, query: Query):
qg = QueryGenerator(self.repo)
output_sql_text = qg.generate_query(query.name)
fields = self.format_fields(query.columns)
output_text = self.base.format(query.name.replace("looker_", ""),
query.columns[0].name, output_sql_text,
fields)
with open(self.file_name, "w") as file_open:
file_open.write(output_text)
def export(self, query: Query):
qg = QueryGenerator(self.repo)
output_text = qg.generate_query(query.name)
with open(self.file_name, "w") as file_open:
file_open.write(output_text)
def export(self, query: Query):
qg = QueryGenerator(self.repo)
output_text = qg.generate_query(query.name)
with open(self.file_name, "w") as file_open:
file_open.write(output_text)
