CN101046812A - Method of data base table recording structure and detection and its device - Google Patents
Method of data base table recording structure and detection and its device Download PDFInfo
- Publication number
- CN101046812A CN101046812A CN 200610083951 CN200610083951A CN101046812A CN 101046812 A CN101046812 A CN 101046812A CN 200610083951 CN200610083951 CN 200610083951 CN 200610083951 A CN200610083951 A CN 200610083951A CN 101046812 A CN101046812 A CN 101046812A
- Authority
- CN
- China
- Prior art keywords
- field
- database table
- configuration file
- order
- value
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a database table record automatic structure and examination method and its equipment. Said method includes the following steps: obtaining user' s input information form operation command, then ealling configuration file, combining user' s input information with configuration file to form SQL statement an implementing operation for database table record structure or examination. Said equipment includes device for receiving operation command information, device for searching configuration file, device for forming SQL command, device for executing said command and device for storing said configuration file.
Description
Technical field
The present invention relates to a kind of database technology, particularly to the method and apparatus of data base table recording structure and inspection.
Background technology
A large amount of ool instruction language scripts that adopt carry out automatic test in the current operation software product.Direct application structure query language SQL statement execution INSERT and SELECT order and construct and the look-up table record in automatic test script.The SQL statement form is: DBSQL SCUDB " insert into table name (field 1, field 2 ...) values (field 1 value, field 2 values ...) "; The set temporary table [DBSQLSCUDB " select field 1, field 2 ... from table name where condition "].In SQL statement, must strict order of the field insert each field value of whole fields during the structure table record by the list structure definition, if do not import whole field values, may when writing down, look-up table make mistakes; Compare field name during the look-up table field value one by one, till finding.All must write SQL statement again and generate complicated script command when each structure of user or look-up table record.
In the automatic test course of software, often to check to the increase of the database table in the database in software product record or to each field value of table record, special complex structure at database table, Field Count is above 100, and under the situation that the default value of these fields often changes with version, automatized script just becomes complicated and loaded down with trivial details when structure table record or look-up table field value, and script is readable poor; If field name does not have the corresponding tables structure, value is dislocation easily, and all will pay close attention to the unconcerned field value of user at every turn.Data check is not comprehensive, can't check that the user does not have the value of input field, causes the insufficient test leakage problem that causes of test easily; Correspondingly write and safeguard the script difficulty, if literary name section or field value change, the script of structure table record must upgrade otherwise can't reuse, its very flexible, and the test effect is undesirable and cost is higher.
Summary of the invention
The invention provides a kind of structure of data base table recording and the method for inspection, exist complicated operation loaded down with trivial details when utilizing prior art in comparatively complicated database table, to increase record in order to solution, and the problem of makeing mistakes easily; Further solve in the software product automatic test course, there are complex operation in structure and inspection record, make mistakes and the problem of very flexible easily in database table.
The present invention separates the list structure field of database table and default value thereof to put into configuration file and unify centralized management and safeguard, insertion and inspection to table record provide unified interface command, call configuration file by interface command, form SQL statement and realize the insertion of table record and the operation of inspection.More new configuration file gets final product when list structure changes, and it is less to change script.
The invention provides a kind of method of constructing table record, these method concrete steps are:
A, from operational order, obtain the database table sign that needs operation, need be by the field name and the designated value thereof of user's assignment.
B, call corresponding configuration file, comprise all fields and the corresponding default value of described database table in this configuration file according to described database table sign.
C, from described configuration file, obtain unspecified field in the operational order and corresponding default value, and with its with operational order in the field and the respective value of appointment press order of the field generation insertion statement in the database table.
D, the described insertion statement of execution generate record in database table.
The method of structure table record also can comprise step:
Before generate inserting order, further judge the field that whether includes in the field of configuration file in the operational order, if, execution in step C then, otherwise end process flow process.
The invention provides a kind of device of constructing table record, this device comprises receiving trap, searches device, command device, actuating unit and memory storage.
Memory storage is used for store configuration files, includes all fields and the corresponding default value of database table in the described configuration file.
Receiving trap is used for obtaining from operational order the database table sign of input, and field name and respective value thereof are imported the operational order appointed information into and searched device.
Search device, be used for calling the corresponding configuration file of memory storage according to described database table sign.
Command device is used for searching the configuration file that device finds and obtaining unspecified field and corresponding default value the operational order from described, and with its with operational order in the field and the respective value of appointment press order of the field generation insertion statement in the database table.
Actuating unit, the operation that the database of command execution in memory storage that is used for generating according to command device inserts a table record.
The device of described structure table record also comprises:
Error Detection Unit was used for before generate inserting order, further judged all fields that whether include in the field of configuration file in the operational order, if, startup command device then, otherwise finish the device operation.
The invention provides a kind of method of checking data base table recording, these method concrete steps are:
A, from operational order, obtain the database table sign, the field name of user's appointment and the corresponding desired value that need operation.
The database table field generated query order that B, utilization are obtained.
C, the described querying command of execution are realized look-up table record from database, and acquisition needs the value of the field of inquiry.
The value of D, the field that will obtain from database table compares with corresponding desired value, finishes the operation of look-up table record.
The method of described inspection data base table recording, taking a step forward at execution in step B comprises step:
A1, judge whether the user needs to check all fields, if, then carry out steps A 2, otherwise, carry out step B.
A2, call the configuration file of all fields that comprise this database table according to described database table sign, therefrom unspecified field and corresponding default value in the read operation order, and with default value as desired value, continue step B.
The method of described inspection data base table recording also can comprise step:
Before the generated query order, further judge all fields that whether comprise in the field of configuration file in the operational order, if, execution in step B then, otherwise end process flow process.
The invention provides a kind of testing fixture of data base table recording, this device comprises receiving trap, command device, actuating unit, comparison device and memory storage;
Memory storage is used for store configuration files, includes all fields and the corresponding default value of database table in the described configuration file;
Receiving trap is used for obtaining from operational order the database table sign of input, field name and corresponding desired value;
Command device, the field generated query order that is used for inquiring about as required;
Actuating unit is used for the querying command that the fill order device generates, and searches required table record to obtain the value of specific field correspondence in described data of database table;
Comparison device, the value that is used for field that described actuating unit is obtained is compared with corresponding desired value.
The device of described inspection data base table recording also comprises:
Search device, be used for calling corresponding configuration file from described memory storage according to described database table sign, when the user need check all fields, from configuration file, obtain unspecified field that other need be inquired about and default value in the described operational order, and send field to command device, with the default value of field as desired value.
Error Detection Unit was used for before the generated query order, further judged the field that whether includes in the field of configuration file in the operational order, if, startup command device then, otherwise finish the device operation.
Beneficial effect of the present invention is as follows:
1, realize test script logical and data separating, the test script data centralization is safeguarded, greatly strengthens the reuse capability of script.
2, all data base table recordings insert and check the simple unified interface function of employing, have hidden the complicated processes that forms SQL statement, make script simpler, are easy to safeguard.
3, the user's field information that only need import concern can insert a record, reduces input quantity and error rate.
Field name was corresponding one by one with its value when 4, data base table recording inserted with inspection, had increased the readability of script, and field name has been carried out validity checking, avoided occurring rudimentary SQL statement mistake.
5, data check more comprehensively, more flexible.The user only need import table field name and the desired value that will check can realize only checking the field of importing, and also can be fit to the inspection of big database table with default value as other field value in the desired value look-up table.
6, set up the automatic test environment automatically, reduced the building amount of test data environment.
Description of drawings
Fig. 1 is the installation drawing of structure table record among the present invention;
Fig. 2 is database table structure record schematic flow sheet among the present invention;
Fig. 3 is the installation drawing of look-up table record among the present invention;
Fig. 4 checks schematic flow sheet for data base table recording among the present invention.
Embodiment
In order to solve in the prior art database table for complexity, problems such as the complicated operation that user's input quantity causes greatly is loaded down with trivial details and make mistakes easily, the present invention separates the list structure field and the default value thereof of database table from database, put into configuration file, unifies centralized management and safeguards; When database was inserted recording operation, the user only provided the digital library field and the corresponding value of care, and system reads all the other fields and default value generation insertion order automatically and finishes the insertion recording operation from configuration file.Accordingly, the field that can also utilize configuration file that the user is provided is carried out the mistake inspection and data base table recording is checked.
Present embodiment with in the software automated testing process in the table of database the structure and inspection record be that example describes.
For the maintenance and operation convenience, set up corresponding configuration file according to the list structure field and the default value thereof of each database table in the present embodiment, the method for making of configuration file is: definition list structure at first when setting up database, the default value of while named list field, use present prior art that the list structure of the database table in the target database is exported to text by following form, i.e. configuration file.Because tool using is derived, thus the list structure in the configuration file in strict accordance with the content of database table, field name is corresponding one by one with its value, and in strict accordance with the list structure series arrangement.The form of configuration file is as follows:
Table name 1
(
Field name 1=default value
Field name 2=default value
Field name 3=default value
……
)
Table name 2
(
Field name 1=default value
Field name 2=default value
Field name 3=default value
……
)
……
For example:
transfer_cfg
(
scallingnoidx＝-1
scardtypeidx＝-1
scardtypeidx2＝-1
sservicelevel＝0
sservicelevel2＝0
scardtype＝0
scardtype2＝0
nservicekey＝230
stransfercond＝0
stransfercond2＝0
ntransferlinit＝200
ntransferlinit2＝200
sbountytfflg＝0
smodiresperiodflg＝0
stransferpartflg＝0
stransinorout＝1
saccumifflg＝0
sbountytfmode＝0
stransopenflg＝0
useridentifier＝-1
sifbindtransflag＝0
nfixextendtime＝0
)
tcppro_trans
(
useridentifier＝-1
saccountnumber＝0
scallingnumber＝-1
nservicekey＝230
……
)
By the defining interface function, the operation of writing down realized inserting in encapsulation SQL INSERT statement in database table in this function in the present embodiment.This function at first reads in the database table field and the corresponding designated value of user's input, from configuration file, read in the whole field names and the default value thereof of database table then, be combined into new tabulation from the information of two channels according to the structure of database table and pass to the INSERT statement, carry out this insertion order and realize inserting a record to database table.
Be used to insert the function AddTableRecord by name of the function of record in the present embodiment, comprise parameter errinfo, tablename and args, wherein errinfo is the error message return parameters, be used for script command, tablename represents table name, args is a variable element, the field name and the value list thereof of the data base table recording that desire is inserted.
Referring to Fig. 1, in the present embodiment a kind of device that can realize the constructs database table record comprise receiving trap 101, search device 102, Error Detection Unit 103, command device 104, actuating unit 105 and memory storage 106.
Memory storage 106 is used for store configuration files and database etc., includes all fields and the corresponding default value of database table in the described configuration file, and this device can be memory devices such as floppy disk, hard disk, tape.
Receiving trap 101 is used for obtaining from operational order the database table sign of input, and field name and corresponding value are passed to input information then and searched device 102.
Search device 102, be used for calling configuration file corresponding the memory storage 106, reading database literary name section according to the database table sign of obtaining from described operational order.
Error Detection Unit 103, whether the field that is used for further judging configuration file comprises all fields in the operational order, if then the startup command device 104, otherwise finishes the device operation.
Command device 104, be used for searching the configuration file that device 102 finds and obtaining unspecified field and corresponding default value the operational order from described, and with its with operational order in the field and the respective value of appointment press order of the field generation insertion statement in the database table.
Actuating unit 105, the operation that the database of insertion command execution in memory storage 106 that is used for generating according to command device 104 inserts a table record.
Be described in detail below in conjunction with in database table, inserting record in 1 pair of present embodiment of example:
Example 1, function AddTableRecord by name.The user wishes to insert a record in database table User_info, and requiring field Username is John, and Account is 13500011188, and all the other field users are indifferent to, and this table comprises 150 fields, and list structure is as follows:
User_info
(
Userid＝001
Username＝A
Account＝0
Useradd＝0
Annotate: totally 150 fields
)
Referring to Fig. 2, realize in the present embodiment that the method flow of constructs database table record is as follows:
Step 210: the database table name is provided, needs the field name and the designated value of assignment, carry out the operational order of calling interface function.Described operational order can be imported by the user, the order that is comprised in also can current executive routine.
For example 1, table name User_info is replaced parametric t ablename, will insert data Username, John, Account, 13500011188 correspondingly replaces args, form is: Username=John, Account=13500011188, out-of-order requirement between the field.
Step 220: this function finds corresponding list structure according to passing the table name that advances in configuration file, obtain all field names and default value thereof.In the example 1, in configuration file, find 150 field names and default value thereof by table name User_info.
Step 230: field name by the parameter transmission and the field name that from configuration file, obtains comparison, check whether correct, if incorrect then jump out this function, if correctly then enter step 240.
This step is intended to just checking out before the database manipulation whether the user imports wrong, if there is not this step, could find mistake in the time of then must waiting until step 260, and has carried out process from data to database that insert this moment.In the example 1,,, then enter step 240 if in 150 field names, can find Username and Account with field name Username and Account and 150 field name comparisons; If it is wrong having one among Username and the Account at least, then finish this function.
Step 240:, form tabulation newly by with the information combination in user's input information and the configuration file.
A kind of preferable mode is that the field name by the parameter transmission is finding corresponding position from this database table configuration file, replaces default value in the former list structure with the value of parameter transmission, constitutes tabulation newly.In the example 1, replace default value A at field name Username place with John, replace default value 0 at field name Account place with 13500011188, new tabulation is:
User_info
(
Userid＝001
Username＝John
Account＝13500011188
Useradd＝0
Annotate: totally 150 fields
)
Step 250: new list information is passed to the INSERT order.
Step 260: carrying out this insertion order increases data recording in database.Can turn back to beginning if insert failure, insert table record again.
Return results during end, inserting successful return results is 0, mistake returns 1.
Script command included only parameter and passed into data this moment, did not comprise the data in the configuration file.In the example 1, script command is AddTableRecord errinfo user_info " Username=' John ' " " Account=' 13500011188 ' ".
Whether correct in order to check the table record that the user inserts in database, when database is carried out checked operation, the user only provides the digital library field and the corresponding desired value of care, system calls query statement automatically and search corresponding table record from database table, if the user need search complete table record, system reads all the other fields and default value automatically and offers query statement from configuration file, the data base table recording and the desired value that find are compared, finish the operation of look-up table record.
Accordingly, present embodiment realizes checking the operation of data base table recording by the defining interface function.Function at first reads in user's input information, reads in the field name of database table then by configuration file, checks whether user's input field name is correct.The field name that utilizes the user to import finds data by the SELECT statement in database, checking process is finished in the desired value comparison of these data and user's input.
Function is called CheckTableValue in the present embodiment, comprise parameter errinfo, ischeckall, tablename, filterstr and args, wherein errinfo is the error message return parameters, be used for script command, ischeckall is used for judging whether by all field values of default value look-up table, tablename represents table name, filterstr is a where conditional parameter in the SQL statement, be used to filter fox message, args is a variable element, the field name of the data base table recording that desire is checked and desired value tabulation thereof, the desired value of each field uses " | " to separate when needs are checked many records.
Referring to Fig. 3, can realize in the present embodiment that the device of table record inspection comprises: receiving trap 301, search device 302, Error Detection Unit 303, command device 304, actuating unit 305, comparison device 306 and memory storage 307.
Memory storage 307 is used for store configuration files etc., includes all fields and the corresponding default value of database table in the described configuration file, and this device can be memory devices such as floppy disk, hard disk, tape.
Receiving trap 301 is used for obtaining from operational order the database table sign of input, field name and corresponding desired value, and querying condition.This desired value is thought the value that should store in the database table for the user.
Search device 302, be used for from described memory storage 307, calling corresponding configuration file according to the database table sign of obtaining from described operational order, from configuration file, obtain unspecified field that other need be inquired about and default value in the described operational order, and send field to command device 304, with the default value of field as desired value.
Error Detection Unit 303, whether the field that is used for further judging configuration file comprises all fields in the operational order, if then the startup command device 304, otherwise finishes the device operation.
Command device 304, the field generated query order that is used for inquiring about as required.
Actuating unit 305 is used for the querying command that fill order device 304 generates, and searches required table record to obtain the respective value of operational order specific field in described data of database table, and the respective value of literary name section is sent into comparison device 306.
Comparison device 306, the value that is used for the field that will obtain from described actuating unit 305 compares with the corresponding desired value of obtaining from operational order, finishes the inspection to data base table recording.
Below in conjunction with checking in 2 pairs of present embodiments of example that data base table recording is described in detail:
Example 2, function is called CheckTableValue.The user wishes that from database table User_info inquiry field Accountid value by name is 20050223 record, whether the value of checking field Username is John, whether the value of field Account is 13500011188 or 13511111188, this table comprises 150 fields, and other field value is indifferent to.Temporary table tmpdbretrunlist put in the record of getting, from tmpdbretrunlist, isolate the value of Username and Account and put into variable curname and curcount, utilize above-mentioned two variablees and desired value to compare, realize inspection table record.
This table configuration file content is:
User_info
(
Userid＝001
Username＝A
Account＝0
Useradd＝0
Annotate: totally 150 fields
)
Referring to Fig. 4, check in the present embodiment that the flow process of data base table recording is as follows:
Step 410: field name and the desired value that provide the database table name, need check, carry out the operational order of calling the interface function of checking data base table recording.
In the example 2 table name User_info is replaced parametric t ablename, to check that data Username, John, Account, 13500011188,13511111188 correspondingly replace args, form is Username=John, Account=13500011188|13511111188, out-of-order requirement between the field.
Step 420: function finds corresponding list structure according to passing the table name that advances in configuration file, obtain the title of all fields.In the example 2, in configuration file, find 150 field names by table name User_info.
Step 430: field name by the parameter transmission and the field name that from configuration file, obtains comparison, check whether correct, if incorrect then jump out this function, if correctly then enter step 440.
This step is intended to just checking out before the database manipulation whether the user imports wrong, if there is not this step, could find mistake in the time of then must waiting until step 480, and has carried out the process to the data base querying data this moment.In the example 2,,, then enter step 440 if in 150 field names, can find Username, Account and Accountid with field name Username, Account and Accountid and 150 field name comparisons; If it is wrong having one among Username, Account and the Accountid at least, then finish this function.
Step 440: judge whether to check for parameter ischeckall by assignment and all fields in the database table, then enter step 441 if check all fields.If do not need to check other field, then enter step 450.Parameter ischeckall value is 0 not to be needed to judge, is that 1 needs is judged.In the example 2, the user only is concerned about two fields, and all the other are not paid close attention to, and is 0 for parameter ischeckall assignment then, and skips steps 441 directly carry out step 450.
Step 441:, form tabulation newly by with the information combination in user's input information and the configuration file.Present embodiment provides a kind of preferable scheme to be: the field name by the parameter transmission finds corresponding position in the list structure that obtains from configuration file, replace default value in the former list structure with the desired value of parameter transmission, the default value of other field constitutes tabulation newly as desired value in the table.In the example 2, replace default value A at field name Username place with John, replace default value 0 at field name Account place with 13500011188 and 13511111188, new tabulation is:
User_info
(
Userid＝001
Username＝John
Account＝13500011188|13511111188
Useradd＝0
Annotate: totally 150 fields
)
Step 450: the table name and the field name of user's input are passed to the SELECT statement, can obtain field name in the configuration file from step 441 in case of necessity.In the example 2, parameter f ilterstr is replaced by Accountid=20050223, and the SELECT statement is: set tmpdbretrunlist[DBSql SCUDB " selectUsername, Account from User_info where Accountid=20050223 "]
Step 460: fill order obtains the data base table recording that user's desire is checked from database.
Step 470: compare the desired value that this desired value can be imported for the user or comprised the default value in the configuration file by record and desired value that order obtains from database.In the example 2, the value of Username and Account is separated from tmpdbretrunlist, put into variable curname and curcount, order to be: separate_list$tmpdbretrunlist 0 curname curcount; The table record value and the desired value that obtain are compared.
Step 480: whether inspection record is consistent with desired value.If unanimity then function finish, if inconsistent then carry out step 490.Error situation has two kinds, and the one, record is inconsistent with the desired value of user's input; The 2nd, when wishing to check all fields, owing to other field desired value replaces with default value, and a field value or several field value in the record are non-default value, cause the result to make mistakes, and in fact the desired value of user's input is consistent with record value.Both of these case is handled in step 490.
Step 490: generation error information, function finishes.
Return results during end if inspection record all correctly returns 0, exists mistake to return 1.
Script command included only parameter and passed into data this moment, did not comprise the data in the configuration file, and filtering information is controlled by parameter f ilterstr.In the example 2, script command is CheckTableValue errinfo YESuser_info " Username=' John ' " " Account=13500011188 ".
Above-mentioned function name and parameter thereof can define voluntarily according to actual conditions, and function name and parameter name and value only are usefulness for example in the present embodiment.
Press the configuration file that database table structure generates owing to adopt, guaranteed the succession and the consistance of list structure.Provide unified interface function by structure and inspection for data base table recording, encapsulated SQL statement, the database manipulation order is finished automatically by function, reduced user's input quantity and to the direct control of database, improve the security of system, simplified script command simultaneously, strengthened the readability and the reuse capability of script, be easy to safeguard, save cost.
Obviously, those skilled in the art can carry out various changes and modification to the present invention and not break away from the spirit and scope of the present invention.Like this, if of the present invention these are revised and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these changes and modification interior.
Claims (15)
1, a kind of table record building method of database table is characterized in that,
A, from operational order, obtain the database table sign that needs operation, need be by the field name and the designated value thereof of user's assignment;
B, call corresponding configuration file, comprise all fields and the corresponding default value of described database table in this configuration file according to described database table sign;
C, from described configuration file, obtain unspecified field in the operational order and corresponding default value, and with its with operational order in the field and the respective value of appointment press order of the field generation insertion statement in the database table;
D, the described insertion statement of execution generate record in database table.
2, data base table recording structure method as claimed in claim 1 is characterized in that, described operational order can be the order that comprises in the current executive routine, also can be user input commands.
3, data base table recording structure method as claimed in claim 1 is characterized in that, in configuration file, is arranged in order field according to the structural order of the database table field of correspondence.
4, data base table recording structure method as claimed in claim 1 is characterized in that, described database table is designated table name.
5, as each described data base table recording structure method of claim 1 to 4, it is characterized in that, before generating the insertion order, further judge all database table fields that whether include in the field of configuration file in the operational order, if, execution in step C then, otherwise end process flow process.
6, a kind of method of checking data base table recording is characterized in that,
A, from operational order, obtain the database table sign that needs operation, the field name of user's appointment and corresponding desired value;
The database table field generated query order that B, utilization are obtained;
C, the described querying command of execution are realized look-up table record from database, and acquisition needs the value of the field of inquiry;
The value of D, the field that will obtain from database table compares with corresponding desired value, finishes the operation of look-up table record.The operation of table record.
7, the method for data base table recording inspection as claimed in claim 6 is characterized in that described operational order can be the order that comprises in the current executive routine, also can be user input commands.
8, the method checked of data base table recording as claimed in claim 6 is characterized in that, in configuration file, is arranged in order field according to the structural order of the database table field of correspondence.
9, the method for data base table recording inspection as claimed in claim 6 is characterized in that described database table is designated table name.
10, the method for checking as each described data base table recording of claim 6 to 9 is characterized in that taking a step forward at execution in step B comprises step:
A1, judge whether the user needs to check all fields, if, then carry out steps A 2, otherwise, carry out step B;
A2, call the configuration file of all fields that comprise this database table according to described database table sign, therefrom unspecified field and corresponding default value in the read operation order, and with default value as desired value, continue step B.
11, the method for data base table recording inspection as claimed in claim 10 is characterized in that, before the generated query order, further judge all database table fields that whether comprise in the field of configuration file in the operational order, if, execution in step B then, otherwise end process flow process.
12, a kind of device of fulfillment database table record structure is characterized in that this device comprises:
Memory storage is used for store configuration files, includes all fields and the corresponding default value of database table in the described configuration file;
Receiving trap is used for obtaining from operational order the database table sign of input, and field name and respective value thereof are imported the operational order appointed information into and searched device;
Search device, be used for calling the corresponding configuration file of memory storage according to described database table sign;
Command device is used for searching the configuration file that device finds and obtaining unspecified field and corresponding default value the operational order from described, and with its with operational order in the field and the respective value of appointment press order of the field generation insertion statement in the database table;
Actuating unit, the operation that the database of command execution in memory storage that is used for generating according to command device inserts a table record.
13, the device of fulfillment database table record structure as claimed in claim 12 is characterized in that this table record constructing apparatus also comprises:
Error Detection Unit was used for before generate inserting order, further judged all fields that whether comprise in the field of configuration file in the operational order, if, startup command device then, otherwise finish the device operation.
14, a kind of device of realizing checking data base table recording is characterized in that, this device comprises:
Memory storage is used for store configuration files, includes all fields and the corresponding default value of database table in the described configuration file;
Receiving trap is used for obtaining from operational order the database table sign of input, field name and corresponding desired value;
Command device, the field generated query order that is used for inquiring about as required;
Actuating unit is used for the querying command that the fill order device generates, and searches required table record to obtain the value of specific field correspondence in described data of database table;
Comparison device, the value that is used for field that described actuating unit is obtained is compared with corresponding desired value.
15, the device of data base table recording is checked in realization as claimed in claim 14, it is characterized in that this device also comprises:
Search device, be used for calling corresponding configuration file from described memory storage according to described database table sign, when the user need check all fields, from configuration file, obtain unspecified field that other need be inquired about and default value in the described operational order, and send field to command device, with the default value of field as desired value;
Error Detection Unit was used for before the generated query order, further judged all fields that whether comprise in the field of configuration file in the operational order, if, startup command device then, otherwise finish the device operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610083951 CN101046812A (en) | 2006-06-12 | 2006-06-12 | Method of data base table recording structure and detection and its device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610083951 CN101046812A (en) | 2006-06-12 | 2006-06-12 | Method of data base table recording structure and detection and its device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101046812A true CN101046812A (en) | 2007-10-03 |
Family
ID=38771428
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200610083951 Pending CN101046812A (en) | 2006-06-12 | 2006-06-12 | Method of data base table recording structure and detection and its device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101046812A (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102289505A (en) * | 2011-08-29 | 2011-12-21 | 北京星网锐捷网络技术有限公司 | Method, device and equipment for accessing database |
| CN102760096A (en) * | 2011-04-27 | 2012-10-31 | 阿里巴巴集团控股有限公司 | Test data generation method, unit testing method and unit testing system |
| CN102811445A (en) * | 2011-06-01 | 2012-12-05 | 中兴通讯股份有限公司 | Method and device for checking configuration data |
| CN103020139A (en) * | 2012-11-21 | 2013-04-03 | 用友软件股份有限公司 | Data sheet extension system and method |
| CN103488694A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Business data inquiry device and business data inquiry method |
| CN106294776A (en) * | 2016-08-12 | 2017-01-04 | 北京东方车云信息技术有限公司 | A kind of data processing method and device |
| CN104156343B (en) * | 2014-08-20 | 2017-05-10 | 北京国双科技有限公司 | Processing method and device for messy codes in data warehouse |
| CN106844772A (en) * | 2017-02-28 | 2017-06-13 | 东软集团股份有限公司 | The update method and device of application database |
| CN107679203A (en) * | 2017-10-12 | 2018-02-09 | 广州华多网络科技有限公司 | A kind of Redis internal databases call method and system |
| CN108804480A (en) * | 2017-05-05 | 2018-11-13 | 天津中铁电气化设计研究院有限公司 | A kind of analyzing platform and design method of novel dynamic generation data operation commands |
| CN109062925A (en) * | 2018-06-06 | 2018-12-21 | 中国平安人寿保险股份有限公司 | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence |
| CN110221967A (en) * | 2019-05-20 | 2019-09-10 | 深圳壹账通智能科技有限公司 | Test data building method, device, computer equipment and storage medium |
| CN111008191A (en) * | 2019-10-30 | 2020-04-14 | 深圳震有科技股份有限公司 | Completion method and device for database query and computer equipment |
| CN111339128A (en) * | 2018-12-18 | 2020-06-26 | 北京嘀嘀无限科技发展有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN111984666A (en) * | 2019-05-23 | 2020-11-24 | 北京数聚鑫云信息技术有限公司 | Database access method and device, computer readable storage medium and computer equipment |
| WO2021042532A1 (en) * | 2019-09-05 | 2021-03-11 | 平安科技（深圳）有限公司 | Database information analysis method and apparatus, computer apparatus, and storage medium |
-
2006
- 2006-06-12 CN CN 200610083951 patent/CN101046812A/en active Pending
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102760096A (en) * | 2011-04-27 | 2012-10-31 | 阿里巴巴集团控股有限公司 | Test data generation method, unit testing method and unit testing system |
| CN102760096B (en) * | 2011-04-27 | 2016-03-30 | 阿里巴巴集团控股有限公司 | The generation method of test data, unit test method and unit test system |
| CN102811445A (en) * | 2011-06-01 | 2012-12-05 | 中兴通讯股份有限公司 | Method and device for checking configuration data |
| CN102811445B (en) * | 2011-06-01 | 2017-03-22 | 中兴通讯股份有限公司 | Method and device for checking configuration data |
| CN102289505A (en) * | 2011-08-29 | 2011-12-21 | 北京星网锐捷网络技术有限公司 | Method, device and equipment for accessing database |
| CN103020139A (en) * | 2012-11-21 | 2013-04-03 | 用友软件股份有限公司 | Data sheet extension system and method |
| CN103020139B (en) * | 2012-11-21 | 2016-01-20 | 用友网络科技股份有限公司 | Tables of data expanding system and tables of data extended method |
| CN103488694A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Business data inquiry device and business data inquiry method |
| CN104156343B (en) * | 2014-08-20 | 2017-05-10 | 北京国双科技有限公司 | Processing method and device for messy codes in data warehouse |
| CN106294776A (en) * | 2016-08-12 | 2017-01-04 | 北京东方车云信息技术有限公司 | A kind of data processing method and device |
| CN106844772A (en) * | 2017-02-28 | 2017-06-13 | 东软集团股份有限公司 | The update method and device of application database |
| CN108804480A (en) * | 2017-05-05 | 2018-11-13 | 天津中铁电气化设计研究院有限公司 | A kind of analyzing platform and design method of novel dynamic generation data operation commands |
| CN107679203A (en) * | 2017-10-12 | 2018-02-09 | 广州华多网络科技有限公司 | A kind of Redis internal databases call method and system |
| CN107679203B (en) * | 2017-10-12 | 2020-11-13 | 广州华多网络科技有限公司 | Redis internal database calling method and system |
| CN109062925A (en) * | 2018-06-06 | 2018-12-21 | 中国平安人寿保险股份有限公司 | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence |
| CN109062925B (en) * | 2018-06-06 | 2023-08-22 | 中国平安人寿保险股份有限公司 | Method, device, computer equipment and storage medium for automatically generating insert sentences |
| CN111339128A (en) * | 2018-12-18 | 2020-06-26 | 北京嘀嘀无限科技发展有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN111339128B (en) * | 2018-12-18 | 2023-09-26 | 北京嘀嘀无限科技发展有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN110221967A (en) * | 2019-05-20 | 2019-09-10 | 深圳壹账通智能科技有限公司 | Test data building method, device, computer equipment and storage medium |
| CN111984666A (en) * | 2019-05-23 | 2020-11-24 | 北京数聚鑫云信息技术有限公司 | Database access method and device, computer readable storage medium and computer equipment |
| CN111984666B (en) * | 2019-05-23 | 2024-03-29 | 北京数聚鑫云信息技术有限公司 | Database access method, apparatus, computer readable storage medium and computer device |
| WO2021042532A1 (en) * | 2019-09-05 | 2021-03-11 | 平安科技（深圳）有限公司 | Database information analysis method and apparatus, computer apparatus, and storage medium |
| CN111008191A (en) * | 2019-10-30 | 2020-04-14 | 深圳震有科技股份有限公司 | Completion method and device for database query and computer equipment |
| CN111008191B (en) * | 2019-10-30 | 2023-08-11 | 深圳震有科技股份有限公司 | Completion method and device for database query and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101046812A (en) | Method of data base table recording structure and detection and its device | |
| CN1768373A (en) | Information processing device, information processing method, and computer program | |
| CN1658184A (en) | Network system, distributed processing method and information processing apparatus | |
| CN1530926A (en) | Phonetic recognizing dictionary producer and information search device | |
| CN1918646A (en) | Recording apparatus, integrated circuit for recording apparatus, recording method, computer program, and recording medium which facilitates content recording | |
| CN1532753A (en) | Sevice processer and service processing method | |
| CN1870478A (en) | Event reansmitting device and method of digital broadcasting receiving device | |
| CN1680959A (en) | Process editing apparatus and method and process management apparatus and method | |
| CN1795434A (en) | Program execution control device, program execution control method, control program and recording medium | |
| CN1677365A (en) | Test case inheritance controlled via attributes | |
| CN1300022A (en) | Electronic apparatus for managing changeable storage medium, method thereof and storage medium | |
| CN1610881A (en) | Gui application development support device, gui display device, and method, and computer program | |
| CN1278228C (en) | Two tier paste buffer and display | |
| CN101051937A (en) | User's power managing method and system based on XML | |
| CN1794788A (en) | Apparatus and method for processing image, computer program and recording medium | |
| CN101065967A (en) | Meta data management device and meta data use device | |
| CN101065725A (en) | Command supply device | |
| CN101030223A (en) | Apparatus, method, and computer program for processing information | |
| CN1790957A (en) | Apparatus testing method | |
| CN1744054A (en) | Automatic test auxiliary system and corresponding software automatic test method | |
| CN1517868A (en) | Information processing device, method and program | |
| CN1756334A (en) | Apparatus, method, and program for processing information | |
| CN1737802A (en) | Information processing apparatus and method, recording medium, and program | |
| CN1862511A (en) | Method for testing software unit | |
| CN1870028A (en) | Work flow system, work flow processing method and work flow processing program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20071003 |