1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
import testbase
from sqlalchemy import *
from sqlalchemy.databases import firebird
from sqlalchemy.sql import table, column
from testlib import *
class BasicTest(AssertMixin):
# A simple import of the database/ module should work on all systems.
def test_import(self):
# we got this far, right?
return True
class CompileTest(SQLCompileTest):
__dialect__ = firebird.FBDialect()
def test_alias(self):
t = table('sometable', column('col1'), column('col2'))
s = select([t.alias()])
self.assert_compile(s, "SELECT sometable_1.col1, sometable_1.col2 FROM sometable sometable_1")
def test_function(self):
self.assert_compile(func.foo(1, 2), "foo(:foo, :foo_1)")
self.assert_compile(func.current_time(), "current_time")
self.assert_compile(func.foo(), "foo")
m = MetaData()
t = Table('sometable', m, Column('col1', Integer), Column('col2', Integer))
self.assert_compile(select([func.max(t.c.col1)]), "SELECT max(sometable.col1) FROM sometable")
if __name__ == '__main__':
testbase.main()
|
