Investigate Postgres support

[aaronbushnell]

Hey @aaronbushnell, isolate is really good plugin... but I have problem with pgslq database, I assume you made sql queries for msyql, do you have in mind to build it for pgsql?

Originally posted by @Kreshimir in https://github.com/trendyminds/isolate/issues/3#issuecomment-491711278

[aaronbushnell]

@Kreshimir Are you having issues in Postgres? I believe all DB functionality is using the Craft API so it should be compatible with whatever Craft is.

[Kreshimir]

@aaronbushnell Yes, only with postgres
Error ->
SQLSTATE[42703]: Undefined column: 7 ERROR: column con.elementid does not exist
LINE 3: LEFT JOIN "content" "con" ON con.elementId=ent.id
^
HINT: Perhaps you meant to reference the column "con.elementId".
The SQL being executed was: SELECT "ent"."id", "con"."title", "sec"."handle", "con"."siteId"
FROM "entries" "ent"
LEFT JOIN "content" "con" ON con.elementId=ent.id
LEFT JOIN "sections" "sec" ON sec.id=ent.sectionId
WHERE "sec"."id"=7
ORDER BY "con"."title"

With mysql works perfect.
Any idea?

[aaronbushnell]

Very odd! I'll investigate as soon as possible

[Kreshimir]

@aaronbushnell thank you!

[etienneasselin]

Queries in postgres must be like

            ->from("{{%entries}} ent")
            ->leftJoin("{{%content}} con", '"con"."elementId"="ent"."id"')
            ->leftJoin("{{%sections}} sec", '"sec"."id"="ent"."sectionId"')
            ->filterWhere(['"sec"."id"' => $sectionId])
            ->orderBy('"con"."title"')
            ->all();`

[Kreshimir]

@etienneasselin works perfect, thanks :)

[Kreshimir]

@etienneasselin now I have problem with this query ->
$entries = $query
->select([
"ent.id",
"con.title",
"sec.handle",
"struc.level",
"con.siteId",
])
->from("{{%structureelements}} struc")
->leftJoin("{{%elements}} elems", "struc.elementId = elems.id")
->leftJoin("{{%content}} con", "con.elementId=struc.elementId")
->leftJoin("{{%entries}} ent", "con.elementId=ent.id")
->leftJoin("{{%sections}} sec", "sec.id=ent.sectionId")
->where(["struc.structureId" => $structure->id])
->andWhere("con.title IS NOT NULL")
->orderBy([
"lft" => SORT_ASC,
])
->all();
any idea?

[aaronbushnell]

Hello! We've moved all open Issues to Discussions.

Unfortunately, due to client workload we often find ourselves unable to implement new features or resolve issues in a timely manner. Switching to Discussions allows better categorization to separate "Feature Requests" from bugs. It also allows the community to better suggest/provide solutions when we're unable to do so.

Hope Isolate continues to be useful for you!