@brainhubeu/hadron-typeorm

    1.0.3 • Public • Published

    Installation

    npm install @brainhubeu/hadron-typeorm --save

    More info about installation

    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
    🔑 id 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) in entitySchemas

    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

    Install

    npm i @brainhubeu/hadron-typeorm

    DownloadsWeekly Downloads

    8

    Version

    1.0.3

    License

    MIT

    Unpacked Size

    12.8 kB

    Total Files

    11

    Last publish

    Collaborators

    • benedyktdryl
    • dluber
    • brainhubeu-devops
    • annalach
    • szymon.morawski
    • dyoda
    • brainhubeu-ci
    • roberthebel