What are the Slack Archives?
It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
Hi Team, Do you have any idea about how to check data in mirror table in DB? Please let me know if
Hi Team,
Do you have any idea about how to check data in mirror table in DB?
Please let me know if you have any idea about this.
Thanks in advance
Comments
-
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,082 ⚖️ - Guardians (admin)
Hey, what kind of data and what do you mean with “mirror table”? - And what do you mean with “check” ? Just visually?
0 -
I assume you want to compare two tables with the same structure if one of the table is missing an entry that the other one has:
SELECT table_a.field_1, table_b.field_1 FROM table_a FULL OUTER JOIN table_b ON table_a.id = table_b.id WHERE table_a.field_1 IS NULL OR table_b.field_1 IS NULL
that would give you all entries that only exist in one of the tables.
Please be aware that these will do a full table scan on both tables, so it's performance sensitive and should not be executed on large tables in a production system.
0 -
You can using cron job to count number record in ''mirror table" and compare with "entries table"
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 924 Developer Corner
- 783 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random