Max execution time
We can drop slow query to avoid crashing the server.
Use custom index
You can provide a certain index for database server to use in some cases. This feature is only supported in MySQL.
Joining any entity or table
You can join not only relations, but also other unrelated entities or tables. Examples:
Inner Join in Typeorm
Inner and left joins If you want to use INNER JOIN instead of LEFT JOIN just use innerJoinAndSelect instead: This will generate: The difference between LEFT JOIN and INNER JOIN is that INNER JOIN won’t return a user if it does not have any photos. LEFT JOIN will return you the user even if it doesn’t have photos. Join without selection You can join data without its selection. To do that, use leftJoin or innerJoin: This will generate: This will select Timber if he has photos, but won’t return his photos.
Joining Relations
This will generate following SQL query: You can also add conditions to the join expression instead of using “where”: This will generate the following SQL query:
Adding OFFSET expression
Adding an SQL OFFSET expression is easy as: Which will produce the following SQL query: The resulting SQL query depends on the type of database (SQL, mySQL, Postgres, etc). Note: OFFSET may not work as you may expect if you are using complex queries with joins or subqueries. If you are using pagination, it’s recommended to use skip instead.
Adding LIMIT expression
Adding a LIMIT expression is easy as: Which will produce the following SQL query: The resulting SQL query depends on the type of database (SQL, mySQL, Postgres, etc). Note: LIMIT may not work as you may expect if you are using complex queries with joins or subqueries. If you are using pagination, it’s recommended to use take instead.
Adding GROUP BY expression
Adding GROUP BY expression Adding a GROUP BY expression is easy as: Which will produce the following SQL query: To add more group-by criteria use addGroupBy: If you use .groupBy more than once you’ll override all previous GROUP BY expressions.
Adding ORDER BY expression
Adding an ORDER BY expression is easy as: Which will produce: You can change the ordering direction from ascending to descending (or versa): You can add multiple order-by criteria: You can also use a map of order-by fields: If you use .orderBy more than once you’ll override all previous ORDER BY expressions. Adding ORDER BY expression Adding an ORDER BY expression is easy as: Which will produce: You can change the ordering direction from ascending to descending (or versa): You can add multiple order-by criteria: You can also use a map of order-by fields: If you use .orderBy more than once you’ll override all previous ORDER BY expressions.
Adding HAVING expression
Adding HAVING expression Adding a HAVING expression is easy as: Which will produce following SQL query: You can add AND into an exist HAVING expression: Which will produce the following SQL query: You can add OR into a exist HAVING expression: Which will produce the following SQL query: You can combine as many AND and OR expressions as you need. If you use .having more than once you’ll override all previous HAVING expressions.
