JP5023038B2 - Program generating program and program generating apparatus - Google Patents

Description

  The present invention relates to a program generation program that automatically generates a program for performing processing on a database, and a program generation apparatus on which the program operates.

  In recent years, for example, an apparatus (hereinafter referred to as a program generation apparatus) that automatically generates a program (application) for performing processing such as data generation, reading, update, or deletion for a database has been developed.

  As a technique for automatically generating a program as described above, for example, a technique for connecting to a database and generating a program using existing table information is known.

  For example, in application development for performing database operations, a technique related to automation of creating a database access part program (hereinafter referred to as a first prior art) is disclosed (for example, see Patent Document 1). According to this first prior art, it is possible to process data comprehensively by assigning conditions to each function of new (generation), update, deletion, and reading, which are types of database operations. In the first prior art, a program for reading a database file and accessing the database is automatically generated.

In addition, for example, a technique for generating a source code of a program based on designation information (hereinafter referred to as second prior art) is disclosed (for example, see Patent Document 2). According to this second prior art, for the application program developer, the pull-down list is automatically divided for each digit and not divided, and a numerical value is selected from a short selection list without creating a long selection list. A function that can be entered is provided. There is also provided a mechanism that can generate a program that can easily select and input a target numerical value from a pull-down list with only simple definition information without considering the length of the pull-down list and the screen status. In addition, it is possible to provide a mechanism for the application program user to divide the pull-down list for each digit or not to divide it automatically, and to easily select a desired numerical value from a short selection list. Is provided. In other words, according to the second prior art, when a program is automatically generated, an input screen (in which a user (user) of the generated program can easily select a numerical value as a purpose from a pull-down list is displayed. To generate a program).
Japanese Patent Laid-Open No. 11-53391 JP 2008-52386 A

  However, in the above-described program generation device, for example, in order to generate an operating program, it is necessary to input detailed physical specifications. If there is no input of physical specifications, only a part of programs can be automatically generated.

  For example, when the user of the generated program inputs data from the input screen, it is checked whether the input data satisfies a constraint condition caused by the definition of the table, or based on existing data In order to perform input assistance or the like, it is necessary to create a separate program and add processing.

  In addition, the definition of the database table structure causes restrictions on the range or value of data that can be entered in each item. However, restrictions on the operation of the program (application) are not limited by the database table structure definition alone. It is. For this reason, it is necessary to separately create a program for assisting input and add processing.

  As described above, in the first prior art, it is possible to process data comprehensively by assigning conditions to each function of new / update / delete / read which are types of database operations. However, in the first prior art, it is necessary to specify in advance which process of each function (new, update, delete, and read) is to be generated. In the first prior art, it is also necessary to specify the condition of input data by the user of the generated program for each function. If it is necessary to specify for each function in this way, it is necessary to make changes to each function to be changed when performing maintenance such as `` changing the input data conditions ''. Come.

  As described above, in the second prior art, it is possible to generate an input screen that allows a user of the generated program to easily select a numerical value as a purpose from a pull-down list. That is, in the second prior art, it is possible to perform the input assistance described above. However, in the second prior art, conditions for generating user input assistance (support) processing such as the numerical interval of items in the pull-down list must be specified in advance.

  Accordingly, an object of the present invention is to provide a program generation program and a program generation apparatus capable of generating an input auxiliary program for assisting a user input of the generated program when the program is automatically generated. It is to provide.

According to one aspect of the present invention, it is used to generate an input auxiliary program for assisting a user to input data using a program for performing processing on a table holding data stored in a database. An external storage device having template storage means and table structure definition information storage means for storing in advance a template to be associated with the type of data held in the table, and a computer using the external storage device In the program generation apparatus, a program generation program executed by the computer, the table information indicating the structure of the table stored in the database in the computer, the type of data held in the table holding the table information and the table including The data that is, a step of acquiring from said table stored in said database, parsing the acquired data, based on the structure and the analysis results of the table indicated by the obtained table information Generating table structure definition information including the type of data included in the table information and the range of data held in the table, and storing the generated table structure definition information in the table structure definition information storage unit. The step of storing and the range of data included in the table structure definition information stored in the table structure definition information storage unit are stored in the template storage unit in association with the type of data included in the table structure definition information. input check by fitting in with templates Program for producing a program for executing the steps of generating Lumpur program is provided.

  According to the present invention, when a program is automatically generated, it is possible to generate an input assistance program for assisting the user's input of the generated program.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

[First Embodiment]
First, a first embodiment of the present invention will be described with reference to FIGS. FIG. 1 is a block diagram illustrating a hardware configuration of the program generation apparatus according to the present embodiment. As shown in FIG. 1, the computer 10 is connected to an external storage device 20 such as a hard disk drive (HDD). The external storage device 20 stores a program 21 executed by the computer 10. The computer 10 and the external storage device 20 constitute a program generation device 30.

  FIG. 2 is a block diagram mainly showing a functional configuration of the program generation apparatus 30 shown in FIG. The program generation device 30 is connected to a database 40 that stores, for example, a table holding various data, for example, for each schema name.

  As illustrated in FIG. 2, the program generation device 30 includes an overall control unit 31, a table information acquisition unit 32, a data item specification generation unit 33, a program generation unit 34, and an input check rule generation unit 35. In the present embodiment, these units 31 to 35 are realized by the computer 10 shown in FIG. 1 executing the program (program generation program) 21 stored in the external storage device 20. This program 21 can be stored in advance in a computer-readable storage medium and distributed. The program 21 may be downloaded to the computer 10 via, for example, a network.

  Further, the program generation device 30 includes a table structure definition information storage unit 22 and an input check rule template storage unit 23. In the present embodiment, the table structure definition information storage unit 22 and the input check rule template storage unit 23 are stored in, for example, the external storage device 20.

  The overall control unit 31 inputs database connection information in accordance with, for example, an operation of a user (hereinafter referred to as an administrator) of the program generation device 30. This database connection information includes, for example, a URI (Uniform Resource Identifier).

  The overall control unit 31 acts on the table information acquisition unit 32 and instructs to acquire table information from the database 40 in accordance with an operation (instruction) of the administrator. The overall control unit 31 operates on the program generation unit 34 and performs a series of CRUD processing (generation / reading / update / deletion) on the database 40 in accordance with the operation of the administrator (hereinafter referred to as a main body). To generate a program).

  The table information acquisition unit 32 acquires the table name of the table stored in the database 40 in response to an instruction from the overall control unit 31. The acquired table name is displayed to the administrator, for example.

  The table information acquisition unit 32 acquires table information indicating the structure of the table designated (selected) by the administrator from the table stored in the database 40. This table information includes, for example, the table name, the type (type) of data held in the table, restrictions on the data, and the like. This type includes, for example, a VARCHAR2 type (character data), a NUMBER type (numeric data), a TIMESTAMP type (date data), and the like. The data constraint includes, for example, the number of characters or the number of digits of data.

  Based on the table structure indicated by the table information acquired by the table information acquisition unit 32, the data item specification generation unit 33 generates table structure definition information including a range of data held in the table. The table structure definition information is obtained by adding the range of data held in the table in the table structure indicated by the table information to the table information acquired by the table information acquisition unit 32. The range of this data is determined based on the restriction of data held in the table included in the table information acquired by the table information acquisition unit 32.

  The data item specification generation unit 33 stores the generated table structure definition information in the table structure definition information storage unit 22.

  In response to an instruction from the overall control unit 31, the program generation unit 34 executes processing for generating the main body program described above. The program generation unit 34 generates a main body program based on the table structure definition information stored in the table structure definition information storage unit 22. This main body program is, for example, a web application program.

  The program (main program) generated by the program generation unit 34 is used (executed) in a terminal of a user (hereinafter referred to as a user) who uses the program, for example.

  The input check rule template storage unit 23 includes a template used to generate a program for assisting a user to input data using the main body program generated by the program generation unit 34 (hereinafter referred to as an input auxiliary program). Stored in advance. This template is stored in the input check rule template storage unit 23 in association with each type of data (that is, type) held in a table stored in the database 40 in, for example, XML (eXtensible Markup Language) format. Yes.

  The input check rule generation unit 35 applies the input assistance by applying the range of data included in the table structure definition information stored in the table structure definition information storage unit 22 to the template stored in the input check rule template storage unit 23. Generate a program. The input check rule generation unit 35 performs a process to make an error when the data input outside the range of the data included in the table structure definition information stored in the table structure definition information storage unit 22 is input. The input check rule (input support rule) program (hereinafter referred to as input check rule program) is generated as an input support program.

  The program generation device 30 provides the user with a set of the main body program generated by the program generation unit 34 and the input check rule program (input auxiliary program) generated by the input check rule generation unit 35. The input check rule program is incorporated into the main body program in, for example, a terminal used by a user. Thereby, the user can use the program including the input check function.

  FIG. 3 shows an example of the data structure of the table information acquired by the table information acquisition unit 32 shown in FIG.

  As shown in FIG. 3, the table information includes a table name, a column name, a type, a column attribute, and a value of the column attribute (column attribute value) in association with each other. The column attribute and the column attribute value indicate restrictions (for example, the number of digits) of data held in the table.

  In the example illustrated in FIG. 3, the table information includes column names “empNo”, “salary”, and “hiredate” in association with the table name “emp”. The table information includes a type “VARCHAR2 (character data type)” in association with the column name “empNo”. Further, the table information includes a type “NUMBER (numerical data type)” associated with the column name “salary” and a type “TIMESTAMP (date data type)” associated with the column name “hiredate”.

  The table information includes a column attribute “digit (number of characters)” and a column attribute value “x = 200” in association with the type “VARCHAR2”. According to this, it is indicated that the data of the column whose column name is “empNo” and whose type is “VARCHAR2” is character data whose digit is “200 (below)”.

  The table information includes a column attribute “digit” and a column attribute value “y = 5” in association with the type “NUMBER”. Similarly, the table information includes a column attribute “scale” and a column attribute value “z = 0” in association with the type “NUMBER”. According to this, it is shown that the data of the column whose column name is “salary” and whose type is “NUMBER” is numeric data whose digit is “5 (less than)” and whose scale is “0”. Has been.

  FIG. 4 shows an example of the data structure of the table structure definition information stored in the table structure definition information storage unit 22 shown in FIG. The table structure definition information illustrated in FIG. 4 is table structure definition information generated by the data item specification generation unit 33 based on the table structure indicated by the table information illustrated in FIG. 3 described above.

  As shown in FIG. 4, in the table structure definition information, column attributes “minimum character length” and “maximum character length” are added in association with the type “VARCHAR2” as compared with the table information shown in FIG. Has been. In the table structure definition information, a column attribute value “0” is added in association with the column attribute “minimum character length”. In the table structure definition information, a column attribute value “200” is added in association with the column attribute “maximum character length”. The column name is "empNo" from "0" associated with this "minimum character length" to "200" associated with "maximum character length", and the type is "VARCHAR2 (character data type ) ”Is the data range (number of characters) in the column.

  The column attribute “minimum character length” and the column attribute value “0”, the column attribute “maximum character length” and the column attribute value “200” are associated with the type “VARCHAR2” and included in the table information shown in FIG. It is determined based on the attribute “digit” and the column attribute value “x = 200”.

  Further, in the table structure definition information, column attributes “minimum value” and “maximum value” are added in association with the type “” as compared with the table information shown in FIG. 3 described above. In the table structure definition information, a column attribute value “−99999” is added in association with the column attribute “minimum value”. In the table structure definition information, a column attribute value “99999” is added in association with the column attribute “maximum value”. From “−99999” associated with this “minimum value” to “99999” associated with “maximum value”, the column name is “salary” and the type is “NUMBER (numeric data type)”. This is the data range (numerical range) in the column.

  The column attribute “minimum value”, the column attribute value “−99999”, the column attribute “maximum value”, and the column attribute value “99999” are associated with the type “NUMBER” and are included in the table information shown in FIG. It is determined based on “digit” and column attribute value “y = 5”, column attribute “scale” and column attribute value “z = 0”.

  Thus, the structure of the table indicated by the table information shown in FIG. 3 (here, column attribute “digit” and column attribute value “x = 200”, column attribute “digit” and column attribute value “y = 5”, Column attribute “scale” and column attribute value “z = 0”), column attribute “minimum character length”, column attribute value “0” associated with the column attribute, column attribute “maximum” The column attribute value “200” associated with the column attribute “character length”, the column attribute “minimum value”, the column attribute value “−99999” associated with the column attribute, the column attribute “maximum value”, and the By adding a column attribute value “99999” associated with the column attribute to the table information, the table structure definition information shown in FIG. 4 is generated.

  Next, a processing procedure of the program generation device 30 according to the present embodiment will be described. The processing of the program generation device 30 is divided into processing for generating table structure definition information and processing for generating a main body program and an input auxiliary program (hereinafter simply referred to as processing for generating a program). Hereinafter, each of these processes will be described.

  First, with reference to the flowchart of FIG. 5, the process sequence of the process which produces | generates the table structure definition information in the program production | generation apparatus 30 concerning this embodiment is demonstrated.

  When the process of generating the table structure definition information is executed, a screen (input screen) for specifying minimum initial information for accessing the database 40 is displayed to the administrator of the program generating device 30. Displayed. This screen is displayed via a display unit (not shown) provided in the program generation device 30. The same applies to screens displayed to the administrator below.

  The administrator can specify database connection information including, for example, a URI via this screen. That is, the administrator can specify the database 40 by specifying, for example, a URI. When the database connection information is designated, the administrator selects (presses), for example, the “generate table structure definition information” or “get table information” menu displayed on the screen, to change the table structure definition information. Directs generation.

  The overall control unit 31 included in the program generation device 30 inputs the database connection information in response to the administrator's operation as described above (step S1). The overall control unit 31 activates the data item specification generation unit 33 in response to an instruction to generate table structure definition information from the administrator. At this time, the overall control unit 31 passes the input database connection information to the data item specification generation unit 33.

  The data item specification generation unit 33 verifies the database connection information for the database 40 passed from the overall control unit 31 (step S2). The data item specification generation unit 33 verifies whether the database connection information (URI) is correct. If the database connection information is correct as a result of the verification, the data item specification generation unit 33 activates the table information acquisition unit 32. At this time, the data item specification generation unit 33 passes the database connection information to the table information acquisition unit 32.

  If the database connection information is not correct as a result of the verification, the fact is returned (displayed) to the administrator.

  Next, the data information acquisition unit 32 connects to the database 40 based on the database connection information passed from the data item specification generation unit 33.

  The data information acquisition unit 32 acquires a schema name (default schema name) set (initially set) in advance (step S3). The data information acquisition unit 32 acquires a default schema name from the database 40.

  The data information acquisition unit 32 acquires the table name of the table corresponding to the acquired schema name from the database 40 (step S4).

  The schema name and table name acquired by the data information acquisition unit 32 are displayed to the administrator (step S5).

  Here, FIG. 6 shows an example of a screen (hereinafter referred to as a table selection screen) on which the schema name and the table name acquired by the data information acquisition unit 32 are displayed.

  The table selection screen 100 shown in FIG. 6 includes a schema name display field 101, a table name display field 102, a selected table name display field 103, an import button 104, and a cancel button 105.

  In the schema name display field 101, the schema name acquired by the data information acquisition unit 32 (here, the default schema name) is displayed. In the example shown in FIG. 6, “SCOTT” is displayed as the default schema name in the schema name display field 101. Note that the administrator can change the schema name displayed in the schema name display column 101 by operating the program generation device 30, for example.

  In the table name display column 102, the table name acquired by the data information acquisition unit 32 (the table name corresponding to the schema name displayed in the schema name display column 101) is displayed. In the example shown in FIG. 6, the table name display field 102 displays a plurality of table names such as “ACCOUNT”, “APPCLASS”, “APPINSTANCE”, and “APPLOG” as table names.

  The administrator can select a table (name) from which table information is acquired from a plurality of table names displayed in the table name display field 102 by operating the program generation device 30. That is, the administrator can specify a table for which table structure definition information is generated.

  In this case, the administrator can select a table by moving the table name displayed in the table name display field 102 to the selected table name display field 103 and pressing (specifying) the import button 104.

  For example, when the table name displayed in the table name display field 102 is moved to the selected table name display field 103 and the selection of the table is to be canceled, the table is displayed by pressing the cancel button 105. You can cancel the selection.

  Returning to the flowchart of FIG. 5 again, after the schema name and table name acquired by the table information acquisition unit 32 are displayed, the default schema name (in the schema name display column 101 is displayed by the administrator's operation as described above. It is determined whether or not the displayed schema name has been changed (step S6).

  If it is determined that the schema name has been changed (YES in step S6), the process returns to step S4 and the process is repeated. That is, when the schema name is changed, the table information acquisition unit 32 acquires the table name of the table corresponding to the changed schema name from the database 40. Thereafter, the changed schema name and the table name acquired by the table information acquisition unit 32 (the table name corresponding to the changed schema name) are displayed on the table selection screen 100 as shown in FIG. In this case, the table name is selected by the administrator on the table selection screen 100 as described above.

  On the other hand, when it is determined that the schema name has not been changed (NO in step S6), the table information acquisition unit 32 stores in the database 40 table information indicating the structure of the table selected (designated) by the administrator. It is acquired from the table that has been (step S7). The table information acquisition unit 32 passes the acquired table information to the data item specification generation unit 33. When the table information is passed to the data item specification generation unit 33, the processing of the table information acquisition unit 32 is terminated.

  Next, the data item specification generation unit 33, based on the table information passed from the table information acquisition unit 32, the data held in the table in the table structure indicated by the table information (column data in the table) Table structure definition information is generated by adding the range (step S8). Specifically, the data item specification generation unit 33 generates the table structure definition information shown in FIG. 4 based on the table information shown in FIG.

  The data item specification generation unit 33 writes the generated table structure definition information in the table structure definition information storage unit 22 (step S9). This table structure definition information is held in a spreadsheet, for example. When the table structure definition information is written in the table structure definition information storage unit 22, the processing of the data item specification generation unit 33 is terminated.

  When the process of the data item specification generation unit 33 is finished, a screen (end screen) indicating that the process of generating the table structure definition information is finished is displayed to the user (step S10).

  Next, with reference to the flowchart of FIG. 7, the process sequence of the process which produces | generates the program in the program production | generation apparatus 30 which concerns on this embodiment is demonstrated. In this embodiment, as an input assistance program, for example, an input check rule (program) for checking user data input is generated.

  When a process for generating a program is executed, a screen for instructing the process is displayed to the administrator. The administrator operates the program generation apparatus 30 to instruct the program generation apparatus 30 to generate a program via this screen. Specifically, the administrator instructs the generation of the program by, for example, selecting (pressing) the “start generation of (program)” menu displayed on the screen.

  The general control unit 31 included in the program generation device 30 activates the program generation unit 34 when the generation of the program is instructed in accordance with the operation of the administrator as described above.

  When the program generation unit 34 is activated, the program generation unit 34 reads the table structure definition information stored in the table structure definition information storage unit 22 via the overall control unit 31 (step S11).

  Based on the read table structure definition information, the program generation unit 34 performs a series of CRUD processing (generation / read / update / delete) on the database 40 (the table stored in the database 40) , A main body program) is generated (step S12).

  Next, the program generation unit 34 activates the input check rule generation unit 35. At this time, the program generation unit 34 passes the read table structure definition information to the input check rule generation unit 35.

  The input check rule generation unit 35 reads an appropriate template from the input check rule template storage unit 23 based on the table structure definition information passed from the program generation unit 34 (step S13). The input check rule generation unit 35 is associated with the type (type of data such as character data, numerical data, or date data) included in the table structure definition information passed from the program generation unit 34, and the input check rule template storage unit 23 Load templates stored in.

  The input check rule generation unit 35 generates an input check rule (program) based on the table structure definition information passed from the program generation unit 34 and the read template (step S14). The input check rule generation unit 35 inputs the range of data associated with the column name and type in the table structure definition information passed from the program generation unit 34 by applying the range of data to the template corresponding to the read type. Generate a check rule program.

  For example, in the input check rule program for the column name “empNo” included in the table structure definition information shown in FIG. 4, the minimum character length is associated with the “minimum character length” of “empNo” in the table structure definition information. It is “0”. The maximum character length is “200” associated with “maximum character length” of “empNo” in the table structure definition information shown in FIG. That is, according to this input check rule program, when data having a character length outside the range of the minimum character length “0” to the maximum character length “200” is input, it is checked that the input is an error. be able to.

  Note that the input check rule program generated by the input check rule generation unit 35 performs input check based on the input check rule file. This input check rule file is, for example, an XML file here.

  Here, FIG. 8 illustrates an example (definition example) of a setting file used in the input check rule program generated by the input check rule generation unit 35. FIG. 8 shows a setting file used in the input check rule program generated based on the table structure definition information shown in FIG.

  In the example shown in FIG. 8, the portion surrounded by <form id =...> On the second line and </ form> on the 27th line indicates the definition of one input check rule.

  In the example shown in FIG. 8, the portion surrounded by <item key =...> On the fourth line and </ item> on the sixth line is a setting item for a column (column name “empNo”) existing in the table. Hereinafter, the part enclosed by <item key = ...> to </ item> is the definition of the input check rule for each item (column names “salary” and “hiredate”).

  For example, <ank-length max = “x” min = ”0” erro-message = ”ank-length-char” /> on the 5th line is an input check based on the character length converted to single-byte characters. In this case, the attributes, max and min, indicate the maximum value (maximum character length) and the minimum value (minimum character length) of the character length by half-width character conversion.

  In the example shown in FIG. 8, as shown in the fifth line, max = x (actually, a digit obtained from the database 40, for example, 200 is input), and min = 0. That is, for example, the input check rule for the column name “empNo” is stored in the template associated with the column name type “VARCHAR2” in the input check rule template storage unit 23 in the minimum character of the column name “empNo”. It is generated by fitting the column “0” and the maximum character string “x (= 200)”. The same applies to other column names (for example, “salary”).

  Returning to FIG. 7 again, when the input check rule program is generated as described above, the input check rule generation unit 35 returns the input check rule program to the program generation unit 34. When the input check rule program is returned to the program generation unit 34, the processing of the input check rule generation unit 35 is terminated.

  When the process of the input check rule generation unit 35 is completed, a screen (end screen) indicating that the process of generating the program is completed is displayed to the user (step S15).

  As described above, the program generation device 30 provides the user with a set of the main body program generated in step S12 and the input check rule program generated in step S14, for example. The input check rule program is incorporated into the main body program in a terminal or the like used by the user. Thus, for example, when the user's data input for the input item of the main body program does not satisfy the requirements of the input check rule (the range of data defined in the setting file described above), for example, the input check error screen is displayed Is displayed.

  Here, FIG. 9 shows an example of an input check error screen. The input check error screen 200 shown in FIG. 9 displays that the user's data input does not satisfy the requirements of the input check rule. In the example shown in FIG. 9, “SALARY (column name) is a numeric value (data range) within 5 digits of the integer part. + Or − can be added to the head.” Is displayed. The user can input appropriate data by referring to the input check error screen 200.

  As described above, in the present embodiment, the table information of the table specified (selected) by the administrator of the program generation device 30 is acquired, and the table structure definition information generated from the table information is stored in the table structure definition information storage unit. 22. In the present embodiment, when a program (main program) for performing a series of CRUD processes on the database 40 is generated based on the table structure definition information stored in the table structure definition information storage unit 22. Based on the table structure definition information and the template stored in the input check rule template storage unit 23, an input check rule program (input auxiliary program) for checking data input to the input item in the main body program is generated. The

  Thus, in the present embodiment, an input check rule program for data input by the user can be automatically generated based on the input data restriction caused by the structure of the table stored in the database 40 accessed by the main body program. It becomes possible. That is, in the present embodiment, when automatically generating a main body program, an input auxiliary program (input check rule program) for assisting the user's input of the generated main body program can be generated. The production efficiency of the application can be improved.

[Second Embodiment]
Next, a second embodiment of the present invention will be described with reference to FIG. FIG. 10 is a block diagram mainly showing a functional configuration of the program generation device according to the present embodiment. The same parts as those in FIG. 2 described above are denoted by the same reference numerals, and detailed description thereof is omitted. Here, parts different from FIG. 2 will be mainly described.

  The hardware configuration of the program generation device according to this embodiment is the same as that of the first embodiment described above, and will be described with reference to FIG. 1 as appropriate.

  A program generation apparatus 300 illustrated in FIG. 10 includes a table information acquisition unit 301, a data analysis unit 302, a data item specification generation unit 303, and a screen option generation unit 304. In the present embodiment, these units 301 to 304 are realized by the computer 10 illustrated in FIG. 1 executing the program 21 stored in the external storage device 20.

  Note that the table stored in the database 40 holds (stores) data input to the table, for example.

  In addition to the function of the table information acquisition unit 32 in the first embodiment described above, the table information acquisition unit 301 stores data (table storage data) held (stored) in a table specified by the administrator as a database. 40 is obtained from the table stored in 40.

  The data analysis unit 302 analyzes the data acquired by the table information acquisition unit 301.

  In addition to the table structure indicated by the table information acquired by the table information acquisition unit 301, the data item specification generation unit 303 further generates table structure definition information based on the analysis result of the data analysis unit 302. The analysis result by the data analysis unit 302 includes, for example, the distribution or interval (information) of data acquired by the table information acquisition unit 301 (data held in the table). That is, the table structure definition information generated by the data item specification generating unit 303 includes the distribution and interval of data held in the table (analysis result). Details of the table structure definition information generated by the data item specification generation unit 303 will be described later.

  The screen option generation unit 304 is a program for assisting user data input using the main body program generated by the program generation unit 34 based on the table structure definition information stored in the table structure definition information storage unit 22. (Input auxiliary program) is generated. The screen option generation unit 304 displays a program (hereinafter referred to as a screen option display program) for displaying a screen (screen option) that allows the user to select and input data when the user inputs data in the main program. Generate as an input auxiliary program.

  That is, in the program generation device 300 according to the present embodiment, as the input auxiliary program, the input check rule program (first input auxiliary program) in the first embodiment described above and the screen option display program (second output) described above. Two programs (input auxiliary program) are generated.

  FIG. 11 shows an example of the data structure of the table structure definition information stored in the table structure definition information storage unit 22 shown in FIG. The table structure definition information shown in FIG. 11 is generated based on the analysis result (data distribution or interval) of data (table storage data) held (stored) in the table as described above. This is different from the table structure definition information shown in FIG. Here, differences from the table structure definition information shown in FIG. 4 will be mainly described.

  The table structure definition information illustrated in FIG. 11 includes the column attribute value “3” in association with the column name “empNo”, the type “VARCHAR2”, and the column attribute “minimum character length”. That is, in the table structure definition information shown in FIG. 4 described above, the minimum character length that was “0” is “3”. In the above data analysis result, when the minimum character length in the data distribution of the column whose column name is “empNo” and whose type is “VARCHAR2” is “3”, the minimum is as shown in FIG. As the character length, “3” is included in the table structure definition information.

  The table structure definition information illustrated in FIG. 11 includes a column attribute value “180” in association with the column name “empNo”, the type “VARCHAR2”, and the column attribute “maximum character length”. That is, in the table structure definition information shown in FIG. 4 described above, the minimum character length that was “200” is “180”. In the above data analysis result, when the maximum character length in the data distribution of the column having the column name “empNo” and the type “VARCHAR2” is “180”, the maximum is as shown in FIG. As the character length, “180” is included in the table structure definition information.

  The table structure definition information illustrated in FIG. 11 includes a column attribute value “0” in association with a column name “salary”, a type “NUMBER”, and a column attribute “minimum value”. That is, in the table structure definition information shown in FIG. 4 described above, the minimum value that was “−99999” is “0”. In the above data analysis result, when the minimum value in the data distribution of the column whose column name is “salary” and whose type is “NUMBER” is “0”, as shown in FIG. “0” is included in the table structure definition information.

  The table structure definition information illustrated in FIG. 11 includes a column attribute value “6000” in association with the column name “salary”, the type “NUMBER”, and the column attribute “maximum value”. That is, in the table structure definition information shown in FIG. 4 described above, the minimum character length that was “999999” is “6000”. In the analysis result of the above data, when the maximum value in the data distribution of the column whose column name is “salary” and whose type is “NUMBER” is “6000”, as shown in FIG. “6000” is included in the table structure definition information.

  Further, the table structure definition information shown in FIG. 11 includes a column attribute value “10” in association with the column name “hiredate”, the type “TIMESTAMP”, and the column attribute “minute interval”. In the analysis result of the above data, when the minute interval of the data (date data) of the column whose column name is “hiredate” and whose type is “TIMESTAMP” is “10”, as shown in FIG. As the minute interval, “10” is included in the table structure definition information.

  Next, a processing procedure of the program generation device 300 according to the present embodiment will be described. Similar to the first embodiment described above, the processing of the program generation device 300 is divided into processing for generating table structure definition information and processing for generating a program. Hereinafter, each of these processes will be described.

  With reference to the flowchart of FIG. 12, the process sequence of the process which produces | generates the table structure definition information in the program production | generation apparatus 300 which concerns on this embodiment is demonstrated.

  When the process for generating the table structure definition information is executed, a screen for specifying minimum initial information for accessing the database 40 is generated as in the first embodiment described above. Displayed to the administrator of the device 300.

  The administrator can specify database connection information including, for example, a URI via this screen. That is, the administrator can specify the database 40 by specifying, for example, a URI. When the database connection information is designated, the administrator selects (presses), for example, the “generate table structure definition information” or “get table information” menu displayed on the screen, to change the table structure definition information. Directs generation.

  As described above, when generation of table structure definition information is instructed by the administrator, processing in steps S21 to S26 corresponding to the processing in steps S1 to S6 shown in FIG. 5 described above is executed.

  If it is determined in step S26 that the schema name has been changed, the process returns to step S24 and the process is repeated.

  On the other hand, when it is determined in step S26 that the schema name has not been changed, the table information acquisition unit 301 holds (stores) the table information indicating the structure of the table selected (designated) by the administrator and the table. Data (table storage data) is acquired from the table stored in the database 40. The table information acquisition unit 301 passes the acquired table information and data to the data item specification generation unit 303. When the table information and data are passed to the data item specification generation unit 303, the processing of the table information acquisition unit 301 is terminated.

  Next, the data item specification generation unit 303 activates the data analysis unit 302. At this time, the data item specification generation unit 303 passes the data passed from the table information acquisition unit 301 to the data analysis unit 302.

  The data analysis unit 302 analyzes the data passed from the data item specification generation unit 303 (step S28). The data analysis unit 302 passes (outputs) the analysis result including the distribution or interval of the data passed from the data item specification generation unit 303 to the data item specification generation unit 303. When the analysis result is passed to the data item specification generation unit 303, the processing of the data analysis unit 302 ends.

  The data item specification generation unit 303 generates table structure definition information based on the table information passed from the table information acquisition unit 301 and the analysis result passed from the data analysis unit 302 (step S30). As shown in FIG. 11, the data item specification generation unit 303 has a range (minimum character string, maximum character string) of data (column data in the table) held in the table in the table structure indicated by the table information. Etc.), the table structure definition information reflecting the distribution of data included in the analysis result is generated. In addition, the data item specification generation unit 303 generates table structure definition information including an interval of data included in the analysis result.

  When the process of step S30 described above is executed, the processes of step S30 and step S31 corresponding to the processes of step S9 and step S10 shown in FIG. 5 described above are executed.

  Next, a processing procedure for generating a program in the program generating apparatus 300 according to the present embodiment will be described with reference to the flowchart of FIG. In the present embodiment, an input check rule program (first input auxiliary program) for checking user data input and a screen option display program (second program) for displaying screen options at the time of user data input. An input auxiliary program) is generated as an input auxiliary program.

  When a process for generating a program is executed, a screen for instructing the process is displayed to the administrator as in the first embodiment described above. The administrator operates the program generation apparatus 300 to instruct the program generation apparatus 300 to generate a program via this screen. Specifically, the administrator instructs the generation of the program by, for example, selecting (pressing) the “start generation of (program)” menu displayed on the screen.

  When the generation of the program is instructed as described above, the processes in steps S41 to S44 corresponding to the processes in steps S11 to S14 shown in FIG. 7 described above are executed. That is, the main body program is generated by the program generation unit 34 in step S42.

  In step S44, the input check rule generation unit 35 generates an input check rule program (first input auxiliary program). At this time, when the table structure definition information has the data structure shown in FIG. 11, the input check rule generation unit 35, for example, the data range of the column whose column name is “empNo” is changed from the minimum character length “3” to the maximum. An input check rule program having a character length of up to “180” is generated. That is, the input check rule generation unit 35 generates an input check rule program that reflects the distribution of data included in the analysis result described above. In this input check rule program, the data range may be changed from the minimum character string “0” to the maximum character string “200” as in the first embodiment. The same applies to other than the column name “empNo” (for example, the column name “salary”).

  Note that the program generation unit 34 activates the screen option generation unit 304 when the process of step S44 is executed. At this time, the program generation unit 34 passes the read table structure definition information to the screen option generation unit 304.

  The screen option generation unit 304 generates a screen option display program based on the analysis result included in the table structure definition information passed from the program generation unit 34 (step S45). The screen option generation unit 304 generates a screen option display program based on the column attribute included in the table structure definition information and the column attribute value associated with the column attribute. Specifically, the screen option generation unit 304 includes the minute interval included in the table structure definition information (in the data structure definition information illustrated in FIG. 11, the column attribute value “10” associated with the column attribute “minute interval”). ]) To generate a screen option display program.

  The screen option generation unit 304 returns the generated screen option display program to the program generation unit 34. When the screen option display program is returned to the program generation unit 34, the processing of the screen option generation unit 304 is terminated.

  When the process of the screen option generation unit 304 is completed, a screen (end screen) indicating that the process of generating the program is completed is displayed to the user (step S46).

  The program generation device 300 provides the user with a set of the main body program generated in step S42, the input check rule program generated in step S44, and the screen option display program generated in step S45, for example. Similar to the input check rule program, the screen option display program is incorporated in the main body program in a terminal or the like used by the user. Thereby, for example, when the user inputs data to the input item of the main program, a screen (screen option) for selectively inputting the data is displayed to the user.

  Here, FIG. 14 shows an example of screen options displayed when the screen option display program generated by the screen option generation unit 304 is executed. The screen option 400 shown in FIG. 14 is a screen displayed by executing the screen option display program generated based on the table structure definition information shown in FIG. 11 described above.

  As described above, the column attribute value associated with the column name “hiredate”, the type “TIMESTAMP”, and the column attribute “minute interval” included in the table structure definition information illustrated in FIG. 11 is “10”. In this case, when the user inputs date (time) data of “TIMESTAMP type” as an input item, a pull-down menu (pull-down list) at 10-minute intervals is displayed as a screen option 400 as shown in FIG. The Thus, when a user who uses the main body program inputs date data, the date can be easily selected by selecting an appropriate time in the screen option 400 displayed by the screen option display program incorporated in the main body program. Data can be input.

  As described above, in this embodiment, in addition to the input check rule program in the first embodiment described above, the analysis result of the data (table storage data) held in the table stored in the database 40 is included. A screen option display program is generated as an input auxiliary program based on the table structure definition information.

  As a result, in this embodiment, as compared with the first embodiment described above, the data distribution or interval that cannot be obtained only by the structure of the table stored in the database 40 is actually stored in the table. And an input auxiliary program (screen option display program) can be automatically generated based on the analysis result. For this reason, in this embodiment, it becomes possible to improve the production efficiency of an application.

  Note that the present invention is not limited to the above-described embodiments as they are, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage. Further, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the above embodiments. For example, some components may be deleted from all the components shown in each embodiment. Furthermore, constituent elements over different embodiments may be appropriately combined.

The block diagram which shows the hardware constitutions of the program production | generation apparatus which concerns on the 1st Embodiment of this invention. The block diagram which mainly shows the function structure of the program generation apparatus 30 shown in FIG. The figure which shows an example of the data structure of the table information acquired by the table information acquisition part 32 shown in FIG. The figure which shows an example of the data structure of the table structure definition information stored in the table structure definition information storage part 22 shown in FIG. The flowchart which shows the process sequence of the process which produces | generates the table structure definition information in the program production | generation apparatus 30 which concerns on this embodiment. The figure which shows an example of the screen on which the schema name and table name which were acquired by the data information acquisition part 32 are displayed. The flowchart which shows the process sequence of the process which produces | generates the program in the program production | generation apparatus 30 which concerns on this embodiment. The figure for demonstrating an example of the setting file used with the input check rule program produced | generated by the input check rule production | generation part 35. FIG. The figure which shows an example of an input check error screen. The block diagram which mainly shows the function structure of the program generation apparatus which concerns on the 2nd Embodiment of this invention. The figure which shows an example of the data structure of the table structure definition information stored in the table structure definition information storage part 22 shown in FIG. The flowchart which shows the process sequence of the process which produces | generates the table structure definition information in the program production | generation apparatus 300 which concerns on this embodiment. The flowchart which shows the process sequence of the process which produces | generates the program in the program production | generation apparatus 300 which concerns on this embodiment. The figure which shows the example of a position of the screen choice displayed when the screen choice display program produced | generated by the screen choice production | generation part 304 is performed.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 10 ... Computer, 20 ... External storage device, 22 ... Table structure definition information storage part, 23 ... Input check rule template storage part, 30, 300 ... Program generation apparatus, 31 ... Overall control part, 32, 301 ... Table information acquisition part 33, 303 ... data item specification generation unit, 34 ... program generation unit, 35 ... input check rule generation unit, 40 ... database, 302 ... data analysis unit, 304 ... screen selector generation unit.

Claims (5)

Data stored in the table that is used to generate an input assistance program for assisting the user to input data using a program for processing a table that stores data stored in the database In a program generation device comprising an external storage device having a template storage means and a table structure definition information storage means stored in advance in association with the type of data, and a computer using the external storage device, the program generation device is executed by the computer. A program generation program,
In the computer,
Table information indicating the structure of the table stored in the database, the table information including the type of data held in the table and the data held in the table are stored in the database Steps to get from the table;
Analyzing the acquired data;
Based on the structure and the analysis results of the table indicated by the obtained table information, the step of generating a table structure definition information including range of data held on the type and the table of data included in the table information When,
Storing the generated table structure definition information in the table structure definition information storage means;
The range of data included in the table structure definition information stored in the table structure definition information storage unit is applied to the template stored in the template storage unit in association with the type of data included in the table structure definition information. the method comprising the steps of: generating an input check rule program by
Program generation program for executing   The generated table structure definition information further includes the analysis result,
  In the table structure definition information stored in the table structure definition information storage means, a screen option display program for causing the computer to display a screen for allowing the user to select and input data when the user inputs data is stored in the table structure definition information storage means. The program generation program according to claim 1, further comprising a step of generating based on the included analysis result.   And causing the computer to further execute a step of generating a program for processing the table stored in the database based on the table structure definition information stored in the table structure definition information storage means. The program generation program according to claim 1. Input validation rules programmed the generated, when the data input outside the data contained in the table structure definition information that has been fit to the template is, up for performing the process of an error the data input The program generation program according to claim 1, wherein the program generation program is a program. In a program generator connected to a database that stores a table that holds data,
A template used to generate an input assistance program for assisting a user who uses a program for performing processing on a table stored in the database is used as a type of data held in the table. Template storage means for storing in advance in association with each other;
Wherein a table information indicating a structure of a table stored in the database, the the data held in the table information and the table including the type of data held in the table, are stored in the database Table information acquisition means for acquiring from the table;
Analyzing means for analyzing the acquired data;
A data item for generating table structure definition information including the type of data included in the table information and the range of data held in the table based on the structure of the table indicated by the acquired table information and the analysis result Specification generation means;
Table structure definition information storage means for storing the generated table structure definition information;
The range of data included in the table structure definition information stored in the table structure definition information storage unit is applied to the template stored in the template storage unit in association with the type of data included in the table structure definition information. program generating apparatus characterized by comprising an input check rule generation means for generating an input check rule program by.

Images