JP2003280956A5

JP2003280956A5 -

Info

Publication number: JP2003280956A5
Application number: JP2002087220A
Authority: JP
Filing date: 2002-03-26
Publication date: 2005-05-19

Description

【０００８】
【課題を解決するための手段】
上記目的を達成するために、請求項１に係る発明は、プログラム開発に用いるツールである、コンピュータを利用した、データベースＣＡＳＥ装置であって、データベーススキーマ情報を格納したデータベース設計文書ファイルを記憶する手段と、該データベース設計文書ファイルを解析し、データベーススキーマ定義文を自動生成する手段と、データベースアクセス基本クラスライブラリを記憶する手段と、データベースアクセス基本クラスの派生クラスとしてデータベースの各テーブルへアクセスするクラスを生成するためのテンプレートファイルを記憶する手段と、前記データベース設計文書ファイルと前記テンプレートファイルから前記データベースの各テーブルへアクセスするクラスのソースプログラムを自動生成する手段とを備えることを特徴とする。 [0008]
[Means for Solving the Problems]
In order to achieve the above object, the invention according to claim 1 is a database CASE apparatus using a computer which is a tool used for program development, and means for storing a database design document file storing database schema information. And means for analyzing the database design document file and automatically generating database schema definition statements, means for storing the database access basic class library, and classes for accessing each table of the database as derived classes of the database access basic class. means for storing a template file for generating to, Bei and means for automatically generating a class source programs to be accessed from the database design document file and the template file to the table of the database And wherein the Rukoto.

Claims

A database CASE apparatus using a computer, which is a tool used for program development,
A means for storing a database design document file storing database schema information;
A means for analyzing the database design document file and automatically generating a database schema definition statement;
A means for storing a database access base class library;
A means for storing a template file for generating a class for accessing each table of the database as a derived class of the database access basic class;
And a means for automatically generating a source program of a class for accessing each table of the database from the database design document file and the template file.

In the database CASE device according to claim 1,
The means for automatically generating the database schema definition statement includes table constraints of one table, primary key information, index addition information, column definition names, column definition types, column constraints, column common names, and / or column descriptions. A database CASE apparatus characterized by outputting the database schema definition statement collectively or individually for all the tables described in the database design document file based on the stored database design document file.

In the database CASE device according to claim 1 or 2,
The database access basic class is composed of two classes: a class for editing search results of SQL statements and a class for executing SQL statements and a class for processing search results, and the class for editing the search results of the SQL statements is It becomes a base class of the class that accesses each table of the database, and can be adapted to the database access interface of different packages by customizing each member function of the class that processes the execution of SQL statements and the search results. Database CASE apparatus characterized by.

In the database CASE apparatus according to any one of claims 1 to 3,
The template file includes two files of a source template file and a header template file, and each of these template files is a source file of a class for accessing each table of the database generated by the means for automatically generating the source program. And the input file used to output the header file, and the template file is a method to add, update, delete, or search in one table and a table-specific SQL statement creation auxiliary method A database CASE apparatus characterized in that a tag corresponding to information to be embedded is described in a portion in which information specific to each table is embedded and a member function unique to the system can be added.

In the database CASE device according to claim 4,
The means for automatically generating the source program includes a member function for adding, updating, deleting, or searching the template source file in which the tag is described and a template header file to a single table from the template source file and a table-specific SQL statement creation assistant member A database CASE device which automatically generates a source program of a class having a function.