-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathTest.py
39 lines (37 loc) · 784 Bytes
/
Test.py
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
-- CREATE TABLE to store the problem parameters
CREATE TABLE problem_parameters (
ID UUID,
SOLVED_ON TIMESTAMP,
LABEL VARCHAR(50),
STATUS VARCHAR(50),
COMPLETED VARCHAR(50),
SUBMITTED_BY VARCHAR(50),
TYPE VARCHAR(50),
NUM_READS INT,
SUBMITTED_ON TIMESTAMP
);
-- INSERT statement to insert the problem parameters
INSERT INTO problem_parameters VALUES (
'6dbabf04-9a93-4534-9239-51d9edc7cbe2',
'2023-05-18T722:14:41702012Z',
'Copy Value',
'Training - Embedding',
'COMPLETED',
'SOLVER',
'Advantage_system4.1',
'qubo',
10,
'2023-05-18T722:14:41.533053Z'
);
-- SELECT statement to retrieve the problem parameters
SELECT
ID,
SOLVED_ON,
LABEL,
STATUS,
COMPLETED,
SUBMITTED_BY,
TYPE,
NUM_READS,
SUBMITTED_ON
FROM problem_parameters;