Esempi in Python per QueryBuilder.get_query_and_params

Esempio n. 1

File: test_querybuilder.py Progetto: Duke-GCB/TF-DNA-PredictionsDB

 def test_append_two_items(self):
     builder = QueryBuilder()
     builder.set_schema.add("SET search_path TO %s,public;", ["hg38"])
     builder.query.add("select 1 from table where value = %s;", [5])
     query, params = builder.get_query_and_params()
     expected_sql = "SET search_path TO %s,public;\nselect 1 from table where value = %s;"
     expected_params = ["hg38", 5]
     self.assertEqual(expected_sql, query)
     self.assertEqual(expected_params, params)

Esempio n. 2

File: test_querybuilder2.py Progetto: gordanlab/TF-DNA-PredictionsDB

 def test_append_two_items(self):
     builder = QueryBuilder()
     builder.set_schema.add("SET search_path TO %s,public;", ["hg38"])
     builder.query.add("select 1 from table where value = %s;", [5])
     query, params = builder.get_query_and_params()
     expected_sql = "SET search_path TO %s,public;\nselect 1 from table where value = %s;"
     expected_params = ["hg38", 5]
     self.assertEqual(expected_sql, query)
     self.assertEqual(expected_params, params)

Esempio n. 3

 def get_query_and_params(self):
     builder = QueryBuilder()
     builder.set_schema.add_part(set_search_path(self.schema))
     if self.count:
         builder.query.add_part(begin_count())
     builder.query.add_parts(self.main_query_parts())
     if self.count:
         builder.query.add_part(end_count())
     return builder.get_query_and_params()

Esempio n. 4

File: genelistquery.py Progetto: Duke-GCB/TF-DNA-PredictionsDB

 def get_query_and_params(self):
     builder = QueryBuilder()
     builder.set_schema.add_part(set_search_path(self.schema))
     if self.count:
         builder.query.add_part(begin_count())
     builder.query.add_parts(self.main_query_parts())
     if self.count:
         builder.query.add_part(end_count())
     return builder.get_query_and_params()

Esempio n. 5

File: genelistquery.py Progetto: gordanlab/TF-DNA-PredictionsDB

 def get_query_and_params(self):
     builder = QueryBuilder()
     builder.set_schema.add_part(set_search_path(self.schema))
     builder.query.add_parts([
         items_not_in_gene_list(self.custom_list_id,
                                self.custom_list_filter,
                                self.custom_gene_name_type)
     ])
     return builder.get_query_and_params()

Esempio n. 6

File: test_querybuilder.py Progetto: Duke-GCB/TF-DNA-PredictionsDB

    def test_all_items(self):
        builder = QueryBuilder()
        builder.set_schema.add_part(set_search_path("hg38"))
        builder.with_clause.add("WITH regional_sales AS (SELECT amount AS total_sales FROM orders)", [])
        builder.query.add("SELECT * from orders where total_sales > %s;", [200])
        query, params = builder.get_query_and_params()
        expected_sql = """SET search_path TO %s,public;
WITH regional_sales AS (SELECT amount AS total_sales FROM orders)
SELECT * from orders where total_sales > %s;"""
        expected_params = ["hg38", 200]
        self.assertEqual(expected_sql, query)
        self.assertEqual(expected_params, params)

Esempio n. 7

File: test_querybuilder2.py Progetto: gordanlab/TF-DNA-PredictionsDB

    def test_all_items(self):
        builder = QueryBuilder()
        builder.set_schema.add_part(set_search_path("hg38"))
        builder.with_clause.add(
            "WITH regional_sales AS (SELECT amount AS total_sales FROM orders)",
            [])
        builder.query.add("SELECT * from orders where total_sales > %s;",
                          [200])
        query, params = builder.get_query_and_params()
        expected_sql = """SET search_path TO %s,public;
WITH regional_sales AS (SELECT amount AS total_sales FROM orders)
SELECT * from orders where total_sales > %s;"""
        expected_params = ["hg38", 200]
        self.assertEqual(expected_sql, query)
        self.assertEqual(expected_params, params)

Esempio n. 8

File: test_querybuilder2.py Progetto: gordanlab/TF-DNA-PredictionsDB

 def test_starts_blank(self):
     builder = QueryBuilder()
     query, params = builder.get_query_and_params()
     self.assertEqual("", query)
     self.assertEqual([], params)

Esempio n. 9

File: test_querybuilder2.py Progetto: gordanlab/TF-DNA-PredictionsDB

 def test_simple_query(self):
     builder = QueryBuilder()
     builder.query.add("select 1 from table where value = %s;", [5])
     query, params = builder.get_query_and_params()
     self.assertEqual("select 1 from table where value = %s;", query)
     self.assertEqual([5], params)

Esempio n. 10

File: test_querybuilder.py Progetto: Duke-GCB/TF-DNA-PredictionsDB

 def test_starts_blank(self):
     builder = QueryBuilder()
     query, params = builder.get_query_and_params()
     self.assertEqual("", query)
     self.assertEqual([], params)

Esempio n. 11

File: test_querybuilder.py Progetto: Duke-GCB/TF-DNA-PredictionsDB

 def test_simple_query(self):
     builder = QueryBuilder()
     builder.query.add("select 1 from table where value = %s;", [5])
     query, params = builder.get_query_and_params()
     self.assertEqual("select 1 from table where value = %s;", query)
     self.assertEqual([5], params)