How can I concatenate two columns?

[ghost]

I would like to concatenate two columns but all what I get are errors :-(

abstract class Bookings extends View {
  Companies get c;

  ProductionCompanies get pc;

  Projects get p;

  Events get e;

  Positions get p2;

  Contracts get c2;

  @override
  Query as() => select([
        c.firstName,
        c.lastName,
        // const CustomExpression<String>("companies.firstname || ' ' || companies.lastname as company"),
        p.projectName,
        e.shootingDay,
        c2.token,
        c2.lastName,
        c2.firstName,
        p2.checkIn,
        p2.checkOut,
        p2.role,
      ]).from(c).join([
        innerJoin(pc, c.companyId.equalsExp(pc.companyId) & c.companyDb.equalsExp(pc.companyDb)),
        innerJoin(p, pc.companyId.equalsExp(p.companyId) & pc.companyDb.equalsExp(p.companyDb)),
        innerJoin(e, p.projectId.equalsExp(e.projectId) & p.projectDb.equalsExp(e.projectDb)),
        innerJoin(p2, e.eventId.equalsExp(p2.eventId) & e.eventDb.equalsExp(p2.eventDb)),
        innerJoin(c2, p2.positionId.equalsExp(c2.positionId) & p2.positionDb.equalsExp(c2.positionDb)),
      ]);
}

For example, when I use this CustomExpression, I get:

[WARNING] drift_dev:drift_dev on lib/src/database/database.dart:
AnalysisException: Error: line 432, column 16 of package:repositories/src/model/db_models.dart: Table named `const CustomExpression<String>("companies` not found! Maybe not included in @DriftDatabase or not belongs to this database
    ╷
432 │ abstract class Bookings extends View {
    │                ^^^^^^^^
    ╵


[SEVERE] drift_dev:drift_dev on lib/src/database/database.dart:

AnalysisException: Error: line 432, column 16 of package:repositories/src/model/db_models.dart: Failed to parse view `as()` query
    ╷
432 │ abstract class Bookings extends View {
    │                ^^^^^^^^
    ╵


[WARNING] drift_dev:drift_dev on lib/src/database/dao.dart:
AnalysisException: Error: line 432, column 16 of package:repositories/src/model/db_models.dart: Table named `const CustomExpression<String>("companies` not found! Maybe not included in @DriftDatabase or not belongs to this database
    ╷
432 │ abstract class Bookings extends View {
    │                ^^^^^^^^
    ╵


[SEVERE] drift_dev:drift_dev on lib/src/database/dao.dart:

AnalysisException: Error: line 432, column 16 of package:repositories/src/model/db_models.dart: Failed to parse view `as()` query
    ╷
432 │ abstract class Bookings extends View {
    │                ^^^^^^^^
    ╵

[simolus3]

Columns added in as() should be simple references. I see that neither the docs nor the error message are particularly clear on this, I'll improve the UX here. The reason for that is that we need a name for the column, which we read from the getter.

So you can do

abstract class Bookings extends View {
  Companies get c;
  // ...

  Expression<String> get company => c.firstname + c.lastname;

  @override
  Query as() => select([
        c.firstName,
        c.lastName,
        company,
        p.projectName,
        e.shootingDay,
        c2.token,
        c2.lastName,
        c2.firstName,
        p2.checkIn,
        p2.checkOut,
        p2.role,
      ]).from(c).join([
        innerJoin(pc, c.companyId.equalsExp(pc.companyId) & c.companyDb.equalsExp(pc.companyDb)),
        innerJoin(p, pc.companyId.equalsExp(p.companyId) & pc.companyDb.equalsExp(p.companyDb)),
        innerJoin(e, p.projectId.equalsExp(e.projectId) & p.projectDb.equalsExp(e.projectDb)),
        innerJoin(p2, e.eventId.equalsExp(p2.eventId) & e.eventDb.equalsExp(p2.eventDb)),
        innerJoin(c2, p2.positionId.equalsExp(c2.positionId) & p2.positionDb.equalsExp(c2.positionDb)),
      ]);
}

[ghost]

this is my final company expression:

Expression<String> get company => c.firstName + const Constant(' ') + c.lastName;