anitnilay20 / anitnilay20/beatrix

Add PostgreSQL migration system

Aperta
#7 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub
high-priority migrations postgres
Lingua principale
Rust
Stelle
1
Fork
0
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

## Description
Implement a migration system for PostgreSQL to handle schema changes, version control, and database evolution.

## Requirements
- [ ] Create migration framework
- [ ] Support CREATE/ALTER/DROP TABLE operations
- [ ] Add migration versioning
- [ ] Implement rollback functionality
- [ ] Add CLI tools for migration management
- [ ] Write comprehensive tests

## Acceptance Criteria
- Users can create migrations: `beatrix migrate create add_user_table`
- Support for up/down migrations
- Track migration history in database
- Generate migrations from model changes

## Files to create
- `beatrix_cli/` (new crate)
- `beatrix_core/src/relational/migrations/`
- `beatrix_macro/src/migrations.rs`

## Example Usage
```rust
// CLI usage
beatrix migrate create add_users_table
beatrix migrate up
beatrix migrate down

// In code
Migration::new("add_users_table")
.create_table("users", |table| {
table.id();
table.string("name");
table.string("email").unique();
})
.run(&db).await?;
```

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.