개정판 469c42f1
issue #1190: optimization open drawing finish before exclusive opening
Change-Id: I4fdac86db0dce4f41ba24d96912d4fbd3aed6323
| DTI_PID/DTI_PID/AppDocData.py | ||
|---|---|---|
| 2082 | 2082 |
cursor = conn.cursor() if self.project.database.db_type == 'SQLite' else conn.cursor(as_dict=True) |
| 2083 | 2083 |
|
| 2084 | 2084 |
#sql = "select * from Points where Components_UID='{}' order by [Index]".format(component)
|
| 2085 |
sql = "select * from Points order by Components_UID, [Index]".format(component) |
|
| 2085 |
sql = "select a.* from Points a \ |
|
| 2086 |
join Components b on a.Components_UID=b.[UID] where Drawings_UID='{}' order by Components_UID, [Index]".format(self.activeDrawing.UID)
|
|
| 2086 | 2087 |
cursor.execute(sql) |
| 2087 | 2088 |
|
| 2088 | 2089 |
pre = '' |
| ... | ... | |
| 2118 | 2119 |
cursor = conn.cursor() if self.project.database.db_type == 'SQLite' else conn.cursor(as_dict=True) |
| 2119 | 2120 |
|
| 2120 | 2121 |
#sql = "select * from Associations where Components_UID='{}'".format(component)
|
| 2121 |
sql = "select * from Associations order by Components_UID" |
|
| 2122 |
sql = "select a.* from Associations a \ |
|
| 2123 |
join Components b on a.Components_UID=b.[UID] where Drawings_UID='{}' order by Components_UID".format(self.activeDrawing.UID)
|
|
| 2122 | 2124 |
cursor.execute(sql) |
| 2123 | 2125 |
|
| 2124 | 2126 |
pre = '' |
| ... | ... | |
| 2155 | 2157 |
|
| 2156 | 2158 |
#sql = "select * from [Attributes] a \ |
| 2157 | 2159 |
# join SymbolAttribute b on a.SymbolAttribute_UID=b.UID where a.Components_UID='{}' order by a.Components_UID,b.[index]".format(component)
|
| 2158 |
sql = "select * from [Attributes] a \ |
|
| 2159 |
join SymbolAttribute b on a.SymbolAttribute_UID=b.UID order by a.Components_UID, b.[index]" |
|
| 2160 |
sql = "select a.*, b.* from Attributes a \ |
|
| 2161 |
join SymbolAttribute b on a.SymbolAttribute_UID=b.UID \ |
|
| 2162 |
join Components c on a.Components_UID=c.UID \ |
|
| 2163 |
where Drawings_UID='{}' order by a.Components_UID, b.[index]".format(self.activeDrawing.UID)
|
|
| 2160 | 2164 |
cursor.execute(sql) |
| 2161 | 2165 |
|
| 2162 | 2166 |
pre = '' |
내보내기 Unified diff
