Skip to main content

Using Databases & Scripting in Projects

Course Overview​

Take your existing SQL and Python knowledge and use it in Ignition. In this class students will create project resources built around existing database data. Design bi-directional data displays, process JSON objects, and use complex Perspective components while exploring error handling. Students will work with multiple data sets to focus on understanding the data and creating useful Ignition resources based on it. By the end of this class, students will be able to enhance existing displays, design projects to modify SQL databases while maintaining data integrity, and plan scalable scripting/SQL strategies.

Length: 4 days

Who Is This Class For? What Are the Class Expectations?​

This class is for those that can read and write basic SQL queries or basic programs in Python or other object-oriented programming languages and want to integrate these skills directly into their Ignition Project design.

Important

This is a Level 2 class, prior experience with Ignition is required and Core Certification is recommended.

Suggested Class Pre-Requisites:​

  • Working knowledge of SQL and Python languages, or completing the Level 1 DB&S class.
  • Completed Inductive University.

Topics Covered​

Review of SQL and Python​

  • SQL Refresher
  • Python Refresher

JSON Objects​

  • Transforming Query Results
  • Creating JSON Objects using Script Transforms

Dynamic Data Displays: Table Component​

  • Updating Database from User Input
  • Enhancing Displays Using Component Events

Dynamic View Embedding: Accordion Component​

  • Embedding Sets of Dynamic Views

Batch INSERTS / File Importing: CSV​

  • Python CSV Library
  • Improving Efficiency of Existing Code

Component Message Handlers​

  • Message Sending
  • Enhancing Displays Using Message Handlers
  • Sharing Data Between Sessions with Messages

Customized Layouts: Dashboard Component​

  • Interacting with the Dashboard
  • Storing Dashboard Configurations to the Database