tspace-mysql

tspace-mysql

tspace-mysql is an Object-Relational Mapping (ORM) tool designed to run seamlessly in Node.js and is fully compatible with TypeScript. It consistently supports the latest features in both TypeScript and JavaScript, providing additional functionalities to enhance your development experience.

Feature

Feature	Description
Supports Driver	MySQL ✅ / MariaDB ✅ / Postgres / ✅ MSSQL ⏳ / SQLite3 ⏳ / Oracle ⏳
Query Builder	Create flexible queries like SELECT, INSERT, UPDATE, and DELETE. You can also use raw SQL.
Join Clauses	Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN to combine data from multiple tables.
Model	Provides a way to interact with database records as objects in code. You can perform create, read, update, and delete (CRUD) operations. Models also support soft deletes and relationship methods.
Schema	Allows you to define and manage the structure of MySQL tables, including data types and relationships. Supports migrations and validation.
Validation	Automatically checks data against defined rules before saving it to the database, ensuring data integrity and correctness.
Sync	Synchronizes the model structure with the database, updating the schema to match the model definitions automatically.
Soft Deletes	Marks records as deleted without removing them from the database. This allows for recovery and auditing later.
Relationships	Set up connections between models, such as one-to-one, one-to-many, belongs-to, and many-to-many. Supports nested relationships and checks.
Type Safety	Ensures that queries are safer by checking the types of statements like SELECT, ORDER BY, GROUP BY, and WHERE.
Metadata	Get the metadata of a Model.
Repository	Follows a pattern for managing database operations like SELECT, INSERT, UPDATE, and DELETE. It helps keep the code organized.
Decorators	Use decorators to add extra functionality or information to model classes and methods, making the code easier to read.
Caching	Improves performance by storing frequently requested data. Supports in-memory caching (like memory DB) and Redis for distributed caching.
Migrations	Use CLI commands to create models, make migrations, and apply changes to the database structure.
Blueprints	Create a clear layout of the database structure and how models and tables relate to each other.
CLI	A Command Line Interface for managing models, running migrations, executing queries, and performing other tasks using commands (like make:model, migrate, and query).

Install

Install with npm:

# Install tspace-mysql locally for your project
npm install tspace-mysql --save

# Install tspace-mysql globally (optional)
npm install -g tspace-mysql

# Install database drivers if needed:
# For MariaDB
npm install mariadb --save

# For PostgreSQL
npm install pg --save

# MySQL2 driver is installed by default with tspace-mysql

Documentation

See the docs directory for full documentation.

Basic Usage

• Getting Started
  • Install
  • Configuration
• SQL Like
  • Select Statements
  • Insert Statements
  • Update Statements
  • Delete Statements
• Query Builder
  • Table Name & Alias Name
  • Returning Results
  • Query Statement
  • Select Statements
  • Insert Statements
  • Update Statements
  • Delete Statements
  • Raw Expressions
  • Ordering, Grouping, Limit and Offset
    • Ordering
    • Grouping
    • Limit and Offset
  • Joins
    • Inner Join Clause
    • Left Join, Right Join Clause
    • Cross Join Clause
  • Basic Where Clauses
    • Where Clauses
    • Or Where Clauses
    • Where cases
    • Where Object Clauses
    • JSON Where Clauses
    • Additional Where Clauses
    • Logical Grouping
  • Advanced Where Clauses
    • Where Exists Clauses
    • Subquery Where Clauses
    • Conditional Where Clauses
  • GetGroupBy
  • Paginating
  • Hook Statements
  • Faker Statements
  • Unset Statements
  • Common Table Expressions
  • Union
  • More Methods
• Database Transactions
• Race Condition
• Connection
• Backup
• Injection
• Model
  • Basic Model Setup
    • Table Name
    • Pattern
    • UUID
    • Timestamp
    • Debug
    • Observer
    • Logger
    • Hooks
    • Global Scope
  • Schema
    • Schema Model
    • Virtual Column
    • Validation
    • Sync
  • SoftDelete
  • Joins Model
    • Inner Join Model Clause
    • Left Join , Right Join Model Clause
    • Cross Join Model Clause
  • Relationships
    • One To One
    • One To Many
    • Belongs To
    • Many To Many
    • Relation
    • Deeply Nested Relations
    • Relation Exists
    • Relation Count
    • Relation Trashed
    • Built in Relation Functions
  • Cache
  • Decorator
  • Type Safety
    • Select Type Safety
    • OrderBy Type Safety
    • GroupBy Type Safety
    • Where Type Safety
    • Insert Type Safety
    • Update Type Safety
    • Delete Type Safety
    • Relationships Type Safety
    • Results Type Safety
  • Metadata
  • Audit
• Repository
  • Select Statements
  • Insert Statements
  • Update Statements
  • Delete Statements
  • Transactions
  • Relations
• View
• Stored Procedure
• Blueprint
• Cli
  • Make Model
  • Make Migration
  • Migrate
  • Query
  • Dump
  • Generate Models
  • Migration Models
  • Migration DB