Session recreated on tests that use pytest.parametrize

[joac]

As is reported on: pytest-dev/pytest#634
metafunc.parametrize overwrite scopes.
This produce a recreation of the entire session on tests that use parametrize.

This can be easily fixed using request.config.option.sql_url inside _sqlalchemy instead passing it as a fixture.

I'm working on a PR to fix this ASAP

This is my test case test_pytest.py:

from __future__ import print_function

import pytest

from pyramid_sqlalchemy import BaseObject
from sqlalchemy import Column, Integer


class Model(BaseObject):
    __tablename__ = 'models'
    id = Column(Integer, primary_key=True)


@pytest.mark.parametrize('n', xrange(3))
def test_standar_foo(n, sql_session):
    print('parameter foo', n)

and this is the result of running py.test test_pytest.py --sql-echo -s

============================= test session starts ==============================
platform linux2 -- Python 2.7.6, pytest-2.9.1, py-1.4.31, pluggy-0.3.1
rootdir: /home/joac/other_repos/pyramid_sqlalchemy, inifile: setup.cfg
plugins: pyramid-sqlalchemy-1.5
collected 3 items

test_pytest.py 2016-04-22 11:13:40,064 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2016-04-22 11:13:40,064 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,064 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2016-04-22 11:13:40,064 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,065 INFO sqlalchemy.engine.base.Engine PRAGMA foreign_keys = ON
2016-04-22 11:13:40,065 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,065 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("models")
2016-04-22 11:13:40,065 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,066 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE models (
    id INTEGER NOT NULL, 
    PRIMARY KEY (id)
)


2016-04-22 11:13:40,066 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,066 INFO sqlalchemy.engine.base.Engine COMMIT
parameter foo 0
.2016-04-22 11:13:40,068 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("models")
2016-04-22 11:13:40,068 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,068 INFO sqlalchemy.engine.base.Engine 
DROP TABLE models
2016-04-22 11:13:40,068 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,068 INFO sqlalchemy.engine.base.Engine COMMIT
2016-04-22 11:13:40,070 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2016-04-22 11:13:40,070 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,070 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2016-04-22 11:13:40,070 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,071 INFO sqlalchemy.engine.base.Engine PRAGMA foreign_keys = ON
2016-04-22 11:13:40,071 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,071 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("models")
2016-04-22 11:13:40,071 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,071 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE models (
    id INTEGER NOT NULL, 
    PRIMARY KEY (id)
)


2016-04-22 11:13:40,071 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,072 INFO sqlalchemy.engine.base.Engine COMMIT
parameter foo 1
.2016-04-22 11:13:40,073 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("models")
2016-04-22 11:13:40,073 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,074 INFO sqlalchemy.engine.base.Engine 
DROP TABLE models
2016-04-22 11:13:40,074 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,074 INFO sqlalchemy.engine.base.Engine COMMIT
2016-04-22 11:13:40,075 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine PRAGMA foreign_keys = ON
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("models")
2016-04-22 11:13:40,076 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,077 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE models (
    id INTEGER NOT NULL, 
    PRIMARY KEY (id)
)


2016-04-22 11:13:40,077 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,077 INFO sqlalchemy.engine.base.Engine COMMIT
parameter foo 2
.2016-04-22 11:13:40,078 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("models")
2016-04-22 11:13:40,078 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,078 INFO sqlalchemy.engine.base.Engine 
DROP TABLE models
2016-04-22 11:13:40,078 INFO sqlalchemy.engine.base.Engine ()
2016-04-22 11:13:40,078 INFO sqlalchemy.engine.base.Engine COMMIT


=========================== 3 passed in 0.03 seconds ===========================u

[joac]

@wichert here is my PR that fix this #6