问:
How do you convert bytes into a zipped file in python? (originally a zip file) for GCP secret manager secrets?
really need someones help here.

I am currently trying to store a zip file in GCP secrets manager and then retrieve the zip file in python.

from google.cloud import secretmanager
import base64
client = secretmanager.SecretManagerServiceClient()
PROJECT_ID = "project"
secret_id = "secret"
version_id = 1
name = f"projects/{PROJECT_ID}/secrets/{secret_id}/versions/{version_id}"

response = client.access_secret_version(name=name)
bytes_returned = base64.b64decode(response.payload.data)

with open("my_zip.zip", "wb") as binary_file:
    # Write bytes to file
    binary_file.write(bytes_returned)

```
<p>once I try and open the zip however it complains that the file is in the incorrect format.</p>
<p>When I download using gcloud commands everything seems to work</p>
<pre class="lang-bash prettyprint-override"><code>gcloud secrets versions access latest --secret "bi_cass_secure_bundle" --format "json" | \
  jq -r .payload.data | \
  base64 --decode > results_binary.zip
</code>```

I have also tried the method explained here but with no luck
Create zip file object from bytestring in Python?

Thanks in advance and I am sending you all some good karma

extra notes

Soo even if I have a valid zip file and write the bytes to another zip file I get the same error so it is something to do with the python library

with open("valid.zip", 'rb') as file_data:
    bytes_content = file_data.read()

    with open("test_valid.zip", "wb") as binary_file:
        # Write bytes to file
        binary_file.write(bytes_content)
```

Body:
really need someones help here.

I am currently trying to store a zip file in GCP secrets manager and then retrieve the zip file in python.

from google.cloud import secretmanager
import base64
client = secretmanager.SecretManagerServiceClient()
PROJECT_ID = "project"
secret_id = "secret"
version_id = 1
name = f"projects/{PROJECT_ID}/secrets/{secret_id}/versions/{version_id}"

response = client.access_secret_version(name=name)
bytes_returned = base64.b64decode(response.payload.data)

with open("my_zip.zip", "wb") as binary_file:
    # Write bytes to file
    binary_file.write(bytes_returned)

once I try and open the zip however it complains that the file is in the incorrect format.

When I download using gcloud commands everything seems to work

gcloud secrets versions access latest --secret "bi_cass_secure_bundle" --format "json" | \
  jq -r .payload.data | \
  base64 --decode > results_binary.zip

I have also tried the method explained here but with no luck
Create zip file object from bytestring in Python?

Thanks in advance and I am sending you all some good karma

extra notes

Soo even if I have a valid zip file and write the bytes to another zip file I get the same error so it is something to do with the python library

with open("valid.zip", 'rb') as file_data:
    bytes_content = file_data.read()

    with open("test_valid.zip", "wb") as binary_file:
        # Write bytes to file
        binary_file.write(bytes_content)


来源: stackexchange

问:
Delete a remote object from outside the distributed system
I have been playing around with Pyro, particularly Pyro5 and wanted to simulate some fault tolerance algorithms by creating a distributed system consisting of remote processes and RPC's using Pyro5 in Python.

Does anybody know how to delete / crash any particular pyro remote object which communicates with other pyro remote objects through RPCs? I have been looking up at the Pyro5 documentation and it just mentions pyro5-nsc remove [object_name], which just removes the object from the nameserver, but does not crash it.

Does anybody know how to solve this?

ContentLicense: CC BY-SA 4.0


问:
Raising to the power of zero
As we know, raising any non-zero number to the power of zero gives 1, since n^0 = n^(a-a) = n^a / n^a = 1.

I just noticed that JavaScript implementations (Chrome, Firefox, Edge, Safari) will shortcut such operation, ignoring the first operand and returning 1. However, these implementations don't simply ignore the first numeric operand, they completely ignore anything!

console.log("hello" ** 0);
console.log(false ** 0);
console.log({} ** 0);
console.log(NaN ** 0);
console.log(null ** 0);
console.log(Infinity ** 0);```

My question is: is that behavior an implementation (meaning it can change at any moment), or is it described by ECMA somewhere? I searched ECMA but I couldn't find anything

Title: Raising to the power of zero

Body:
As we know, raising any non-zero number to the power of zero gives 1, since n^0 = n^(a-a) = n^a / n^a = 1.

I just noticed that JavaScript implementations (Chrome, Firefox, Edge, Safari) will shortcut such operation, ignoring the first operand and returning 1. However, these implementations don't simply ignore the first numeric operand, they completely ignore anything!

console.log("hello" ** 0);
console.log(false ** 0);
console.log({} ** 0);
console.log(NaN ** 0);
console.log(null ** 0);
console.log(Infinity ** 0);

My question is: is that behavior an implementation (meaning it can change at any moment), or is it described by ECMA somewhere? I searched ECMA but I couldn't find anything


问:
pywinauto cannot find dialog with start, only can connect to existing one
pywinauto cannot find the dialog window after start.

```<code>from pywinauto import Application

app = Application(backend="uia")
app.start(PROGRAM_PATH)

dlg = app["dialog title"]

dlg.print_control_identifiers()
"""
^^^^^
  Exception has occurred: ElementNotFoundError
  {'best_match': 'dialog title', 'backend': 'uia', 'process': XXXXX}

  During handling of the above exception, another exception occurred:
    trace back. . .
"""
</code>```

however, it can connect to existing dialog

```<code>from pywinauto import Application

app = Application(backend="uia")
app.connect(path=PROGRAM_PATH)

dlg = app["dialog title"]

dlg.print_control_identifiers()
"""
^^^^^
  this works
"""
</code>```

I tried to add some delay to make sure the program is properly opened, but it didn't seem to help

tried to print all window

```<code>[print(w) for w in app.windows]
</code>```

nothing comes up for the app.start(PROGRAM_PATH) one.

Body:
pywinauto cannot find the dialog window after start.

from pywinauto import Application

app = Application(backend="uia")
app.start(PROGRAM_PATH)

dlg = app["dialog title"]

dlg.print_control_identifiers()
"""
^^^^^
  Exception has occurred: ElementNotFoundError
  {'best_match': 'dialog title', 'backend': 'uia', 'process': XXXXX}

  During handling of the above exception, another exception occurred:
    trace back. . .
"""

however, it can connect to existing dialog

from pywinauto import Application

app = Application(backend="uia")
app.connect(path=PROGRAM_PATH)

dlg = app["dialog title"]

dlg.print_control_identifiers()
"""
^^^^^
  this works
"""

I tried to add some delay to make sure the program is properly opened, but it didn't seem to help

tried to print all window

[print(w) for w in app.windows]

nothing comes up for the app.start(PROGRAM_PATH) one.


问:
com.itextpdf.io.exceptions.IOException: Table name does not exist in otf font
Itext7, I was able to load font and generate pdf in IntelliJ/Jetty server, But when moved to tomcat same code started failing with below error

com.itextpdf.io.exceptions.IOException: Table name does not exist in ./fonts/CompactText-Regular.otf
at com.itextpdf.io.font.OpenTypeParser.readNameTable(OpenTypeParser.java:638)
at com.itextpdf.io.font.OpenTypeParser.loadTables(OpenTypeParser.java:442)
at com.itextpdf.io.font.TrueTypeFont.(TrueTypeFont.java:93)
at com.itextpdf.io.font.TrueTypeFont.(TrueTypeFont.java:102)
at com.itextpdf.io.font.FontProgramFactory.createFont(FontProgramFactory.java:210)
at com.itextpdf.io.font.FontProgramFactory.createFont(FontProgramFactory.java:118)
at com.itextpdf.kernel.font.PdfFontFactory.createFont(PdfFontFactory.java:249)
at com.itextpdf.kernel.font.PdfFontFactory.createFont(PdfFontFactory.java:232)
at com.itextpdf.kernel.font.PdfFontFactory.createFont(PdfFontFactory.java:216)

*** Code for ref **

PdfFont segFont = PdfFontFactory.createFont("./fonts/CompactText-Regular.otf", PdfFontFactory.EmbeddingStrategy.FORCE_EMBEDDED);


问:
How does the await pre-fix work? How am I using it wrong for fetch?
```<code>let message;
let names;
</code>```

I have two variables. The goal is to initialize them before the rest of the code runs.

```<code>async function getArraysFromPHP(phpFile) {
    return fetch('forumData.php')
    .then(response => response.json())
    .then(data => {
      return [data.data, data.data1];
    });
}
</code>```

I get the data for the two variables (they are two arrays) from this function. This function works.

```<code>async function resetForumData() {
    const arrays = await getArraysFromPHP('forumData.php');
    message = arrays[0];
    names = arrays[1];
    console.log(message[0]);
}
</code>```

I have this function which calls the other one and uses its data to initialize the variables.

```<code>resetForumData();
</code>```

I then call that function to initialize the variables using the data I got from the fetch request.

The problem is that they don't seem to be awaiting. It doesn't call these functions until after the code has been run, which leaves the two variables un-initialized. I am very new to async/await, so I'm not really sure what I'm doing. Thanks for help.

Body:
let message;
let names;

I have two variables. The goal is to initialize them before the rest of the code runs.

async function getArraysFromPHP(phpFile) {
    return fetch('forumData.php')
    .then(response => response.json())
    .then(data => {
      return [data.data, data.data1];
    });
}

I get the data for the two variables (they are two arrays) from this function. This function works.

async function resetForumData() {
    const arrays = await getArraysFromPHP('forumData.php');
    message = arrays[0];
    names = arrays[1];
    console.log(message[0]);
}

I have this function which calls the other one and uses its data to initialize the variables.

resetForumData();

I then call that function to initialize the variables using the data I got from the fetch request.

The problem is that they don't seem to be awaiting. It doesn't call these functions until after the code has been run, which leaves the two variables un-initialized. I am very new to async/await, so I'm not really sure what I'm doing. Thanks for help.


问:
How to treat rdf xml resources with java dom
Here is my xml document :

```<code><rdf:RDF
xmlns:test="http://www.test/2022#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
xml:base="http://www.desktop-eqkvgq5.net/2022#">
<test:Dog rdf:ID="_100">
<test:Animal.Name>Jeck</test:Animal.Name>
<test:Dog.breed>Akita</test:Dog.breed>
<test:Animal.age rdf:resource="#_1000"/>
<test:Animal.legs rdf:resource="#_1100"/>
</test:Dog>
<test:Cat rdf:ID="_101">
<test:Animal.Name>Tom</test:Animal.Name>
<test:Cat.breed>Munchkin</test:Cat.breed>
<test:Animal.age rdf:resource="#_1001"/>
<test:Animal.legs rdf:resource="#_1100"/>
</test:Cat>
</rdf:RDF>
</code>```

I'm using java dom to parse.
Paring ID and name is clear but How should rdf:resource="#_1000"/>?

Here is my code :

```<code>        try {
        DocumentBuilderFactory factory_parsing = DocumentBuilderFactory.newInstance();
        DocumentBuilder builder_parsing = factory_parsing.newDocumentBuilder();
        Document document = builder_parsing.parse("D://Test/dog_test.xml");
        document.getDocumentElement().normalize();

        System.out.println("Root element: " + document.getDocumentElement().getNodeName()); //
        NodeList nList = document.getElementsByTagName("test:Dog");
        System.out.println(nList.getLength());

        for(i=0; i<nList.getLength();i++)
        {
            Node nNode = nList.item(i);

            System.out.println("\nCurrent Element: " + nNode.getNodeName());

            if (nNode.getNodeType() == Node.ELEMENT_NODE) {
                Element elem = (Element) nNode;

                String id = elem.getAttribute("rdf:ID");
                String name = elem.getElementsByTagName(("test:Animal.Name")).item(0).getTextContent();
                String age = elem.getAttribute("rdf:resource");

                System.out.printf("id : %s%n", id);
                System.out.printf("Name : %s%n", name);
                System.out.printf("age : %s%n", age);
            }
        }
    } catch (Exception e){
        e.printStackTrace();
    }
</code>```

The result :
Current Element: test:Dog//id : _100//Name : Jeck//age ://It return age is blank

[Additional] I solved it on this site. https://mkyong.com/java/how-to-read-xml-file-in-java-dom-parser/
Thank you for your reply.

Body:
Here is my xml document :

<rdf:RDF
xmlns:test="http://www.test/2022#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
xml:base="http://www.desktop-eqkvgq5.net/2022#">
<test:Dog rdf:ID="_100">
<test:Animal.Name>Jeck</test:Animal.Name>
<test:Dog.breed>Akita</test:Dog.breed>
<test:Animal.age rdf:resource="#_1000"/>
<test:Animal.legs rdf:resource="#_1100"/>
</test:Dog>
<test:Cat rdf:ID="_101">
<test:Animal.Name>Tom</test:Animal.Name>
<test:Cat.breed>Munchkin</test:Cat.breed>
<test:Animal.age rdf:resource="#_1001"/>
<test:Animal.legs rdf:resource="#_1100"/>
</test:Cat>
</rdf:RDF>

I'm using java dom to parse.
Paring ID and name is clear but How should rdf:resource="#_1000"/>?

Here is my code :

        try {
        DocumentBuilderFactory factory_parsing = DocumentBuilderFactory.newInstance();
        DocumentBuilder builder_parsing = factory_parsing.newDocumentBuilder();
        Document document = builder_parsing.parse("D://Test/dog_test.xml");
        document.getDocumentElement().normalize();

        System.out.println("Root element: " + document.getDocumentElement().getNodeName()); //
        NodeList nList = document.getElementsByTagName("test:Dog");
        System.out.println(nList.getLength());

        for(i=0; i<nList.getLength();i++)
        {
            Node nNode = nList.item(i);

            System.out.println("\nCurrent Element: " + nNode.getNodeName());

            if (nNode.getNodeType() == Node.ELEMENT_NODE) {
                Element elem = (Element) nNode;

                String id = elem.getAttribute("rdf:ID");
                String name = elem.getElementsByTagName(("test:Animal.Name")).item(0).getTextContent();
                String age = elem.getAttribute("rdf:resource");

                System.out.printf("id : %s%n", id);
                System.out.printf("Name : %s%n", name);
                System.out.printf("age : %s%n", age);
            }
        }
    } catch (Exception e){
        e.printStackTrace();
    }

The result :
Current Element: test:Dog//id : _100//Name : Jeck//age ://It return age is blank

[Additional] I solved it on this site. https://mkyong.com/java/how-to-read-xml-file-in-java-dom-parser/
Thank you for your reply.


问:
From a GRPC Project, call a method on another GRPC project, in a different solution
I'm using GRPC in C#, I already have a GRPC Project that uses its locals methods / proto classes, but  don't know how to call a method that's in a different GRPC service that I referenced my adding the corresponding Nuget Package. Do I need to create that service proto  method again? I'm not sure how to do this and I can't find examples about this.

For example This is one method in the proto file in that other service I need to use in my project:

```<code>/* Creates a new address under a given customer. */
rpc Create(CreateAddressRequest) returns (Address) {
    option (google.api.http) = {
        post: "/api/customers/{customer_id}/addresses/{type}"
        body: "address"
    };
}
</code>```

And ths is the corresponding method in C# code (removed all the content)

```<code>[Authorize(Roles = V1.AuthorizationAttributes.Addresses.Create)]
public override async Task<Address> Create(CreateAddressRequest request, ServerCallContext context)
{
    Guard.AgainstNull(request);
    Guard.AgainstNonPositiveNumber(request.CustomerId);
    Guard.AgainstNull(request.Address);

    // more content here..

    return AddressSerializer.Serialize(address!);
}
</code>```

So that's in a different service / solution that I reference by adding the nuget package to my GRPC project. What should I do to be able to call this method from my GRPc project?

Body:
I'm using GRPC in C#, I already have a GRPC Project that uses its locals methods / proto classes, but  don't know how to call a method that's in a different GRPC service that I referenced my adding the corresponding Nuget Package. Do I need to create that service proto  method again? I'm not sure how to do this and I can't find examples about this.

For example This is one method in the proto file in that other service I need to use in my project:

/* Creates a new address under a given customer. */
rpc Create(CreateAddressRequest) returns (Address) {
    option (google.api.http) = {
        post: "/api/customers/{customer_id}/addresses/{type}"
        body: "address"
    };
}

And ths is the corresponding method in C# code (removed all the content)

[Authorize(Roles = V1.AuthorizationAttributes.Addresses.Create)]
public override async Task<Address> Create(CreateAddressRequest request, ServerCallContext context)
{
    Guard.AgainstNull(request);
    Guard.AgainstNonPositiveNumber(request.CustomerId);
    Guard.AgainstNull(request.Address);

    // more content here..

    return AddressSerializer.Serialize(address!);
}

So that's in a different service / solution that I reference by adding the nuget package to my GRPC project. What should I do to be able to call this method from my GRPc project?


问:
Creating A Unique Context Menu In Windows
I am wondering if there is a way to create an application for windows that is not in a form/window format. Something that could show up near a cursor such as the context menu shows up when you right click on a desktop. A small app that could launch when a user would trigger lets say a middle mouse button click and then form around the cursor location.  I am relatively new to windows development and starting to work/learn windows form development. Trying to understand if it's something that is even possible.

Thank you in advance and reach out if I need to add more description!

So far, I have googled around and have found nothing along the lines of what I am looking


问:
How to gently stop/pause an animation in CSS?
I am trying to create a personal webpage. In this website I will 4 circles that move in a circular path infinitely. If I ever hover my cursor over one of the circles, I want all of the circles to gently come to a stop, and have the one I am hovering over move into the center of the circle and increase in size. I have an idea on how to do the latter, but my main issue is how I can get a CSS animation come to a gentle stop and not a sudden halt, kind of like ease transition that comes to a stop, except in a much shorter period of time.

I have tried researching quite a bit but the only thing I come across is the animation-play-state property. However, this property can only bring the animation to a complete pause, which is not what I want. I cannot use the transition property on animation-play-state even if I wanted to because transition only works if there are numerical values that can be altered as time pass for the transition (like opacity going from 0.5 to 0.9 in .1 increments based on transition time as opposed to visibility being either just hidden or visible).

I am open to the idea of needing to JS if necessary (I am just getting into web development). However, I would prefer if there are any answers that compose of just CSS or vanilla JS as I want to get a strong base in CSS and JS before moving on to frameworks.


问:
How to parse enum arguments in Rust
In the Rust CLI I'm developing with using Clap, I take some parameters from the end user, which is specified as a struct.

args.rs

use clap:: {
    Args,
    Parser,
    Subcommand
};

#[derive(Debug, Parser)]
#[clap(author, version, about)]
pub struct CLIArgs {
    #[clap(subcommand)]
    pub action: CLIAction,
}

#[derive(Debug, Subcommand)]
pub enum CLIAction {
    Run(RunCommand),

    Copy(CopyCommand),
}

#[derive(Debug, Args)]
pub struct RunCommand {
    pub app: String,

    #[clap(long)]
    pub from: String,

    #[clap(long)]
    pub against: String
}

#[derive(Debug, Args)]
#[derive(Default)]
pub struct CopyCommand {
    pub app: String,
}
```
<p>I use this file in my <code>main.rs</code> as follows.</p>
<p><strong>main.rs</strong></p>
<pre class="lang-rs prettyprint-override"><code>use clap::Parser;

mod args;

use args::CLIArgs;

fn main() {
    let args: CLIArgs = CLIArgs::parse();
    println!("{:?}",args.action);
}
</code>```

When executing the following run command,

cli run console --from id --against local

The print statement in the main method prints the following, but I'm unable to parse this in order to get specific properties from this. :(

Run(RunCommand { app: "console", from: "id", against: "local" })
```

Ideally I want to do something like,

args.action.app -> returns "console"

Any idea how to properly parse the args.action and get the above done? Thanks in advance.

Title: How to parse enum arguments in Rust

Body:
In the Rust CLI I'm developing with using Clap, I take some parameters from the end user, which is specified as a struct.

args.rs

use clap:: {
    Args,
    Parser,
    Subcommand
};

#[derive(Debug, Parser)]
#[clap(author, version, about)]
pub struct CLIArgs {
    #[clap(subcommand)]
    pub action: CLIAction,
}

#[derive(Debug, Subcommand)]
pub enum CLIAction {
    Run(RunCommand),

    Copy(CopyCommand),
}

#[derive(Debug, Args)]
pub struct RunCommand {
    pub app: String,

    #[clap(long)]
    pub from: String,

    #[clap(long)]
    pub against: String
}

#[derive(Debug, Args)]
#[derive(Default)]
pub struct CopyCommand {
    pub app: String,
}

I use this file in my main.rs as follows.

main.rs

use clap::Parser;

mod args;

use args::CLIArgs;

fn main() {
    let args: CLIArgs = CLIArgs::parse();
    println!("{:?}",args.action);
}

When executing the following run command,

cli run console --from id --against local

The print statement in the main method prints the following, but I'm unable to parse this in order to get specific properties from this. :(

Run(RunCommand { app: "console", from: "id", against: "local" })

Ideally I want to do something like,

args.action.app -> returns "console"

Any idea how to properly parse the args.action and get the above done? Thanks in advance.


问:
When using a 12 column grid whenever I put tags inside an element like
 whatever the descendent elements are
I'm new to coding and trying to get into using grids in my css as they seem super useful.  My textbook and all the guides I find tend to show the css but not associated html.

Anyway when I put tags into and area element like   , the tags inside of them will not display in the correct columns and rows, but if I take those tags out of those elements they will work in the grid.  Using the inspect tool tells me to turn the parent element to display: grid, but that doesen't work.  My textbook says you can use
,
 etc etc on a 12 column grid but for the life of me I can't figure it out.

I've tried putting display: grid into every element... I've tried using the inspect tool to try to learn why they are getting the display: block property, but all I get is its coming from "user agent stylesheet", Ive tried on Chrome and Firefox.

/* custom property */
:root {
    --global-color-1: #21aab4;
    background-color: white;
}
* {
    margin: 0;
    padding: 0;
}

/* the styles for the elements */
body {
    font-family: Arial, Helvetica, sans-serif;
  font-size: 100%;

    border: 3px solid black;

    margin: 0;
    display: grid;
    grid-template-rows: 150px auto auto 150px;
    grid-template-columns: repeat(12, 8.3vw);

}
img {
    max-width: 100%;
    overflow: hidden;
}

#logo{
    display: grid;
    grid-row: 1 /2; grid-column: 1 / 5;
    max-width: 100%;
}
#name{
    max-width: 100%;
    padding-top: 2rem;
    grid-row: 1 /2; grid-column: 1 / 5;
}
#header {
    grid-row: 1 / 2; grid-column: 1 / 13;
    background-color: white;
  border-bottom: 2px solid black;
}
#nav {
  display: flex;
  justify-content: space-between;

  list-style-type: none;
  grid-column: 5 / 12;
  padding-top: 2.5rem;
    border-bottom: 2px solid black;

}
main {
    grid-row: 2 / 4; grid-column: 1 / 13;
    display: grid;
}

#thoughtful {
  display: flex;
    grid-row: 2 / 4;
    grid-column: 1 /  5;
}
#s2 {
    grid-row: 2 / 4; grid-column: 7 / 13;
    width: 40vw;
}
#s2 h1{
    font-size: 3.2vw;
}
#s2 li{
    font-size: 2vw;
}
footer {
    grid-row: 4 / 5; grid-column: 1 / 12;
    text-align: center;
    padding-top: 5vh;
    font-family: serif;
}
a:focus, a:hover {
    font-style: italic;
}

.current {
    color:  rgb(20, 111, 4);
}```
<pre class="snippet-code-html lang-html prettyprint-override"><code><!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title>Sage Raymond </title>
    <link rel="shortcut icon" href="images/Bear-favicon.jpg">
    <link rel="stylesheet" href="styles/main_gridexp.css">
    <meta name="viewport" content="width=device-width, initial-scale=1">
</head>

<body>
        <div id="logo"><img src="images/name.gif" alt="Sage Raymond Homepage" id="name"></div>
        <ul id="nav">
      <li> </li>
      <li class="current"><h2>Home</h2></li>

      <li><h2 class="current">C.V.</h2></li>
      <li><h2>Papers</h2></li>
      <li><h2>Media</h2></li>
    </ul>

    <img src="images/thoughtful_sage.jpeg" id="thoughtful">
    <ul id="s2">
      <h1>Degrees</h1>
      <li>Master of Science in Ecology, University of Alberta, January 2021 to present</li>
      <li>Bachelor of Science in Biology, Thompson Rivers University, December 2020</li>
      <li>Diploma in Recreation, Fish, and Wildlife, Selkirk College, April 2017</li>
    </ul>

    <footer>
      <p>© 2022, Sage Raymond, Port Townsend, WA, USA 98368</p>
    </footer>
</body>
</html></code>```

Title: When using a 12 column grid whenever I put tags inside an element like <header> <div> whatever the descendent elements are

Body:
I'm new to coding and trying to get into using grids in my css as they seem super useful.  My textbook and all the guides I find tend to show the css but not associated html.

Anyway when I put tags into and area element like   , the tags inside of them will not display in the correct columns and rows, but if I take those tags out of those elements they will work in the grid.  Using the inspect tool tells me to turn the parent element to display: grid, but that doesen't work.  My textbook says you can use
,
 etc etc on a 12 column grid but for the life of me I can't figure it out.

I've tried putting display: grid into every element... I've tried using the inspect tool to try to learn why they are getting the display: block property, but all I get is its coming from "user agent stylesheet", Ive tried on Chrome and Firefox.

/* custom property */
:root {
    --global-color-1: #21aab4;
    background-color: white;
}
* {
    margin: 0;
    padding: 0;
}

/* the styles for the elements */
body {
    font-family: Arial, Helvetica, sans-serif;
  font-size: 100%;

    border: 3px solid black;

    margin: 0;
    display: grid;
    grid-template-rows: 150px auto auto 150px;
    grid-template-columns: repeat(12, 8.3vw);

}
img {
    max-width: 100%;
    overflow: hidden;
}

#logo{
    display: grid;
    grid-row: 1 /2; grid-column: 1 / 5;
    max-width: 100%;
}
#name{
    max-width: 100%;
    padding-top: 2rem;
    grid-row: 1 /2; grid-column: 1 / 5;
}
#header {
    grid-row: 1 / 2; grid-column: 1 / 13;
    background-color: white;
  border-bottom: 2px solid black;
}
#nav {
  display: flex;
  justify-content: space-between;

  list-style-type: none;
  grid-column: 5 / 12;
  padding-top: 2.5rem;
    border-bottom: 2px solid black;

}
main {
    grid-row: 2 / 4; grid-column: 1 / 13;
    display: grid;
}

#thoughtful {
  display: flex;
    grid-row: 2 / 4;
    grid-column: 1 /  5;
}
#s2 {
    grid-row: 2 / 4; grid-column: 7 / 13;
    width: 40vw;
}
#s2 h1{
    font-size: 3.2vw;
}
#s2 li{
    font-size: 2vw;
}
footer {
    grid-row: 4 / 5; grid-column: 1 / 12;
    text-align: center;
    padding-top: 5vh;
    font-family: serif;
}
a:focus, a:hover {
    font-style: italic;
}

.current {
    color:  rgb(20, 111, 4);
}

<!DOCTYPE html>

    <meta charset="utf-8">
    <title>Sage Raymond </title>
    <link rel="shortcut icon" href="images/Bear-favicon.jpg">
    <link rel="stylesheet" href="styles/main_gridexp.css">
    <meta name="viewport" content="width=device-width, initial-scale=1">

Home

C.V.

Papers

Media

Degrees

Master of Science in Ecology, University of Alberta, January 2021 to present

Bachelor of Science in Biology, Thompson Rivers University, December 2020

Diploma in Recreation, Fish, and Wildlife, Selkirk College, April 2017

© 2022, Sage Raymond, Port Townsend, WA, USA 98368


问:
i am getting an error The QuerySet value for an exact lookup must be limited to one result using slicing
When i am redirecting to the dashboard/ i am getting this error, i think that it is because i dont have the data, just empty data tables in postgreSQL is this because of empty tables?
Here is my views.py:

```<code>@login_required
def dashboard(request):
    user = request.user
    company = None
    is_expired = 0
    cost_diverse = 0
    cost_not_diverse = 0
    total_invoice = 0
    project_bar_e_id = []
    project_bar_e_value = []
    project_bar_s_id = []
    project_bar_s_value = []
    project_bar_g_id = []
    project_bar_g_value = []
    today = datetime.now().date()
    if user.role == UserRole.COLLABORATOR:
        company = Company.objects.get(collaborators=user)
    else:
        company = Company.objects.filter(user=user)

    if company:
        company_u = CustomUser.get_company(request.user)

        if user.role == UserRole.PROJECT_OWNER:

            project = Project.objects.filter(company=company_u)
            if project:
                diverse_not_diverse = ResourceDiverseNotDiverse.objects.filter(project__company=company_u)
                invoice = invoice_project.objects.filter(company=company_u)
                if diverse_not_diverse:
                    cost_diverse = sum(item.diverse_total for item in diverse_not_diverse)
                    cost_not_diverse = sum(item.not_diverse_total for item in diverse_not_diverse)
                if invoice:
                    total_invoice = sum(item.amount for item in invoice)

            val = {
                'company_id': company_u.id
            }
            r_success = requests.post(URL_DETAILS_OWNER, data=json.dumps(val))
            body_result = r_success.json()

            if body_result['statusCode'] == 200:
                result = json.loads(body_result['body'])

                #e_top bar
                for e_top in result['e_each_top_5_projects_id']:
                    project_bar_e_id.append(e_top['project_id'])
                    project_bar_e_value.append(e_top['e'])

                for e_bottom in result['e_each_bottom_5_projects_id']:
                    project_bar_e_id.append(e_bottom['project_id'])
                    project_bar_e_value.append(e_bottom['e'])

                #s_top bar
                for s_top in result['s_each_top_5_projects_id']:
                    project_bar_s_id.append(s_top['project_id'])
                    project_bar_s_value.append(s_top['s'])

                for s_bottom in result['s_each_bottom_5_projects_id']:
                    project_bar_s_id.append(s_bottom['project_id'])
                    project_bar_s_value.append(s_bottom['s'])

                #g_top bar
                for g_top in result['g_each_top_5_projects_id']:
                    project_bar_g_id.append(g_top['project_id'])
                    project_bar_g_value.append(g_top['g'])

                for g_bottom in result['g_each_bottom_5_projects_id']:
                    project_bar_g_id.append(g_bottom['project_id'])
                    project_bar_g_value.append(g_bottom['g'])

        else:
            project = Project.objects.filter(company=company_u).first()

        supplier_detail = FileSupplierRisk.objects.filter(company=company_u)
        osha_logs = supplier_detail.filter(prefix_form='osha')
        policies = FileSupplierRisk.objects.filter(prefix_form='policies')
        balance_sheet = FileSupplierRisk.objects.filter(prefix_form='balance')
        company_resources = CompanyResource.objects.filter(company=company_u)
        projects_execution = Project.objects.filter(stage_project=StageProyect.RFP_BID).exclude(company=company_u).order_by('-created_at')
        certifications = CompanyCertification.objects.filter(company=company_u)
        for certification in certifications:
            if certification.expiration_date is not None and str(datetime.strptime(f'{certification.expiration_date}', FORMAT_DATE)) < str(today):
                is_expired += 1

        context = {
            'company': company_u,
            'project': project,
            'is_expired': is_expired,
            'osha_logs': osha_logs,
            'policies': policies,
            'balance_sheet': balance_sheet,
            'company_resources': company_resources,
            'projects_execution': projects_execution.count(),
            'cost_diverse': cost_diverse,
            'cost_not_diverse': cost_not_diverse,
            'total_invoice': total_invoice,
            'project_bar_e_id': project_bar_e_id,
            'project_bar_e_value': project_bar_e_value,
            'project_bar_s_id': project_bar_s_id,
            'project_bar_s_value': project_bar_s_value,
            'project_bar_g_id': project_bar_g_id,
            'project_bar_g_value': project_bar_g_value,
        }
        return render(request, 'dashboard/index.html', context)
    else:
        return redirect('register')
</code>```

Here is the ss of the problem:
enter image description here

here is the error:

```<code>Internal Server Error: /dashboard/
Traceback (most recent call last):
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\core\handlers\exception.py", line 47, in inner
    response = get_response(request)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\core\handlers\base.py", line 179, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\contrib\auth\decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\apps\dashboard\views.py", line 65, in dashboard
    if project:
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\query.py", line 291, in __bool__
    self._fetch_all()
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\query.py", line 1308, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 1143, in execute_sql
    sql, params = self.as_sql()
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 513, in as_sql
    where, w_params = self.compile(self.where) if self.where is not None else ("", [])
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 430, in compile
    sql, params = node.as_sql(self, self.connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\where.py", line 81, in as_sql
    sql, params = compiler.compile(child)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 430, in compile
    sql, params = node.as_sql(self, self.connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\fields\related_lookups.py", line 132, in as_sql
    return super().as_sql(compiler, connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\lookups.py", line 302, in as_sql
    return super().as_sql(compiler, connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\lookups.py", line 181, in as_sql
    rhs_sql, rhs_params = self.process_rhs(compiler, connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\lookups.py", line 284, in process_rhs
    raise ValueError(
ValueError: The QuerySet value for an exact lookup must be limited to one result using slicing.
</code>```

I made one data manually in the companies table and the rest of the tables are empty is this the reason for the error?

Body:
When i am redirecting to the dashboard/ i am getting this error, i think that it is because i dont have the data, just empty data tables in postgreSQL is this because of empty tables?
Here is my views.py:

@login_required
def dashboard(request):
    user = request.user
    company = None
    is_expired = 0
    cost_diverse = 0
    cost_not_diverse = 0
    total_invoice = 0
    project_bar_e_id = []
    project_bar_e_value = []
    project_bar_s_id = []
    project_bar_s_value = []
    project_bar_g_id = []
    project_bar_g_value = []
    today = datetime.now().date()
    if user.role == UserRole.COLLABORATOR:
        company = Company.objects.get(collaborators=user)
    else:
        company = Company.objects.filter(user=user)

    if company:
        company_u = CustomUser.get_company(request.user)

        if user.role == UserRole.PROJECT_OWNER:

            project = Project.objects.filter(company=company_u)
            if project:
                diverse_not_diverse = ResourceDiverseNotDiverse.objects.filter(project__company=company_u)
                invoice = invoice_project.objects.filter(company=company_u)
                if diverse_not_diverse:
                    cost_diverse = sum(item.diverse_total for item in diverse_not_diverse)
                    cost_not_diverse = sum(item.not_diverse_total for item in diverse_not_diverse)
                if invoice:
                    total_invoice = sum(item.amount for item in invoice)

            val = {
                'company_id': company_u.id
            }
            r_success = requests.post(URL_DETAILS_OWNER, data=json.dumps(val))
            body_result = r_success.json()

            if body_result['statusCode'] == 200:
                result = json.loads(body_result['body'])

                #e_top bar
                for e_top in result['e_each_top_5_projects_id']:
                    project_bar_e_id.append(e_top['project_id'])
                    project_bar_e_value.append(e_top['e'])

                for e_bottom in result['e_each_bottom_5_projects_id']:
                    project_bar_e_id.append(e_bottom['project_id'])
                    project_bar_e_value.append(e_bottom['e'])

                #s_top bar
                for s_top in result['s_each_top_5_projects_id']:
                    project_bar_s_id.append(s_top['project_id'])
                    project_bar_s_value.append(s_top['s'])

                for s_bottom in result['s_each_bottom_5_projects_id']:
                    project_bar_s_id.append(s_bottom['project_id'])
                    project_bar_s_value.append(s_bottom['s'])

                #g_top bar
                for g_top in result['g_each_top_5_projects_id']:
                    project_bar_g_id.append(g_top['project_id'])
                    project_bar_g_value.append(g_top['g'])

                for g_bottom in result['g_each_bottom_5_projects_id']:
                    project_bar_g_id.append(g_bottom['project_id'])
                    project_bar_g_value.append(g_bottom['g'])

        else:
            project = Project.objects.filter(company=company_u).first()

        supplier_detail = FileSupplierRisk.objects.filter(company=company_u)
        osha_logs = supplier_detail.filter(prefix_form='osha')
        policies = FileSupplierRisk.objects.filter(prefix_form='policies')
        balance_sheet = FileSupplierRisk.objects.filter(prefix_form='balance')
        company_resources = CompanyResource.objects.filter(company=company_u)
        projects_execution = Project.objects.filter(stage_project=StageProyect.RFP_BID).exclude(company=company_u).order_by('-created_at')
        certifications = CompanyCertification.objects.filter(company=company_u)
        for certification in certifications:
            if certification.expiration_date is not None and str(datetime.strptime(f'{certification.expiration_date}', FORMAT_DATE)) < str(today):
                is_expired += 1

        context = {
            'company': company_u,
            'project': project,
            'is_expired': is_expired,
            'osha_logs': osha_logs,
            'policies': policies,
            'balance_sheet': balance_sheet,
            'company_resources': company_resources,
            'projects_execution': projects_execution.count(),
            'cost_diverse': cost_diverse,
            'cost_not_diverse': cost_not_diverse,
            'total_invoice': total_invoice,
            'project_bar_e_id': project_bar_e_id,
            'project_bar_e_value': project_bar_e_value,
            'project_bar_s_id': project_bar_s_id,
            'project_bar_s_value': project_bar_s_value,
            'project_bar_g_id': project_bar_g_id,
            'project_bar_g_value': project_bar_g_value,
        }
        return render(request, 'dashboard/index.html', context)
    else:
        return redirect('register')

Here is the ss of the problem:
enter image description here

here is the error:

Internal Server Error: /dashboard/
Traceback (most recent call last):
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\core\handlers\exception.py", line 47, in inner
    response = get_response(request)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\core\handlers\base.py", line 179, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\contrib\auth\decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\apps\dashboard\views.py", line 65, in dashboard
    if project:
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\query.py", line 291, in __bool__
    self._fetch_all()
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\query.py", line 1308, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 1143, in execute_sql
    sql, params = self.as_sql()
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 513, in as_sql
    where, w_params = self.compile(self.where) if self.where is not None else ("", [])
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 430, in compile
    sql, params = node.as_sql(self, self.connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\where.py", line 81, in as_sql
    sql, params = compiler.compile(child)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 430, in compile
    sql, params = node.as_sql(self, self.connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\fields\related_lookups.py", line 132, in as_sql
    return super().as_sql(compiler, connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\lookups.py", line 302, in as_sql
    return super().as_sql(compiler, connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\lookups.py", line 181, in as_sql
    rhs_sql, rhs_params = self.process_rhs(compiler, connection)
  File "D:\Suhaib Illyas\Locomex\code\backend-locomex\.venv\lib\site-packages\django\db\models\lookups.py", line 284, in process_rhs
    raise ValueError(
ValueError: The QuerySet value for an exact lookup must be limited to one result using slicing.

I made one data manually in the companies table and the rest of the tables are empty is this the reason for the error?


问:
Is there any way to look into the caches folder on iOS?
I used an image cropping library to crop a taken photo. The cropped photo was then saved with a path called, "file:///var/mobile/Containers/Data/Application/7DFB198F-E7B7-4D28-A334-652B8F59F0EB/Library/Caches/ReactNative_cropped_image_/D8465CA1-4F9F-4596-8F23-1FCFB452F6B2.jpg". The thing is, there is no way for me to check whether the photo was properly cropped or not. Is there any way to look into the caches folder and check out the files?</p>


问:
Is it possible to prevent an user using the GET HTTP Request method to submit a form?
I operate a website that has had thousands of users successfully submit a form and I am trying to understand an anomalgy. Is it possible to prevent the below user using the GET HTTP Request method to submit a form?

At 1:14:13pm the sever receives a GET request from a logged in user (ID123) on ip XXX.XXX.XXX.36 for form.php and the http status is 200.

At 1:45:52pm the server receives a GET request from the same logged in user (ID123) on IP XXX.XXX.XXX.36 for post_form.php and the http status is 302 (the user is redirected to error.php because post_form.php expected the HTTP Request method to be POST)

At 1:45:52pm the server receives a GET request from the same logged in user (ID123) on IP XXX.XXX.XXX.9 for error.php and the http status is 200.

I find it very odd that the error page is servered to a new IP address and suspect this may be related to the issue.

Do other devs with large volumes of traffic have similar anomalies?

For further context:

The user is running a three year old version of Mac and two month old version of Google Chrome.

The IP address is for one of the large ISPs in this region (so I suspect this isn't related to a misconfigured proxy on the users end).

The user only logged in once prior to the error occuring, so it this isn't caused by being signed into multiple devices.

I used the below HTML/JS for the form:

<form id="form" action='./post_form.php'  method="post" enctype="multipart/form-data">
    <input type="text" name="amount" id="amount" placeholder="Please enter the amount" value='' maxlength="255">
    Submit Information
</form>

```
<p>I use the below PHP to detect the HTTP Request Method:</p>
```
if ($_SERVER["REQUEST_METHOD"] != "POST") {
   file_put_contents ("error.txt","*Debug Details*",FILE_APPEND);
   header("location:./error.php");
   exit();
}
```

I have reviewed the error logs and been unable to find any rationale explanation for why they would be trying to GET the post_form.php.

Body:
I operate a website that has had thousands of users successfully submit a form and I am trying to understand an anomalgy. Is it possible to prevent the below user using the GET HTTP Request method to submit a form?

At 1:14:13pm the sever receives a GET request from a logged in user (ID123) on ip XXX.XXX.XXX.36 for form.php and the http status is 200.

At 1:45:52pm the server receives a GET request from the same logged in user (ID123) on IP XXX.XXX.XXX.36 for post_form.php and the http status is 302 (the user is redirected to error.php because post_form.php expected the HTTP Request method to be POST)

At 1:45:52pm the server receives a GET request from the same logged in user (ID123) on IP XXX.XXX.XXX.9 for error.php and the http status is 200.

I find it very odd that the error page is servered to a new IP address and suspect this may be related to the issue.

Do other devs with large volumes of traffic have similar anomalies?

For further context:

The user is running a three year old version of Mac and two month old version of Google Chrome.

The IP address is for one of the large ISPs in this region (so I suspect this isn't related to a misconfigured proxy on the users end).

The user only logged in once prior to the error occuring, so it this isn't caused by being signed into multiple devices.

I used the below HTML/JS for the form:

<form id="form" action='./post_form.php'  method="post" enctype="multipart/form-data">
    <input type="text" name="amount" id="amount" placeholder="Please enter the amount" value='' maxlength="255">
    Submit Information
</form>

I use the below PHP to detect the HTTP Request Method:

if ($_SERVER["REQUEST_METHOD"] != "POST") {
   file_put_contents ("error.txt","*Debug Details*",FILE_APPEND);
   header("location:./error.php");
   exit();
}

I have reviewed the error logs and been unable to find any rationale explanation for why they would be trying to GET the post_form.php.


问:
Embedding website without iFrame but with URL routing
So theres a service called NoCodeMayo and it allows you to put content from other sites onto your own domain. It's built on vercel. It basically acts as an iFrame, but isn't, and changes the URL on the page as if you were on the actual site. How did they do this?

https://nocodemayo.com

I tried using <embed>, but didn't work.


问:
Use stored procedure in postgresql to compare input value with that in database table? python
In postgresql database, need to compare the password being entered to the last 5 passwords stored, so that they are not similar. Need to use a stored procedure as the password change is done using different portals, but to the same database table. Can you suggest the best way to achieve this. NOTE: The password while storing is already stored with SHA1 and not pg crypt algorithm. How can we implement this Stored procedure</p>


问:
Is it possible to read a shared memory block from inside a loop in PHP and get updated values when that shared memory is updated by another script?
I have a PHP EventSource script that looks something like this:

```<code>...
while (true){

  // read state of shared memory
  echo.. [value inside shared memory];

  if (connection_aborted())
     break;
  sleep(n);
}
</code>```

The EventSource parts works well, updating the client (sample.com/client.html) every n seconds. However, when the shared memory is updated with a different value (say from "Foo 1" to "Foo 2") from another script, the client keeps receiving the original value (i.e. "Foo 1").

Here's what I've tried:

I know the variable is updated because if I try the page (sample.com/client.html) from another browser or machine right after updating the variable, it shows me the updated value ("Foo 2").

if I reload the client page, it will show me the updated value "Foo 2" (and it won't change from that even if I update the value on shared memory again)

tried using APCu and shmop with both doing the same thing.

tried encapsulating reading the shared memory inside a function, but it has the same behavior.

also tried to shell_exec() a secondary PHP script to just read the shared memory, but get a 'permission denied' error from the hosting server :/ [not related, but I tried it too]

Is what I'm trying to do even possible in PHP? I'm afraid I may be missing something important about how PHP operates [i.e. caching variables or the result of shmop_read()/apcu_fetch() calls?]

Any help will be tremendously appreciated

Body:
I have a PHP EventSource script that looks something like this:

...
while (true){

  // read state of shared memory
  echo.. [value inside shared memory];

  if (connection_aborted())
     break;
  sleep(n);
}

The EventSource parts works well, updating the client (sample.com/client.html) every n seconds. However, when the shared memory is updated with a different value (say from "Foo 1" to "Foo 2") from another script, the client keeps receiving the original value (i.e. "Foo 1").

Here's what I've tried:

I know the variable is updated because if I try the page (sample.com/client.html) from another browser or machine right after updating the variable, it shows me the updated value ("Foo 2").

if I reload the client page, it will show me the updated value "Foo 2" (and it won't change from that even if I update the value on shared memory again)

tried using APCu and shmop with both doing the same thing.

tried encapsulating reading the shared memory inside a function, but it has the same behavior.

also tried to shell_exec() a secondary PHP script to just read the shared memory, but get a 'permission denied' error from the hosting server :/ [not related, but I tried it too]

Is what I'm trying to do even possible in PHP? I'm afraid I may be missing something important about how PHP operates [i.e. caching variables or the result of shmop_read()/apcu_fetch() calls?]

Any help will be tremendously appreciated


问:
Why Does My Website Only Encounter Issue On The Mobile Version Of Google Chrome?
I'm a beginner at creating a website with HTML, CSS, and Javascript. I have created a responsive website and am in the process of testing how it runs on both a computer and a mobile device. I have no problems getting it to run on a computer, but when it comes to testing it out on a mobile device I'm running into some issues. I've been testing it on my iPhone 12 pro, not with any sort of simulator.

I have tested out multiple mobile browsers, and they all seem to run my website without any issues except for Google Chrome. When using Google Chrome, after opening the website and viewing a few pages, the website seems to freeze. After freezing, none of the links work (including the menu), and sometimes content disappears. Refreshing the page doesn't help and the only way I'm able to access my website again is by closing out the window and opening up the website in a new one.

I originally thought that maybe the -webkit-transform: script, the display: block, or the display: none script in the CSS may be affecting the performance of my website on a mobile browser, but this doesn't seem to be the case. Could the Javascript be affecting my website? Is this an issue with Google Chrome itself?

Below is all the code that I'm using on my website. If anyone has any ideas about why my website isn't working well with the mobile version of Google Chrome I would very much appreciate sharing them with me.

Thank you.

```<code><!DOCTYPE html>
<html lang="ja">

<head>

<meta name="viewport" content="width=device-width, initial-scale=1.0;" charset="utf-8">

<title>MORIKOBOSHI・</title>

</head>

<body>

<div class="page-wrap">

<div class="cp_cont">
<input id="cp_toggle03" type="checkbox"/>
<div class="cp_mobilebar">
<label for="cp_toggle03" class="cp_menuicon">
<span></span>
</label>
</div>
<label id="h-menu_black" class="cp_toggle03" for="cp_menuicon"></label>
<div id="body" class="noscroll"></div>

<header class="cp_offcm03">

<nav>
<ul style="text-align: center; margin-left: 210px; overflow: hidden; padding-bottom: 10px;">

<li style="border-bottom: .05px solid lightgray;"><a href="#">ホーム</a></li>
<li style="border-bottom: .05px solid lightgray;"><a href="#">ブログ</a></li>
<li style="border-bottom: .05px solid lightgray;"><a href="#">このサイトについて</a></li>
<li style="border-bottom: .05px solid lightgray;"><a href="#">参考文献</a></li>

<div class="searchbar">

<form id="frmSearch" class="search2" method="get" action="default.html" style=" padding-right: 10px; padding-top: 20px; text-align: center; position: inline;">
<input class="search2" id="txtSearch" type="text" placeholder="Googleカスタム検索" name="serach_bar" size="31" maxlength="255" value="" style="top: 185px; width: 180px; height: 26px;">
<input class="search1" type="submit" name="submition" value="検索" style="padding-left: 5px; top: 153px; height: 25px; width: 34px; display: inline-flex; justify-content: center;">
<input class="search2" type="hidden" name="sitesearch" value="default.html">
</form>
</div>

<script type="text/javascript">
 document.getElementById('frmSearch').onsubmit = function() {
 window.location = 'http://www.google.com/search?q=site:morikoboshi.com' + document.getElementById('txtSearch').value;
        return false;
    }

</script>

<script>
 document.getElementById('cp_toggle03').onchange = function() {
 if (document.getElementById('cp_toggle03').checked) {
 document.body.style.overflow = "hidden";
  } else {
 document.body.style.overflow = "";
  }
}

</script>

</ul>
</nav>
</header>

<div class="setsumei">
<br><h1 style="text-align: center; font-size: 40px;">◯◯◯◯</h1>
<br><p style="text-align: justify; font-size: 16px;"></p>

 <p style="text-align: center; font-size: 13px;">著者：◯◯◯◯</p>
 <p style="text-align: center; font-size: 13px;">撮影日：◯◯◯◯年◯◯月◯◯日</p>

 <br><br><p style="text-align: justify; font-size: 16px;">

    #
 </p>

</div>

<br><br><div class="image">

 <a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

 <br><br><a href="#"><img src="#" alt="#" width="90%"></a>

</div>
</div>

<br><br><footer class="site-footer" style="font-size: 12px;">MORIKOBOSHI© | <a href="#">English</a></footer>

</div>

<style>

html {visibility: visible;
      opacity: 1;}

.body{background-color: white;
      font-family: sans-serif;}

 .searchbar{float: right;}

 .image{text-align: center;}

 .setsumei{margin-left: 20px;
           margin-right: 20px;}

 .footer{width: 100%;
           height: 40px;
           text-align: center;
           border-top: 1px solid black;
           position: absolute;
           bottom: 0;
           padding: 10px;}

 .page-wrap {
  min-height: 100%;
  /* equal to footer height */
  margin-bottom: -40px;
}

 .page-wrap:after {
  content: "";
  display: block;
  }

 .site-footer, .page-wrap:after {
  /* .push must be the same height as footer */
  height: 20px;
}

 .site-footer {
  text-align: center;
  border-top: 1px solid black;
  padding: 10px;
}

 *, *:before, *:after {
    padding-left: 0;
    margin: 0;
    box-sizing: border-box;

}

 ol, ul {
    list-style: none;
}

 a {
    text-decoration: none;
    color: black;
}

 .cp_cont {
    height: auto;
}

/* menu */
 .cp_offcm03 {
    position: relative;
    z-index: 5000;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
    overflow: auto;
    width: 100%;
    height: auto;
    padding-top: 0;
    -webkit-transition: transform 0.3s ease-in;
            transition: transform 0.3s ease-in;
    text-align: center;
    color: black;
    background-color: white;
}
 .cp_offcm03 nav,
 .cp_offcm03 ul {
    height: 100%;
}

 .cp_offcm03 li {
    display: inline-block;
    margin-right: -6px;
}

 .cp_offcm03 a {
    display: block;
    padding: 15px 45px;
    margin-bottom: -5px;
    -webkit-transition: background-color .3s ease-in;
            transition: background-color .3s ease-in;
}

 .cp_offcm03 a:hover {
    background-color: lightgray;
}

/* menu toggle */
 #cp_toggle03 {
    display: none;
}

 #cp_toggle03:checked ~ .cp_offcm03 {
    -webkit-transform: translateX(0);
                    transform: translateX(0);
}

 #cp_toggle03:checked ~ .cp_container {
    -webkit-transform: translateX(0);
                    transform: translateX(0);
}

 .cp_mobilebar {
    display: none;

}

/* content */
 .cp_container {
    position: relative;
    top: 0;
    padding: 35px auto;
    -webkit-transition: transform .3s ease-in;
            transition: transform .3s ease-in;
}

 .cp_content {
    margin: 0 auto;
    padding: 20px;
    height: 65vh;
    text-align: center;

}

@media (max-width: 1130px)and (min-width: 280px) {
/* menu */
 .cp_offcm03 {
        position: fixed;
        left: -250px;
        overflow-y: hidden;
        width: 250px;
        height: 100%;
        padding-top: 40px;
        color: black;
        background-color: white;
        z-index: 1000;
    }

 .cp_offcm03 nav {
        background: white;
        border-right: 0.5px solid lightgray;
        margin-left: -210px;
    }

 .cp_offcm03 li {
        display: block;
        margin-right: 0;}

 .cp_offcm03 a {
        padding: 20px;

    }

/* menu toggle */
 .cp_mobilebar {
        display: block;
        z-index: 2000;
        position: relative;
        top: 0;
        left: 0;
        padding: 0 25px;
        width: 100%;
        height: 40px;
        background-color: white;
        border-bottom: .05px solid lightgray;

    }

 .cp_menuicon {
        display: block;
        position: relative;
        width: 25px;
        height: 100%;
        cursor: pointer;
        -webkit-transition: transform .3s ease-in;
                transition: transform .3s ease-in;
    }
 .cp_menuicon > span {
        display: block;
        position: absolute;
        top: 55%;
        margin-top: -0.3em;
        width: 100%;
        height: 0.2em;
        border-radius: 1px;
        background-color: black;
        -webkit-transition: transform .3s ease;
                transition: transform .3s ease;
    }
 .cp_menuicon > span:before,
 .cp_menuicon > span:after {
        content: "";
        position: absolute;
        width: 100%;
        height: 100%;
        border-radius: 1px;
        background-color: black;
        -webkit-transition: transform .3s ease-in;
                transition: transform .3s ease-in;
    }

 .cp_menuicon > span:before {
        -webkit-transform: translateY(-0.6em);
                transform: translateY(-0.6em);
    }

 .cp_menuicon > span:after {
        -webkit-transform: translateY(0.6em);
                transform: translateY(0.6em);
    }

 #cp_toggle03:checked + .cp_mobilebar .cp_menuicon {
        -webkit-transform: rotate(45deg);
                transform: rotate(45deg);
    }

 #cp_toggle03:checked + .cp_mobilebar span:before,
 #cp_toggle03:checked + .cp_mobilebar span:after {
        -webkit-transform: rotate(90deg);
                transform: rotate(90deg);
    }

 #cp_toggle03:checked ~ .cp_offcm03 {
        -webkit-transform: translateX(100%);
                transform: translateX(100%);
    }

 #cp_toggle03:checked ~ .cp_container {
        -webkit-transform: translateX(250px);
                transform: translateX(250px);
    }

 input:checked ~ #h-menu_black {
    display: block;/*カバーを表示*/
    opacity: .6;
}

 #h-menu_black {
    display: none;
    position: fixed;
    z-index: 999;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background: black;
    opacity: 0;
    transition: .7s ease-in-out;
}

/* content */
 .cp_container {
        top: 60px;
        height: 92vh;
        text-align: center;
    }

 .noscroll{
        overflow: hidden;
        position: fixed;
    }

</style>

</body>
</html>
</code>```

Body:
I'm a beginner at creating a website with HTML, CSS, and Javascript. I have created a responsive website and am in the process of testing how it runs on both a computer and a mobile device. I have no problems getting it to run on a computer, but when it comes to testing it out on a mobile device I'm running into some issues. I've been testing it on my iPhone 12 pro, not with any sort of simulator.

I have tested out multiple mobile browsers, and they all seem to run my website without any issues except for Google Chrome. When using Google Chrome, after opening the website and viewing a few pages, the website seems to freeze. After freezing, none of the links work (including the menu), and sometimes content disappears. Refreshing the page doesn't help and the only way I'm able to access my website again is by closing out the window and opening up the website in a new one.

I originally thought that maybe the -webkit-transform: script, the display: block, or the display: none script in the CSS may be affecting the performance of my website on a mobile browser, but this doesn't seem to be the case. Could the Javascript be affecting my website? Is this an issue with Google Chrome itself?

Below is all the code that I'm using on my website. If anyone has any ideas about why my website isn't working well with the mobile version of Google Chrome I would very much appreciate sharing them with me.

Thank you.

<!DOCTYPE html>

<meta name="viewport" content="width=device-width, initial-scale=1.0;" charset="utf-8">

<title>MORIKOBOSHI・</title>

<input id="cp_toggle03" type="checkbox"/>

ホーム

ブログ

このサイトについて

参考文献

<form id="frmSearch" class="search2" method="get" action="default.html" style=" padding-right: 10px; padding-top: 20px; text-align: center; position: inline;">
<input class="search2" id="txtSearch" type="text" placeholder="Googleカスタム検索" name="serach_bar" size="31" maxlength="255" value="" style="top: 185px; width: 180px; height: 26px;">
<input class="search1" type="submit" name="submition" value="検索" style="padding-left: 5px; top: 153px; height: 25px; width: 34px; display: inline-flex; justify-content: center;">
<input class="search2" type="hidden" name="sitesearch" value="default.html">
</form>

◯◯◯◯

著者：◯◯◯◯

撮影日：◯◯◯◯年◯◯月◯◯日

    #

MORIKOBOSHI© | English


问:
How do I export different types of data obtained from Bibliometrix using R?
I am new to R. I am wondering how I can export different types of data under 'S' as a .csv file for each list in 'S'.

Thanks.

```<code>results <- biblioAnalysis(M,sep = ";")
S <- summary(object = results, k = 10, pause = FALSE)
</code>```

```<code> dput(head(M, n = 1))
structure(list(AU = "WANG Y;LI L;LI P", DE = "GENE;  GENOME-WIDE ASSOCIATION STUDY;  GESTATIONAL DIABETES MELLITUS;  SINGLE NUCLEOTIDE POLYMORPHISM;  TYPE 2 DIABETES MELLITUS",
    ID = NA_character_, C1 = "DEPARTMENT OF ENDOCRINOLOGY, SHENGJING HOSPITAL OF CHINA MEDICAL UNIVERSITY, LIAONING PROVINCE, SHENYANG, CHINA",
    CR = "MCINTYRE, H.D., CATALANO, P., ZHANG, C., DESOYE, G., MATHIESEN, E.R., DAMM, P., GESTATIONAL DIABETES MELLITUSJ (2019) NAT. REV. DIS. PRIMERS, 5 (1); YANG, Y., GUO, F., PENG, Y., CHEN, R., ZHOU, W., WANG, H., OUYANG, J., XU, Z., TRANSCRIPTOMIC PROFILING OF HUMAN PLACENTA IN GESTATIONAL DIABETES MELLITUS AT THE SINGLE-CELL LEVELJ (2021) FRONT. ENDOCRINOL., 12; AUVINEN, A.M., LUIRO, K., JOKELAINEN, J., TYPE 1 AND TYPE 2 DIABETES AFTER GESTATIONAL DIABETES: A 23 YEAR COHORT STUDYJ (2020) DIABETOLOGIA, 63 (10), PP. 2123-2128; DAMM, P., HOUSHMAND-OEREGAARD, A., KELSTRUP, L., LAUENBORG, J., MATHIESEN, E.R., CLAUSEN, T.D., GESTATIONAL DIABETES MELLITUS AND LONG-TERM CONSEQUENCES FOR MOTHER AND OFFSPRING: A VIEW FROM DENMARKJ (2016) DIABETOLOGIA, 59 (7), PP. 1396-1399; JOHNS, E.C., DENISON, F.C., NORMAN, J.E., REYNOLDS, R.M., GESTATIONAL DIABETES MELLITUS: MECHANISMS, TREATMENT, AND COMPLICATIONSJ (2018) TRENDS ENDOCRINOL. METAB., 29 (11), PP. 743-754; BAZ, B., RIVELINE, J.P., GAUTIER, J.F., ENDOCRINOLOGY OF PREGNANCY: GESTATIONAL DIABETES MELLITUS: DEFINITION, AETIOLOGICAL AND CLINICAL ASPECTSJ (2016) EUR. J. ENDOCRINOL., 174 (2), PP. R43-R51; BARROSO, I., MCCARTHY, M.I., THE GENETIC BASIS OF METABOLIC DISEASEJ (2019) CELL, 177 (1), PP. 146-161; KOLB, H., MARTIN, S., ENVIRONMENTAL/LIFESTYLE FACTORS IN THE PATHOGENESIS AND PREVENTION OF TYPE 2 DIABETESJ (2017) BMC MED., 15 (1), P. 131; MAHAJAN, A., TALIUN, D., THURNER, M., FINE-MAPPING TYPE 2 DIABETES LOCI TO SINGLE-VARIANT RESOLUTION USING HIGH-DENSITY IMPUTATION AND ISLET-SPECIFIC EPIGENOME MAPSJ (2018) NAT. GENET., 50 (11), PP. 1505-1513; SANNA, S., VAN ZUYDAM, N.R., MAHAJAN, A., CAUSAL RELATIONSHIPS AMONG THE GUT MICROBIOME, SHORT-CHAIN FATTY ACIDS AND METABOLIC DISEASESJ (2019) NAT. GENET., 51 (4), PP. 600-605; FRANCAITE-DAUGELIENE, M., LESAUSKAITE, V., TAMOSIUNAS, A., GENETIC VARIANTS OF TCF7L2 GENE AND ITS COHERENCE WITH METABOLIC PARAMETERS IN LITHUANIAN (KAUNAS DISTRICT) WOMEN POPULATION WITH PREVIOUSLY DIAGNOSED GESTATIONAL DIABETES MELLITUS COMPARED TO GENERAL POPULATIONJ (2021) DIABETES RES. CLIN. PRACT., 172; KASUGA, Y., MIYAKOSHI, K., TAJIMA, A., CLINICAL AND GENETIC CHARACTERISTICS OF ABNORMAL GLUCOSE TOLERANCE IN JAPANESE WOMEN IN THE FIRST YEAR AFTER GESTATIONAL DIABETES MELLITUSJ (2019) J DIABETES INVESTIG, 10 (3), PP. 817-826; PERVJAKOVA, N., MOEN, G.H., BORGES, M.C., MULTI-ANCESTRY GENOME-WIDE ASSOCIATION STUDY OF GESTATIONAL DIABETES MELLITUS HIGHLIGHTS GENETIC LINKS WITH TYPE 2 DIABETESJ (2022) HUM. MOL. GENET; DIAS, S., PHEIFFER, C., ABRAHAMS, Y., MOLECULAR BIOMARKERS FOR GESTATIONAL DIABETES MELLITUSJ (2018) INT. J. MOL. SCI., 19 (10); HUANG, Y., RESEARCH PROGRESS ON SINGLE NUCLEOTIDE POLYMORPHISM AND LINKAGE DISEQUILIBRIUM (2004) BASIC CLIN. MED; SCHIERDING, W., O'SULLIVAN, J.M., CONNECTING SNPS IN DIABETES: A SPATIAL ANALYSIS OF META-GWAS LOCIJ (2015) FRONT ENDOCRINOL (LAUSANNE), 6, P. 102; CHENG, M., HUANG, X., ZHANG, M., COMPUTATIONAL AND FUNCTIONAL ANALYSES OF T2D GWAS SNPS FOR TRANSCRIPTION FACTOR BINDINGJ (2020) BIOCHEM. BIOPHYS. RES. COMMUN., 523 (3), PP. 658-665; HUANG, Q., GENETIC STUDY OF COMPLEX DISEASES IN THE POST-GWAS ERAJ (2015) J GENET GENOMICS, 42 (3), PP. 87-98; UDLER, M.S., MCCARTHY, M.I., FLOREZ, J.C., GENETIC RISK SCORES FOR DIABETES DIAGNOSIS AND PRECISION MEDICINEJ (2019) ENDOCR. REV., 40 (6), PP. 1500-1520; XU, N., ZHANG, T.T., HAN, W.J., ASSOCIATION OF CDKAL1 RS10946398 GENE POLYMORPHISM WITH SUSCEPTIBILITY TO DIABETES MELLITUS TYPE 2: A META-ANALYSISJ (2021) J. DIABETES RES., 2021, P. 1254968; HAN, W.J., DENG, J.Y., JIN, H., ASSOCIATION OF KCNQ1RS2237892C⟶T GENE WITH TYPE 2 DIABETES MELLITUS: A META-ANALYSISJ (2021) J. DIABETES RES., 2021, P. 6606830; SARHANGI, N., SHARIFI, F., HASHEMIAN, L., PPARG (PRO12ALA) GENETIC VARIANT AND RISK OF T2DM: A SYSTEMATIC REVIEW AND META-ANALYSISJ (2020) SCI. REP., 10 (1), P. 12764; LIANG, Z., DONG, M., CHENG, Q., GESTATIONAL DIABETES MELLITUS SCREENING BASED ON THE GENE CHIP TECHNIQUEJ (2010) DIABETES RES. CLIN. PRACT., 89 (2), PP. 167-173; WANG, X., LI, W., MA, L., INVESTIGATION OF MIRNA-BINDING SITE VARIANTS AND RISK OF GESTATIONAL DIABETES MELLITUS IN CHINESE PREGNANT WOMENJ (2017) ACTA DIABETOL., 54 (3), PP. 309-316; LIAO, S., LIU, Y., TAN, Y., ASSOCIATION OF GENETIC VARIANTS OF MELATONIN RECEPTOR 1B WITH GESTATIONAL PLASMA GLUCOSE LEVEL AND RISK OF GLUCOSE INTOLERANCE IN PREGNANT CHINESE WOMENJ (2012) PLOS ONE, 7 (7), P. E40113; CEBALLOS-CHAVEZ, M., RIVERO, S., GARCIA-GUTIERREZ, P., CONTROL OF NEURONAL DIFFERENTIATION BY SUMOYLATION OF BRAF35, A SUBUNIT OF THE LSD1-COREST HISTONE DEMETHYLASE COMPLEXJ (2012) PROC. NATL. ACAD. SCI. USA, 109 (21), PP. 8085-8090; LORENZO, P.I., MARTIN-MONTALVO, A., COBO VUILLEUMIER, N., MOLECULAR MODELLING OF ISLET BETA-CELL ADAPTATION TO INFLAMMATION IN PREGNANCY AND GESTATIONAL DIABETES MELLITUSJ (2019) INT. J. MOL. SCI., 20 (24); MELLADO-GIL, J.M., FUENTE-MARTIN, E., LORENZO, P.I., THE TYPE 2 DIABETES-ASSOCIATED HMG20A GENE IS MANDATORY FOR ISLET BETA CELL FUNCTIONAL MATURITYJ (2018) CELL DEATH DIS., 9 (3), P. 279; SHABANA, S.S.U., HASNAIN, S., IDENTIFICATION OF GENETIC BASIS OF OBESITY AND MECHANISTIC LINK OF GENES AND LIPIDS IN PAKISTANI POPULATIONJ (2018) BIOSCI. REP., 38 (4); HUANG, T., WANG, L., BAI, M., INFLUENCE OF IGF2BP2, HMG20A, AND HNF1B GENETIC POLYMORPHISMS ON THE SUSCEPTIBILITY TO TYPE 2 DIABETES MELLITUS IN CHINESE HAN POPULATIONJ (2020) BIOSCI. REP., 40 (5); ARORA, G.P., AKERLUND, M., BRONS, C., PHENOTYPIC AND GENOTYPIC DIFFERENCES BETWEEN INDIAN AND SCANDINAVIAN WOMEN WITH GESTATIONAL DIABETES MELLITUSJ (2019) J. INTERN. MED., 286 (2), PP. 192-206; KANTHIMATHI, S., CHIDAMBARAM, M., BODHINI, D., ASSOCIATION OF RECENTLY IDENTIFIED TYPE 2 DIABETES GENE VARIANTS WITH GESTATIONAL DIABETES IN ASIAN INDIAN POPULATIONJ (2017) MOL. GENET. GENOMICS, 292 (3), PP. 585-591; WANG, H., LI, J., LENG, J., THE CDKAL1 RS7747752-BILE ACIDS INTERACTION INCREASED RISK OF GESTATIONAL DIABETES MELLITUS: A NESTED CASE-CONTROL STUDYJ (2022) FRONT. ENDOCRINOL. (LAUSANNE), 13; LASRAM, K., BEN HALIM, N., BENRAHMA, H., CONTRIBUTION OF CDKAL1 RS7756992 AND IGF2BP2 RS4402960 POLYMORPHISMS IN TYPE 2 DIABETES, DIABETIC COMPLICATIONS, OBESITY RISK AND HYPERTENSION IN THE TUNISIAN POPULATIONJ (2015) J. DIABETES, 7 (1), PP. 102-113; RYOO, H., WOO, J., KIM, Y., HETEROGENEITY OF GENETIC ASSOCIATIONS OF CDKAL1 AND HHEX WITH SUSCEPTIBILITY OF TYPE 2 DIABETES MELLITUS BY GENDERJ (2011) EUR. J. HUM. GENET., 19 (6), PP. 672-675; PENG, D., WANG, J., ZHANG, R., CDKAL1 RS7756992 IS ASSOCIATED WITH DIABETIC RETINOPATHY IN A CHINESE POPULATION WITH TYPE 2 DIABETESJ (2017) SCI. REP., 7 (1), P. 8812; ZHAO, J., LI, M., BRADFIELD, J.P., EXAMINATION OF TYPE 2 DIABETES LOCI IMPLICATES CDKAL1 AS A BIRTH WEIGHT GENEJ (2009) DIABETES, 58 (10), PP. 2414-2418; AMIN, U.S.M., PARVEZ, N., RAHMAN, T.A., CDKAL1 GENE RS7756992 A/G AND RS7754840 G/C POLYMORPHISMS ARE ASSOCIATED WITH GESTATIONAL DIABETES MELLITUS IN A SAMPLE OF BANGLADESHI POPULATION: IMPLICATION FOR FUTURE T2DM PROPHYLAXISJ (2022) DIABETOL. METAB. SYNDR., 14 (1), P. 18; KANTHIMATHI, S., CHIDAMBARAM, M., LIJU, S., IDENTIFICATION OF GENETIC VARIANTS OF GESTATIONAL DIABETES IN SOUTH INDIANSJ (2015) DIABETES TECHNOL. THER., 17 (7), PP. 462-467; JIANG, G., HU, C., TAM, C.H.T., GENETIC AND CLINICAL VARIABLES IDENTIFY PREDICTORS FOR CHRONIC KIDNEY DISEASE IN TYPE 2 DIABETESJ (2016) KIDNEY INT., 89 (2), PP. 411-420; SAINZ, J., RUDOLPH, A., HOFFMEISTER, M., EFFECT OF TYPE 2 DIABETES PREDISPOSING GENETIC VARIANTS ON COLORECTAL CANCER RISKJ (2012) J. CLIN. ENDOCRINOL. METAB., 97 (5), PP. E845-E851; ROSTA, K., AL-AISSA, Z., HADARITS, O., ASSOCIATION STUDY WITH 77 SNPS CONFIRMS THE ROBUST ROLE FOR THE RS10830963/G OF MTNR1B VARIANT AND IDENTIFIES TWO NOVEL ASSOCIATIONS IN GESTATIONAL DIABETES MELLITUS DEVELOPMENTJ (2017) PLOS ONE, 12 (1), P. E0169781; XIE, K., CHEN, T., ZHANG, Y., ASSOCIATION OF RS10830962 POLYMORPHISM WITH GESTATIONAL DIABETES MELLITUS RISK IN A CHINESE POPULATIONJ (2019) SCI. REP., 9 (1), P. 5357; WANG, H., YANG, W., LIU, J., SERUM CONCENTRATIONS OF SFAS AND CDKAL1 SINGLE-NUCLEOTIDE POLYMORPHISM RS7747752 ARE RELATED TO AN INCREASED RISK OF GESTATIONAL DIABETES MELLITUSJ (2021) AM. J. CLIN. NUTR., 114 (5), PP. 1698-1707; WANG, K., CHEN, Q., FENG, Y., SINGLE NUCLEOTIDE POLYMORPHISMS IN CDKAL1 GENE ARE ASSOCIATED WITH RISK OF GESTATIONAL DIABETES MELLITUS IN CHINESE POPULATIONJ (2019) J. DIABETES RES., 2019, P. 3618103; BAI, Y., TANG, L., LI, L., THE ROLES OF ADIPOQ RS266729 AND MTNR1B RS10830963 POLYMORPHISMS IN PATIENTS WITH GESTATIONAL DIABETES MELLITUS: A META-ANALYSISJ (2020) GENE, 730; DE LUIS, D.A., PRIMO, D., IZAOLA, O., ROLE OF THE VARIANT IN ADIPONECTIN GENE RS266729 ON WEIGHT LOSS AND CARDIOVASCULAR RISK FACTORS AFTER A HYPOCALORIC DIET WITH THE MEDITERRANEAN PATTERNJ (2019) NUTRITION, 60, PP. 1-5; DE LUIS, D.A., IZAOLA, O., PRIMO, D., RELATION OF A VARIANT IN ADIPONECTIN GENE (RS266729) WITH METABOLIC SYNDROME AND DIABETES MELLITUS TYPE 2 IN ADULT OBESE SUBJECTS (2020) EUR. REV. MED. PHARMACOL. SCI., 24 (20), PP. 10646-10652; CHENG, J., LI, Y., HE, Q., ESSENTIAL HYPERTENSION IN PATIENTS EXPOSED TO HIGH-ARSENIC EXPOSED AREAS IN WESTERN CHINA: GENETIC SUSCEPTIBILITY AND URINARY ARSENIC METABOLISM CHARACTERISTICSJ (2021) J. TRACE ELEM. MED BIOL., 67; ZHOU, M., NING, N., JIANG, Y., CORRELATION OF ADIPOQ GENE SINGLE NUCLEOTIDE POLYMORPHISMS WITH BONE STRENGTH INDEX IN MIDDLE-AGED AND THE ELDERLY OF GUANGXI MULAM ETHNIC GROUPJ (2021) INT. J. ENVIRON. RES. PUBLIC HEALTH, 18 (24); DIVELLA, R., DANIELE, A., MAZZOCCA, A., ADIPOQ RS266729 G/C GENE POLYMORPHISM AND PLASMATIC ADIPOCYTOKINES CONNECT METABOLIC SYNDROME TO COLORECTAL CANCERJ (2017) J. CANCER, 8 (6), PP. 1000-1008; LI, W., YU, Z., HOU, D., RELATIONSHIP BETWEEN ADIPONECTIN GENE POLYMORPHISMS AND LATE-ONSET ALZHEIMER'S DISEASEJ (2015) PLOS ONE, 10 (4), P. E0125186; WANG, Z.D.J., YUE, X., ZHONG, J., EFFECTS OF ADIPOQ POLYMORPHISMS ON INDIVIDUAL SUSCEPTIBILITY TO CORONARY ARTERY DISEASE: A META-ANALYSISJ (2019) ADIPOCYTE, 137-143; DIAS, S., ADAM, S., RHEEDER, P., NO ASSOCIATION BETWEEN ADIPOQ OR MTHFR POLYMORPHISMS AND GESTATIONAL DIABETES MELLITUS IN SOUTH AFRICAN WOMENJ (2021) DIABETES METAB. SYNDR. OBES., 14, PP. 791-800; PAWLIK, A., TELER, J., MACIEJEWSKA, A., ADIPONECTIN AND LEPTIN GENE POLYMORPHISMS IN WOMEN WITH GESTATIONAL DIABETES MELLITUSJ (2017) J. ASSIST. REPROD. GENET., 34 (4), PP. 511-516; HOU, H., GE, S., ZHAO, L., AN UPDATED SYSTEMATIC REVIEW AND META-ANALYSIS OF ASSOCIATION BETWEEN ADIPONECTIN GENE POLYMORPHISMS AND CORONARY ARTERY DISEASEJ (2017) OMICS, 21 (6), PP. 340-351; HAN, L.Y., WU, Q.H., JIAO, M.L., ASSOCIATIONS BETWEEN SINGLE-NUCLEOTIDE POLYMORPHISMS (+45T>G, +276G>T, -11377C>G, -11391G>A) OF ADIPONECTIN GENE AND TYPE 2 DIABETES MELLITUS: A SYSTEMATIC REVIEW AND META-ANALYSISJ (2011) DIABETOLOGIA, 54 (9), PP. 2303-2314; KANG, J., LIU, C.H., LEE, C.N., NOVEL INTERLEUKIN-10 GENE POLYMORPHISM IS LINKED TO GESTATIONAL DIABETES IN TAIWANESE POPULATIONJ (2019) FRONT. GENET., 10, P. 89; LI, X., LAI, L., SU, J., NOVEL ASSOCIATION BETWEEN A TRANSIENT RECEPTOR POTENTIAL CATION CHANNEL SUBFAMILY M MEMBER 5 EXPRESSION QUANTITATIVE TRAIT LOCUS RS35197079 AND DECREASED SUSCEPTIBILITY OF GESTATIONAL DIABETES MELLITUS IN A CHINESE POPULATIONJ (2021) J DIABETES INVESTIG, 12 (11), PP. 2062-2070; WANG, X., LI, W., MA, L., ASSOCIATION STUDY OF THE MIRNA-BINDING SITE POLYMORPHISMS OF CDKN2A/B GENES WITH GESTATIONAL DIABETES MELLITUS SUSCEPTIBILITYJ (2015) ACTA DIABETOL., 52 (5), PP. 951-95",
    JI = "CLIN. CHIM. ACTA", AB = "THE ASSOCIATION BETWEEN GESTATIONAL DIABETES MELLITUS (GDM) AND SINGLE NUCLEOTIDE POLYMORPHISMS (SNPS) HAS ATTRACTED GLOBAL RESEARCH ATTENTION. EXPLORING SNPS CAN HELP US FURTHER UNDERSTAND THE PATHOGENESIS OF GDM, PREDICT THE RISK OF GDM, AND GUIDE THE MANAGEMENT OF GDM PATIENTS. IN THIS REVIEW, WE SUMMARIZED THE STUDIES ON THE ASSOCIATION BETWEEN SNPS AND GDM, FOCUSING ON NOVEL SNPS PUBLISHED IN THE LAST 10 YEARS. THE SNPS IDENTIFIED TO BE ASSOCIATED WITH GDM INCLUDED HMG20A (RS7178572), CDKAL1 (RS7756992, RS7754840, AND RS7747752), ADIPOQ (RS266729 AND RS17300539), MTHFR (RS1801133), IL10 (RS3021094), CDKN2B (RS1063192), AND TRPM5 (RS35197079). HOWEVER, THE ROLE OF SNPS IN THE PREDICTION, DIAGNOSIS, TREATMENT, AND PROGNOSIS OF GDM, AS A POLYGENIC DISEASE, NEEDS TO BE FURTHER EXPLORED IN MULTIPLE ETHNIC POPULATIONS. © 2022 ELSEVIER B.V.",
    PA = NA_character_, AR = NA_character_, chemicals_cas = NA_character_,
    coden = "CCATA", RP = "LI, P.; DEPARTMENT OF ENDOCRINOLOGY, LIAONING PROVINCE, CHINA; EMAIL: LIPINGSJ@163.COM",
    DT = "REVIEW", DI = "10.1016/j.cca.2022.11.010", BN = NA_character_,
    SN = "00098981", SO = "CLINICA CHIMICA ACTA", LA = "ENGLISH",
    manufacturers = NA_character_, molecular_seqnumbers = NA_character_,
    TC = 0, PN = NA_character_, PP = "60-64", PU = "ELSEVIER B.V.",
    PM = "36375523", DB = "SCOPUS", sponsors = NA_character_,
    TI = "NOVEL SINGLE NUCLEOTIDE POLYMORPHISMS IN GESTATIONAL DIABETES MELLITUS",
    tradenames = NA_character_, url = "https://www.scopus.com/inward/record.uri?eid=2-s2.0-85142221343&doi=10.1016%2fj.cca.2022.11.010&partnerID=40&md5=1515fe2ea8a6e122bc74618b5c0f985b",
    VL = "538", PY = 2023, AU_UN = "SHENGJING HOSPITAL OF CHINA MEDICAL UNIVERSITY",
    AU1_UN = "NOTREPORTED;NOTREPORTED;NOTREPORTED", AU_UN_NR = NA,
    SR_FULL = "WANG Y, 2023, CLIN CHIM ACTA", SR = "WANG Y, 2023, CLIN CHIM ACTA"), row.names = "WANG Y, 2023, CLIN CHIM ACTA", class = c("bibliometrixDB",
"data.frame"))
</code>```

Body:
I am new to R. I am wondering how I can export different types of data under 'S' as a .csv file for each list in 'S'.

Thanks.

results <- biblioAnalysis(M,sep = ";")
S <- summary(object = results, k = 10, pause = FALSE)

 dput(head(M, n = 1))
structure(list(AU = "WANG Y;LI L;LI P", DE = "GENE;  GENOME-WIDE ASSOCIATION STUDY;  GESTATIONAL DIABETES MELLITUS;  SINGLE NUCLEOTIDE POLYMORPHISM;  TYPE 2 DIABETES MELLITUS",
    ID = NA_character_, C1 = "DEPARTMENT OF ENDOCRINOLOGY, SHENGJING HOSPITAL OF CHINA MEDICAL UNIVERSITY, LIAONING PROVINCE, SHENYANG, CHINA",
    CR = "MCINTYRE, H.D., CATALANO, P., ZHANG, C., DESOYE, G., MATHIESEN, E.R., DAMM, P., GESTATIONAL DIABETES MELLITUSJ (2019) NAT. REV. DIS. PRIMERS, 5 (1); YANG, Y., GUO, F., PENG, Y., CHEN, R., ZHOU, W., WANG, H., OUYANG, J., XU, Z., TRANSCRIPTOMIC PROFILING OF HUMAN PLACENTA IN GESTATIONAL DIABETES MELLITUS AT THE SINGLE-CELL LEVELJ (2021) FRONT. ENDOCRINOL., 12; AUVINEN, A.M., LUIRO, K., JOKELAINEN, J., TYPE 1 AND TYPE 2 DIABETES AFTER GESTATIONAL DIABETES: A 23 YEAR COHORT STUDYJ (2020) DIABETOLOGIA, 63 (10), PP. 2123-2128; DAMM, P., HOUSHMAND-OEREGAARD, A., KELSTRUP, L., LAUENBORG, J., MATHIESEN, E.R., CLAUSEN, T.D., GESTATIONAL DIABETES MELLITUS AND LONG-TERM CONSEQUENCES FOR MOTHER AND OFFSPRING: A VIEW FROM DENMARKJ (2016) DIABETOLOGIA, 59 (7), PP. 1396-1399; JOHNS, E.C., DENISON, F.C., NORMAN, J.E., REYNOLDS, R.M., GESTATIONAL DIABETES MELLITUS: MECHANISMS, TREATMENT, AND COMPLICATIONSJ (2018) TRENDS ENDOCRINOL. METAB., 29 (11), PP. 743-754; BAZ, B., RIVELINE, J.P., GAUTIER, J.F., ENDOCRINOLOGY OF PREGNANCY: GESTATIONAL DIABETES MELLITUS: DEFINITION, AETIOLOGICAL AND CLINICAL ASPECTSJ (2016) EUR. J. ENDOCRINOL., 174 (2), PP. R43-R51; BARROSO, I., MCCARTHY, M.I., THE GENETIC BASIS OF METABOLIC DISEASEJ (2019) CELL, 177 (1), PP. 146-161; KOLB, H., MARTIN, S., ENVIRONMENTAL/LIFESTYLE FACTORS IN THE PATHOGENESIS AND PREVENTION OF TYPE 2 DIABETESJ (2017) BMC MED., 15 (1), P. 131; MAHAJAN, A., TALIUN, D., THURNER, M., FINE-MAPPING TYPE 2 DIABETES LOCI TO SINGLE-VARIANT RESOLUTION USING HIGH-DENSITY IMPUTATION AND ISLET-SPECIFIC EPIGENOME MAPSJ (2018) NAT. GENET., 50 (11), PP. 1505-1513; SANNA, S., VAN ZUYDAM, N.R., MAHAJAN, A., CAUSAL RELATIONSHIPS AMONG THE GUT MICROBIOME, SHORT-CHAIN FATTY ACIDS AND METABOLIC DISEASESJ (2019) NAT. GENET., 51 (4), PP. 600-605; FRANCAITE-DAUGELIENE, M., LESAUSKAITE, V., TAMOSIUNAS, A., GENETIC VARIANTS OF TCF7L2 GENE AND ITS COHERENCE WITH METABOLIC PARAMETERS IN LITHUANIAN (KAUNAS DISTRICT) WOMEN POPULATION WITH PREVIOUSLY DIAGNOSED GESTATIONAL DIABETES MELLITUS COMPARED TO GENERAL POPULATIONJ (2021) DIABETES RES. CLIN. PRACT., 172; KASUGA, Y., MIYAKOSHI, K., TAJIMA, A., CLINICAL AND GENETIC CHARACTERISTICS OF ABNORMAL GLUCOSE TOLERANCE IN JAPANESE WOMEN IN THE FIRST YEAR AFTER GESTATIONAL DIABETES MELLITUSJ (2019) J DIABETES INVESTIG, 10 (3), PP. 817-826; PERVJAKOVA, N., MOEN, G.H., BORGES, M.C., MULTI-ANCESTRY GENOME-WIDE ASSOCIATION STUDY OF GESTATIONAL DIABETES MELLITUS HIGHLIGHTS GENETIC LINKS WITH TYPE 2 DIABETESJ (2022) HUM. MOL. GENET; DIAS, S., PHEIFFER, C., ABRAHAMS, Y., MOLECULAR BIOMARKERS FOR GESTATIONAL DIABETES MELLITUSJ (2018) INT. J. MOL. SCI., 19 (10); HUANG, Y., RESEARCH PROGRESS ON SINGLE NUCLEOTIDE POLYMORPHISM AND LINKAGE DISEQUILIBRIUM (2004) BASIC CLIN. MED; SCHIERDING, W., O'SULLIVAN, J.M., CONNECTING SNPS IN DIABETES: A SPATIAL ANALYSIS OF META-GWAS LOCIJ (2015) FRONT ENDOCRINOL (LAUSANNE), 6, P. 102; CHENG, M., HUANG, X., ZHANG, M., COMPUTATIONAL AND FUNCTIONAL ANALYSES OF T2D GWAS SNPS FOR TRANSCRIPTION FACTOR BINDINGJ (2020) BIOCHEM. BIOPHYS. RES. COMMUN., 523 (3), PP. 658-665; HUANG, Q., GENETIC STUDY OF COMPLEX DISEASES IN THE POST-GWAS ERAJ (2015) J GENET GENOMICS, 42 (3), PP. 87-98; UDLER, M.S., MCCARTHY, M.I., FLOREZ, J.C., GENETIC RISK SCORES FOR DIABETES DIAGNOSIS AND PRECISION MEDICINEJ (2019) ENDOCR. REV., 40 (6), PP. 1500-1520; XU, N., ZHANG, T.T., HAN, W.J., ASSOCIATION OF CDKAL1 RS10946398 GENE POLYMORPHISM WITH SUSCEPTIBILITY TO DIABETES MELLITUS TYPE 2: A META-ANALYSISJ (2021) J. DIABETES RES., 2021, P. 1254968; HAN, W.J., DENG, J.Y., JIN, H., ASSOCIATION OF KCNQ1RS2237892C⟶T GENE WITH TYPE 2 DIABETES MELLITUS: A META-ANALYSISJ (2021) J. DIABETES RES., 2021, P. 6606830; SARHANGI, N., SHARIFI, F., HASHEMIAN, L., PPARG (PRO12ALA) GENETIC VARIANT AND RISK OF T2DM: A SYSTEMATIC REVIEW AND META-ANALYSISJ (2020) SCI. REP., 10 (1), P. 12764; LIANG, Z., DONG, M., CHENG, Q., GESTATIONAL DIABETES MELLITUS SCREENING BASED ON THE GENE CHIP TECHNIQUEJ (2010) DIABETES RES. CLIN. PRACT., 89 (2), PP. 167-173; WANG, X., LI, W., MA, L., INVESTIGATION OF MIRNA-BINDING SITE VARIANTS AND RISK OF GESTATIONAL DIABETES MELLITUS IN CHINESE PREGNANT WOMENJ (2017) ACTA DIABETOL., 54 (3), PP. 309-316; LIAO, S., LIU, Y., TAN, Y., ASSOCIATION OF GENETIC VARIANTS OF MELATONIN RECEPTOR 1B WITH GESTATIONAL PLASMA GLUCOSE LEVEL AND RISK OF GLUCOSE INTOLERANCE IN PREGNANT CHINESE WOMENJ (2012) PLOS ONE, 7 (7), P. E40113; CEBALLOS-CHAVEZ, M., RIVERO, S., GARCIA-GUTIERREZ, P., CONTROL OF NEURONAL DIFFERENTIATION BY SUMOYLATION OF BRAF35, A SUBUNIT OF THE LSD1-COREST HISTONE DEMETHYLASE COMPLEXJ (2012) PROC. NATL. ACAD. SCI. USA, 109 (21), PP. 8085-8090; LORENZO, P.I., MARTIN-MONTALVO, A., COBO VUILLEUMIER, N., MOLECULAR MODELLING OF ISLET BETA-CELL ADAPTATION TO INFLAMMATION IN PREGNANCY AND GESTATIONAL DIABETES MELLITUSJ (2019) INT. J. MOL. SCI., 20 (24); MELLADO-GIL, J.M., FUENTE-MARTIN, E., LORENZO, P.I., THE TYPE 2 DIABETES-ASSOCIATED HMG20A GENE IS MANDATORY FOR ISLET BETA CELL FUNCTIONAL MATURITYJ (2018) CELL DEATH DIS., 9 (3), P. 279; SHABANA, S.S.U., HASNAIN, S., IDENTIFICATION OF GENETIC BASIS OF OBESITY AND MECHANISTIC LINK OF GENES AND LIPIDS IN PAKISTANI POPULATIONJ (2018) BIOSCI. REP., 38 (4); HUANG, T., WANG, L., BAI, M., INFLUENCE OF IGF2BP2, HMG20A, AND HNF1B GENETIC POLYMORPHISMS ON THE SUSCEPTIBILITY TO TYPE 2 DIABETES MELLITUS IN CHINESE HAN POPULATIONJ (2020) BIOSCI. REP., 40 (5); ARORA, G.P., AKERLUND, M., BRONS, C., PHENOTYPIC AND GENOTYPIC DIFFERENCES BETWEEN INDIAN AND SCANDINAVIAN WOMEN WITH GESTATIONAL DIABETES MELLITUSJ (2019) J. INTERN. MED., 286 (2), PP. 192-206; KANTHIMATHI, S., CHIDAMBARAM, M., BODHINI, D., ASSOCIATION OF RECENTLY IDENTIFIED TYPE 2 DIABETES GENE VARIANTS WITH GESTATIONAL DIABETES IN ASIAN INDIAN POPULATIONJ (2017) MOL. GENET. GENOMICS, 292 (3), PP. 585-591; WANG, H., LI, J., LENG, J., THE CDKAL1 RS7747752-BILE ACIDS INTERACTION INCREASED RISK OF GESTATIONAL DIABETES MELLITUS: A NESTED CASE-CONTROL STUDYJ (2022) FRONT. ENDOCRINOL. (LAUSANNE), 13; LASRAM, K., BEN HALIM, N., BENRAHMA, H., CONTRIBUTION OF CDKAL1 RS7756992 AND IGF2BP2 RS4402960 POLYMORPHISMS IN TYPE 2 DIABETES, DIABETIC COMPLICATIONS, OBESITY RISK AND HYPERTENSION IN THE TUNISIAN POPULATIONJ (2015) J. DIABETES, 7 (1), PP. 102-113; RYOO, H., WOO, J., KIM, Y., HETEROGENEITY OF GENETIC ASSOCIATIONS OF CDKAL1 AND HHEX WITH SUSCEPTIBILITY OF TYPE 2 DIABETES MELLITUS BY GENDERJ (2011) EUR. J. HUM. GENET., 19 (6), PP. 672-675; PENG, D., WANG, J., ZHANG, R., CDKAL1 RS7756992 IS ASSOCIATED WITH DIABETIC RETINOPATHY IN A CHINESE POPULATION WITH TYPE 2 DIABETESJ (2017) SCI. REP., 7 (1), P. 8812; ZHAO, J., LI, M., BRADFIELD, J.P., EXAMINATION OF TYPE 2 DIABETES LOCI IMPLICATES CDKAL1 AS A BIRTH WEIGHT GENEJ (2009) DIABETES, 58 (10), PP. 2414-2418; AMIN, U.S.M., PARVEZ, N., RAHMAN, T.A., CDKAL1 GENE RS7756992 A/G AND RS7754840 G/C POLYMORPHISMS ARE ASSOCIATED WITH GESTATIONAL DIABETES MELLITUS IN A SAMPLE OF BANGLADESHI POPULATION: IMPLICATION FOR FUTURE T2DM PROPHYLAXISJ (2022) DIABETOL. METAB. SYNDR., 14 (1), P. 18; KANTHIMATHI, S., CHIDAMBARAM, M., LIJU, S., IDENTIFICATION OF GENETIC VARIANTS OF GESTATIONAL DIABETES IN SOUTH INDIANSJ (2015) DIABETES TECHNOL. THER., 17 (7), PP. 462-467; JIANG, G., HU, C., TAM, C.H.T., GENETIC AND CLINICAL VARIABLES IDENTIFY PREDICTORS FOR CHRONIC KIDNEY DISEASE IN TYPE 2 DIABETESJ (2016) KIDNEY INT., 89 (2), PP. 411-420; SAINZ, J., RUDOLPH, A., HOFFMEISTER, M., EFFECT OF TYPE 2 DIABETES PREDISPOSING GENETIC VARIANTS ON COLORECTAL CANCER RISKJ (2012) J. CLIN. ENDOCRINOL. METAB., 97 (5), PP. E845-E851; ROSTA, K., AL-AISSA, Z., HADARITS, O., ASSOCIATION STUDY WITH 77 SNPS CONFIRMS THE ROBUST ROLE FOR THE RS10830963/G OF MTNR1B VARIANT AND IDENTIFIES TWO NOVEL ASSOCIATIONS IN GESTATIONAL DIABETES MELLITUS DEVELOPMENTJ (2017) PLOS ONE, 12 (1), P. E0169781; XIE, K., CHEN, T., ZHANG, Y., ASSOCIATION OF RS10830962 POLYMORPHISM WITH GESTATIONAL DIABETES MELLITUS RISK IN A CHINESE POPULATIONJ (2019) SCI. REP., 9 (1), P. 5357; WANG, H., YANG, W., LIU, J., SERUM CONCENTRATIONS OF SFAS AND CDKAL1 SINGLE-NUCLEOTIDE POLYMORPHISM RS7747752 ARE RELATED TO AN INCREASED RISK OF GESTATIONAL DIABETES MELLITUSJ (2021) AM. J. CLIN. NUTR., 114 (5), PP. 1698-1707; WANG, K., CHEN, Q., FENG, Y., SINGLE NUCLEOTIDE POLYMORPHISMS IN CDKAL1 GENE ARE ASSOCIATED WITH RISK OF GESTATIONAL DIABETES MELLITUS IN CHINESE POPULATIONJ (2019) J. DIABETES RES., 2019, P. 3618103; BAI, Y., TANG, L., LI, L., THE ROLES OF ADIPOQ RS266729 AND MTNR1B RS10830963 POLYMORPHISMS IN PATIENTS WITH GESTATIONAL DIABETES MELLITUS: A META-ANALYSISJ (2020) GENE, 730; DE LUIS, D.A., PRIMO, D., IZAOLA, O., ROLE OF THE VARIANT IN ADIPONECTIN GENE RS266729 ON WEIGHT LOSS AND CARDIOVASCULAR RISK FACTORS AFTER A HYPOCALORIC DIET WITH THE MEDITERRANEAN PATTERNJ (2019) NUTRITION, 60, PP. 1-5; DE LUIS, D.A., IZAOLA, O., PRIMO, D., RELATION OF A VARIANT IN ADIPONECTIN GENE (RS266729) WITH METABOLIC SYNDROME AND DIABETES MELLITUS TYPE 2 IN ADULT OBESE SUBJECTS (2020) EUR. REV. MED. PHARMACOL. SCI., 24 (20), PP. 10646-10652; CHENG, J., LI, Y., HE, Q., ESSENTIAL HYPERTENSION IN PATIENTS EXPOSED TO HIGH-ARSENIC EXPOSED AREAS IN WESTERN CHINA: GENETIC SUSCEPTIBILITY AND URINARY ARSENIC METABOLISM CHARACTERISTICSJ (2021) J. TRACE ELEM. MED BIOL., 67; ZHOU, M., NING, N., JIANG, Y., CORRELATION OF ADIPOQ GENE SINGLE NUCLEOTIDE POLYMORPHISMS WITH BONE STRENGTH INDEX IN MIDDLE-AGED AND THE ELDERLY OF GUANGXI MULAM ETHNIC GROUPJ (2021) INT. J. ENVIRON. RES. PUBLIC HEALTH, 18 (24); DIVELLA, R., DANIELE, A., MAZZOCCA, A., ADIPOQ RS266729 G/C GENE POLYMORPHISM AND PLASMATIC ADIPOCYTOKINES CONNECT METABOLIC SYNDROME TO COLORECTAL CANCERJ (2017) J. CANCER, 8 (6), PP. 1000-1008; LI, W., YU, Z., HOU, D., RELATIONSHIP BETWEEN ADIPONECTIN GENE POLYMORPHISMS AND LATE-ONSET ALZHEIMER'S DISEASEJ (2015) PLOS ONE, 10 (4), P. E0125186; WANG, Z.D.J., YUE, X., ZHONG, J., EFFECTS OF ADIPOQ POLYMORPHISMS ON INDIVIDUAL SUSCEPTIBILITY TO CORONARY ARTERY DISEASE: A META-ANALYSISJ (2019) ADIPOCYTE, 137-143; DIAS, S., ADAM, S., RHEEDER, P., NO ASSOCIATION BETWEEN ADIPOQ OR MTHFR POLYMORPHISMS AND GESTATIONAL DIABETES MELLITUS IN SOUTH AFRICAN WOMENJ (2021) DIABETES METAB. SYNDR. OBES., 14, PP. 791-800; PAWLIK, A., TELER, J., MACIEJEWSKA, A., ADIPONECTIN AND LEPTIN GENE POLYMORPHISMS IN WOMEN WITH GESTATIONAL DIABETES MELLITUSJ (2017) J. ASSIST. REPROD. GENET., 34 (4), PP. 511-516; HOU, H., GE, S., ZHAO, L., AN UPDATED SYSTEMATIC REVIEW AND META-ANALYSIS OF ASSOCIATION BETWEEN ADIPONECTIN GENE POLYMORPHISMS AND CORONARY ARTERY DISEASEJ (2017) OMICS, 21 (6), PP. 340-351; HAN, L.Y., WU, Q.H., JIAO, M.L., ASSOCIATIONS BETWEEN SINGLE-NUCLEOTIDE POLYMORPHISMS (+45T>G, +276G>T, -11377C>G, -11391G>A) OF ADIPONECTIN GENE AND TYPE 2 DIABETES MELLITUS: A SYSTEMATIC REVIEW AND META-ANALYSISJ (2011) DIABETOLOGIA, 54 (9), PP. 2303-2314; KANG, J., LIU, C.H., LEE, C.N., NOVEL INTERLEUKIN-10 GENE POLYMORPHISM IS LINKED TO GESTATIONAL DIABETES IN TAIWANESE POPULATIONJ (2019) FRONT. GENET., 10, P. 89; LI, X., LAI, L., SU, J., NOVEL ASSOCIATION BETWEEN A TRANSIENT RECEPTOR POTENTIAL CATION CHANNEL SUBFAMILY M MEMBER 5 EXPRESSION QUANTITATIVE TRAIT LOCUS RS35197079 AND DECREASED SUSCEPTIBILITY OF GESTATIONAL DIABETES MELLITUS IN A CHINESE POPULATIONJ (2021) J DIABETES INVESTIG, 12 (11), PP. 2062-2070; WANG, X., LI, W., MA, L., ASSOCIATION STUDY OF THE MIRNA-BINDING SITE POLYMORPHISMS OF CDKN2A/B GENES WITH GESTATIONAL DIABETES MELLITUS SUSCEPTIBILITYJ (2015) ACTA DIABETOL., 52 (5), PP. 951-95",
    JI = "CLIN. CHIM. ACTA", AB = "THE ASSOCIATION BETWEEN GESTATIONAL DIABETES MELLITUS (GDM) AND SINGLE NUCLEOTIDE POLYMORPHISMS (SNPS) HAS ATTRACTED GLOBAL RESEARCH ATTENTION. EXPLORING SNPS CAN HELP US FURTHER UNDERSTAND THE PATHOGENESIS OF GDM, PREDICT THE RISK OF GDM, AND GUIDE THE MANAGEMENT OF GDM PATIENTS. IN THIS REVIEW, WE SUMMARIZED THE STUDIES ON THE ASSOCIATION BETWEEN SNPS AND GDM, FOCUSING ON NOVEL SNPS PUBLISHED IN THE LAST 10 YEARS. THE SNPS IDENTIFIED TO BE ASSOCIATED WITH GDM INCLUDED HMG20A (RS7178572), CDKAL1 (RS7756992, RS7754840, AND RS7747752), ADIPOQ (RS266729 AND RS17300539), MTHFR (RS1801133), IL10 (RS3021094), CDKN2B (RS1063192), AND TRPM5 (RS35197079). HOWEVER, THE ROLE OF SNPS IN THE PREDICTION, DIAGNOSIS, TREATMENT, AND PROGNOSIS OF GDM, AS A POLYGENIC DISEASE, NEEDS TO BE FURTHER EXPLORED IN MULTIPLE ETHNIC POPULATIONS. © 2022 ELSEVIER B.V.",
    PA = NA_character_, AR = NA_character_, chemicals_cas = NA_character_,
    coden = "CCATA", RP = "LI, P.; DEPARTMENT OF ENDOCRINOLOGY, LIAONING PROVINCE, CHINA; EMAIL: LIPINGSJ@163.COM",
    DT = "REVIEW", DI = "10.1016/j.cca.2022.11.010", BN = NA_character_,
    SN = "00098981", SO = "CLINICA CHIMICA ACTA", LA = "ENGLISH",
    manufacturers = NA_character_, molecular_seqnumbers = NA_character_,
    TC = 0, PN = NA_character_, PP = "60-64", PU = "ELSEVIER B.V.",
    PM = "36375523", DB = "SCOPUS", sponsors = NA_character_,
    TI = "NOVEL SINGLE NUCLEOTIDE POLYMORPHISMS IN GESTATIONAL DIABETES MELLITUS",
    tradenames = NA_character_, url = "https://www.scopus.com/inward/record.uri?eid=2-s2.0-85142221343&doi=10.1016%2fj.cca.2022.11.010&partnerID=40&md5=1515fe2ea8a6e122bc74618b5c0f985b",
    VL = "538", PY = 2023, AU_UN = "SHENGJING HOSPITAL OF CHINA MEDICAL UNIVERSITY",
    AU1_UN = "NOTREPORTED;NOTREPORTED;NOTREPORTED", AU_UN_NR = NA,
    SR_FULL = "WANG Y, 2023, CLIN CHIM ACTA", SR = "WANG Y, 2023, CLIN CHIM ACTA"), row.names = "WANG Y, 2023, CLIN CHIM ACTA", class = c("bibliometrixDB",
"data.frame"))


问:
sqoop export hive->oracle error(string/varchar column to clob column)
```<code>    [Hive side]
    create table TEST.HIVE_TEST (
    CONTENT string)
    stored as textfile;

    [oracle side]
    create table TEST.ORACLE_TEST (
    CONTENT clob);

    [sqoop export]
    /usr/bin/sqoop export \
    --connect "connection string"
    --username "ex" password "ex" \
    --table ORACLE_TEST \
    --columns CONTENT \
    --hcatalog-table HIVE_TEST --hcatalog-database TEST \
    --map-column-java CONTENT=String
</code>```

result of mapreduce is successed but when i see the yarn application log
i find
ERROR [main] org.apache.sqoop.mapreduce.hcat.SqoopHCatExportHelper : cannot convert hcatalog object of type string to java object type org.apache.sqoop.lib.clobref

and i see null in oracle
what is the solution can anyone help?

sqoop version is Sqoop-1.4.7-cdh6.3.4

i hope anyone knows how to export data from string to clob(oracle) using sqoop

Body:
    [Hive side]
    create table TEST.HIVE_TEST (
    CONTENT string)
    stored as textfile;

    [oracle side]
    create table TEST.ORACLE_TEST (
    CONTENT clob);

    [sqoop export]
    /usr/bin/sqoop export \
    --connect "connection string"
    --username "ex" password "ex" \
    --table ORACLE_TEST \
    --columns CONTENT \
    --hcatalog-table HIVE_TEST --hcatalog-database TEST \
    --map-column-java CONTENT=String

result of mapreduce is successed but when i see the yarn application log
i find
ERROR [main] org.apache.sqoop.mapreduce.hcat.SqoopHCatExportHelper : cannot convert hcatalog object of type string to java object type org.apache.sqoop.lib.clobref

and i see null in oracle
what is the solution can anyone help?

sqoop version is Sqoop-1.4.7-cdh6.3.4

i hope anyone knows how to export data from string to clob(oracle) using sqoop


问:
IntelliJ does not compile source files, unless I put "Build Project" in Before Launch steps
I have a maven project for Cucumber in Java, where I am mixing Java+Kotlin. The maven build works fine and compiles files as I change them. But when I run a test (*.feature file) from IntelliJ, the files are not compiled.

As per the default 'Run Configuration', the step to run 'Before Launch' of test is 'Build'. If I change the configuration to run 'Build Project' instead, the files are getting compiled. But it should work even with default 'Build' step. It won't be feasible to ask the whole team to change their default settings only to use Kotlin in a working Java project.

I am using Kotlin v1.7.21. I tried deleting all the .idea/.., *.iml files and reimporting the project multiple times without any luck.

Github project to reproduce

I have tried below Q&A, but none of them worked

Changing the order of maven plugins execution

Intellij Idea won't compile kotlin but maven does