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]>
Date: Tuesday, April 17, 2018 at 4:34 PM
To: "SMOKOWSKI, STEVEN" <[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?

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]>; 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?

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

Reply via email to