Views code generation about drift HOT 9 CLOSED

abstract class DynamicColumnsWithForeignKeys extends View {
  DynamicColumns get sourceDynamicColumns;
  DynamicColumns get targetDynamicColumns;
  DynamicTableForeignKeys get foreignKeys;

  Expression<int> get sourceId => sourceDynamicColumns.id;
  Expression<int> get sourceDynamicTableId => soure.dynamicTableId;

  @override
  Query as() => select([
        sourceId,
        sourceDynamicTableId,
        targetDynamicColumns.id,
        targetDynamicColumns.dynamicTableId,
        foreignKeys.id,
      ]).from(sourceDynamicColumns).join([
        leftOuterJoin(foreignKeys,
            foreignKeys.sourcePropertyId.equalsExp(sourceDynamicColumns.id)),
        leftOuterJoin(targetDynamicColumns,
            targetDynamicColumns.id.equalsExp(foreignKeys.targetPropertyId))
      ]);
}

// view.dart

import 'package:drift/drift.dart';
import 'package:persistence/src/database/models/dynamic_database/dynamic_database.dart';

abstract class DynamicColumnsWithForeignKeys extends View {
  DynamicColumns get sourceDynamicColumns;
  DynamicColumns get targetDynamicColumns;
  DynamicTableForeignKeys get foreignKeys;

  Expression<BigInt> get sourceColumnId => sourceDynamicColumns.id;
  Expression<BigInt> get sourceTableId => sourceDynamicColumns.dynamicTableId;
  Expression<BigInt> get targetColumnId => targetDynamicColumns.id;
  Expression<BigInt> get targetTableId => targetDynamicColumns.dynamicTableId;
  Expression<BigInt> get foreignKeyId => foreignKeys.id;
  Expression<BigInt> get relationId => foreignKeys.relationId;

  @override
  Query as() => select([
        sourceColumnId,
        sourceTableId,
        targetColumnId,
        targetTableId,
        foreignKeyId,
        relationId,
      ]).from(sourceDynamicColumns).join([
        leftOuterJoin(foreignKeys,
            foreignKeys.sourcePropertyId.equalsExp(sourceDynamicColumns.id)),
        leftOuterJoin(targetDynamicColumns,
            targetDynamicColumns.id.equalsExp(foreignKeys.targetPropertyId))
      ]);
}

// view.drift.dart

// ignore_for_file: type=lint
import 'package:drift/drift.dart' as i0;
import 'package:persistence/src/database/views/dynamic_columns_with_foreign_keys.drift.dart'
    as i1;
import 'package:drift/src/runtime/query_builder/query_builder.dart' as i2;

class DynamicColumnsWithForeignKey extends i0.DataClass {
  final BigInt? sourceColumnId;
  final BigInt? sourceTableId;
  final BigInt? targetColumnId;
  final BigInt? targetTableId;
  final BigInt? foreignKeyId;
  final BigInt? relationId;
  const DynamicColumnsWithForeignKey(
      {this.sourceColumnId,
      this.sourceTableId,
      this.targetColumnId,
      this.targetTableId,
      this.foreignKeyId,
      this.relationId});
  factory DynamicColumnsWithForeignKey.fromJson(Map<String, dynamic> json,
      {i0.ValueSerializer? serializer}) {
    serializer ??= i0.driftRuntimeOptions.defaultSerializer;
    return DynamicColumnsWithForeignKey(
      sourceColumnId: serializer.fromJson<BigInt?>(json['sourceColumnId']),
      sourceTableId: serializer.fromJson<BigInt?>(json['sourceTableId']),
      targetColumnId: serializer.fromJson<BigInt?>(json['targetColumnId']),
      targetTableId: serializer.fromJson<BigInt?>(json['targetTableId']),
      foreignKeyId: serializer.fromJson<BigInt?>(json['foreignKeyId']),
      relationId: serializer.fromJson<BigInt?>(json['relationId']),
    );
  }
  @override
  Map<String, dynamic> toJson({i0.ValueSerializer? serializer}) {
    serializer ??= i0.driftRuntimeOptions.defaultSerializer;
    return <String, dynamic>{
      'sourceColumnId': serializer.toJson<BigInt?>(sourceColumnId),
      'sourceTableId': serializer.toJson<BigInt?>(sourceTableId),
      'targetColumnId': serializer.toJson<BigInt?>(targetColumnId),
      'targetTableId': serializer.toJson<BigInt?>(targetTableId),
      'foreignKeyId': serializer.toJson<BigInt?>(foreignKeyId),
      'relationId': serializer.toJson<BigInt?>(relationId),
    };
  }

  i1.DynamicColumnsWithForeignKey copyWith(
          {i0.Value<BigInt?> sourceColumnId = const i0.Value.absent(),
          i0.Value<BigInt?> sourceTableId = const i0.Value.absent(),
          i0.Value<BigInt?> targetColumnId = const i0.Value.absent(),
          i0.Value<BigInt?> targetTableId = const i0.Value.absent(),
          i0.Value<BigInt?> foreignKeyId = const i0.Value.absent(),
          i0.Value<BigInt?> relationId = const i0.Value.absent()}) =>
      i1.DynamicColumnsWithForeignKey(
        sourceColumnId:
            sourceColumnId.present ? sourceColumnId.value : this.sourceColumnId,
        sourceTableId:
            sourceTableId.present ? sourceTableId.value : this.sourceTableId,
        targetColumnId:
            targetColumnId.present ? targetColumnId.value : this.targetColumnId,
        targetTableId:
            targetTableId.present ? targetTableId.value : this.targetTableId,
        foreignKeyId:
            foreignKeyId.present ? foreignKeyId.value : this.foreignKeyId,
        relationId: relationId.present ? relationId.value : this.relationId,
      );
  @override
  String toString() {
    return (StringBuffer('DynamicColumnsWithForeignKey(')
          ..write('sourceColumnId: $sourceColumnId, ')
          ..write('sourceTableId: $sourceTableId, ')
          ..write('targetColumnId: $targetColumnId, ')
          ..write('targetTableId: $targetTableId, ')
          ..write('foreignKeyId: $foreignKeyId, ')
          ..write('relationId: $relationId')
          ..write(')'))
        .toString();
  }

  @override
  int get hashCode => Object.hash(sourceColumnId, sourceTableId, targetColumnId,
      targetTableId, foreignKeyId, relationId);
  @override
  bool operator ==(Object other) =>
      identical(this, other) ||
      (other is i1.DynamicColumnsWithForeignKey &&
          other.sourceColumnId == this.sourceColumnId &&
          other.sourceTableId == this.sourceTableId &&
          other.targetColumnId == this.targetColumnId &&
          other.targetTableId == this.targetTableId &&
          other.foreignKeyId == this.foreignKeyId &&
          other.relationId == this.relationId);
}

class $DynamicColumnsWithForeignKeysView extends i0.ViewInfo<
    i1.$DynamicColumnsWithForeignKeysView,
    i1.DynamicColumnsWithForeignKey> implements i0.HasResultSet {
  final String? _alias;
  @override
  final i0.GeneratedDatabase attachedDatabase;
  $DynamicColumnsWithForeignKeysView(this.attachedDatabase, [this._alias]);
  // NOT AVAILABLE
  $DynamicColumnsTable get sourceDynamicColumns =>
      attachedDatabase.dynamicColumns.createAlias('t0');
  // NOT AVAILABLE
  $DynamicColumnsTable get targetDynamicColumns =>
      attachedDatabase.dynamicColumns.createAlias('t1');
  // NOT AVAILABLE
  $DynamicTableForeignKeysTable get foreignKeys =>
      attachedDatabase.dynamicTableForeignKeys.createAlias('t2');
  @override
  List<i0.GeneratedColumn> get $columns => [
        sourceColumnId,
        sourceTableId,
        targetColumnId,
        targetTableId,
        foreignKeyId,
        relationId
      ];
  @override
  String get aliasedName => _alias ?? entityName;
  @override
  String get entityName => 'dynamic_columns_with_foreign_keys';
  @override
  Map<i0.SqlDialect, String>? get createViewStatements => null;
  @override
  $DynamicColumnsWithForeignKeysView get asDslTable => this;
  @override
  i1.DynamicColumnsWithForeignKey map(Map<String, dynamic> data,
      {String? tablePrefix}) {
    final effectivePrefix = tablePrefix != null ? '$tablePrefix.' : '';
    return i1.DynamicColumnsWithForeignKey(
      sourceColumnId: attachedDatabase.typeMapping.read(
          i0.DriftSqlType.bigInt, data['${effectivePrefix}source_column_id']),
      sourceTableId: attachedDatabase.typeMapping.read(
          i0.DriftSqlType.bigInt, data['${effectivePrefix}source_table_id']),
      targetColumnId: attachedDatabase.typeMapping.read(
          i0.DriftSqlType.bigInt, data['${effectivePrefix}target_column_id']),
      targetTableId: attachedDatabase.typeMapping.read(
          i0.DriftSqlType.bigInt, data['${effectivePrefix}target_table_id']),
      foreignKeyId: attachedDatabase.typeMapping.read(
          i0.DriftSqlType.bigInt, data['${effectivePrefix}foreign_key_id']),
      relationId: attachedDatabase.typeMapping
          .read(i0.DriftSqlType.bigInt, data['${effectivePrefix}relation_id']),
    );
  }

  late final i0.GeneratedColumn<BigInt> sourceColumnId =
      i0.GeneratedColumn<BigInt>('source_column_id', aliasedName, true,
          generatedAs: i0.GeneratedAs(sourceDynamicColumns.id, false),
          type: i0.DriftSqlType.bigInt);
  late final i0.GeneratedColumn<BigInt> sourceTableId =
      i0.GeneratedColumn<BigInt>('source_table_id', aliasedName, true,
          generatedAs:
              i0.GeneratedAs(sourceDynamicColumns.dynamicTableId, false),
          type: i0.DriftSqlType.bigInt);
  late final i0.GeneratedColumn<BigInt> targetColumnId =
      i0.GeneratedColumn<BigInt>('target_column_id', aliasedName, true,
          generatedAs: i0.GeneratedAs(targetDynamicColumns.id, false),
          type: i0.DriftSqlType.bigInt);
  late final i0.GeneratedColumn<BigInt> targetTableId =
      i0.GeneratedColumn<BigInt>('target_table_id', aliasedName, true,
          generatedAs:
              i0.GeneratedAs(targetDynamicColumns.dynamicTableId, false),
          type: i0.DriftSqlType.bigInt);
  late final i0.GeneratedColumn<BigInt> foreignKeyId =
      i0.GeneratedColumn<BigInt>('foreign_key_id', aliasedName, true,
          generatedAs: i0.GeneratedAs(foreignKeys.id, false),
          type: i0.DriftSqlType.bigInt);
  late final i0.GeneratedColumn<BigInt> relationId = i0.GeneratedColumn<BigInt>(
      'relation_id', aliasedName, true,
      generatedAs: i0.GeneratedAs(foreignKeys.relationId, false),
      type: i0.DriftSqlType.bigInt);
  @override
  $DynamicColumnsWithForeignKeysView createAlias(String alias) {
    return $DynamicColumnsWithForeignKeysView(attachedDatabase, alias);
  }

  @override
  i0.Query? get query =>
      (attachedDatabase.selectOnly(sourceDynamicColumns)..addColumns($columns))
          .join([
        i2.leftOuterJoin(foreignKeys,
            foreignKeys.sourcePropertyId.equalsExp(sourceDynamicColumns.id)),
        i2.leftOuterJoin(targetDynamicColumns,
            targetDynamicColumns.id.equalsExp(foreignKeys.targetPropertyId))
      ]);
  @override
  Set<String> get readTables =>
      const {'dynamic_columns', 'dynamic_table_foreign_keys'};
}