Control device
Provided is a technique enables programming, including that for database operations, without describing a SQL used to operate the database. A PLC ( 30 ) that can access a DBMS ( 22 ) stores a user program ( 38 ) and definition information ( 32 ), the user program ( 38 ) including a structure type of variable, the definition information ( 32 ) indicating a definition of the structure type. The sequence command program ( 34 ) sequentially executes instructions in the user program ( 38 ) and invokes a DB access process program ( 35 ) in order to access the DBMS ( 22 ). The DB access process program ( 35 ) reads the definition information ( 32 ) and, on the basis of the read definition information ( 32 ), generates a SQL statement to be used when access to the DBMS ( 22 ) is made by execution of the user program ( 38 ). The DB access process program ( 35 ) executes the generated SQL statement by transmitting the SQL statement to the DB server ( 20 ).
1. A programmable logic controller (PLC) for accessing a database system, the PLC comprising:
a connection configured to connect the PLC with a personal computer for receiving a user program and definition information from the personal computer, wherein the definition information is in a non-SQL language;
an interface configured to read values from an external sensor;
a microprocessor configured to perform operations based on stored instructions;
a memory configured to store the user program and the definition information, the user program including a variable of a structure type, the definition information indicating a definition of the structure type included in the user program;
a converter configured to convert the definition information in the non-SQL language to a SQL statement for controlling the PLC to access the database system; and
an executioner configured to execute the SQL statement that is generated by transmitting the SQL statement to the database system.
2. The PLC according to claim 1 ,
wherein the converter converts the definition information in the non-SQL language to the SQL statement by extracting a structure tag name and a member name indicated by a definition in the definition information which corresponds to the user program that is executed and designating the structure tag name and the member name that are executed as a table name and a field name used to access the database system in accordance with a preset conversion rule.
3. PLC according to claim 1 ,
wherein the converter converts the definition information in the non-SQL language to the SQL statement including no value, from which a table name and a field name used to access the database system are identified, based on the definition information, and
the executioner executes the SQL statement by transmitting the SQL statement including no value to the database system in advance, extracting a value of a member in the variable of a structure type in accordance with an instruction in the user program, and transmitting the value that is extracted to the database system.
4. The PLC according to claim 1 ,
wherein the memory stores mapping information that provides a conversion rule for converting a definition of a structure tag name and a member name indicated by the definition information into a table name and a field name used to access the database system, and
the converter converts the definition information in the non-SQL language to the SQL statement based on the structure tag name and the member name indicated by the definition information and the conversion rule provided by the mapping information.
5. The PLC according to claim 4 ,
wherein the converter converts the definition information in the non-SQL language to the SQL statement including no value based on a table name and a field name indicated by the mapping information, and
the executioner executes the SQL statement by transmitting the SQL statement including no value to the database system in advance, extracting a value of a member in the variable of a structure type in accordance with an instruction in the user program, and transmitting the extracted value to the database system.
6. The PLC according to claim 1 ,
wherein the memory is configured to store mapping information that provides a conversion rule for converting a definition of a structure tag name and a member name indicated by the definition information into a table name and a field name used to access the database system,
the user program includes an instruction for generating the mapping information based on the definition information, and
the converter converts the definition information in the non-SQL language to the mapping information based on the definition information by executing the instruction for generating the mapping information which is included in the user program, and
converts the definition information in the non-SQL language to the SQL statement based on the structure tag name and the member name indicated by the definition information and the conversion rule provided by the generated mapping information.
7. A programmable logic controller (PLC) for accessing a database system, the PLC comprising:
a connection configured to connect the PLC with a personal computer for receiving a user program and definition information from the personal computer, wherein the definition information is in a non-SQL language;
an interface configured to read values from an external sensor;
a microprocessor;
a memory configured to store the user program and the definition information, the user program including variable of a structure type, the definition information indicating a definition of the structure type included in the user program, the memory including instructions that when executed by the microprocessor, cause the microprocessor to perform operations including
converting the definition information in the non-SQL language to a SQL statement for controlling the PLC to access the database system; and
executing the converted SQL statement by transmitting the SQL statement to the database system.
8. The PLC according to claim 7 ,
wherein the converting converts the definition information in the non-SQL language to the SQL statement by extracting a structure tag name and a member name indicated by a definition in the definition information which corresponds to the executed user program and designating the extracted structure tag name and member name as a table name and a field name used to access the database system in accordance with a preset conversion rule.
9. The PLC according to claim 7 ,
wherein the converting converts the definition information in the non-SQL language to the SQL statement including no value, from which a table name and a field name used to access the database system are identified, based on the definition information, and
the executing executes the SQL statement by transmitting the SQL statement including no value to the database system in advance, extracting a value of a member in the variable of a structure type in accordance with an instruction in the user program, and transmitting the extracted value to the database system.
10. The PLC according to claim 7 ,
wherein the memory stores mapping information that provides a conversion rule for converting a definition of a structure tag name and a member name indicated by the definition information into a table name and a field name used to access the database system, and
the converting converts the definition information in the non-SQL language to the SQL statement based on the structure tag name and the member name indicated by the definition information and the conversion rule provided by the mapping information.
11. The PLC according to claim 10 ,
wherein the converter converts the definition information in the non-SQL language to the SQL statement including no value based on a table name and a field name indicated by the mapping information, and
the executing executes the SQL statement by transmitting the SQL statement including no value to the database system in advance, extracting a value of a member in the variable of a structure type in accordance with an instruction in the user program, and transmitting the extracted value to the database system.
12. The PLC according to claim 7 ,
wherein the memory is configured to store mapping information that provides a conversion rule for converting a definition of a structure tag name and a member name indicated by the definition information into a table name and a field name used to access the database system,
the user program includes an instruction for generating the mapping information based on the definition information, and
the converting converts the definition information in the non-SQL language to the mapping information based on the definition information by executing the instruction for generating the mapping information which is included in the user program, and converts the definition information in the non-SQL language to the SQL statement based on the structure tag name and the member name indicated by the definition information and the conversion rule provided by the generated mapping information.