| 1188 | } |
| 1189 | |
| 1190 | async saveCodePatterns(issueNumber, patterns) { |
| 1191 | const insertSQL = ` |
| 1192 | INSERT OR REPLACE INTO code_patterns |
| 1193 | (issue_number, pattern_name, pattern_type, code_snippet, explanation, use_cases, performance_notes, browser_support) |
| 1194 | VALUES (?, ?, ?, ?, ?, ?, ?, ?) |
| 1195 | `; |
| 1196 | |
| 1197 | for (const pattern of patterns) { |
| 1198 | await new Promise((resolve, reject) => { |
| 1199 | this.db.run( |
| 1200 | insertSQL, |
| 1201 | [ |
| 1202 | issueNumber, |
| 1203 | pattern.pattern_name, |
| 1204 | pattern.pattern_type, |
| 1205 | pattern.code_snippet, |
| 1206 | pattern.explanation, |
| 1207 | pattern.use_cases, |
| 1208 | pattern.performance_notes, |
| 1209 | pattern.browser_support |
| 1210 | ], |
| 1211 | function(err) { |
| 1212 | if (err) reject(err); |
| 1213 | else resolve(); |
| 1214 | } |
| 1215 | ); |
| 1216 | }); |
| 1217 | } |
| 1218 | } |
| 1219 | |
| 1220 | async savePropertyCategories(categories) { |
| 1221 | const insertSQL = ` |