MessyORM

MessyORM is a lightweight ORM for Node.js built on top of the Knex query builder. It provides a simple and intuitive API for interacting with your database. MessyORM currently supports multiple database clients, but you'll need to install the specific driver for your database manually.

Features

• Simple and easy-to-use API
• Supports multiple databases via Knex
• Flexible model configuration
• Future migration to TypeScript

Installation

Before using MessyORM, ensure that you've installed the necessary database drivers. For example, to use MySQL:

npm install mysql2
import {BaseModel,Column,Entity} from 'messyorm'


@Entity()
class User extends BaseModel {
    @Column()
    name:string






    static config = {
        client: 'mysql2',
          connection: {
              host: '127.0.0.1',
              port: 3306,
              user: 'your_username',
              password: 'your_password',
              database: 'your_database',
            },
    }
}
const test = async()=> {
  const data = await User.getAll({limit:1})
  console.log(data)
}
test()
you can not include columns static fields array it will get all columns
second example
@Entity()
class Order extends BaseModel {
    @Column({primary:true})
    orderNumber:string






    static config = {
        client: 'mysql2',
          connection: {
              host: '127.0.0.1',
              port: 3306,
              user: 'your_username',
              password: 'your_password',
              database: 'your_database',
            },
    }
}
  const orderData = await Orders.getOne({ where: { orderNumber: 10103 } });
  console.log(orderData);

relation example
@Entity('orders')
export class Order extends BaseModel {
    @Column({primary:true})
    orderNumber: number;

    @Column()
    orderDate: Date;

    @Column()
    requiredDate: Date;

    @Column()
    shippedDate?: Date;

    @Column()
    status: string;

    @Column()
    comments?: string;

    @Column()
    customerNumber: number;

    @Column()
    phone?: string;
    static config = {
        client: 'mysql2',
        connection: {
           host: '127.0.0.1',
            port: 3306,
            user: 'your_username',
            password: 'your_password',
            database: 'your_database',
        },
    };
}
@Entity('customers')
class Customer extends BaseModel {
    @Column({primary:true})
    customerName: string;
    @Column()
    customerNumber: number;
    @Relations(Order, 'customerNumber', 'customerNumber')
    orders: Order[];

    static config = {
        client: 'mysql2',
        connection: {
           host: '127.0.0.1',
            port: 3306,
            user: 'your_username',
            password: 'your_password',
            database: 'your_database',
        },
    };
}
const test = async () => {
    // const orders = await Order.getAll({ limit: 2 });
    // console.log('^^^^', orders);
    const customers = await Customer.getAll({
        relations: ['orders'],
    });
    console.log(customers.length);
    console.log(
        '%aaa%',
        customers[0].customerNumber,
        customers[0].orders[0].customerNumber
    );
    const affected=await Order.updateOne({where:{orderNumber:11114,},data:{status:'tttttt'}})
    console.log(affected);
      const deleted=await Order.delete({where:{orderNumber:11114,}})
    console.log(deleted);
     const inserted=await Order.insertAndFetch({orderNumber:12310
        ,customerNumber:103,status:'deliver'})
     console.log(inserted);
};
test();