@skidos/skidosmysqldblib v1.0.3

@skidos/skidosmysqldblib

A MySQL database library for Skidos projects using Sequelize ORM.

Installation

npm install @skidos/skidosmysqldblib
# or
yarn add @skidos/skidosmysqldblib
# or
pnpm add @skidos/skidosmysqldblib

Requirements

• Node.js >= 14.0.0
• MySQL database server

Usage

const { initializeMySqlConn, User, Game, Subscription } = require('@skidos/skidosmysqldblib');

// Initialize the database connection
await initializeMySqlConn({
  host: 'your-host',
  database: 'your-database',
  username: 'your-username',
  password: 'your-password'
});

// Use the models
const users = await User.findAll();
const games = await Game.findAll();

Available Models

The library provides the following models:

• Activity
• Age
• AggregatedStats
• AssetBundle
• Avatar
• AvatarCustomization
• AvatarPurchaseEquip
• Config
• DefaultSubtopic
• Device
• DynamicJsonData
• EmailSubscription
• Game
• Player
• Subscription
• User
• And many more...

Requirements

• Node.js >= 14.0.0
• MySQL database

Dependencies

• mysql2: ^3.6.5
• sequelize: ^6.35.2
• winston: ^3.11.0
• dotenv: ^16.3.1

License

ISC