JP5163662B2 - File generation system and file generation method - Google Patents

Description

  The present invention relates to a file generation system and a file generation method for generating a file, and more particularly to a file generation system and a file generation method for generating a file in the field of O / R mapping.

The iBATIS of iBATIS provides a function that generates a SQL (Structured Query Language) SQL of a basic CRUD (Create, Read, Update, Delete) and uses it through a data access class. This function Read provides the following functions.
(1) A function that performs a SELECT on the primary key as a condition (2) A function that performs a SELECT on a condition in which a column in which a value is set is connected with AND is a condition (1) It is a function. On the other hand, the function (2) is a unique function of iBATOR.

  However, in the functions (1) and (2) described above, since the search condition is constructed on the assumption that the value is set in the same method, the condition used internally is estimated from the user side. It is difficult to cause bugs.

  Also, Ruby on Rails, which appeared as a latecomer of Java (registered trademark), one of the programming languages, is said to be generally more productive than Java. One reason for this is that Ruby on Rails has an Active Record dynamic finder function.

  In a dynamic language such as Ruby on Rails, there is a function of metaprogramming that allows a specific method to operate when “MethodMissingException” occurs and analyze the method name. This method name analysis function realizes the dynamic finder function.

  Ruby on Rails' Active Record provides a dynamic finder function, but can only be used to search for an exact match. Furthermore, only conditional statements connected by AND can be used.

  In general, Java has a higher operation speed than Ruby on Rails, and is therefore widely used for enterprises. Therefore, if the productivity of Java can be made equivalent to Ruby on Rails, the productivity of enterprise system development can be improved, which can contribute to the development of information technology.

  Further, a technique for analyzing item definition information acquired from an RDBMS (relational database management system) and creating a desired SQL definition sentence from the analysis result and the acquired area parameter is considered (for example, Patent Document 1). reference.).

Japanese Patent Laid-Open No. 11-259345

  However, since Ruby on Rails is a dynamic language, there is a problem that it cannot be applied to Java, which is a static language.

  In order to realize the dynamic finder function in Java, there is a problem that methods and SQL statements must be automatically generated, and dynamically regenerated according to specification changes.

  Further, the technique described in Patent Document 1 does not generate a data access class and a data access related SQL statement.

  An object of the present invention is to provide a file generation system and a file generation method that solve the above-described problems.

The file generation system of the present invention includes:
In a file generation system composed of a table design document reading device, a source generation control device, a data class generation device, a data access class generation device, and an SQL statement definition file generation device,
The table design document reading device reads a table design document in which a table is predefined,
The source generation control device controls the data class generation device, the data access class generation device, and the SQL statement definition file generation device based on a combination of columns of the table of the table design document;
The SQL statement definition file generation device generates an SQL statement definition file including a dynamic finder SQL statement generated based on the combination of the columns and an SQL statement of INSERT, UPDATE, and DELETE,
The data class generation device generates a data class file that is a data class file that is used in the data access class and the SQL statement definition file, and that is a class representing a correspondence with a table in O / R mapping.
The data access class generation device is a class that includes the dynamic finder method name generated based on the combination of the columns, applies the value of the data class to an SQL statement, and operates the SQL statement. Generate a data access class file to be a data access class file,
The SQL statement definition file, the data class file, and the data access class file are operated on the O / R mapping of Java.

Further, the file generation method of the present invention includes:
A file generation method in a file generation system comprising a table design document reading device, a source generation control device, a data class generation device, a data access class generation device, and an SQL statement definition file generation device,
The table design document reading device reads a table design document in which a table is defined in advance;
The source generation control device controls the data class generation device, the data access class generation device, and the SQL statement definition file generation device based on a combination of columns in the table of the table design document;
A process in which the SQL statement definition file generating device generates an SQL statement definition file including a dynamic finder SQL statement generated based on the combination of the columns and an INSERT, UPDATE, and DELETE SQL statement;
The data class generation device generates a data class file that is a data class file that is a class representing a correspondence with a table in the O / R mapping used in the data access class and the SQL statement definition file;
The data access class generation device is a class that includes the dynamic finder method name generated based on the combination of the columns, applies the value of the data class to an SQL statement, and operates the SQL statement Processing to generate a data access class file to be a data access class file;
And processing for operating the SQL statement definition file, the data class file, and the data access class file on the O / R mapping of Java.

  As described above, in the present invention, Java productivity can be improved in the field of O / R mapping.

It is a figure which shows one Embodiment of the file generation system of this invention. It is a figure which shows an example of the table design document shown in FIG. It is an example of the information of each column which the table design document reading apparatus shown in FIG. 1 stored. It is a figure which shows an example of an internal structure of the source production | generation control apparatus shown in FIG. It is a flowchart for demonstrating the process in the extraction part shown in FIG. 4 among the file production | generation methods in this form. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder method name, a method name in which column names are connected by AND in the method name generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder method name, a method name in which column names are connected by OR in the method name generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder method name, a method name in which “each column name + [Like / Ge]” is connected by AND in the method name generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder method name, a method name in which “each column name + [Like / Ge]” is connected by OR in the method name generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder SQL statement, a SQL conditional statement in which each column is connected by AND in the SQL statement generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder SQL statement, a SQL conditional statement in which the columns are connected by OR in the SQL statement generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder SQL statement, a SQL conditional statement in which “each column + [LIKE /> =]” is connected by AND in the SQL statement generation unit illustrated in FIG. 4. FIG. 5 is a diagram illustrating an example of a program that generates, as a dynamic finder SQL statement, a SQL conditional statement in which “each column + [LIKE /> =]” is connected by OR in the SQL statement generation unit illustrated in FIG. 4.

  Embodiments of the present invention will be described below with reference to the drawings.

  FIG. 1 is a diagram showing an embodiment of a file generation system of the present invention.

  As shown in FIG. 1, this embodiment includes a table design document reading device 101, a source generation control device 102, a data class generation device 103, a data access class generation device 104, and an SQL statement definition file generation device 105. Has been.

  The table design document reading device 101 reads a table design document 100 which is a design document in which a table is defined in advance.

  FIG. 2 is a diagram showing an example of the table design document 100 shown in FIG.

  As shown in FIG. 2, the table design document 100 shown in FIG. 1 includes a table name “T_TEST”, a logical name, a physical name, a type, a length, a precision, a mandatory, a primary key, and a definition content for each item number (No). Are associated with each.

  The logical name is “user ID”, “user name”, “telephone number (home)”, or the like.

  The physical name is “USER_ID”, “USER_NAME”, “TEL_JITAKU”, or the like corresponding to each logical name.

  The type is “NUMBER”, “VARCHAR2”, “CHAR” or the like corresponding to the logical name and the physical name.

  The length, accuracy, essentiality, primary key, and definition contents are also set in advance.

  Further, the table design document reading device 101 acquires the table name and information on each column from the read table design document 100. Further, the table design document reading device 101 stores (stores) the acquired information on each column in association with the table name.

  FIG. 3 is an example of information on each column stored by the table design document reading apparatus 101 shown in FIG.

  As shown in FIG. 3, the information of each column stored in the table design document reading apparatus 101 shown in FIG. 1 is stored as “Entity Mapping Row” in which variable names, types, and descriptions thereof are associated with each other. This “explanation” corresponds to each item of the design document. This is stored in List <EntityMappingRow> based on EntityMappingRow.

  The source generation control device 102 controls the data class generation device 103, the data access class generation device 104, and the SQL statement definition file generation device 105 based on the combination of the table columns in the table design document 100.

  FIG. 4 is a diagram illustrating an example of an internal configuration of the source generation control apparatus 102 illustrated in FIG.

  As shown in FIG. 4, the source generation control apparatus 102 shown in FIG. 1 includes an extraction unit 1021, a method name generation unit 1022, an SQL sentence generation unit 1023, and an activation unit 1024.

  The extraction unit 1021 extracts a combination of columns from all the columns acquired by the table design document reading apparatus 101. The extraction unit 1021 extracts all combinations of columns that can be combined from all the columns acquired by the table design document reading apparatus 101.

  The method name generation unit 1022 generates a dynamic finder method name based on the column name of each column of the combination extracted by the extraction unit 1021. In addition, the method name generation unit 1022 generates a method name obtained by connecting the column names of each column of the combination extracted by the extraction unit 1021 by AND that is a logical product as a dynamic finder method name. Alternatively, the method name generation unit 1022 generates, as a dynamic finder method name, a method name obtained by connecting the column names of the columns of the combination extracted by the extraction unit 1021 with OR that is a logical sum.

  The SQL statement generation unit 1023 generates a dynamic finder SQL statement based on each combination column extracted by the extraction unit 1021. In addition, the SQL statement generation unit 1023 generates a SQL conditional statement in which each column of the combination extracted by the extraction unit 1021 is connected by AND, which is a logical product, as a dynamic finder SQL statement. Alternatively, the SQL statement generation unit 1023 generates a SQL conditional statement in which each column of the combination extracted by the extraction unit 1021 is connected by OR that is a logical sum as a dynamic finder SQL statement.

  The activation unit 1024 activates the data class generation device 103, the data access class generation device 104, and the SQL statement definition file generation device 105.

  The SQL statement definition file generating apparatus 105 generates an SQL statement definition file 108 including a dynamic finder SQL statement generated based on a combination of columns and an INSERT, UPDATE, and DELETE SQL statement.

  The data class generation device 103 generates a data class file 106 that is a data class file that is used in the data access class and SQL statement definition file 108 and represents a correspondence with a table in O / R mapping.

  The data access class generation device 104 applies the value of the data class including the dynamic finder method name generated based on the combination of columns to the SQL statement, and the data access class of the data access class that operates the SQL statement. A data access class file 107 to be a file is generated.

  Further, the SQL statement definition file 108, the data class file 106, and the data access class file 107 generated in the form shown in FIG. 1 are operated on the O / R mapping of Java.

  Below, the process in the extraction part 1021 shown in FIG. 4 among the file generation methods in this form is demonstrated.

  FIG. 5 is a flowchart for explaining processing in the extraction unit 1021 shown in FIG. 4 in the file generation method according to this embodiment.

  First, a variable n that is the total number of columns and a variable m that is the number of columns to be extracted from the number are initialized (step S1). The possible range of the value of m is (1 ≦ m ≦ total number of columns), and is initialized to “1” in step S1.

  Thereafter, the extraction unit 1021 extracts different m items from different n items.

  After extraction, it is determined whether m is equal to or less than the total number of columns (step S2).

  If it is determined that m is not less than the total number of columns, the process ends.

  On the other hand, when it is determined that m is equal to or less than the total number of columns, it is determined whether or not the number of combinations employed is a value equal to or less than the total number of combinations (step S3). This “adopted combination” will be described later.

  Here, the total number of combinations for extracting different m items from different n items is expressed by a calculation formula for the total number of combinations. Although the total number of combinations is mechanically determined as described above, a specific combination cannot be mechanically determined.

  Therefore, when it is determined that the number of combinations adopted is a numerical value equal to or less than the total number of combinations, m different ones are randomly extracted from n different ones (step S4). Unlike the total number of combinations, this combination cannot be obtained by a calculation formula and is therefore extracted at random.

  Then, it is determined whether or not the same combination as the extracted one already exists (step S5).

  If it is determined in step S5 that the same combination as the extracted one does not exist, that combination is adopted (step S6). Then, the process of step S3 is performed again. This adopted combination is the “adopted combination” described above.

  On the other hand, when it is determined in step S5 that the same combination as the extracted one exists, the combination is discarded (step S8), and the process of step S3 is performed again.

  If it is determined in step S3 that the number of combinations adopted is not a numerical value equal to or less than the total number of combinations, the value of m is incremented (step S7), and the process of step S2 is performed again.

  In this way, an algorithm is implemented that discards the same combination and adopts a different combination until the total number of combinations is reached.

  Based on the combination of columns extracted as described above, a dynamic finder method name and a dynamic finder SQL statement are created.

  FIG. 6 is a diagram illustrating an example of a program that generates, as the dynamic finder method name, a method name in which the column names are connected by AND in the method name generation unit 1022 illustrated in FIG.

  As shown in FIG. 6, a method name in which each column name represented by 6012 is connected by AND by the logic 6011 is generated.

  FIG. 7 is a diagram illustrating an example of a program for generating, as the dynamic finder method name, a method name in which the column names are connected by OR in the method name generation unit 1022 illustrated in FIG.

  As shown in FIG. 7, a method name in which the column names represented by 6022 are connected by OR by the logic 6021 is generated.

  FIG. 8 is a diagram illustrating an example of a program that generates, as the dynamic finder method name, a method name in which “each column name + [Like / Ge]” is connected by AND in the method name generation unit 1022 illustrated in FIG. is there.

  As illustrated in FIG. 8, a method name in which “each column name + [Like / Ge]” represented by 6032 is connected by AND is generated by the logic of 6031. “Ge” is added to the numerical type, and “Like” is added to the others.

  FIG. 9 is a diagram illustrating an example of a program that generates, as the dynamic finder method name, a method name in which “each column name + [Like / Ge]” is connected by OR in the method name generation unit 1022 illustrated in FIG. is there.

  As shown in FIG. 9, a method name in which “each column name + [Like / Ge]” represented by 6042 is connected by OR by the logic of 6041 is generated. “Ge” is added to the numerical type, and “Like” is added to the others.

  FIG. 10 is a diagram illustrating an example of a program that generates, as the dynamic finder SQL statement, a SQL conditional statement in which the columns are connected by AND in the SQL statement generation unit 1023 illustrated in FIG. 4.

  As shown in FIG. 10, an SQL conditional statement in which the columns 7012 are connected by AND is generated by the logic 7011.

  FIG. 11 is a diagram illustrating an example of a program that generates, as the dynamic finder SQL statement, a SQL conditional statement in which the columns are connected by OR in the SQL statement generation unit 1023 illustrated in FIG. 4.

  As shown in FIG. 11, an SQL conditional statement in which the columns 7022 are connected by OR is generated by the logic 7021.

  FIG. 12 shows an example of a program for generating, as a dynamic finder SQL statement, a SQL conditional statement in which “each column + [LIKE /> =]” is connected by AND in the SQL statement generating unit 1023 shown in FIG. FIG.

  As shown in FIG. 12, an SQL conditional statement in which “each column + [LIKE /> =]” represented by 8012 is connected by AND is generated by the logic of 8011. “> =” Is added to the numeric type, and “LIKE” is added to the others.

  FIG. 13 shows an example of a program for generating, as a dynamic finder SQL sentence, a SQL conditional sentence in which “each column + [LIKE /> =]” is connected by OR in the SQL sentence generating unit 1023 shown in FIG. FIG.

  As shown in FIG. 13, an SQL conditional statement in which “each column + [LIKE /> =]” represented by 8022 is connected by OR by the logic of 8021 is generated. “> =” Is added to the numeric type, and “LIKE” is added to the others.

  As described above, the dynamic finder method and the dynamic finder SQL statement are generated. The generated data class, data access class, and SQL statement definition file operate on the iBATIS O / R mapping to realize a dynamic finder function.

  For this reason, on the class side using this, it is possible to use a combination condition (a condition connected by AND or a condition connected by OR) of all the columns of the table to be accessed.

  The present invention can operate on the Java O / R mapping framework. For example, the dynamic finder method and the dynamic finder SQL statement generated by the present invention are suitable for S2Dao O / R mapping.

  As described above, the present invention relates to the field of O / R mapping, and relates to a system for executing an SQL statement related to a dynamic finder.

  As described above, in the present invention, a condition in which combinations of all columns are connected by AND or a condition in which OR is connected is generated. In addition, in consideration of partial matching, [LIKE] and [> =] are used to generate conditions connected by AND and conditions connected by OR. Thereby, a basic access pattern to each table can be used at the start of program implementation. Also, when the contents of each table are changed, the viewfinder method corresponding to the table specification at that time can be used dynamically by performing regeneration. Therefore, it is possible to reduce the development man-hour for data access. Ruby on Rails is generally said to be more productive than Java, but this is largely due to the dynamic finder function of ActiveRecord. In the present invention, the same function as the dynamic finder provided by ActiveRecord in Java is realized, and the problem is solved, thereby bringing about the effect of improving Java productivity.

DESCRIPTION OF SYMBOLS 100 Table design document 101 Table design document reading apparatus 102 Source generation control apparatus 103 Data class generation apparatus 104 Data access class generation apparatus 105 SQL sentence definition file generation apparatus 106 Data class file 107 Data access class file 108 SQL sentence definition file 1021 Extraction part 1022 Method name generation unit 1023 SQL statement generation unit 1024 activation unit

Claims (8)

In a file generation system composed of a table design document reading device, a source generation control device, a data class generation device, a data access class generation device, and an SQL statement definition file generation device,
The table design document reading device reads a table design document in which a table is predefined,
The source generation control device controls the data class generation device, the data access class generation device, and the SQL statement definition file generation device based on a combination of columns of the table of the table design document;
The SQL statement definition file generation device generates an SQL statement definition file including a dynamic finder SQL statement generated based on the combination of the columns and an SQL statement of INSERT, UPDATE, and DELETE,
The data class generation device generates a data class file that is a data class file that is used in the data access class and the SQL statement definition file, and is a class representing a correspondence with a table in O / R mapping
The data access class generation device is a class that includes the dynamic finder method name generated based on the combination of the columns, applies the value of the data class to an SQL statement, and operates the SQL statement. A file generation system for generating a data access class file to be a data access class file. The file generation system according to claim 1,
The table design document reading device acquires a table name and column information from the table design document,
The source generation control device includes:
An extraction unit for extracting a combination of columns from all the columns acquired by the table design document reading device;
A method name generation unit that generates a dynamic finder method name based on the column name of each column of the combination extracted by the extraction unit;
An SQL statement generation unit that generates the dynamic finder SQL statement based on each column of the combination extracted by the extraction unit;
A file generation system comprising: an activation unit that activates the data class generation device, the data access class generation device, and the SQL statement definition file generation device. The file generation system according to claim 2,
The file generation system, wherein the method name generation unit generates, as the dynamic finder method name, a method name obtained by connecting column names of combinations of columns extracted by the extraction unit by AND. The file generation system according to claim 2,
The file generation system, wherein the method name generation unit generates, as the dynamic finder method name, a method name obtained by connecting the column names of the combinations of columns extracted by the extraction unit with OR. The file generation system according to claim 2,
The SQL statement generation unit generates an SQL conditional statement in which the combination columns extracted by the extraction unit are connected by AND as the dynamic finder SQL statement. The file generation system according to claim 2,
The SQL statement generation unit generates, as the dynamic finder SQL statement, an SQL conditional statement in which each column of the combination extracted by the extraction unit is connected by OR. The file generation system according to claim 2,
The extraction unit extracts all combinations of columns that can be combined from all columns acquired by the table design document reading device. A file generation method in a file generation system comprising a table design document reading device, a source generation control device, a data class generation device, a data access class generation device, and an SQL statement definition file generation device,
The table design document reading device reads a table design document in which a table is defined in advance;
The source generation control device controls the data class generation device, the data access class generation device, and the SQL statement definition file generation device based on a combination of columns in the table of the table design document;
A process in which the SQL statement definition file generating device generates an SQL statement definition file including a dynamic finder SQL statement generated based on the combination of the columns and an INSERT, UPDATE, and DELETE SQL statement;
The data class generation device generates a data class file that is a data class file that is a class representing a correspondence with a table in the O / R mapping used in the data access class and the SQL statement definition file;
The data access class generation device is a class that includes the dynamic finder method name generated based on the combination of the columns, applies the value of the data class to an SQL statement, and operates the SQL statement A file generation method comprising : generating a data access class file to be a data access class file.

Images