dbscripts | Some scripts to dump / convert between CSV , MySQL , SQLite | SQL Database library

$node=$xml.SelectNodes("configuration/userSettings/DatabaseUpdate.Properties.Settings/setting[@name='ScriptPath']")

This doesn't return a single XML node as you seem to expect based on naming of the variable. Instead, it returns an instance of XPathNodeList, whose base class is XmlNodeList.

You can use its Item() method to access individual XML nodes of the result by index:

There are a few issues with the current code but since the main question appears to be the wrong value assigned to the (bash) variable FOUND, I'll focus on just this issue ...

The main issue is the testing for the search pattern stored in the awk variable ITEM; one fix:

Thanks @compo ....

I wouldn't expect two different Zip algorithms/libraries to yield the same output. For one, in the programmatic way, the file metadata (name, modification date, attributes) are not set, while the command line version will include all that information for unzipping purposes.

Plus libraries update at different cadence than standalones, and you might not have the fixes synchronized to reliably match the outputs.

You are building your project here with the 4.7.2 framework, but in the yml you are referencing the .Net Core Framework. Could this be the problem?

You are creating 4 nearly identical resources all named execute[Create_scripts] and when the notification fires from the first cookbook_file resource being updated it finds the last one of them to be notified and runs against test4 (no matter which cookbook_file resource updates).

The fix is to use string interpolation to change the name of the execute resources to be unique and to notify based on that unique name:

Check these 2 things:

The init scripts are triggered only on the first deploy. On the subsequent docker-compose ups you probably see as well on the logs the following message:

1. As I have not used MultiTenantConnectionProvider so not sure at what point the datasource is chosen by the framework.

2. But I have a great suspicion it is done by the interceptor auto created by @Transactional, and the framework never reads the TenantContext inside the method. I.e one datasource for one transactional method. So may be worth identifying if my suspicion is true.

   • You can put a breakpoint at the following :

The CARBON_DB contains product-specific data. And by default that stores in the embedded h2 database. There is no requirement to point that DB to the PostgreSQL database. Hence you need to worry only about these databases SHARED_DB, USERSTORE_DB, IDENTITY_DB, CONSENT_MGT_DB and BPS_DB.

As per your next question, You can find the DB scripts related to USER_DB(USERSTORE_DB) in /dbscripts/postgresql.sql file. This file has tables starting with the name UM_. These tables are the user management tables. You can use those table sql scripts to create tables in USERSTORE_DB.

Refer the following doc for more information

[1]https://is.docs.wso2.com/en/5.10.0/administer/user-management-related-tables/