Schema name is ignored when building SQL Query (PostgreSQL)

[frankhorv]

Hey,
I'm trying to build a select query like this

let query = Query::select()
  .from(Table1)
  .left_join(
      Table2,
      Expr::tbl(Table1, Table1Column::ReferenceId)
          .equals(Table2, Table2Column::Id),
  )
  .and_where(Expr::col(Table1Column::AnotherId).eq(another_id))
  .to_owned();

The generated query looks like this

SELECT FROM "table1" LEFT JOIN "table2" ON "table1"."reference_id" = "table2"."id" WHERE "another_id" = 'c79de015-ae0e-40c7-b8c6-a3eb9fd39609'

But both tables Table1 and Table2 are located in their own schema like this

#[sea_orm(schema_name = "valid_schema_name", table_name = "table1")]
#[sea_orm(schema_name = "valid_schema_name", table_name = "table2")]

The query generator ignores the schema_name attribute.

[billy1624]

Hi @frankhorv, welcome!!

Can you try...

let query = Query::select()
  // Use `.table_ref()` here
  .from(Table1.table_ref())
  .left_join(
      // And here
      Table2.table_ref(),
      Expr::tbl(Table1, Table1Column::ReferenceId)
          .equals(Table2, Table2Column::Id),
  )
  .and_where(Expr::col(Table1Column::AnotherId).eq(another_id))
  .to_owned();

The table_ref() defined in EntityName trait

• https://docs.rs/sea-orm/0.4.0/sea_orm/entity/prelude/trait.EntityName.html#method.table_ref

[frankhorv]

Thank you for your help, that works for me!

[billy1624]

No problem!