SQLame/test.py at main · Szymon423/SQLame · GitHub

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
import requests
import pytest
import json

# URL serwera bazy danych
BASE_URL = "http://localhost:9443"

# Przykładowe dane do testów
create_table_1 = {
    "CREATE": {
        "TABLE": {
            "NAME": "MY_TABLE",
            "COLUMNS": [
                {
                    "NAME": "id",
                    "TYPE": "INT",
                    "ATTRIBUTES": [
                        "UNIQUE",
                        "PRIMARY_KEY",
                        "AUTOINCREMENT"
                    ]
                },
                {
                    "NAME": "name",
                    "TYPE": "TEXT"
                },
                {
                    "NAME": "valid",
                    "TYPE": "BOOLEAN"
                },
                {
                    "NAME": "value",
                    "TYPE": "DOUBLE"
                },
                {
                    "NAME": "timestamp",
                    "TYPE": "UNIX_TIME"
                },
                {
                    "NAME": "something",
                    "TYPE": "BLOB"
                }
            ]
        }
    }
}


drop_table_1 = {
    "DROP" : {
        "TABLE": {
            "NAME": "MY_TABLE"
        }
    }
}

create_table_2 = {
    "CREATE": {
        "TABLE": {
            "NAME": "MY_TABLE",
            "COLUMNS": [
                {
                    "NAME": "id",
                    "TYPE": "INT",
                },
                {
                    "NAME": "name",
                    "TYPE": "TEXT"
                },
                {
                    "NAME": "value",
                    "TYPE": "DOUBLE"
                }
            ]
        }
    }
}

insert_table_2 = {
    "INSERT" : {
        "INTO": "MY_TABLE",
        "VALUES": [
            {
                "id": 0,
                "name": "truskawka",
                "value": 123.4
            },
            {
                "id": 1,
                "name": "gruszka",
                "value": 12.34
            },
        ]
    }
}

drop_table_2 = {
    "DROP" : {
        "TABLE": {
            "NAME": "MY_TABLE"
        }
    }
}

def test_create_table():
    response = requests.post(f"{BASE_URL}", json=create_table_2)
    print(f"Status Code: {response.status_code}")
    assert response.status_code == 200
    print(f"Response Body: {response.text}")
    data = response.json()
    assert data["message"] == "Table MY_TABLE created succesfully"

def test_table_allready_exist():
    response = requests.post(f"{BASE_URL}", json=create_table_2)
    print(f"Status Code: {response.status_code}")
    assert response.status_code == 200
    print(f"Response Body: {response.text}")
    data = response.json()
    assert data["message"] == "Table allready exists."

def test_insert():
    response = requests.post(f"{BASE_URL}", json=insert_table_2)
    print(f"Status Code: {response.status_code}")
    assert response.status_code == 200
    print(f"Response Body: {response.text}")
    data = response.json()
    assert data["message"] == "Inserted 2 values into table 'MY_TABLE'."

def test_insert_2():
    response = requests.post(f"{BASE_URL}", json=insert_table_2)
    print(f"Status Code: {response.status_code}")
    assert response.status_code == 200
    print(f"Response Body: {response.text}")
    data = response.json()
    assert data["message"] == "Inserted 2 values into table 'MY_TABLE'."

def test_insert_3():
    response = requests.post(f"{BASE_URL}", json=insert_table_2)
    print(f"Status Code: {response.status_code}")
    assert response.status_code == 200
    print(f"Response Body: {response.text}")
    data = response.json()
    assert data["message"] == "Inserted 2 values into table 'MY_TABLE'."

def test_drop_table_exist():
    response = requests.post(f"{BASE_URL}", json=drop_table_2)
    print(f"Status Code: {response.status_code}")
    assert response.status_code == 200
    print(f"Response Body: {response.text}")
    data = response.json()
    assert data["message"] == "Table MY_TABLE dropped succesfully."

if __name__ == "__main__":
    pytest.main()