Documentation
¶
Overview ¶
Package writers provides interfaces and implementations for writing database schemas to various output formats and destinations.
Overview ¶
The writers package defines a common Writer interface that all format-specific writers implement. This allows RelSpec to export database schemas to multiple formats including:
- SQL schema files (PostgreSQL, SQLite)
- Schema definition files (DBML, DCTX, DrawDB, GraphQL)
- ORM model files (GORM, Bun, Drizzle, Prisma, TypeORM)
- Data interchange formats (JSON, YAML)
Architecture ¶
Each writer implementation is located in its own subpackage (e.g., pkg/writers/dbml, pkg/writers/pgsql) and implements the Writer interface, supporting three levels of granularity:
- WriteDatabase() - Write complete database with all schemas
- WriteSchema() - Write single schema with all tables
- WriteTable() - Write single table with all columns and metadata
Usage ¶
Writers are instantiated with WriterOptions containing destination-specific configuration:
// Write to file
writer := dbml.NewWriter(&writers.WriterOptions{
OutputPath: "schema.dbml",
})
err := writer.WriteDatabase(db)
// Write ORM models with package name
writer := gorm.NewWriter(&writers.WriterOptions{
OutputPath: "./models",
PackageName: "models",
})
err := writer.WriteDatabase(db)
// Write with schema flattening for SQLite
writer := sqlite.NewWriter(&writers.WriterOptions{
OutputPath: "schema.sql",
FlattenSchema: true,
})
err := writer.WriteDatabase(db)
Schema Flattening ¶
The FlattenSchema option controls how schema-qualified table names are handled:
- false (default): Uses dot notation (schema.table)
- true: Joins with underscore (schema_table), useful for SQLite
Supported Formats ¶
- dbml: Database Markup Language files
- dctx: DCTX schema files
- drawdb: DrawDB JSON format
- graphql: GraphQL schema definition language
- json: JSON database schema
- yaml: YAML database schema
- gorm: Go GORM model structs
- bun: Go Bun model structs
- drizzle: TypeScript Drizzle ORM schemas
- prisma: Prisma schema language
- typeorm: TypeScript TypeORM entities
- pgsql: PostgreSQL SQL schema
- sqlite: SQLite SQL schema with automatic flattening
Index ¶
Constants ¶
const ( // NullableTypeSqlTypes uses git.warky.dev/wdevs/relspecgo/pkg/sqltypes // (SqlString, SqlInt32, SqlVector, SqlStringArray, …). NullableTypeSqlTypes = "sqltypes" // NullableTypeStdlib uses the standard library database/sql nullable types // (sql.NullString, sql.NullInt32, …) and plain Go slices for arrays. NullableTypeStdlib = "stdlib" // NullableTypeBaselib uses plain Go pointer types for nullable columns // (*string, *int32, *time.Time, …) and plain Go slices for arrays. // No external imports are required beyond the standard library. This is the default. NullableTypeBaselib = "baselib" )
NullableType constants control which Go package is used for nullable column types in code-generation writers (Bun, GORM).
const ( // NullableArraysSlice represents every array column (nullable or not) as // a plain slice ([]string, []int32, …). SQL NULL and '{}' both scan into // a zero-length/nil slice, so callers cannot distinguish them. This is // the default. NullableArraysSlice = "slice" // NullableArraysPointerSlice represents nullable array columns as a // pointer to a slice (*[]string, *[]int32, …), so callers can // distinguish SQL NULL (nil pointer) from '{}' (pointer to an empty // slice). NOT NULL array columns are unaffected and remain plain slices. NullableArraysPointerSlice = "pointer_slice" )
NullableArrays constants control how nullable PostgreSQL array columns are represented in native-slice code-generation writers (Bun in stdlib/baselib mode).
Variables ¶
This section is empty.
Functions ¶
func QualifiedTableName ¶ added in v1.0.30
QualifiedTableName returns a schema-qualified table name. When flatten is true, schema and table are joined with underscore (e.g., "schema_table"). When flatten is false, they are dot-separated (e.g., "schema.table"). If schema is empty, just the table name is returned regardless of flatten.
func QuoteDefaultValue ¶ added in v1.0.38
func SanitizeFilename ¶ added in v1.0.7
SanitizeFilename removes quotes, comments, and invalid characters from identifiers to make them safe for use in filenames. This handles: - Double and single quotes: "table_name" or 'table_name' -> table_name - DBML comments: table [note: 'description'] -> table - Invalid filename characters: replaced with underscores
func SanitizeStructTagValue ¶ added in v1.0.8
SanitizeStructTagValue sanitizes a value to be safely used inside Go struct tags. Go struct tags are delimited by backticks, so any backtick in the value would break the syntax. This function: - Removes DBML/DCTX comments in brackets - Removes all quotes (double, single, and backticks) - Returns a clean identifier safe for use in struct tags and field names
Types ¶
type Writer ¶
type Writer interface {
// WriteDatabase takes a Database model and writes it to the desired format
WriteDatabase(db *models.Database) error
// WriteSchema takes a Schema model and writes it to the desired format
WriteSchema(schema *models.Schema) error
// WriteTable takes a Table model and writes it to the desired format
WriteTable(table *models.Table) error
}
Writer defines the interface for writing database specifications to various output formats at different granularity levels
type WriterOptions ¶
type WriterOptions struct {
// OutputPath is the path where the output should be written
OutputPath string
// PackageName is the Go package name (for code generation)
PackageName string
// FlattenSchema disables schema.table dot notation and instead joins
// schema and table with an underscore (e.g., "public_users").
// Useful for databases like SQLite that do not support schemas.
FlattenSchema bool
// NullableTypes selects the Go type package used for nullable columns in
// code-generation writers (bun, gorm). Accepted values:
// "sqltypes" — git.warky.dev/wdevs/relspecgo/pkg/sqltypes
// "stdlib" — database/sql (sql.NullString, sql.NullInt32, …)
// "baselib" (default) — plain Go pointer types (*string, *int32, …)
NullableTypes string
// NullableArrays selects how nullable PostgreSQL array columns are
// represented in native-slice code-generation writers (bun). Accepted values:
// "slice" (default) — plain slice for every array column
// "pointer_slice" — pointer-to-slice for nullable array columns,
// distinguishing SQL NULL from '{}'
// Has no effect in "sqltypes" NullableTypes mode, which always uses the
// SqlXxxArray wrapper types.
NullableArrays string
// Prisma7 enables Prisma 7-specific output for Prisma writers.
Prisma7 bool
// ContinueOnError instructs SQL writers to prepend `\set ON_ERROR_STOP off`
// to their output so that psql continues past errors instead of stopping.
ContinueOnError bool
// Additional options can be added here as needed
Metadata map[string]interface{}
}
WriterOptions contains common options for writers
Source Files
Directories