To allow for more easily show what exactly is being selected.

To communicate to clients that they can safely cache GET results for some specified amount of seconds.

In real projects, of all but simplest complexity, model classes often relate to each other via one-to-one, one-to-many, or many-to many navigational properties.

Perhaps it would be a good idea to add a master-detail example to the project. Or at least some guidance, on where the best extensibility points are to implement models with navigational properties.

Thank you.

To avoid Windows unzip issues ...

Need to support filenames with "non valid" characters, to allow for uploading/downloading arbitrary files containing "funny characters".

To allow for also returning error through exceptions to client

Preferably different theme for read only CodeMirror instances, to separate them from other editors. Such as for instance in the "Endpoints" menu item, the result of invocations, etc ...

To rather use some sort of async logic, if possible

Not using dropdown to filter on client in requests among other things, since this requires loading every single public key in the system, which in theory might be a lot of keys.

To allow for choosing between ExecuteScalar, ExecuteNonQuery and ExecuteDataReader to create different types of results. This allows us to more easily return scalar values, null values (empty result) and tabular data (which is the only thing we support today).

To simplify code, try to refactor code such that it uses something else

To allow for memory based caching.

And hook into semantic log parsing such as "We successfully authenticated", etc - To count and group items according to types, in all different forms, to provide more high level data of what the log actually contains.

Psst, for those of you not having bought a license yet - https://servergardens.com/2019/11/28/black-friday-magic-sale/

All the usual rights applies, such as free support, free upgrades (in the 5.x version track), etc, etc, etc.

Wondering what you're getting ...?

https://dzone.com/articles/a-dynamic-task-scheduler-for-aspnet-core

This is useful since few users are using more than one database type. Not having to select a database type, across pageloads, becomes useful for these reasons

Such that you can override its "root folder", which by default would be the database name, but could be overridden to allow for making it a custom choice.

By componentizing it such that it's accessible through a modal dialogue.

In a few places throughout the code, while configuring services, there are calls like the following:

AppDomain.CurrentDomain.GetAssemblies()
                .SelectMany(s => s.GetTypes())

If I understand the intention correctly, you do not want types from all of the domain assemblies, perhaps limiting the call to your assemblies only is needed. Maybe something like this, instead:

AppDomain.CurrentDomain.GetAssemblies()
                .Where(a => a.FullName.Contains("magic."))
                .SelectMany(s => s.GetTypes())

HTH

And possibly also CSV, to allow for exporting items. Also consider creating import CSV and JSON files, somehow ...

Both in the scaffolded result and in the dashboard frontend, since it serves as an example of how to create charts in Magic.

It cause "-x seconds from now" due dates ...

Specifically its description, not its name

Such as a "filter by type" dropdown, etc. This can be achieved today by filtering on e.g. "info", but it's not entirely intuitive. Also implement the ability to delete single log entries, etc.

Such as [http.post], etc - To allow for passing ins streams to these which is useful for instance in combination with cryptography, etc

Which also creates a service method in the scaffolded Angular code, allowing you to invoke it from the frontend. Also make sure we're logging IP address of caller, in addition to username, if it's an authenticated user invoking the log endpoint.

I've had a lot of downloads, clones, etc the last couple of days due to my DZone article. I just wanted everybody to know that I am working on a release, which will be of more "stable character", and that I'll probably be done with this during the upcoming weekend.

Among some of its features, will be the "signals and slots" parts, refactored and significantly cleaned up code, in addition to a more generic and better "magic.test" module as an integral part, having unit tests for all submodules (auth, email, io and cookie).

If you're not 100% happy with its current code base, please just wait a couple of days, and hopefully I'll be able to make you happy :)

To allow for having the private key becoming more similar in nature to the existing authentication/authorisation - Possibly adding new column in roles table, containing slots allowed to invoke for caller, and appending these into [vocabulary] as we invoke a [whitelist] invocation cryptographically signed by some client.

I see the exception below in the console, the Setup page detail won't save either

info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[0] User profile is available. Using 'C:\Users\jslootweg\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest. Hosting environment: Development Content root path: C:\Work\magic\magic.backend Now listening on: http://localhost:63247 Application started. Press Ctrl+C to shut down. info: Microsoft.AspNetCore.Hosting.Diagnostics[1] Request starting HTTP/1.1 GET http://localhost:63247/ warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] Failed to determine the https port for redirect. info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Executing endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)' info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3] Route matched with {action = "Get", controller = "Endpoint"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.ActionResult] Get(System.String) on controller magic.endpoint.controller.EndpointController (magic.endpoint.controller).
info: Microsoft.AspNetCore.Mvc.StatusCodeResult[1]
Executing HttpStatusCodeResult, setting HTTP status code 404
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller) in 55.1595ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 209.46720000000002ms 404 text/html
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:63247/magic/modules/system/ping
info: Microsoft.AspNetCore.Cors.Infrastructure.CorsService[4]
CORS policy execution successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "Get", controller = "Endpoint"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.ActionResult] Get(System.String) on controller magic.endpoint.controller.EndpointController (magic.endpoint.controller). info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1] Executing ObjectResult, writing value of type 'Newtonsoft.Json.Linq.JObject'. info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2] Executed action magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller) in 82.8117ms info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)' info: Microsoft.AspNetCore.Hosting.Diagnostics[2] Request finished in 96.7008ms 200 application/json; charset=utf-8 info: Microsoft.AspNetCore.Hosting.Diagnostics[1] Request starting HTTP/1.1 GET http://localhost:63247/magic/modules/system/auth/authenticate?username=root&password=root info: Microsoft.AspNetCore.Cors.Infrastructure.CorsService[4] CORS policy execution successful. info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Executing endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)' info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3] Route matched with {action = "Get", controller = "Endpoint"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.ActionResult] Get(System.String) on controller magic.endpoint.controller.EndpointController (magic.endpoint.controller).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type 'Newtonsoft.Json.Linq.JObject'.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller) in 78.664ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 94.4521ms 200 application/json; charset=utf-8
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:63247/magic/modules/system/setup/load-config-file
info: Microsoft.AspNetCore.Cors.Infrastructure.CorsService[4]
CORS policy execution successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "Get", controller = "Endpoint"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.ActionResult] Get(System.String) on controller magic.endpoint.controller.EndpointController (magic.endpoint.controller). info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2] Executed action magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller) in 10.4389ms info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed endpoint 'magic.endpoint.controller.EndpointController.Get (magic.endpoint.controller)' fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1] An unhandled exception has occurred while executing the request. System.Security.SecurityException: Access denied at magic.lambda.auth.helpers.TicketFactory.VerifyTicket(ITicketProvider ticketProvider, String roles) at magic.lambda.auth.VerifyTicket.Signal(ISignaler signaler, Node input) at magic.signals.services.Signaler.Signal(String name, Node input) at magic.lambda.Eval.ExecuteAsync(ISignaler signaler, IEnumerable1 nodes)
at magic.lambda.Eval.SignalAsync(ISignaler signaler, Node input)
at magic.signals.services.Signaler.SignalAsync(String name, Node input)
at magic.endpoint.services.ExecutorAsync.<>c__DisplayClass8_0.<b__1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at magic.signals.services.Signaler.ScopeAsync(String name, Object value, Func1 functor) at magic.endpoint.services.ExecutorAsync.<>c__DisplayClass8_0.<<ExecuteUrl>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at magic.signals.services.Signaler.ScopeAsync(String name, Object value, Func1 functor)
at magic.endpoint.services.ExecutorAsync.ExecuteUrl(String url, String verb, IEnumerable1 args, JContainer payload) at magic.endpoint.services.ExecutorAsync.ExecuteGetAsync(String url, DateTime ifModifiedSince, IEnumerable1 args)
at magic.endpoint.controller.EndpointController.Get(String url)
at lambda_method(Closure , Object )
at Microsoft.Extensions.Internal.ObjectMethodExecutorAwaitable.Awaiter.GetResult()
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task) info: Microsoft.AspNetCore.Hosting.Diagnostics[2] Request finished in 102.3743ms 500 application/json

Read the details here

To allow for filtering files the same way endpoints can be filtered.

To allow for basic validation on input data during POST and PUT.

To allow for more easily see tables and columns as we create custom SQL. Implement both on "SQL" menu item in front end, and "Custom SQL" CRUDifier, at the bare minimum,

hi guys,
How can I define a pageable interface like "/api/controller?page=1&size=50"

Which informs the user to crudify his magic database, and/or generate a server key pair - Which checks the backend to see if the user has already done this, at which point the list items are hidden on a per item level.

The type of database should be a parameter, since there is way too much code repetition in the logic as it is now.

Also merge the slots for MySQL and MS SQL into one, taking the database type as a parameter, if possible ... (which might be difficult, but thinking about it ...)

Thery're currently in magic.lambda.slots, and magic.lambda.scheduler

But persist key as "disabled" until root accepts the key.

To allow for viewing results of invocations that doesn't return JSON.

Such as [http.get], [io.files.load], etc - To allow code to more easily handle raw byte[]

To allow for viewing results without having to use the mouse

That is created in the "magic" database during startup ...

It doesn't handle query parameters correctly, allowing for rich filtering in the GET verb

Maybe have a modal dialogue allowing user to add QUERY parameters ...?

These lots doesn't correctly apply short circuiting today, especially not the [and] slot

Through additional slot, that loads the file only the initial loading, for then to cache it upon consecutive requests of the same file. Use some sort of Dictionary<string, Node>, with thread synchronisation, to implement it ...

Which allows sys-admins to store frequently used SQL statements they need to perform to administrate system.

Yes, they're there ...