Forum Discussion

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago

Slow PostgreSQL Update Snap

I have a PostgreSQL Update snap at the end of a pipeline. It’s job is to update a column in a row if nothing in an inbound row (matching that data) has been modified. This means that most of the time...
sdoscher's avatar
sdoscher
New Contributor III
4 years ago
Copy Link

Hmmm…that did not work for me. I talked to the SL admin and they said we are on
SQL Server snap pack main11181. That is not the latest version, would that have anything to do with it? What version are you on?

marjan_karafilo's avatar
marjan_karafilo
Contributor
4 years ago
Copy Link

Hi @sdoscher ,

I’m using version main12833. I’ve tried with version main11181 and I got this output:

What is your output?

Maybe the Snap Pack version has to do something with it, change it to the latest main12833 and try again.

BR,
Marjan

  • tstack's avatar
    tstack
    Former Employee
    7 years ago
    Copy Link

    You should be able to reference the other library through the lib variable. Is that not working?

    For example, if you this as the library helper.expr:

    {
    chefify: x => x + ' bork! bork! bork!'
}

    You should be able to reference it from another library, like so:

    {
    msg: () => lib.helper.chefify('Hello, World!')
}

    Note that if the references are not in functions, but directly in the top-level expression, you’ll need to ensure the libraries are listed in the right order in the pipeline properties.

    • ayush_vipul's avatar
      ayush_vipul
      New Contributor III
      7 years ago
      Copy Link

      I found a better way to achieve what i was look for.

      But thanks for highlighting this.@tstack

    • ayush_vipul's avatar
      ayush_vipul
      New Contributor III
      7 years ago
      Copy Link

      I have a use case where a child pipeline has multiple expr files.

      I want to pass a value to the child pipeline using which my chiled pipeline would choose one of the expression library.
      is there a way to do it ?

      • tstack's avatar
        tstack
        Former Employee
        7 years ago
        Copy Link

        In the child pipeline properties, add a parameter that you’ll use to specify the library to load. Then, in the “Expression Libraries” section, add a path that uses the parameter you just created. You’ll probably also want to set the name of the imported library using the “As” column. In the screenshot below, the parameter is config and defaults to the library file dev.expr and the library can be referenced via lib.conf in expressions:

        In the parent pipeline, you’ll pass the config parameter with the library paths that you want. In the screenshot below, there are two documents entering the PipeExec with “dev.expr” and “prod.expr” as the paths. So, the child will execute first with the “dev” library and then with the “prod” library.

    • ayush_vipul's avatar
      ayush_vipul
      New Contributor III
      7 years ago
      Copy Link

      Is there a way to declare methods with global scope in expression library.
      Is nesting multiple libraries together a good preactice ?

      • tstack's avatar
        tstack
        Former Employee
        7 years ago
        Copy Link

        Do you mean without the lib.libname prefix? No, libraries are always imported under the lib object.

        I’m not sure what you mean by this, can you give an example?