Installation
npm install @brainhubeu/hadron-typeorm --save
Initializing
Pass package as an argument for hadron bootstrapping function:
const hadronTypeOrm = require('@brainhubeu/hadron-typeorm');
// ... importing and initializing other components
hadron(expressApp, [hadronTypeOrm], config).then(() => {
console.log('Hadron with typeORM initialized');
});
Connecting to database
You can set up a new connection using connection object.
{
connectionName: string,
type: string,
host: string,
port: number,
username: string,
password: string,
database: string
entitySchemas: entities,
synchronize: bool,
}
-
connectionName
- string that identifies this connection -
type
- string that defines type of database, f.e. mysql, mariadb, postgres, sqlite, mongodb, -
host
- url to database, -
port
- port of database, -
username
- username of account to databse, -
password
- password to database, -
database
- name of database -
entities
- array of classes that defines models -
entitySchemas
- in case that You are describing models with schemas, put those in this parameter -
synchronize
- parameter that defines if database should be automatically synchronized with models
Also all other parameters available in typeOrm are available. Please take a look at TypeORM documentation
Including database connection in hadron
NOTE: Also events aren't included in this section so logging into the console is done using setTimeout.
Since we have our connection, we need to include it inside our hadron constructor's config object.
const hadronTypeOrm = require('@brainhubeu/hadron-typeorm');
const config = {
connection: {
/* connection object */
},
};
hadron(expressApp, [hadronTypeOrm], config).then((container) => {
console.log('Initialized connection:', container.take('connection'));
});
Entities
Let's assume we want to have a simple table user
Field | Type |
---|---|
|
int |
firstName | varchar |
lastName | varchar |
We have two options while defining our entities
.
Class + Decorators
import { Entity, Column, PrimaryColumn } from 'typeorm';
@Entity()
export class Photo {
@PrimaryGeneratedColumn()
@Column()
id: number;
@Column() firstName: string;
@Column() lastName: string;
}
When using this method, while creating connection to database, those classes should be in entities
parameter.
Schema Way
// entity/User.js
module.exports = {
name: 'User',
columns: {
id: {
primary: true,
type: 'int',
generated: true,
},
firstName: {
type: 'varchar',
},
lastName: {
type: 'varchar',
},
},
};
When using this method, while creating connection to database, those schemas should be in entitySchemas
parameter.
For more details about defining models, please take a look at TypeORM documentation. Especially section about available types for each database distribution
Injecting entities into hadron
To include our entities in hadron, we simply need to include them in our config object. Let's modify the code that we were using to initialize hadron:
const hadronTypeOrm = require('@brainhubeu/hadron-typeorm');
const user = require('./entity/User');
const config = {
connection,
entities: [user],
};
hadron(expressApp, [hadronTypeOrm], config).then((container) => {
console.log(
'userRepository available:',
container.take('userRepository') !== null,
);
// User entity should be declared under userRepository key and
// will be available as a typeORM repository
});
Repository key in Container depends from name of schema/class and is builded in such way:
<schema/class name in camelCase>Repository
Examples:
User = userRepository
SuperUser = superUserRepository
loremIpsumDolor = loremIpsumDolorRepository
Repositories
Generater repositories contain same methods as ones from TypeORM. Please check them out here:
http://typeorm.io/#/working-with-entity-manager
Troubleshooting
I can' connect to database:
- make sure that connection config has valid data and there is existing database with specified name
There are no tables in my database
-
There are few possible reasons for that. Firstly check if parameter
synchronize
in configuration is set to true. -
Then make sure that connection configuration contains
entities
/entitySchemas
fields. -
Remember, if You are using class definition of models, You need to put them in
entities
parameter, otherwise (schema method) inentitySchemas
There is an information that I am missing a driver
- If you decided which database You want to use, You need to add a proper driver to your dependencies. For more details check TypeORM README file