Re: Eugene tests - scenario_information?

Fabrice

The role of scenario_information is basically to provide a pointer from
one database to its 'parent' database, providing a means to create
scenario databases that mostly use the contents of a baseyear database,
but over-ride, or 'shadow' any tables that are contained in the base
year database with the tables in the scenario database. Not sure if
this is covered clearly enough in the documentation. It is quite
convenient for creating databases that share most tables, but have one
or more that differ. For example you might create a baseline scenario
as the default scenario, and then create variations on this scenario by
creating additional databases that use the baseline scenario database as
the parent database, but change one or two tables.

Paul

Fabrice Marchal wrote:
> Hi again,
>
> I forgot to mention: in order to have the green-light for Eugene all_tests
> we had to create a database named "Eugene_1980_baseyear_opus_estimation"
> as specified by default in the eugene.configs.
>
> However, it seems to require a table which is not created by default
> named "scenario_information" . Is this a mandatory table? What is its
> role exactly? I had the feeling it was only needed in some cases so I
> modified "opus_core/store/scenario_database.py" accordingly:
>
> def _create_table_mapping(self, database_name):
> .....
> ....
> sql = "SELECT PARENT_DATABASE_URL FROM
> scenario_information;"
> _log_sql(sql, self.show_output)
> cursor.execute(sql)
> rows = cursor.fetchall()
> if( not rows): ## <-- hack
> return ## <-- hack
> if (not rows[0][0]) or (len(rows[0][0]) < 1) :
>
>
> Can someone shed light on this problem?
>
> Fabrice
>
>
>
> =====================================================
> Fabrice Marchal
> fabrice.marchal_at_let.ish-lyon.cnrs.fr
> <mailto:fabrice.marchal_at_let.ish-lyon.cnrs.fr>
> Associate researcher +33 472 72 79 44 fabrice.marchal_at_ieee.org
> <mailto:fabrice.marchal_at_ieee.org>
> CNRS - Lab of Transport Economics (LET), Lyon http://marchal.let.fr
> =====================================================
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users_at_urbansim.org
> http://www.urbansim.org/mailman/listinfo/users
>
Received on Sat Jul 07 2007 - 23:21:07 PDT