Hello!
I am setting up GenieAuthorisation within a Genie App, I am setting up the 4 tables:
- CreateTableRoles
- CreateTablePermissions
- CreateTableRolesUsers
- CreateTablePermissionsRoles
within my module CreateTableRolesUsers, I want to declare a composed primary_key … I have tried different options, but nothing has worked so far, further more I get the Warning:
WARNING: could not import Migration.add_foreign_key into CreateTableRolesUsers
module CreateTableRolesUsers, looks like:
module CreateTableRolesUsers
import SearchLight.Migrations: create_table, column, primary_key, add_index, drop_table, add_foreign_key
function up()
create_table(:rolesusers) do
[
column(:user_id, :string)
column(:role_id, :integer)
primary_key([:user_id, :role_id])
]
end
add_foreign_key(:role_id, :roles, on_delete = :cascade)
add_index(:rolesusers, :role_id)
add_index(:rolesusers, :user_id)
end
function down()
drop_table(:rolesusers)
end
end
and the error I get is:
julia> CreateTableRolesUsers.up()
ERROR: MethodError: no method matching column_id(::Vector{Symbol})
Closest candidates are:
column_id()
@ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:350
column_id(::Union{String, Symbol})
@ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:350
column_id(::Union{String, Symbol}, ::Union{String, Symbol})
@ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:350
Stacktrace:
[1] (::Main.CreateTableRolesUsers.var"#1#2")()
@ Main.CreateTableRolesUsers /Users/ANHERN1/Documents/amh/EstadisticaProbabilidad/genie_workspace/project-sim/sim/db/migrations/2021061519532446_create_table_roles_users.jl:7
[2] create_table_sql(f::Main.CreateTableRolesUsers.var"#1#2", name::String, options::String)
@ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:336
[3] create_table(f::Function, name::Symbol, options::String)
@ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:329
[4] up()
@ Main.CreateTableRolesUsers /Users/ANHERN1/Documents/amh/EstadisticaProbabilidad/genie_workspace/project-sim/sim/db/migrations/2021061519532446_create_table_roles_users.jl:6
[5] top-level scope
@ REPL[125]:1
Any suggestions?
Thank you very much!