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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
|
from __future__ import annotations
import sys
from typing import Awaitable, Callable, List
import pytest
from textual.message import Message
from textual.notifications import Notify
from textual.widgets.text_area import Selection
from textual.widgets.tree import TreeNode
from harlequin import Harlequin
from harlequin.app import QuerySubmitted
from harlequin.catalog import CatalogItem
@pytest.mark.asyncio
async def test_query_formatting(
app: Harlequin,
wait_for_workers: Callable[[Harlequin], Awaitable[None]],
) -> None:
async with app.run_test() as pilot:
await wait_for_workers(app)
while app.editor is None:
await pilot.pause()
app.editor.text = "select\n\n1 FROM\n\n foo"
await pilot.press("f4")
assert app.editor.text == "select 1 from foo\n"
@pytest.mark.flaky
@pytest.mark.asyncio
async def test_multiple_buffers(
app: Harlequin,
app_snapshot: Callable[..., Awaitable[bool]],
wait_for_workers: Callable[[Harlequin], Awaitable[None]],
) -> None:
snap_results: List[bool] = []
async with app.run_test(size=(120, 36)) as pilot:
await wait_for_workers(app)
while app.editor is None:
await pilot.pause()
assert app.editor_collection
assert app.editor_collection.tab_count == 1
assert app.editor_collection.active == "tab-1"
app.editor.text = "tab 1"
await pilot.press("home")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Tab 1 of 1 (No tabs)"))
await pilot.press("ctrl+n")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.tab_count == 2
assert app.editor_collection.active == "tab-2"
assert app.editor.text == ""
app.editor.text = "tab 2"
await pilot.press("home")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Tab 2 of 2"))
await pilot.press("ctrl+n")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.tab_count == 3
assert app.editor_collection.active == "tab-3"
assert app.editor.text == ""
app.editor.text = "tab 3"
await pilot.press("home")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Tab 3 of 3"))
await pilot.press("ctrl+k")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.tab_count == 3
assert app.editor_collection.active == "tab-1"
assert app.editor.text == "tab 1"
snap_results.append(await app_snapshot(app, "Tab 1 of 3"))
await pilot.press("ctrl+k")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.tab_count == 3
assert app.editor_collection.active == "tab-2"
assert app.editor.text == "tab 2"
snap_results.append(await app_snapshot(app, "Tab 2 of 3"))
await pilot.press("ctrl+w")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.tab_count == 2
assert app.editor_collection.active == "tab-3"
assert app.editor.text == "tab 3"
# TODO: bring back this flaky test.
# snap_results.append(await app_snapshot(app, "Tab 3 after deleting 2"))
await pilot.press("ctrl+k")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.active == "tab-1"
assert app.editor.text == "tab 1"
snap_results.append(await app_snapshot(app, "Tab 1 of [1,3]"))
await pilot.press("ctrl+k")
await pilot.pause()
await pilot.wait_for_scheduled_animations()
assert app.editor_collection.active == "tab-3"
assert app.editor.text == "tab 3"
snap_results.append(await app_snapshot(app, "Tab 3 of [1,3]"))
assert all(snap_results)
@pytest.mark.flaky
@pytest.mark.asyncio
async def test_word_autocomplete(
app_all_adapters: Harlequin,
app_snapshot: Callable[..., Awaitable[bool]],
wait_for_workers: Callable[[Harlequin], Awaitable[None]],
transaction_button_visible: Callable[[Harlequin], bool],
) -> None:
app = app_all_adapters
snap_results: List[bool] = []
async with app.run_test() as pilot:
await wait_for_workers(app)
while app.editor is None or app.editor_collection.word_completer is None:
await pilot.pause()
# we need to let the data catalog load the root's children
while (
app.data_catalog.database_tree.loading
or not app.data_catalog.database_tree.root.children
):
await pilot.pause()
app.editor.focus()
await pilot.press("s")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "s"))
await pilot.press("e")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "se"))
await pilot.press("l")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "sel"))
await pilot.press("backspace")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "se again"))
await pilot.press("l")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
await pilot.press("enter")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "submitted"))
if not (transaction_button_visible(app)):
assert all(snap_results)
@pytest.mark.skipif(
sys.platform == "win32", reason="Initial snapshot very flaky on windows."
)
@pytest.mark.flaky
@pytest.mark.asyncio
async def test_member_autocomplete(
app_small_duck: Harlequin,
app_snapshot: Callable[..., Awaitable[bool]],
wait_for_workers: Callable[[Harlequin], Awaitable[None]],
) -> None:
app = app_small_duck
snap_results: List[bool] = []
async with app.run_test() as pilot:
await wait_for_workers(app)
async def _expand_and_wait(node: TreeNode[CatalogItem]) -> None:
node.expand()
while not node.children:
if getattr(node.data, "loaded", True):
break
await pilot.pause()
# we need to expand the data catalog to load items into the completer
while (
app.data_catalog.database_tree.loading
or not app.data_catalog.database_tree.root.children
):
await pilot.pause()
for db_node in app.data_catalog.database_tree.root.children:
await _expand_and_wait(db_node)
await wait_for_workers(app)
for schema_node in db_node.children:
await _expand_and_wait(schema_node)
await wait_for_workers(app)
await pilot.pause(1)
# now the completer should be populated
while app.editor is None or app.editor_collection.member_completer is None:
await pilot.pause()
app.editor.text = '"drivers"'
app.editor.selection = Selection((0, 9), (0, 9))
app.editor.focus()
await pilot.press("full_stop")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "driver members"))
await pilot.press("quotation_mark")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "with quote"))
await pilot.press("enter")
await pilot.pause()
await wait_for_workers(app)
await pilot.pause()
await pilot.wait_for_scheduled_animations()
snap_results.append(await app_snapshot(app, "submitted"))
assert all(snap_results)
@pytest.mark.asyncio
async def test_no_tree_sitter(
app: Harlequin,
monkeypatch: pytest.MonkeyPatch,
wait_for_workers: Callable[[Harlequin], Awaitable[None]],
) -> None:
import textual.document._syntax_aware_document
import textual.widgets._text_area
monkeypatch.setattr(textual.document._syntax_aware_document, "TREE_SITTER", False)
monkeypatch.setattr(textual.widgets._text_area, "TREE_SITTER", False)
messages: list[Message] = []
async with app.run_test(message_hook=messages.append) as pilot:
await wait_for_workers(app)
while app.editor is None:
await pilot.pause()
assert app.editor is not None
assert app.editor.text_input is not None
app.editor.text = "select 1; select 2"
assert not app.editor.text_input.is_syntax_aware
await pilot.press("ctrl+a")
await pilot.press("ctrl+j")
await pilot.pause()
await wait_for_workers(app)
submitted_msg = next(
iter(filter(lambda m: isinstance(m, QuerySubmitted), messages))
)
assert submitted_msg
assert isinstance(submitted_msg, QuerySubmitted)
assert len(submitted_msg.queries) == 2
text_area_warning = next(
iter(
filter(
lambda m: isinstance(m, Notify)
and m.notification.severity == "warning",
messages,
)
)
)
assert text_area_warning
@pytest.mark.asyncio
async def test_footer_inputs(
app: Harlequin,
wait_for_workers: Callable[[Harlequin], Awaitable[None]],
app_snapshot: Callable[..., Awaitable[bool]],
) -> None:
snap_results: List[bool] = []
async with app.run_test() as pilot:
await wait_for_workers(app)
while app.editor is None:
await pilot.pause()
assert app.editor is not None
assert app.editor.text_input is not None
app.editor.text = "select 1"
await pilot.press("ctrl+o")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Open Input visible"))
await pilot.press("ctrl+s")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Save Input visible"))
await pilot.press("escape")
await pilot.pause(0.1)
snap_results.append(await app_snapshot(app, "No Input visible"))
await pilot.press("ctrl+f")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Find Input visible"))
await pilot.press("escape")
await pilot.pause()
await pilot.press("ctrl+g")
await pilot.pause()
snap_results.append(await app_snapshot(app, "Goto Input visible"))
assert all(snap_results)
|
