Method selectQuery

src/pg.ts:396–426

(
        table: SqlTable,
        select: SqlResultColumnSelector = null,
        where?: SqlCondition,
        limit?: number | undefined,
        ...joins: SqlJoin[]
    )

    }

    selectQuery(
        table: SqlTable,
        select: SqlResultColumnSelector = null,
        where?: SqlCondition,
        limit?: number | undefined,
        ...joins: SqlJoin[]
    ): ExecutableSqlQuery {
        let line = `SELECT ${this.createSelectQuery(select)}`
        line += ` FROM "${table.name}"`
        if (joins && joins.length > 0) {
            joins.forEach((join) => {
                const tableName: string = join.as ? join.as : join.targetTable
                line += ` ${join.join ?? "INNER"} JOIN "${join.targetTable}"${join.as ? " " + join.as : ""}`
                line += ` ON "${tableName}".${join.targetKey} = "${join.sourceTable ?? table.name}".${join.sourceKey}`
            })
        }
        let values: any[] = []
        if (where && Object.keys(where).length > 0) {
            let i: [number] = [1]
            const whereData = this.createSqlWhereCondition(table.name, where, i)
            line += ` WHERE ${whereData[0]}`
            values = whereData.slice(1)
        }
        if (limit && limit > 0) {
            line += " LIMIT " + limit
        }
        return [
            line,
            ...values
        ]
    }

    deleteQuery(
        table: SqlTable,