差別
這里會顯示出您選擇的修訂版和當前版本之間的差別。
| 兩側同時換到之前的修訂記錄 前一修訂版 后一修訂版 | 前一修訂版 | ||
|
en:razor:upgrade-instruction-v0-6-to-v0-7 [2015/09/15 10:05] cobub |
en:razor:upgrade-instruction-v0-6-to-v0-7 [2017/07/14 11:18] (當前版本) |
||
|---|---|---|---|
| 行 2: | 行 2: | ||
| {{description>Cobub Razor is an Open Source Mobile Analytics. When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required:.}} | {{description>Cobub Razor is an Open Source Mobile Analytics. When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required:.}} | ||
| {{keywords>Cobub Razor,open source mobile analytics,mobile analytics,mobile app analytics, upgrade}} | {{keywords>Cobub Razor,open source mobile analytics,mobile analytics,mobile app analytics, upgrade}} | ||
| - | v0.7.1 | + | ? |
| ====== Upgrade Instruction (v0.6 to v0.7) ====== | ====== Upgrade Instruction (v0.6 to v0.7) ====== | ||
| When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required: | When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required: | ||
| 行 8: | 行 9: | ||
| 1、Download the code of version 0.7 from https://github.com/cobub/razor , and you can get the razor-master.zip, unzip it to get razor-master folder, which contains the sdk and web folders. | 1、Download the code of version 0.7 from https://github.com/cobub/razor , and you can get the razor-master.zip, unzip it to get razor-master folder, which contains the sdk and web folders. | ||
| - | 2、Copy the **web** folder to the directory of your web site where you are ready to upgrade Cobub Razor (Note: web can not be the same name with Cobub Razor’s name of V0.6 or V0.7 ). To facilitate debugging, you can rename ”web” to “razor_v6“, and set the $ config ['base_url'] value to the ‘http://192.168.1.103/razor_v6 ‘ in **config.php** which is under the **application** folder. | + | 2、Copy the **web** folder to the directory of your web site where you are ready to upgrade Cobub Razor (Note: web can not be the same name with Cobub Razor’s name of V0.6 or V0.7 ). To facilitate debugging, you can rename ”web” to “razor_v6“, and set the $ config ['base_url'] value to the ‘http://yoururl/razor_v6 ‘ in **config.php** which is under the **application** folder. |
| 3、Copy the **autoload.php** and **database.php** of V0.6 under the directory of **application\config\** to the diretory of **application\config\** of V0.7, override these two files of V0.7, and replace $route['default_controller'] = “install/installation” to $route['default_controller'] = “report/home” of V0.7 in **routes.php**. | 3、Copy the **autoload.php** and **database.php** of V0.6 under the directory of **application\config\** to the diretory of **application\config\** of V0.7, override these two files of V0.7, and replace $route['default_controller'] = “install/installation” to $route['default_controller'] = “report/home” of V0.7 in **routes.php**. | ||
| 行 1138: | 行 1139: | ||
| ('72417', 'Ceterp Cel Brazil', '724', 'BR'); | ('72417', 'Ceterp Cel Brazil', '724', 'BR'); | ||
| </code> | </code> | ||
| + | ==== 3、Modify the stored procedures ==== | ||
| + | |||
| + | |||
| + | Stored procedures: **rundaily** 、 **rundim** 、 **runfact** 、 **runmonthly** 、 **runsum** and **runweekly** 。 | ||
| + | |||
| + | Steps: | ||
| + | |||
| + | 1)you will get six sql script files under the directory of **assets\sql** of V0.7 : **sp_rundaily.sql** 、 **sp_rundim.sql** 、 **sp_runfact.sql** 、 **sp_runmonthly.sql** 、 **sp_runsum.sql** | ||
| + | and **sp_runweekly.sql**. | ||
| + | |||
| + | 2) modify table prefix | ||
| + | |||
| + | Modify the **umsinstall_** in all sql scirpt files above to your own data warehouse’s table prefix, for example,your data warehouse table prefix “razordw_”; | ||
| + | |||
| + | Replace the “databaseprefix.umsdatainstall_” to “database.database’s table prefix”, for example, your database is cobubrazor,and database’s table prefix is razor_,the ”databaseprefix.umsdatainstall_” should be “cobubrazor.razor_“. | ||
| + | ===== Step three: stop inserting data to database and pause the stored procedures. ===== | ||
| + | |||
| + | |||
| + | |||
| + | Note: you need to have prepared all the relevant SQL scripts(i.e. all sql scripts in Step two). | ||
| + | |||
| + | |||
| + | ===== Step four: delete all stored procedures in data warehouse. ===== | ||
| + | |||
| + | |||
| + | |||
| + | ===== Step five: execute the SQL scripts generated in Step two. ===== | ||
| + | |||
| + | |||
| + | Note: Please backup the data of your database and data warehouse before you execute the sql scripts. | ||
| + | |||
| + | |||
| + | ===== Step six:restart the database and data warehouse. ===== | ||
| + | |||
| + | |||
| + | Before this step, you need to do the last thing : | ||
| + | |||
| + | Backup the directory of the previous web site(e.g **web**,which is the root directory of version 0.6),store it in a suitable place and named web-backup0.6, then delete **web**. | ||
| + | |||
| + | Change”razor_v6” to “web”(the name of V0.6),and set $config['base_url']= ‘http://yoururl/web’ in **config.php**. | ||
en/razor/upgrade-instruction-v0-6-to-v0-7.1442282743.txt.gz · 最后更改: 2017/07/14 11:12 (外部編輯)