Method createTableQuery

src/pg.ts:324–343

(
        table: SqlTable
    )

    }

    createTableQuery(
        table: SqlTable
    ): ExecutableSqlQuery {
        let line: string = table.columns.map(
            (c) => this.createColumnQuery(c)
        ).join(", ")

        if (table.foreignKey && table.foreignKey.length > 0) {
            line += "," + table.foreignKey.map(
                (fKey) =>
                    ` FOREIGN KEY(${fKey.columnName}) REFERENCES "${fKey.foreignTableName}" (${fKey.foreignColumnName}) ON DELETE CASCADE`
            ).join(",")
        }

        line = `CREATE TABLE IF NOT EXISTS "${table.name}"(${line})`

        return [
            line
        ]
    }

    dropTableQuery(
        table: SqlTable