https://kotlinlang.org logo
#exposed
Title
# exposed
s

SrSouza

07/26/2019, 8:21 PM
Hi guys, I'm using DAO and I have a Table in other database, how I can reference a column in this table that is in other database with Exposed?
I was think, using the Table name with the database as prefix would work? like this
object MyTableInOtherDatabase : Table("Database.my_table")
This dont work :S Table name that I use in exposed Table: server_global.jogadores createStatements output
Copy code
CREATE TABLE IF NOT EXISTS server_global.jogadores (id INT AUTO_INCREMENT PRIMARY KEY, uuid BINARY(16) NOT NULL, nickname VARCHAR(25) NOT NULL, nickname_lowercase VARCHAR(25) NOT NULL, register_date DATETIME(6) NOT NULL)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_uuid_unique UNIQUE (uuid)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_nickname_unique UNIQUE (nickname)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_nickname_lowercase_unique UNIQUE (nickname_lowercase)
The creates but the other commands I think that dont work, can you help me @tapac?
Exception:
t

tapac

07/27/2019, 8:05 PM
You want to make joins between different schemas?
s

SrSouza

07/28/2019, 5:26 PM
Exacly