Understanding upsert update

[swampthang]

I'm able to successfully create records but not able to update. Inspecting the query args I can see that the where data is correct and can also confirm that the record I'm trying to update matches the query.

I have a feeling it's the way I have this set up. Here's what I have. I've removed some of the obj properties to keep it pithy:

SomeSQL('aniblocks')
.model([
  {key:'id',type:'uuid',props:['pk']},
  {key:'blockID', type: 'string'},
  {key:'title',type:'string'},
  {key:'timelineData',type:'map'}
])
.actions([
  {
    name: 'add_new_block',
    args: ['aniblock:map'],
    call: function(args,db) {
      return db.query('upsert',args.aniblock).exec();
    }
  },
  {
    name: 'update_block',
    args: ['aniblock:map'],
    call: function(args,db) {
      var D = args.aniblock;
      return db.query('upsert',{
        title:D.title,
        timelineData:D.timelineData
      }).where(['blockID','=',D.blockID]).exec();
    }
  }
])
.views([
  {
    name: 'get_block_by_blockID',
    args: ['blockID:string'],
    call: function(args,db) {
      return db.query('select').where(['blockID','=', args.blockID]).exec();
    }
  },
  {
    name: 'list_all_blocks',
    args: ['blockID:string'],
    call: function(args,db) {
      return db.query('select').exec();
    }
  }
])
.on('error', function(eventData){
  console.log(eventData);
});

function addNewBlock(obj) {
  SomeSQL()
  .connect()
  .then(function(result, db) {
      db.doAction('add_new_block',{aniblock:{
        id: null,
        blockID: obj.blockID,
        title: obj.title,
        timelineData: obj.timelineData
      }}).then(function(result, db) {
          console.log(result)
          return db.getView('get_block_by_blockID',obj);
      }).then(function(result, db) {
          console.log(result)
      }).on('error', function(eventData){
         console.log(eventData);
      });
  });
}

function updateBlock(obj) {
  SomeSQL()
  .connect()
  .then(function(result, db) {
      db.doAction('update_block',{aniblock:{
        blockID: obj.blockID,
        title: obj.title,
        timelineData: obj.timelineData
      }}).then(function(result, db) {
          return db.getView('get_block_by_blockID',obj);
      }).then(function(result, db) {
          logAll();
      }).on('error', function(eventData){
         console.log(eventData);
      });
  })
}

function logAll() {
  SomeSQL().connect()
  .then(function(result,db) {
    db.getView('list_all_blocks');
  })
  .then(function(result, db){
    console.log(result);
  });
}

I'm adding screenshots of a session so you can see what's happening. Successfully ran addNewBlock - note the blockID value:

You can see that the result was success.
Then ran updateBlock. You can see here that the blockID is a match:

From the same update instance here's showing the args object:

Same instance showing the matching value for 'where':

Back in the updateBlock method showing the result that nothing was modified:

So, I'm sure I have everything out of place. Hoping you can tell me what I am I doing wrong.

[swampthang]

When I run addNewBlock a row is added to the table because I can see it there. When I run updateBlock it seems to delete the row because when i run list_all_blocks it returns an empty array.

[only-cliches]

Hi swampthang, When you call 'connect()' the database is initialized, table objects are created, etc. The way you have it set up right now each of the bottom functions is emptying the database before querying it! You should call 'connect()' only once after you e setup the models and views.

I'm on my phone right now so I can't test this but that should fix things. 🙂

[swampthang]

Ahhhh. That fixed it, thanks!