Get effect name from the new db
(effect)
| 152 | |
| 153 | effectnames = {} |
| 154 | def geteffectname(effect): |
| 155 | """Get effect name from the new db""" |
| 156 | if effect in effectnames: |
| 157 | name = effectnames[effect] |
| 158 | else: |
| 159 | query = 'SELECT effectName FROM dgmeffects WHERE effectID = ?' |
| 160 | new_cursor.execute(query, (effect,)) |
| 161 | name = "" |
| 162 | for row in new_cursor: |
| 163 | name = row[0] |
| 164 | if not name: |
| 165 | old_cursor.execute(query, (effect,)) |
| 166 | for row in old_cursor: |
| 167 | name = row[0] |
| 168 | effectnames[effect] = name |
| 169 | return name |
| 170 | |
| 171 | attrnames = {} |
| 172 | def getattrname(attr): |