To filter relational table in TypeORM using findAndCount there is a workaround. To filtering based on relation fields for findAndCount.
We need to use ObjectLiteral-style where using this style conditions are works perfectly.
Assume that we have Three entities – products,attributeSet and woodType. products belongs to one attributeSet and one woodType,
attributeSet and woodType has many prod
Date: July 17, 2020, 10:46 am Author: Akram Hossain
Virtual column in MySQL is generated column, this column data or value comes from expression or function or other columns.
The difference between virtual column and normal column is normal table column value saved to disk
but virtual column value generated dynamically from any expression or function or from other columns.
So the virtual column has following characteristics
Virtual column is
Date: July 22, 2015, 11:11 am Author: Akram Hossain
In this tutorial we will learn how to create md5 hash in java. To create md5 hash in java we need follow below steps.
Create MessageDigest object for MD5
Update input string in message digest
Converts message digest value in base16 (hex)
If md5 generated successfully return md5
Date: June 18, 2014, 10:40 pm Author: Akram Hossain
For connecting to MySQL database using java we need to do following.
Java driver class name for MySQL: com.mysql.jdbc.Driver
Database connection string or connection url: jdbc:mysql://localhost:3306/addressBook
jdbc is the api name.
mysql is the database managment software.
localhost is the name of server where MySQL is installed.
3306 is the port port number.
addressBook is the name of d
Date: June 18, 2014, 10:37 pm Author: Akram Hossain
In this article i will explain how to export MySQL table data to csv file. To export data to csv at first we need to connect our application to MySQL.
You can follow this tutorial to learn How to connect to MySQL database in java.
We need to follow these steps in order to export data to csv.
Connect to MySQL.
Use FileWriter Class.
Get Data from MySQL table.
Append data to csv file
Date: June 18, 2014, 10:25 pm Author: Akram Hossain