forked from feldera/feldera
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest_pipeline.py
More file actions
238 lines (178 loc) · 6.34 KB
/
test_pipeline.py
File metadata and controls
238 lines (178 loc) · 6.34 KB
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
import os
import pathlib
import unittest
import uuid
import threading
from tests import TEST_CLIENT
from feldera.rest.pipeline import Pipeline
class TestPipeline(unittest.TestCase):
result = None
def test_delete_all_pipelines(self):
pipelines = TEST_CLIENT.pipelines()
for pipeline in pipelines:
TEST_CLIENT.delete_pipeline(pipeline.name)
def test_create_pipeline(
self, name: str = "blah", delete=False, runtime_config: dict = {}
):
self.test_delete_all_pipelines()
sql = """
CREATE TABLE tbl(id INT) WITH ('append_only' = 'true');
CREATE VIEW V AS SELECT * FROM tbl;
"""
pipeline = Pipeline(name, sql, "", "", {}, runtime_config)
pipeline = TEST_CLIENT.create_pipeline(pipeline)
if delete:
TEST_CLIENT.delete_pipeline(pipeline.name)
def test_delete_pipeline(self):
name = str(uuid.uuid4())
self.test_create_pipeline(name, False)
TEST_CLIENT.delete_pipeline(name)
def __test_push_to_pipeline(self, data, format, array):
name = str(uuid.uuid4())
self.test_create_pipeline(name, False)
TEST_CLIENT.start_pipeline(name)
TEST_CLIENT.push_to_pipeline(
pipeline_name=name,
table_name="tbl",
format=format,
array=array,
data=data,
)
TEST_CLIENT.pause_pipeline(name)
TEST_CLIENT.shutdown_pipeline(name)
TEST_CLIENT.delete_pipeline(name)
def test_push_to_pipeline_json(self):
data = [
{"id": 1},
{"id": 2},
{"id": 3},
]
self.__test_push_to_pipeline(data, format="json", array=True)
def test_push_to_pipeline_csv0(self):
data = "1\n2\n"
self.__test_push_to_pipeline(data, format="csv", array=False)
def test_list_pipelines(self):
name = str(uuid.uuid4())
self.test_create_pipeline(name, False)
pipelines = TEST_CLIENT.pipelines()
assert len(pipelines) > 0
assert name in [p.name for p in pipelines]
TEST_CLIENT.delete_pipeline(name)
def test_get_pipeline(self):
name = str(uuid.uuid4())
self.test_create_pipeline(name, False)
p = TEST_CLIENT.get_pipeline(name)
assert name == p.name
TEST_CLIENT.delete_pipeline(name)
def test_get_pipeline_config(self):
name = str(uuid.uuid4())
self.test_create_pipeline(name, False, {"workers": 2, "storage": False})
config = TEST_CLIENT.get_runtime_config(name)
assert config is not None
assert config.get("workers") == 2
assert not config.get("storage")
TEST_CLIENT.delete_pipeline(name)
def test_get_pipeline_stats(self):
name = str(uuid.uuid4())
self.test_create_pipeline(name, delete=False)
TEST_CLIENT.start_pipeline(name)
stats = TEST_CLIENT.get_pipeline_stats(name)
assert stats is not None
assert stats.get("pipeline_config") is not None
TEST_CLIENT.pause_pipeline(name)
TEST_CLIENT.shutdown_pipeline(name)
TEST_CLIENT.delete_pipeline(name)
def __listener(self, name: str):
gen_obj = TEST_CLIENT.listen_to_pipeline(
pipeline_name=name,
table_name="V",
format="csv",
)
counter = 0
for chunk in gen_obj:
counter += 1
text_data = chunk.get("text_data")
if text_data:
assert text_data == "1,1\n2,1\n"
self.result = True
break
if counter > 10:
self.result = False
break
def test_listen_to_pipeline(self):
data = "1\n2\n"
name = str(uuid.uuid4())
self.test_create_pipeline(name, False)
TEST_CLIENT.pause_pipeline(name)
t1 = threading.Thread(target=self.__listener, args=(name,))
t1.start()
TEST_CLIENT.start_pipeline(name)
TEST_CLIENT.push_to_pipeline(name, "tbl", "csv", data)
t1.join()
assert self.result
TEST_CLIENT.shutdown_pipeline(name)
TEST_CLIENT.delete_pipeline(name)
def test_adhoc_query_text(self):
data = "1\n2\n"
name = str(uuid.uuid4())
sql = """
CREATE TABLE tbl(id INT) with ('materialized' = 'true');
"""
pipeline = Pipeline(name, sql, "", "", {}, {})
pipeline = TEST_CLIENT.create_pipeline(pipeline)
TEST_CLIENT.start_pipeline(name)
TEST_CLIENT.push_to_pipeline(name, "tbl", "csv", data)
resp = TEST_CLIENT.query_as_text(pipeline.name, "SELECT * FROM tbl")
expected = [
"""+----+
| id |
+----+
| 1 |
| 2 |
+----+""",
"""+----+
| id |
+----+
| 2 |
| 1 |
+----+""",
]
got = "\n".join(resp)
assert got in expected
TEST_CLIENT.shutdown_pipeline(name)
TEST_CLIENT.delete_pipeline(name)
def test_adhoc_query_parquet(self):
data = "1\n2\n"
name = str(uuid.uuid4())
sql = """
CREATE TABLE tbl(id INT) with ('materialized' = 'true');
"""
pipeline = Pipeline(name, sql, "", "", {}, {})
pipeline = TEST_CLIENT.create_pipeline(pipeline)
TEST_CLIENT.start_pipeline(name)
TEST_CLIENT.push_to_pipeline(name, "tbl", "csv", data)
file = name.split("-")[0]
TEST_CLIENT.query_as_parquet(pipeline.name, "SELECT * FROM tbl", file)
TEST_CLIENT.shutdown_pipeline(name)
TEST_CLIENT.delete_pipeline(name)
path = pathlib.Path(file + ".parquet")
assert path.stat().st_size > 0
os.remove(path)
def test_adhoc_query_json(self):
data = "1\n2\n"
name = str(uuid.uuid4())
sql = """
CREATE TABLE tbl(id INT) with ('materialized' = 'true');
"""
pipeline = Pipeline(name, sql, "", "", {}, {})
pipeline = TEST_CLIENT.create_pipeline(pipeline)
TEST_CLIENT.start_pipeline(name)
TEST_CLIENT.push_to_pipeline(name, "tbl", "csv", data)
resp = TEST_CLIENT.query_as_json(pipeline.name, "SELECT * FROM tbl")
expected = [{"id": 2}, {"id": 1}]
got = list(resp)
self.assertCountEqual(got, expected)
TEST_CLIENT.shutdown_pipeline(name)
TEST_CLIENT.delete_pipeline(name)
if __name__ == "__main__":
unittest.main()