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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
from decimal import Decimal
from sqlalchemy import BIGINT
from sqlalchemy import Column
from sqlalchemy import DECIMAL
from sqlalchemy import Integer
from sqlalchemy import select
from sqlalchemy import Sequence
from sqlalchemy import String
from sqlalchemy import Table
from sqlalchemy.testing import config
from sqlalchemy.testing import eq_
from sqlalchemy.testing import fixtures
from sqlalchemy.testing.provision import normalize_sequence
class SequenceTest(fixtures.TablesTest):
__only_on__ = "mssql"
__backend__ = True
@classmethod
def define_tables(cls, metadata):
Table(
"int_seq_t",
metadata,
Column(
"id", Integer, default=Sequence("int_seq", data_type=Integer())
),
Column(
"id_provision",
Integer,
default=normalize_sequence(
config, Sequence("id_provision", data_type=Integer())
),
),
Column(
"id_start",
Integer,
default=Sequence("id_start", data_type=Integer(), start=42),
),
Column("txt", String(50)),
)
Table(
"bigint_seq_t",
metadata,
Column(
"id",
BIGINT,
default=Sequence("bigint_seq", start=3000000000),
),
Column("txt", String(50)),
)
Table(
"decimal_seq_t",
metadata,
Column(
"id",
DECIMAL(10, 0),
default=Sequence(
"decimal_seq",
data_type=DECIMAL(10, 0),
start=3000000000,
),
),
Column("txt", String(50)),
)
def test_int_seq(self, connection):
t = self.tables.int_seq_t
connection.execute(t.insert().values({"txt": "int_seq test"}))
result = connection.execute(select(t)).first()
eq_(result.id, -(2**31))
eq_(result.id_provision, 1)
eq_(result.id_start, 42)
def test_bigint_seq(self, connection):
t = self.tables.bigint_seq_t
connection.execute(t.insert().values({"txt": "bigint_seq test"}))
result = connection.scalar(select(t.c.id))
eq_(result, 3000000000)
def test_decimal_seq(self, connection):
t = self.tables.decimal_seq_t
connection.execute(t.insert().values({"txt": "decimal_seq test"}))
result = connection.scalar(select(t.c.id))
eq_(result, Decimal("3000000000"))
|
