-
Notifications
You must be signed in to change notification settings - Fork 11
/
bulkloader_backup.yaml
241 lines (191 loc) · 7.89 KB
/
bulkloader_backup.yaml
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
# Autogenerated bulkloader.yaml file.
# You must edit this file before using it. TODO: Remove this line when done.
# At a minimum address the items marked with TODO:
# * Fill in connector and connector_options
# * Review the property_map.
# - Ensure the 'external_name' matches the name of your CSV column,
# XML tag, etc.
# - Check that __key__ property is what you want. Its value will become
# the key name on import, and on export the value will be the Key
# object. If you would like automatic key generation on import and
# omitting the key on export, you can remove the entire __key__
# property from the property map.
# If you have module(s) with your model classes, add them here. Also
# change the kind properties to model_class.
python_preamble:
- import: base64
- import: re
- import: google.appengine.ext.bulkload.transform
- import: google.appengine.ext.bulkload.bulkloader_wizard
- import: google.appengine.ext.db
- import: google.appengine.api.datastore
- import: google.appengine.api.users
transformers:
- kind: Pledge
connector: csv
connector_options:
# TODO: Add connector options here--these are specific to each connector.
property_map:
- property: __key__
external_name: key
export_transform: transform.key_id_or_name_as_string
- property: amountCents
external_name: amountCents
# Type: Integer Stats: 6705 properties of this type in this kind.
import_transform: transform.none_if_empty(int)
- property: donationTime
external_name: donationTime
# Type: Date/Time Stats: 6705 properties of this type in this kind.
import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
- property: email
external_name: email
# Type: Email Stats: 6705 properties of this type in this kind.
import_transform: db.Email
- property: fundraisingRound
external_name: fundraisingRound
# Type: String Stats: 6705 properties of this type in this kind.
- property: model_version
external_name: model_version
# Type: Integer Stats: 3246 properties of this type in this kind.
import_transform: transform.none_if_empty(int)
- property: note
external_name: note
# Type: Text Stats: 6705 properties of this type in this kind.
import_transform: db.Text
- property: stripeCustomer
external_name: stripeCustomer
# Type: String Stats: 6705 properties of this type in this kind.
- property: url_nonce
external_name: url_nonce
# Type: String Stats: 6705 properties of this type in this kind.
- property: pledge_type
external_name: pledge_type
# Type: String Stats: 6705 properties of this type in this kind.
- property: paypalPayerID
external_name: paypalPayerID
# Type: String Stats: 6705 properties of this type in this kind.
- property: paypalTransactionID
external_name: paypalTransactionID
# Type: String Stats: 6705 properties of this type in this kind.
- property: bitpay_invoice_id
external_name: bitpay_invoice_id
# Type: String Stats: 6705 properties of this type in this kind.
- kind: Secrets
connector: csv
connector_options:
# TODO: Add connector options here--these are specific to each connector.
property_map:
- property: __key__
external_name: key
export_transform: transform.key_id_or_name_as_string
- property: stripe_private_key
external_name: stripe_private_key
# Type: String Stats: 1 properties of this type in this kind.
- property: stripe_public_key
external_name: stripe_public_key
# Type: String Stats: 1 properties of this type in this kind.
- kind: ShardedCounter
connector: csv
connector_options:
# TODO: Add connector options here--these are specific to each connector.
property_map:
- property: __key__
external_name: key
export_transform: transform.key_id_or_name_as_string
- property: count
external_name: count
# Type: Integer Stats: 50 properties of this type in this kind.
import_transform: transform.none_if_empty(int)
- kind: User
connector: csv
connector_options:
# TODO: Add connector options here--these are specific to each connector.
property_map:
- property: __key__
external_name: key
export_transform: transform.key_id_or_name_as_string
- property: email
external_name: email
# Type: Email Stats: 10658 properties of this type in this kind.
import_transform: db.Email
- property: employer
external_name: employer
# Type: String Stats: 7332 properties of this type in this kind.
- property: from_import
external_name: from_import
# Type: Boolean Stats: 4062 properties of this type in this kind.
import_transform: transform.regexp_bool('true', re.IGNORECASE)
- property: occupation
external_name: occupation
# Type: String Stats: 7336 properties of this type in this kind.
- property: phone
external_name: phone
# Type: String Stats: 6681 properties of this type in this kind.
- property: target
external_name: target
# Type: String Stats: 6710 properties of this type in this kind.
- property: address
external_name: address
# Type: String Stats: 10658 properties of this type in this kind.
- property: city
external_name: city
# Type: String Stats: 10658 properties of this type in this kind.
- property: zipCode
external_name: zipCode
# Type: String Stats: 10658 properties of this type in this kind.
- property: state
external_name: state
# Type: String Stats: 10658 properties of this type in this kind.
- property: first_name
external_name: first_name
# Type: String Stats: 10658 properties of this type in this kind.
- property: last_name
external_name: last_name
# Type: String Stats: 10658 properties of this type in this kind.
- property: mail_list_optin
external_name: mail_list_optin
# Type: String Stats: 10658 properties of this type in this kind.
- kind: WpPledge
connector: csv
connector_options:
# TODO: Add connector options here--these are specific to each connector.
property_map:
- property: __key__
external_name: key
export_transform: transform.key_id_or_name_as_string
- property: amountCents
external_name: amountCents
# Type: Integer Stats: 4099 properties of this type in this kind.
import_transform: transform.none_if_empty(int)
- property: donationTime
external_name: donationTime
# Type: Date/Time Stats: 4099 properties of this type in this kind.
import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
- property: email
external_name: email
# Type: Email Stats: 4099 properties of this type in this kind.
import_transform: db.Email
- property: employer
external_name: employer
# Type: String Stats: 688 properties of this type in this kind.
- property: occupation
external_name: occupation
# Type: String Stats: 692 properties of this type in this kind.
- property: phone
external_name: phone
# Type: String Stats: 28 properties of this type in this kind.
- property: stripeCustomer
external_name: stripeCustomer
# Type: String Stats: 4099 properties of this type in this kind.
- property: target
external_name: target
# Type: String Stats: 57 properties of this type in this kind.
- property: url_nonce
external_name: url_nonce
# Type: String Stats: 4099 properties of this type in this kind.
- property: wp_post_id
external_name: wp_post_id
# Type: Integer Stats: 4099 properties of this type in this kind.
import_transform: transform.none_if_empty(int)