20 September, 2024

Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh

Programing Coderfunda September 20, 2024 No comments

pyspark XPath Query Returns Lists Omitting Missing Values Instead of Including None

Programing Coderfunda September 20, 2024 No comments

I have a PySpark DataFrame with a column containing XML strings, and I'm using XPath queries with absolute paths to extract data from these XML strings. However, I've noticed that the XPath queries return lists that omit values if they are not present, rather than including None in their place. I would like to keep the length of the lists consistent, filling in None where data is missing.

Here is the sample data and code I'm working with:
data = [
(1, """

Lion

Apple

Banana

Tiger

Cranberry

"""),
(2, """

Lion

Apple

Tiger

Banana

Zebra

""")

df = spark.createDataFrame(data, ["id", "xml_string"])

What the XPath queries return:

For data column:
(1, ["Apple","Banana","Cranberry"], ["Lion","Tiger"])
(2, ["Apple","Banana"], ["Lion","Tiger","Zebra"])
What I want:

For data column:
(1, ["Apple","Banana","Cranberry"], ["Lion", None, "Tiger"])
(2, ["Apple","Banana", None], ["Lion","Tiger","Zebra"])

How can I adjust my XPath queries?
root/level1/level2/level3/level4/data

root/level1/level2/level3/data2

SQL REPL from within Python/Sqlalchemy/Psychopg2

Programing Coderfunda September 20, 2024 No comments

It's helpful to have a DB CLI available for writing quick raw SQL queries. Suppose that the 1 minute it takes to remind myself how to type the correct version of psql postgresql://username@localhost:5432 is simply too long.

Is there any convenience method like engine.interactive() that just drops you into a CLI in the current database, similar to breakpoint() dropping you into a PDB? One thing I considered was
subprocess.run(['psql', engine.url])

But that doesn't work since psql doesn't accept the +psycopg2: bit of the sqlalchemy connection string.
$ psql postgresql+psycopg2://postgres:dev@localhost:5432/
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

$ psql postgresql://postgres:dev@localhost:5432/
psql (16.4 (Debian 16.4-1.pgdg120+1))
Type "help" for help.

postgres=#

I can slice it off myself and this works:
def enter_cli(engine):
url = engine.url.set(drivername=url.drivername.split("+")[0])
connection_string = url.render_as_string(hide_password=False)
subprocess.run(["psql", connection_string])

But that seems likely to be non-portable, as I'm hardcoding the CLI and the specific type of connection string. (e.g. it looks like pgcli wants postgres:// and doesn't accept postgresql://.) The other approach would be writing a python-based CLI, but with the naive approach you lose a lot of tab-completion and similar features. Is there a portable way to do this?

MySql Explain with Tobias Petry

Programing Coderfunda September 20, 2024 No comments

---

This week, we welcome Tobias Petry to the Laravel Creator Series show to discuss his journey into database optimization, the development of his MySQL Explain tool, and the acquisition of the domain mysqlexplain.com. Tobias also shares insights about his other projects, including Stack Bricks, a tool for managing different database versions, and his contributions to the Laravel Debug Bar.

➡️ Save 10% on his Indexing Beyond the Basics book and video package with the coupon code LARAVELNEWS

Show Links

*

https://x.com/tobias_petry />

*

https://tpetry.me />

*

https://mysqlexplain.com />

*

https://stackbricks.app />

*

https://sqlfordevs.com />

*

https://goodindexes.com />

The post MySql Explain with Tobias Petry appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

How to combine information from different devices into one common abstract virtual disk? [closed]

Programing Coderfunda September 20, 2024 No comments

Is it possible to create a program that will connect hard drives of computers via the Internet and combine this data into one virtual disk? I don't know how to implement this in practice.

I need to create a program that can combine computers and their hard drives into one virtual disk. It should be a compiled executable (exe) application. Please give me at least some information about this.

AdminJS not overriding default dashboard with custom React component

Programing Coderfunda September 19, 2024 No comments

So, I just started with adminjs and have been trying to override the default dashboard with my own custom component. I read the documentation and I don't think I am doing anything wrong? yet it still wont load the component. I started with a basic component to see whether it works or not.
It's being initialized but its not overriding the default dashboard.
AdminJS initialized with dashboard: { component: 'Dashboard' }

Code is provided below
Dashboard.jsx:
import React from 'react';
import { Box } from '@adminjs/design-system';
import { useTranslation } from 'adminjs';

const Dashboard = () => {
const { translateMessage } = useTranslation();
console.log('dashboard component loading...')
return (

{translateMessage('helloMessage', 'Hello')}

);
};

export default Dashboard;

admin.js:
import AdminJS from 'adminjs';
import { Database, Resource } from '@adminjs/sequelize';
import Customers from './src/models/Customers.js';
import Product from './src/models/Product.js';
import People from './src/models/People.js';
import Companies from './src/models/Companies.js';
import Leads from './src/models/Leads.js';
import Offers from './src/models/Offers.js';
import { ComponentLoader } from 'adminjs';

const componentLoader = new ComponentLoader();

const Components = {
Dashboard: componentLoader.add('Dashboard', './src/components/Dashboard.jsx')
};

AdminJS.registerAdapter({ Database, Resource });

const adminOptions = {
dashboard: {
component: Components.Dashboard
},
componentLoader,
resources: [{
resource: Customers,
options: {
parent: null,
properties: {
id: {
isVisible: { list: false, edit: false, show: false },
},
type: {
position: 1,
availableValues: [
{ value: 'company', label: 'Company' },
{ value: 'person', label: 'Person' },
],
},
name: {
position: 2,
},
email: {
position: 3,
},
phone: {
position: 4,
},
country: {
position: 5,
},
},
},
},
{
resource: People,
options: {
parent: null,
},
},
{
resource: Companies,
options: {
parent: null,
},
},
{
resource: Leads,
options: {
parent: null,
properties: {
type: {
availableValues: [
{ value: 'company', label: 'Company' },
{ value: 'person', label: 'Person' },
],
},
},
},
},
{
resource: Offers,
options: {
parent: null,
},
},
{
resource: Product,
options: {
parent: null,
},
},
],
rootPath: '/admin',
};

export default adminOptions;

server.js:
import AdminJS from 'adminjs'
import AdminJSExpress from '@adminjs/express'
import express from 'express'
import dotenv from 'dotenv'
import sequelize from './src/config/db.js';
import { Database, Resource } from '@adminjs/sequelize';
import adminOptions from './admin.js';

dotenv.config();

const PORT = 3000;

const start = async () => {
const app = express()
AdminJS.registerAdapter({ Database, Resource });
const admin = new AdminJS(adminOptions);
console.log('AdminJS initialized with dashboard:', admin.options.dashboard);

const adminRouter = AdminJSExpress.buildRouter(admin)
app.use(admin.options.rootPath, adminRouter)

app.listen(PORT, async () => {
console.log(`AdminJS started on
http://localhost:${PORT}${admin.options.rootPath}`) />
try {
await sequelize.authenticate();
console.log("database connected successfully")

await sequelize.sync();
console.log("database models synchronized")
}
catch (err) {
console.log("error connecting to database", err)
}
})
}

start()

I tried logging any information regarding it but it seems like it's not loading the component at all?
Any help or suggestions would be appreciated. Thanks!

Campfire Coders (The post-Laracon-'24 recap episode!)

Programing Coderfunda September 19, 2024 No comments

submitted by /u/JerseyMilker
[link] [comments]

Why ngModel doesn't works on the last version of Angular 17?

Programing Coderfunda September 19, 2024 No comments

I am trying to make a form in my angular app, but when i want to implement ngModel on my form :

Connexion

Mot de passe oublie ?
Se Connecter

I have this error :

NG8002: Can't bind to 'ngModel' since it isn't a known property of 'input'. [plugin angular-compiler]

I can't import FormsModule in the app.module.ts because this file doesn't exists on Angular 17, i only have an app.config.ts file.

Can someone please explain me how to do?

Fetch PHP is a Lightweight HTTP Library Inspired by JavaScript's fetch()

Programing Coderfunda September 19, 2024 No comments

---

Fetch PHP is a lightweight HTTP library inspired by JavaScript's fetch, bringing simplicity and flexibility to PHP HTTP requests. It uses the Guzzle client behind the scenes, offering synchronous and asynchronous requests with an easy-to-use API

I know that Guzzle is king, and I will use Laravel's HTTP client on most projects. However, the Fetch PHP package is just downright fun when you want a no-frills fetch() function:
$response = fetch('
https://jsonplaceholder.typicode.com/todos/1');">
https://jsonplaceholder.typicode.com/todos/1'); />
// Get the JSON response
$data = $response->json(assoc: true);
print_r($data);
/*
[
"userId" => 1,
"id" => 1,
"title" => "delectus aut autem",
"completed" => false
}
*/

// Get the status text (e.g., "OK")
echo $response->statusText();

Available Response Methods

*
json(bool $assoc = true): Decodes the response body as JSON. If $assoc is true, it returns an associative array. If false, it returns an object.

*
text(): Returns the response body as plain text.

*
blob(): Returns the response body as a PHP stream resource (like a "blob").

*
arrayBuffer(): Returns the response body as a binary string.

*
statusText(): Returns the HTTP status text (e.g., "OK" for 200).

*
ok(): Returns true if the status code is between 200-299.

*
isInformational(), isRedirection(), isClientError(), isServerError(): Helpers to check status ranges.

The asynchronous requests use the fetchAsync() function to can be used as follows:
//
// Asyc requests
//
$promise = fetchAsync('
https://jsonplaceholder.typicode.com/todos/1');">
https://jsonplaceholder.typicode.com/todos/1'); />
$promise->then(function ($response) {
$data = $response->json();
print_r($data);
});

// Wait for the promise to resolve
$promise->wait();

//
// Error handling
//
$promise = fetchAsync('
https://nonexistent-url.com'); />
$promise->then(function ($response) {
// handle success
}, function ($exception) {
// handle failure
echo "Request failed: " . $exception->getMessage();
});

You can also pass Guzzle options to the fetch() and fetchAsync() functions for any advanced Guzzle features you'll need. You can learn more about this package, get full installation instructions, and view the source code on GitHub.

The post Fetch PHP is a Lightweight HTTP Library Inspired by JavaScript's fetch() appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

Asking random PHP questions at Laracon

Programing Coderfunda September 19, 2024 No comments

submitted by /u/pronskiy
[link] [comments]

window.location.replace() is not working

Programing Coderfunda September 18, 2024 No comments

just wanna ask why does window.location.replace is not working in my page. I've been working on it for weeks. It works fine on my other pages, although those pages have DevExpress components, but in this particular page where I am only using normal html and asp tags and components it is not working. It seems to be refreshing only and not redirecting. Here is my code for the button:

Thanks.

My first Laravel package - Translation checker for Laravel

Programing Coderfunda September 18, 2024 No comments

Hey everyone!

I have created my first Laravel package, Translation Checker! It's designed to simplify the process of managing translations in your lang folders, so you no longer need to manually add new translations whenever you add a new translation string.

I built this into a package because it solved a personal need, and gave me a chance to try parsing PHP, and now, I decided to open-source.
Check it out on GitHub: Translation Checker

If you're working with multi/bi-lingual applications, whether open-source or closed-source—let me know! I’m eager for it to be tested in more real-life cases and make it work with different workflows other than my own.

Any feedback is appreciated :) submitted by /u/cawex
[link] [comments]

Windows 10 Intellij 2024.2.1 Spring boot WebFlux Unit test failed normally it's work fine. I have a exit code -1

Programing Coderfunda September 18, 2024 No comments

@ExtendWith(MockitoExtension.class)
class XXXXXXXTest {
private YYYYRule rule;

@Mock
private ZZZZService zzzzService;

@BeforeEach
void setUp() {
rule = new YYYYRule(zzzzService);
}

@Test
void shouldWork() {
RuleEngineContext context = generateActionExecutionContext();

assertThat(rule.when(context)).isTrue();

MonoMock mockToCall = MonoMock.empty();
when(zzzzService.method(anyString(), anyString(), eq(context.getOrderData().getExistingCustomerOrder()))).thenReturn(mockToCall);

StepVerifier.create(rule.then(context))
.verifyComplete();

ExecutionAction executionAction = context.getOrderData().getExecutionActions().get(0);

verify(zzzzService).method(executionAction.getRequestId(), ENUM.templateType, context.getOrderData().getExistingCustomerOrder());
mockToCall.expectHasBeenSubscribed();

assertThat(executionAction.getAllImpactedLines().stream().allMatch(impactedLine -> impactedLine.isStepOfTypeIsAtStatus(TYPE, ImpactedLineStep.Status.COMPLETED))).isTrue();

assertThat(context.getOrderData().getExistingLineExecutions().stream().allMatch(line -> line.getSentMails().isEmpty())).isTrue();

assertThat(rule.when(context)).isFalse();
}

}

Result :

NFO: Received request to resolve method 'void package.XXXXTest.shouldWork()' as test but could not fulfill it

org.opentest4j.AssertionFailedError:

Expecting value to be true but was false

Expected :true

Actual :false

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)

at packages.XXXXXTest.shouldWork(XXXXTest.java:94)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:568)

at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)

at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)

at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)

at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)

at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)

at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)

at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)

at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)

at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)

at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:214)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:210)

at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)

at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:66)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)

at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)

at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)

at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)

at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)

at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)

at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:35)

at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)

at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:54)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:107)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52)

at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:114)

at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:86)

at org.junit.platform.launcher.core.DefaultLauncherSession$DelegatingLauncher.execute(DefaultLauncherSession.java:86)

at org.junit.platform.launcher.core.SessionPerRequestLauncher.execute(SessionPerRequestLauncher.java:53)

at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:57)

at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)

at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)

at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)

at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:232)

at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:55)

Disconnected from the target VM, address: '127.0.0.1:55360', transport: 'socket'

Process finished with exit code -1

Normally this tests return successfull

Validate Console Command Input With the Command Validator Package

Programing Coderfunda September 18, 2024 No comments

---

The Command Validator package by Andrea Marco Sartori makes validating the input of console commands a cinch using Laravel's beloved Validator. All the Laravel Validator rules you know and love work with this package, along with any custom validation rules.

This package integrates with your application's console commands using the provided ValidatesInput trait, which includes an abstract rules() method. The command signature looks like the following:
namespace App\Console\Commands;

use Illuminate\Console\Command;
use Cerbero\CommandValidator\ValidatesInput;

class SampleCommand extends Command
{
use ValidatesInput;

protected $signature = 'app:sample {--start-date=}';

// ...

public function rules(): array
{
return ['start-date' => 'date_format:Y-m-d'];
}
}

I find it really neat that you can use a closure-based custom validation rule directly in your console command with command-specific business logic:

public function rules(): array
{
return [
'start-date' => [
'date_format:Y-m-d',
function (string $attribute, mixed $value, Closure $fail) {
$date = Carbon::parse($value);
$startOfYear = Carbon::now()->startOfYear();

if ($date->lessThan($startOfYear)) {
$fail("The {$attribute} must be a date from {$startOfYear->format('Y-m-d')} or later.");
}
}
],
];
}

When validation passes, you know you're working with valid input, and your handle() method can stay clean from manual validation checks.

Another neat use-case using the built-in validation rules is validating that an input exists in the database automatically with the exists rule:
public function rules(): array
{
return ['user-id' => 'exists:users,id'];
}

Sure, you could easily query a user and conditionally return an error, but I think it's neat that you can validate it using exists automatically and give back a default error message when a record doesn't exist.

You can use this package in your project by installing it via Composer:
composer require cerbero/command-validator

Learn more about this package, get full installation instructions, and view the source code on GitHub.

The post Validate Console Command Input With the Command Validator Package appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

using type parameters in generic constraints in TypeScript

Programing Coderfunda September 18, 2024 No comments

I have the following ts code in many places:

(note here's a typescript playground with the example)
let filtered = items.filter(item =>
item.title.toLowerCase().includes(search.toLowerCase()) ||
item.name.toLowerCase().includes(search.toLowerCase()) ||
item.date.toLowerCase().includes(search.toLowerCase())
);

So I created this function
function filterByKey(items: T[], keys: K[], search: string) {
return items.filter((item) =>
keys.some((key) => item[key].toString().toLowerCase().includes(search.toLowerCase()))
);
}

to call it like this:
let filtered = filterByKey(items, ['title', 'name', 'date'], search));

But I'm getting this error:
Property 'toString' does not exist on type 'T[K]'

I tried like this, but it doesn't seem like a valid syntax
function filterByKey(items: T[], keys: K[], search: string)

how can I tell ts that the properties of items will support .toString()

or how would you handle such a case so taht typescript won't complain?

---

I checked this ts documentation:
https://www.typescriptlang.org/docs/handbook/2/generics.html#using-type-parameters-in-generic-constraints

FINDSTR' is not recognized as an internal or external command

Programing Coderfunda September 17, 2024 No comments

Hello I trying to install jmeter
I type

cd C:\apache-jmeter-2.13\bin
C:\apache-jmeter-2.13\bin>jmeter.bat

And i receive this message

FINDSTR' is not recognized as an internal or external command
Not able to find Java executable or version. Please check your Java installation

.
I trying change PATH variable , fallow this topic
Findstr does not work with SET /P?
, but it didn't work.

My PATH user variable is C:\Windows\System32, C:\Program Files\apache-maven-3.3.3\src\bin and System variable is C:\Program Files\apache-maven-3.3.3\bin; C:\WINDOWS\system32, C:\Program Files\TortoiseSVN\bin

Please help i not find helpful information in google

Can `postMessage` messages get lost/dropped e.g. if recipient's main thread is coincidentally blocked at the time it should have received it?

Programing Coderfunda September 17, 2024 No comments

Context:

I'm tracking down a hard-to-replicate bug related to messages between frames. One thing I'm mildly suspicious of is that messages between the main frame and an iframe are sometimes not being sent successfully. I.e. messages are possibly being "dropped" in rare cases.

Question:

Is there any spec-level guarantee that a message sent with postMessage will be received by the target frames, assuming there's no bugs in my code?

For example, if the recipient frame happens to be unresponsive (e.g. due to a long computation which freezes the main thread) at the time that it would have received the message event, could that cause the message event to be lost? Or would is it guaranteed to be "queued" and eventually received by the window once the main thread is freed up.

Notes:

* I'd prefer answers which reference specifications, since this would allow me to file bug reports on browser engines if needed.

* I've noticed that if I have the debugger paused in the recipient frame, then all messages are lost. After unpausing, the messages are never received.

* If there are no spec-level guarantees in this area, I'm also interested in any info on browser-engine-specific behavior, if anyone has any info on that.

I built a free and public presentation tool called Simple Slides using Laravel/Filament/Inertia/Vue, and I wanted to share it

Programing Coderfunda September 17, 2024 No comments

Hey everyone, I know no-one likes self-promotion, and I genuinely am trying to not make it about that. We talk a lot about Filament and Inertia here, and I built a free-to-use (and open-source, since it's public on my GitHub) web application that uses these tools heavily - and I just wanted to share it. Whether you want to use the tool, or just want to see the code - it's all free (GitHub:
https://github.com/alkrauss48/simple-slides).

It's called Simple Slides, and the url is
https://simpleslides.dev. The front-page is an interactive experience explaining what Simple Slides is and how it works, but the tl;dr is that it's a platform for creating simple presentations that are mostly text-based and fully responsive (so it looks good on mobile, for example).

I've given a lot of talks in the past, and I found the way I present fits really well with the Takahashi method (only a few words on a slide so that it's easier for the audience to understand, mostly text content, and changing slides often to keep your audience engaged).

I have many more plans for what I want to add on, but no immediate plans for monetization (maybe one day I'll consider it to assist in covering hosting costs, but that day is not today). I just build things that I want to exist, and that I want to use myself. I would always love any feedback, even if it's a downvote!

Lastly, just for fun, here's a short (< 4 min.) YouTube video I gave about this tool at a local user group. submitted by /u/thecodeboss
[link] [comments]

TemPHPest PHP Extension for VSCode

Programing Coderfunda September 17, 2024 No comments

---

TemPHPest is an extension for Visual Studio Code to improve writing PHP in VS Code. Created by Liam Hammett, this package adds rich PHP features that will enhance the experience tremendously while writing PHP:

TemPHPest is an extension for VSCode that I’ve been working on to bring nice little tweaks and features to improve working with PHP. Each feature could probably be a separate extension, but being bundled in one is easier for me to maintain and you to install.

TemPHPest Extension Features

* Stubs for file creation

* Auto Renaming

* Code Actions

* Auto Switch to PHP Language

* Auto Interpolate from single quotes to double quotes

* Surround with Snippets

* Explorer file nesting

* REPL as you write

* Date formatting lense

* Smart autocompletion

* Blade Heredoc/Nowdoc syntax highlighting

* And more...

Let's highlight a few features that launched with TemPHPest for VS Code:

Stubs

Creating a PHP file in VS Code gives you an empty file (without PHP tags) out of the box, but TemPHPest uses PSR naming conventions to fill out an empty class/interface/trait/etc, based on the file's name. For example, creating a PHP file in app/Enums will stub out an enum for you with the proper namespace:

How does StackOverflow optimise the performance for the display of the questions?

Programing Coderfunda September 17, 2024 No comments

I am trying to learn C#.net to program a web app.

And having learned that stackoverflow uses C#.net I am happy to discover it.

I noticed that at the home page or at the questions section, whenever I refresh the page. The page always returns me the latest information without fail and at acceptable speeds.

I am not sure how do you do it. Sorry for the long series of questions. I am trying to learn what is the best practices for data retrieval, paging, performance , etc

I know that the homepage only returns a limited number of questions and their stats but the questions section actually returns everything.

How do you optimise it?

*

For the homepage, do you always grab ALL the stats of the recent questions? so your query is something like "select * from questions order by datetime_created limit 20" ?

So the * contains ALL the info including question title, id, views, etc?

Do you use HttpContext.Current.Server.cache to help with that?

*

For the questions, this is even more intriguing.

How do you do the paging?

Do you always grab from the database only the results for the specific page?

Or do you grab all the results and store it into a dataset? Then you use some kind of datagrid control to help with the paging?

If it is the latter, how do you maintain the data to be updated?

Laravel Ai Package

Programing Coderfunda September 16, 2024 No comments

I’ve broken ground on a AI package for Laravel.

https://github.com/jordandalton/laravelai

Currently supports Anthropic/Claude message creation, even a AI validation rule.

Looking forward to your feedback. submitted by /u/jdcarnivore
[link] [comments]

Laravel needs an official openapi implementation

Programing Coderfunda September 16, 2024 No comments

Hi, i just want to discuss the state of openapi documentation in laravel. As it stands many if not all of the big frameworks have openapi integration, and its pretty straighyfoward, without much hassle or just little api docs.

Still, laravel, being so popular has no such implementation and i think this needs to be a priority for the team.

There are plenty of community libraries like dedoc but they have a long way from full support or need alot of docblocks to make sense.

The laravel team has the opportunity to implement such a feature by integrating it with its classes, in the same way the router can give you a list of ruotes, their methods and the controller 'executing' the action.

I tried on my own to test the waters and i dont think i would be able to do much better than dedoc scramble is doing due to limitations, my thinking in the way mapping works.

Plenty of teams use api docs, heck even having an internal documentation is amazing, not to speak about public apis.

What do you think about this? I would go ahead and start doing it myself but my skillet is not up there, and even then i dont see myself doing anything other than static analysis, which kinda results in the current available setups

Edit: if i wasnt clear, the idea is that for public libraries to have a full-baked setup they have to first get the routes(using the route class), use reflection to get info about the request that validates the data + its validation methods, then using static analysis to detect responses (correct me if wrong, but this was my impression after trying it myself). As far as we appressiate what the community is doing, having laravel at least give a hand into it is more than welcome, not to mention an official setup submitted by /u/EmptyBrilliant6725
[link] [comments]

Clear cache on each iteration - JMeter

Programing Coderfunda September 16, 2024 No comments

Should we clear on each iteration in our load scenario in jmeter

Original time in browser : 5 seconds
When I check Clear cache each iteration: 5 seconds
When I uncheck Clear cache each iteration: 100 milliseconds

Please suggest what should I do while testing (should I clear or not), the stats I shared are for single load

Building Multiplayer Minesweeper with Laravel, Livewire and Reverb

Programing Coderfunda September 16, 2024 No comments

---

Writing PHP was my first venture into web programming some 20 years ago. WordPress, Joomla, Drupal, Zend, you name it I probably had shipped something in it.

I took a step away from all that professionally around a decade ago and ventured off into Ruby, JS, TypeScript and lately Rust land. However, the recent uptick in PHP being discussed piqued my interest. I wanted to see where things were. Reader, I was in for a treat. Even if it did take a few licks (of reading the docs and fighting with configs) to get to the center of the lollipop.

My strategy when learning something new is generally to pick a silly project and then do whatever it takes to make it work. I’ll have one or two hard requirements for things I want to see happen, and all the rest is malleable.

Here is the joyful little app I ended up building. A multiplayer minesweeper Laravel app, with Livewire, Reverb and hosted on Fly.io.

You can play it at
https://multiplayerminesweeper.lol/ if you want (open a couple tabs and share the link with yourself for a “multiplayer” experience).
My two non-negotiable hard requirements: One, I wanted to be able to play minesweeper with a couple friends on a sizable (at least 20x20) grid on the web easily. Two, I didn’t want to write any React / Vue / anything. A touch of javascript if necessary was fine, but I wanted to avoid it where I could.

I’m happy to say, mission accomplished. The playable grid works pretty well up to 40x40. Turns out that kind of takes a long time to solve, and 30x30 seems more to be a more reasonable game length. And more importantly, I wrote almost no frontend javascript code. I leaned entirely on the capabilities of the tools provided by Laravel.

How, you might ask, is this possible in a traditionally request / response bound language and server? I sketched a quick diagram that shows a slightly abbreviated flow.

It’s a deceptively simple concept. When using Livewire components, Laravel wires up some simple javascript that when you take an action submits a “POST” request, and this is used by the Livewire components server side to generate and return new HTML in the response which gets swapped into the page. There are bits of state managed for you so the Livewire component that gets passed back and forth, so for instance maintaining something like a counter feels a bit like magic.

However, this left me with a problem in that a singular client would only ever see the latest state of things if and when it submitted its own moves forcing the update function call and getting the newest state patched into their HTML.

This is where Laravel Echo, a websocket client, and Reverb, a first party websocket server, end up being the big winners. We can subscribe to the Reverb server from each of the frontend Clients, with a tiny bit of JS from the provided Laravel Echo to subscribe to the game channel. When any client makes a move on the board, the Laravel server broadcasts an “update” message to all subscribers via the Reverb server. Each client then goes and picks up the latest state to patch into their HTML. Below is an abbreviated flow from the perspective of a “Viewer” of a move and the “Player” of a move.

I did initially have some problems with large payload sizes across the wire during an update, and it was super easy to cheat. It turns out that Livewire happily sends along all the properties on the class unless you inform it otherwise. I had a board property that was generated at the beginning of each game with the locations of all the mines, and other information like if there were mines in range (aka: the number squares). I was inadvertently hydrating this board into the state of the component that went across the wire with every call. Simply making the prop protected solves that problem. Finally, implementing gzipping shrunk the payloads across the wire tremendously since it was mostly repetitive HTML for each cell, ~300Kb to ~12Kb.

That’s it. That’s all it took and I had what feels like a little single page app to play a 900 cell game of minesweeper with a couple friends without writing any Javascript. The great part is, I’m sure this could all be vastly improved. Laravel, specifically Livewire, has quite a few neat ways to make optimizations. Importantly though, my silly project still works even without needing to be an expert. Could it be better? Yes. But in mere hours I built something that satisfied my predefined hard requirements.

I threw everything up on fly.io and started testing with friends. It totally worked, but because the payloads could be a little bit sizable (especially before I gzipped things), a more distant friend, in the geographical sense, said it could be a bit laggy. I played around with putting instances of the app distributed to a few regions to get things closer to players since the Fly platform made that so easy. This worked, but I realize that this caused a problem given I was using SQLite for my database. The game would only ever exist and be accessible to a player if it was started on the server they were routed to.

I ended up using a neat Fly feature to resolve this, the fly-replay header. In the case where a game had been started on a different server it let me dynamically route requests from one server that doesn’t have that game state on it, to the one that does, without the user being any the wiser.

In the best case, geographically close players have a better experience since no replay / re-routing is required. In the worst case for games with highly distributed players, players far away from the game host incur some latency, as I haven’t yet figured out how to beat the physics of the speed of light. However, at least it is routing that traffic behind the Fly Proxy, and not a likely weaker client connection.

Side note: Fly.io was kind enough to sponsor this silly project, and gave me a link that gives anyone reading a $50 credit if they want to play with Fly.io themselves. Even if you aren’t using their platform right now, you can grab the credits and they won’t expire on you!

It wasn’t all rainbows and 200’s

I want to be very clear... The following all comes from a place of acknowledging that Laravel and the ecosystem have done so much well that the sharp edges are particularly noticeable. The process of growing a framework and ecosystem should appreciate the new developer experience as a cornerstone. This was my singular developer new-to-the-framework experience.

Coming in as a complete novice to the Laravel ecosystem is disorienting at best. The sheer amount of flexibility in the framework along with its depth of features and integrated products inflict an analysis paralysis on newcomers. I wasn’t quite sure which, or if I needed any 25 different things listed under the ecosystem tab (answer, yes).

Getting going had a couple false starts figuring out what approach to take. Eventually I ended up with a very spicy stew from a local and Sail based environment. It’s all still a bit broken, but like my hand-me-down Dodge Stratus in high school, it got the job done.

I think what demoralized and slowed me down the most, there was no definitive “do this to get started”. There are docs, yes, honestly probably too many versions of “getting started”. It was a choose your own adventure where paths diverge, converge at points, lead off a cliff on another path (several times I deleted whole folders, attempted to uninstall everything and get back to a fresh state), and at one point you end up in an alley where you are offered some salve (Laravel Herd) to soothe all your aches and pains for a couple silver coins.

Were I to do this all again, I’d have a better idea of where to go and what I’d want. But my experience here is highly contrasted by experiences like install node, run npx create-next-app@latest or install ruby, run gem install rails.

When it came to actual functionality, it took me quite a bit of scouring the docs to understand that Livewire and Echo were the things I needed to enable a pattern of inducing a Livewire update when another client updates. But Echo then mentions Redis is needed, and something else called Reverb is optional, but you can use Pusher channels if you want instead? What was Reverb, Pusher channels? We all know I got there in the end, I needed a websocket broker and Reverb is simply the first party one provided by Laravel.

While reading the docs is not something I’m not proclaiming as a negative, and it is a side-effect of the “not all batteries included, but they are available” that seems to be the strategy of Laravel, it is painful in a lot of cases to have so many options documented without clear indicators of preference. If I was diving into laravel professionally, I’d likely read the documentation religiously and this would all be less of a problem. But for a new developer trying to set things up, all these options add up to a layer of hidden complexities.

As an illustration of hidden complexity, in the sketch at the beginning of the article... you see a redis powered queue system. It took me quite a while to realize I needed to actually run queue workers somewhere in my local dev, it didn’t just happen with the normal starting up of a dev server. For probably a solid hour I just thought my code was wrong. In retrospect, duh, but without catching the small two-sentence blurb in the docs under a h4 header, I wouldn’t have realized it for much longer.

Finally, when it came to shipping everything on fly.io, while packaging up a container and shipping was easy... with Laravel itself there are lots of configurations for everything because of all the flexibility in how you can model an architecture. You are mostly left to your own devices and experience for figuring it out. Lacking the requisite Laravel specific experience, I mostly resorted to guessing and playing documentation telephone with AI.

I simply wanted to put Reverb on a /socket path on my main domain. As far as I could tell this had to be possible (it is). And while the incantation is fairly trivial at the end of the day, the docs all make various assumptions, for example that Reverb will be running on its own subdomain. Even the pre-populated .env configuration files account for wanting to have Laravel be able to hit Redis inside of a network while your clients will need a DNS resolution across a domain.

To reiterate the opening paragraph of this section. I only took the time to write this because I care. There is a saying we use a lot at my day job, “Reality has a surprising amount of detail” (John Salvatier). When I look at everything Laravel has done and can do, it is not surprising to me that getting started is a bit complicated. The reality is that Laravel grew and evolved to the needs of those depending on it to do real work, real work is complicated. Every last thing I raised here is solvable with skilled and guided hands pruning and tending the garden of the ecosystem.

I’m impressed, the hype is earned

Regardless of the pains expressed, I still came away having enjoyed the journey and the project as a whole. I get why Laravel is gaining steam, I understand why people love the ecosystem. I appreciate and value what the community is building.

I’m not going to drop all my toolsets and jump to Laravel tomorrow at the day job, but I’m also pretty sure my next silly build with PHP isn’t going to be another decade away..

The post Building Multiplayer Minesweeper with Laravel, Livewire and Reverb appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

Python httpx.get or requests.get much slower than cURL for this API - why?

Programing Coderfunda September 16, 2024 No comments

For a home automation project I am trying to pull train delay data for our magestically unreliable commuter trains. An API wrapper exists, with cURL examples. These work fine, but both Python's requests.get and httpx.get are slow to pull data (up to a minute for requests and ca. 4 seconds httpx) but curl, or pasting a link in the browser, returns almost immediately. Why?

The internet suggested that some sites have anti-scraping protections and may throttle or block requests, as it uses HTTP1.0. On this API httpx does seem to be much faster, but nowhere near as fast as curl or the browser.

Some examples - this Python snippet takes ca. 4 seconds:
import httpx
client = httpx.Client(http2=True)
response = client.get('
https://v6.db.transport.rest/stations?query=berlin')
https://v6.db.transport.rest/stations?query=berlin') /> print(response.text)

This takes up to a minute:
import requests
response = requests.get('
https://v6.db.transport.rest/stations?query=berlin')
print(response.text)

This returns almost immediately:
import subprocess
command = 'curl \'
https://v6.db.transport.rest/stations?query=berlin\' -s'
result = subprocess.run(command, capture_output=True, shell=True, text=True)
print(result.stdout)
print(result.stderr)

What's the magic here? Thanks in advance for any hints.

Different ways of passing a variable by reference?

Programing Coderfunda September 15, 2024 No comments

I want to pass a variable to a function and have the function change the value.

I know I can do this as an object but am wondering if there is some way to do this that I haven't thought of.

This is what I want to do, but it doesn't work the way I want of course:
function test1(vari) {
vari = 2;
}
var myvar1 = 1;
test1(myvar1);
console.log(myvar1);

This works, but I don't really want to make all the variables objects:
function test2(vari) {
vari.val = 2;
}
var myvar2 = { val: 1 };
test2(myvar2);
console.log(myvar2.val);

This also works, but not an acceptable solution:
function test3(vari) {
eval(vari + ' = 2;');
}
var myvar3 = 1;
test3('myvar3');
console.log(myvar3);

Is there a better option than these?

Updated

A better example of what I would like to do:
function test5(vari, onblur) {
document.querySelector('body').innerHTML += ``;
el = document.getElementById(`ctl_${vari}`);
el.addEventListener('blur', function(e) {
vari = e.target.value; //Doesn't update original variable
onblur(e);
});
return el;
}
var myvar5 = 'test';
var ele = test5(
myvar5,
function(e) {
//Could set myvar5 = e.target.value but not wanting to do this for every single field
console.log(myvar5);
}
);

Weekly /r/Laravel Help Thread

Programing Coderfunda September 15, 2024 No comments

Ask your Laravel help questions here. To improve your chances of getting an answer from the community, here are some tips:

* What steps have you taken so far?
* What have you tried from the documentation?
* Did you provide any error messages you are getting?
* Are you able to provide instructions to replicate the issue?

* Did you provide a code example?

* Please don't post a screenshot of your code. Use the code block in the Reddit text editor and ensure it's formatted correctly.

For more immediate support, you can ask in the official Laravel Discord.

Thanks and welcome to the /r/Laravel community! submitted by /u/AutoModerator
[link] [comments]

Convert CSV to REST API

Programing Coderfunda September 15, 2024 No comments

Convert your CSV to a fast, searchable, REST API with my new tool. Check it out and let me know what you think. submitted by /u/jdcarnivore
[link] [comments]

How to consider daylight savings time when using cron schedule in Airflow

Programing Coderfunda September 15, 2024 No comments

In Airflow, I'd like a job to run at specific time each day in a non-UTC timezone. How can I go about scheduling this?

The problem is that once daylight savings time is triggered, my job will either be running an hour too soon or an hour too late. In the Airflow docs, it seems like this is a known issue:

In case you set a cron schedule, Airflow assumes you will always want
to run at the exact same time. It will then ignore day light savings
time. Thus, if you have a schedule that says run at end of interval
every day at 08:00 GMT+1 it will always run end of interval 08:00
GMT+1, regardless if day light savings time is in place.

Has anyone else run into this issue? Is there a work around? Surely the best practice cannot be to alter all the scheduled times after Daylight Savings Time occurs?

Thanks.

I dug through Laravel's new `defer()` helper to find out what's powering them if not queues.

Programing Coderfunda September 15, 2024 No comments

submitted by /u/amitmerchant
[link] [comments]

An auth helper package for Laravel HTTP Client

Programing Coderfunda September 14, 2024 No comments

I really like the built in HTTP Client in Laravel. It makes it so quick and easy to make calls to external services. But a common thing for me to solve when building applications with Laravel is simple authentication with external API:s. Especially OAuth2 or API:s that is using refresh tokens to fetch short lived access tokens. I was also very surprised that I couldn’t find any simple solutions for this. So I created one.

It is just an extension of the built in HTTP Client that provides a very simple, yet flexible and powerful API to manage the refreshing and usage of short lived access tokens. Managing this in a robust way required significant amount of boilerplate code or custom API clients for each integration. Now it is just a chained method call on the HTTP Client you are already using.

I’m about to release the 1.0 version, but first I wanted reach out to collect some feedback on the API and overall solution. Once I tag the 1.0 version, I don’t want to make any breaking changes for a good while.

Here is the repository:
https://github.com/pelmered/laravel-http-client-auth-helper

I’d love to get some feedback on this. Specifically I would like feedback on the following:

*

The API to use it. Is it good? How would you want to improve it?
*

What are the most sensible defaults? (See usage for example on how these are used)
*

Auth type: Basic or bearer? (for the access token)
*

Expires option (how should this be set by default? The package supports reading a field from the response from the refresh request, either as a string for the key in the response, or as a closure that receives the whole response object. You can also set it with an integer for TTL in seconds)
*

Credential token key name (If sent in body, or as a query string, what should be the the field name? Currently it is “token”)
*

Access token key (From what key should we get the access token from the refresh response be default? Accepts both a string or a closure that receives the response object and returns the token)
*

Right now I’m just using the default cache driver to store the tokens. Would you want this to be configurable?

The plan is to release version 1.0.0 with a stable API next weekend.

Thank you for reading! submitted by /u/pekz0r
[link] [comments]

Error when i run commend php composer dump-autoload

Programing Coderfunda September 14, 2024 No comments

Illuminate\Foundation\ComposerScripts::postAutoloadDump
@php artisan package:discover --ansi

Error

Class "Composer\InstalledVersions" not found

at vendor/maatwebsite/excel/src/Cache/CacheManager.php:43
39▕ * @return MemoryCache
40▕ */
41▕ public function createMemoryDriver(): CacheInterface
42▕ {
➜ 43▕ if (!InstalledVersions::satisfies(new VersionParser, 'psr/simple-cache', '^3.0')) {
44▕ return new MemoryCacheDeprecated(
45▕ config('excel.cache.batch.memory_limit', 60000)
46▕ );
47▕ }
+11 vendor frames

12 artisan:35
Illuminate\Foundation\Console\Kernel::handle()

Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1

I tried to change databass password and server

Should Laravel introduce AI validation rules into core?

Programing Coderfunda September 14, 2024 No comments

I think this could be a great addition. Would you use it? submitted by /u/jdcarnivore
[link] [comments]

Where to find the latest version of google-api-services-gmail maven?

Programing Coderfunda September 14, 2024 No comments

I am trying to find the latest version of the google-api-services-gmail api. At
https://central.sonatype.com/artifact/com.google.apis/google-api-services-gmail I see 1-rev20240520-2.0.0 which 'sounds' right. But the place where I usually get the versions is
https://mvnrepository.com/ which only has data from 2020:
https://mvnrepository.com/artifact/com.google.apis/google-api-services-gmail . Am I looking at the wrong place on mvnrepository ?

Thanks for any help in advance!

I also see
https://javadoc.io/doc/com.google.apis/google-api-services-gmail/latest/index.html which seems to be managed by Google as well as
https://mvnrepository.com/artifact/com.google.apis/google-api-services-artifactregistry/v1-rev20240903-2.0.0

I am trying to insert a timestamp from one spreadsheet to another spreadsheet

Programing Coderfunda September 14, 2024 No comments

I have two spreadsheets, we will call them Active Spreadsheet (where the code is being implemented) and Target Spreadsheet (where the timestamps go) The Active Spreadsheet will have data entered on sheet "Week1" into column D starting at row 4. When the data is entered into column D I want an "Initial Date" timestamp and a "Modified Date" timestamp populated into the Target Spreadsheet, sheet "Week#1" at the corresponding rows in columns 1 and 2 respectively. I have the following code written, and it runs without errors. However, when I input data into column D of the Active Spreadsheet, nothing populates in the Target Spreadsheet. I have tried running the code and researching various reasons as to why it is not working but cannot find a solution.
function onEdit(e){
const row = e.range.getRow();
const col = e.range.getColumn();
const sheetName = "Week1";

if (col === 4 && row > 3 && e.source.getActiveSheet().getName() === "Week1"){

var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var targetSpreadsheetId = "TargetSpreadsheetID";
var targetSpreadsheet = SpreadsheetApp.openById(targetSpreadsheetId);
var targetSheet = targetSpreadsheet.getSheetByName("Week#1");
var targetRow = range.getRow();
var timestamp = new Date();
var formattedTimestamp = Utilities.formatDate(timestamp, Session.getScriptTimeZone(), "yyyy-MM-dd HH:mm:ss");

targetSheet.getRange(row,2).setValue(formattedTimestamp);

if(targetSheet.getRange(row,1).getValue() == ""){
targetSheet.getRange(row,1).setValue(formattedTimestamp);

}
}
}

Different plots of marginal effects with interaction term and offset when using different packages

Programing Coderfunda September 13, 2024 No comments

I'm trying to understand why when I plot marginal effects using different packages I get different plots. Admittedly, I suspect it's because I do not understand how data transformations and offsets are being handled by the respective packages. I'm afraid I don't know how to make a reproducible sample of data, but I hope I can provide enough context below.

I have the following model using package MASS:
model

Laravel Singletons Can Be Dangerous in Long Living Processes

Programing Coderfunda September 13, 2024 No comments

submitted by /u/DutchBytes
[link] [comments]

Stop using arrays

Programing Coderfunda September 13, 2024 No comments

submitted by /u/lyotox
[link] [comments]

Laravel Herd Adds Forge Integration, Dump Updates, and More in v1.11

Programing Coderfunda September 13, 2024 No comments

---

Laravel Herd released v1.11 this week, a significant update that includes Laravel Forge integration, sharing Herd project configuration across a team, a convenient profiler integration, and more:

Laravel Herd v1.11 Main Features

*
Forge Integration - Integrate directly with Forge and deploy applications via the UI

*
Share Configuration With Your Team - share project configuration via a Herd.yml file

*
Profiler - profile applications with the SPX profiler using herd profile

*
Reverb TLS Support - Reverb TLS support with the click of a checkbox

*
Dump UI Improvements - Dump queries, HTTP requests, logs, and more directly in Herd

Forge Integration

Herd now has direct integration with Laravel Forge, enabling you to deploy your site directly from Herd, open an SSH connection on the server, or even open your site on forge.laravel.com. Head over to the documentation to learn more!

Sharing Configuration With Herd.yml

With Herd v1.11, you can share project configuration with your team using a Herd.yml file in the root of your project. You can configure the project name, domain aliases, PHP version, and SSL certificates.

You set up the Herd.yml using the herd init command. If your project doesn't have the file, the init command prompts you through the setup process. Pro users can also define services in the Herd.yml file.

When a new developer clones your project, running herd init will get them up and running immediately, and all developers will have the same setup. Projects can configure the Forge server and site IDs to share site configurations with all developers.

Check out the Herd documentation to learn all about Sharing project configurations.

The Herd v1.11 update is available immediately on macOS, with the Windows release happening soon.

Profiler

Herd v1.11 has a new profiler for identifying performance issues in your code. Herd makes profile requests, CLI scripts, and long-running tasks seamless.

Profiler example from the Herd documentation

Here's an example of profiling Artisan commands via the Herd CLI:
herd profile artisan my-command

Dump UI Improvements

Herd's dump debugging features a new custom PHP extension that makes using dd() and dump() automatic. You can also configure Herd to dump queries, HTTP requests, views, jobs, and logs.

Learn More

You can learn more about Herd's features in the official documentation.

The post Laravel Herd Adds Forge Integration, Dump Updates, and More in v1.11 appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

What’s New in Laravel 11.23: A Summary

Programing Coderfunda September 13, 2024 No comments

submitted by /u/codingtricks
[link] [comments]

Excel VBA Selecting the files xxx_Before.log then xxx_After.log

Programing Coderfunda September 12, 2024 No comments

Main goal is to select Tag1_Before.log then Tag1_After.log (The name of the files will be different but there will definitely have a before or after in the name of the files). Currently the files are being selected in alphabetical order because I am using the Dir function. Below is part of the code I have gathered, and a visual representation of where I will access the files.
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Filters.Add "Log Files", "*.log", 1

If .Show = -1 Then
FullPath = .SelectedItems.Item(1) 'selected text file full path
End If
End With

If FullPath = "" Then Exit Sub 'if Cancel pressed, the code stops

textFileLocation = Left(FullPath, InStrRev(FullPath, "\") - 1)
fileName = Dir(textFileLocation & "\*.log") 'first text file name
fileDate = Format(FileDateTime(textFileLocation), "mm/dd/yyyy")

If fileName "" Then
Do While fileName "" 'loop since there still are not processed text files
'Get File Name
sFullFilename = Right(fileName, Len(fileName) - InStrRev(fileName, "\"))
sFileName = Left(sFullFilename, (InStr(sFullFilename, ".") - 1))

'place the content of the text file in an array (split by VbCrLf):
arrTxt = Split(CreateObject("Scripting.FileSystemObject").OpenTextFile(textFileLocation & "\" & fileName, 1).ReadAll, vbCrLf)
lastR = ws.Range("A" & ws.Rows.Count).End(xlUp).Row 'the row where to paste the array content

'drop the transposed array content:
ws.Range("A" & IIf(lastR = 1, lastR, lastR + 1)).Resize(UBound(arrTxt) + 1, 1).Value = Application.Transpose(arrTxt)

'apply TextToColumns to whole returned data:
ws.Columns(1).TextToColumns Destination:=ws.Range("A1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(43, 1), Array(70, 1)), TrailingMinusNumbers:=True

✅ Command Validator: validate the input of console commands

Programing Coderfunda September 12, 2024 No comments

Command Validator is a Laravel package to validate the input of console commands. ✅

https://github.com/cerbero90/command-validator

The validation of our command arguments and options is just one trait away! 🙌

https://preview.redd.it/018z0tn9pfod1.png?width=1748&format=png&auto=webp&s=e523f7bd24f8c4b94c9a08b1f19a383a699982cb submitted by /u/cerbero90
[link] [comments]

Invalid Grant Error with MSAL in Next.js - Insufficient Permissions (AADB2C90205)

Programing Coderfunda September 12, 2024 No comments

I am implementing login functionality in my Next.js application using Azure AD B2C and the MSAL library. However, I am encountering the following error when attempting to log in:
{
"error": "invalid_grant",
"error_description": "AADB2C90205:This application does not have sufficient permissions
against this web resource to perform the operation.
\r\nCorrelation ID: 425d0c39-3bf7-48be-9b81-8bc5cd5abc02\r\nTimestamp: 2024-09-06 12:41:31Z\r\n"
}

Here are the relevant details:
@azure/msal-browser: ^3.23.0
@azure/msal-react: ^2.0.13

I am using Azure AD B2C to handle user authentication.

Steps Taken:

I registered the application in Azure AD B2C.
Configured the necessary redirect URIs and API permissions.
Set up the MSAL configuration in my Next.js app using the MSAL React library.

Troubleshooting Attempts:

Checked API permissions and made sure they were granted admin consent.
Verified that the redirect URIs and scopes in my MSAL configuration match those in Azure AD B2C.
Question: What might be causing this "insufficient permissions" error, and how can I resolve it? Is there something specific I need to configure in Azure AD B2C for MSAL to successfully authenticate users?

Any help would be appreciated!

Laracon US Keynote Framework Updates Are Now In Laravel 11.23

Programing Coderfunda September 12, 2024 No comments

---

The Laravel team released v11.23 this week, with the Laracon US 2024 open-source updates like defer(), concurrency, contextual container attritubes, and more.

Laracon 2024 Updates

Taylor Otwell contributed all of the goodies he shared in his Laracon US 2024 keynote, including chaperone(), defer(), Cache::flexible(), contextual container attributes, and more.

The documentation is being updated; here are a few highlights you should check out to get familiar with these updates:

*
Concurrency Documentation

*
Container Contextual Attributes

*
Automatically Hydrating Parent Models on Children (AKA chaperone())

*
Helpers: Deferred Functions

See Pull Request #52710 for full details on everything added related to Taylor's .

Add minRatio and maxRatio Rules to Dimension Validation

Cam Kemshal-Bell added min and max ratio to the dimensions validation rule:

You can use these methods fluently, using minRatio(), maxRatio(), and ratioBetween():
use Illuminate\Validation\Rule;

//
// Using minRatio and maxRatio fluent methods
//
Rule::dimensions()
->minRatio(1 / 2)
->maxRatio(1 / 3);
// dimensions:min_ratio=0.5,max_ratio=0.33333333333333

//
// Equivalent using ratioBetween()
//
Rule::dimensions()->ratioBetween(min: 1 / 2, max: 1 / 3);

// dimensions:min_ratio=0.5,max_ratio=0.33333333333333

You can also use the string style dimensions rule with this update as well:
use Illuminate\Support\Facades\Validator;

Validator::make($request->all(), [
'min_12' => 'dimensions:min_ratio=1/2',
'square' => 'dimensions:ratio=1',
'max_25' => 'dimensions:max_ratio=2/5',
'min_max' => 'dimensions:min_ratio=1/4,max_ratio=2/5',
]);

Backed Enum Support in Gate Methods and Authorize Middleware

Diaa Fares contributed two pull requests that continue to add backed enum support. This release includes updates to the Gate methods and Authorize middleware.

Here are some examples of using Enums with Gate methods:
enum Abilities: string {
case VIEW_DASHBOARD = 'view-dashboard';
case EDIT = 'edit';
case UPDATE = 'update';
}

// Before
Gate::define('view-dashboard', function (User $user) {
return $user->isAdmin;
});

Gate::authorize('view-dashboard');
Gate::inspect('view-dashboard');
Gate::check('view-dashboard');
Gate::any(['edit', 'update], $post);
Gate::none(['edit', 'update]], $post);
Gate::allows('update', $post);
Gate::denies('update', $post);

// After
Gate::define(Abilities::VIEW_DASHBOARD, function (User $user) {
return $user->isAdmin;
});

Gate::authorize(Abilities::VIEW_DASHBOARD);
Gate::inspect(Abilities::VIEW_DASHBOARD);
Gate::check(Abilities::VIEW_DASHBOARD);
Gate::any([Abilities::EDIT, Abilities::UPDATE], $post);
Gate::none([Abilities::EDIT, Abilities::UPDATE], $post);
Gate::allows(Abilities::UPDATE, $post);
Gate::denies(Abilities::UPDATE, $post);

Here's an example of the Authorize middleware's support for backed enums:
Route::get('/dashboard', [AdminDashboardController::class, 'index'])
->middleware(
Authorize::using(Abilities::VIEW_DASHBOARD)
)
->name(AdminRoutes::DASHBOARD);

Skip Middleware for Queue Jobs

Kennedy Tedesco contributed a Skip middleware to skip a job based on a condition. This middleware has three static constructor methods you can use, including when(), unless(). The job is skipped based on the result of the condition used:
class MyJob implements ShouldQueue
{
use Queueable;

public function handle(): void
{
// TODO
}

public function middleware(): array
{
return [
Skip::when($someCondition), // Skip when `true`

Skip::unless($someCondition), // Skip when `false`

Skip::when(function(): bool {
if ($someCondition) {
return true;
}
return false;
}),
];
}
}

Eloquent Collection findOrFail() Method

Steve Bauman contributed a findOrFail() method on Eloquent collections that adds a way to find a model on an already populated collection:
$users = User::get(); // [User(id: 1), User(id: 2)]

$users->findOrFail(1); // User

$user->findOrFail([]); // []

$user->findOrFail([1, 2]); // [User, User]

$user->findOrFail(3); // ModelNotFoundException: 'No query results for model [User] 3'

$user->findOrFail([1, 2, 3]); // ModelNotFoundException: 'No query results for model [User] 3'

Release notes

You can see the complete list of new features and updates below and the diff between 11.22.0 and 11.23.0 on GitHub. The following release notes are directly from the changelog:

v11.23.0

* [11.x] Fix $fail closure type in docblocks for validation rules by @bastien-phi in
https://github.com/laravel/framework/pull/52644 />

* [11.x] Add MSSQL 2017 and PGSQL 10 builds by @driesvints in
https://github.com/laravel/framework/pull/52631 />

* Update everyThirtyMinutes cron expression by @SamuelNitsche in
https://github.com/laravel/framework/pull/52662 />

* Bump micromatch from 4.0.5 to 4.0.8 in /src/Illuminate/Foundation/resources/exceptions/renderer by @dependabot in
https://github.com/laravel/framework/pull/52664 />

* [11.x] apply excludeUnvalidatedArrayKeys to list validation by @lorenzolosa in
https://github.com/laravel/framework/pull/52658 />

* [11.x] Adding minRatio & maxRatio rules on Dimension validation ruleset by @CamKem in
https://github.com/laravel/framework/pull/52482 />

* [11.x] Add BackedEnum support to Authorize middleware by @diaafares in
https://github.com/laravel/framework/pull/52679 />

* [11.x] Add BackedEnum support to Gate methods by @diaafares in
https://github.com/laravel/framework/pull/52677 />

* [11.x] Suggest serializable-closure by @driesvints in
https://github.com/laravel/framework/pull/52673 />

* [11.x] Fix alter table expressions on SQLite by @hafezdivandari in
https://github.com/laravel/framework/pull/52678 />

* [11.x] Add Exceptions\Handler::mapLogLevel(...) so the logic can be easily overridden by @taka-oyama in
https://github.com/laravel/framework/pull/52666 />

* [11.x] Bugfix for calling pluck() on chaperoned relations. by @samlev in
https://github.com/laravel/framework/pull/52680 />

* [11.x] Fix build failures due to enum collide After adding BackedEnum support to Gate by @diaafares in
https://github.com/laravel/framework/pull/52683 />

* Fixing Str::trim to remove the default trim/ltrim/rtim characters " \n\r\t\v\0" by @mathiasgrimm in
https://github.com/laravel/framework/pull/52684 />

* [11.x] Add Skip middleware for Queue Jobs by @KennedyTedesco in
https://github.com/laravel/framework/pull/52645 />

* [11.x] Fix etag headers for binary file responses by @wouterrutgers in
https://github.com/laravel/framework/pull/52705 />

* [11.x] add withoutDelay() to PendingDispatch by @KennedyTedesco in
https://github.com/laravel/framework/pull/52696 />

* [11.x] Refactor Container::getInstance() to use null coalescing assignment by @xurshudyan in
https://github.com/laravel/framework/pull/52693 />

* [11.x] Removed unnecessary call to setAccessible(true) by @xurshudyan in
https://github.com/laravel/framework/pull/52691 />

* [11.x] Add Eloquent\Collection::findOrFail by @stevebauman in
https://github.com/laravel/framework/pull/52690 />

* [11.x] PHPStan Improvements by @crynobone in
https://github.com/laravel/framework/pull/52712 />

* [11.x] Fix Collection PHPDoc by @staudenmeir in
https://github.com/laravel/framework/pull/52724 />

* [11.x] Add optional parameter for confirmed validator rule by @jwpage in
https://github.com/laravel/framework/pull/52722 />

* [11.x] Test Improvements by @crynobone in
https://github.com/laravel/framework/pull/52718 />

* [11.x] Fix incorrect variable-length argument $guards from array to string by @kayw-geek in
https://github.com/laravel/framework/pull/52719 />

* Allow testing of relative signed routes by @shealavington in
https://github.com/laravel/framework/pull/52726 />

* [11.x] fix: Builder::with closure types by @calebdw in
https://github.com/laravel/framework/pull/52729 />

* Laracon 2024 by @taylorotwell in
https://github.com/laravel/framework/pull/52710 />

* Add Tag attribute by @TijmenWierenga in
https://github.com/laravel/framework/pull/52743 />

* [11.x] Adds BackedEnum to PendingDispatch's phpDoc for onQueue, allOnQueue, onConnection, allOnConnection methods by @sethsandaru in
https://github.com/laravel/framework/pull/52739 />

* New when() helper. by @danmatthews in
https://github.com/laravel/framework/pull/52665 />

* [11.x] Add fromUrl() to Attachment by @KennedyTedesco in
https://github.com/laravel/framework/pull/52688 />

The post Laracon US Keynote Framework Updates Are Now In Laravel 11.23 appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

20 September, 2024

19 September, 2024

18 September, 2024

17 September, 2024

16 September, 2024

15 September, 2024

14 September, 2024

13 September, 2024

12 September, 2024

Meta

Popular Posts

Categories

Social Media Links

Pages

Blog Archive

Laravel News