Sub Process_Globals
Public srvr As Server
Public sql As SQL
End Sub
Sub AppStart (Args() As String)
Log("Initializing SQL..")
srvr.Initialize("")
srvr.Port = 80
'Enable HTTPS on 443 using your keystore:
ConfigureSSL(443)
'srvr.StaticFilesFolder = File.Combine(File.DirApp,"/assets")
'Log("StaticFilesFolder: " & File.Combine(File.DirApp,"www"))
'Optional: redirect http -> https
srvr.AddFilter("/*", "HttpsFilter", False)
'Your virtual-host style router:
srvr.AddHandler("/*", "HostRouter", False)
srvr.Start
Log($"Listening on http:${srvr.Port} and https:${srvr.SslPort}"$)
StartMessageLoop
End Sub
Sub sql_Ready (Success As Boolean)
If Success = False Then
Log("DB connect failed: " & LastException.Message)
Return
End If
Log("DB connected!")
Insert_ActivityLog
End Sub
Sub Insert_ActivityLog
Dim q As String = _
$"INSERT INTO [dbo].[ActivityLog]
([AndroidID],[Module],[LocCode],[Role],[Event],[Result],[Timestamp])
OUTPUT INSERTED.[LogID]
VALUES (?,?,?,?,?,?,?)"$
Dim args As List = Array As Object( _
"test-android-id-123", _
"MarkTestServer", _
"NZ-WLG", _
"Admin", _
"Hello World From Mark Test Server", _
"OK", _
DateTime.Now _
)
Dim rs As ResultSet = sql.ExecQuery2(q, args)
If rs.NextRow Then
Log("Inserted LogID: " & rs.GetInt("LogID"))
End If
rs.Close
End Sub
Private Sub ConfigureSSL(SslPort As Int)
Dim ssl As SslConfiguration
ssl.Initialize
ssl.SetKeyStorePath("/ssl", "jetty.keystore")
ssl.KeyStorePassword = "*********"
ssl.KeyManagerPassword = "**********"
srvr.SetSslConfiguration(ssl, SslPort)
End Sub