Transactions

[matthewhisle]

Hello :)

I was having issuew ith the following:

                        await connection.clear('EventNotifications');
                        var eventnotifications= msg.d.DynamicProps.eventnotifications;
                        var eventnotificationsjson= $.parseJSON(eventnotifications);
                        await connection.insert({
                            into: 'EventNotifications',
                            values: eventnotificationsjson,
                            skipDataCheck: true
                        });
                        
                     No issue with JSSTORE. The issue was I had a background task UI loooking at EventNotifications. Sometimes it would hit right between the clear and insert and load a blank screen (I know crazy because its milliseconds apart). I need to be able to clear and insert with no risk of any read hitting the table between the two.
                     
                     I am trying to use transactions, but want to know, will this guarentee that no read of EventNotifications hits a blank table? I am using as follows:
                     
                                             var eventnotifications = msg.d.DynamicProps.eventnotifications; var eventnotificationsjson = $.parseJSON(eventnotifications); await connection.transaction({
                        tables: ['EventNotifications'], // list of tables which will be used inside a transaction                                 
                        method: "rebuildEventNotifications", // name of method which implements transaction                                 
                        data: $.parseJSON(eventnotifications) // pass any data , that will be used in runing transaction                            
                    });
                    
                    
                    async function rebuildEventNotifications(ctx) {

ctx.start(); // start the transaction

var rowsDeleted = await ctx.remove({
    from: "EventNotifications"
});
var inserteden = await ctx.insert({
    into: 'EventNotifications',
    values: ctx.data,
    skipDataCheck: true
});

await ctx.commit();

}

[matthewhisle]

Sorry for the weird paste. Basically I am trying to make sure that my example use of a transaciton above will ensure that a read that is happening in a job elsewhere in the background will never see an empty table BETWEEN the clear and the re-insertion