def test_where_value_object(self):
     class TestClass(object):
         def __str__(self):
             return "object as a string"
     q = Select()
     sql_t = q.from_table('t1').where_value('t1c1', TestClass()).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 WHERE `t1c1` = ?', ['object as a string']))

 def test_having_value_or(self):
     q = Select()
     sql_t = q.from_table('t1').having_or().having_value('t1c1', 3).having_value('t1c1', 5).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING (`t1c1` = 3 OR `t1c1` = 5)', None))

 def test_join_field(self):
     # join(table, 'Field1')
     # JOIN table USING (Field1)
     q = Select()
     sql_t = q.columns(['t1c1', 't2c1']).from_table('t1').left_join('t2', 't1c1').sql()
     assert_equals(sql_t, ('SELECT `t1c1`, `t2c1` FROM t1 LEFT JOIN t2 USING (`t1c1`)', None))

 def test_select_quote_col_func(self):
     q = Select()
     sql_t = q.from_table('t1').columns('DATE(`t1c1`)').sql()
     assert_equals(sql_t, ('SELECT DATE(`t1c1`) FROM t1', None))

 def test_select_distinct(self):
     q = Select('t1')
     sql_t = q.set_option('DISTINCT').columns('t1c1').sql()
     assert_equals(sql_t, ('SELECT DISTINCT `t1c1` FROM t1', None))

 def test_select_no_table(self):
     q = Select()
     sql_t = q.column_expr('1+1').sql()
     assert_equals(sql_t, ('SELECT 1+1', None))

 def test_join_no_root(self):
     q = Select()
     q.columns(['t1c1', 't2c1']).left_join('t2', 't1c1').sql()

 def test_qualify_columns(self):
     q = Select()
     sql_t = q.from_table('t1').columns(('t1c1', 't1c2')).qualify_columns('t1', ('t1c1',)).sql()
     assert_equals(sql_t, ('SELECT t1.`t1c1`, `t1c2` FROM t1', None))

 def test_having_expr_with_expr_param(self):
     q = Select()
     sql_t = q.from_table('t1').having_expr('`t1c1` = PASSWORD(?)', ('mypw',)).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING `t1c1` = PASSWORD(?)', ['mypw']))

 def test_having_expr(self):
     q = Select()
     sql_t = q.from_table('t1').having_expr('`t1c1` = NOW()').sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING `t1c1` = NOW()', None))

 def test_having_raw_value_with_param(self):
     q = Select()
     sql_t = q.from_table('t1').having_raw_value('t1c1', 'PASSWORD(?)', value_params=('mypw',)).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING `t1c1` = PASSWORD(?)', ['mypw']))

 def test_having_values_dict(self):
     q = Select()
     sql_t = q.from_table('t1').having_value(OrderedDict([('t1c1', 3), ('t1c2', 'string')])).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING (`t1c1` = 3 AND `t1c2` = ?)', ['string']))

 def test_select_col_callable(self):
     q = Select()
     sql_t = q.from_table('t1').columns('t1c1')()
     assert_equals(sql_t, ('SELECT `t1c1` FROM t1', None))

 def test_having_value_or_and(self):
     q = Select(having_predicate='AND')
     sql_t = q.from_table('t1').having_or().having_value('t1c1', 1).having_value('t1c1', 5).having_or().having_value('t1c1', 6).having_value('t1c1', 10).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING ((`t1c1` = 1 OR `t1c1` = 5) AND (`t1c1` = 6 OR `t1c1` = 10))', None))

 def test_having_value_and_or(self):
     q = Select()
     sql_t = q.from_table('t1').having_and().having_value('t1c1', 1).having_value('t1c2', 5).having_and().having_value('t1c1', 6).having_value('t1c2', 10).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 HAVING ((`t1c1` = 1 AND `t1c2` = 5) OR (`t1c1` = 6 AND `t1c2` = 10))', None))

 def test_where_value_utf_noparam(self):
     q = Select(placeholder=False)
     sql = q.from_table('t1').where_value('t1c1', u'"äöü"').sql()
     assert_equals(sql, u'SELECT * FROM t1 WHERE `t1c1` = "äöü"')

 def test_remove_col_expr(self):
     q = Select()
     sql_t = q.from_table('t1').columns('t1c1').column_expr('1+1 AS t2c1').remove_column('t2c1').sql()
     assert_equals(sql_t, ('SELECT `t1c1` FROM t1', None))

 def test_select_orderby(self):
     q = Select()
     sql_t = q.from_table('t1').order_by('t1c1').sql()
     assert_equals(sql_t, ('SELECT * FROM t1 ORDER BY t1c1', None))

 def test_qualify_columns_all_nonqual(self):
     q = Select()
     sql_t = q.from_table(('t1', 't2')).columns(('t1c1', 't2.t2c1')).qualify_columns('t1').sql()
     assert_equals(sql_t, ('SELECT t1.`t1c1`, t2.`t2c1` FROM t1, t2', None))

 def test_select_groupbys(self):
     q = Select()
     sql_t = q.from_table('t1').group_by(['t1c1', 't1c2']).sql()
     assert_equals(sql_t, ('SELECT * FROM t1 GROUP BY t1c1, t1c2', None))