Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P242
Drop requests bulk
Active
Public
Actions
Authored by
stwalkerster
on Mar 14 2019, 11:40 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Tags
ACC
Subscribers
None
-- Tested on Oracle 11G XE
-- Produces a resultset of MySQL statements which can be run directly on ACC's database to drop the requests without notifications
-- This is hard-coded to be me (UID 7) performing the actions. The list of request IDs here should be obvious...
select
replace
(
sql
.
COLUMN_VALUE
,
'$$RID$$'
,
requests
.
COLUMN_VALUE
)
from
table
(
sys
.
odcinumberlist
(
257498
,
257950
,
259816
,
260058
,
260117
,
260275
,
260586
,
260596
,
260636
,
260638
,
260639
,
260718
,
260729
,
260748
,
260765
,
260822
,
260995
,
260997
,
261026
,
261031
,
261039
,
261069
,
261118
,
261135
,
261215
,
261262
,
261341
))
requests
cross
join
table
(
sys
.
odcivarchar2list
(
'INSERT INTO comment (time, user, comment, visibility, request) VALUES (current_timestamp(), 7, ''self-create'', ''user'', $$RID$$);'
,
'UPDATE request SET status = ''Closed'', reserved = 0 WHERE id = $$RID$$;'
,
'INSERT INTO log (objectid, objecttype, user, action, timestamp) VALUES ($$RID$$, ''Request'', 7, ''Closed 0'', current_timestamp());'
))
sql
;
Event Timeline
stwalkerster
created this paste.
Mar 14 2019, 11:40 PM
2019-03-14 23:40:51 (UTC+0)
stwalkerster
created this object with visibility "Public (No Login Required)".
stwalkerster
edited the content of this paste.
(Show Details)
Mar 14 2019, 11:43 PM
2019-03-14 23:43:44 (UTC+0)
Log In to Comment