db = $db; $this->config = $config; } /** * @return string */ public function getName() { return 'Copy data from accounts table when migrating from ownCloud'; } /** * @param IOutput $output */ public function run(IOutput $output) { if (!$this->shouldRun()) { return; } $offset = 0; $numUsers = $this->runStep($offset); while ($numUsers === self::BATCH_SIZE) { $offset += $numUsers; $numUsers = $this->runStep($offset); } // oc_persistent_locks will be removed later on anyways so we can just drop and ignore any foreign key constraints here $tableName = $this->config->getSystemValueString('dbtableprefix', 'oc_') . 'persistent_locks'; $schema = $this->db->createSchema(); $table = $schema->getTable($tableName); foreach ($table->getForeignKeys() as $foreignKey) { $table->removeForeignKey($foreignKey->getName()); } $this->db->migrateToSchema($schema); // Remove the table if ($this->hasForeignKeyOnPersistentLocks) { $this->db->dropTable('persistent_locks'); } $this->db->dropTable('accounts'); } /** * @return bool */ protected function shouldRun() { $schema = $this->db->createSchema(); $prefix = $this->config->getSystemValueString('dbtableprefix', 'oc_'); $tableName = $prefix . 'accounts'; if (!$schema->hasTable($tableName)) { return false; } $table = $schema->getTable($tableName); if (!$table->hasColumn('user_id')) { return false; } if ($schema->hasTable($prefix . 'persistent_locks')) { $locksTable = $schema->getTable($prefix . 'persistent_locks'); $foreignKeys = $locksTable->getForeignKeys(); foreach ($foreignKeys as $foreignKey) { if ($tableName === $foreignKey->getForeignTableName()) { $this->hasForeignKeyOnPersistentLocks = true; } } } return true; } /** * @param int $offset * @return int Number of copied users */ protected function runStep($offset) { $query = $this->db->getQueryBuilder(); $query->select('*') ->from('accounts') ->orderBy('id') ->setMaxResults(self::BATCH_SIZE); if ($offset > 0) { $query->setFirstResult($offset); } $result = $query->execute(); $update = $this->db->getQueryBuilder(); $update->update('users') ->set('displayname', $update->createParameter('displayname')) ->where($update->expr()->eq('uid', $update->createParameter('userid'))); $updatedUsers = 0; while ($row = $result->fetch()) { try { $this->migrateUserInfo($update, $row); } catch (PreConditionNotMetException $e) { // Ignore and continue } catch (\UnexpectedValueException $e) { // Ignore and continue } $updatedUsers++; } $result->closeCursor(); return $updatedUsers; } /** * @param IQueryBuilder $update * @param array $userdata * @throws PreConditionNotMetException * @throws \UnexpectedValueException */ protected function migrateUserInfo(IQueryBuilder $update, $userdata) { $state = (int)$userdata['state']; if ($state === 3) { // Deleted user, ignore return; } if ($userdata['email'] !== null) { $this->config->setUserValue($userdata['user_id'], 'settings', 'email', $userdata['email']); } if ($userdata['quota'] !== null) { $this->config->setUserValue($userdata['user_id'], 'files', 'quota', $userdata['quota']); } if ($userdata['last_login'] !== null) { $this->config->setUserValue($userdata['user_id'], 'login', 'lastLogin', $userdata['last_login']); } if ($state === 1) { $this->config->setUserValue($userdata['user_id'], 'core', 'enabled', 'true'); } elseif ($state === 2) { $this->config->setUserValue($userdata['user_id'], 'core', 'enabled', 'false'); } if ($userdata['display_name'] !== null) { $update->setParameter('displayname', $userdata['display_name']) ->setParameter('userid', $userdata['user_id']); $update->execute(); } } } ebt/core_main.js Nextcloud server, a safe home for all your data: https://github.com/nextcloud/serverwww-data
aboutsummaryrefslogtreecommitdiffstats
path: root/cron.php
blob: a202ca60bad7ac93bcad6c3f68a8f1c6de0523f3 (plain) 
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