dormql 0.3.0

dormql: ^0.3.0 copied to clipboard

Upcoming #

• ⏳ cassandra support

Upcoming #

• ⏳ improve select query API
• ⏳ add sql built-in functions
• ⏳ improve raw query API

Upcoming #

• ⏳ Support SSL for postgresql connection
• ⏳ Support SSL for mysql connection
• ⏳ Detect SQL injection in raw queries
• ⏳ improve support for stored procedures
• ⏳ Add support for custom types

Upcoming #

• ⏳ Integrate YAML file for connection configuration and environment variables
• ⏳ Add tests for migration and schema validation
• ⏳ Add MySQL package support
• ⏳ Add DTO generator

Completed #

• ✅ Add dormql_analyzer_plugin - Static analysis plugin for DormQL annotations
• ✅ Entity validation rules (missing ID, multiple IDs, ID type mismatch)
• ✅ @OneToOne relationship validation (target entity, mappedBy checks)
• ✅ Quick fixes for common issues (add ID field, remove nullable marker)
• ✅ Improved @OneToMany relationship - auto-resolve FK from target entity's @ManyToOne
• ✅ Improved @OneToMany relationship - auto-resolve target table from @Entity annotation
• ✅ Remove targetTable parameter from @OneToMany (now auto-resolved)
• ✅ Remove foreignKey parameter from @OneToMany (now auto-resolved from target's @ManyToOne)
• ✅ Better error messages when FK cannot be resolved
• ✅ Removed dbType from @Entity (database type is now derived from @Db's DbConfig)
• ✅ Extended @Id to support autoIncrement and strategy (including IDStrategy.uuid) with database-specific auto-increment handling

Completed #

• ✅ Add @OneToOne relationship annotation
• ✅ Add @PrimaryKey, @Unique, @ForeignKeyConstraint, @Check annotations
• ✅ Add validation for annotation column references (fails if column doesn't exist)
• ✅ Add Schema to SQL extensions (toCreateTableSql(), toCreateIndexSql(), etc.)
• ✅ Add SchemaManager for executing schema operations
• ✅ Add migration helper methods (createTable, addColumn, createIndex, etc.)
• ✅ Add createSchema() method to generated database class
• ✅ Add autoCreateSchema parameter to setup() method
• ✅ All schema operations use IF NOT EXISTS / IF EXISTS for idempotency
• ✅ Schema now generated as extension on entity (EntityNameSchema.schema)
• ✅ Database class references entity schemas (no duplication)
• ✅ Build order: entity → schema → db (proper dependency chain)
• ✅ Add generateSql parameter to @Db annotation
• ✅ Generate SQL files at .dart_tool/dorm/<db_name>.sql on build
• ✅ Versioned SQL files: <db_name>_v<version>.sql

Completed #

• ✅ Bring back part of directive in .orm.g.dart files for entity files
• ✅ Create @Db annotation and db generator for database class generation
• ✅ Generate repository extensions with singleton pattern
• ✅ Link schema generation to database level (not entity level)
• ✅ Add schema hash for change detection
• ✅ Fail initialization if schema changed but migration version not bumped
• ✅ Integrate DatabaseMigration with MigrationRunner

Breaking Changes #

• DatabaseMigration.Up() renamed to DatabaseMigration.up()
• DatabaseMigration.Down() renamed to DatabaseMigration.down()
• Schema is now generated at database level, not entity level

• Initial version.