How to insert data with foreign key?

[jack24254029]

I have two tables.

class Profile extends Table {
  IntColumn get id => integer().autoIncrement()();

  IntColumn get uid => integer()();

  TextColumn get account => text()();

  TextColumn get name => text()();
}

class PhoneInfo extends Table {
  IntColumn get id => integer().autoIncrement()();

  IntColumn get profileId => integer().nullable().references(Profile, #id)();

  TextColumn get phone => text()();

  TextColumn get code => text()();

  IntColumn get prefix => integer()();
}

I have two ways to insert data;

final ProfileCompanion profileCompanion = ProfileCompanion.insert(uid: uid, account: account, name: name);
final int id = await into(profile).insert(profileCompanion);
final PhoneInfoCompanion phoneInfoCompanion = PhoneInfoCompanion.insert(profileId: Value<int>(id), phone: phone, code:code, prefix:prefix);
await into(phoneInfo).insert(phoneInfoCompanion);

final ProfileCompanion profileCompanion = ProfileCompanion.insert(uid: uid, account: account, name: name);
final PhoneInfoCompanion phoneInfoCompanion = PhoneInfoCompanion.insert(phone: phone, code: code, prefix: prefix);
final returns = await Future.wait([
  into(profile).insert(profileCompanion),
  into(phoneInfo).insertReturning(phoneInfoCompanion)
]);
final updatePhoneInfo = returns[1].copyWith(profileId: Value<int>(returns[0])).toCompanion(false);
await update(phoneInfo).replace(updatePhoneInfo);

Which is better or who has the better way?

[simolus3]

I would probably go for approach number 1, perhaps in a transaction if you care about atomicity.

Approach 2 is not more efficient (any positive effect Future.wait may have is cancelled out because you still have to run a query afterwards). And IMO approach 1 is more readable.

[jack24254029]

I can't agree with you more.