In recent version of chrome :
Navigate to : chrome://flags/#unsafely-treat-insecure-origin-as-secure
Add in textbox : https://localhost
I have the same error, have you solved it?
Have the same problem every time. Solved with File-SetPath, and move my path to the top of the list.
Today is better refering to the official documentation, which will be updated: https://github.com/cmderdev/cmder/wiki/Seamless-VS-Code-Integration
You can use tg://user?id={telegramUserId} but work this link only Telegram...
The $..[?(@.isFolder == false)].id expression is correct
Make sure that the response you're getting is valid JSON
More information: JMeter's JSON Path Extractor Plugin - Advanced Usage Scenarios
How to run TypeScript files from command line?
I think a quick Google search will lead you to this. The TL;DR is that Node.js can understand JavaScript, but not TypeScript.
Use npx ts-node src/foo.ts to convert and run the TypeScript file in one step, or do it in two steps with tsc (the first option is simpler).
As @PaulMcKenzie said, this error is easily avoided by running VsCode as an administrator
To run it as an administrator, you can double click VsCode and scroll down on the options until you find Run as administrator
Or to run it as an administrator all the time you can
From it will run as an administrator everytime you open the application
Try 'deno' instead of node, it has build in native typescript support, created by Ryan Dahl, the man who also created Node.js. However, it is not widely adapted even after 5 years on the run. Node still rules.
try '@shared/*' for path key and make sure your path is pointing to the correct dir
In my case, the solution was to not override the original decrypted file and create an encrypted new file flagged with ".locked" suffix.
Because to avoid this common error java.io.IOException: No matching key found for the ciphertext in the stream. the encrypted file should not be corrupted with a copy or rename.
The best solution to avoid multiple join operations seems to be:
Steps I Followed and which worked like a Charm were :
Setup your Firebase:
Setup Unity:
Add your TeamID from appstore connect to the field available under project setting of your Unity project
also check true auto init next to teamID field in project setting
use this code to init Firebase
private void Start()
{
Firebase.FirebaseApp.CheckAndFixDependenciesAsync().ContinueWith(task =>
{
var dependencyStatus = task.Result;
if (dependencyStatus == Firebase.DependencyStatus.Available)
{
Debug.Log("Firebase Init");
Firebase.Messaging.FirebaseMessaging.TokenReceived += OnTokenReceived;
Firebase.Messaging.FirebaseMessaging.MessageReceived += OnMessageReceived;
}
else
{
UnityEngine.Debug.LogError(System.String.Format(
"Could not resolve all Firebase dependencies: {0}", dependencyStatus));
}
});
}
#region FIREBASE MESSAGING
public void OnTokenReceived(object sender, Firebase.Messaging.TokenReceivedEventArgs token)
{
UnityEngine.Debug.Log("Received Registration Token: " + token.Token);
}
public void OnMessageReceived(object sender, Firebase.Messaging.MessageReceivedEventArgs e)
{
UnityEngine.Debug.Log("Received a new message from: " + e.Message.From);
}
#endregion
Make build after this
Setup Xcode :
if that don't prevent you to generarate what you want just don't waste your time trying to remove a warning without any impact on your work. This can turn to the worst in you mess with those packages. My 2 cents
Remove the fixed background color from NavHost to avoid issues with background layering during transitions. Use smooth transition animations to ensure screens fade in and out without leaving artifacts. Ensure proper state restoration when navigating back using navigateUp(). Check for navigation stack integrity to avoid UI inconsistencies.
To solve this you can run your Python script with the PYTHONPATH set to the foo directory, allowing Python to find bar.pyro from within foo:
$ PYTHONPATH=foo python3 bar/burp/cache.py
This tells Python to treat the foo directory as part of the module search path.
You could use relative imports. In your cache.py file:
from ..bar.pyro import explosion
def setup():
print('setting things up')
setup()
explosion()
Did you find the answer? Have the same problem :)
Tried this and worked for me flutter build apk --release --no-tree-shake-icons
tk aisnah v bukittinggi,tk cerdas ceria bukittinggi,tk aisyiyah 1 bukittingi,tk i.c.e islamic school bukittingi,tk ibnu sina bukitinggi,sd negeri 01 bukittinggi,sd negeri 02 bukittinggi,sd negeri 03 bukittinggi,sd negeri 04 bukittinggi,sd negeri 05 bukittinggi,smp negeri 1 bukittinggi,smp negeri 2 bukittinggi,smp negeri 3 bukittinggi,smp negeri 4 bukittinggi,smp negeri 5 bukittinggi,MAN 1 bukittinggi,Smk negeri 1 bukittinggi,sma negeri 3 bukittingi,sma IT alkatsar islamic school,sma negeri 5 bukittinggi
I really confused on this while im using the below
FROM python:3.12-slim
WORKDIR /Fdep
RUN mkdir ~/.ssh/
COPY /Fdep/id_rsa /root/.ssh/id_rsa
RUN chmod 400 /root/.ssh/id_rsa
RUN ssh-keyscan -H "bitbucket.org" >> ~/.ssh/known_hosts
it shows ssh-keyscan: not found when using python:3.12 it works fine is while installing that version also install SSH ?
The solution was to use the sample rate like the current microphone. The sample rate of my MacBook Pro mic is 48000 so I had to change it in the Python script:
fs = 48000
model = vosk.Model(lang="en-us")
recognizer = vosk.KaldiRecognizer(model, fs)
As mentioned in the top answer, if you want to share state between different components, you should lift the state up to their common parent. https://github.com/houpjs/houp can help you implement this quickly.
I met the same issue and found this https://medium.com/front-end-weekly/solve-breakpoint-ignored-with-visual-studio-code-vscode-1-19-chrome-debugger-6d484c88b829 it worked
I added this to launch.json. "sourceMapPathOverrides": {"*": "${workspaceFolder}/src/*"}
my file launch.json
{
"version": "0.2.0",
"configurations": [
{
// "command": "npm run start:dev",
"runtimeExecutable": "npm",
"runtimeArgs": ["run", "start:debug"],
"name": "Run npm start",
"request": "launch",
"type": "node",
"sourceMaps": true,
"console": "integratedTerminal",
"sourceMapPathOverrides": {
"*": "${workspaceFolder}/src/*"
}
}
]
}
it doesn't work when the character is not English. I tried for persian and it didn't work. what should I do?
i also have the problem when i install kats module, after try install a older packaging, such as "pip install packaging==21.0", i sovled my problem. hope helpfull.
enter image description here the sequence of args should be same with constructor. for me i swith the entranceFee and coordiantorAddress then it works!
My g tag was being overlapped by another g tag (checked in developer tools) ,so when i put style pointer-events: none; in the g tag that was overlapping the issue is resolved
Please check that the email address of the user registered at the IDP is the same one registered in Snowflake. They must be the same. And it is email address not username.
Normally, you can use the windows key + number key to switch between instances same app. It works on Windows 10 perfectly, in Windows 11 sometime the OS cannot response well, I think MS need to fixed this bug next time.
Case (IIf(ActiveCell.Value Like "*string*", ActiveCell.Value, ""))
Unconventional, but when I want to quickly compile a qt c++ file I high jack with pkg-config --list-all | grep qt5 then use , for example,
eval gcc file.cpp $(pkg-config --cflags --libs avahi-qt5)
As of my knowledge using DropdownButtonFormField we can't achieve it. we can make it by our own using overlay widget and some extra codes but it's a lot of work.
I found a package Drop Down 2 in pub.dev, you can use it to achieve the same much easier.
Try this,
select name from v$services;
After upgrading flutter version its want to sdk also update pubsec yaml sdk: ^3.6.0
take backup your android,ios folder then delete that
flutter create . (it will generate your android ,ios ,web and others as well)
check your manifest file it will comes as its then run if its shows error midsdk 34 like change as per your project need it will solve issues
sometimes the app size will big.
ANOTHER WAY: If your working local projects create new project copy paste your lib folder to new project same as well add your pubspecyaml also. It is simple way to solve issues.
i have the same issue , did u solve it ?
It seems like the issue you are encountering is related to the timing of service registration during the restart of your consumer service. When you restart the consumer service, the service might not have successfully registered or discovered the provider service at the time the request is made. This can result in the error No provider available for the service XXXX.
A possible cause could be that Spring Cloud or Nacos is still in the process of discovering and registering the services, which leads to the temporary unavailability of the provider when the consumer service tries to make a call. This is especially common if there’s a delay in the consumer service attempting to connect immediately after a restart.
Here are some steps you can try to mitigate the issue:
Service Dependency Delay: Introduce a delay or retry mechanism in the consumer service startup, allowing enough time for the provider services to register with Nacos before the consumer attempts to make any RPC calls.
Service Registration Check: Ensure that the Nacos registry has completely registered the provider services before the consumer starts invoking them. This can be checked by looking into the Nacos dashboard or logs.
Graceful Restart Handling: Consider using a graceful restart approach for your consumer service. This would ensure that the consumer waits until the provider services are up and available before making any requests.
Check Nacos Configuration: Ensure that your Nacos service discovery configuration is optimal and that the registration and deregistration are happening in the correct sequence.
Logging and Monitoring: Implement more detailed logging to monitor the service registration status in both the consumer and provider services during the restart process, helping you identify the root cause more effectively.
By refining these aspects, you should be able to reduce or eliminate the occurrence of these exceptions during the consumer service restart.
Create a global function
void hideKeyboard(PointerDownEvent event) {
FocusManager.instance.primaryFocus?.unfocus();
}
Then use it in any textFields
CupertinoTextField(
onTapOutside: hideKeyboard,
),
Our OPC UA Cient SDK discovers custom types at runtime, and can decode them. So you can access individual fields from code, or convert it to JSON formatted text. But it is in C++, not Go. https://onewayautomation.com/opcua-sdk
Remove RCT-Folly.common manually from pods within xcode and then try to make build.
It turns out I needed to first install Java. Here is the final snippet that worked:
- name: gcr.io/cloud-builders/npm
entrypoint: bash
dir: edcloud/cloud-function/${_PROJECT_NAME}
args:
- -c
- |
apt-get update && apt-get install -y openjdk-11-jdk
npm install -g firebase-tools
npm install
firebase emulators:exec --project $PROJECT_ID 'npm test'
A better solution is that you can use the boost-udp library instead of QUdpsocket. Try it out.
The issue seems to be with the segment you are passing. In the MUI documentation, segment paths are typically written without a leading forward slash (/).
Try using:
segment: 'dashboard/review-files'
Similar to @Cataurus !! bind handler with picker !!
private async void Button_Click_Choose_Left_Folder(object sender, RoutedEventArgs e)
{
var folderPicker = new FolderPicker();
// 获取当前窗口的句柄(在 WinUI 或桌面应用中)
IntPtr hwnd = System.Diagnostics.Process.GetCurrentProcess().MainWindowHandle;
// 将文件夹选择器与窗口句柄关联
WinRT.Interop.InitializeWithWindow.Initialize(folderPicker, hwnd);
folderPicker.SuggestedStartLocation = PickerLocationId.PicturesLibrary;
...
var folder = await folderPicker.PickSingleFolderAsync();
}
Using a timer to run an executable file at a specific time
Lee, Cheul Woo
Usually, you use the Windows Task Scheduler to run an executable file at a specific time or when a specific event occurs. This article introduces a code that uses a timer in a program to run an executable file at a specific time.
The static function below is called when a timer event occurs. The parameter settingTime is a specific time, the parameter now is the current time, the parameter period is the timer cycle, and the parameter processPath is an executable file.
private static void CheckTime(TimeOnly settingTime, TimeOnly now, TimeSpan period, string processPath)
{
if (now < settingTime)
{
var diff = settingTime - now;
if (diff > period)
{
}
else
{
// To-Do.
System.Diagnostics.Process.Start(processPath!);
}
}
}
The To-Do section of the code above makes a specific executable file run. You can put the tasks you want to do in this section.
VS Code's integrated terminal populates environment variables on startup by sourcing the shell configuration files relevant to the terminal's shell type (e.g., Bash, Zsh, PowerShell). When you open the terminal, it executes the startup files like .bashrc or .zshrc (on Unix-based systems) or $PROFILE (on Windows for PowerShell). These files define environment variables, including custom paths, user-specific variables, or system-wide configurations. VS Code also provides the ability to customize environment variables specifically for the integrated terminal through settings in settings.json or by using the terminal.integrated.env.* settings to ensure a tailored environment that can differ from the system's global environment.
I have tried with: "vite": "^6.0.5" and vite@latest.
but even setting base:'' sets always a slash(/) before the folder/filename like so:
<link rel="stylesheet" crossorigin="" href="/assets/main-DKYW8OEW.css">
what i want is:
<link rel="stylesheet" crossorigin="" href="assets/main-DKYW8OEW.css">
Requirement to know data types before compilation is too restrictive in my opinion. Our C++ SDK discovers custom data types at runtime: https://onewayautomation.com/opcua-sdk
So this fix is to make the class injectable by annotating it with @Injectable(), put it at the top of the class
I had the same issue. There were multiple "libiomp5md.dll" files inside the environment, one in the root of the environment folder and another in lib\site-packages\torch\lib. I deleted the libiomp5md.dll in the root folder, and it started working fine.
if you hover over the hot reload icon with your mouse it's gonna show you the active shortcut for it and to change it you can go to setting > keymap > main menu > Run/Debug
In my case, I have some breakpoints in DOM Breakpoints, you need to remove them to void enter debug mode, you can see below image
@APB Reports provides a good answer. I also come across this issue, you have to adjust the padding of your view and the width of your marks (more so than normal).
Here is my example: Bullet Chart - Vega-Lite
You can also achieve responsive behaviours in PowerBI's Deneb by multiplying marks or other elements by the container height and width:
Config:
{
"padding": {
"left": 20,
"right": 20,
"top": 20,
"bottom": 20
}
}
"dx": {"expr": "width * - 0.01"},
"dy": {"expr": "height * 0.01"}
Set the header no-cache on the path that you want.
module.exports = {
headers: () => [
{
source: '/:path*',
headers: [
{
key: 'cache-control',
value: 'no-cache',
},
],
},
],
}
Further to @SeaSky what worked for me:
sudo dnf install python3.11 -y
sudo dnf install python3.11-pip -y
sudo dnf groupinstall "Development Tools"
sudo dnf install mysql-community-devel gcc python3.11-devel
pip install mysqlclient
The answer given by @fuyushimoya is very poor quality and does not work the way you intended. If you actually wanted to sync them, you would have to ensure the value gets updated on input in either textarea.
<html>
<head>
<title>Live Text Sync</title>
<meta charset="utf-8" />
</head>
<body>
<textarea id="a"></textarea>
<textarea id="b"></textarea>
<script>
var a = document.getElementById("a");
var b = document.getElementById("b");
a.oninput = function(e) {
b.value = a.value;
}
b.oninput = function(e) {
a.value = b.value;
}
</script>
</body>
</html>
Use -exclude-secrets flag: aztfexport has an option to exclude secrets from the exported Terraform configuration. By default, it includes all the data in the exported files. To automatically exclude secrets, use the -exclude-secrets flag when running the tool.
Example command:
aztfexport -subscriptionId -exclude-secrets -outputDirectory ./output
But if we have to update the key value secret from library variable group to Key vault is that possible ? As we did this without masking value in library variable group. As we some requirement which required those value present to run data factory first
If you are connecting via an office network. It is possible the DNS resolution is being blocked. Try using the standard uri connection string without srv from mongodb atlas website.
How to get standard URI connection string (without srv) on mongodb website with current update?
How to Make RocketChat Talk to Your Ticket System: A Practical Guide Good news - you can connect these systems using webhooks, and while it requires some setup, it's quite manageable. Here's how:
Set Up RocketChat Webhook: Configure RocketChat to notify your ticket system when something important happens - think of it as setting up a digital messenger between the two systems. Choose Your Integration Method: You need something to translate between RocketChat and your ticket system. You've got options:
n8n: An open-source tool that connects different systems like digital building blocks Node-RED: Similar, but with a more user-friendly interface Custom Script: For those who prefer total control over their integration
Security Setup:
Add authentication tokens to your webhook Secure your API connections Because keeping your system secure is just common sense!
Implementation Steps:
Deploy your chosen solution on your local network Configure the webhook to send relevant chat data Set up the connection to your ticket system's API Test thoroughly before going live
Why This Approach Works:
Keeps your data within your network Gives you complete control over the process Saves money (since you're using open-source tools)
The end result? Two systems working together smoothly and efficiently. No external services required, just a straightforward, secure integration that gets the job done. Remember to test everything thoroughly before rolling it out - better safe than sorry when it comes to system integrations!
There is an example of CRUD operations using NextJS and Couchbase in this repository, it should help you get started.
https://github.com/couchbase-examples/nextjs-capella-quickstart
IM-COOL-BOOY-FM 📻✨
🔰 SL Android Official ™
👨💻 Developed by IM COOL BOOY
Welcome to IM-COOL-BOOY-FM a powerful Python-based radio station player.This tool is designed to allow users to easily search for, play, switch, and stop radio stations from around the world.Powered by the Radio Browser API and VLC Media Player, it provides a seamless and enjoyable listening experience with a modern,colorful CLI interface.👨💻
📦 Installation Instructions:⬇️⬇️⬇️
⬇️⬇️To get started with IM-COOL-BOOY-FM, follow these steps:⬇️⬇️
1️⃣ pkg install vlc
📦 Install the package via pip:⬇️⬇️
2️⃣ pip install IM-COOL-BOOY-FM
🚀 Quick Start:⬇️⬇️⬇️
Explore and enjoy worldwide radio stations with simple commands ⬇️
⬇️⬇️ Run the program to get started
1️⃣ IM-COOL-BOOY-FM
Once installed, you can access the tool's help and start using it with the following command:⬇️⬇️⬇️
3️⃣ IM-COOL-BOOY-FM -h
🔰🔰🔰🔰🔰🔰🔰🔰🔰🔰🔰🔰🔰🔰🔰
We chaged the IP tables at Host machine which effected the docker networking so simply restart the docker service resolved my problem.
Just use the contentShape(_:_:eoFill:) initializer, making sure to specify a ContentShapeKinds of .contextMenuPreview:
.contentShape(.contextMenuPreview, RoundedRectangle(cornerRadius: 10))
Create new ssh key using ssh keygen and Personal access token. This will solve the error and give you access.
As the project manager for SCons I don't recommend this. It's not supported usage.
Your app has been rejected by the Google team for two reasons:
Login Credentials: You must provide active and working credentials for the Google team to log into your app. If you've already provided credentials, ensure they are correct.
App Crashing: The application crashes upon launch. This crash might be due to a version mismatch between the submitted app and the previous one. Check Firebase Crashlytics for crash details if Firebase is implemented. Otherwise, review the Google Pre-launch report in the Play Console.
Additionally, keep in mind that both app bundles are being reviewed. If you want only one bundle reviewed, roll out the desired bundle to 100% of users across all selected countries for Internal, Beta, and Production testing.
Lets assume for a minute that the URL is correct (because that is a ridiculous blame) and that the https: address is correct (because, are you imagining that I am an idiot?) The problem is the SSH key and how do I check and correct whatever is wrong.
Port 8080 needs to be opened on the tomcat host machine.
In this instance the host machine was a macbook.
echo "pass in proto tcp from any to any port 8080" | sudo pfctl -ef -
This line was ran in the terminal to open the port on the machine and connection was then allowed.
Use <scope>system</scope> in jar <dependecy></dependency>,
please reference (https://stackoverflow.com/a/28958317/4573839).
2025/Python/FlaskIntro
[09:20]❯ python3 -m venv .venv
2025/Python/FlaskIntro
[09:20]❯ . .venv/bin/activate.fish
2025/Python/FlaskIntro [🐍 v3.13.1(.venv)]
[09:21]❯ pip install Flask
Collecting Flask
Downloading flask-3.1.0-py3-none-any.whl.metadata (2.7 kB)
I tried all the files in venv/bin folder and the above command worked.
Cause of the problem: I was using fish shell.
If you are using dokesh's lightbox then the anchor link needs to have data-title="My caption". That data-title in the anchor link triggers the elimination of display:none or display:hidden in the code and the caption will then show.
=> in design view remove any crystal report viewer control if placed and put below code
<div id="divPDFView" runat="server" >
</div>
=> Dont forget to create folder "PDFExports" in root
=> Just call below function to show report. (Replace values with your values where '?' is placed and report should be in folder named "Reports" )
private void ShowReport()
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "?ReportName.rpt"));
//@@: Record Selection formula
//rd.RecordSelectionFormula = "???";
rd.SetDatabaseLogon(?UserId, ?Password, ?DbServer, "");
//@@: Parameters
//rd.SetParameterValue("cpf_1", ""); //String
//rd.SetParameterValue("cpf_2", Convert.toInt32("1")); //Int
//@@: Parameters to Subreport
//rd.SetParameterValue("cpf_????", "", rd.Subreports[0].Name);
//@@: Set Title
//rd.SummaryInfo.ReportTitle = "Report as on " + DateTime.Today.Day + "-" + DateTime.Today.Month + "-" + DateTime.Today.Year;
//I use it for unique file names.. you can avoid it..
Guid g = Guid.NewGuid();
string strFileName = "?zReportName_" + DateTime.Now.ToString("yyyyMMdd-HHmmss") + "_" + Session["userId"].ToString() + "_" + g.ToString() + ".pdf";
rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Path.Combine(Server.MapPath("~/PDFExports"), strFileName));
divPDFView.InnerHtml = "<object data=\"PDFExports/" + strFileName + "\" type=\"application/pdf\" width=\"1230\" height=\"880\"> alt : <a href=\"PDFExports\\a.pdf\">PDF File</a> </object>";
rd.Dispose();
rd.Close();
}
I think Elysiajs doesn't have a plugin that serves folders, but you can see an example of making a bun file server in this repository or use the http-server from nodejs
Extracting data from low-resolution or scanned graphs can be tricky, but there are tools to help. For example, free plot digitizer (SplineCloud.com) is an excellent option for extracting data points, including those from graphs with logarithmic scales. It's easy to use and supports various graph types, making the process much simpler.
To add custom toolbar on SALV, you need to do these following steps:
You can check the steps more detail here: adding custom toolbar on SALV.
I encountered the same issue and managed to proceed by using a thread pool.
For example:
celery -A app worker --loglevel=info --pool threads
This approach is suitable for debugging purposes. You might need to dig deeper on the tasks being executed by the workers
This is a UI bug which may occur if you:
solutions:
If you have a fix, here's information about contributing to pandas.
If you don't want to contribute, the best way would be to validate input in application code to avoid breaking functionality and maintaining the patch long-term.
Thanks to M.Deinum, I learned that: In case of an error, it redirects to /error. I made a few modifications and it worked.
We recommend avoiding _catalog endpoint if possible for AR or GCR. Usually you can get better much results querying the specific info you need using the AR api (https://cloud.google.com/artifact-registry/docs/reference/rest)
In my environment, the deployment is in Kubernetes and this issue happens when there are multiple replicas and the error is repeatable with more than one replicas. So, for admin console I created a separate deployment with one replica and there is no such error. I had to resort to this fix as this is disruptive in production environment. For token request, I have multiple replicas as there are more traffic.
You must review and agree with the new agreement from Apple by the role Account Holder of the Organization.
Thank you for this post I am thinking about the same however mainly notifications need to be posted to Admin or Dashboard whatever you call it. Did you manage to solve it ?
There are also other simple ways to confirm usb2.0 or usb3.0 port:
For example:
C:\Users\jason95>adb root & adb remount
adbd is already running as root remount succeeded
C:\Users\jason95>adb pull /data/test.img
/data/test.img: 1 file pulled, 0 skipped. 323.9 MB/s (1073741824 bytes in 3.161s)
In my case, I downgraded clang from version 16 to 14.
Here's the steps for my environment (adapt as necessary):
brew install llvm@14~/.zhrcclang -v prints out 14.0.6bundle install as usualIs the googleIdTokenCredential.id fixed for the same account, or can it alternate between numbers and email addresses?
Did you find a solution at last?
I have the same issue. May I ask, do you run a web server application?
'image' => 'required_if:old_image,!=,null'
If clicking on an edit icon is not suppose to open the edit page, what should it do instead?
If the problem is that it does not send you to the correct edit page, you should use the pk argument in the edit_category in the views.py to select the right one. You may need to modify the edit_category.html before rendering it for each request.
P.S. I know I not suppose to ask for clarification here, but I CAN NOT WRITE COMMENTS UNTIL 50 REPUTATION!
Thanks @zer00ne and @Alohci for your comments, both overflow-y: scroll and scrollbar-gutter: stable work for my use case.
Obligatory caniuse for the latter.
I was told if I use Google services or Google Play store apps in Vancouver, BC I'd be beaten to death or have my head smashed in
The original poster might not see this, but hopefully anyone with the same question does.
I directly referenced the alias and it worked. My query was:
SELECT SUM(amt) AS to_assets FROM ... WERE ...;
My string that I input into the control source for the text box was 'to_assets', not '=to_assets', not '=[query_name]![to_assets]'
you just need to add a condition inside your forEach loop that checks if the row is hidden before processing it. The sheet.isRowHiddenByUser(rowIndex) method returns true if the row is hidden by the user. Modify your loop like this:
Add a check for sheet.isRowHiddenByUser(index + 2) (since your data starts at row 2) before updating the event. If the row is hidden, skip the update for that row.
As mentioned above, in order for my service under test to be correctly wired up to be Proxied, it needs to be annotated in the test as @Autowired.
And, in order to make my service @Autowired while still being able to mock a failure, I needed to change my dependencies from being @Autowired to using @SpyBean.
In addition, @MybatisTest is itself @Transactional, so that masks whether the rollback in my application code is actually working. So, I have fallen back to using @SpringBootTest.
@SpringBootTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
public class ThingServiceIntegrationTest extends AbstractPostgresJupiterTest {
// NOTE: AbstractPostgresJupiterTest sets up a PostgreSQLContainer and initializes datasource properties
@SpyBean
private ThingMapper mapper;
@SpyBean
private ThingDao dao;
@Autowired
private ThingService service;
@Test
@Description("Should rollback on error")
public void rollbackOnError() {
final List<ThingRequest> createRequests = Stream.of(1, 3)
.map(i -> generateThingRequest())
.toList();
final ThingRequest badRequest = createRequests.getLast().withName("Bad Request");
final List<ThingRequest> all =
Stream.concat(createRequests.stream(), Stream.of(badRequest)).toList();
doThrow(new MyBadRequestException("bad")).when(dao)
.createThing(argThat(thing -> thing.id().equals(badCreate.id())));
assertThrows(MyBadRequestException.class, () -> thingService.createUpdateThings(all));
// should rollback all inserts
createRequests.forEach(req -> {
assertTrue(dao.getByName(req.name()).isEmpty());
});
}
}
Finally, one other tweak I had to do was due to MyService having an @Autowired constructor (vs autowired fields). This seemed to cause problems for the @SpyBeans. The fix for this was to mark the constructor parameters as @Lazy.
With all these changes, I was able to use @Transactional instead of the transaction manager approach.
@Service
public class ThingService {
private final ThingDao thingDao;
@Autowired
public ThingService(@Lazy final ThingDao dao) {
this.thingDao = dao;
this.txManager = txManager;
}
@Transactional(rollbackFor = Throwable.class)
public void createOrUpdate(final List<ThingRequest> requests) {
requests.forEach(c -> thingDao.createThing(ThingModel.fromCreateRequest(c)));
}
public void createUpdateThings(final List<ThingRequest> requests) throws ControllerBadRequestException {
try {
createOrUpdate(requests);
} catch (final Throwable t) {
logger.error("A database exception occurred during createUpdateThings", t);
throw new MyBadRequestException(t);
}
}
}
Hope this is helpful for someone else.
For now my TLDR is to use Platform.io instead of the Arduino plugin.
You can define the mask with your 2 conditions and then use .loc:
x, y = 1, 5
mask = df["col1"].isin(["val2", "val3"]) & df.index.isin(range(x, y+1))
df.loc[mask, "col1"] = "val4"
display(df)
Is there a way to somehow configure twilio account, or use some parameters/verbs in twiML to use specific edge location for websocket connection?
No, the Media Stream feature of Twilio’s Programmable Voice does not support Edge Locations.
As of this writing, the only features listed within Programmable Voice that do support Edge Locations are the REST API, Sending SIP & Receiving SIP.