One To Many Relation, Dart Flutter, Database Swagger Codegen

Hey guys,
I am currently working on an project where i have a objectA which consists of many objectB´s. A basic one to many relationship.
Here is some pseudo sql code of the table:

create table objectA ( id )
create table objectB ( id, objectA_id references objectA id)

create table objectA ( id )
create table objectB ( id, objectA_id references objectA id)

and i to create those types with the swagger codegen: https://pub.dev/packages/swagger_dart_code_generator (please do not mind syntax. the classes have the json serialization annotation correctly)

class ObjectA() {
  id,
  List<ObjectB> objectBs,
}
class ObjectB() {
  id
}

class ObjectA() {
  id,
  List<ObjectB> objectBs,
}
class ObjectB() {
  id
}

but the codegen is generating smth like this

class ObjectA() {
  id,
}
class ObjectB() {
  id,
  objectA_ID,
}

class ObjectA() {
  id,
}
class ObjectB() {
  id,
  objectA_ID,
}

which means an postgrest call in dart like this wouldn´t work because objectA.fromJson never reads the value ObjectB:

final response = await _supabaseClient
          .from('objectA')
          .select(
            '''
            *,
            objectB (
              *
            )
            ''',
          )
          .eq('id', id)
          .single()
          .execute();
final data = response.data as Map<String, dynamic>;
return ObjectA.fromJson(data);

final response = await _supabaseClient
          .from('objectA')
          .select(
            '''
            *,
            objectB (
              *
            )
            ''',
          )
          .eq('id', id)
          .single()
          .execute();
final data = response.data as Map<String, dynamic>;
return ObjectA.fromJson(data);

any reccomendations or best practices on how to solve this?

Dart packages

swagger_dart_code_generator | Dart Package

Have you been turned into a problem with writing code for Http requests? This package can help. It has all of the Http and model codegen functionality you have been looking for.

One To Many Relation, Dart Flutter, Database Swagger Codegen

Hey guys,
I am currently working on an project where i have a objectA which consists of many objectB´s. A basic one to many relationship.
Here is some pseudo sql code of the table:

create table objectA ( id )
create table objectB ( id, objectA_id references objectA id)

create table objectA ( id )
create table objectB ( id, objectA_id references objectA id)

and i to create those types with the swagger codegen: https://pub.dev/packages/swagger_dart_code_generator (please do not mind syntax. the classes have the json serialization annotation correctly)

class ObjectA() {
  id,
  List<ObjectB> objectBs,
}
class ObjectB() {
  id
}

class ObjectA() {
  id,
  List<ObjectB> objectBs,
}
class ObjectB() {
  id
}

but the codegen is generating smth like this

class ObjectA() {
  id,
}
class ObjectB() {
  id,
  objectA_ID,
}

class ObjectA() {
  id,
}
class ObjectB() {
  id,
  objectA_ID,
}

which means an postgrest call in dart like this wouldn´t work because objectA.fromJson never reads the value ObjectB:

final response = await _supabaseClient
          .from('objectA')
          .select(
            '''
            *,
            objectB (
              *
            )
            ''',
          )
          .eq('id', id)
          .single()
          .execute();
final data = response.data as Map<String, dynamic>;
return ObjectA.fromJson(data);

final response = await _supabaseClient
          .from('objectA')
          .select(
            '''
            *,
            objectB (
              *
            )
            ''',
          )
          .eq('id', id)
          .single()
          .execute();
final data = response.data as Map<String, dynamic>;
return ObjectA.fromJson(data);

any reccomendations or best practices on how to solve this?

Dart packages

swagger_dart_code_generator | Dart Package

Have you been turned into a problem with writing code for Http requests? This package can help. It has all of the Http and model codegen functionality you have been looking for.

One To Many Relation, Dart Flutter, Database Swagger Codegen

One To Many Relation, Dart Flutter, Database Swagger Codegen

Similar Threads

Similar Threads

Similar Threads