Re: [UrbanSim-Users] writing specifications and coefficients to a baseyear database

Brian,

If I understand correctly, what you want to do, the easiest way is to
create two sql-based storage objects - one for loading (say
trapperkeeper_storage), the other one for storing (say
baseyear_storage). Then you can do:

coefficients = Coefficients()
coefficients.load(in_storage=trapperkeeper_storage,
        in_table_name='my_coefficients_table')
coefficients.write(out_storage=baseyear_storage,
        out_table_name="<MODEL_NAME>_coefficients")

(The same with specification)

To create the storage objects, you can use the MysqlStorage class below,
e.g.

trapperkeeper_storage = MysqlStorage().get('trapperkeeper_database')
baseyear_storage = MysqlStorage().get('baseyear_database')

I hope it helps.

Hana

from opus_core.storage_factory import StorageFactory
from opus_core.database_management.database_server import DatabaseServer
from opus_core.database_management.database_server_configuration import
DatabaseServerConfiguration

class MysqlStorage:
     def get(self, database):
         db_config = DatabaseServerConfiguration(
             host_name = os.environ['MYSQLHOSTNAME'],
             user_name = os.environ['MYSQLUSERNAME'],
             password = os.environ['MYSQLPASSWORD']

         )
         db_server = DatabaseServer(db_config)
         db = db_server.get_database(database)

         storage = StorageFactory().get_storage(
             'sql_storage',
             storage_location = db)
         return storage

Brian Miles wrote:
> Hello,
>
> I'm updating our estimation management tool <http://trondheim.cs.washington.edu/cgi-bin/trac.cgi/wiki/EstimationTrapperKeeper
> > to be able to write specifications and coefficients to the baseyear
> database.
>
> What I want to be able to do is to write arbitrary estimation results
> (stored in my trapperkeeper database) to the
> "<MODEL_NAME>_specification" and the "<MODEL_NAME>_coefficients" tables.
>
> Is there a relatively easy way to write to these tables through Opus's
> dataset/storage APIs?
>
> I've been looking at what's done in
> urbansim.estimation.Estimator::save_results and
> urbansim.models.LandPriceModel.Test and am thinking that I might be
> able to:
>
> 1. build dict_storage-based Storage object(s) to put the data in
>
> 2. get connection to the sql-based baseyear as a Storage object
>
> 3. Build opus_core.Coefficients and opus_core.EquationSpecification
> datasets using the data in dict_storage
>
> 4. Tell the Coefficients and EquationSpecification objects to write
> themselves to the baseyear storage
>
> Does this seem like "the right way" to do what I want to do? Are the
> Coefficients and EquationSpecification classes the right datasets to
> use?
>
> Any suggestions or pointers to relevant example code would be
> appreciated.
>
> Thanks,
>
> Brian
> _______________________________________________
> Users mailing list
> Users_at_urbansim.org
> http://www.urbansim.org/mailman/listinfo/users
Received on Wed Nov 14 2007 - 10:17:15 PST