MarioVilas
sql code is broken
when importing the winappdbg.sql module I get an crash:
__all__ = ['CrashDAO']
import sqlite3
import datetime
import warnings
from sqlalchemy import create_engine, Column, ForeignKey, Sequence
from sqlalchemy.engine.url import URL
from sqlalchemy.ext.compiler import compiles
from sqlalchemy.ext.declarative import declarative_base
> from sqlalchemy.interfaces import PoolListener
E ImportError: No module named interfaces
I installed the winappdbg version from current head, running on python 2.7 and sqlalchemy is present (SQLAlchemy==1.4.13)
Looks like SQLAlchemy has changed their interface a bit: https://docs.sqlalchemy.org/en/13/core/interfaces.html#sqlalchemy.interfaces.PoolListener
For the time being I recommend installing an older version of SQLAlchemy until I port the code to the latest version.
Alright, a quick look at the code shows that PoolListener was used as a hack for detecting certain features of sqlite. So another option is to just remove the offending code, that is, the broken import, the definition of the _SQLitePatch class and the line where that class is used.
I have no idea if anything else is broken too, down the road. I wrote this back when SQLAlchemy was still below 1.0 so more features could be gone. :(
The PoolListener logic is roughly equivalent to the Event system now, as far as I see it. The code snippet from here should do the same thing like your _SQLitePatch class, for example.
As for CrashDAO / BaseDAO, I'm not sure. I think the mapper functionality would the similar to the logic, however I have never used it.
Another workaround for now would also be using an older version of SQLAlchemy.
pip install sqlalchemy==1.3.24
