Windows binaries version of Python

[Cédric Mayer]

Hello all,
I'm developping over web2py source (1.99.7) using Eclipse, with Python (I used to use the version 2.7.2, but now because of my problem I use version 2.5.4 but...).
When I think my application is worth it, I zip its folder and I give it to someone else in order to test it. This person uses a compiled Web2py server for Windows (current version too) which uses embarked Python (2.5.x ?) binaries.

The issue I have is that I always have problems with the "exported" database.
With my old use of version 2.7 I had problems with the "ON DELETE CASCADE" directive.
My current problem with version 2.5.4 is the following one (when I try to log in) (I did not tamper with the definitions of auth tables, which are defined with auth.define_tables() ):

Traceback (most recent call last):
  File "gluon/restricted.py", line 205, in restricted
  File "C:/Users/cedric/projets/LACT/devWeb2py/lact_web2py/applications/lact/controllers/default.py", line 74, in <module>
  File "gluon/globals.py", line 173, in <lambda>
  File "C:/Users/cedric/projets/LACT/devWeb2py/lact_web2py/applications/lact/controllers/default.py", line 33, in user
  File "gluon/tools.py", line 1161, in __call__
  File "gluon/tools.py", line 1729, in login
  File "gluon/dal.py", line 7578, in select
  File "gluon/dal.py", line 1315, in select
  File "gluon/dal.py", line 1305, in response
  File "gluon/dal.py", line 1392, in execute
  File "gluon/dal.py", line 1386, in log_execute
OperationalError: no such column: auth_user.registration_id

So my questions are (at least one answer to any one would please me) :
1) what is the correct way to export a web2py application from a development environment to a Windows "production" environment, without deleting the entire database ?
2) what is the correct source execution environment compatible with compiled version ?
Thank you a lot,

Cédric

[Derek]

1. Use "Pack All". It creates a W2P file that you can send. The production site would use the "upload and install packed..."

2. I believe it's developed on 2.7.x - when it says it supports 2.5.x that means it is backwards compatible to that version. No idea what the binary version is - I prefer to use the source version, it's easier to update (as you might have witnessed yourself).

[Massimo Di Pierro]

It is possible that different python version use different sqlite formats. If you develop with 2.5 and pack and unpack to 2.7 the sqlite file will be readable. I do not know for sure about the opposite.

massimo