bbachi

version: '3.8'
services:
  db:
    image: postgres:14.1-alpine
    restart: always
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
    ports:
      - '5432:5432'

bbachi

const axios = require('axios');

export class UserService {

    public async getUsers() {
        return await axios.get('/api/users');
    }

    public async getContacts() {
        return await axios.get('/api/contacts');

bbachi

const axios = require('axios');

async function getUsers() {

    return await axios.get('/api/users');
}

async function getContacts() {

    return await axios.get('/api/contacts');

bbachi

module.exports = (sequelize, DataTypes, Model) => {

    class Tasks extends Model {}

    Tasks.init({
        // Model attributes are defined here
        name: {
          type: DataTypes.STRING,
          allowNull: false
        },

bbachi

const { Sequelize, Model, DataTypes } = require("sequelize");
const logger = require('../logger/api.logger');

const connect = () => {

    const hostName = process.env.MYSQL_HOST;
    const userName = process.env.MYSQL_USER;
    const password = process.env.MYSQL_PASSWORD;
    const database = process.env.MYSQL_DATABASE;
    const dialect = process.env.MYSQL_DIALECT;

bbachi

import { connect } from "../config/db.config";
import { APILogger } from '../logger/api.logger';
import { Tasks } from "../model/task.model";

export class TaskRepository {

    private logger: APILogger;
    private db: any = {};
    private taskRespository: any;

bbachi

import { Table, Column, Model, HasMany } from 'sequelize-typescript'

@Table
export class Tasks extends Model {
  
  @Column
  name: string

  @Column
  description: string

bbachi

import { Sequelize } from 'sequelize-typescript'
import { Dialect } from 'sequelize';
import { Tasks } from '../model/task.model';

export const connect = () => {

    const hostName = process.env.MYSQL_HOST;
    const userName = process.env.MYSQL_USER;
    const password = process.env.MYSQL_PASSWORD;
    const database = process.env.MYSQL_DATABASE;

bbachi

{
  "IsEncrypted": false,
  "Values": {
    "FUNCTIONS_WORKER_RUNTIME": "node",
    "AzureWebJobsStorage": "",
    "MYSQL_USER": "apidemo",
    "MYSQL_HOST": "azure-mysql-demo.mysql.database.azure.com",
    "MYSQL_PASSWORD": "Tester@321",
    "MYSQL_DATABASE": "tasks",
    "MYSQL_DIALECT": "mysql"

bbachi

CREATE TABLE TASKS(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           CHAR(100)    NOT NULL,
   DESCRIPTION          CHAR(500),
   CREATEDAT        DATE,
   UPDATEDAT         DATE,
   CREATEDBY          CHAR(50),
   UPDATEDBY          CHAR(50)
);