I want to be able to do iterative processing
complete
ベースマキナ サポート担当
For example, if multiple IDs are passed and repeated processing can be executed, processing is performed for each ID, the same action does not need to be executed by hand over and over again, so the intention is to reduce the number of work steps.
If you execute an SQL SELECT statement, you can retrieve data all at once by embedding an IN clause, for example.
However, for example, when updating data via the REST API, if an update endpoint has only been created for a single data, there is no reason to establish a new endpoint that accepts multiple IDs, but if anything, I want to keep throwing different values to the same endpoint over and over again.
Shuichiro Fukuoka (BaseMachina)
marked this post as
complete
Shuichiro Fukuoka (BaseMachina)
A batch action execution function has been added to this issue, so we have resolved it.
Kei Kamikawa
marked this post as
in progress
河
河原塚 有希彦
Background I'd like to use (here's an example):
・I want to perform common processing for multiple and large numbers of accounts (user IDs)
・You can put an UPDATE statement with an IN clause, but when an account has been unsubscribed and there is no user ID, an empty swing occurs in the IN clause, and as a result, a wide range of table locks are applied
・In order to avoid this, IN clauses are prohibited by operation rules
In such a case, I made a request to perform iterative processing instead of an IN clause. I look forward to working with you.
Kei Kamikawa
河原塚 有希彦: Thank you
In the near future, we plan to provide a mechanism that allows ShellScript to be executed only to enterprise customers.
If this can be realized, I think the following problems can be solved.
- Repeated processing is also possible.
- Since you can use whatever command you like, you can use data sources that are not supported by Base Machina.
- Commands etc. that were used before using Bass Machina can be used as they are, and it is possible to post them in the Bass Machina review flow!
- Also, it will be possible to acquire it as a data format that has been used until now!
I would be happy to talk to you again after the release. Until then, sorry for the inconvenience 🙏