javascript - Insert using a select in typeorm - Stack Overflow

admin管理员组

文章数量:1289867

I want to reproduce a query where the values are the result of a select in typeorm. The query i want to reproduce is the one i provide here, but i can't find anything in typeorm documentation. (Isnt important what the query does for the answer, i only need to know how to write that "SELECT" in typeorm)

/classes/_query_builder_insertquerybuilder_.insertquerybuilder.html#values

INSERT INTO `furgpezzo`(`giacenza`, `giacenzaMin`, `pezzoBarcode`, `furgoneTarga`, `invStandardId`) 
    select '0', '5', '234234234234', f.`furgoneTarga`, '1'
    from `furgpezzo` f
    where f.`invStandardId` = '1'
    group by f.`furgoneTarga`

something like:

(Edit:)

return await this.dmDatabase.getRepository(FurgPezzo)
    .createQueryBuilder()
    .insert()
    .into(FurgPezzo)
    .values(   //here put my select   )

I want to reproduce a query where the values are the result of a select in typeorm. The query i want to reproduce is the one i provide here, but i can't find anything in typeorm documentation. (Isnt important what the query does for the answer, i only need to know how to write that "SELECT" in typeorm)

http://typeorm.delightful.studio/classes/_query_builder_insertquerybuilder_.insertquerybuilder.html#values

INSERT INTO `furgpezzo`(`giacenza`, `giacenzaMin`, `pezzoBarcode`, `furgoneTarga`, `invStandardId`) 
    select '0', '5', '234234234234', f.`furgoneTarga`, '1'
    from `furgpezzo` f
    where f.`invStandardId` = '1'
    group by f.`furgoneTarga`

something like:

(Edit:)

return await this.dmDatabase.getRepository(FurgPezzo)
    .createQueryBuilder()
    .insert()
    .into(FurgPezzo)
    .values(   //here put my select   )

• javascript
• mysql
• typescript
• typeorm
• typeorm-datamapper

Share Improve this question Follow edited Oct 23, 2019 at 14:51 doub1ejack 11.2k2020 gold badges7777 silver badges130130 bronze badges asked Aug 5, 2019 at 17:11 marco-zan reymerkmarco-zan reymerk 6911 gold badge11 silver badge66 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 10

This is the neatest solution I could e up with, hope it helps future explorers. The answer ments inspired me.

const [selectQuery, params] = this.entityManager
  .createQueryBuilder()
  .select("user.name")
  .from(User, "user")
  .where("user.id IN (:...ids)", {
    ids: [
      "87654321-1234-1234-1234-123456789abc",
      "a9876521-aabb-ccdd-ffaa-123abcdefccc",
    ],
  })
  .getQueryAndParameters();

await this.entityManager.query(
  `
INSERT INTO dummy("name")
${selectQuery}
`,
  params
);

Yes you can. From docs:

You can easily create subqueries. Subqueries are supported in FROM, WHERE and JOIN expressions.

Refer to the following posts for example: TypeORM subqueries, Typeorm subquery add select.

You can use subqueries:

return await this.dmDatabase.getRepository(InvStandard)
    .insert()
    .values(qb => {qb.select(FurgPezzo).where()})//here put my select 

// with subquery->

return await this.dmDatabase.getRepository(InvStandard)
    .insert()
    .values(qb => {qb.select(FurgPezzo).where(
            const subQuery = qb.subQuery()
                // your subquery builder
            return "your condition " + subQuery;)})

本文标签： javascriptInsert using a select in typeormStack Overflow