Defer Foreign references during creation

[chrisjenx]

Just found this out the hard way today. There are no deferred references.

Take two tables:

object Images : UUIDTable() {
    val name = varchar("name", 120)
    val fileName = varchar("file_name", 1024)
    val userId = uuid("user_id").references(Users.id)
}

object Users : UUIDTable("users") {

    val email = varchar("email", 256).uniqueIndex()
    val firstName = varchar("first_name", 256)
    val lastName = varchar("last_name", 256)

    // Profile Image
    val profileImageId = uuid("profile_image_id").references(Images.id, ReferenceOption.SET_NULL).nullable()

}

We can never create these two tables as the current create* methods will sort them based on table dependences (which is really good). But doesn't take into account tables that reference each other.

Not sure if it's a good approach, or not, but I'm wondering if all foreign references should be left to the end of the create() process so that the tables can be created first so that all foreign references can be created?

[Wavesonics]

Just ran into this my self.

[Tapac]

Fixed in master. Now it's possible to create cycle-referenced tables.

[chrisjenx]

Awesome, nice one!

…

On Thu, 20 Sep 2018, 10:02 Andrey.Tarashevskiy, ***@***.***> wrote: Fixed in master. Now it's possible to create cycle-referenced tables. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#384 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABHRsTlf2ntkQbpbNb3JBBhUGVtM1tq_ks5uc7wrgaJpZM4WhxP-> .