bitten upgrade broken with 0.9.x-branch opt trunk from trac

[sven.reimers@…]

Trying to use bitten trunk leads to difficulties setting up new repository if used with sqlite or postgres.

Using 0.9.x branch -> Command failed: 'module' object has no attribute 'get_cnx_pool' with postgres (--no-backup) Using trunk -> Command failed: 'psycopg2._psycopg.connection' object has no attribute 'to_sql' (postgres)

-> Command failed: 'to_sql' (sqlite)

I got no clue what is going on, but it seems as if bitten is trying to use wrong object to call to_sql on (not the wrapper but the real connection)

[cmlenz]

This has already been fixed in [333] and [335].

[sven.reimers@…]

I have the latest from trac trunk and bitten trunk and tried the bitten 0.5.x branch as well - still getting the upper error messages

[sven.reimers@…]

I think i may have found what crashes:

   def environment_created(self):
        # Create the required tables
    print "Trying to create environment"
        db = self.env.get_db_cnx()
        cursor = db.cursor()
        for table in schema:
            for stmt in db.to_sql(table):
                cursor.execute(stmt)

The db.to_sql(table) seems to be broken

[sven.reimers@…]

Patch to fix db-upgrade problem

[sven.reimers@…]

Using the attached patch, I successfully upgraded a plain vanilla empty trac environment to use the bitten plugin (both trunk versions). Thx for your patience.

[cmlenz]

Doh, thanks! Patch applied in [336] and [337].