XF2-PostComments/Setup.php at master · ThemeHouse-XF/XF2-PostComments · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?php

namespace ThemeHouse\PostComments;

use XF\AddOn\AbstractSetup;
use XF\AddOn\StepRunnerInstallTrait;
use XF\AddOn\StepRunnerUninstallTrait;
use XF\AddOn\StepRunnerUpgradeTrait;
use XF\Db\Schema\Alter;

/**
 * Class Setup
 * @package ThemeHouse\PostComments
 */
class Setup extends AbstractSetup
{
    use StepRunnerInstallTrait;
    use StepRunnerUpgradeTrait;
    use StepRunnerUninstallTrait;

    /**
     *
     */
    public function installStep1()
    {
        $schemaManager = $this->schemaManager();

        $schemaManager->alterTable('xf_post', function (Alter $table) {
            $table->addColumn('thpostcomments_parent_post_id', 'int')->setDefault(0);
            $table->addColumn('thpostcomments_root_post_id', 'int')->setDefault(0);
            $table->addColumn('thpostcomments_lft', 'int')->setDefault(0);
            $table->addColumn('thpostcomments_rgt', 'int')->setDefault(0);
            $table->addColumn('thpostcomments_depth', 'smallint', 5)->setDefault(0);
            $table->addKey('thpostcomments_parent_post_id');
            $table->addKey('thpostcomments_root_post_id');
            $table->addKey('thpostcomments_lft');
        });
    }

    /**
     *
     */
    public function installStep2()
    {
        $this->applyGlobalPermission('forum', 'thpostcomments_comment', 'forum', 'like');
    }

    /**
     *
     */
    public function installStep3()
    {
        $schemaManager = $this->schemaManager();
        $schemaManager->alterTable('xf_thread', function (Alter $table) {
            $table->addColumn('thpostcomments_root_reply_count', 'int')->setDefault(0);
        });

        \XF::app()->jobManager()->enqueue('ThemeHouse\PostComments:RebuildCounters');
    }

    /**
     *
     */
    public function upgrade1000231Step1()
    {
        $schemaManager = $this->schemaManager();
        $schemaManager->alterTable('xf_post', function (Alter $table) {
            $table->renameColumn('parent_post_id', 'thpostcomments_parent_post_id');
            $table->renameColumn('root_post_id', 'thpostcomments_root_post_id');
            $table->renameColumn('lft', 'thpostcomments_lft');
            $table->renameColumn('rgt', 'thpostcomments_rgt');
            $table->renameColumn('depth', 'thpostcomments_depth');
        });

        \XF::app()->jobManager()->enqueue('ThemeHouse\PostComments:RebuildCounters');
    }

    /**
     *
     */
    public function upgrade1000231Step2()
    {
        $schemaManager = $this->schemaManager();
        $schemaManager->alterTable('xf_thread', function (Alter $table) {
            $table->addColumn('thpostcomments_root_reply_count', 'int')->setDefault(0);
        });

        \XF::app()->jobManager()->enqueue('ThemeHouse\PostComments:RebuildCounters');
    }

    /**
     *
     */
    public function uninstallStep1()
    {
        $schemaManager = $this->schemaManager();

        $schemaManager->alterTable('xf_post', function (Alter $table) {
            $table->dropColumns([
                'thpostcomments_parent_post_id',
                'thpostcomments_root_post_id',
                'thpostcomments_lft',
                'thpostcomments_rgt',
                'thpostcomments_depth',
            ]);
        });
    }

    /**
     *
     */
    public function uninstallStep2()
    {
        $schemaManager = $this->schemaManager();

        $schemaManager->alterTable('xf_thread', function (Alter $table) {
            $table->dropColumns([
                'thpostcomments_root_reply_count',
            ]);
        });
    }
}