Function render_table

pydbml/renderer/sql/default/table.py:77–97

Returns full SQL for table definition: CREATE TABLE "countries" ( "code" int PRIMARY KEY, "name" varchar, "continent_name" varchar ); Also returns indexes if they were defined: CREATE INDEX ON "products" ("id", "name");

(model: Table)

@DefaultSQLRenderer.renderer_for(Table)
def render_table(model: Table) -> str:
    '''
    Returns full SQL for table definition:

    CREATE TABLE "countries" (
      "code" int PRIMARY KEY,
      "name" varchar,
      "continent_name" varchar
    );

    Also returns indexes if they were defined:

    CREATE INDEX ON "products" ("id", "name");
    '''
    result = create_components(model)

    if model.note:
        result += f'\n\n{model.note.sql}'

    result += render_column_notes(model)
    return result