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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
import datetime
from decimal import Decimal
from enum import Enum
import pytest
from asyncmy.cursors import DictCursor
@pytest.mark.asyncio
async def test_fetchone(connection):
async with connection.cursor() as cursor:
await cursor.execute("SELECT 1")
ret = await cursor.fetchone()
assert ret == (1,)
@pytest.mark.asyncio
async def test_fetchall(connection):
async with connection.cursor() as cursor:
await cursor.execute("SELECT 1")
ret = await cursor.fetchall()
assert ret == ((1,),)
@pytest.mark.asyncio
async def test_dict_cursor(connection):
async with connection.cursor(cursor=DictCursor) as cursor:
await cursor.execute("SELECT 1")
ret = await cursor.fetchall()
assert ret == [{"1": 1}]
@pytest.mark.asyncio
async def test_insert(connection):
async with connection.cursor(cursor=DictCursor) as cursor:
rows = await cursor.execute(
"""INSERT INTO test.asyncmy(id,`decimal`, date, datetime, time,
`float`, string, `tinyint`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)""",
(
1,
1,
"2020-08-08",
"2020-08-08 00:00:00",
"00:00:00",
1,
"1",
1,
),
)
assert rows == 1
await cursor.execute("select * from test.asyncmy where id = %s", (cursor.lastrowid,))
result = await cursor.fetchall()
assert result == [
{
"id": 1,
"decimal": Decimal("1.00"),
"date": datetime.date(2020, 8, 8),
"datetime": datetime.datetime(2020, 8, 8, 0, 0),
"time": datetime.timedelta(hours=0, minutes=0, seconds=0),
"float": 1.0,
"string": "1",
"tinyint": 1,
}
]
@pytest.mark.asyncio
async def test_delete(connection):
async with connection.cursor() as cursor:
rows = await cursor.execute("delete from test.asyncmy where id = -1")
assert rows == 0
@pytest.mark.asyncio
async def test_executemany(connection):
async with connection.cursor(cursor=DictCursor) as cursor:
rows = await cursor.executemany(
"""INSERT INTO test.asyncmy(`decimal`, date, datetime, time, `float`,
string, `tinyint`) VALUES (%s,%s,%s,%s,%s,%s,%s)""",
[
(
1,
"2020-08-08",
"2020-08-08 00:00:00",
"00:00:00",
1,
"1",
1,
),
(
1,
"2020-08-08",
"2020-08-08 00:00:00",
"00:00:00",
1,
"1",
1,
),
],
)
assert rows == 2
@pytest.mark.asyncio
async def test_table_ddl(connection):
async with connection.cursor() as cursor:
await cursor.execute("drop table if exists test.alter_table")
create_table_sql = """
CREATE TABLE test.alter_table
(
`id` int primary key auto_increment
)
"""
await cursor.execute(create_table_sql)
add_column_sql = "alter table test.alter_table add column c varchar(20)"
await cursor.execute(add_column_sql)
await cursor.execute("drop table test.alter_table")
class EnumValue(str, Enum):
VALUE = "1"
@pytest.mark.asyncio
async def test_insert_enum(connection):
async with connection.cursor(cursor=DictCursor) as cursor:
rows = await cursor.execute(
"""INSERT INTO test.asyncmy(id, `decimal`, date, datetime, time,
`float`, string, `tinyint`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)""",
(
-1,
1,
"2020-08-08",
"2020-08-08 00:00:00",
"00:00:00",
1,
EnumValue.VALUE,
1,
),
)
assert rows == 1
|
