Package com.inductiveautomation.gateway.tags.history.storage

Class TagHistoryTables.Drivers

  • Enclosing class:
    TagHistoryTables
    public static class TagHistoryTables.Drivers
extends java.lang.Object

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static java.lang.String DRV_ID  
      static java.lang.String PROV_NAME  
      static java.lang.String SYS_NAME  
      static java.lang.String TABLE_NAME  

    • Constructor Summary

      Constructors 
      Constructor Description
      Drivers()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.lang.String queryAllProviders()
      SELECT id, gwname, provider from drivers ORDER BY provider
      static java.lang.String queryDrvIdForName()
      SELECT id FROM drivers WHERE name=? *
      static java.lang.String queryInsert()
      INSERT INTO drivers(name, provider) values(?,?) *
      static java.lang.String queryProviders_v1()
      SELECT id, name FROM drivers ORDER BY name ASC
      static java.lang.String queryProviders_v2()
      SELECT id, name, provider FROM drivers ORDER BY name ASC
      static java.lang.String queryProvidersForSystem_v1()  
      static java.lang.String queryProvidersForSystem_v2()
      SELECT id, name, provider from drivers WHERE name=? ORDER BY provider *
      static java.lang.String queryUpdate()
      UPDATE drivers SET name=? WHERE name=? *

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    • Constructor Detail

      • Drivers

        public Drivers()

    • Method Detail

      • queryDrvIdForName

        public static java.lang.String queryDrvIdForName()
        SELECT id FROM drivers WHERE name=? *

      • queryProviders_v2

        public static java.lang.String queryProviders_v2()
        SELECT id, name, provider FROM drivers ORDER BY name ASC

      • queryProviders_v1

        public static java.lang.String queryProviders_v1()
        SELECT id, name FROM drivers ORDER BY name ASC

      • queryProvidersForSystem_v2

        public static java.lang.String queryProvidersForSystem_v2()
        SELECT id, name, provider from drivers WHERE name=? ORDER BY provider *

      • queryAllProviders

        public static java.lang.String queryAllProviders()
        SELECT id, gwname, provider from drivers ORDER BY provider

      • queryProvidersForSystem_v1

        public static java.lang.String queryProvidersForSystem_v1()

      • queryInsert

        public static java.lang.String queryInsert()
        INSERT INTO drivers(name, provider) values(?,?) *

      • queryUpdate

        public static java.lang.String queryUpdate()
        UPDATE drivers SET name=? WHERE name=? *