Comments (1)
A real incremental import is quite difficult because of the data denormalization across tables. We can be smarter however to do less work on a per event basis.
Proposed changes follow (new indices needed).
BUNDLE_*
and SUBSCRIPTION_*
events
- Refresh only the rows for the bundle associated with the event.
- Care must be taken however to update
bundle_account_rank
inanalytics_bundles
.
PAYMENT_SUCCESS
and PAYMENT_FAILED
events
- Refresh invoice row and invoice item rows for the invoice id associated with the event only (if the payment points to an invoice payment).
- Refresh only the payment tables for the
paymentId
from the event.
INVOICE_CREATION
and INVOICE_ADJUSTMENT
events
- Don't refresh payments.
If the event isSee killbill/killbill#1143.INVOICE_CREATION
and if the invoice doesn't contain anyCBA
item, only refresh invoice and invoice item rows for that invoice id. Otherwise, we need to still refresh all invoice and invoice items (impact of CBA across invoices).
from killbill-analytics-plugin.
Related Issues (20)
- NPE in BusinessTagDao#updateInTransaction
- analytics_bundles.charged_through_date not correctly updated HOT 2
- Wong invoice amounts in analytics_payment_purchases after credit scenario
- not found 404: ddl files in the documentation are not pointing to a resource.
- Invoice balance not updated after consuming CBA
- Plugin analytics-plugin version 7.2.3 cannot be started because the version 7.2.3 already exists in the registry HOT 3
- Enhance debugging of rescheduled notifications
- Add information on data freshness
- Appropriate error message is not displayed when there is an issue with the view/table corresponding to a report
- Kill Bill optimizations for Analytics plugins
- Issue in viewing the dashboard after creating a report HOT 3
- Rename columns to avoid SQL syntax error HOT 2
- Exception while refreshing an account with a custom field HOT 1
- Allow global configuration via properties file HOT 2
- Enable global configuration for complex properties. HOT 1
- Exception when running integration tests HOT 1
- Is this synchronized lock needed? HOT 2
- Add subcription_id column in analytics_invoice_items tables
- Catalog api
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from killbill-analytics-plugin.