Get commonly used patterns
(self, min_frequency: int = 3)
| 231 | self.conn.commit() |
| 232 | |
| 233 | def get_common_patterns(self, min_frequency: int = 3) -> List[Dict]: |
| 234 | """Get commonly used patterns""" |
| 235 | cursor = self.conn.cursor() |
| 236 | cursor.execute(""" |
| 237 | SELECT pattern_name, operation_sequence, frequency, success_rate, avg_time |
| 238 | FROM patterns |
| 239 | WHERE frequency >= ? |
| 240 | ORDER BY frequency DESC |
| 241 | """, (min_frequency,)) |
| 242 | |
| 243 | patterns = [] |
| 244 | for row in cursor.fetchall(): |
| 245 | patterns.append({ |
| 246 | "name": row[0], |
| 247 | "sequence": json.loads(row[1]), |
| 248 | "frequency": row[2], |
| 249 | "success_rate": row[3], |
| 250 | "avg_time": row[4] |
| 251 | }) |
| 252 | |
| 253 | return patterns |
| 254 | |
| 255 | def learn_preference(self, pref_type: str, pref_value: str, confidence: float = 1.0): |
| 256 | """Learn a user preference""" |