-
Notifications
You must be signed in to change notification settings - Fork 1
/
migration.php
300 lines (259 loc) · 10.5 KB
/
migration.php
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
<?php
/**
* Quick, dirty, but it works migration script. This will get all post types, loop through them and then update the acf cap byline field with the original terms data.
*/
// Let's get the missing posts with missing byline arrays and provide a number as to how many there are.
function get_missing_byline_array_count() {
global $wpdb;
$query = "
SELECT count(*)
FROM wp_posts
WHERE post_status = 'publish' AND ID NOT IN (
SELECT post_id
FROM wp_postmeta
WHERE meta_key = 'byline_array' AND meta_value != '' AND meta_value IS NOT NULL
);
";
$count = $wpdb->get_var($query);
return $count;
}
function cap_byline_migrate() {
// Setup an empty dumb array. We'll use this later on to store how many posts dont have data.
$results = array();
// Setup a query to get posts that don't have a byline array meta field. Limit to 10.
$args = array(
'post_type' => 'post',
'posts_per_page' => 100,
'fields' => 'ids',
'meta_query' => array(
array(
'key' => 'byline_array',
'compare' => 'NOT EXISTS',
)
),
'cache_results' => false
);
$the_query = new WP_Query( $args );
// Loop through this query, get the person terms that already exist, copy those via
// update_field (an ACF function) to the new byline_array field.
if ( $the_query->have_posts() ) {
$i = 1;
while ( $the_query->have_posts() ) {
$the_query->the_post();
$persons = get_the_terms( get_the_ID(), 'person' );
$new_data = array();
// We don't want to throw errors if there are any posts with no data.
if (!empty($persons)) {
foreach ($persons as $person ) {
$new_data[] = $person->term_id;
}
update_field('field_53f38cd042a42', $new_data);
// print_r($new_data);
// echo '<strong>'.get_the_id().'</strong>';
// echo '<br>'.get_the_title().' -- Ran '. $i . '<br><br>';
} else {
// echo '<span style="color:red">'.get_the_title().' Had No Persons -- Ran' . $i . '</span><br><br>';
}
$i++;
}
}
// Restore original post data to start through the loop again.
wp_reset_postdata();
// Provide a count of how many posts after running this query do not have the byline_array field.
$results["count"] = get_missing_byline_array_count();
// Write json header
header("Content-type: application/json");
$return = json_encode($results);
echo $return;
//echo $results["count"];
die();
}
add_action('wp_ajax_cap_byline_migrate', 'cap_byline_migrate');
add_action('wp_ajax_nopriv_cap_byline_migrate', 'cap_byline_migrate');
// To run hit - http://domain.com/wp-admin/admin-ajax.php?action=cap_byline_migrate
function wceg_cap_byline_migrate() {
// Setup an empty dumb array. We'll use this later on to store how many posts dont have data.
$results = array();
// Setup a query to get posts that don't have a byline array meta field. Limit to 10.
$args = array(
'post_type' => array('post','work','press','news'),
'posts_per_page' => 1000,
'fields' => 'ids',
'meta_query' => array(
array(
'key' => 'byline_array',
'compare' => 'NOT EXISTS',
)
),
'cache_results' => false
);
$the_query = new WP_Query( $args );
// Loop through this query, get the person terms that already exist, copy those via
// update_field (an ACF function) to the new byline_array field.
if ( $the_query->have_posts() ) {
$i = 1;
while ( $the_query->have_posts() ) {
$the_query->the_post();
$persons = get_the_terms( get_the_ID(), 'person' );
$new_data = array();
// We don't want to throw errors if there are any posts with no data.
if (!empty($persons)) {
foreach ($persons as $person ) {
$new_data[] = $person->term_id;
}
update_field('field_53f38cd042a42', $new_data);
print_r($new_data);
echo '<strong>'.get_the_id().'</strong>';
echo '<br>'.get_the_title().' -- Ran '. $i . '<br><br>';
} else {
echo '<span style="color:red">'.get_the_title().' Had No Persons -- Ran' . $i . '</span><br><br>';
}
$i++;
}
}
// Restore original post data to start through the loop again.
wp_reset_postdata();
// // Provide a count of how many posts after running this query do not have the byline_array field.
// $results["count"] = get_missing_byline_array_count();
// // Write json header
// header("Content-type: application/json");
//
// $return = json_encode($results);
// echo $return;
echo $results["count"];
die();
}
add_action('wp_ajax_wceg_cap_byline_migrate', 'wceg_cap_byline_migrate');
add_action('wp_ajax_nopriv_wceg_cap_byline_migrate', 'wceg_cap_byline_migrate');
// To run hit - http://domain.com/wp-admin/admin-ajax.php?action=wceg_cap_byline_migrate
function hit_cap_byline_migrate() {
// Setup an empty dumb array. We'll use this later on to store how many posts dont have data.
$results = array();
// Setup a query to get posts that don't have a byline array meta field. Limit to 10.
$args = array(
'post_type' => array('post','stories'),
'posts_per_page' => 1000,
'fields' => 'ids',
'meta_query' => array(
array(
'key' => 'byline_array',
'compare' => 'NOT EXISTS',
)
),
'cache_results' => false
);
$the_query = new WP_Query( $args );
// Loop through this query, get the person terms that already exist, copy those via
// update_field (an ACF function) to the new byline_array field.
if ( $the_query->have_posts() ) {
$i = 1;
while ( $the_query->have_posts() ) {
$the_query->the_post();
$persons = get_the_terms( get_the_ID(), 'person' );
$new_data = array();
// We don't want to throw errors if there are any posts with no data.
if (!empty($persons)) {
foreach ($persons as $person ) {
$new_data[] = $person->term_id;
}
update_field('field_53f38cd042a42', $new_data);
print_r($new_data);
echo '<strong>'.get_the_id().'</strong>';
echo '<br>'.get_the_title().' -- Ran '. $i . '<br><br>';
} else {
echo '<span style="color:red">'.get_the_title().' Had No Persons -- Ran' . $i . '</span><br><br>';
}
$i++;
}
}
// Restore original post data to start through the loop again.
wp_reset_postdata();
// Provide a count of how many posts after running this query do not have the byline_array field.
$results["count"] = get_missing_byline_array_count();
// Write json header
// header("Content-type: application/json");
//
// $return = json_encode($results);
// echo $return;
echo $results["count"];
die();
}
add_action('wp_ajax_hit_cap_byline_migrate', 'hit_cap_byline_migrate');
add_action('wp_ajax_nopriv_hit_cap_byline_migrate', 'hit_cap_byline_migrate');
// To run hit - http://domain.com/wp-admin/admin-ajax.php?action=hit_cap_byline_migrate
function c3_cap_byline_migrate() {
// Set up an empty array. We'll use this to store bios without data.
$missed_bios = array();
// Setup a query to get posts of type bio
$args = array(
'post_type' => array( 'bio' ),
'posts_per_page' => 1000,
'fields' => 'ids',
'cache_results' => false
);
$the_query = new WP_Query( $args );
// Loop through this query, get the person term that already exists, copy email address and
// twitter handle from the bio to the person
if ( $the_query->have_posts() ) {
$i = 1;
while ( $the_query->have_posts() ) {
$the_query->the_post();
// get the email address and twitter handle
$email_address = get_post_meta( get_the_ID(), '_bio_email', true );
$twitter_handle = get_post_meta( get_the_id(), '_bio_twitter', true );
$persons = get_the_terms( get_the_ID(), 'person' );
// We don't want to throw errors if there are any posts with no data.
if ( ! empty( $persons ) ) {
$person = array_shift( $persons );
if ( ! empty( $email_address ) ) {
update_field( 'field_539f06f598929', $email_address, $person );
}
if ( ! empty( $twitter_handle ) ) {
update_field( 'field_539efea738186', $twitter_handle, $person );
}
echo '<strong>' . get_the_id() . '</strong>';
echo '<br>' . get_the_title() . ' -- Ran ' . $i . '<br><br>';
} else {
echo '<span style="color:red">' . get_the_title() . ' Had No Persons -- Ran' . $i . '</span><br><br>';
$missed_bios[] = get_the_ID();
}
$i ++;
}
}
// Restore original post data to start through the loop again.
wp_reset_postdata();
print_r($missed_bios);
die();
}
add_action( 'wp_ajax_c3_cap_byline_migrate', 'c3_cap_byline_migrate' );
add_action( 'wp_ajax_nopriv_c3_cap_byline_migrate', 'c3_cap_byline_migrate' );
// To run hit - http://domain.com/wp-admin/admin-ajax.php?action=c3_cap_byline_migrate
function gp_cap_byline_migrate() {
// Setup a query to get posts of type bio
$args = array(
'post_type' => array( 'bio' ),
'posts_per_page' => 1000,
'cache_results' => false
);
$the_query = new WP_Query( $args );
// Loop through this query, set person_is_linked to true for the person
// corresponding to each bio
if ( $the_query->have_posts() ) {
$posts = $the_query->get_posts();
foreach ($posts as $post) {
echo "for Bio post_id: $post->ID<br/>\n";
// get person
$person = get_term_by('slug', $post->post_name, 'person');
if ($person) {
// update person_is_linked
update_field('field_53a2ff7d56f11', true, $person->term_id);
echo "update person (term_id, name): ($person->term_id, $person->name)";
}
echo "<br/><br/>\n";
}
}
die();
}
add_action( 'wp_ajax_gp_cap_byline_migrate', 'gp_cap_byline_migrate' );
add_action( 'wp_ajax_nopriv_gp_cap_byline_migrate', 'gp_cap_byline_migrate' );
// To run hit - http://domain.com/wp-admin/admin-ajax.php?action=gp_cap_byline_migrate