janky | Continuous integration server built on top of Jenkins | Continuous Deployment library

I'm using ASP NET core 5.0 and using Pomelo to work with a MariaDB database

I have a stored procedure that takes a bunch of parameters and returns a SELECT COUNT(*), so a nice simple integer. I thought this would be fairly trivial to do, but it turns out it's actually really difficult

I can do an extremely ugly workaround by doing something like:

I working on a basic ncurses program and ran across this issue.

I am trying to call addch() without overwritten the following characters.

Basically, I want to be able to type out something like

"elp!"

Use the left cursor to move to the first position, and then type h in front of the current text to get

"help!"

Right now that behavior would result in

"hlp"

With the h overwriting the first character.

My code showing this issue:

I am building an app that has multiple pages. The problem is that I have a lot of Hero() widgets that I would like to animate between pages. I tried using the animation package's PageTransitionSwitcher but Hero() widgets don't animate with that. I have a wrapper at the root of my tree below the MaterialApp() and I route to either a log in screen, verification screen, and a home screen. The problem is if I route on the home screen it will replace the wrapper so I have resorted to having the home screen be an empty container that pushes a route above it which are the actual home screens, each having a bottomNavigationBar() that pushes a replacement to change screens with a fade animation while Hero()s animate.

The problem is that this approach is quite janky and I ran into a lot of problems because I have to have an empty widget that pushes a route then pop all routes in the wrapper when the auth state of the user changes. I was wondering if there is a better way to do this or a way to get route animations without actually routing the user.

Thanks for the help!

Edit: The current approach I had didn't work as it would randomly pop the pages when the user would update their profile. I have temporarily reverted back to the PageTransitionSwitcher() but I would like to know how I can use the navigator or use the Navigator's animation with my current setup.

I am in need of some help with chaining some filters involving has many through relationships. Some background:

1. I have a model called product. A product has many categories. Vice versa, a category can have many products.
2. I have a model called colours, A product can have many colours. These 2 are also linked via has many through relationships.

My main goal is to somehow be able to filter items based on category and colour. I am receiving input from the user via a form.This would mean doing something in the controller like

I'm writing a script to help update a small blog hosted on my website, but for some reason, when I request the HTML for the page, so that I can write it to memory and modify it, it seems to be spacing the lines out:

Expected:

So, I need to review some pages, and made a janky queue for efficiency. I have a CSV that needs to be opened to be read, and one to be written to. For each page I open from the read CSV, I call input(), and write some notes, so that they can be saved to the csv to be written to. Code below.

I am writing one bot and it needs to run multiple instances: first you input how many you want:

The only way I am aware of boosting audio past 100% with the Video JS library is to setup a slightly janky custom audio context with a gain node. This makes changing the playback rate not work. I understand that player.tech() is not really intended to be used but it seems like this is the only way to boost audio volume.

Is there something I am doing wrong here? If so what is the best way be able to both boost volume past 100 as well as control playback rate?

I have 10+ legacy VB6/VB.NET applications. They establish connections to databases (ODBC/Thick client). The connections strings are all just strings in the source, plain text. My current task is to remove all occurrences of the database's password; I'm trying to decide the best approach.

What I've gathered/decided thus far:

• Using just the app.config is not enough. The production DB password would then be in the appname.manifest.config on the user's machine.. in plain text! Unacceptable for my needs.

• Encryption/Decryption (app.config with ConfigurationManager .NET class) on the main load/close events is an option. Is it a good one? Tim Corey says don't do it.. ugh.

• I have all the DB passwords available on the IIS site that my web services use. They are stored in the connection strings (web.config) correctly. I am able to retrieve them from web services.. why shouldn't I use a web service to return the correct connection string? Because of security reasons - authorization and authentication.. is that solely it?

Use a web service call to return the database password, making sure your security is perfect?

Edit: You some real options when removing the password from your legacy database application:

• Just update your password and continue the cycle. Re-publish everything :(
• Refactor the code, and remove database operations out of the view section of your desktop code. Put it into a web-service. Do NOT write SQL within your views/forms at all costs!
• Use a web-service to return your connection string lol. Not great - works but not recommended unless you don't feel there are enough negatives with this solution. (Authen/Authorization/Hackers/its janky/etc)
• Use app.config and be OK with your password being in plain text. Optionally encrypt it. Salt + Hash would be GREAT! This is the ideal solution IMO if it wasn't such a huge task. <--