问:
Submenus In Custom WordPress Theme Open Down, I Need Them To Open To The Right
I'm an SEO working on a client site, but technical elements are still a struggle for me. I just changed the navigation menu to include submenus, but they open straight down. I need them to open to the right so all menu items are accessible.

I'm not super techy so I'm having difficulty figuring out how to do it on this custom theme. I know in Astra a simple command fixes this, but it doesn't work because it's a custom theme.

Below is the code. I Need the submenus below "Industrues" (Manufacturing and Warehouse, Hospitality Pest Control, etc.) to pop out to the right when I hover over Industries (not down as they are currently doing).

Any help would be much appreciated.

```<code></div><!-- /.search-form -->
    </li>
</ul>
                        </div><!-- /.header__actions -->

                        <div class="header__content">
                            <nav class="nav"><ul id="menu-main-menu" class="menu"><li id="menu-item-47" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-47"><a href="x">Residential</a>
<ul class="sub-menu">
    <li id="menu-item-613" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-613"><a href="x">Guardian Program</a></li>
    <li id="menu-item-612" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-612"><a href="x">Guardian Plus Program</a></li>
    <li id="menu-item-611" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-611"><a href="x">Guardian Complete</a></li>
    <li id="menu-item-610" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-610"><a href="x">Bed Bug Treatments</a></li>
    <li id="menu-item-614" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-614"><a href="x">Mosquito Mitigation Program</a></li>
    <li id="menu-item-616" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-616"><a href="x">Residential Termite Control</a></li>
    <li id="menu-item-3432" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3432"><a href="x">Stinging Insect Control</a></li>
</ul>
</li>
<li id="menu-item-269" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-269"><a href="x">Commercial</a>
<ul class="sub-menu">
    <li id="menu-item-3433" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-3433"><a href="x">Industries</a>
    <ul class="sub-menu">
        <li id="menu-item-3439" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3439"><a href="x">Manufacturing and Warehouse</a></li>
        <li id="menu-item-3440" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3440"><a href="x/">Hospitality Pest Control</a></li>
        <li id="menu-item-3437" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3437"><a href="x">Higher Education Pest Control</a></li>
        <li id="menu-item-3438" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3438"><a href="x">Food Manufacturing Pest Control</a></li>
        <li id="menu-item-3436" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3436"><a href="x">Pharmaceutical Manufacturing Pest Control</a></li>
        <li id="menu-item-3435" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3435"><a href="x">Apartment Management Pest Control</a></li>
    </ul>
</li>
</code>```

Adding commands into the CSS Classes under Appearance, Menus

Body:
I'm an SEO working on a client site, but technical elements are still a struggle for me. I just changed the navigation menu to include submenus, but they open straight down. I need them to open to the right so all menu items are accessible.

I'm not super techy so I'm having difficulty figuring out how to do it on this custom theme. I know in Astra a simple command fixes this, but it doesn't work because it's a custom theme.

Below is the code. I Need the submenus below "Industrues" (Manufacturing and Warehouse, Hospitality Pest Control, etc.) to pop out to the right when I hover over Industries (not down as they are currently doing).

Any help would be much appreciated.

Residential

Guardian Program

Guardian Plus Program

Guardian Complete

Bed Bug Treatments

Mosquito Mitigation Program

Residential Termite Control

Stinging Insect Control

Commercial

Industries

Manufacturing and Warehouse

Hospitality Pest Control

Higher Education Pest Control

Food Manufacturing Pest Control

Pharmaceutical Manufacturing Pest Control

Apartment Management Pest Control

Adding commands into the CSS Classes under Appearance, Menus


来源: stackexchange

问:
How can I synchronize Azure DevOps repository content with a Microsoft Teams sharepoint
I have an azure DevOps repo and a sharepoint from Microsoft Teams. I'd like to have the content of the repository automatically loaded into the sharepoint. In the DevOps repo, I can run a pipeline and execute scripts that would do this job, but is there a sharepoint API with a key I can use to load the repository content into the sharepoint?</p>

ContentLicense: CC BY-SA 4.0


问:
Simulate execution of system back button
There is a single screen in an app with a button in the center. When such button is pressed the following code will execute:

```<code>Navigator.of(context).pop();
</code>```

A black screen will be the next presentation after the given code finishes its execution. However, this is not the desired view. Instead, it's expected that the system pops out the app itself.

how can such a goal be accomplished?

Body:
There is a single screen in an app with a button in the center. When such button is pressed the following code will execute:

Navigator.of(context).pop();

A black screen will be the next presentation after the given code finishes its execution. However, this is not the desired view. Instead, it's expected that the system pops out the app itself.

how can such a goal be accomplished?


问:
Amazon S3 Multipart Upload Fails at 21% in Paws::S3, Net::Amazon::S3::Client and Amazon::S3
I've been attempting to do a simple, but large file upload to S3 in Perl. Using Paws::S3, Net::Amazon::S3::Client and Amazon::S3, it fails at around 21% of the chunks being uploaded -- the first chunks go fine, but no matter how small or large of chunks I go with, at approximately that percentage of them, it fails. I've run into problems trying to use Net::Amazon::S3::Client more generally, but have kludged my way past the issue in this other question for now.

I'm suspecting this is an S3 issue at this point, since I'm using two completely separate Perl libraries to attempt the upload, although perhaps both libraries have the same flaw. The Paws::S3 library simply pauses for a long time, outputs so much gibberish that it crashes my Terminal app and dies. Net::Amazon::S3::Client at least gives a bit more of a meaningful error output:

```<code>Subroutine Net::Amazon::S3::Client::Object::put_part redefined at ftBackupPaws.pl line 136, <FH> line 14.
Progress:  21% [=======================================                                                                                ]ETA  12:05500: write failed:  at /usr/local/share/perl5/Net/Amazon/S3/Error/Handler/Confess.pm line 35.
    Net::Amazon::S3::Error::Handler::Confess::handle_error(Net::Amazon::S3::Error::Handler::Confess=HASH(0x55b8d529af68), Net::Amazon::S3::Operation::Object::Upload::Part::Response=HASH(0x55b8d5ca7d50)) called at /usr/local/share/perl5/Net/Amazon/S3.pm line 393
    Net::Amazon::S3::_perform_operation(Net::Amazon::S3=HASH(0x55b8d55a6fb0), "Net::Amazon::S3::Operation::Object::Upload::Part", "error_handler", Net::Amazon::S3::Error::Handler::Confess=HASH(0x55b8d529af68), "bucket", "MyBucketName", "part_number", 21, ...) called at /usr/local/share/perl5/Net/Amazon/S3/Client.pm line 109
    Net::Amazon::S3::Client::_perform_operation(Net::Amazon::S3::Client=HASH(0x55b8d044cab0), "Net::Amazon::S3::Operation::Object::Upload::Part", "bucket", "MyBucketName", "headers", HASH(0x55b8d601b8c0), "part_number", 21, ...) called at /usr/local/share/perl5/Net/Amazon/S3/Client/Bucket.pm line 197
    Net::Amazon::S3::Client::Bucket::_perform_operation(Net::Amazon::S3::Client::Bucket=HASH(0x55b8d55a6fc8), "Net::Amazon::S3::Operation::Object::Upload::Part", "key", "multipart1", "part_number", 21, "headers", HASH(0x55b8d601b8c0), ...) called at /usr/local/share/perl5/Net/Amazon/S3/Client/Object.pm line 520
    Net::Amazon::S3::Client::Object::_perform_operation(Net::Amazon::S3::Client::Object=HASH(0x55b8d55a17b0), "Net::Amazon::S3::Operation::Object::Upload::Part", "upload_id", "BmDoBE8OdS8aUMUpP5m3jf9ltt7NmTiWuou01ODeW3YZzloElL3EnUcdApIX_"..., "part_number", 21, "headers", HASH(0x55b8d601b8c0), ...) called at ftBackupPaws.pl line 133
    main::__ANON__(Net::Amazon::S3::Client::Object=HASH(0x55b8d55a17b0), "upload_id", "theUploadId"..., "part_number", 21, "value", "\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}"...) called at ftBackupPaws.pl line 164
</code>```

The code that is presently doing the upload is, as I said, a bit of a kludge. Net::Amazon::S3::Client seems to have a bug that prevents it from initializing a multipart upload, so to get started, I used aws-cli to create get an upload id and hard coded it for the time being, just to try to assess how everything else worked. Here's the Paws::S3 version since it is less kludgy, but, again, they fail at the same point.

```<code>use Paws;
use Paws::Credential::Explicit;
use POSIX;
use Term::ProgressBar;

our $paws = Paws->new(config => {
  credentials => Paws::Credential::Explicit->new(
    access_key => $config{'access_key_id'},
    secret_key => $config{'access_key'}
  )
});

our $pawsS3 = Paws->service('S3', credentials => Paws::Credential::Explicit->new(
            access_key => $config{'access_key_id'},
            secret_key => $config{'access_key'}),
        region => 'us-east-1');

my $CreateMultipartUploadOutput = $pawsS3->CreateMultipartUpload(
    'Bucket' => $bucketName,
    'Key'    => 'backup/daily/2022-11-13/myaccount.tar.gz'
);

my $filename = "/backup/2022-12-13/accounts/myaccount.tar.gz";
my $size = -s $filename;
my $fiveMeg = (1024*1024*500);
my $parts = ceil($size / $fiveMeg);
my @manifest;

open(my $file, "/backup/2022-12-13/accounts/myaccount.tar.gz") or die("Error reading file, stopped");

my $progress = Term::ProgressBar->new({name  => 'Progress',
                                        count => $parts,
                                        ETA   => 'linear',
                                        remove => 1 });

for (my $i = 0; $i <= $parts; $i++) {
    my $chunk;
    my $offset = $i * $fiveMeg;

    read($file, $chunk, $fiveMeg, $offset);
    my $UploadPartOutput = $pawsS3->UploadPart(
        'Body'       => $chunk,
        'Bucket'     => $bucketName,
        'Key'        => 'backup/daily/2022-11-13/myaccount.tar.gz',
        'PartNumber' => $i + 1,
        'UploadId'   => $CreateMultipartUploadOutput->UploadId
    );

    push (@manifest, { 'ETag' => $UploadPartOutput->ETag, 'PartNumber' => $i +1 });

    $progressBarUpdate = $progress->update($i);
    say STDOUT 'Chunk ' . $i . '/' . $parts;
}

close(FILE);

    my $CompleteMultipartUploadOutput = $pawsS3->CompleteMultipartUpload(
        'Bucket'     => $bucketName,
        'Key'        => 'backup/daily/2022-11-13/myaccount.tar.gz',
        'MultipartUpload' => {
                'Parts' => \@manifest
            },
        'UploadId' => $CreateMultipartUploadOutput->UploadId
    );

    # Results:
    use Data::Dumper;
    say STDOUT Dumper $CompleteMultipartUploadOutput;
</code>```

I can provide the other code base, too, if that's helpful.

Update (December 15, 2022): So it must have something to do with the API and not S3 itself. To try to test it further, I modified my script to output the 18 chunks rather than upload them. I then tried to use the aws console app to to a multipart upload:

```<code>aws s3api create-multipart-upload --bucket mybucket --key 'multipart1'

aws s3api upload-part --bucket mybucket --key 'multipart1' --part-number 1 --body part0 --upload-id  [ID GOES HERE]
aws s3api upload-part --bucket mybucket --key 'multipart1' --part-number 2 --body part1 --upload-id  [ID GOES HERE]
# ....
</code>```

I went well beyond the stopping point in the Perl API and each upload successfully received an etag. So there's something in both Paws::S3 and Net::Amazon::S3::Client causing a disruption at around 2GB of uploads that doesn't happen in was-cli.

Updated (December 15, 2022): I tried Amazon::S3 and the result was the same: when it has uploaded 21%, it fails with:

```<code>Amazon::S3: Amazon responded with 500 write failed:   at /usr/local/share/perl5/Amazon/S3/Bucket.pm line 418 thread 2.
</code>```

I also tried iterating so that the program would hit the "troublemaking" bucket that appears at the 21% mark first. In doing so, the upload still failed at having uploaded 21% of the chunks -- so the failure seems to be tied somehow to how much stuff is being uploaded rather than it being something corrupt in a particular chunk.

Also, I tried implementing threading thinking maybe the upload was timing out. But queuing up the work into multiple threads didn't solve anything other than getting me to the failure point faster.

Body:
I've been attempting to do a simple, but large file upload to S3 in Perl. Using Paws::S3, Net::Amazon::S3::Client and Amazon::S3, it fails at around 21% of the chunks being uploaded -- the first chunks go fine, but no matter how small or large of chunks I go with, at approximately that percentage of them, it fails. I've run into problems trying to use Net::Amazon::S3::Client more generally, but have kludged my way past the issue in this other question for now.

I'm suspecting this is an S3 issue at this point, since I'm using two completely separate Perl libraries to attempt the upload, although perhaps both libraries have the same flaw. The Paws::S3 library simply pauses for a long time, outputs so much gibberish that it crashes my Terminal app and dies. Net::Amazon::S3::Client at least gives a bit more of a meaningful error output:

Subroutine Net::Amazon::S3::Client::Object::put_part redefined at ftBackupPaws.pl line 136, <FH> line 14.
Progress:  21% [=======================================                                                                                ]ETA  12:05500: write failed:  at /usr/local/share/perl5/Net/Amazon/S3/Error/Handler/Confess.pm line 35.
    Net::Amazon::S3::Error::Handler::Confess::handle_error(Net::Amazon::S3::Error::Handler::Confess=HASH(0x55b8d529af68), Net::Amazon::S3::Operation::Object::Upload::Part::Response=HASH(0x55b8d5ca7d50)) called at /usr/local/share/perl5/Net/Amazon/S3.pm line 393
    Net::Amazon::S3::_perform_operation(Net::Amazon::S3=HASH(0x55b8d55a6fb0), "Net::Amazon::S3::Operation::Object::Upload::Part", "error_handler", Net::Amazon::S3::Error::Handler::Confess=HASH(0x55b8d529af68), "bucket", "MyBucketName", "part_number", 21, ...) called at /usr/local/share/perl5/Net/Amazon/S3/Client.pm line 109
    Net::Amazon::S3::Client::_perform_operation(Net::Amazon::S3::Client=HASH(0x55b8d044cab0), "Net::Amazon::S3::Operation::Object::Upload::Part", "bucket", "MyBucketName", "headers", HASH(0x55b8d601b8c0), "part_number", 21, ...) called at /usr/local/share/perl5/Net/Amazon/S3/Client/Bucket.pm line 197
    Net::Amazon::S3::Client::Bucket::_perform_operation(Net::Amazon::S3::Client::Bucket=HASH(0x55b8d55a6fc8), "Net::Amazon::S3::Operation::Object::Upload::Part", "key", "multipart1", "part_number", 21, "headers", HASH(0x55b8d601b8c0), ...) called at /usr/local/share/perl5/Net/Amazon/S3/Client/Object.pm line 520
    Net::Amazon::S3::Client::Object::_perform_operation(Net::Amazon::S3::Client::Object=HASH(0x55b8d55a17b0), "Net::Amazon::S3::Operation::Object::Upload::Part", "upload_id", "BmDoBE8OdS8aUMUpP5m3jf9ltt7NmTiWuou01ODeW3YZzloElL3EnUcdApIX_"..., "part_number", 21, "headers", HASH(0x55b8d601b8c0), ...) called at ftBackupPaws.pl line 133
    main::__ANON__(Net::Amazon::S3::Client::Object=HASH(0x55b8d55a17b0), "upload_id", "theUploadId"..., "part_number", 21, "value", "\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}"...) called at ftBackupPaws.pl line 164

The code that is presently doing the upload is, as I said, a bit of a kludge. Net::Amazon::S3::Client seems to have a bug that prevents it from initializing a multipart upload, so to get started, I used aws-cli to create get an upload id and hard coded it for the time being, just to try to assess how everything else worked. Here's the Paws::S3 version since it is less kludgy, but, again, they fail at the same point.

use Paws;
use Paws::Credential::Explicit;
use POSIX;
use Term::ProgressBar;

our $paws = Paws->new(config => {
  credentials => Paws::Credential::Explicit->new(
    access_key => $config{'access_key_id'},
    secret_key => $config{'access_key'}
  )
});

our $pawsS3 = Paws->service('S3', credentials => Paws::Credential::Explicit->new(
            access_key => $config{'access_key_id'},
            secret_key => $config{'access_key'}),
        region => 'us-east-1');

my $CreateMultipartUploadOutput = $pawsS3->CreateMultipartUpload(
    'Bucket' => $bucketName,
    'Key'    => 'backup/daily/2022-11-13/myaccount.tar.gz'
);

my $filename = "/backup/2022-12-13/accounts/myaccount.tar.gz";
my $size = -s $filename;
my $fiveMeg = (1024*1024*500);
my $parts = ceil($size / $fiveMeg);
my @manifest;

open(my $file, "/backup/2022-12-13/accounts/myaccount.tar.gz") or die("Error reading file, stopped");

my $progress = Term::ProgressBar->new({name  => 'Progress',
                                        count => $parts,
                                        ETA   => 'linear',
                                        remove => 1 });

for (my $i = 0; $i <= $parts; $i++) {
    my $chunk;
    my $offset = $i * $fiveMeg;

    read($file, $chunk, $fiveMeg, $offset);
    my $UploadPartOutput = $pawsS3->UploadPart(
        'Body'       => $chunk,
        'Bucket'     => $bucketName,
        'Key'        => 'backup/daily/2022-11-13/myaccount.tar.gz',
        'PartNumber' => $i + 1,
        'UploadId'   => $CreateMultipartUploadOutput->UploadId
    );

    push (@manifest, { 'ETag' => $UploadPartOutput->ETag, 'PartNumber' => $i +1 });

    $progressBarUpdate = $progress->update($i);
    say STDOUT 'Chunk ' . $i . '/' . $parts;
}

close(FILE);

    my $CompleteMultipartUploadOutput = $pawsS3->CompleteMultipartUpload(
        'Bucket'     => $bucketName,
        'Key'        => 'backup/daily/2022-11-13/myaccount.tar.gz',
        'MultipartUpload' => {
                'Parts' => \@manifest
            },
        'UploadId' => $CreateMultipartUploadOutput->UploadId
    );

    # Results:
    use Data::Dumper;
    say STDOUT Dumper $CompleteMultipartUploadOutput;

I can provide the other code base, too, if that's helpful.

Update (December 15, 2022): So it must have something to do with the API and not S3 itself. To try to test it further, I modified my script to output the 18 chunks rather than upload them. I then tried to use the aws console app to to a multipart upload:

aws s3api create-multipart-upload --bucket mybucket --key 'multipart1'

aws s3api upload-part --bucket mybucket --key 'multipart1' --part-number 1 --body part0 --upload-id  [ID GOES HERE]
aws s3api upload-part --bucket mybucket --key 'multipart1' --part-number 2 --body part1 --upload-id  [ID GOES HERE]
# ....

I went well beyond the stopping point in the Perl API and each upload successfully received an etag. So there's something in both Paws::S3 and Net::Amazon::S3::Client causing a disruption at around 2GB of uploads that doesn't happen in was-cli.

Updated (December 15, 2022): I tried Amazon::S3 and the result was the same: when it has uploaded 21%, it fails with:

Amazon::S3: Amazon responded with 500 write failed:   at /usr/local/share/perl5/Amazon/S3/Bucket.pm line 418 thread 2.

I also tried iterating so that the program would hit the "troublemaking" bucket that appears at the 21% mark first. In doing so, the upload still failed at having uploaded 21% of the chunks -- so the failure seems to be tied somehow to how much stuff is being uploaded rather than it being something corrupt in a particular chunk.

Also, I tried implementing threading thinking maybe the upload was timing out. But queuing up the work into multiple threads didn't solve anything other than getting me to the failure point faster.


问:
plotly graph objects persistent data labels when clicking the graph
I'm generating a graph:

```<code>import plotly.graph_objects as go
</code>```

When I click on a data point I get the x,y data as shown, but as soon as I move the mouse pointer to a different data point then the other disappears.

I want to have both points appear on the graph in the same image at the same time so that I can compare them.  Is there a way of doing this?

Body:
I'm generating a graph:

import plotly.graph_objects as go

When I click on a data point I get the x,y data as shown, but as soon as I move the mouse pointer to a different data point then the other disappears.

I want to have both points appear on the graph in the same image at the same time so that I can compare them.  Is there a way of doing this?


问:
After Writing in the constructor parameter the router linkstop working
follow is my code, if I emty the construction parameter thecode will work.but Likethis router linkwill not work.</p>
```<code>import { Component, OnInit } from '@angular/core';
import { AuthService } from '../auth.service';

@Component({
  selector: 'app-login',
  templateUrl: './login.component.html',
  styleUrls: ['./login.component.scss']
})
export class LoginComponent implements OnInit {

  constructor(private afAuth : AuthService) { }

  ngOnInit(): void {
  }
  login(){

  }

}
</code>```

Body:
follow is my code, if I emty the construction parameter thecode will work.but Likethis router linkwill not work.

import { Component, OnInit } from '@angular/core';
import { AuthService } from '../auth.service';

@Component({
  selector: 'app-login',
  templateUrl: './login.component.html',
  styleUrls: ['./login.component.scss']
})
export class LoginComponent implements OnInit {

  constructor(private afAuth : AuthService) { }

  ngOnInit(): void {
  }
  login(){

  }

}


问:
Where is the best place to put common (library) code for Netlify functions
Often I have code reused by multiple Netlify functions in the same project.

I know that anything within my /functions directory will become a function so I don't want to nest directories there. I could include it in /src, but if feels odd to comingle source with my single-page app (SPA) since they have different dependencies.

Is there a good convention for where to put this code? I can't seem to find any answer to this in any of Netlify's documentation.


问:
missing FROM-clause in posgressql
I'm facing the below error while executing the below SQL statement in Django after converting from sqlite to postgressql, it was working fine with sqlite.

```<code>         joined_data = HistoryTable.objects.raw(

        '''
        SELECT pages_historytable.id, pages_historytable.dial, pages_historytable.request_status, pages_historytable.summary, pages_historytable.registration_date, dashboard_storesemails.emails, dashboard_storescode.agent_name
        FROM pages_historytable
        LEFT JOIN dashboard_storescode
        ON pages_historytable.dial = dashboard_storescode.dial
        LEFT JOIN dashboard_storesmails
        ON dashboard_storescode.shop_code = dashboard_storesmails.dtscode
        WHERE pages_historytable.request_status = 'Rejected' AND pages_historytable.Today_Date =  %s;

        ''',[today])
</code>```

The error is

```<code>missing FROM-clause entry for table "dashboard_storesemails"
LINE 2: ...le.summary, pages_historytable.registration_date, dashboard_...
</code>```

Title: missing FROM-clause in posgressql

Body:
I'm facing the below error while executing the below SQL statement in Django after converting from sqlite to postgressql, it was working fine with sqlite.

         joined_data = HistoryTable.objects.raw(

        '''
        SELECT pages_historytable.id, pages_historytable.dial, pages_historytable.request_status, pages_historytable.summary, pages_historytable.registration_date, dashboard_storesemails.emails, dashboard_storescode.agent_name
        FROM pages_historytable
        LEFT JOIN dashboard_storescode
        ON pages_historytable.dial = dashboard_storescode.dial
        LEFT JOIN dashboard_storesmails
        ON dashboard_storescode.shop_code = dashboard_storesmails.dtscode
        WHERE pages_historytable.request_status = 'Rejected' AND pages_historytable.Today_Date =  %s;

        ''',[today])

The error is

missing FROM-clause entry for table "dashboard_storesemails"
LINE 2: ...le.summary, pages_historytable.registration_date, dashboard_...


问:
Blazor Wasm AOT build Precompiling failed
I have been trying to build my Blazor Wasm application with AOT turned on, but I get failed builds all the time. I have looked in the updates for the Nuget packages, but everything seems in order. I have looked all over the Web and I can't seem to find anything related, has anyone seen this before. It worked in net 6 and if I turn the AOT to false, it works.

All errors look the same and all relates to

```<code>C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Precompiling failed for C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll with exit code 1. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Private.CoreLib.dl
l'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref System.Private.CoreLib[0000024D74966B70] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\net
7.0\linked\System.Private.CoreLib.dll[0000024D74964CB0]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'System.Private.CoreLib' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System
.Private.CoreLib.dll) [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Private.CoreLib.dll' has no debug directory. [
C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Priva
te.CoreLib.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Private.CoreLib (0000024D74966B70) into domain System.Web.WebPages.Razor.dll (0000024D749
5A0C0) and ALC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly System.Private.CoreLib[0000024D74966B70] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'System.Web.WebPages.Razor.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref System.Web.WebPages.Razor[0000024D74980D50] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\
net7.0\linked\System.Web.WebPages.Razor.dll[0000024D7497FE40]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'System.Web.WebPages.Razor' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\Sys
tem.Web.WebPages.Razor.dll) [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Web.WebPages.Razor (0000024D74980D50) into domain System.Web.WebPages.Razor.dll (0000024D
7495A0C0) and ALC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly System.Web.WebPages.Razor[0000024D74980D50] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Wor
k\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll' has no debug directory
. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'System.Web.WebPages.Razor.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'System.Web.WebPages.Razor.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Web.WebPages.Razor (0000024D74980D50) into domain System.Web.WebPages.Razor.dll (0000024D
7495A0C0) and ALC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono Ahead of Time compiler - compiling assembly C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPag
es.Razor.dll [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Requesting loading reference 0 (of 7) of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages
.Razor.dll [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading reference 0 of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll (defaul
t ALC), looking for mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Request to load mscorlib in alc 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll'. [C:\Work\D
ev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref mscorlib[0000024D74A0D610] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\msc
orlib.dll[0000024D74A0B870]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'mscorlib' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll) [C:\Wo
rk\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly mscorlib (0000024D74A0D610) into domain System.Web.WebPages.Razor.dll (0000024D7495A0C0) and ALC
 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly mscorlib[0000024D74A0D610] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll' has no debug directory. [C:\Work\Dev\Gi
t\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll
'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly found with the filesystem probing logic: 'mscorlib'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Ref addref System.Web.WebPages.Razor[0000024D74980D50] -> mscorlib[0000024D74A0D610]: 2 [C:\Work\Dev\Git
\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Requesting loading reference 0 (of 9) of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll [C:\Wo
rk\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading reference 0 of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll (default ALC), looking f
or System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Request to load System.Private.CoreLib in alc 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly already loaded in the active ALC: 'System.Private.CoreLib'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Ref addref mscorlib[0000024D74A0D610] -> System.Private.CoreLib[0000024D74966B70]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Requesting loading reference 1 (of 7) of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages
.Razor.dll [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading reference 1 of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll (defaul
t ALC), looking for System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Request to load System.Web in alc 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.dll'. [C:\Work
\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref System.Web[0000024D74A176B0] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\S
ystem.Web.dll[0000024D74A13970]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'System.Web' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.dll) [C
:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Web (0000024D74A176B0) into domain System.Web.WebPages.Razor.dll (0000024D7495A0C0) and A
LC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly System.Web[0000024D74A176B0] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.dll' has no debug directory. [C:\Work\Dev\
Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.d
ll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly found with the filesystem probing logic: 'System.Web'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Ref addref System.Web.WebPages.Razor[0000024D74980D50] -> System.Web[0000024D74A176B0]: 2 [C:\Work\Dev\G
it\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Failed to load method 0x6000011 from 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dl
l' due to Could not resolve type with token 0100001a from typeref (expected class 'System.Web.Compilation.BuildProvider' in assembly 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a') assembly:System.Web, V
ersion=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a type:System.Web.Compilation.BuildProvider member:(null). [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Run with MONO_LOG_LEVEL=debug for more information. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : AOT of image System.Web.WebPages.Razor.dll failed. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
</code>```

Body:
I have been trying to build my Blazor Wasm application with AOT turned on, but I get failed builds all the time. I have looked in the updates for the Nuget packages, but everything seems in order. I have looked all over the Web and I can't seem to find anything related, has anyone seen this before. It worked in net 6 and if I turn the AOT to false, it works.

All errors look the same and all relates to

C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Precompiling failed for C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll with exit code 1. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Private.CoreLib.dl
l'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref System.Private.CoreLib[0000024D74966B70] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\net
7.0\linked\System.Private.CoreLib.dll[0000024D74964CB0]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'System.Private.CoreLib' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System
.Private.CoreLib.dll) [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Private.CoreLib.dll' has no debug directory. [
C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Priva
te.CoreLib.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Private.CoreLib (0000024D74966B70) into domain System.Web.WebPages.Razor.dll (0000024D749
5A0C0) and ALC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly System.Private.CoreLib[0000024D74966B70] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'System.Web.WebPages.Razor.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref System.Web.WebPages.Razor[0000024D74980D50] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\
net7.0\linked\System.Web.WebPages.Razor.dll[0000024D7497FE40]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'System.Web.WebPages.Razor' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\Sys
tem.Web.WebPages.Razor.dll) [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Web.WebPages.Razor (0000024D74980D50) into domain System.Web.WebPages.Razor.dll (0000024D
7495A0C0) and ALC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly System.Web.WebPages.Razor[0000024D74980D50] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Wor
k\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll' has no debug directory
. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'System.Web.WebPages.Razor.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'System.Web.WebPages.Razor.dll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Web.WebPages.Razor (0000024D74980D50) into domain System.Web.WebPages.Razor.dll (0000024D
7495A0C0) and ALC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono Ahead of Time compiler - compiling assembly C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPag
es.Razor.dll [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Requesting loading reference 0 (of 7) of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages
.Razor.dll [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading reference 0 of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll (defaul
t ALC), looking for mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Request to load mscorlib in alc 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll'. [C:\Work\D
ev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref mscorlib[0000024D74A0D610] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\msc
orlib.dll[0000024D74A0B870]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'mscorlib' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll) [C:\Wo
rk\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly mscorlib (0000024D74A0D610) into domain System.Web.WebPages.Razor.dll (0000024D7495A0C0) and ALC
 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly mscorlib[0000024D74A0D610] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll' has no debug directory. [C:\Work\Dev\Gi
t\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll
'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly found with the filesystem probing logic: 'mscorlib'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Ref addref System.Web.WebPages.Razor[0000024D74980D50] -> mscorlib[0000024D74A0D610]: 2 [C:\Work\Dev\Git
\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Requesting loading reference 0 (of 9) of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll [C:\Wo
rk\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading reference 0 of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\mscorlib.dll (default ALC), looking f
or System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Request to load System.Private.CoreLib in alc 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly already loaded in the active ALC: 'System.Private.CoreLib'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Ref addref mscorlib[0000024D74A0D610] -> System.Private.CoreLib[0000024D74966B70]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Requesting loading reference 1 (of 7) of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages
.Razor.dll [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading reference 1 of C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dll (defaul
t ALC), looking for System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Request to load System.Web in alc 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader probing location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.dll'. [C:\Work
\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image addref System.Web[0000024D74A176B0] (default ALC) -> C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\S
ystem.Web.dll[0000024D74A13970]: 2 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Prepared to set up assembly 'System.Web' (C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.dll) [C
:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Loading assembly System.Web (0000024D74A176B0) into domain System.Web.WebPages.Razor.dll (0000024D7495A0C0) and A
LC 0000024D7495FB60 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly System.Web[0000024D74A176B0] added to ALC '(null)'[0000024D7495FB60], ref_count=1 [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Image 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.dll' has no debug directory. [C:\Work\Dev\
Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Loader loaded assembly from location: 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.d
ll'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly found with the filesystem probing logic: 'System.Web'. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Mono: Assembly Ref addref System.Web.WebPages.Razor[0000024D74980D50] -> System.Web[0000024D74A176B0]: 2 [C:\Work\Dev\G
it\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Failed to load method 0x6000011 from 'C:\Appl\Compile\Blazor\obj\Release\net7.0\linked\System.Web.WebPages.Razor.dl
l' due to Could not resolve type with token 0100001a from typeref (expected class 'System.Web.Compilation.BuildProvider' in assembly 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a') assembly:System.Web, V
ersion=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a type:System.Web.Compilation.BuildProvider member:(null). [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : Run with MONO_LOG_LEVEL=debug for more information. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]
C:\Program Files\dotnet\packs\Microsoft.NET.Runtime.WebAssembly.Sdk\7.0.0\Sdk\WasmApp.Native.targets(583,5): error : AOT of image System.Web.WebPages.Razor.dll failed. [C:\Work\Dev\Git\Instruments\Blazor\Blazor.csproj]


问:
Blazor webassembly app starts swagger automatically and I don't understand why
I have hosted Blazor Webassembly app.

My Program.cs in Server project has following code fragments related to swagger:

```<code>builder.Services.AddSwaggerGen(options =>
{
    options.EnableAnnotations();

    List<string> xmlFiles = Directory.GetFiles(AppContext.BaseDirectory, "*.xml", SearchOption.TopDirectoryOnly).ToList();
    xmlFiles.ForEach(xmlFile => options.IncludeXmlComments(xmlFile));

    options.SwaggerDoc("v1", new OpenApiInfo
    {
        Version = "v1",
        Title = "My API",
        TermsOfService = new Uri("https://website.com/terms"),
        License = new OpenApiLicense
        {
            Name = "License",
            Url = new Uri("https://website.com/license")
        },
        Contact = new OpenApiContact
        {
            Name = "Questions? Send email to support:",
            Email = "support@website.com"
        }
    });
});
</code>```

and

```<code>app.UseSwagger();
app.UseSwaggerUI(c =>
{
    c.SupportedSubmitMethods(new SubmitMethod[] { });
});
</code>```

As far as I can see there is no redirect, navigate, or @page directives that require Client to be initialized with swagger page. Nevertheless, when I start "Server" app that starts "Client", it ends up immediately at the following url:
https://localhost:7089/swagger/index.html

Question: How can I change this behavior?

Body:
I have hosted Blazor Webassembly app.

My Program.cs in Server project has following code fragments related to swagger:

builder.Services.AddSwaggerGen(options =>
{
    options.EnableAnnotations();

    List<string> xmlFiles = Directory.GetFiles(AppContext.BaseDirectory, "*.xml", SearchOption.TopDirectoryOnly).ToList();
    xmlFiles.ForEach(xmlFile => options.IncludeXmlComments(xmlFile));

    options.SwaggerDoc("v1", new OpenApiInfo
    {
        Version = "v1",
        Title = "My API",
        TermsOfService = new Uri("https://website.com/terms"),
        License = new OpenApiLicense
        {
            Name = "License",
            Url = new Uri("https://website.com/license")
        },
        Contact = new OpenApiContact
        {
            Name = "Questions? Send email to support:",
            Email = "support@website.com"
        }
    });
});

and

app.UseSwagger();
app.UseSwaggerUI(c =>
{
    c.SupportedSubmitMethods(new SubmitMethod[] { });
});

As far as I can see there is no redirect, navigate, or @page directives that require Client to be initialized with swagger page. Nevertheless, when I start "Server" app that starts "Client", it ends up immediately at the following url:
https://localhost:7089/swagger/index.html

Question: How can I change this behavior?


问:
Add an audio file to a Google slide using API or app script
I'm having trouble finding any reference in the documentation for both Google Slides API or Google Apps Script about programmatically adding an audio file to a slide.

For example, https://developers.google.com/apps-script/guides/slides/presentations there is no Audio in page elements type. However the action is allowed manually in the slide UI.

I tried making a request to the API with a createAudio similar to what is done for images

```<code>requests.append({
            'createImage': {
                'objectId': image_id,
                'url': image_url,
                'elementProperties': {
                    'pageObjectId': page_id,
                    'size': {
                        'height': emu4M,
                        'width': emu4M
                    },
                    'transform': {
                        'scaleX': 1,
                        'scaleY': 1,
                        'translateX': 100000,
                        'translateY': 100000,
                        'unit': 'EMU'
                    }
                }
            }
        })
</code>```

But I expected this to fail, I went to see if I could extend the functionality with Apps Script but I'm unsure if that is the correct path.

Does anyone have a work around for this?

Body:
I'm having trouble finding any reference in the documentation for both Google Slides API or Google Apps Script about programmatically adding an audio file to a slide.

For example, https://developers.google.com/apps-script/guides/slides/presentations there is no Audio in page elements type. However the action is allowed manually in the slide UI.

I tried making a request to the API with a createAudio similar to what is done for images

requests.append({
            'createImage': {
                'objectId': image_id,
                'url': image_url,
                'elementProperties': {
                    'pageObjectId': page_id,
                    'size': {
                        'height': emu4M,
                        'width': emu4M
                    },
                    'transform': {
                        'scaleX': 1,
                        'scaleY': 1,
                        'translateX': 100000,
                        'translateY': 100000,
                        'unit': 'EMU'
                    }
                }
            }
        })

But I expected this to fail, I went to see if I could extend the functionality with Apps Script but I'm unsure if that is the correct path.

Does anyone have a work around for this?


问:
SPARQL Distance problem WIKIDATA - problem with distance measuring
I am doing SPARQL exercise right now - I want to find all places that dont have airport in 100km range.
Right now I am stuck, cause I wanted to union them to filter data, but that isnt working.
Please help me to understand how to connect data to be able to filter the distance :)
To simplify code I changed all the cities to only Berlin.</p>
```<code>SELECT ?placeCoor WHERE{

  {
        SELECT ?placeCoor WHERE{
    ?place wdt:P31/wdt:P279* wd:Q1248784.
    ?place wdt:P625 ?placeCoor.
    }
  }
    UNION
  {
    SELECT DISTINCT ?berlinLoc WHERE {
     wd:Q64 wdt:P625 ?berlinLoc .

SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }                                                                }
   }
  FILTER (geof:distance(?placeCoor, ?berlinLoc) >5 )
}

</code>```

Body:
I am doing SPARQL exercise right now - I want to find all places that dont have airport in 100km range.
Right now I am stuck, cause I wanted to union them to filter data, but that isnt working.
Please help me to understand how to connect data to be able to filter the distance :)
To simplify code I changed all the cities to only Berlin.

SELECT ?placeCoor WHERE{

  {
        SELECT ?placeCoor WHERE{
    ?place wdt:P31/wdt:P279* wd:Q1248784.
    ?place wdt:P625 ?placeCoor.
    }
  }
    UNION
  {
    SELECT DISTINCT ?berlinLoc WHERE {
     wd:Q64 wdt:P625 ?berlinLoc .

SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }                                                                }
   }
  FILTER (geof:distance(?placeCoor, ?berlinLoc) >5 )
}


问:
2 device apns token device active for the same session FCM swiftui
I am trying to implement APNS on my app with Firebase, but my implementation currently has 2 active device tokens active:
enter image description here

How this can happen?
My implementation:

```<code>struct iOSApp: App {
    @UIApplicationDelegateAdaptor(AppDelegate.self) var delegate

    var body: some Scene {
        WindowGroup {

            let isLogin = UserDefaults.standard.bool(forKey: "isLogin")
            let isUser = UserDefaults.standard.bool(forKey: "isUser")

            let token = Messaging.messaging().fcmToken

            if(isLogin == false){
                LoginView(myFCMToken: token ?? "fcmioserrordan")
            }else
            {
                if(isUser == true){
                    UsersView(myFCMToken: token ?? "fcmioserrordan")
                }else{
                    RestaurantView(myFCMToken: token ?? "fcmioserrordan")
                }
            }
        }
    }
}

</code>```

Body:
I am trying to implement APNS on my app with Firebase, but my implementation currently has 2 active device tokens active:
enter image description here

How this can happen?
My implementation:

struct iOSApp: App {
    @UIApplicationDelegateAdaptor(AppDelegate.self) var delegate

    var body: some Scene {
        WindowGroup {

            let isLogin = UserDefaults.standard.bool(forKey: "isLogin")
            let isUser = UserDefaults.standard.bool(forKey: "isUser")

            let token = Messaging.messaging().fcmToken

            if(isLogin == false){
                LoginView(myFCMToken: token ?? "fcmioserrordan")
            }else
            {
                if(isUser == true){
                    UsersView(myFCMToken: token ?? "fcmioserrordan")
                }else{
                    RestaurantView(myFCMToken: token ?? "fcmioserrordan")
                }
            }
        }
    }
}


问:
Adobe Sign: How to suppress read-only mode in sent document
I've created an agreement with the agreements REST API and am displaying it in an iframe using the signingURLs API.  However, the UI that Sign presents in the iframe includes an Options menu in the top left with a "Read Agreement" option which, when clicked, reloads the document in the iframe in a read-only mode with no apparent way to get back to where the user can actually sign.

My main question is whether there's a way to prevent the Read Agreement option when the agreement is created (I pored over the API docs trying to find a way, but didn't spot one).

If not, is there a way to suppress the menu item at the account/group level?  I was able to find some info online about how to suppress the Delegate and Decline option menu items, but not this one.


问:
My postgres tables are not showing after I defined my models with Sequelize
```<code>//db.config.js

module.exports = {
  HOST: 'localhost',

  USER: 'postgres',

  PASSWORD: '123',

  DB: 'capital-greek',

  dialect: 'postgres',

  pool: {
    max: 5,

    min: 0,

    acquire: 30000,

    idle: 10000,
  },
};
</code>```
```<code>//server.js
const express = require('express');

const bodyParser = require('body-parser');

const cors = require('cors');

const app = express();

let corsOptions = {
  origin: 'http://localhost:8081',
};

app.use(cors(corsOptions));

// parse requests of content-type - application/json

app.use(bodyParser.json());

// parse requests of content-type - application/x-www-form-urlencoded

app.use(bodyParser.urlencoded({ extended: true }));

// database

const db = require('./app/models');

const Role = db.role;

// db.sequelize.sync()

// force: true will drop the table if it already exists

db.sequelize.sync({ force: true }).then(() => {
  console.log('Drop and Resync Database with { force: true }');

  initial();
});

// simple route

app.get('/', (req, res) => {
  res.json({ message: 'Welcome to bezkoder application.' });
});

// routes

require('./app/routes/auth.routes.js')(app);
require('./app/routes/users.routes.js')(app);

// set port, listen for requests

const PORT = process.env.PORT || 8080;
app.listen(PORT, () => {
  console.log(`Server is running on port ${PORT}.`);
});

function initial() {
  Role.create({
    id: 1,

    name: 'user',
  });

  Role.create({
    id: 2,

    name: 'moderator',
  });
</code>```
```<code>//models/index.js

const config = require('../config/db.config.js');

const Sequelize = require('sequelize');

const sequelize = new Sequelize(config.DB, config.USER, config.PASSWORD, {
  host: config.HOST,

  dialect: config.dialect,

  operatorsAliases: 0,

  pool: {
    max: config.pool.max,

    min: config.pool.min,

    acquire: config.pool.acquire,

    idle: config.pool.idle,
  },
});

const db = {};

db.Sequelize = Sequelize;

db.sequelize = sequelize;

db.user = require('../models/user.model.js')(sequelize, Sequelize);

db.role = require('../models/role.model.js')(sequelize, Sequelize);

db.role.belongsToMany(db.user, {
  through: 'user_roles',

  foreignKey: 'roleId',

  otherKey: 'userId',
});

db.user.belongsToMany(db.role, {
  through: 'user_roles',

  foreignKey: 'userId',

  otherKey: 'roleId',
});

db.ROLES = ['user', 'admin', 'moderator'];

module.exports = db;
</code>```

After going through the trouble of getting my postgres server running, I now have a different issue with not being able to see my tables generated in to my database. I defined my models with Sequelize, only thing I haven't done yet was create a seed file for my database so that way I can see what I have. I'm connected to the database that I created on the command line. When I type the command "\dt" inside postgres, I get back "Did not find any relations." Any help would be greatly appreciated , I've been stuck in this process for a long time.

Body:
//db.config.js

module.exports = {
  HOST: 'localhost',

  USER: 'postgres',

  PASSWORD: '123',

  DB: 'capital-greek',

  dialect: 'postgres',

  pool: {
    max: 5,

    min: 0,

    acquire: 30000,

    idle: 10000,
  },
};

//server.js
const express = require('express');

const bodyParser = require('body-parser');

const cors = require('cors');

const app = express();

let corsOptions = {
  origin: 'http://localhost:8081',
};

app.use(cors(corsOptions));

// parse requests of content-type - application/json

app.use(bodyParser.json());

// parse requests of content-type - application/x-www-form-urlencoded

app.use(bodyParser.urlencoded({ extended: true }));

// database

const db = require('./app/models');

const Role = db.role;

// db.sequelize.sync()

// force: true will drop the table if it already exists

db.sequelize.sync({ force: true }).then(() => {
  console.log('Drop and Resync Database with { force: true }');

  initial();
});

// simple route

app.get('/', (req, res) => {
  res.json({ message: 'Welcome to bezkoder application.' });
});

// routes

require('./app/routes/auth.routes.js')(app);
require('./app/routes/users.routes.js')(app);

// set port, listen for requests

const PORT = process.env.PORT || 8080;
app.listen(PORT, () => {
  console.log(`Server is running on port ${PORT}.`);
});

function initial() {
  Role.create({
    id: 1,

    name: 'user',
  });

  Role.create({
    id: 2,

    name: 'moderator',
  });

//models/index.js

const config = require('../config/db.config.js');

const Sequelize = require('sequelize');

const sequelize = new Sequelize(config.DB, config.USER, config.PASSWORD, {
  host: config.HOST,

  dialect: config.dialect,

  operatorsAliases: 0,

  pool: {
    max: config.pool.max,

    min: config.pool.min,

    acquire: config.pool.acquire,

    idle: config.pool.idle,
  },
});

const db = {};

db.Sequelize = Sequelize;

db.sequelize = sequelize;

db.user = require('../models/user.model.js')(sequelize, Sequelize);

db.role = require('../models/role.model.js')(sequelize, Sequelize);

db.role.belongsToMany(db.user, {
  through: 'user_roles',

  foreignKey: 'roleId',

  otherKey: 'userId',
});

db.user.belongsToMany(db.role, {
  through: 'user_roles',

  foreignKey: 'userId',

  otherKey: 'roleId',
});

db.ROLES = ['user', 'admin', 'moderator'];

module.exports = db;

After going through the trouble of getting my postgres server running, I now have a different issue with not being able to see my tables generated in to my database. I defined my models with Sequelize, only thing I haven't done yet was create a seed file for my database so that way I can see what I have. I'm connected to the database that I created on the command line. When I type the command "\dt" inside postgres, I get back "Did not find any relations." Any help would be greatly appreciated , I've been stuck in this process for a long time.


问:
Autopilot Nodes needs to communicate with the GKE managed control plane
In my organization someone removed a forwarding rule that allowed the Autopilot Nodes to communicate with the GKE managed control plane

we are using Google cloud & terraform to manage Infra & policies.
I assume we have only one resource "Cloud Composer" which has these firewall rules.

I want to disable the deletion of these forwarding rules so that there will be no issue for Autopilot Nodes to communicate with the GKE managed control plane in the future.

Can someone let me know the below,

What is the Organization policy related to this issue?

What is the default value to set for this Organization policy?


问:
Vertex AI batch prediction results in ('ValueError', 1)
I have a predictor that works successfully when run on a local container, but when that container is pushed to the Artifact Registry, and imported to a Vertex AI model, and run in Batch Prediction mode, it returns an empty prediction file and an error file that simply says ('ValueError', 1)

The request is made using Flask.
code (main.py) is

```<code>if 'AIP_HEALTH_ROUTE' in os.environ:
    AIP_HEALTH_ROUTE = os.environ['AIP_HEALTH_ROUTE']
else:
    AIP_HEALTH_ROUTE = '/health'

if 'AIP_PREDICT_ROUTE' in os.environ:
    AIP_PREDICT_ROUTE = os.environ['AIP_PREDICT_ROUTE']
else:
    AIP_PREDICT_ROUTE = '/predict'

@app.route(AIP_HEALTH_ROUTE, methods=['GET'])
def health():
    response = {"message": "OK", "code": "SUCCESS"}
    return make_response(jsonify(response), 200)

@app.route(AIP_PREDICT_ROUTE, methods=['POST'])
def predict():
    try:
        instances = pd.DataFrame(request.json.get("instances"))
        # creates a model using model and encoders stored at given GCS location
        model = model_active.CustomPredictor('datascience-modelartifacts/my-model/actives')

        processed_data = model.process_score_data(instances)
        predictions = model.predict(processed_data)

        response = {"predictions": predictions}
        status = 200

    except Exception as e:
        response = {"error": str(e)}
        status = 500

    return make_response(jsonify(response), status)
</code>```

For local testing, the data looks like:

```<code>dat = {"instances": [
    {"F1": 1000854828492, "F2": 3000076437878, "F3": 19.99, ...},
    {"F1": 1000222326963, "F2": 3000127917915, "F3": 19.99, ...},
    ... ]}
</code>```

I call this with

```<code>import requests
url = 'http://localhost:5000/predict'
headers = {'content-type': 'application/json', 'Accept-Charset': 'UTF-8'}
r = requests.post(url, json=dat, headers=headers)
</code>```

and in this case everything works as expected (I get a list of predicted classes returned).

I can successfully deploy this model as an endpoint and provide this data as test and get predictions returned.

However, for Vertex batch prediction (which is what I ultimately want to enable since we only need this model once a month), I have tried providing this data as both JSONL and CSV and I keep receiving output with no successful predictions and an error file that simply says ('ValueError', 1)

Does anyone have any suggestions what this error means and what is causing it?

Body:
I have a predictor that works successfully when run on a local container, but when that container is pushed to the Artifact Registry, and imported to a Vertex AI model, and run in Batch Prediction mode, it returns an empty prediction file and an error file that simply says ('ValueError', 1)

The request is made using Flask.
code (main.py) is

if 'AIP_HEALTH_ROUTE' in os.environ:
    AIP_HEALTH_ROUTE = os.environ['AIP_HEALTH_ROUTE']
else:
    AIP_HEALTH_ROUTE = '/health'

if 'AIP_PREDICT_ROUTE' in os.environ:
    AIP_PREDICT_ROUTE = os.environ['AIP_PREDICT_ROUTE']
else:
    AIP_PREDICT_ROUTE = '/predict'

@app.route(AIP_HEALTH_ROUTE, methods=['GET'])
def health():
    response = {"message": "OK", "code": "SUCCESS"}
    return make_response(jsonify(response), 200)

@app.route(AIP_PREDICT_ROUTE, methods=['POST'])
def predict():
    try:
        instances = pd.DataFrame(request.json.get("instances"))
        # creates a model using model and encoders stored at given GCS location
        model = model_active.CustomPredictor('datascience-modelartifacts/my-model/actives')

        processed_data = model.process_score_data(instances)
        predictions = model.predict(processed_data)

        response = {"predictions": predictions}
        status = 200

    except Exception as e:
        response = {"error": str(e)}
        status = 500

    return make_response(jsonify(response), status)

For local testing, the data looks like:

dat = {"instances": [
    {"F1": 1000854828492, "F2": 3000076437878, "F3": 19.99, ...},
    {"F1": 1000222326963, "F2": 3000127917915, "F3": 19.99, ...},
    ... ]}

I call this with

import requests
url = 'http://localhost:5000/predict'
headers = {'content-type': 'application/json', 'Accept-Charset': 'UTF-8'}
r = requests.post(url, json=dat, headers=headers)

and in this case everything works as expected (I get a list of predicted classes returned).

I can successfully deploy this model as an endpoint and provide this data as test and get predictions returned.

However, for Vertex batch prediction (which is what I ultimately want to enable since we only need this model once a month), I have tried providing this data as both JSONL and CSV and I keep receiving output with no successful predictions and an error file that simply says ('ValueError', 1)

Does anyone have any suggestions what this error means and what is causing it?


问:
How to get the data of a "multiselect option" coming from a cell
I created a cell to assemble a "multiple selection option" and inserted it into a view for the user.

Fill in the fields like this:

```<code><select class="form-control" multiple id="product">
    <?php foreach ($json["data"] as $product):?>
    <option value="<?php echo $product["id"]; ?>"><?php echo $product["name"]; ?></option>
    <?php endforeach; ?>
</select>

</code>```

I added this cell to a user registration form along with other fields!

```<code><?= $this->cell('Products');?>
</code>```

How can I get the information selected by the user and send it to the controller after submitting the form?
Can I solve this using the cell?

Body:
I created a cell to assemble a "multiple selection option" and inserted it into a view for the user.

Fill in the fields like this:

<select class="form-control" multiple id="product">
    <?php foreach ($json["data"] as $product):?>
    <option value="<?php echo $product["id"]; ?>"><?php echo $product["name"]; ?></option>
    <?php endforeach; ?>
</select>

I added this cell to a user registration form along with other fields!

<?= $this->cell('Products');?>

How can I get the information selected by the user and send it to the controller after submitting the form?
Can I solve this using the cell?


问:
I am using the C5.0 algorithm to construct a decision tree and it uses only one of the variables that I feed it. How do I force it to be more complex?
The variable in question is the most informative one (sorry if the language is bad, Im a newbie), and the tree is 90% accurate (base rate would be around 86%), however I want the algorithm to use more than one attiribute. I constructed a CART tree based on the same data and it used a few more of the available variables and achieved an accuracy of about 92% (all tested on holdout). Is there any way to force the tree to make more splits? Here is the code that I am using:

predictors <- subset(student_train, select = -c(10)) dependant <- as.factor(student_train$g3) c50fit <- C5.0(x = predictors, y = dependant, trials = 10, control = C5.0Control(noGlobalPruning = TRUE))

As you can see I tried some of the stuff I found online but it did not work.

Here's a picture of the output:

the plot of the tree

You can see in the code that I tried out some of the control options but none seemed to work.

Here's the head of the data from the dput() code, I hope I provided it correctly:

```<code>structure(list(school = structure(c(2L, 2L, 1L, 1L, 1L, 1L, 2L,
1L, 1L, 1L), levels = c("GP", "MS"), class = "factor"), address =
structure(c(2L,
1L, 2L, 2L, 2L, 2L, 1L, 2L, 2L, 2L), levels = c("R", "U"), class
= "factor"),
mjob = structure(c(1L, 3L, 3L, 3L, 3L, 1L, 4L, 1L, 3L, 3L
), levels = c("at_home", "health", "other", "services", "teacher"
), class = "factor"), fjob = structure(c(4L, 3L, 3L, 3L,
3L, 3L, 3L, 4L, 3L, 3L), levels = c("at_home", "health",
"other", "services", "teacher"), class = "factor"), reason =
structure(c(1L,
1L, 1L, 1L, 2L, 2L, 1L, 1L, 2L, 1L), levels = c("course",
"home", "other", "reputation"), class = "factor"), internet =
structure(c(2L,
1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), levels = c("no", "yes"
), class = "factor"), dalc = c(2L, 3L, 1L, 2L, 2L, 1L, 1L,
1L, 1L, 2L), walc = c(3L, 3L, 1L, 2L, 3L, 1L, 2L, 4L, 2L,
4L), g2 = c(10L, 11L, 12L, 14L, 12L, 10L, 11L, 8L, 12L, 11L
), g3 = c("Fail", "Pass", "Pass", "Pass", "Pass", "Pass",
"Pass", "Fail", "Pass", "Pass")), row.names = c(580L, 545L,
98L, 378L, 85L, 113L, 645L, 178L, 27L, 384L), class =
"data.frame")
</code>```

Body:
The variable in question is the most informative one (sorry if the language is bad, Im a newbie), and the tree is 90% accurate (base rate would be around 86%), however I want the algorithm to use more than one attiribute. I constructed a CART tree based on the same data and it used a few more of the available variables and achieved an accuracy of about 92% (all tested on holdout). Is there any way to force the tree to make more splits? Here is the code that I am using:

predictors <- subset(student_train, select = -c(10)) dependant <- as.factor(student_train$g3) c50fit <- C5.0(x = predictors, y = dependant, trials = 10, control = C5.0Control(noGlobalPruning = TRUE))

As you can see I tried some of the stuff I found online but it did not work.

Here's a picture of the output:

the plot of the tree

You can see in the code that I tried out some of the control options but none seemed to work.

Here's the head of the data from the dput() code, I hope I provided it correctly:

structure(list(school = structure(c(2L, 2L, 1L, 1L, 1L, 1L, 2L,
1L, 1L, 1L), levels = c("GP", "MS"), class = "factor"), address =
structure(c(2L,
1L, 2L, 2L, 2L, 2L, 1L, 2L, 2L, 2L), levels = c("R", "U"), class
= "factor"),
mjob = structure(c(1L, 3L, 3L, 3L, 3L, 1L, 4L, 1L, 3L, 3L
), levels = c("at_home", "health", "other", "services", "teacher"
), class = "factor"), fjob = structure(c(4L, 3L, 3L, 3L,
3L, 3L, 3L, 4L, 3L, 3L), levels = c("at_home", "health",
"other", "services", "teacher"), class = "factor"), reason =
structure(c(1L,
1L, 1L, 1L, 2L, 2L, 1L, 1L, 2L, 1L), levels = c("course",
"home", "other", "reputation"), class = "factor"), internet =
structure(c(2L,
1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), levels = c("no", "yes"
), class = "factor"), dalc = c(2L, 3L, 1L, 2L, 2L, 1L, 1L,
1L, 1L, 2L), walc = c(3L, 3L, 1L, 2L, 3L, 1L, 2L, 4L, 2L,
4L), g2 = c(10L, 11L, 12L, 14L, 12L, 10L, 11L, 8L, 12L, 11L
), g3 = c("Fail", "Pass", "Pass", "Pass", "Pass", "Pass",
"Pass", "Fail", "Pass", "Pass")), row.names = c(580L, 545L,
98L, 378L, 85L, 113L, 645L, 178L, 27L, 384L), class =
"data.frame")


问:
How to change gorm.Record type to array
currently I am using gorm to retrieve data from db (postgresql db to be specific) and scan it in an array, the data stored in db is also in form of array. So problem I am facing is after scanning data in empty int array it changes into gorm.Record type which can't be used for basic array operation like, appending, iterating, etc.

Here's a related part of my code:

```<code>    var winner_selection []int64 // empty int64 array
    db.Table("giveaways").Select("Participants").Where("Name = ?", name).Scan(&winner_selection) // scanning the value in array

</code>```

How can I retrieve the data directly in form of array so the array remains array or is there anyway to change gorm.Record type to array?

Title: How to change gorm.Record type to array

Body:
currently I am using gorm to retrieve data from db (postgresql db to be specific) and scan it in an array, the data stored in db is also in form of array. So problem I am facing is after scanning data in empty int array it changes into gorm.Record type which can't be used for basic array operation like, appending, iterating, etc.

Here's a related part of my code:

    var winner_selection []int64 // empty int64 array
    db.Table("giveaways").Select("Participants").Where("Name = ?", name).Scan(&winner_selection) // scanning the value in array

How can I retrieve the data directly in form of array so the array remains array or is there anyway to change gorm.Record type to array?


问:
!D/EGL_emulation
After using the !D/EGL_emulation filter to hide the app time stats in flutter I get this annoying label next to the filter text field that tells me how many lines have been hidden in the console log |Showing 122/444| , is there any way to remove this ?!

It's ticking every second and I want to remove it.

Title: !D/EGL_emulation


问:
code errors with getxcontroller and const app
the red underline means the code is having an issue correct?

the code is done is VS code with flutter

in this code the const App() is having an red underline

moreover

the part here I wish to make the GetxController green but it would not work

along with the line of code underneath it

both the getxcontroller and the line underneath it is having red underline as well

i was thinking of adding it to the library and according to the video i was watching he managed to do so by ctrl + . but when i do ctrl + . it only shows "create class"


问:
PyImgur not Accessing Imgur through Rapid API
I am using the Pyimgur library to upload images to imgur. I can get it to work for non-commercial usage, but when I try to configure it for commercial usage, I get an error.

When I change the code from:
im = pyimgur.Imgur(os.getenv("IMGUR_CONSUMER_ID"))
to this:
im = pyimgur.Imgur(os.getenv("IMGUR_CONSUMER_ID"),mashape_key=os.getenv("MASHAPE_KEY"))
I get this error:

```<code>HTTPSConnectionPool(host='imgur-apiv3.p.mashape.com', port=443): Max retries exceeded with url: /3/image (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f7cb9afb430>: Failed to establish a new connection: [Errno -2] Name or service not known'))
</code>```

The issue is that imgur now uses RapidAPI instead of Mashape. The host should be imgur-apiv3.p.rapidapi.com instead of imgur-apiv3.p.mashape.com

I feel like if you just changed MASHAPE_BASE on line 51 of init.py (here: https://github.com/Damgaard/PyImgur/blob/master/pyimgur/__init__.py) to the correct url, it would work, but I don't know how to do that.

I installed the python library using pip.

I've tried posting the issue on github, but I don't think they maintain the repo anymore.

Body:
I am using the Pyimgur library to upload images to imgur. I can get it to work for non-commercial usage, but when I try to configure it for commercial usage, I get an error.

When I change the code from:
im = pyimgur.Imgur(os.getenv("IMGUR_CONSUMER_ID"))
to this:
im = pyimgur.Imgur(os.getenv("IMGUR_CONSUMER_ID"),mashape_key=os.getenv("MASHAPE_KEY"))
I get this error:

HTTPSConnectionPool(host='imgur-apiv3.p.mashape.com', port=443): Max retries exceeded with url: /3/image (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f7cb9afb430>: Failed to establish a new connection: [Errno -2] Name or service not known'))

The issue is that imgur now uses RapidAPI instead of Mashape. The host should be imgur-apiv3.p.rapidapi.com instead of imgur-apiv3.p.mashape.com

I feel like if you just changed MASHAPE_BASE on line 51 of init.py (here: https://github.com/Damgaard/PyImgur/blob/master/pyimgur/__init__.py) to the correct url, it would work, but I don't know how to do that.

I installed the python library using pip.

I've tried posting the issue on github, but I don't think they maintain the repo anymore.


问:
How to scroll to a particular section of the data fetched from an API while filtering the data on some parameter?
I am calling an API from a server, and I am getting this as a response. A part of the data I am getting -

```<code>{
    "id": 322854,
    "date": "2022-09-20T18:00:00+00:00",
    "time": "18:00",
    "timestamp": 1663696800,
    "timezone": "UTC",
    "stage": null,
    "week": null,
    "status": {
        "long": "Game Finished",
        "short": "FT",
        "timer": null
    },
    "league": {
        "id": 9,
        "name": "French Cup",
        "type": "cup",
        "season": 2022,
        "logo": "https://media-2.api-sports.io/basketball/leagues/9.png"
    },
    "country": {
        "id": 4,
        "name": "France",
        "code": "FR",
        "flag": "https://media-2.api-sports.io/flags/fr.svg"
    },
    "teams": {
        "home": {
            "id": 22,
            "name": "Boulazac",
            "logo": "https://media-2.api-sports.io/basketball/teams/22.png"
        },
        "away": {
            "id": 2294,
            "name": "CEP Lorient",
            "logo": "https://media-2.api-sports.io/basketball/teams/2294.png"
        }
    },
    "scores": {
        "home": {
            "quarter_1": 16,
            "quarter_2": 12,
            "quarter_3": 21,
            "quarter_4": 26,
            "over_time": null,
            "total": 75
        },
        "away": {
            "quarter_1": 9,
            "quarter_2": 16,
            "quarter_3": 19,
            "quarter_4": 23,
            "over_time": null,
            "total": 67
        }
    }
}
{
    "id": 322854,
    "date": "2022-09-20T18:00:00+00:00",
    "time": "18:00",
    "timestamp": 1663696800,
    "timezone": "UTC",
    "stage": null,
    "week": null,
    "status": {
        "long": "Game Not Started",
        "short": "NS",
        "timer": null
    },
    "league": {
        "id": 9,
        "name": "French Cup",
        "type": "cup",
        "season": 2022,
        "logo": "https://media-2.api-sports.io/basketball/leagues/9.png"
    },
    "country": {
        "id": 4,
        "name": "France",
        "code": "FR",
        "flag": "https://media-2.api-sports.io/flags/fr.svg"
    },
    "teams": {
        "home": {
            "id": 22,
            "name": "Boulazac",
            "logo": "https://media-2.api-sports.io/basketball/teams/22.png"
        },
        "away": {
            "id": 2294,
            "name": "CEP Lorient",
            "logo": "https://media-2.api-sports.io/basketball/teams/2294.png"
        }
    },
    "scores": {
        "home": {
            "quarter_1": 16,
            "quarter_2": 12,
            "quarter_3": 21,
            "quarter_4": 26,
            "over_time": null,
            "total": 75
        },
        "away": {
            "quarter_1": 9,
            "quarter_2": 16,
            "quarter_3": 19,
            "quarter_4": 23,
            "over_time": null,
            "total": 67
        }
    }
}
</code>```

There are a bunch of such objects in an array each having a different fixture. As you can see that status?.short === "NS" in one while the other is status?.short === "FT". Now, I want to filter the data using these properties.

```<code>    <div className="fixturesTab-container">
      <div className="fixturesTab-container__header">
        <h4>Fixtures</h4>
      </div>
      <div className="fixturesTab-container__body">
        {fixtures.map((fixture) => (
            <div
              key={fixture?.id}
              className="fixturesTab-container__body__box"
            >
              ......
            </div>
          ))}
      </div>
    </div>
</code>```

I want the data to be displayed in such a manner that when the user browse to that page and the API is being fetched, eventhough the entire data (fixtures) is being displayed in the page. I want the fixtures that have not yet started, i.e has the property of status?.short === "NS", to be displayed in the window that is visible to the user. And the rest data can be acquired by either scrolling up, which will have the fixtures that have been completed, or by scrolling down which will have the fixtures that have not yet been started.

If, I am unable to understand what I want properly, then you can check out this page . This is exactly what I am planning to achieve.

Body:
I am calling an API from a server, and I am getting this as a response. A part of the data I am getting -

{
    "id": 322854,
    "date": "2022-09-20T18:00:00+00:00",
    "time": "18:00",
    "timestamp": 1663696800,
    "timezone": "UTC",
    "stage": null,
    "week": null,
    "status": {
        "long": "Game Finished",
        "short": "FT",
        "timer": null
    },
    "league": {
        "id": 9,
        "name": "French Cup",
        "type": "cup",
        "season": 2022,
        "logo": "https://media-2.api-sports.io/basketball/leagues/9.png"
    },
    "country": {
        "id": 4,
        "name": "France",
        "code": "FR",
        "flag": "https://media-2.api-sports.io/flags/fr.svg"
    },
    "teams": {
        "home": {
            "id": 22,
            "name": "Boulazac",
            "logo": "https://media-2.api-sports.io/basketball/teams/22.png"
        },
        "away": {
            "id": 2294,
            "name": "CEP Lorient",
            "logo": "https://media-2.api-sports.io/basketball/teams/2294.png"
        }
    },
    "scores": {
        "home": {
            "quarter_1": 16,
            "quarter_2": 12,
            "quarter_3": 21,
            "quarter_4": 26,
            "over_time": null,
            "total": 75
        },
        "away": {
            "quarter_1": 9,
            "quarter_2": 16,
            "quarter_3": 19,
            "quarter_4": 23,
            "over_time": null,
            "total": 67
        }
    }
}
{
    "id": 322854,
    "date": "2022-09-20T18:00:00+00:00",
    "time": "18:00",
    "timestamp": 1663696800,
    "timezone": "UTC",
    "stage": null,
    "week": null,
    "status": {
        "long": "Game Not Started",
        "short": "NS",
        "timer": null
    },
    "league": {
        "id": 9,
        "name": "French Cup",
        "type": "cup",
        "season": 2022,
        "logo": "https://media-2.api-sports.io/basketball/leagues/9.png"
    },
    "country": {
        "id": 4,
        "name": "France",
        "code": "FR",
        "flag": "https://media-2.api-sports.io/flags/fr.svg"
    },
    "teams": {
        "home": {
            "id": 22,
            "name": "Boulazac",
            "logo": "https://media-2.api-sports.io/basketball/teams/22.png"
        },
        "away": {
            "id": 2294,
            "name": "CEP Lorient",
            "logo": "https://media-2.api-sports.io/basketball/teams/2294.png"
        }
    },
    "scores": {
        "home": {
            "quarter_1": 16,
            "quarter_2": 12,
            "quarter_3": 21,
            "quarter_4": 26,
            "over_time": null,
            "total": 75
        },
        "away": {
            "quarter_1": 9,
            "quarter_2": 16,
            "quarter_3": 19,
            "quarter_4": 23,
            "over_time": null,
            "total": 67
        }
    }
}

There are a bunch of such objects in an array each having a different fixture. As you can see that status?.short === "NS" in one while the other is status?.short === "FT". Now, I want to filter the data using these properties.

Fixtures

        {fixtures.map((fixture) => (

              ......

          ))}

I want the data to be displayed in such a manner that when the user browse to that page and the API is being fetched, eventhough the entire data (fixtures) is being displayed in the page. I want the fixtures that have not yet started, i.e has the property of status?.short === "NS", to be displayed in the window that is visible to the user. And the rest data can be acquired by either scrolling up, which will have the fixtures that have been completed, or by scrolling down which will have the fixtures that have not yet been started.

If, I am unable to understand what I want properly, then you can check out this page . This is exactly what I am planning to achieve.


问:
How can I intercept XHR requests to a specific URI and return my own response using a web extension?
I'm trying to implement a feature in an extension I'm building that consists of "manually" caching requests. It's for a website that has a search box that takes around 15 seconds (when it doesn't timeout) every time I search for something and never caches anything. What I pretend to do is store the response JSON in localStorage and return it when the request is made (updating it daily on the background). I got to the conclusion that it can't be made using the webRequests API and the best way to achieve it is by modifying the XMLHttpRequest prototype, but how can I do it?

I've tried to modify the send method on the XHR prototype and adding a readystatechange event listener to return the "cached" response when readyState == 2, but I have no idea how to actually return my own response. Thanks in advance!