I'm looking for the equivalent VBA-GAS of:

Application.ScreenUpdating = False

I'm running a very long macro in one of my Google Spreadsheets and it takes at least 30 seconds to finish it every time. It would be helpful if the macro didn't refresh the screen after every line of code.

I am trying to create a audio tag in javascript.

I have the following

this.audioElement = createElement('audio', {className:'audio', src:'test.mp3', type:'audio/mpeg'});

The audio tag I want to appear in html

<audio controls src='test.mp3' type='audio/mpeg'></audio>

I am not sure how to create controls attribute in js. Can anyone help me about it?

So i am new to both fontoxpath and Xquery.

I would like to select a node in a document, then do an insert.

declare %public %updating function xyz:change($bc as document-node(), $ch as element()) {
 let $contextNode := evaluateXPath($ch/@contextNode, $bc)
 return insert node $ch/element() as last into $contextNode
};

So $ch/@contextNode is an XPath.

When i change the last bit of the insert line into as last into $bc/changes/*[Last()}, i do get a result.

The problem is I don't know how to get evaluateXPath to work, so $contextNode actually point to a node. I keep getting this error when trying several namespaces:

XPST0017: Function evaluateXPath with arity of 2 not registered.

So how can I do this using fontoxpath? Without adding extra dependencies.

Or is this just not yet implemented in fontoxpath?

I want to notify my employee's smartwatch (Wear OS by Google) when something goes wrong with a machine at the factory. There is one Windows PC for management, and this PC holds the state of the machine. There are 10 smart watches in the factory. There is a wireless LAN access point in the factory. The Windows PC and smartwatch are in the same network.

I think there are several methods, but I would like to know the optimal solution.

For example
1.The smartwatch directly refers to the DB in the PC.
2.Send and receive messages (JSON?) Between your PC and smartwatch

If I can know how to do it, I will try to develop it.

I develop Windows PC apps well, but I have rarely developed Android apps. I'm not good at English. I asked a question in English because there is not much information in my mother tongue. Sorry if I came off as rude.

The following code generates a schedule that fits the following scenario:

An event is taking place with 8 stations and 24 teams. There are 3 teams at a station at a time. There are exactly 8 rotations, and every team must visit each of the 8 stations in the 8 rotations. No team can repeat a station, and all teams must be at a station during each rotation. Furthermore, each team cannot see another team more than once throughout the whole event. For example, if team 1 saw team 2 and 3 at station 1, team 1 cannot be with team 2 or 3 at any of the future stations. (Implies that a team will not be able to see every team, but the goal is that each team competes against as many different teams as possible).

include "alldifferent.mzn";

int: num_teams = 24; % Number of teams
int: num_stations = 8; % Number of stations
int: num_rotations = 8; % Number of rotations
int: teams_per_station = 3; % Teams per station per rotation

% Decision variable: station assignments
array[1..num_teams, 1..num_rotations] of var 1..num_stations: station;

% Constraints
constraint
 % Each team visits exactly one station in each rotation
 forall(t in 1..num_teams, r in 1..num_rotations) (
 station[t, r] >= 1 /\ station[t, r] <= num_stations
 )
 /\
 % No team visits the same station more than once
 forall(t in 1..num_teams, s in 1..num_stations) (
 sum([station[t, r] == s | r in 1..num_rotations]) <= 1
 )
 /\
 % Each station accommodates exactly teams_per_station teams per rotation
 forall(r in 1..num_rotations, s in 1..num_stations) (
 sum([station[t, r] == s | t in 1..num_teams]) == teams_per_station
 )
 /\
 % Teams do not see each other more than once
 forall(t1 in 1..num_teams, t2 in 1..num_teams where t1 != t2) (
 sum([station[t1, r] == station[t2, r] | r in 1..num_rotations]) <= 1
 );

% Objective: Maximize team diversity by minimizing the number of repeat encounters
solve satisfy;

% Output the station assignments
output [
 "Team " ++ show(t) ++ ": " ++ show([station[t, r] | r in 1..num_rotations]) ++ "\n"
 | t in 1..num_teams
];

The code works for smaller numbers (ex. 15 teams, 5 stations and rotations, 3 teams per station), but I need it to finish running for a solution to 24 teams, 8 stations and rotations, and 3 teams per station). I ran for 18 hours, and it still didn't compute.

I tried combining the first 2 constraints using alldifferent, but was unsuccessful. Does anyone have an idea on how to get this to compute in a reasonable amount of time?

After searching for numerous hours all over the web and asking ChatGPT, I have found no solution.

I have a Firebase Project (Web App) and I am using Gen2 Javascript Node for Firebase Functions. I have enabled Firebase Auth with Identity Platform in my project.

I am ONLY using emulators currently.

The problem I'm having is that the beforeUserCreated event (blocking function) is not being called in my emulator.

All other functions work perfectly. Users get created (when they shouldn't due to the blocking function) and there are no errors in the logs.

My index.js file looks like this:

import * as v2 from "firebase-functions/v2";

import {
 beforeUserCreated,
 beforeUserSignedIn,
 } from "firebase-functions/v2/identity";

export const helloworld = v2.https.onRequest((request, response) => {
 response.send("Hello from Firebase!");
});


export const beforeusercreated = beforeUserCreated({ region: 'europe-west1' }, (event) => {
 const user = event.data;
 // Only users of a specific domain can sign up.
 if (!user.email || !user.email.endsWith("@example.com")) {
 throw new HttpsError("invalid-argument", "Unauthorized email");
 }
 });

I also get this in the function logs in the emulator:

✔ functions[us-central1-beforeusercreated]: providers/cloud.auth/eventTypes/user.beforeCreate function initialized (http://127.0.0.1:5101/univus-9457e/us-central1/beforeusercreated).

Can someone please help me out here. Has anyone found a solution to this?

I've tried changing the function names, nothing changes. There are no errors, no documentation anywhere!

I'm attempting to modify this feedforward network taken from https://github.com/yunjey/pytorch-tutorial/blob/master/tutorials/01-basics/feedforward_neural_network/main.py to utilize my own dataset.

I define a custom dataset of two 1 dim arrays as input and two scalars the corresponding output :

x = torch.tensor([[5.5, 3,3,4] , [1 , 2,3,4], [9 , 2,3,4]])
print(x)

y = torch.tensor([1,2,3])
print(y)

import torch.utils.data as data_utils

my_train = data_utils.TensorDataset(x, y)
my_train_loader = data_utils.DataLoader(my_train, batch_size=50, shuffle=True)

I've updated the hyperparameters to match new input_size (2) & num_classes (3).

I've also changed images = images.reshape(-1, 28*28).to(device) to images = images.reshape(-1, 4).to(device)

As the training set is minimal I've changed the batch_size to 1.

Upon making these modifications I receive error when attempting to train :

RuntimeError Traceback (most recent call
> last) <ipython-input-52-9cdca58f3ef6> in <module>()
> 51 
> 52 # Forward pass
> ---> 53 outputs = model(images)
> 54 loss = criterion(outputs, labels)
> 55 
> 
> /home/.local/lib/python3.6/site-packages/torch/nn/modules/module.py in __call__(self, *input, **kwargs)
> 489 result = self._slow_forward(*input, **kwargs)
> 490 else:
> --> 491 result = self.forward(*input, **kwargs)
> 492 for hook in self._forward_hooks.values():
> 493 hook_result = hook(self, input, result)
> 
> <ipython-input-52-9cdca58f3ef6> in forward(self, x)
> 31 
> 32 def forward(self, x):
> ---> 33 out = self.fc1(x)
> 34 out = self.relu(out)
> 35 out = self.fc2(out)
> 
> /home/.local/lib/python3.6/site-packages/torch/nn/modules/module.py in __call__(self, *input, **kwargs)
> 489 result = self._slow_forward(*input, **kwargs)
> 490 else:
> --> 491 result = self.forward(*input, **kwargs)
> 492 for hook in self._forward_hooks.values():
> 493 hook_result = hook(self, input, result)
> 
> /home/.local/lib/python3.6/site-packages/torch/nn/modules/linear.py in forward(self, input)
> 53 
> 54 def forward(self, input):
> ---> 55 return F.linear(input, self.weight, self.bias)
> 56 
> 57 def extra_repr(self):
> 
> /home/.local/lib/python3.6/site-packages/torch/nn/functional.py
> in linear(input, weight, bias)
> 990 if input.dim() == 2 and bias is not None:
> 991 # fused op is marginally faster
> --> 992 return torch.addmm(bias, input, weight.t())
> 993 
> 994 output = input.matmul(weight.t())
> 
> RuntimeError: size mismatch, m1: [3 x 4], m2: [2 x 3] at
> /pytorch/aten/src/THC/generic/THCTensorMathBlas.cu:249

How to amend code to match expected dimensionality ? I'm unsure what code to change as I've changed all parameters that require updating ?

Source prior to changes :

import torch
import torch.nn as nn
import torchvision
import torchvision.transforms as transforms


# Device configuration
device = torch.device('cuda' if torch.cuda.is_available() else 'cpu')

# Hyper-parameters 
input_size = 784
hidden_size = 500
num_classes = 10
num_epochs = 5
batch_size = 100
learning_rate = 0.001

# MNIST dataset 
train_dataset = torchvision.datasets.MNIST(root='../../data', 
 train=True, 
 transform=transforms.ToTensor(), 
 download=True)

test_dataset = torchvision.datasets.MNIST(root='../../data', 
 train=False, 
 transform=transforms.ToTensor())

# Data loader
train_loader = torch.utils.data.DataLoader(dataset=train_dataset, 
 batch_size=batch_size, 
 shuffle=True)

test_loader = torch.utils.data.DataLoader(dataset=test_dataset, 
 batch_size=batch_size, 
 shuffle=False)

# Fully connected neural network with one hidden layer
class NeuralNet(nn.Module):
 def __init__(self, input_size, hidden_size, num_classes):
 super(NeuralNet, self).__init__()
 self.fc1 = nn.Linear(input_size, hidden_size) 
 self.relu = nn.ReLU()
 self.fc2 = nn.Linear(hidden_size, num_classes) 
 
 def forward(self, x):
 out = self.fc1(x)
 out = self.relu(out)
 out = self.fc2(out)
 return out

model = NeuralNet(input_size, hidden_size, num_classes).to(device)

# Loss and optimizer
criterion = nn.CrossEntropyLoss()
optimizer = torch.optim.Adam(model.parameters(), lr=learning_rate) 

# Train the model
total_step = len(train_loader)
for epoch in range(num_epochs):
 for i, (images, labels) in enumerate(train_loader): 
 # Move tensors to the configured device
 images = images.reshape(-1, 28*28).to(device)
 labels = labels.to(device)
 
 # Forward pass
 outputs = model(images)
 loss = criterion(outputs, labels)
 
 # Backward and optimize
 optimizer.zero_grad()
 loss.backward()
 optimizer.step()
 
 if (i+1) % 100 == 0:
 print ('Epoch [{}/{}], Step [{}/{}], Loss: {:.4f}' 
 .format(epoch+1, num_epochs, i+1, total_step, loss.item()))

# Test the model
# In test phase, we don't need to compute gradients (for memory efficiency)
with torch.no_grad():
 correct = 0
 total = 0
 for images, labels in test_loader:
 images = images.reshape(-1, 28*28).to(device)
 labels = labels.to(device)
 outputs = model(images)
 _, predicted = torch.max(outputs.data, 1)
 total += labels.size(0)
 correct += (predicted == labels).sum().item()

 print('Accuracy of the network on the 10000 test images: {} %'.format(100 * correct / total))

# Save the model checkpoint
torch.save(model.state_dict(), 'model.ckpt')

Source post changes :

x = torch.tensor([[5.5, 3,3,4] , [1 , 2,3,4], [9 , 2,3,4]])
print(x)

y = torch.tensor([1,2,3])
print(y)

import torch.utils.data as data_utils

my_train = data_utils.TensorDataset(x, y)
my_train_loader = data_utils.DataLoader(my_train, batch_size=50, shuffle=True)

print(my_train)

print(my_train_loader)

import torch
import torch.nn as nn
import torchvision
import torchvision.transforms as transforms


# Device configuration
device = torch.device('cuda' if torch.cuda.is_available() else 'cpu')

# Hyper-parameters 
input_size = 2
hidden_size = 3
num_classes = 3
num_epochs = 5
batch_size = 1
learning_rate = 0.001

# MNIST dataset 
train_dataset = my_train

# Data loader
train_loader = my_train_loader

# Fully connected neural network with one hidden layer
class NeuralNet(nn.Module):
 def __init__(self, input_size, hidden_size, num_classes):
 super(NeuralNet, self).__init__()
 self.fc1 = nn.Linear(input_size, hidden_size) 
 self.relu = nn.ReLU()
 self.fc2 = nn.Linear(hidden_size, num_classes) 
 
 def forward(self, x):
 out = self.fc1(x)
 out = self.relu(out)
 out = self.fc2(out)
 return out

model = NeuralNet(input_size, hidden_size, num_classes).to(device)

# Loss and optimizer
criterion = nn.CrossEntropyLoss()
optimizer = torch.optim.Adam(model.parameters(), lr=learning_rate) 

# Train the model
total_step = len(train_loader)
for epoch in range(num_epochs):
 for i, (images, labels) in enumerate(train_loader): 
 # Move tensors to the configured device
 images = images.reshape(-1, 4).to(device)
 labels = labels.to(device)
 
 # Forward pass
 outputs = model(images)
 loss = criterion(outputs, labels)
 
 # Backward and optimize
 optimizer.zero_grad()
 loss.backward()
 optimizer.step()
 
 if (i+1) % 100 == 0:
 print ('Epoch [{}/{}], Step [{}/{}], Loss: {:.4f}' 
 .format(epoch+1, num_epochs, i+1, total_step, loss.item()))

# Test the model
# In test phase, we don't need to compute gradients (for memory efficiency)
with torch.no_grad():
 correct = 0
 total = 0
 for images, labels in test_loader:
 images = images.reshape(-1, 4).to(device)
 labels = labels.to(device)
 outputs = model(images)
 _, predicted = torch.max(outputs.data, 1)
 total += labels.size(0)
 correct += (predicted == labels).sum().item()

 print('Accuracy of the network on the 10000 test images: {} %'.format(100 * correct / total))

# Save the model checkpoint
torch.save(model.state_dict(), 'model.ckpt')

Hello I'm trying to find the next element of a node in a preorder traversal in a binary tree

eg: consider a BT

 1
 / \
 2 3
 / \ \
4 5 6
 /
 7

i want to write a recursive algorithm such that if the method input is a node like preOrder(2) -> 5

similarly preOrder(5) -> 7

But the problem arises when i have to visit the right subtree of the root node such as preOrder(7) -> 3

This is my code, I'm new to programming, so this might not be clean code. Aprreciate any help thanks

 public E preordernextRecursive(Node<E> node) {
 if (node == null) {
 return null;
 } 
 else if (node.left != null) {
 return node.left.element; 
 } 
 else if (node.right != null) {
 return node.right.element; 
 } 
 else if (node.parent != null && node.parent.left == node && node.parent.right != null) {
 return node.parent.right.element; 
 }
 else if((node.parent.left == node || node.parent.right == node) && node.left == null && node.right == null ) {
 return preordernextRecursive(node.parent); 
 }
 return null;
 }

WooCommerce Checkout Problem

About a week ago, with no changes to our code base, we started receiving fairly frequent order duplicates. There are no automatic updates applied to plugins or WordPress, and I'm the only one that has access to do these kinds of things. Approximately 1 order in 10 orders has a duplicate order. the customer would be contacted (or contact us) and offer some feedback on what they were seeing, which was mostly one of the two following errors:

• "Sorry, your session has expired."
• "Please check the reCaptcha box to place your order."

They had no idea that their order had already been created, and being the good customer that wanted their stuff, they would click on the place order button again.

Sometimes they would actually see no error message, and the AJAX call to /?wc-ajax=checkout would complete but not redirect them to the order confirmation page. This fact is an important thing to consider, because it means that if the result is success or failure, the order gets created, but the customer doesn't know it was created. On success, the browser isn't redirecting.

So as a temporary hack to find out what was going on, we altered the wp_send_json function in wp-includes/functions.php to provide some logging. We were then able to see what the JSON responses were, but nothing looked abnormal here. It did however show us that not all responses that included success as the result were being redirected to the order confirmation page:

{
 "result": "success",
 "redirect": "https://example.com/checkout/order-received/123456/?key=wc_order_ABCabc123xyz",
 "order_id": 123456
}

To me this looks like some sort of JavaScript error, as the success method of the AJAX call to wc_checkout_params.checkout_url should redirect the customer, but did not. So we tried disabling or deactivating many plugins and 3rd party JavaScript sources on the checkout page, but still no luck. We even tried disabling Varnish without success. We asked Cloudways if they had made any changes to the server, and they said no.

The next step was to prove that the JSON response from the server was actually received by checkout.js. So we hacked checkout.min.js adding a function to send a second AJAX call back to the server, with the response from the first call. That function looks something like this:

function logServerResponse(res,ts,xhr,err){
 var h = xhr && xhr.getAllResponseHeaders
 ? xhr.getAllResponseHeaders()
 : "N/A";
 var payload={
 result: res ? JSON.stringify(res) : "N/A",
 textStatus: ts,
 headers: h,
 error: err || ""
 };
 e.ajax({
 url:"/abc.php",
 method:"POST",
 cache:false,
 data:payload,
 dataType:"json"
 })
};

Function calls were added to the success and error methods of the first AJAX. The success and error methods themselves were also updated to include all the parameters needed to pass to logServerResponse:

Success modified

success:function(c,wy,wz){
 logServerResponse(c,wy,wz,"");
 //...
}

Error modified

error:function(e,o,c){
 logServerResponse(null,o,e,c);
 //...
}

This is when we realized that some of the responses from the server were just not showing up. The logging script at /abc.php would have logged something every time, but it doesn't:

<?php

$d = new DateTime('now', new DateTimeZone('America/Chicago') );

// Define the log file path
$logFile = __DIR__ . '/' . $d->format('Y-m-d') . '.log';

// Check if required keys exist in $_POST
if( 
 ! isset( $_POST['result'] ) OR
 ! isset( $_POST['textStatus'] ) OR 
 ! isset( $_POST['headers'] ) OR
 ! isset( $_POST['error'] )
){
 // Silently fail if all post vars not present
 http_response_code(200);
 exit;
}

// Prepare the log entry
$logEntry = [
 'timestamp' => $d->format('Y-m-d H:i:s'),
 'post_data' => [
 'result' => $_POST['result'],
 'textStatus' => $_POST['textStatus'],
 'headers' => $_POST['headers'],
 'error' => $_POST['error'],
 ]
];

// JSON-encode with pretty printing
$jsonData = json_encode(
 $logEntry, 
 JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE
);

if( $jsonData === FALSE )
{
 $jsonData = json_encode([
 'timestamp' => $d->format('Y-m-d H:i:s'),
 'message' => 'Posted data could not be encoded successfully',
 ]);
}

// Ensure the log entry ends with a newline, and add an extra empty line
$logContent = $jsonData . "\n\n";

// Append to the log file
if( file_put_contents( $logFile, $logContent, FILE_APPEND | LOCK_EX ) === FALSE )
{
 error_log("Failed to write to $logFile in abc.php");
}

if( ! is_file( $logFile ) OR ! is_writable( $logFile ) )
{
 error_log("$logFile is not writable in abc.php");
}

// Send a simple response (optional, for AJAX confirmation)
header('Content-Type: application/json');
echo json_encode([
 'status' => 'logged'
]);
ob_flush();
flush();

Also, to make things more complicated, it appears that a WooCommerce session related problem is the root cause of all of this. I say that because of the error messages that the customer sees (or sometimes doesn't see), and the fact that applying a recaptcha error uses the woocommerce_checkout_process action and wc_add_notice doesn't stop the process_checkout method of class-wc-checkout.php from creating the order. That combined with the fact that if we disable the reCaptcha completely, the customer will more than likely just see the "Sorry, your session has expired." error!

Another interesting fact is that I can place infinite orders in our development environment without the problem happening to me. Although the production website is hosting on a Cloudways managed Linode server, the development environment is a Ubuntu server that nearly matches the LAMP stack portion of what Cloudways has. For reference, the Cloudways stack is currently Varnish on top of nginx on top of apache.

Keep in mind that the problem is intermittent. Only about 1 in 10 orders are affected. Why would it just start one day, when we hadn't done any code changes in days? Why doesn't it affect all orders? What should I do now?

I must know, is there a different way to resolve this task?

May use only "If" and "else"

Without cycle, array and s.l.

Chess elephant move the diagonal. Given two different cage chessboard. Define, may elephant get with first cage at second one move.

Entrance data:

program gets four digital from 1 before 8 inclusive every, set item column and string begin for first cage, then for second string.

Get data user:

 "Yes" if from one move.
 "No" if no.

I write so:

 a = int(input())
 b = int(input())
 c = int(input())
 d = int(input())
 h = abs(a-c)
 if b+h==d or d+h==b:
 print("YES")
 else:
 print("NO")

Is there a different way?

I need to be able to trigger a event whenever an object is added to a Queue<Delegate>.

I created a new class that extends Queue:

public delegate void ChangedEventHandler(object sender, EventArgs e);

public class QueueWithChange<Delegate> : Queue<Delegate>
{
 public event ChangedEventHandler Changed;

 protected virtual void OnChanged(EventArgs e) {
 if (Changed != null)
 {
 Changed(this, e);
 }
 }
}

And then attached the event from another class, like such:

QueueWithChange<TimerDelegate> eventQueue = new QueueWithChange<TimerDelegate>();

//

eventQueue.Changed += new ChangedEventHandler(delegate(object s, EventArgs ex) {
 //This event is not being triggered, so this code is unreachable atm...and that is my problem

 if (eventQueue.Count > 0)
 {
 eventQueue.Dequeue().Invoke(new DispatcherTimer() { Interval = TimeSpan.FromMilliseconds(5) });
 actionTimer.Stop();
 }
});

But whenever I enqueue an object (eventQueue.Enqueue(something)), the attached event is not being fired.

What am I missing here?

I have a long macro that is running in my Google Sheets. It take about 2 minutes to finish. It continually loads each of the 24 tabs as it processes the macro. I know this is taking time and would prefer it not to show the screen updating. I have tried "SpreadsheetApp.ScreenUpdating = False" and "Application.ScreenUpdating = False" with no success. How do I stop the screen from updating with the macro?

I tried

SpreadsheetApp.ScreenUpdating = False
Application.ScreenUpdating = False

with no success.

I want to write a book on programming. I need to target both print and HTML.

In order not to get burned with the code examples, I need to be able to include parts of source code which have been marked up with start and end points to ensure the code is up to date and compiles. Extract the code from external files if you will.

I would like some simple format such as Txt2tags rather than latex since I then can use word's fine spelling capabilities.

Any experiences you want to share?

I'm trying to follow the npgsql guide to map a class to a JSON column, but I cannot get past the following error:

System.InvalidOperationException: The entity type 'MainCategory' is not mapped to a table, therefore the entities cannot be persisted to the database. Call 'ToTable' in 'OnModelCreating' to map it to a table.

I have a model like this:

public class Post
{
 // ...
 public MainCategory MainCategory { get; set; } 
}

public class Category
{
}

public class Category<TParent> where TParent: Category
{
 // ...
 [JsonIgnore] 
 public TParent Parent { get; set; }
}

public class Category<TParent, TChildren> where TParent: Category, where TChildren: Category
{
 [Column(TypeName = "jsonb")] 
 public ICollection<Category> Children { get; set; }
}

public class MainCategory : Category<Category, Category>
{
}

With the following context:

public class MyContext : DbContext 
{
 public DbSet<Post> Posts => Set<Post>();

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
 modelBuilder.Entity<Post>()
 .OwnsOne(c => c.MainCategory, r =>
 {
 r.ToJson();
 r.OwnsMany(c => c.Children);
 });

 base.OnModelCreating(modelBuilder);
 }
} 

The child categories have different properties so it's important for me to have the correct parent/child relationship across them - which would be very difficult if it was just Category all the way.

I also tried using two interfaces to represent parent/children, but I always end up with the same error. If I remove [Column(TypeName = "jsonb")] from Children, then I get

System.InvalidOperationException: 'Unable to determine the relationship represented by navigation 'OneOfTheSubCategories.Children' of type 'ICollection<Category>'. Either manually configure the relationship, or ignore this property using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.'

I'm not sure what I'm doing wrong or if this is an unsupported scenario altogether. I can use just string and do manual conversion on the Post class if needed, but I'm trying to avoid that.

This is using latest .NET 9.0 versions.

I'm migrating a functional mixin project from javascript to typescript. All my javascript minxins have constructor signatures with a single parameter constructor(props){} .

In typescript I have defined a mixin constructor type from following the official docs at https://www.typescriptlang.org/docs/handbook/mixins.html :

export type ConstrainedMixin<T = {}> = new (...args: any[]) => T;

Even if I change that mixin signature to:

export type ConstrainedMixin<T = {}> = new (props: any) => T;

and update the implementations TSC will throw an error:

TS2545: A mixin class must have a constructor with a single rest parameter of type 'any[]'.

This is unfortunate because it doesn't enable creating unique type signatures for the parameters passed to the constructor. I also now need to migrate all my existing constructors. How can I create more explicit type interfaces for the mixin constructors?

I have created a playground example

You can see in this screen shot that the compiler errors on the MIXIN definition and says a mixin class must have a single rest parameter. even though the type definition is:

type ConstrainedMixin<T = {}> = new (props: any) => T;

In the example I have const mg = new MixedGeneric({cool: 'bro'}); I would like to create an interface for that {cool: 'bro'} object and enforce it from within the mixin definition. I"m not sure how to properly do this. If the constructor is ...args: any[]

Update sounds like this may be some anti pattern so here is further explanation. I am building an entity component system. In my current implementation I have chains of mixins like:

const MixedEntity = RenderMixin(PhysicsMixin(GeometryMixin(Entity));
const entityInstance = new MixedEntity({bunch: "of", props: "that mixins use"});

When the final MixedEntity is instantiated it is passed a props data bag object. All the Mixins have their own initialization logic in their constructors that looks for specific properties on the props object.

where my previous mixin classes had constructors like:

constructor(props){
 super(props);
 if(props.Thing) // do props.thing
}

I now have to migrate the constructors to :

constructor(...args: any[]){
 const props = args[0]
 super(props);
 if(props.Thing) // do props thing
} 

TLDR; Is there a way (using a type map or some other solution) to give dynamic result sets a default name, such as "(No Column Name)" in Dapper when no column name is supplied?

I am writing a query editor that allows users to write and run user-supplied queries against MS SQL Server databases. I've been using Dapper for all our querying and it has been working beautifully for 99% of what we need. I've hit a snag though and I'm hoping someone has a solution.

The query editor is similar to SSMS. I don't know ahead of time what the script will look like, what the shape or type the result set(s) will be, or even how many result sets will be returned. For this reason, I've been batching the scripts and using Dapper's QueryMultiple to read dynamic results from the GridReader. The results are then sent to a third party UI data grid (WPF). The data grid knows how to consume dynamic data and the only thing it requires to display a given row is at least one key value pair with a non-null, but not necessarily unique key and a nullable value. So far, so good.

The simplified version of the Dapper call looks something like this:

 public async Task<IEnumerable<IEnumerable<T>>> QueryMultipleAsync<T>(string sql, 
 object parameters, 
 string connectionString,
 CommandType commandType = CommandType.Text, 
 CancellationTokenSource cancellationTokenSource = null)
 {
 using (IDbConnection con = _dbConnectionFactory.GetConnection(connectionString))
 {

 con.Open();
 var transaction = con.BeginTransaction();

 var sqlBatches = sql
 .ToUpperInvariant()
 .Split(new[] { " GO ", "\r\nGO ", "\n\nGO ", "\nGO\n", "\tGO ", "\rGO "}, StringSplitOptions.RemoveEmptyEntries);

 var batches = new List<CommandDefinition>();

 foreach(var batch in sqlBatches)
 {
 batches.Add(new CommandDefinition(batch, parameters, transaction, null, commandType, CommandFlags.Buffered, cancellationTokenSource.Token));
 }

 var resultSet = new List<List<T>>();

 foreach (var commandDefinition in batches)
 {
 using (GridReader reader = await con.QueryMultipleAsync(commandDefinition))
 {
 while (!reader.IsConsumed)
 {
 try
 {
 var result = (await reader.ReadAsync<T>()).AsList();
 if (result.FirstOrDefault() is IDynamicMetaObjectProvider)
 {
 (result as List<dynamic>).ConvertNullKeysToNoColumnName();
 }
 resultSet.Add(result);
 }
 catch(Exception e)
 {
 if(e.Message.Equals("No columns were selected"))
 {
 break;
 }
 else
 {
 throw;
 }
 }
 }
 }
 }
 try
 {
 transaction.Commit();
 }
 catch (Exception ex)
 {
 Trace.WriteLine(ex.ToString());
 if (transaction != null)
 {
 transaction.Rollback();
 }
 }

 return resultSet;
 }
 }

public static IEnumerable<dynamic> ConvertNullKeysToNoColumnName<dynamic>(this IEnumerable<dynamic> rows)
 {
 foreach (var row in rows)
 {
 if (row is IDictionary<string, object> rowDictionary)
 {
 if (rowDictionary == null) continue;

 rowDictionary.Where(x => string.IsNullOrEmpty(x.Key)).ToList().ForEach(x =>
 {
 var val = rowDictionary[x.Key];

 if (x.Value == val)
 {
 rowDictionary.Remove(x);
 rowDictionary.Add("(No Column Name)", val);
 }
 else
 {
 Trace.WriteLine("Something went wrong");
 }
 });
 }
 }
 return rows;
 } 

This works with most queries (and for queries with only one unnamed result column), but the problem manifests when the user writes a query with more than one unnamed column like this:

select COUNT(*), MAX(create_date) from sys.databases.

In this case, Dapper returns a DapperRow that looks something like this:

{DapperRow, = '9', = '2/14/2020 9:51:54 AM'}

So the result set is exactly what the user asks for (i.e., values with no names or aliases) but I need to supply (non-unique) keys for all data in the grid...

My first thought was to simply change the null keys in the DapperRow object to a default value (like '(No Column Name)'), as it appears to be optimized for storage so table keys are only stored once in the object (which is nice and would provide a nice performance bonus for queries with huge result sets). The DapperRow type is private though. After searching around, I found that I could cast the DapperRow to an IDictionary<string, object> to access keys and values for the object, and even set and remove values. That's where the ConvertNullKeysToNoColumnName extension method comes from. And it works... But only once.

Why? Well, it appears that when you have multiple null or empty keys in a DapperRow that gets cast to an IDictionary<string,object> and you call the Remove(x) function (where x is the entire item OR just the key for any single item with a null or empty key), all subsequent attempts to resolve other values with a null or empty key via the indexer item[key] fail to retrieve a value--even if the additional key value pairs still exist in the object.

In other words, I can't remove or replace subsequent empty keys after the first one is removed.

Am I missing something obvious? Do I just need to alter the DapperRow via reflection and hope it doesn't have any weird side affects or that the underlying data structure doesn't change later? Or do I take the performance/memory hit and just copy/map the entire potentially large result set into a new sequence to give empty keys a default value at runtime?

I have found similar questions here and here, but no one is talking about my exact issue, which involves MacOS (I believe).

I am writing shell scripts, one that launches a screen session and immediately executes a uvicorn application in python, while the other gracefully ends the uvicorn process and retains all the logging I care about. I am writing this for two different OSs: one on MacOS and the other on some flavor of Linux. The exact command that launches the screen sessions is

screen -S myscreen -dm "$0"

The reason for passing $0 as the command is that the script as a whole is recursive and checks "if it's in a screen, do this, otherwise launch the screen", and this is working fine. The code that launches the python is

python script.py 2>&1 | tee -ia output.log

This piping is done for logging purposes.

The output from uvicorn in script.py is

INFO: Started server process [59411]
INFO: Waiting for application startup.
INFO: Application startup complete.
INFO: Uvicorn running on http://127.0.0.1:8000 (Press CTRL+C to quit)

Now, I have a second script that is supposed to kill the process in the screen. Ideally, I don't want to kill the screen, I want to pass Ctrl-C to the process in the screen and let the log complete and the process finish gracefully. I have found three different approaches thus far:

screen -S <pid>.myscreen -X quit
# or
screen -S <pid>.myscreen -X stuff "^C"
# or
screen -S <pid>.myscreen -X stuff $'\003'

Each one works totally fine on the Linux OS I am using. However, each one has an issue on MacOS that I can't get around.

screen -S <pid>.myscreen -X quit # Quits the process, ends uvicorn, screen vanishes,
 # but the tty remains as an active process and the port remains bound.
screen -S <pid>.myscreen -X stuff "^C" # Adds Ctrl-C to the input buffer in the screen,
 # and it just sits there, and the process continues.
screen -S <pid>.myscreen -X stuff $'\003' # Sends EOT character. This works only SOMETIMES.
 # I sometimes have to pass this 5+ times for it to actually function.

So my questions are:

1. Is there a good way to pass either a Ctrl-C or SIGINT to the screen session that makes it end gracefully on MacOS, or should I just resort to kill, which would require the extra effort of grabbing the process ID of uvicorn (yes, it's sitting on the first line, I just haven't written the logic to grab it)?
2. What is MacOS doing that is getting in the way of this seemingly simple process?

I have a Blazor server-side app and I replaced my memory cache ITicketStore implementation with a distributed cache using SQL Server. When running in IIS, the app's application pool is recycled every 24 hours.

The authentication cookie is a session cookie, so it is automatically removed once the user closes the browser tab or the browser itself.

In my above scenario, are there any advantages/benefits of using a distributed cache instead of a memory cache implementation?

Good morning, afternoon or evening!

I am using .NET, C# and its graphical API based on the GDI+. My program stumbles over an exception:

 System.ObjectDisposedException
 HResult=0x80131622
 Message=Cannot access a closed Stream.
 Source=mscorlib
 StackTrace:
 at System.IO.__Error.StreamIsClosed()

 This exception was originally thrown at this call stack:
 System.IO.__Error.StreamIsClosed()

The last part of the stack is:

 mscorlib.dll!System.IO.__Error.StreamIsClosed() Unknown
 mscorlib.dll!System.IO.MemoryStream.Position.get() Unknown
 System.Drawing.dll!System.Drawing.Internal.GPStream.Seek(long offset, int origin) Unknown
 [Native to Managed Transition] 
 [Managed to Native Transition] 
 System.Drawing.dll!System.Drawing.Graphics.DrawImage(System.Drawing.Image image, System.Drawing.PointF[] destPoints, System.Drawing.RectangleF srcRect, System.Drawing.GraphicsUnit srcUnit, System.Drawing.Imaging.ImageAttributes imageAttr, System.Drawing.Graphics.DrawImageAbort callback, int callbackData) Unknown
 System.Drawing.dll!System.Drawing.Graphics.DrawImage(System.Drawing.Image image, System.Drawing.PointF[] destPoints, System.Drawing.RectangleF srcRect, System.Drawing.GraphicsUnit srcUnit, System.Drawing.Imaging.ImageAttributes imageAttr) Unknown 

My code calls DrawImage (as you can see above). I will provide the parameter values later.

From my understanding, the GPStream object is internal (I certainly did not create it directly) and I did not touch it. How can I fix this?

Thanks for the hand!

I’ve been on SO for over 7 years. My engagement is mainly read-only. I hardly answer or comment but recently have wanted to.

After 7+ years of being a member I cannot comment on posts because I have less than 50 reputation points. It’s absolutely ridiculous imo.

Does SO want my money for fantasy reputation points so I can comment. As though we’re playing video games out here.

Can the community please upvote this question and my answer below so I can reach 50 points and bloody well comment. I get nothing out of this except helping the SO community.