Hysteria ORM

Package is under development and not production ready by any means

Philosophy

• Hysteria ORM is an agnostic Object-Relational Mapping (ORM) library for TypeScript, designed to simplify interactions between your application and a SQL and NoSql databases.

• The structure of this ORM Is ispireed by some main Typescript orms like Typeorm and Lucid.

• It's partially type safe by design, allowing you to have features like intellisense for you models interactions while maintaining the flexibility of shooting yourself in the foot!

• The main characteristic Is that Models classes refer to the database repository allowing you to interact with It via static methods in a concise and minimal way. While Models instances do not have anything else but what you define as Columns(sql) or Properties(noSql) and are designed to be used directly in you typescript Logic without any overhead.

• Only open source and free to use Databases are and will be supported

• Installation

• Prerequisites

• Supported Databases

• Env example with a config for each database

• TypeScript Configuration example

• Javascript

• Setup Example

Known Issues

• Many to many retrieve not working on mariadb due to database limitations (may be fixed in the future)

Installation

    npm install hysteria-orm

    yarn add hysteria-orm

Prerequisites

• A JavaScript runtime environment (e.g., Node.js, deno or bun).
• The driver for you database, supported drivers are:

### Sql

# postgres
npm install pg
yarn add pg

# mysql or mariadb
npm install mysql2
yarn add mysql2

# sqlite
npm install sqlite3
yarn add sqlite3

### NoSql

# mongo
npm install mongodb
yarn add mongodb

# redis
npm install ioredis
yarn add ioredis

• Driver reference versions used in development

{
  "mysql2": "^3.11.5",
  "pg": "^8.13.1",
  "sqlite3": "^5.1.7",
  "mongodb": "^6.11.0",
  "ioredis": "^5.4.1"
}

Supported Databases

Sql

Documentation For Sql Databases

• Sql supported databases are

1. Mysql
2. MariaDB
3. Postgres
4. SQLite

NoSQl

• Redis
• Mongo

Env example with a config for each database

# POSTGRES
DB_TYPE=postgres
DB_HOST=127.0.0.1
DB_USER=root
DB_PASSWORD=root
DB_DATABASE=test
DB_PORT=5432
DB_LOGS=true
MIGRATION_PATH=./migrations # default is database/migrations

# MYSQL
DB_TYPE=mysql
DB_HOST=127.0.0.1
DB_USER=root
DB_PASSWORD=root
DB_DATABASE=test
DB_PORT=3306
DB_LOGS=true

# MARIADB
DB_TYPE=mariadb
DB_HOST=127.0.0.1
DB_USER=root
DB_PASSWORD=root
DB_DATABASE=test
DB_PORT=3306
DB_LOGS=true

# SQLITE
DB_TYPE=sqlite
DB_DATABASE="./sqlite.db"
DB_LOGS=true

# REDIS
REDIS_HOST=127.0.0.1
REDIS_USERNAME=default
REDIS_PASSWORD=root
REDIS_PORT=6379

# MONGO
MONGO_URL=mongodb://root:root@localhost:27017
MONGO_LOGS=true

TypeScript Configuration example

{
  "compilerOptions": {
    "esModuleInterop": true,
    "forceConsistentCasingInFileNames": true,
    "module": "commonjs",
    "outDir": "lib",
    "rootDirs": ["src", "test"],
    "skipLibCheck": true,
    "strict": true,
    "target": "ES2020",
    "moduleResolution": "node",
    "declaration": true,
    // Must set decorators support
    "experimentalDecorators": true,
    "emitDecoratorMetadata": true,
  },
  "include": ["src/**/*.ts", "test/**/*.ts"],
  "exclude": ["node_modules"]
}

Javascript

Hysteria ORM is written and designed for TypeScript, but It can still be used in JavaScript with some configurations:

1. Install the necessary dependencies:

npm install --save-dev reflect-metadata @babel/core @babel/cli @babel/preset-env @babel/plugin-proposal-decorators
yarn add --dev reflect-metadata @babel/core @babel/cli @babel/preset-env @babel/plugin-proposal-decorators

2. Create a babel.config.js file in the root of your project with the following content:

module.exports = {
  presets: [
    [
      "@babel/preset-env",
      {
        targets: {
          node: "current",
        },
      },
    ],
  ],
  plugins: [
    ["@babel/plugin-proposal-decorators", { legacy: true }],
  ],
};

3. Add a build script to your package.json file:

{
  "scripts": {
    "build": "babel src --out-dir dist"
  }
}

4. Run the build script:

npm run build

5. Run your application:

node dist/index.js

• Your js Model definition may look like this:

require('reflect-metadata');
const { Model, SqlDataSource, column } =  require("hysteria-orm");

class User extends Model {
  @column({ primaryKey: true })
  id

  @column()
  name

  @column()
  email

  @column()
  signupSource

  @column()
  isActive

  @column()
  createdAt

  @column()
  updatedAt
}

JS without decorators

• If you don't want to use decorators, you can define your models like this:
• Aside decorators, all other features are available in JavaScript

import {Model, SqlDataSource, getModelColumns} from 'hysteria-orm';
import Profile from './Profile';
import Post from './Post';
import Role from './Role';
import Address from './Address';

class User extends Model {
  static {
    this.column('id', { primaryKey: true });
    this.column('name');
    this.column('email');
    this.column('signupSource');
    this.column('isActive');

    this.hasOne('profile', () => Profile, "userId");
    this.hasMany('posts', () => Post, "userId");
    this.belongsToMany('roles', () => Role, "roleId");
    this.manyToMany('addresses', () => Address, "user_addresses", "userId");
  }
}

Setup Example

• Docker compose example with the database versions used in the development

version: "3"
services:
  mysql:
    image: mysql:8.0
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: test
    ports:
      - "3306:3306"

  postgres:
    image: postgres:13
    environment:
      POSTGRES_USER: root
      POSTGRES_PASSWORD: root
      POSTGRES_DB: test
    ports:
      - "5432:5432"

  mariadb:
    image: mariadb:10.5
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: test
    ports:
      - "3307:3306"

  redis:
    image: redis:6
    environment:
      - REDIS_PASSWORD=root
    ports:
      - "6379:6379"

  mongo:
    image: mongo:4.4
    environment:
      MONGO_INITDB_ROOT_USERNAME: root
      MONGO_INITDB_ROOT_PASSWORD: root
    ports:
      - "27017:27017"