diff options
author | Stefan Giehl <stefan@matomo.org> | 2020-04-15 12:55:36 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2020-04-15 12:55:36 +0300 |
commit | c4eca98199cdf18a4cd969c5495be58a0c348b92 (patch) | |
tree | c07d130f0f82bf430e9efb59d156a277ec89bbe0 /plugins/CoreConsole | |
parent | 5c7f8498d0e8a4f55ff1a4bd7aab3a3be20a8c31 (diff) |
Rename interaction_position to pageview_position (#15812)
* rename db column interaction_position to pageview_position
* allow storing bigger int values in position fields
* updates tests & expected files
* adds changelog
* Update plugins/Actions/Columns/VisitTotalInteractions.php
* update submodules
Diffstat (limited to 'plugins/CoreConsole')
4 files changed, 64 insertions, 64 deletions
diff --git a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_day.xml b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_day.xml index c336d953d6..ec02c9517a 100644 --- a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_day.xml +++ b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_day.xml @@ -16,7 +16,7 @@ <pageId>9</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-users/</subtitle> <icon /> @@ -144,7 +144,7 @@ <pageId>8</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/</subtitle> <icon /> @@ -272,7 +272,7 @@ <pageId>7</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/translations/</subtitle> <icon /> @@ -400,7 +400,7 @@ <pageId>6</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/download/counter/</subtitle> <icon /> @@ -528,7 +528,7 @@ <pageId>5</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/</subtitle> <icon /> @@ -656,7 +656,7 @@ <pageId>4</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-websites/</subtitle> <icon /> @@ -784,7 +784,7 @@ <pageId>3</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/community/</subtitle> <icon /> @@ -912,7 +912,7 @@ <pageId>2</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -1040,7 +1040,7 @@ <pageId>81</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://www.included4.com/blog/category/meta/</subtitle> <icon /> @@ -1168,7 +1168,7 @@ <pageId>83</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://www.included2.com/blog/category/meta/</subtitle> <icon /> diff --git a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_year.xml b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_year.xml index db3d976568..e85940c668 100644 --- a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_year.xml +++ b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment0_noOptions__Live.getLastVisitsDetails_year.xml @@ -20,7 +20,7 @@ <timeSpentPretty>0s</timeSpentPretty> <generationTimeMilliseconds>123</generationTimeMilliseconds> <generationTime>0.12s</generationTime> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -62,7 +62,7 @@ <timeSpentPretty>0s</timeSpentPretty> <generationTimeMilliseconds>120</generationTimeMilliseconds> <generationTime>0.12s</generationTime> - <interactionPosition>5</interactionPosition> + <pageviewPosition>5</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -89,7 +89,7 @@ <timeSpentPretty>52s</timeSpentPretty> <generationTimeMilliseconds>23</generationTimeMilliseconds> <generationTime>0.02s</generationTime> - <interactionPosition>9</interactionPosition> + <pageviewPosition>9</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -116,7 +116,7 @@ <timeSpentPretty>50s</timeSpentPretty> <generationTimeMilliseconds>234</generationTimeMilliseconds> <generationTime>0.23s</generationTime> - <interactionPosition>2</interactionPosition> + <pageviewPosition>2</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -143,7 +143,7 @@ <timeSpentPretty>49s</timeSpentPretty> <generationTimeMilliseconds>294</generationTimeMilliseconds> <generationTime>0.29s</generationTime> - <interactionPosition>6</interactionPosition> + <pageviewPosition>6</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -170,7 +170,7 @@ <timeSpentPretty>26s</timeSpentPretty> <generationTimeMilliseconds>237</generationTimeMilliseconds> <generationTime>0.24s</generationTime> - <interactionPosition>10</interactionPosition> + <pageviewPosition>10</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -197,7 +197,7 @@ <timeSpentPretty>26s</timeSpentPretty> <generationTimeMilliseconds>1324</generationTimeMilliseconds> <generationTime>1.32s</generationTime> - <interactionPosition>3</interactionPosition> + <pageviewPosition>3</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/community/</subtitle> <icon /> @@ -224,7 +224,7 @@ <timeSpentPretty>7s</timeSpentPretty> <generationTimeMilliseconds>624</generationTimeMilliseconds> <generationTime>0.62s</generationTime> - <interactionPosition>7</interactionPosition> + <pageviewPosition>7</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/community/</subtitle> <icon /> @@ -251,7 +251,7 @@ <timeSpentPretty>8s</timeSpentPretty> <generationTimeMilliseconds>543</generationTimeMilliseconds> <generationTime>0.54s</generationTime> - <interactionPosition>4</interactionPosition> + <pageviewPosition>4</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-websites/</subtitle> <icon /> @@ -276,7 +276,7 @@ <bandwidth /> <generationTimeMilliseconds>343</generationTimeMilliseconds> <generationTime>0.34s</generationTime> - <interactionPosition>8</interactionPosition> + <pageviewPosition>8</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-websites/</subtitle> <icon /> @@ -389,7 +389,7 @@ <pageId>84</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://www.notdatefiltered.com/blog/category/meta/</subtitle> <icon /> @@ -517,7 +517,7 @@ <pageId>30</pageId> <bandwidth>43</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>incredible title!</title> <subtitle>http://example.org/index.htm</subtitle> <icon /> @@ -670,7 +670,7 @@ <pageId>31</pageId> <bandwidth>43</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>Piwik Forums</title> <subtitle>http://forum.piwik.org/register.php?0,approve=9a94a02145599</subtitle> <icon /> @@ -831,7 +831,7 @@ <pageId>28</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -963,7 +963,7 @@ <pageId>29</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -1097,7 +1097,7 @@ <bandwidth>3574</bandwidth> <timeSpent>180</timeSpent> <timeSpentPretty>3 min 0s</timeSpentPretty> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>301/URL = http%3A%2F%2Fpiwik.net%2Fmoved-permanently</title> <subtitle>http://piwik.net/moved-permanently</subtitle> <icon /> @@ -1135,7 +1135,7 @@ <pageId>27</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>2</interactionPosition> + <pageviewPosition>2</pageviewPosition> <title>307/URL = http%3A%2F%2Fpiwik.net%2Ftemp-redirect</title> <subtitle>http://piwik.net/temp-redirect</subtitle> <icon /> @@ -1254,7 +1254,7 @@ <bandwidth>3574</bandwidth> <timeSpent>61</timeSpent> <timeSpentPretty>1 min 1s</timeSpentPretty> - <interactionPosition /> + <pageviewPosition /> <icon>plugins/Morpheus/images/download.png</icon> <iconSVG>plugins/Morpheus/images/download.svg</iconSVG> <title>Download</title> @@ -1279,7 +1279,7 @@ <bandwidth>3574</bandwidth> <timeSpent>61</timeSpent> <timeSpentPretty>1 min 1s</timeSpentPretty> - <interactionPosition /> + <pageviewPosition /> <icon>plugins/Morpheus/images/download.png</icon> <iconSVG>plugins/Morpheus/images/download.svg</iconSVG> <title>Download</title> @@ -1302,7 +1302,7 @@ <pageId>25</pageId> <bandwidth>3574</bandwidth> - <interactionPosition /> + <pageviewPosition /> <icon>plugins/Morpheus/images/download.png</icon> <iconSVG>plugins/Morpheus/images/download.svg</iconSVG> <title>Download</title> @@ -1419,7 +1419,7 @@ <pageId>22</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/</subtitle> <icon /> @@ -1551,7 +1551,7 @@ <pageId>21</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>500/URL = http%3A%2F%2Fpiwik.net%2Fto-an-error</title> <subtitle>http://piwik.net/to-an-error</subtitle> <icon /> diff --git a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_day.xml b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_day.xml index c336d953d6..ec02c9517a 100644 --- a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_day.xml +++ b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_day.xml @@ -16,7 +16,7 @@ <pageId>9</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-users/</subtitle> <icon /> @@ -144,7 +144,7 @@ <pageId>8</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/</subtitle> <icon /> @@ -272,7 +272,7 @@ <pageId>7</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/translations/</subtitle> <icon /> @@ -400,7 +400,7 @@ <pageId>6</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/download/counter/</subtitle> <icon /> @@ -528,7 +528,7 @@ <pageId>5</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/</subtitle> <icon /> @@ -656,7 +656,7 @@ <pageId>4</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-websites/</subtitle> <icon /> @@ -784,7 +784,7 @@ <pageId>3</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/community/</subtitle> <icon /> @@ -912,7 +912,7 @@ <pageId>2</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -1040,7 +1040,7 @@ <pageId>81</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://www.included4.com/blog/category/meta/</subtitle> <icon /> @@ -1168,7 +1168,7 @@ <pageId>83</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://www.included2.com/blog/category/meta/</subtitle> <icon /> diff --git a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_year.xml b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_year.xml index db3d976568..e85940c668 100644 --- a/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_year.xml +++ b/plugins/CoreConsole/tests/System/expected/test_ArchiveCronTest_preArchivedSegment1_noOptions__Live.getLastVisitsDetails_year.xml @@ -20,7 +20,7 @@ <timeSpentPretty>0s</timeSpentPretty> <generationTimeMilliseconds>123</generationTimeMilliseconds> <generationTime>0.12s</generationTime> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -62,7 +62,7 @@ <timeSpentPretty>0s</timeSpentPretty> <generationTimeMilliseconds>120</generationTimeMilliseconds> <generationTime>0.12s</generationTime> - <interactionPosition>5</interactionPosition> + <pageviewPosition>5</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -89,7 +89,7 @@ <timeSpentPretty>52s</timeSpentPretty> <generationTimeMilliseconds>23</generationTimeMilliseconds> <generationTime>0.02s</generationTime> - <interactionPosition>9</interactionPosition> + <pageviewPosition>9</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -116,7 +116,7 @@ <timeSpentPretty>50s</timeSpentPretty> <generationTimeMilliseconds>234</generationTimeMilliseconds> <generationTime>0.23s</generationTime> - <interactionPosition>2</interactionPosition> + <pageviewPosition>2</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -143,7 +143,7 @@ <timeSpentPretty>49s</timeSpentPretty> <generationTimeMilliseconds>294</generationTimeMilliseconds> <generationTime>0.29s</generationTime> - <interactionPosition>6</interactionPosition> + <pageviewPosition>6</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -170,7 +170,7 @@ <timeSpentPretty>26s</timeSpentPretty> <generationTimeMilliseconds>237</generationTimeMilliseconds> <generationTime>0.24s</generationTime> - <interactionPosition>10</interactionPosition> + <pageviewPosition>10</pageviewPosition> <title /> <subtitle>http://piwik.net/faq/</subtitle> <icon /> @@ -197,7 +197,7 @@ <timeSpentPretty>26s</timeSpentPretty> <generationTimeMilliseconds>1324</generationTimeMilliseconds> <generationTime>1.32s</generationTime> - <interactionPosition>3</interactionPosition> + <pageviewPosition>3</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/community/</subtitle> <icon /> @@ -224,7 +224,7 @@ <timeSpentPretty>7s</timeSpentPretty> <generationTimeMilliseconds>624</generationTimeMilliseconds> <generationTime>0.62s</generationTime> - <interactionPosition>7</interactionPosition> + <pageviewPosition>7</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/community/</subtitle> <icon /> @@ -251,7 +251,7 @@ <timeSpentPretty>8s</timeSpentPretty> <generationTimeMilliseconds>543</generationTimeMilliseconds> <generationTime>0.54s</generationTime> - <interactionPosition>4</interactionPosition> + <pageviewPosition>4</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-websites/</subtitle> <icon /> @@ -276,7 +276,7 @@ <bandwidth /> <generationTimeMilliseconds>343</generationTimeMilliseconds> <generationTime>0.34s</generationTime> - <interactionPosition>8</interactionPosition> + <pageviewPosition>8</pageviewPosition> <title /> <subtitle>http://piwik.net/docs/manage-websites/</subtitle> <icon /> @@ -389,7 +389,7 @@ <pageId>84</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://www.notdatefiltered.com/blog/category/meta/</subtitle> <icon /> @@ -517,7 +517,7 @@ <pageId>30</pageId> <bandwidth>43</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>incredible title!</title> <subtitle>http://example.org/index.htm</subtitle> <icon /> @@ -670,7 +670,7 @@ <pageId>31</pageId> <bandwidth>43</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>Piwik Forums</title> <subtitle>http://forum.piwik.org/register.php?0,approve=9a94a02145599</subtitle> <icon /> @@ -831,7 +831,7 @@ <pageId>28</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -963,7 +963,7 @@ <pageId>29</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/blog/category/meta/</subtitle> <icon /> @@ -1097,7 +1097,7 @@ <bandwidth>3574</bandwidth> <timeSpent>180</timeSpent> <timeSpentPretty>3 min 0s</timeSpentPretty> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>301/URL = http%3A%2F%2Fpiwik.net%2Fmoved-permanently</title> <subtitle>http://piwik.net/moved-permanently</subtitle> <icon /> @@ -1135,7 +1135,7 @@ <pageId>27</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>2</interactionPosition> + <pageviewPosition>2</pageviewPosition> <title>307/URL = http%3A%2F%2Fpiwik.net%2Ftemp-redirect</title> <subtitle>http://piwik.net/temp-redirect</subtitle> <icon /> @@ -1254,7 +1254,7 @@ <bandwidth>3574</bandwidth> <timeSpent>61</timeSpent> <timeSpentPretty>1 min 1s</timeSpentPretty> - <interactionPosition /> + <pageviewPosition /> <icon>plugins/Morpheus/images/download.png</icon> <iconSVG>plugins/Morpheus/images/download.svg</iconSVG> <title>Download</title> @@ -1279,7 +1279,7 @@ <bandwidth>3574</bandwidth> <timeSpent>61</timeSpent> <timeSpentPretty>1 min 1s</timeSpentPretty> - <interactionPosition /> + <pageviewPosition /> <icon>plugins/Morpheus/images/download.png</icon> <iconSVG>plugins/Morpheus/images/download.svg</iconSVG> <title>Download</title> @@ -1302,7 +1302,7 @@ <pageId>25</pageId> <bandwidth>3574</bandwidth> - <interactionPosition /> + <pageviewPosition /> <icon>plugins/Morpheus/images/download.png</icon> <iconSVG>plugins/Morpheus/images/download.svg</iconSVG> <title>Download</title> @@ -1419,7 +1419,7 @@ <pageId>22</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title /> <subtitle>http://piwik.net/</subtitle> <icon /> @@ -1551,7 +1551,7 @@ <pageId>21</pageId> <bandwidth>3574</bandwidth> - <interactionPosition>1</interactionPosition> + <pageviewPosition>1</pageviewPosition> <title>500/URL = http%3A%2F%2Fpiwik.net%2Fto-an-error</title> <subtitle>http://piwik.net/to-an-error</subtitle> <icon /> |