Redeposit some items

[jcoyne]

Now that #2368 is complete, we want to re-deposit all "Deposited" items that are not locked
and have a WorkVersion updated_at in the range of "Aug 1st, 2021 - until Aug 23rd, 2022"
also exclude these 202 items that have gotten catkeys (https://docs.google.com/spreadsheets/d/1Hpp29zeivIsiyXz5C3627fCCpo8GzK_2I6B8zLwsqaA/edit#gid=0)

We want these to be redeposited (with a new version, and re-accessioned), however we don't want emails to go out to the owners. This will ensure deposit dates are added to the purl record if they didn't explicitly supply one.

distilled from (#2370)

[jcoyne]

@amyehodge what is the version message that we want to use here?

[jcoyne]

@amyehodge there are 1017 works meeting these criteria:

exclude_set = %w[bj405nv5607
bm142zd2566
bq914bx7183
bs745hk3945
bv776pv8667
bz820zw2118
cc356pb3124
cg218nh3682
cm933kg7492
cn826ff0507
cp197fg5433
cp265ts9980
cr602gp1097
cs299gc2112
cy831hg9983
db711bd5524
dc693bm0837
dh698ds7642
dm184rq4610
dn188wb1696
dn921yp9305
dw941xn0521
dx768cb2586
dy801jb2539
fg169wp2836
fs147hb1302
fx087bx0270
gc101vv2215
gh408xz2065
gn527ff6311
gp063xk8495
gy941bz9342
gz384vg0121
hc021kh0359
hd662bs5719
hf609nr9241
hj765yd7960
hq928sz7861
hs321ng8910
hs449wf5142
jb272br5541
jd561pd8635
jg169kn8622
jk481zy8493
jq101qk2856
js509th0922
jx706bt9320
kb791hg3946
kf897rp9357
kh647wk8004
kh768wj1579
km285nt7603
kn347cn9302
ks372jx7320
kv635vf9856
kz952nt2214
mc977rd5510
md176dk1200
md475vq0525
mg587gh9026
mg802ht2044
mr290xz8156
mv522rq4275
mw298xr2903
mw683dc6567
mx695bx5424
mx713cs8907
nd579yq0116
np144th7072
nq641ck8400
nr367ch0696
nr635hs0297
ny937tp7160
pf503zw6931
pm019xr6338
pn516mv5835
pn788jn0506
pp800fz4795
ps339qr0927
qc749pq6092
qd536cz4448
qm616mh0054
qy041qt3985
qy562tn8599
qy614vc4298
rb274dm3421
rb407sx9368
rb416sg3189
rc703qc7903
rd859fz5466
rg051vq4934
rh769zm3475
rn807bx6508
rp216jd6910
rq144gp9226
rr091gt3625
rt675cp1036
rx216dk0197
sc722kv3664
sf476gk3445
sj387rb5615
sp053gq3480
sx742fg4179
sx868sk7792
tf817pd9856
tg539fh7766
tg863bp5893
tj152cr9469
tn895bv6211
tp041gt5602
tp065nw5129
tp964pk6047
tq638pw3404
tq978hq0730
tw604tb1797
tx719jv3214
vf149jk9134
vj838wh8781
vk997ym4371
vm846xq2908
vq558fn9462
vs820pm7236
wc651sw4030
wg070fy7306
wj168jy2895
wk150cb1199
wn015gr1622
wq361hz8247
ws904yf2088
wv941jx9853
ww637hg5230
wx275rg5544
xc545cs8960
xf064ft1557
xf220vc9592
xg253zc2469
xg434yx2382
xk796fp9452
xn764ds5028
xr117gj8779
xy134tt1022
xz326pc6206
yk166zv2612
yp404tr5273
yq990js5761
yr654qy0547
yz094zq4858
yz394zj0695
zb414nw6036
zc114mq8686
zd131qw8549
zd755dk5019
zk171sz2454
zk642vx4724
zk685rr8220
zp008zc1226
zq274bk1466
zw369bv7964
zz575jj1351
zz727sb4020
vs464yv3041
dx385qq8078
gg139ky6239
gg151zs5923
gk714cm0873
hc343gw0579
jm044yn4332
mf283yt5578
nm922dk0747
pk376qy9915
rp645xj5295
rz178mt3885
zf214fh0221
zq851zs2127
mw025dn3864
nn724gc9283
br401qx7376
dn098nk1582
dn125yf7523
dy461kk6206
fq531ww3565
gg760bx5514
jt521vb3195
nr810hq1047
pc279jj8911
vx947vb5305
xw984hv0265
hg666vd0263
nj220xh4291
nk246nv9884
pb597gw2312
qr181gm7220
sd910bs8991
tt728fn3835
vh934np5621
vs762pd2286
xs677zg5107
yn200hw8896
fd019gs5674
gj834gp4151
kk645gv9631
sd708mc4152]
Work.where(locked: false).joins(:head).where('work_versions.state' => 'deposited')
.where('work_versions.published_at' => [Date.parse('2021-08-01')..Date.parse('2022-08-23')])
.where.not(druid: exclude_set.map { |id| "druid:#{id}" }).count

Does that seem right?

[amyehodge]

Yes! That seems right.

Also, how about a version message that says "deposit date added to metadata by SDR admin"?

[jcoyne]

Developer Notes: This will require us to write code to deep clone all the relationships as is done in https://github.com/sul-dlss/happy-heron/blob/main/app/services/new_version_parameter_filter.rb but without going through the request/render html/post form cycle.

[amyehodge]

@justinlittman @mjgiarlo I think this ticket is now done and can be closed.

[mjgiarlo]

Thanks!