개정판 b2544c55
issue #000: hmb mssql
Change-Id: I7ccaf4ad53fa2d0ee456cb5c7b70fac9cd819dab
| DTI_PID/DTI_PID/AppDocData.py | ||
|---|---|---|
| 2528 | 2528 |
index = index + 1 |
| 2529 | 2529 |
cursor.executemany(sql, tuple(params)) |
| 2530 | 2530 |
|
| 2531 |
conn.commit() |
|
| 2531 | 2532 |
self._hmbData = None |
| 2532 | 2533 |
|
| 2533 | 2534 |
except Exception as ex: |
| ... | ... | |
| 2726 | 2727 |
sql = app_doc_data.project.database.to_sql(sql) |
| 2727 | 2728 |
params = (str(uuid.uuid4()), stream_line[0], stream_line[1], stream_line[2], stream_line[3], stream_line[4]) |
| 2728 | 2729 |
cursor.execute(sql, params) |
| 2730 |
|
|
| 2731 |
conn.commit() |
|
| 2729 | 2732 |
except Exception as ex: |
| 2730 | 2733 |
# Roll back any change if something goes wrong |
| 2731 | 2734 |
conn.rollback() |
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 3247 | 3247 |
[To_Component_UID] VARCHAR ( 37 ), |
| 3248 | 3248 |
[Stream_No] VARCHAR ( 100 ), |
| 3249 | 3249 |
[Case] VARCHAR ( 100 ), |
| 3250 |
FOREIGN KEY([From_Component_UID]) REFERENCES [Components]([UID]) ON DELETE CASCADE, |
|
| 3251 | 3250 |
FOREIGN KEY([Drawing_UID]) REFERENCES [Drawings]([UID]) ON DELETE CASCADE, |
| 3252 |
PRIMARY KEY([UID]),
|
|
| 3253 |
FOREIGN KEY([To_Component_UID]) REFERENCES [Components]([UID]) ON DELETE CASCADE )
|
|
| 3251 |
PRIMARY KEY([UID]) |
|
| 3252 |
);
|
|
| 3254 | 3253 |
|
| 3255 | 3254 |
CREATE TABLE HMB_LIST ( |
| 3256 | 3255 |
[UID] VARCHAR ( 37 ), |
| DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
|---|---|---|
| 89 | 89 |
`To_Component_UID` VARCHAR ( 37 ), |
| 90 | 90 |
`Stream_No` VARCHAR ( 100 ), |
| 91 | 91 |
`Case` VARCHAR ( 100 ), |
| 92 |
FOREIGN KEY(`From_Component_UID`) REFERENCES `Components`(`UID`) ON DELETE CASCADE, |
|
| 93 | 92 |
FOREIGN KEY(`Drawing_UID`) REFERENCES `Drawings`(`UID`) ON DELETE CASCADE, |
| 94 |
PRIMARY KEY(`UID`), |
|
| 95 |
FOREIGN KEY(`To_Component_UID`) REFERENCES `Components`(`UID`) ON DELETE CASCADE |
|
| 93 |
PRIMARY KEY(`UID`) |
|
| 96 | 94 |
); |
| 97 | 95 |
|
| 98 | 96 |
CREATE TABLE IF NOT EXISTS "HMB_LIST" ( |
내보내기 Unified diff
