Size: a a a

TypeORM - Русскоязычное сообщество

2020 February 20

VA

Victor Assis in TypeORM - Русскоязычное сообщество
The connection string that I use is
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
connectString: (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(Host = ${process.env.ORACLE_HOST})(Port = ${process.env.ORACLE_PORT})))(CONNECT_DATA =(sid = ${process.env.ORACLE_DATABASE_NAME})(SERVER=dedicated))),
     type: 'oracle',
     host: process.env.ORACLE_HOST,
     port: Number(process.env.ORACLE_PORT),
     username: process.env.ORACLE_USER,
     password: process.env.ORACLE_PASS,
     sid: process.env.ORACLE_DATABASE_NAME,
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
This with typeOrm
источник

JL

J L in TypeORM - Русскоязычное сообщество
Victor Assis
This with typeOrm
Thank you, but i just create file tnsnames.ora and in connectString provide my db name and it's works perfectly )
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
Nice!
источник

n

neurosys in TypeORM - Русскоязычное сообщество
.where('campaign.id IN (:...campaignIds)', {
 campaignIds,
})
Hmm why does this not work?
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
neurosys
.where('campaign.id IN (:...campaignIds)', {
 campaignIds,
})
Hmm why does this not work?
This is about my question?
I think It is not solution for my problema especificly.. I Will up an example.. but i am no free time at moment.. :/
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
With the example Will be more undestanded
источник

n

neurosys in TypeORM - Русскоязычное сообщество
Victor Assis
This is about my question?
I think It is not solution for my problema especificly.. I Will up an example.. but i am no free time at moment.. :/
It was not related to your question. But I found the issue for my problem.
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
Oh, right..
источник

n

neurosys in TypeORM - Русскоязычное сообщество
Hmm. How to select only one side of the join when doing joins with queryBuilder?
источник

n

neurosys in TypeORM - Русскоязычное сообщество
.leftJoinAndSelect() automatically selects the whole join side.
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
Yes. I use it.. but If i get one register And left has more than one he return only one Record with one Record of the Join. If with pagination.. because exists two rows with same register different by only the Join relation... User left Join photos
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
It returns
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
row 1: Id 1 User a photos a.jpg
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
Row 2: id 1 user a photos b.jpb
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
If i select on pagination only one register
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
It returns user.photo[a.jpg]
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
If I select 2 records
источник

VA

Victor Assis in TypeORM - Русскоязычное сообщество
It returns user.[a.jpg, b.jpg]
источник