DSQL ORM
An Experimental Dart ORM or Something Similar
Installation
dart pub global activate dsql
and add dsql to your pubspec.yaml
dependencies:
dsql: ^0.0.9+8
In the root, create a folder called migrations with your .sql file, like spring boot for example.
-- ./migrations/V1__create_users_table.sql
-- Entity => User
CREATE TABLE users (
id SERIAL PRIMARY KEY DEFAULT nextval('users_id_seq'),
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Then you can run the migrations command with the following command
dsql --migrate or -m
dsql -g -o /path/to/output
You will need to provide the database url to migrate and generate DSQL classes
DSQL CLI - Dart SQL Schema Generator
Enter your postgresSQL database URL: postgresql://user:password@host:port/database
Next steps:
- Add more SQL types (currently only VARCHAR, TEXT, UUID, BOOLEAN, INTEGER, DOUBLE, TIMESTAMP are supported)
- Add relationship between entities
- Add others drivers like MySQL, MSSQL, SQLite!
