Thanks Brian and Steve. Our base goal is testing HPA/OOF functionality that was added during this cycle to SO, however we’d like to do it with a blackbox CSIT test for vCPE. We are trying to spin up vCPE usecase and isolate SO from other parts of ONAP. Then preload CSARs for vCPE, create a service instance and then mock interactions with AAI, OOF, Multicloud, SDNC etc. and verify expected outputs and SO logs.
It sounds like we can use this sql example as a base for CSAR preload and add networks, allotteds etc: https://github.com/onap/so/blob/fffbc99f5d7ce51601204076f77882cb298f4275/packages/root-pack-extras/config-resources/mariadb/db-sql-scripts/bulkload-files/demo-vfw/create_mso_db-demo-vfw.sql<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_onap_so_blob_fffbc99f5d7ce51601204076f77882cb298f4275_packages_root-2Dpack-2Dextras_config-2Dresources_mariadb_db-2Dsql-2Dscripts_bulkload-2Dfiles_demo-2Dvfw_create-5Fmso-5Fdb-2Ddemo-2Dvfw.sql&d=DwMGaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=shs6nPzThSiGJml9VXN0Eg&m=kySgFBRox7nU1EJ-eikq8zbOjHAaEjW2v19BwZdCSts&s=VUr0A0YqHPOKGBXgU27yM5xEmb1RT-WbA9DCsCsklKw&e=> Am I correct in thinking that asdc_interface.robot (https://github.com/onap/oom/blob/1ce83234f3909ed16c2987803ffa9f7caf3f632c/kubernetes/config/docker/init/src/config/robot/robot/resources/asdc_interface.robot ) is actually distributing the CSARs and that this is likely to need some components of SDC? That what it looks like from reading the file. If so this might make the sql direct load a better option for our purposes. Distributing the CSARs would test SO interface to SDC however. Cheers, Marcus Williams IRC @ mgkwill Network Software Engineer Intel Corp. – Network Platforms Group From: SMOKOWSKI, STEVEN [mailto:[email protected]] Sent: Tuesday, April 17, 2018 1:38 PM To: Williams, Marcus <[email protected]>; onap-discuss <[email protected]>; DAUGHERTY, ROBERT E <[email protected]>; Seshu m <[email protected]> Subject: Re: [onap-discuss] [so] Script to Simulate loading of CSAR model artifacts? This is the script it is only creating a vnf and vf-module. It depends on what you wish to fake out here, depending on your use case. You may need to insert networks, allotteds etc. It also appears to be missing the customization tables, csar table etc. What use case are you trying to test? Thanks -Steve From: "Williams, Marcus" <[email protected]<mailto:[email protected]>> Date: Tuesday, April 17, 2018 at 4:34 PM To: "SMOKOWSKI, STEVEN" <[email protected]<mailto:[email protected]>>, onap-discuss <[email protected]<mailto:[email protected]>>, "DAUGHERTY, ROBERT E" <[email protected]<mailto:[email protected]>>, Seshu m <[email protected]<mailto:[email protected]>> Subject: RE: [onap-discuss] [so] Script to Simulate loading of CSAR model artifacts? Thanks for the info Steve. The test harness that loads CSAR via REST sounds like a good upgrade for Casablanca. If the robot test currently distributes a CSAR we can probably copy those steps and use updated CSARs. I’ll take a look myself but do you know where this happen in the robot test? I don’t think I saw it while looking through current robot tests for SO. Is this an example of the sql inserts for faux CSAR load https://github.com/onap/so/blob/fffbc99f5d7ce51601204076f77882cb298f4275/packages/root-pack-extras/config-resources/mariadb/db-sql-scripts/bulkload-files/demo-vfw/create_mso_db-demo-vfw.sql<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_onap_so_blob_fffbc99f5d7ce51601204076f77882cb298f4275_packages_root-2Dpack-2Dextras_config-2Dresources_mariadb_db-2Dsql-2Dscripts_bulkload-2Dfiles_demo-2Dvfw_create-5Fmso-5Fdb-2Ddemo-2Dvfw.sql&d=DwMGaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=shs6nPzThSiGJml9VXN0Eg&m=kySgFBRox7nU1EJ-eikq8zbOjHAaEjW2v19BwZdCSts&s=VUr0A0YqHPOKGBXgU27yM5xEmb1RT-WbA9DCsCsklKw&e=> ? Cheers, Marcus Williams IRC @ mgkwill Network Software Engineer Intel Corp. – Network Platforms Group From: SMOKOWSKI, STEVEN [mailto:[email protected]] Sent: Tuesday, April 17, 2018 1:25 PM To: Williams, Marcus <[email protected]<mailto:[email protected]>>; onap-discuss <[email protected]<mailto:[email protected]>>; DAUGHERTY, ROBERT E <[email protected]<mailto:[email protected]>>; Seshu m <[email protected]<mailto:[email protected]>> Subject: Re: [onap-discuss] [so] Script to Simulate loading of CSAR model artifacts? For Casablanca we have a test harness that allows you to load csar via rest, otherwise you just write sql inserts to catalog db. You can probably just take dump of integration environment, and build it off that. Or run the robot test, which distributes a csar, then dump the data. Thanks -Steve From: <[email protected]<mailto:[email protected]>> on behalf of "Williams, Marcus" <[email protected]<mailto:[email protected]>> Date: Tuesday, April 17, 2018 at 4:22 PM To: onap-discuss <[email protected]<mailto:[email protected]>>, "DAUGHERTY, ROBERT E" <[email protected]<mailto:[email protected]>>, Seshu m <[email protected]<mailto:[email protected]>> Subject: [onap-discuss] [so] Script to Simulate loading of CSAR model artifacts? https://github.com/onap/so/blob/fffbc99f5d7ce51601204076f77882cb298f4275/readme.md#to-simulate-loading-of-artifacts--models-bypass-asdci<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_onap_so_blob_fffbc99f5d7ce51601204076f77882cb298f4275_readme.md-23to-2Dsimulate-2Dloading-2Dof-2Dartifacts-2D-2Dmodels-2Dbypass-2Dasdci&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=shs6nPzThSiGJml9VXN0Eg&m=JQNGG4B2oZ54CNj_l4gHZkNTQ9xBB--h6Erm_LnhWds&s=YqEO4EJ376VoqKVxNDog8FWBIa36w8X6j2L7tYl9XBc&e=> To “simulate Loading of Artifacts & models (bypass ASDC)”, “run the 'preload SQL' script” We are creating a blackbox CSIT and simulating SO interaction with other ONAP components to verify interactions from SO perspective. Does anyone have access to an example ‘preload SQL’ script that “simulates loading of Artifacts & models (bypassing ASDC)”? Cheers, Marcus Williams IRC @ mgkwill Network Software Engineer Intel Corp. – Network Platforms Group
_______________________________________________ onap-discuss mailing list [email protected] https://lists.onap.org/mailman/listinfo/onap-discuss
