impact of deploying w2p file

[Vic Ding]

Dear all,

I am wondering if there is any impact on database transactions or database content when deploying w2p file. Does the package only contain code or in some way some data as well?

The database folder contains some kind of transaction logs, this folder and all its contents will be over written by the new deployment. What does this mean for the existing data?

Will this cause any data revert? 

Cheers,

Vic

[Massimo Di Pierro]

the w2p may contain a sqlite database and databases/*.table metadata files.
you normally use those for install, not for updates.

[Dave S]

On Saturday, May 5, 2018 at 8:00:45 PM UTC-7, Massimo Di Pierro wrote:

the w2p may contain a sqlite database and databases/*.table metadata files.
you normally use those for install, not for updates.

Also, if you are creating the w2p file, you can choose "custom" and then select the files to be included.

/dps
 

[Vic]

Dear both, many thanks! Will the *.table files have impact/effect on the actual db content on the target server? Or will the w2p file alter the database on the target server in any way? And what is the purpose of the included sqlite file?

I use w2p file to patch the production server from dev server. 

Cheers,

Vic

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/y3E_7lv2iPc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dave S]

On Monday, May 7, 2018 at 12:04:44 PM UTC-7, Vic Ding wrote:

Dear both, many thanks! Will the *.table files have impact/effect on the actual db content on the target server? Or will the w2p file alter the database on the target server in any way? And what is the purpose of the included sqlite file?

I use w2p file to patch the production server from dev server. 

The *.table files aren't content, they are interface ... they describe to web2p the layout of the tables in the database, reflecting the choice of database engine.  They provide a translation of your model files into DB schema.

The file storage.sqlite file is used as the database itself if you are using sqlite3 as your database engine.

In general, none of the files in the database subdirectory are needed in an update of an existing application.  If your model files change, it is usually better to do a migration than to copy the table files.

If you are doing an update, you only need to include the changed files into your w2p file ... most often, these will be controllers, views, models, or modules.

/dps

 

On Mon, May 7, 2018 at 9:01 PM, Dave S <snide...@gmail.com> wrote:

On Saturday, May 5, 2018 at 8:00:45 PM UTC-7, Massimo Di Pierro wrote:

the w2p may contain a sqlite database and databases/*.table metadata files.
you normally use those for install, not for updates.

Also, if you are creating the w2p file, you can choose "custom" and then select the files to be included.

/dps
 

On Saturday, 28 April 2018 03:49:49 UTC-5, Vic Ding wrote:

Dear all,

I am wondering if there is any impact on database transactions or database content when deploying w2p file. Does the package only contain code or in some way some data as well?

The database folder contains some kind of transaction logs, this folder and all its contents will be over written by the new deployment. What does this mean for the existing data?

Will this cause any data revert? 

Cheers,

Vic

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/y3E_7lv2iPc/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

[Vic]

Thank you very much for the detailed explanation . 

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.