Seems to me that there is no need to EVER deal with the pseudokeys. (select house_id from houses where address = new.address) Select (select name_id from names where name = new.name), Insert or ignore into houses (address) select new.address where new.address is not null Insert or ignore into names (name) values (new.name) Select raise(ABORT, 'Name cannot be NULL') where new.name is null If the subquery returns one or more row, the EXISTS.
#SQLIGHT INSERT IF DOESNT ALREADY EXIST CODE#
Here is the basic syntax of the EXISTS operator: EXISTS (subquery) Code language: SQL (Structured Query Language) (sql) In this syntax, the subquery is a SELECT statement that returns zero or more rows. Where (peasants.name_id is null or peasants.name_id = names.name_id)Īnd (peasants.house_id is null or peasants.house_id = houses.house_id) Ĭreate trigger ins_person instead of insert into persons The EXISTS operator is a logical operator that checks whether a subquery returns any row. create table namesĪddress text not null collate nocase unique I have two ideas: 1st get it, if it returns None, then generate a new and insert, if it is unsuccessful. It is actually not needed for anything at all. The problem: find an rdbms-independent way to get a value with the specified key from a database using sqlalchemy If the key doesn't exist, generate a new value and insert it to the table. It also does not really matter what some excrement-head thinks "after the fact" - they can either accept the answer "I don't know" (which by the way is an incorrect answer - the correct answer would be "that information was not recorded").Īnd going back to the post to which you replied, it only appears to the uneducated that there is a need to know the pseudokey for the row. Playing with pseudokeys will not be helpful in this regard. Unless the inserted record contains a timestamp of when it was inserted, there is no way to tell when the record was inserted. Well, that is a design flaw (failure to store needed information) and has nothing whatsoever to do with the question asked.
0 kommentar(er)
