View in drift files - specify bool

[Foxsterc]

Hi,

If I have a view, in a drift file, with a bool column how do I specify that it should be a boolean() when drift is generating the code?

.i.e: Column = is_favourite

Generates
isFavourite: attachedDatabase.typeMapping .read(DriftSqlType.string, data['${effectivePrefix}is_favourite']),

How do I output DriftSqlType.bool? For ints I have been casting to INTEGER in the view.

Many thanks,

[simolus3]

Does CAST(... as BOOL) work? Drift should pick up the hint and rewrite the cast to an integer when emitting the final SQL.

But also, can you post the query used in the view and perhaps the table definitions referenced therein? In most cases, drift should be able to infer the column type on its own. With more details I can look into why that didn't work here.

[Foxsterc]

Ah yes, that did it! If I use no casts they are all treated as Strings by default.

@DataClassName('Circuit')
class Circuits extends Table {
  IntColumn get apiId => integer()();
  IntColumn get setup => integer()();
  TextColumn get name => text().withLength(max: 100)();

  IntColumn get betaVideos => integer().withDefault(const Constant(0))();
  TextColumn get setbyId => text().withLength(max: 150)();
  TextColumn get setter => text().withLength(max: 150)();
  IntColumn get dateInserted => integer()();

  @override
  Set<Column> get primaryKey => {apiId};
}

@DataClassName('CircuitToConfiguration')
class CircuitToConfigurations extends Table {
  IntColumn get id => integer().autoIncrement()();
  IntColumn get circuit => integer()();
  TextColumn get grade => text().withLength(max: 25)();
  IntColumn get configuration => integer()();
  IntColumn get rating => integer()();
  IntColumn get repeats => integer()();
  TextColumn get comment => text().nullable().withLength(max: 150)();

  IntColumn get dateUpdated => integer().nullable()();
  IntColumn get benchMarkCreated => integer().nullable()();
  BoolColumn get isBenchmark => boolean().withDefault(const Constant(false))();
  BoolColumn get isCompetitionProblem =>
      boolean().withDefault(const Constant(false))();
  BoolColumn get isFavourite => boolean().withDefault(const Constant(false))();
}

@DataClassName('CircuitToProblem')
class CircuitToProblems extends Table {
  
  IntColumn get circuitId => integer()();

  IntColumn get problemId => integer()();

  IntColumn get order => integer().withDefault(const Constant(0))();
}

@DataClassName('BoardProblem')
class BoardProblems extends Table {
  IntColumn get apiId => integer()();
  IntColumn get setup => integer()();
  TextColumn get name => text().withLength(max: 100)();
  TextColumn get climbMethod => text().withLength(max: 150)();
  TextColumn get setbyId => text().withLength(max: 150)();
  TextColumn get setter => text().withLength(max: 150)();
  TextColumn get moves => text()();
  TextColumn get coordinates => text()();
  IntColumn get betaVideos => integer().withDefault(const Constant(0))();
  IntColumn get dateInserted => integer()();
  TextColumn get holdsets => text().withLength(max: 50)();

  @override
  Set<Column> get primaryKey => {apiId};
}

CREATE VIEW circuitsWithProblems AS
select  CAST(c.api_id as INTEGER) as apiId,
           c.name,
           c.setby_id as setbyid,
           c.setter,
           cast(c.beta_videos as INTEGER) as betavideos,
           CAST (c.date_inserted as INTEGER) as circuit_created,
           CAST (c.setup AS INTEGER) AS setup,
           CAST (ctc.configuration AS INTEGER) AS configuration,
           ctc.grade,
           CAST (ctc.rating as INTEGER) as rating,
           CAST (ctc.repeats as INTEGER) as repeats,
           ctc.comment,
           CAST(ctc.is_benchmark as BOOL) as isBenchmark,
           CAST(ctc.is_favourite as BOOL) as isFavourite,
           CAST(bp.api_id as INTEGER) as problemid,
           bp.holdsets,
           T.totalproblems

           
           
      from 
           circuits c
           inner join
           circuit_to_configurations  ctc on c.api_id = ctc.circuit
           inner join
           circuit_to_problems  ctp on c.api_id = ctp.circuit_id
           inner join 
           board_problems bp on ctp.problem_id = bp.api_id
           inner join (select CAST(circuit_id as INTEGER) as circuit_id, count(*) as totalproblems

from 

circuit_to_problems
group by circuit_id
) as T on c.api_id = T.circuit_id

[simolus3]

It generates the columns correctly for me, even without the casts.

Did you import the Dart files defining the tables into the drift file defining the view? Or do you see warnings from drift_dev when running build_runner?

[Foxsterc]

Ah! That's it I didn't import the Dart files defining the tables into the drift file. So, yes I did get warnings, I just thought I had to cast them, I must have missed that in the docs.

Thanks,