Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F96196612
20140321.mstatus.2.mig.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Mon, Dec 23, 16:28
Size
2 KB
Mime Type
text/x-php
Expires
Wed, Dec 25, 16:28 (2 d)
Engine
blob
Format
Raw Data
Handle
23141291
Attached To
rPH Phabricator
20140321.mstatus.2.mig.php
View Options
<?php
$status_map
=
array
(
0
=>
'open'
,
1
=>
'resolved'
,
2
=>
'wontfix'
,
3
=>
'invalid'
,
4
=>
'duplicate'
,
5
=>
'spite'
,
);
$conn_w
=
id
(
new
ManiphestTask
())->
establishConnection
(
'w'
);
echo
pht
(
'Migrating tasks to new status constants...'
).
"
\n
"
;
foreach
(
new
LiskMigrationIterator
(
new
ManiphestTask
())
as
$task
)
{
$id
=
$task
->
getID
();
echo
pht
(
'Migrating %s...'
,
"T{$id}"
).
"
\n
"
;
$status
=
$task
->
getStatus
();
if
(
isset
(
$status_map
[
$status
]))
{
queryfx
(
$conn_w
,
'UPDATE %T SET status = %s WHERE id = %d'
,
$task
->
getTableName
(),
$status_map
[
$status
],
$id
);
}
}
echo
pht
(
'Done.'
).
"
\n
"
;
echo
pht
(
'Migrating task transactions to new status constants...'
).
"
\n
"
;
foreach
(
new
LiskMigrationIterator
(
new
ManiphestTransaction
())
as
$xaction
)
{
$id
=
$xaction
->
getID
();
echo
pht
(
'Migrating %d...'
,
$id
).
"
\n
"
;
if
(
$xaction
->
getTransactionType
()
==
ManiphestTransaction
::
TYPE_STATUS
)
{
$old
=
$xaction
->
getOldValue
();
if
(
$old
!==
null
&&
isset
(
$status_map
[
$old
]))
{
$old
=
$status_map
[
$old
];
}
$new
=
$xaction
->
getNewValue
();
if
(
isset
(
$status_map
[
$new
]))
{
$new
=
$status_map
[
$new
];
}
queryfx
(
$conn_w
,
'UPDATE %T SET oldValue = %s, newValue = %s WHERE id = %d'
,
$xaction
->
getTableName
(),
json_encode
(
$old
),
json_encode
(
$new
),
$id
);
}
}
echo
pht
(
'Done.'
).
"
\n
"
;
$conn_w
=
id
(
new
PhabricatorSavedQuery
())->
establishConnection
(
'w'
);
echo
pht
(
'Migrating searches to new status constants...'
).
"
\n
"
;
foreach
(
new
LiskMigrationIterator
(
new
PhabricatorSavedQuery
())
as
$query
)
{
$id
=
$query
->
getID
();
echo
pht
(
'Migrating %d...'
,
$id
).
"
\n
"
;
if
(
$query
->
getEngineClassName
()
!==
'ManiphestTaskSearchEngine'
)
{
continue
;
}
$params
=
$query
->
getParameters
();
$statuses
=
idx
(
$params
,
'statuses'
,
array
());
if
(
$statuses
)
{
$changed
=
false
;
foreach
(
$statuses
as
$key
=>
$status
)
{
if
(
isset
(
$status_map
[
$status
]))
{
$statuses
[
$key
]
=
$status_map
[
$status
];
$changed
=
true
;
}
}
if
(
$changed
)
{
$params
[
'statuses'
]
=
$statuses
;
queryfx
(
$conn_w
,
'UPDATE %T SET parameters = %s WHERE id = %d'
,
$query
->
getTableName
(),
json_encode
(
$params
),
$id
);
}
}
}
echo
pht
(
'Done.'
).
"
\n
"
;
Event Timeline
Log In to Comment