pydbml

from pydbml import parse # Define a DBML string dbml_content = """ Project "MyProject" { database_type: 'PostgreSQL' Note: 'A simple example project' } Table "users" { id int [pk, increment] username varchar [unique, not null] email varchar [unique] created_at timestamp [default: `now()`] } Table "posts" { id int [pk, increment] title varchar [not null] content text user_id int [ref: > users.id] created_at timestamp [default: `now()`] } """ # Parse the DBML content try: parsed_dbml = parse(dbml_content) print("DBML parsed successfully.") # Render to SQL DDL sql_output = parsed_dbml.sql() print("\n--- Generated SQL ---") print(sql_output) # Optionally, render back to DBML (can differ slightly in formatting) dbml_output = parsed_dbml.dbml() print("\n--- Generated DBML (re-rendered) ---") print(dbml_output) except Exception as e: print(f"An error occurred during parsing or rendering: {e}")