entityMap|blocks|key|1d9fl|text|正如所指出的那样|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9ob38|Tomer+Amir|8kal9|，目前有部分解决方案|v20v|真正的向上插入|5f748|并且在TypeORM的存储库上打开了一个功能请求：|97cpq|TypeORM+upsert功能请求|f84oq|部分解决方案：|8ml1q|await+connection.createQueryBuilder()
++++++++.insert()
++++++++.into(Post)
++++++++.values(post2)
++++++++.onConflict(`("id")+DO+NOTHING`)
++++++++.execute();

await+connection.createQueryBuilder()
++++++++.insert()
++++++++.into(Post)
++++++++.values(post2)
++++++++.onConflict(`("id")+DO+UPDATE+SET+"title"+=+:title`)
++++++++.setParameter("title",+post2.title)
++++++++.execute();|code-block|syntax|javascript|dd0kb|旧的答案实际上指向了OP所要求的“更新”方式：|6m3d6|89i49|已经有一种方法可以解决这个问题：|b6ugd|，其中的文档是这样写的：|a6rae|保存数据库中所有给定的实体。如果数据库中不存在实体，则插入，否则更新。|4l6b|1c3t6|但是如果不指定id或唯一的字段集，save方法就不能知道您引用的是现有的数据库对象。|cs5mp|因此，typeORM的突出之处在于：|5cd9u|let+contraption+=+await+thingRepository.save({id:+1,+name+:+"New+Contraption+Name+!"});^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|19|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|1A|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|1B|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|1C|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|1D|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|1E|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|1F|9|@]|A|@]|B|$]]|$2|O|4|P|6|Q|8|1G|9|@]|A|@]|B|$R|S]]|$2|T|4|U|6|7|8|1H|9|@]|A|@]|B|$]]|$2|V|4|-4|6|7|8|1I|9|@]|A|@]|B|$]]|$2|W|4|X|6|7|8|1J|9|@]|A|@]|B|$]]|$2|Y|4|Z|6|7|8|1K|9|@]|A|@]|B|$]]|$2|10|4|11|6|7|8|1L|9|@]|A|@]|B|$]]|$2|12|4|-4|6|7|8|1M|9|@]|A|@]|B|$]]|$2|13|4|14|6|7|8|1N|9|@]|A|@]|B|$]]|$2|15|4|16|6|7|8|1O|9|@]|A|@]|B|$]]|$2|17|4|18|6|Q|8|1P|9|@]|A|@]|B|$R|S]]]]

As pointed out by <a href="https://stackoverflow.com/users/1678659/tomer-amir">Tomer Amir</a>, there is currently a partial solution for real upsert and a feature request is ATM opened on TypeORM's repository :

<a href="https://github.com/typeorm/typeorm/issues/1090" rel="noreferrer">TypeORM upsert feature request</a>

Partial solution : 

<pre><code>await connection.createQueryBuilder()
 .insert()
 .into(Post)
 .values(post2)
 .onConflict(`("id") DO NOTHING`)
 .execute();

await connection.createQueryBuilder()
 .insert()
 .into(Post)
 .values(post2)
 .onConflict(`("id") DO UPDATE SET "title" = :title`)
 .setParameter("title", post2.title)
 .execute();
</code></pre>

<hr>

Old answer actually points to the "update" way of doing what OP was asking for : 

There's already a method for it : <code>Repository&lt;T&gt;.save()</code>, of which documentation says :

<blockquote>
 Saves all given entities in the database. If entities do not exist in
 the database then inserts, otherwise updates.
</blockquote>

But if you do not specify the id or unique set of fields, the save method can't know you're refering to an existing database object.

So upserting with typeORM is : 

<pre><code>let contraption = await thingRepository.save({id: 1, name : "New Contraption Name !"});
</code></pre>

entityMap|blocks|key|agp7m|text|请在此处以用户身份在您的实体中添加备注|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2du1|@OneToMany(type+=>+Post,+post+=>+post.user,+{
++++++++cascade:+true
++++})
++++posts:+Post[];


export+const+saveAllPosts+=+async+(req:+Request,+res:+Response)+=>+{
++++const+userRepository+=+getManager().getRepository(User);
++++const+postRepository+=+getManager().getRepository(Post);
++++let+i;
++++let+newUsers:any+=+[];
++++let++newUser:any+=+{};
++++let++newPost:any+=+{};
++++for(i=1;+i<=6;+i+%2B%2B)+{
++++++++newUser+=+await+userRepository.findOne({+
++++++++++++where:+{+id:+i}+
++++++++});
++++++++if(typeof+newUser+==+"undefined")+{
++++++++++++newUser+=+new+User();
++++++++++++console.log("insert");
++++++++}+else++{
++++++++++++console.log("update");
++++++++}+++++++++++
++++++++newUser.name++=+"naval+pankaj+test"%2Bi;+++

++++++++newPost+=+await+postRepository.findOne({+
++++++++++++where:+{+userId:+i}+
++++++++});
++++++++if(typeof+newPost+==+"undefined")+{
++++++++++++newPost+=+new+Post();
++++++++++++console.log("post+insert");
++++++++}+else++{
++++++++++++console.log("post+update");
++++++++}
++++++++newPost.title+=+"naval+pankaj+add+post+title+"%2Bi;
++++++++newUser.posts+=+[newPost];
++++++++newUsers.push(newUser);+++++
++++}
++++await+userRepository.save(newUsers);++
++++res.send("complete");
};|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

Note in your entity as user here

<pre><code>@OneToMany(type =&gt; Post, post =&gt; post.user, {
 cascade: true
 })
 posts: Post[];


export const saveAllPosts = async (req: Request, res: Response) =&gt; {
 const userRepository = getManager().getRepository(User);
 const postRepository = getManager().getRepository(Post);
 let i;
 let newUsers:any = [];
 let newUser:any = {};
 let newPost:any = {};
 for(i=1; i&lt;=6; i ++) {
 newUser = await userRepository.findOne({ 
 where: { id: i} 
 });
 if(typeof newUser == "undefined") {
 newUser = new User();
 console.log("insert");
 } else {
 console.log("update");
 } 
 newUser.name = "naval pankaj test"+i; 

 newPost = await postRepository.findOne({ 
 where: { userId: i} 
 });
 if(typeof newPost == "undefined") {
 newPost = new Post();
 console.log("post insert");
 } else {
 console.log("post update");
 }
 newPost.title = "naval pankaj add post title "+i;
 newUser.posts = [newPost];
 newUsers.push(newUser); 
 }
 await userRepository.save(newUsers); 
 res.send("complete");
};
</code></pre>

entityMap|blocks|key|7mab2|text|对于正在寻找向上插入多条记录并使用Postgres和TypeORM的任何人来说，您可以通过excluded关键字访问您试图更新/插入的行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2rceu|const+posts+=+[{+id:+1,+title:+"First+Post"+},+{+id:+2,+title:+"Second+Post"+}];

await+connection.createQueryBuilder()
++++++++.insert()
++++++++.into(Post)
++++++++.values(posts)
++++++++.onConflict(`("id")+DO+UPDATE+SET+"title"+=+excluded."title"`)
++++++++.execute();|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

For anyone looking for a way to upsert multiple records and is using Postgres and TypeORM, you're able to access the row you're attempting to update/insert via the excluded keyword.

<pre><code>const posts = [{ id: 1, title: "First Post" }, { id: 2, title: "Second Post" }];

await connection.createQueryBuilder()
 .insert()
 .into(Post)
 .values(posts)
 .onConflict(`("id") DO UPDATE SET "title" = excluded."title"`)
 .execute();
</code></pre>

entityMap|blocks|key|f0dmq|text|现在有了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|65os5|一个图书馆|eladt|它插入到TypeORM中来帮助实现这一点。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

There is now <a href="https://github.com/danielmhanover/typeorm-upsert" rel="nofollow noreferrer">a library</a> that plugs into TypeORM to help do this.

entityMap|blocks|key|202r4|text|使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|avk4g|插入忽略|crsfl|要忽略MySQL上的重复项，请执行以下操作：|f0n61|await+connection.createQueryBuilder()
++++++++.insert()
++++++++.into(Post)
++++++++.values(post)
++++++++.orIgnore()
++++++++.execute();|code-block|syntax|javascript^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|N|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|O|9|@]|A|@]|B|$J|K]]]]

Use <a href="https://www.tutorialspoint.com/mysql/mysql-handling-duplicates.htm" rel="nofollow noreferrer">INSERT IGNORE</a> to ignore duplicates on MySQL and Postgres:
<pre><code>await connection.createQueryBuilder()
 .insert()
 .into(Post)
 .values(post)
 .orIgnore()
 .execute();
</code></pre>

entityMap|blocks|key|anrld|text|在以下情况下，这可能会有所帮助|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1c49s|不适用于MySQL。来自|1sq8c|Github|3fba3|await+getConnection()
++.createQueryBuilder()
++.insert()
++.into(GroupEntity)
++.values(updatedGroups)
++.orUpdate({+conflict_target:+['id'],+overwrite:+['name',+'parentId',+'web',+'avatar',+'description']+})
++.execute();|code-block|syntax|javascript^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|N|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|O|9|@]|A|@]|B|$J|K]]]]

this might help when <code>ONCONFLICT</code> doesn't work with MySQL. From <a href="https://github.com/typeorm/typeorm/issues/1090#issuecomment-634391487" rel="noreferrer">Github</a>
<pre><code>await getConnection()
 .createQueryBuilder()
 .insert()
 .into(GroupEntity)
 .values(updatedGroups)
 .orUpdate({ conflict_target: ['id'], overwrite: ['name', 'parentId', 'web', 'avatar', 'description'] })
 .execute();
</code></pre>

entityMap|blocks|key|qks7|text|对于在2021年发现这一点的任何人来说，Typeorm的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5lqdm|方法将在找到与主键匹配的项时进行更新或插入。这也适用于sqlite。|ed91l|从文档中：|9cbbm|/**
+*+Saves+all+given+entities+in+the+database.
+*+If+entities+do+not+exist+in+the+database+then+inserts,+otherwise+updates.
+*/|code-block|syntax|javascript^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|N|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|O|9|@]|A|@]|B|$J|K]]]]

For anyone finding this in 2021, Typeorm's <code>Repository.save()</code> method will update or insert if it finds a match with a primary key. This works in sqlite too.
From the documentation:
<pre><code> /**
 * Saves all given entities in the database.
 * If entities do not exist in the database then inserts, otherwise updates.
 */
</code></pre>

Does TypeORM include some functionnality to avoid this : 

<pre><code>let contraption = await thingRepository.findOne({ name : "Contraption" });

if(!contraption) // Create if not exist
{
 let newThing = new Thing();
 newThing.name = "Contraption"
 await thingRepository.save(newThing);
 contraption = newThing;
}
</code></pre>

Something like : 

<pre><code>let contraption = await thingRepository.upsert({ name : "Contraption" });
</code></pre>

TypeORM upsert - create if not exist

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

 TypeORM是否包含一些功能来避免这种情况： let contraption = await thingRepository.findOne({ name : "Contraption" });if(!contraption) // Create if not exist{    let newThing = ne...

问TypeORM upsert -如果不存在则创建
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问TypeORM upsert -如果不存在则创建EN