GitLab Fulfillment Demos, 1 Dec 2022

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Backfill BillingAccounts and BillingAccountMemberships for existing Customers

Description

MR: https://gitlab.com/gitlab-org/customers-gitlab-com/-/issues/4798

A

Hello, this is a demo for this Mr. A new task to backfill ing account. Objects from existing customers objects all right, so um maybe I'm gonna show first the actual Rec task. Just in case we did it and I am going to so I'm into the log here.

A

I'm, just gonna have the logs open and I'm going to run that task with driver and set to false yeah. So no do I run.

A

So this is the log that we have here. As you can see, we had. We have three customers, one two and eight and a bidding account ID was created for them and then that completing account was uh synced. With customer saying that the the intermediate table bidding account, memberships was uh created, the relationship was created, that's basically if I go to the code. That would be that line here.

A

All right. Let's see what we have here, take customer.

A

So, let's take maybe the the third one that was updated, so we have beating count.

A

It's created, what 158, which is like 958 UTC, so that's what's created.

A

And if we are running it again,.

A

That's it here, starting task billing account of customers, nothing with between count, zero completed task. Oh good, now, I just wanted to talk about something here. I noticed that in production we can have a couple of customer objects with the same zero account. Id and different Salesforce account ID yeah, and if we are checking out the related zero account object. We and taking out the Salesforce account ID, that's attached to it. We find like that.

A

One of the two customers objects is actually in sync, I believe this task, at least for the first iteration, should disregard like the question of a bidding object for these, for, like, let's say the customers that are not in sync, with the zero account with their zero account counterpart.

A

So yeah I'm gonna try to emulate that uh that case here. So in order to do so, I'm going to first destroy the three last membership meeting, account memberships that were created just now and then the bidding account.

A

So we don't have like the casket delete yet I think that's fine, uh I, think that was part of the conversation we had in a in the past and what I'm gonna do I'm going to.

A

Let's take one of these three customers and we have Salesforce account and we're going to create a disconnect between the xero account and what we have here. So, let's update this to create a disconnect.

A

A

There we go now so, let's say we're here:.

A

Try that again.

A

And this is what we have. We have like three uh customers, nothing with the billing account and two bidding accounts are created. The third one, since it's not in synced with the related Euro, account object.

A

This one uh doesn't have like a building account created for.