2011/10/31 Nathan Jones <nat...@ncjones.com>
> > ImportError: No module named migrate.versioning.api
>
> Have you installed sqlalchemy-migrate which is a new dependency added in
> 1.9.0.
>
I am sorry. I forgot this. Not I get a new error, when running pytrainer -d
[...]
INFO:root:Populating lap details from GPX for lap 195
INFO:migrate.versioning.api:done
INFO:migrate.versioning.api:11 -> 12...
INFO:migrate.versioning.api:done
INFO:migrate.versioning.api:12 -> 13...
INFO:migrate.versioning.api:done
INFO:migrate.versioning.api:13 -> 14...
DEBUG:root:Sport with id '1' has invalid weight: 'None'. Replacing with
default.
DEBUG:migrate.versioning.util:Disposing SQLAlchemy engine
Engine(sqlite:////home/guest/.pytrainer/pytrainer.ddbb)
Traceback (most recent call last):
File "/usr/local/bin/pytrainer", line 102, in <module>
main()
File "/usr/local/bin/pytrainer", line 99, in main
pytrainer = pyTrainer(None, data_path)
File "/usr/local/lib/python2.7/dist-packages/pytrainer/main.py", line 79,
in __init__
initialize_data(self.ddbb, self.environment.conf_dir)
File "/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/data.py",
line 31, in initialize_data
InstalledData(migratable_db, ddbb, LegacyVersionProvider(conf_dir),
UpgradeContext(conf_dir)).update_to_current()
File "/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/data.py",
line 65, in update_to_current
data_state.update_to_current(self)
File "/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/data.py",
line 170, in update_to_current
self._update_function(installed_data)
File "/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/data.py",
line 181, in _update_legacy
data.upgrade()
File "/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/data.py",
line 147, in upgrade
self._migratable_db.upgrade()
File
"/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/migratedb.py",
line 82, in upgrade
upgrade(self._db_url, self._repository_path)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line
186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<string>", line 2, in _migrate
File
"/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py",
line 159, in with_engine
return f(*a, **kw)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line
365, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py",
line 91, in runchange
change.run(self.engine, step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py",
line 145, in run
script_func(engine)
File
"/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/versions/014_clean_sport_data.py",
line 4, in upgrade
version14.upgrade(migrate_engine)
File
"/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/versions/version014.py",
line 90, in upgrade
_SportNormalizer(id, weight, color, met,
max_pace).normalize(migrate_engine)
File
"/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/versions/version014.py",
line 35, in normalize
self._normalize_weight(migrate_engine)
File
"/usr/local/lib/python2.7/dist-packages/pytrainer/upgrade/versions/version014.py",
line 50, in _normalize_weight
migrate_engine.execute(text("update sports set weight=:weight where
id_sports=:id"), id=self._id, weight=0.0)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
2291, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1399, in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1532, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1675, in _execute_context
self._commit_impl()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1230, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1227, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 306, in do_commit
connection.commit()
sqlalchemy.exc.OperationalError: (OperationalError) database is locked None
None
>From log.out:
2011-10-31
13:27:59,305|INFO|011_populate_lap_details|populate_lap_from_gpx|Populating
lap details from GPX for lap 195
2011-10-31 13:27:59,312|INFO|api|_migrate|done
2011-10-31 13:27:59,313|INFO|api|_migrate|11 -> 12...
2011-10-31 13:27:59,320|INFO|api|_migrate|done
2011-10-31 13:27:59,321|INFO|api|_migrate|12 -> 13...
2011-10-31 13:27:59,327|INFO|api|_migrate|done
2011-10-31 13:27:59,327|INFO|api|_migrate|13 -> 14...
2011-10-31 13:27:59,330|DEBUG|version014|_normalize_weight|Sport with id
'1' has invalid weight: 'None'. Replacing with default.
2011-10-31 13:28:04,339|DEBUG|__init__|with_engine|Disposing SQLAlchemy
engine Engine(sqlite:////home/user/.pytrainer/pytrainer.ddbb)
BTW: Is it save just to copy ~/.pytrainer into another users directory?
With (z)grep I did not found any reference to the absolute path, expect in
the log.
------------------------------------------------------------------------------
Get your Android app more play: Bring it to the BlackBerry PlayBook
in minutes. BlackBerry App World™ now supports Android™ Apps
for the BlackBerry® PlayBook™. Discover just how easy and simple
it is! http://p.sf.net/sfu/android-dev2dev
_______________________________________________
Pytrainer-devel mailing list
Pytrainer-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pytrainer-devel
