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 <[email protected] <javascript:>> > 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 >> [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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 the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
