@jroblesc use
using SearchLight, Movies
using CSV
Base.convert(::Type{String}, _::Missing) = ""
Base.convert(::Type{Int}, _::Missing) = 0
Base.convert(::Type{Int}, s::String) = parse(Int, s)
function seed()
for row in CSV.Rows(joinpath(@__DIR__, "netflix_titles.csv"), limit = _000)
m = Movie()
m.type = row.type
m.title = row.title
m.directors = row.director
m.actors = row.cast
m.country = row.country
m.year = parse(Int, row.release_year)
m.rating = row.rating
m.categories = row.listed_in
m.description = row.description
save(m)
end
endand mentioned in the docs: https://genieframework.com/docs/tutorials/Developing-MVC-Web-Apps.html
Hi all, I wanted to share some quick Genie announcements:
1/ We have a new website and Genie.jl. docs: https://genieframework.com. Have a look and let us know what you think! We’re also working on docs for Stipple, so stay tuned for more updates in 4-6 weeks. :-)
2/ We’re moving the community to DISCORD. Many of you have suggested it, and we think it’s time. You can join our server here: https://discord.gg/9zyZbD6J7H. We’ll continue supporting Gitter for a while but we’d like to eventually centralize the community in one place. We hope to see you on Discord!
[ Info: Precompiling StippleUI [a3c5d34a-b254-4859-a8fa-b86abb7e84a3]
@essenciary I have a question on params(:action) ... it does not return the expected string 'edit" ? , It always return the function name ( "web_handler" in my case ) ?
sAction = params(:action)
println( "action: $sAction" ) .................. this display "action: web_handler"
Where sAction is a symbol, it is the controller function name (it is not what I expected as the passing string "edit") ??
Does :action is a special key word used by Genie ?
3 replies
9 replies
@essenciary following is my SQLSelect function: .... Please point me out to extract the error message
function SQLSelectTable( sSelect::String )::DataFrame
try
sTQuery::String = sSelect
oDf::DataFrame = SearchLight.query( sTQuery )
return oDf
catch ex
et = typeof(ex)
println( "type: $et" )
println( "ex: $ex" )
return ex
end
end
I fount that: (at above case)
type: MySQL.API.Error
ex: MySQL.API.Error(0x00000426, "Duplicate entry '1' for key 'gmessager.PRIMARY'")
How to extract 0x00000426 , "Duplicate entry '1' for key 'gmessager.PRIMARY'" ??
any function to extract the error:
1.) type
2.) code
3.) message
?
@essenciary following is my SQLSelect function: .... Please point me out to extract the error message
function SQLSelectTable( sSelect::String )::DataFrame
try
sTQuery::String = sSelect
oDf::DataFrame = SearchLight.query( sTQuery )
return oDf
catch ex
et = typeof(ex)
println( "type: $et" )
println( "ex: $ex" )
return ex
end
endI fount that: (at above case)
type: MySQL.API.Error
ex: MySQL.API.Error(0x00000426, "Duplicate entry '1' for key 'gmessager.PRIMARY'")How to extract 0x00000426 , "Duplicate entry '1' for key 'gmessager.PRIMARY'" ??
any function to extract the error:
1.) type
2.) code
3.) message
?
can you please use code formatting? It’s hard to read and propose solution
13 replies
@essenciary
I followed the instructions in the doc to create a new web service.
Genie.newapp_webservice("TestWeb")
For the first time the app is created and the server is up and running.
Next time I exit julia and go to the TestWeb directory and activate its environment.
and I call
loadapp(autostart=true)
The following messages are printed out and in the middle of, all of sudden, Julia dies.
Active env: DEV
Loading initializers
My Julia version info:
Julia Version 1.7.2
Commit bf53498635 (2022-02-06 15:21 UTC)
Platform Info:
OS: Windows (x86_64-w64-mingw32)
CPU: Intel(R) Core(TM) i7-6700K CPU @ 4.00GHz
WORD_SIZE: 64
LIBM: libopenlibm
LLVM: libLLVM-12.0.1 (ORCJIT, skylake)
Environment:
JULIA_DEPOT_PATH = D:.julia
JULIA_NUM_THREADS = 8
Genie v4.17.0 is being used.
Thank you!
5 replies
Hi @everywone, we've released new documentation for Stipple and SearchLight libraries. Make sure to check it out!
📝 Docs: https://genieframework.com/docs/
We hope the new docs will make it easier to build data apps & dashboards in low-code Julia.
We'll keep improving our documentation in the coming weeks - drop us a line if you'd like to contribute and help us make it better!
@essenciary following is my SQLSelect function: .... Please point me out to extract the error message
function SQLSelectTable( sSelect::String )::DataFrame
try
sTQuery::String = sSelect
oDf::DataFrame = SearchLight.query( sTQuery )
return oDf
catch ex
et = typeof(ex)
println( "type: $et" )
println( "ex: $ex" )
return ex
end
endI fount that: (at above case)
type: MySQL.API.Error
ex: MySQL.API.Error(0x00000426, "Duplicate entry '1' for key 'gmessager.PRIMARY'")How to extract 0x00000426 , "Duplicate entry '1' for key 'gmessager.PRIMARY'" ??
any function to extract the error:
1.) type
2.) code
3.) message
?
see what fieldnames the exception object has: fieldnames(typeof(ex)) -- and use the right one
Hi, I'm new to Genie. I was following the creating an MVC app documentation on the Genie website but when I got to this code julia> include(joinpath("db", "seeds", "seed_movies.jl")) and this other one
julia> seed()I get this error
ERROR: MethodError: Cannot `convert` an object of type PosLenString to an object of type Int64
Closest candidates are:
convert(::Type{T}, ::Base.TwicePrecision) where T<:Number at C:\Users\Dan\AppData\Local\Programs\Julia-1.7.2\share\julia\base\twiceprecision.jl:262
convert(::Type{T}, ::AbstractChar) where T<:Number at C:\Users\Dan\AppData\Local\Programs\Julia-1.7.2\share\julia\base\char.jl:185
convert(::Type{T}, ::CartesianIndex{1}) where T<:Number at C:\Users\Dan\AppData\Local\Programs\Julia-1.7.2\share\julia\base\multidimensional.jl:136
...
Stacktrace:
[1] setproperty!(x::Movie, f::Symbol, v::PosLenString)
@ Base .\Base.jl:43
[2] seed()
@ Main E:\JuliaProjects\WebDevelopment\Watchtonight\db\seeds\seed_movies.jl:17
[3] top-level scope
@ none:1Please help
using SearchLight, Movies
using CSV
Base.convert(::Type{String}, _::Missing) = ""
Base.convert(::Type{Int}, _::Missing) = 0
Base.convert(::Type{Int}, s::String) = parse(Int, s)
function seed()
for row in CSV.Rows(joinpath(@__DIR__, "netflix_titles.csv"), limit = _000)
m = Movie()
m.type = row.type
m.title = row.title
m.directors = row.director
m.actors = row.cast
m.country = row.country
m.year = parse(Int, row.release_year)
m.rating = row.rating
m.categories = row.listed_in
m.description = row.description
save(m)
end
end
constants.jl file in the initializers folder, but then I don't know how to make them available in any of the controllers. I understand it's available in UserApp, but importing UserApp in the controller won't work. Thanks in advance!
7 replies
https://youtu.be/0Q1dnufQXKM