KR100505111B1 - The apparatus and method of creating program source for operating database and the computer program product using the same - Google Patents

Abstract

The present invention relates to an apparatus and method for generating a program source for acquiring information on a database and performing operations on the database. To this end, the program source generating apparatus of the present invention comprises a data storage unit including a CPU and an information file that records information about data. The program source generating method of the present invention using the program source generating apparatus includes connection information of a database. And obtaining source generation control information, collecting metadata of a database, loading a template file, and generating a program source. By using the program source of the present invention generated as described above, a program developer can easily develop a system that executes operations on a database without performing a simple repetitive task.

Description

A device for generating a database source for a database operation, a method thereof, and a computer program product using the same, and the method of the computer program using the same.

The present invention relates to an apparatus and method for generating a program source for performing operations on data of a database by collecting information about a database. More particularly, the present invention relates to a table of a database after collecting a schema of a database by accessing a database. An apparatus and method for generating a class program source and a migration program source that perform basic operations such as searching, inserting, deleting, and changing a view.

All companies in modern society operate large-scale computer systems and use databases containing large amounts of data. A database is a collection of data that is integrated and stored for common use by various application systems of a specific organization, and that is easily accessed, processed, and updated. Such a database provides a storage unit called a table, which is a place to store data in order to store data, and a view, which is a logical table that defines necessary information about one or more tables. It is possible to perform operations such as select, insert, delete, and update.

By applying these basic operations, a task called migration is also performed. Migration refers to the operation of moving data from one database to another database. When operating or developing a system using a database, a migration is required because it requires moving data from an existing database to another database. In particular, if the database structure and the table structure of the database to be moved (hereinafter referred to as the source database) and the database to be moved to (hereafter referred to as the destination database) match, the migration is relatively simple. If the source database and the target database are different from each other and even the DBMS (database management system) is different, the migration task becomes complicated and it is necessary to develop a program for migration.

6 schematically illustrates a process of executing an operation of a database according to a user's request. When the user 7 makes a request to the database 2 for the retrieval, insertion, deletion, update, etc. of specific information on the database 2, the user from the tables and views of the database 2 itself according to such a request. The desired data operation is executed and the result is provided to the user. In order to be provided with this information, the user requests to provide and change the information in the database 2 through a standardized language (Structured Query Language, SQL) to obtain or update the information in the database. After performing the request operation, the result is provided to the user. The program developer 6 codes and provides a program source for database operation.

In particular, today most databases are provided with a database standard library, Java Database Connectivity (JDBC), which refers to the application interface specification for connecting Java programs to common databases. This application program interface changes the database access request statements in SQL form to be passed to the database management system to suit each system, and the processing result is also obtained through a similar interface. JDBC actually consists of two layers of interfaces. In addition to the main interface, there is an application program interface (API) derived from the JDBC "manager", which in turn communicates with the drivers of individual database products.

JDBC defines a set of classes of object-oriented programs that program developers can use to make SQL requests. The JDBC driver API is described in a separate collection of additional classes.

As such, classes defined in JDBC are made through a series of object-oriented programming (OOP), where the class refers to the source that implements an object, which is a logical management unit in such object-oriented programming.

Object-oriented programming identifies all objects and how they relate, then generalizes the identification results into object classes and defines the kind of data the class contains and any logical sequence that can handle them. Thus, in object-oriented programming, classes play an important role and provide the following benefits:

The class concept allows you to define subclasses of objects that share some or all of the main class properties. This object-oriented programming feature, called inheritance, has the effect of ensuring careful data analysis, reduced development time, and more accurate coding. have. Also, because a class only defines relevant data, you cannot touch data used by other programs when an instance of that class is executed. This data hiding feature provides high system security and prevents unintended corruption of data. Class definitions are easily distributed across networks because they can be reused not only by the original program but also by other object-oriented programming. In addition, the class concept allows program developers to arbitrarily define new data types that are not defined in the language.

Because of these advantages, object-oriented programming languages are widely used. Java is one of the object-oriented programming languages designed to be used for distributed applications in corporations and the Internet. Java is not dependent on a specific computer hardware or a specific operating system (OS), and can be executed on any computer system in which a Java virtual machine can be executed. Therefore, an application developed in Java is versatile and compatible. JDBC described above also belongs to the Java language library, and when a program developer codes SQL, the database standard library JDBC will be used. JDBC is not dependent on a specific DBMS and can be used for any DBMS that provides an API driver defined by JDBC.

However, since it is impossible in reality to request or change information required by a user by coding SQL in a JDBC-based database, a system for performing operations on data in the database is developed and used. Therefore, as shown in FIG. 6, the program developer 6 codes and provides a program source necessary for such data operation.

However, in the coding of such program sources, when there are many data storage units to be dealt with, when creating a class for each storage unit, functions such as Set / Get for columns included in each storage unit, and different data for each column Repeat basic functions for each storage unit, such as a function that handles types, a function that manages a list of search results when there is more than one result, a function that performs a search operation, and a function that performs operations such as change, insert, and delete There was a problem that must be made one by one. Therefore, when developers repeatedly code one by one, it becomes very complicated, and there is a big problem that there is a possibility that there is a logical error in the database calculation system.

In addition to these basic operations, when migrating large storage units and migrating between different database systems, it is often impossible to do it manually, and the migration is not continuously performed. Since it is done only once, writing the program for migration by the program developer is inefficient in terms of time and cost.

The present invention is to solve such a problem, by automatically generating a program source for performing a basic operation and migration of the data in the database for the program developer, the program developer to the basic operation and migration operations for the database storage unit In addition to eliminating the need to code the program source for, we want to refer to the database schema to completely eliminate errors that can occur when program developers create work sources.

In addition, the present invention is a program developer program by creating a source of the changed content automatically for the portion that needs to be changed when the schema of the database is changed, when the schema of the database is changed, and all the source of the associated program is changed. We want to reduce development time and eliminate errors completely.

In addition, the present invention additionally provides a program source generation method for migration, so that a program developer can easily move data in an existing database to another database.

In order to achieve the object of the present invention, a program source generating apparatus for performing operations on a database of the present invention performs a data storage unit for storing files necessary for generating a program source, and commands for files of the data storage unit. It includes a central processing unit (CPU). Here, the data storage unit stores a database connection information file for storing connection information for a database, a program source generation information file for storing information necessary for generating a program source, and a predetermined program source for storing a program source based thereon. One or more of a template file for generating a program according to the information, a library file including a library for collecting metadata and generating a program source, and a program source generation information stored in the program source generation information file. A program source file generated by substituting a variable value with a string for said metadata.

In addition, the program source generating apparatus of the present invention may further include a migration information file for executing migration according to the program source generated in the data storage unit.

The program source generation method of the present invention performing an operation on a database includes: obtaining access information of a database, obtaining program source generation information necessary for generating a program source for a database, and collecting metadata of the database; Loading a template file including a predetermined program source necessary for generating a program source, and replacing one or more variable values of a predetermined program source of the template file with a string about metadata according to the program source generation information. Generating.

In the program source generation method of the present invention, the step of obtaining database connection information includes a driver, a URL (uniform resource locator), a user ID, a user password, an initial database connection number, and a maximum database configuration connection. The database connection information may be extracted by loading the database connection information file stored in the form of a script file including the number and the maximum timeout time.

Also, in the program source generation method of the present invention, the step of obtaining program source generation information of the database includes information on the scope and type of the source generation target, the package name, the class name, the sorting of the results, and the structure of the query. The program source generation information may be extracted by loading the program source generation information file stored in the file form.

In the collecting of the metadata in the program source generation method of the present invention, the metadata of the database, the table metadata and the column metadata may be collected, and the metadata may be collected from the database to extract the program source generation information.

The method for generating a program source for migration according to the program source generation method of the present invention includes the steps of: analyzing a script file for migration, generating a program source of a source database according to a program, and destination according to the program. Generating a program source of a database, and generating a program source for mapping a source database program with the target database program.

The computer program product of the present invention includes a series of instructions for executing the program source generation method of the present invention, and may further include a library for providing instructions included in the series of instructions.

Embodiments of the present invention will be described below with reference to the accompanying drawings. The same reference numerals are used for the same parts, and the description is omitted.

1 is a schematic diagram showing the overall concept of the present invention, showing an overview of generating a program source for a database operation of the present invention. As shown in Fig. 1, the program source generator 1 of the present invention is provided with access information about a database and control information necessary for generating a program source from a script file 3, and metadata is provided from a database 2. . The program source generator 1 of the present invention generates the source file 5 by loading the template file 4 and automatically replacing it with the corresponding specific display portion of the template file 4. The generated source file 5 is provided to program developers who use the database to help in coding the programs necessary for the operation of the database. Program developers develop and provide a system for executing a database operation using a program source produced through this process to a user, the user can perform operations on the database using this database operation system.

The above-mentioned metadata refers to a definition or description of data, and refers to more comprehensive or original data including related data or information. The meta data collected by the program source generator 1 of the present invention includes database meta information, table meta information, and column meta information as schema information of a database, and is collected from a database and used for generating a program source. In the present invention, the self-produced library is used to collect metadata from a database. The library is provided to the program source generator 1 of the present invention and used for generating the program source.

In particular, the program source generator 1 of the present invention can be used in any database that supports JDBC, and can be used regardless of the type of OS (operating system). It can also be used in databases that support open database connectivity (ODBC), which makes it very versatile. In particular, since widely used DBMS (Oracle, Informix, MS SQL Server, MySQL) provides a JDBC driver, the program product of the present invention can be used for general purpose DBMS, not dependent on a specific DBMS.

FIG. 2 is a block diagram illustrating a structure of the program generator of FIG. 1 described above. As shown in FIG. 2, the program generator 1 of the present invention includes a CPU (central processing unit) 22 and a data storage unit 24, and includes an input device 21 and a display device 25. Is connected to the CPU 22 receives the information about the data and processes and outputs.

The CPU 22 includes a memory 23 that temporarily stores the calculation result of the generated data, and the data storage unit 24 includes a database connection information file 241, a program source generation information file 242, and a template file. (243), the library file 244 and the generated program source file (243).

Program developers store the IP address, user ID, password, etc. of the database to access the database access information file 241, the program source generation information file 242, which content will be included in the program source to be generated, what storage unit Program source creation information about whether to generate a program source for the program is stored as a script file. The template file 243 is responsible for providing a predetermined program source such as search, insertion, deletion, and change. As described above, the library file 244 stores a library used for collecting metadata of a database, generating a program source, and the like, and the generated program source file 245 stores a database operation program source generated as a result of executing a source generation program. Speak the saved file.

Although not shown in Fig. 2, the program generator 1 of the present invention may also include an information file for migration. The information file for migration contains information when migrating based on basic operations such as searching, inserting, deleting, and changing. The structure of the program generator 1 of the present invention is merely for illustrating the present invention, and the present invention is not limited thereto.

3 will be described in more detail with respect to the overall flow of the present invention. FIG. 3 is an overall flowchart illustrating a method of generating a program source for database operation of the present invention, and illustrates a process of generating a necessary program source by calculating data according to information provided from a database.

Such a method for generating a database operation program source of the present invention generally includes the steps of obtaining necessary information from a script file (S2 and S3), collecting a schema of a database (S4 to S7), and a process related to generating a program source ( S8, S9). The overall process of generating a program source of the present invention will be described in more detail according to each step.

First, as shown in FIG. 3, in step S1, the program is driven to start the whole process of the present invention. After the program is run, in step S2, the database information file is loaded to obtain information about the database connection. This database connection information provides the information necessary for database DBMS connection. DBMS provides limited metadata for the database based on the authority determined by ID.

Next, in step S3, the program source generation control information file is loaded to obtain information necessary for generation of the program source. This information includes the scope and type of program source generation target, package name, class name, sorting of results, and information about the query. Next, collect the schema of the database to operate on the data in the database.

Specifically, in step S4, when the schema for all tables or all views is to be collected according to the program source generation control information, in step S5, name metadata for tables and views of the database is collected. If you want to collect metadata for a specific table or all views in step S6 to collect the primary key or reference key metadata for the desired table and view. When data collection for each table and view is completed, step S7 collects metadata about the columns of these tables and views. The program source generation is repeated in steps S6 to S10 for each of these tables and views.

In step S8, a pre-stored template file is loaded in order to process the collected data. As described above, the template file stores a predetermined program source for executing operations such as searching, inserting, deleting, and changing.

In step S9, the program source is generated by replacing a specific portion of the template file loaded in step S8 with the previously collected metadata based on the program source generation control information.

In step S10, it is checked whether there is another table or view to be processed when generating a program source for all tables or all views. That is, since the names of all tables or all views are taken from the metadata collection of the database, the process proceeds to step S6 again to process one by one of their names. If there are no more tables or views for generating the program source, the program ends in step S11.

Hereinafter, the overall process of the present invention shown in FIG. 3 will be described in more detail.

First, the database connection information loading in step S2 will be described with reference to program list 1 below. Listing 1 shows an example of database connection information. Such data connection information in List 1 is for illustrating the present invention, but the present invention is not limited thereto.

List 1

As coded in Listing 1, the database connection information file includes a driver (line 5), a URL (uniform resource locator) (line 6), a user ID (line 7), a user password (line 8), and an initial file used for the connection. The number of setting database connections (line 9), the maximum settable database connections (line 10), and the maximum timeout occurrence time (line 12) may be described. After accessing the database based on the access information, a program source generation process may be performed.

After receiving the access information, as shown in Listing 2 below, the program source generation control information shown in step S2 of FIG. 3 is taken to set information on the program source generation. The following Listing 2 is for illustrating the program source generation control information file of the present invention, but the present invention is not limited thereto.

List 2

As shown in Listing 2, the source generation control information of the present invention is a script file that describes the control information for program source generation. That is, lines 11 through 21 of Listing 2 specify whether the program source to be generated is related to the entire table, the entire view, one table, and a search query, and lines 37 to 41 are generated. Specify a partial query (Order By clause) that defines how to sort the results when searching from the program source. Also, lines 56 to 64 designate a search query when the program source to be generated is a search query.

After receiving the source generation control information as described above, when the program source to be generated in step S4 of FIG. 3 relates to the entire table or the entire view, metadata of the database is collected in step S5 of FIG. 3. In collecting metadata of a database, collects the names of all tables or all views in the database.

In addition, in step S6 of FIG. 3, the primary key or reference key metadata of the table or view is collected. Table 1 below shows specific examples of such table metadata. Such table metadata is intended to illustrate the invention, but the invention is not limited thereto.

In step S7 of FIG. 3, metadata about a column name is collected. Here, a select * from TableName query is executed against a database to retrieve metadata about the returned result. Table 2 below shows specific examples of such column metadata. Such column metadata is intended to illustrate the invention but is not limited thereto.

Through this process, after collecting metadata about each table, view, and column, a template file is loaded to generate a program source. The template file is a predetermined program source, and basic codes for the generated program source are implemented, and the part to be replaced has a specific mark.

Listing 3 below shows a concrete example of such a template file. Such template files are merely illustrative of the present invention and the present invention is not limited thereto.

List 3

The $ <....> $ part in Listing 3 is replaced by the collected metadata and the information in the program source control information file. In addition, the template file shown in Listing 3 is quite variable and flexible, as the program developer can optionally add specific Java command code. Hereinafter, $ <...> $ of Listing 3 will be described.

$ <CLASSNAME> $ in lines 2 and 5 of Listing 3 replaces the class name, which is replaced by a string consisting of program source control information and a table / view name when generating a program source. Also, $ <GENERATE_DATE> $ in line 2 replaces the date and time when the program source is generated and is replaced by a string formed by extracting the date and time from the system during program execution.

In addition, $ <PACKAGE_STATEMENT> $ in line 11 is replaced with a name of a package to be generated Java program source, which is replaced with a string consisting of information of a program source control information file when generating a program source. $ <TABLE_EXPR> $ in line 25 is replaced with the name of the table or view to be managed. It is replaced with a string consisting of metadata of the table name of the database when the program source is created.

In addition, $ <COLUMN_SIZE> $ in line 27 replaces the number of columns of a table or view to be managed, and is replaced by a string extracted from table metadata information when generating a program source. In addition, $ <COLUMN_INDEX_ STATEMENTS> $ in line 30 replaces a command to give a serial number for each column, and is replaced with a command string to give a serial number to a column name extracted from column metadata when generating a program source. to be.

$ <COLUMN_NAME_STATEMENTS> $ in line 33 replaces the command that defines the constant for the column name for each column. The command string defines the constant for the column name extracted from the column metadata when the program source is created. It is a part to be replaced. In addition, ~ $ <DEFAULT_ORDER_BY> $ ~ in line 36 replaces a string specifying a partial query (Order By clause) that defines how to sort the results when performing a search operation on the generated program source. Replaced with a string consisting of the information in the program source control information file.

$ <COLUMN_SET_VALUE_STATEMENTS> $ in line 42 replaces the command to create a column class for each column. A string consisting of the data type and primary key information of the column extracted from the table metadata and column metadata when the program source is created. Is replaced with. In addition, $ <GET_SET_STATEMENTS> $ in line 49 replaces the implementation of Set / Get method of each column's value, and is a string consisting of the serial number and Java command of the column defined from the column metadata when the program source is generated. Is replaced with. In addition, $ <IS_ONLY_QUERY_METHODS> $ in line 55 is replaced with a command to execute a search query when the generated program source is related to a search query, and is replaced with a string consisting of information of a program source control information file when the program source is generated. to be.

In the following, such a substitution operation is performed, and a method of generating a program source including metadata collection will be described in more detail.

4A through 4C are detailed flowcharts illustrating a method of generating a program source including metadata collection, and illustrating a method of generating a program source for all tables in a database. The program source generating method of FIGS. 4A to 4C is largely composed of a name setting step, a metadata collecting step, a string replacement step, and a file generation step. The program generation process of the present invention is for illustrating the present invention, and the present invention is not limited thereto.

In step S401, the whole process of the present invention begins. In step S402, the database is accessed. Next, in step S403, metadata about the names of all the tables existing in the database is collected. In step S404, the database is disconnected. After disconnecting the database, in step S405, the name of the package received from the program source control information of the script file is set. If there are no more tables in step S406, the process ends (S407). If the table further exists, the process proceeds to step S408.

The process of steps S409 to S437 is repeated for each collected table name.

First, in step S408, the name of the collected table is set, and the class name is set using the string and the table name received from the program source control information of the script file (S409). Next, access to the database again (S410), and collect the table metadata information (S411). For example, in the table metadata information, there is information about a primary key and a key referenced in another table among the primary keys. In step S412, column metadata information is collected. The column metadata information includes, for example, the number of columns, column names, column data types, and the like. In this way, after collecting metadata information about the table, the database is disconnected (S413).

For the template file loaded in step S414, first, the current time of the system is provided to replace the generation date / time part of the template file (S415). Next, in step S416 of FIG. 4B, the package name portion of the template file is replaced by the set package name, in step S417, the class name portion of the template file is replaced by the set class name, and in step S418, the table is set. The table name portion of the template file is replaced by the name, and in step S419, the column number portion of the template file is replaced by the number of columns of the column information.

In step S420, if there are more columns, the column index string to be used in the program source is generated by repeating the number of columns (S421). Here, the column index means assigning a serial number from 0 to a column. Through this process, in step S422, the column index portion of the template file is replaced with the column index string.

In step S423, if there are more columns, the column variable string to be used in the program source is generated by repeating the number of columns (S424). Next, in step S425, the column variable portion of the template file is replaced with the column variable string. Thereafter, in step S426, the default sorting method portion of the template file is replaced with a default ordering string received as a user's input.

In step S427 of FIG. 4C, if there are more columns, a string for creating a column class is generated by repeating the number of columns in step S428, and in step S429, a primary key for the column when the column is a primary key. Create a string to set the information. Next, the primary key for the column is set (S430), and a string for registering the column in the column list of the table class is generated (S431).

Next, the column information setting method portion of the template file is replaced with the column information setting method string (S432). If the column is not the primary key in step S429, the process proceeds to the string generation step of registering the column in the column list of the table class in step S431.

Next, in the case where additional columns exist, in step S433, the number of columns is repeated to generate a get / set method string for each column in step S434. Subsequently, in step S435, the Get / Set method for each column of the template file is replaced with the column Get / Set method string, and in step S436, a file name to be generated as a class name is set. In step S437, the substituted template file is output to the program source file. Through this process, the program source of the present invention can be generated.

In addition to performing the basic operation as described above, the present invention additionally generates a program source for executing the above-described migration. The present invention provides a migration program source generation method as described above, and provides a migration program source generation method which is a kind of application program by adding a mapping function to the above-described basic operation program source.

5 is a flowchart illustrating a program source generation procedure capable of executing a migration task in the present invention.

In step S51, the program developer creates a script file for migration. Especially when user-defined functions are needed, program developers implement them. The user defined function is a functional implementation of the program developer's logical refinement process during the migration process.

For example, if two or more columns of one table in a source database need to be moved to one column of one of the tables in a target database, the program developer needs to specify how two or more columns are merged into one. In this case, the program developer can specify in some way the match and implement it as a function.

As another example of a user-defined function, there is a case where one column value needs to change as one column value is moved to the target database, such as '1' to 'a' and '2' to 'I'. In such a case, the program developer must provide the change as a function.

Subsequently, in step S52, a program developer inputs a script file for migration to drive a source generation program, and the source generation program analyzes the script file (S53). Thereafter, in step S54 and step S55, program sources of the source database and the target database are generated, respectively. Next, a mapping function program source to connect the program source of the source database and the target database is generated (S56).

The mapping function is to move data as defined by reading the part defining which column data in a table of the source database is moved to which column of a table of the destination database. There are two mapping methods, one of which is a 1: N mapping, in which one table of the source database is specified and one or more tables in the destination database are designated and migrated. The other is a query mapping. When a result of executing a search query is migrated to one or more tables in the target database.

Table 3 shows the information that must be specified in the script file for the migration.

Listing 4 below shows an example of coding such a migration program source of the present invention. Such a program source is for illustrating the present invention, and the present invention is not limited thereto.

List 4

Listing 4 exemplifies a process of generating a migration program source through a mapping process based on a source database and a target database generated based on the basic operation program source as described above.

First, information about the source database is coded in lines 19 to 22 of Listing 4. For the source database, first specify the JDBC driver to use to connect to the source database (line 19), specify the JDBC URL to use to connect to the source database (line 20), and the user ID to use to connect to the source database (line 20). Line 21) and the user password (line 22) used to connect to the source database.

Since we need to move these source databases to the target database, we will code for the target database next. First, specify the JDBC driver used to connect to the target database (line 32), specify the JDBC URL used to connect to the target database (line 33), and the user ID (line 34) and destination used to connect to the target database. Code the user password (line 35) used to connect to the database.

Once the configuration for these destination and source databases is complete, complete the migration for the database by running 1: N mapping or query mapping.

First, in case of 1: N mapping, the source table name (line 59) and the target table name (line 60, 61) are coded.On the left side of the equal sign (=) in lines 63 to 70, the column name of the object table (SNMPDATAEQUIP) On the right side, the column name of the source table is coded. In addition, the column names of the object table SNMPPOOLEQUIP are coded on the left side of the equal sign (=) in lines 71 to 77, and the column names of the source table on the right side, and a user-defined function snmpver () is defined when mapping (line 70).

In the case of query mapping, the search query from the source database (lines 101 and 102) and the target table name (line 104) are coded. Codes the name of the search query column in the source database.

Through this process, program source for migration can be created.

As described above, in the present invention, by creating a class source according to a table and a view of a database and providing an environment in which a database operation can be performed using this class, a system development period is shortened to a system developer using a database. It has the advantage of reducing the error of the program.

As a result, a program developer can easily develop a program source for data operation of a database, thereby significantly reducing the time and cost required to generate a program source, compared with the conventional simple work.

In addition, in the present invention, when the schema of the database is changed, the method of changing the source of all related programs is avoided, and when the schema of the database is changed, the source of the changed contents is automatically generated by generating the source of the changed contents. Shorten program development time and eliminate errors completely.

In addition, the present invention additionally provides a migration program source generated through the migration program source generation method, so that a program developer can compile and use the generated program source immediately without additional development work for migration.

Although the present invention has been described above, it will be readily understood by those skilled in the art that various modifications and variations are possible without departing from the spirit and scope of the claims set out below.

1 is a schematic diagram showing the overall concept of the present invention.

2 is a block diagram showing a program source generating apparatus of the present invention.

3 is an overall flowchart illustrating a method of generating a program source of the present invention.

4A to 4C are flowcharts detailing the method of generating a program source of the present invention.

5 is a flowchart showing a program source generation procedure of the present invention for executing a migration task.

6 is a diagram schematically illustrating a process of executing an operation of a database according to a user's request.

<Description of the symbols for the main parts of the drawings>

1. Program source generator 2. Database

3. Script file 4. Template file

5. Source File 6. Program Developer

7. User 22. Central processing unit (CPU)

23. Memory 24. Data storage unit

241. Database connection information file 242. Program source creation information file

243. template file 244. library file

245. Generated program source file

Claims (9)

A program source generating device that performs an operation on a database, A data storage unit for storing files necessary for generating a program source; A central processing unit (CPU) that executes instructions for the files of the data storage unit, The data storage unit, A database access information file for storing access information for the database; A program source generation information file for storing information necessary for generating the program source; A template file for storing a predetermined program source and generating the program according to information necessary for generating the program source based on the preset program source, A library file that collects the metadata and includes a library applied to the program source generation; A program source file generated by replacing one or more variable values of the template file with a string related to the metadata according to the program source generation information stored in the program source generation information file Program source generating device comprising a. In claim 1, And the data storage unit further comprises a migration information file for executing migration according to the generated program source. Program source generation method that performs operations on a database. A program source generator fetching access information of the database, Obtaining, by the program source generator, program source generation information necessary for generating a program source for the database; Collecting metadata of the database by the program source generator; Loading, by the program source generator, a template file including a preset program source required for generating the program source; Generating, by the program source generator, a program source by replacing one or more variable values of the preset program sources of the template file with a string related to the metadata according to the program source generation information; Program source generation method comprising a. In claim 3, The step of obtaining the connection information of the database by the program source generator may include a driver, a uniform resource locator (URL), a user ID, a user password, an initial database connection number, and a maximum database connection number. And extracting the database connection information by loading the database connection information file stored in the form of a script file, including a maximum timeout occurrence time. In claim 3, The step of obtaining the program source generation information by the program source generator includes information on the range and type of the source generation target, the package name, the class name, the sorting of the results, and the structure of the query, which are stored in the form of a script file. Program source generation method for extracting the program source generation information by loading the program source generation information file. In claim 3, The collecting of the metadata by the program source generator may include collecting metadata, table metadata, and column metadata of the database, and extracting program source generation information by collecting the metadata from the database. Way. In claim 3, Program source generation method using the program source generation method for generating a program source for migration. A computer program product comprising a series of instructions for performing a method according to any one of claims 3 to 7. In claim 8, And a library for providing instructions included in the series of instructions.