Create a NetLogic that populates DataStore with random data

This script generates random data and populates the Store1 database tables with it.
Prerequisites
Set the default external code editor. See Set the default code editor.
  1. In
    Project view
    , right-click the
    Store1
    folder and select
    New
    Runtime NetLogic
    .
  2. Hover-over the NetLogic, select
    Edit
    , and enter
    GenerateRandomData
    .
  3. Double-click the NetLogic.
    The external code editor opens.
  4. In the code editor, replace the existing code with the following code:
    using System; using FTOptix.Core; using Store = FTOptix.Store; public class GenerateRandomData: FTOptix.NetLogic.BaseNetLogic { public override void Start() { // Insert code to be executed when the user-defined logic is started } public override void Stop() { // Insert code to be executed when the user-defined logic is stopped } [FTOptix.NetLogic.ExportMethod] public void InsertRandomValues() { // Get the current project folder. var project = FTOptix.HMIProject.Project.Current; // Save the names of the columns of the table to an array string[] columns = { "Column1", "Column2", "Column3", "Column4" }; // Create and populate a matrix with values to insert into the odbc table var rawValues = new object[1000, 4]; Random randomNumber = new Random(); for (UInt16 i = 0; i < 1000; ++i) { // Column1 rawValues[i, 0] = i; // Column2 rawValues[i, 1] = randomNumber.Next(0, 5000); // Column3 rawValues[i, 2] = randomNumber.NextDouble() * 5000; // Column4 rawValues[i, 3] = Guid.NewGuid().ToString(); } var myStore = LogicObject.Owner as Store.Store; // Get Table1 from myStore var table1 = myStore.Tables.Get<Store.Table>("Table1"); // Insert values into table1 table1.Insert(columns, rawValues); } }
  5. Save the code.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.