Checkbase queries for Installer

Vishal Lahane shared this idea 1 month ago
Not Planned

I have one more idea for installer if Yellowfin provides mechanism to execute SQL query in check base manner.

Like if select query get records then it should update & if no result found insert.

<query type=checkbaseQueries>

<select> </select >

<update> </update>

<insert> </insert>

</query>


It should handle if we provide select and update only then try to update if select result found i.e one more more rows. here I have not provide insert then it will skip that.


Thanks,

Vishal

Comments (6)

photo
1

Hi Vishal,

In regards to checkbasequeries, Yellowfin doesn't create any duplicates when you run the installer as the database will be empty. And the updater doesn't create any duplicate records either as there will be only schema changes and it does check for existing data before inserting new records.

1. If you are getting duplicate records in database by the original update installer then we need to replicate that issue.

2. If you are running full installer on an existing database then you need to stop doing in that way.

3. If you are running custom scripts along with the installer then you need to make sure not running the script twice without checking.

Please let me know if you have any questions.

Kind Regards,

Mahesh

photo
1

Hi Mahesh,

I already told you on basis of table value if I wanted to insert or update record. I know yellowfin will not duplicate or this is not for prevention but we do have own config table. also on older version we might not have configuration OOTB if this not found in current version then this will helpful for us.


Thanks,

Vishal

photo
1

Hi Vishal,

Thanks for your reply.

I understand what you mean. As Yellowfin is not aware of what values you are updating using customised installer to your on config table, Yellowfin will not be able to figure out. However, Yellowfin update installer will do check the database for existing data, when there are changes to the schema and does update accordingly.

Let me know if you have any questions.

Kind Regards,

Mahesh

photo
1

That's correct what if we wanted to customise the configuration what we needed. Suppose we wanted our default configuration.

photo
1

Update configuration there is option but updating values which we provide then only way is yellow fin webservice but I wanted this support in yellowfin installer it self so that check base queries we can run for fresh & upgrade. Even when there is no webservice provided for some yellowfin data updation.

photo
1

Hi Vishal,


Apologies as it sounds like what you're using is a custom installer, and in cases like this the YF installer is not able to pick up any changes that are not out of the box. This item has been reviewed and unfortunately do not have any immediate plans to implement this feature.


This doesn't mean the item has been closed forever, just not on our current road map.If anything changes I'll let you know. Though of course if there was anything else you were after in the meantime, or believe this needs to be revisited due to user impact, please let me know.

Regards,

David