CN108399196A - The sql automatic execution methods and system of database sql sentence Auto-Generation Tools - Google Patents
The sql automatic execution methods and system of database sql sentence Auto-Generation Tools Download PDFInfo
- Publication number
- CN108399196A CN108399196A CN201810087108.7A CN201810087108A CN108399196A CN 108399196 A CN108399196 A CN 108399196A CN 201810087108 A CN201810087108 A CN 201810087108A CN 108399196 A CN108399196 A CN 108399196A
- Authority
- CN
- China
- Prior art keywords
- function
- sql
- database
- auto
- sql query
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Abstract
The present invention provides a kind of sql automatic execution methods of database sql sentence Auto-Generation Tools, by sql query statements Auto-Generation Tool and Database Connectivity;The table structural information of the table to be inquired and the function information of the built-in function of all supports are obtained from database;Sql query statement Auto-Generation Tools read in table structural information and function information, and generate sql query statements using random algorithm;Sql query statement Auto-Generation Tools call the interface function of connection database to execute sql query statements automatically, and the log generated in implementation procedure is output in real time in log files;After having executed sql query statements, programming count implementing result simultaneously exports.The present invention also provides the system corresponding to a kind of method, advantage of the present invention:So that the sql query statements that sql query statement Auto-Generation Tools are generated is run in the database automatically, linking link of the script between executing can be eliminated, save the testing time.
Description
Technical field
The present invention relates to database field, more particularly to a kind of sql of database sql sentence Auto-Generation Tools is held automatically
Row method and system.
Background technology
Database (Database) be according to data structure come tissue, storage and manage data warehouse, it result from away from
Before modern more than 60 years, after the development of information technology and market, especially nineteen nineties, data management is not
It is only to store and manage data, and be transformed into the mode of the required various data managements of user again.
In recent years, with the development of big data, the type of database becomes more and more, sql grammers and application method
Also different, the requirement to function and performance is also higher and higher.It is in test database work(that sql query statements, which automate Core Generator,
A kind of tool often needed to use when energy and performance, still, existing database sql sentences Auto-Generation Tool is generating
After sql script files, it is required for manually performing the sql script files of generation by tester, and can not also give birth in implementation procedure
It at log and exports, therefore, not only testing efficiency is relatively low, but also inconvenient tester positions the position of bug.
Invention content
One of the technical problem to be solved in the present invention is to provide a kind of sql of database sql sentence Auto-Generation Tools
Automatic execution method, the sql query statements for enabling sql query statement Auto-Generation Tools to be generated by this method exist automatically
It is run in database, linking link of the script between executing can be eliminated, save the testing time.
The present invention is realized in one of technical problem:The sql of database sql sentence Auto-Generation Tools is executed automatically
Method, described method includes following steps:
Step S1, by sql query statements Auto-Generation Tool and Database Connectivity;
Step S2, the letter of the table structural information of the table to be inquired and the built-in function of all supports is obtained from database
Number information;
Step S3, sql query statements Auto-Generation Tool reads in table structural information and function information, and utilizes random algorithm
Generate sql query statements;
Step S4, sql query statements Auto-Generation Tool calls the interface function of connection database to execute sql inquiries automatically
Sentence, and the log generated in implementation procedure is output in real time in log files;
Step S5, after having executed sql query statements, programming count implementing result simultaneously exports.
Further, the step S1 is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool with
Database Connectivity.
Further, the step S2 is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database
The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include
Type information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
The second technical problem to be solved by the present invention is to provide a kind of sql of database sql sentence Auto-Generation Tools
Automatic to execute system, the sql query statements for enabling sql query statement Auto-Generation Tools to be generated by the system exist automatically
It is run in database, linking link of the script between executing can be eliminated, save the testing time.
The present invention is realized in the twos' of technical problem:The sql of database sql sentence Auto-Generation Tools is executed automatically
System, the system comprises link block, data obtaining module, sentence generation module, automatic execution module and result statistics
Module;
The link block is used for sql query statements Auto-Generation Tool and Database Connectivity;
Described information acquisition module, for obtaining the table structural information of the table to be inquired and all supports from database
Built-in function function information;
The sentence generation module reads in table structural information and function information for sql query statement Auto-Generation Tools,
And generate sql query statements using random algorithm;
The automatic execution module calls the interface function of connection database for sql query statement Auto-Generation Tools
It is automatic to execute sql query statements, and the log generated in implementation procedure is output in real time in log files;
The result statistical module, after having executed sql query statements, programming count implementing result simultaneously exports.
Further, the link block is specially:By ODBC interconnection techniques by sql query statement Auto-Generation Tools
With Database Connectivity.
Further, described information acquisition module is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database
The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include
Type information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
The invention has the advantages that:1, the side interacted with database by using sql query statements Auto-Generation Tool
Formula makes the sql query statements that sql query statement Auto-Generation Tools are generated run in the database automatically, therefore, the present invention
Linking link of the script between executing is eliminated, the testing time is saved;
2, log of the sql query statements for being generated Sql query statement Auto-Generation Tools in database implementation procedure
Log files are output in real time, for the log information that operating personnel's real time inspection executes, and facilitate the position of positioning bug, simultaneously
Can also real time inspection sql query statements implementation progress and executive condition;
3, after executing, programming count implementing result simultaneously exports, and the personnel that are convenient to operation have implementation effect more intuitive
Understanding.
Description of the drawings
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the functional block diagram of the sql automatic execution methods of database sql sentence Auto-Generation Tools of the present invention.
Fig. 2 is to carry out matched functional block diagram to row and function in the present invention.
Specific implementation mode
Please emphasis refering to fig. 1 with shown in Fig. 2, the side of execution automatically the sql of database sql sentence Auto-Generation Tools of the present invention
The preferred embodiment of method, described method includes following steps:
Step S1, by sql query statements Auto-Generation Tool and Database Connectivity;
The step S1 is specially:It is by ODBC interconnection techniques that sql query statements Auto-Generation Tool and database is mutual
Even.
Step S2, the letter of the table structural information of the table to be inquired and the built-in function of all supports is obtained from database
Number information;
The step S2 is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database
The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include
Type information;The built-in function of all supports includes operator (such as plus sige, minus sign, equal sign, comma), aggregate function
(such as MAX, MIN, SUM, AVG), OLTP functions or OLAP function.
In the specific implementation, it needs the table structural information that will be obtained to preserve into the first text file, the function of acquisition is believed
Breath is preserved into the second text file;It is also desirable to the format of the first text file and the second text file be changed, so that first
The format of text file and the second text file is consistent with the input format of sql query statement Auto-Generation Tools, that is, needs
The first text file and the second text file are changed according to specified format, makes the defeated of sql query statement Auto-Generation Tools
Enter and output obtains unification.
Step S3, sql query statements Auto-Generation Tool reads in table structural information and function information, and utilizes random algorithm
Generate sql query statements;
In the specific implementation, sql query statements Auto-Generation Tool can first read the first text file and the second text text
Part, and preserve the first text file and the second text file according to the format of regulation;Then, sql query statements automatically generate work
Tool obtains the first text file and the second text file preserved, and by the type information of each row in the first text file and the
The type information for the parameters that function return value type and built-in function in two text files are included is matched, and will
The row and built-in function of type matching preserve, and the unmatched row of type and built-in function are then without preserving;It is calculated using random
Method randomly selects the row of preservation and built-in function and automatically generates sql query statements;
Meanwhile sql query statements Auto-Generation Tool type information of each row and second in the first text file
When the type information for the parameters that function return value type and built-in function in text file are included is matched, specifically
Including:The type information of each row in first text file is compared with function return value type in the second text file
Match, and if type matching, preserves row and function return value;If type mismatches, row and function return value are not preserved;
By the class for the parameters that built-in function is included in the type information of each row in the first text file and the second text file
Type information is compared matching, and if the parameters that the type information of each row is included with built-in function type information
Equal Corresponding matching will then preserve in the corresponding parameter list of the type information of each row filling built-in function;It otherwise just will be each
It is preserved in the corresponding parameter list of type information filling built-in function of row;
When specifically generating sql query statements, sql query statements Auto-Generation Tool randomly selects guarantor using random algorithm
The row and built-in function deposited, and the row of type matching and function return value are generated into numeric ratio to (such as<,=,>Deng) first
Sql inquiry clauses;The built-in function that row type information is filled in parameter list is generated into the 2nd sql inquiry clauses;Finally, sql is looked into
It askes sentence Auto-Generation Tool the first sql inquiry clauses and the 2nd sql inquiry clauses are packaged together with other query statements,
Automatically generate sql query statements.
Step S4, sql query statements Auto-Generation Tool calls the interface function of connection database to execute sql inquiries automatically
Sentence, and the log generated in implementation procedure is output in real time in log files, in this way, operating personnel can real time inspection hold
Capable log information, and facilitate the position of positioning bug, while can be with the implementation progress of real time inspection sql query statements and execution
Situation.
Step S5, after having executed sql query statements, programming count implementing result simultaneously exports, including the number that runs succeeded, holds
The various relevant informations such as the row frequency of failure, execution date, the rate that runs succeeded, the personnel that are convenient to operation have implementation effect more intuitive
Understanding.
The sql of database sql sentence Auto-Generation Tools of the present invention executes the preferred embodiment of system, the system automatically
Including link block, data obtaining module, sentence generation module, automatic execution module and result statistical module;
The link block is used for sql query statements Auto-Generation Tool and Database Connectivity;
The link block is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool and database
Interconnection.
Described information acquisition module, for obtaining the table structural information of the table to be inquired and all supports from database
Built-in function function information;
Described information acquisition module is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database
The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include
Type information;The built-in function of all supports includes operator (such as plus sige, minus sign, equal sign, comma), aggregate function
(such as MAX, MIN, SUM, AVG), OLTP functions or OLAP function.
In the specific implementation, it needs the table structural information that will be obtained to preserve into the first text file, the function of acquisition is believed
Breath is preserved into the second text file;It is also desirable to the format of the first text file and the second text file be changed, so that first
The format of text file and the second text file is consistent with the input format of sql query statement Auto-Generation Tools, that is, needs
The first text file and the second text file are changed according to specified format, makes the defeated of sql query statement Auto-Generation Tools
Enter and output obtains unification.
The sentence generation module reads in table structural information and function information for sql query statement Auto-Generation Tools,
And generate sql query statements using random algorithm;
In the specific implementation, sql query statements Auto-Generation Tool can first read the first text file and the second text text
Part, and preserve the first text file and the second text file according to the format of regulation;Then, sql query statements automatically generate work
Tool obtains the first text file and the second text file preserved, and by the type information of each row in the first text file and the
The type information for the parameters that function return value type and built-in function in two text files are included is matched, and will
The row and built-in function of type matching preserve, and the unmatched row of type and built-in function are then without preserving;It is calculated using random
Method randomly selects the row of preservation and built-in function and automatically generates sql query statements;
Meanwhile sql query statements Auto-Generation Tool type information of each row and second in the first text file
When the type information for the parameters that function return value type and built-in function in text file are included is matched, specifically
Including:The type information of each row in first text file is compared with function return value type in the second text file
Match, and if type matching, preserves row and function return value;If type mismatches, row and function return value are not preserved;
By the class for the parameters that built-in function is included in the type information of each row in the first text file and the second text file
Type information is compared matching, and if the parameters that the type information of each row is included with built-in function type information
Equal Corresponding matching will then preserve in the corresponding parameter list of the type information of each row filling built-in function;It otherwise just will be each
It is preserved in the corresponding parameter list of type information filling built-in function of row;
When specifically generating sql query statements, sql query statements Auto-Generation Tool randomly selects guarantor using random algorithm
The row and built-in function deposited, and the row of type matching and function return value are generated into numeric ratio to (such as<,=,>Deng) first
Sql inquiry clauses;The built-in function that row type information is filled in parameter list is generated into the 2nd sql inquiry clauses;Finally, sql is looked into
It askes sentence Auto-Generation Tool the first sql inquiry clauses and the 2nd sql inquiry clauses are packaged together with other query statements,
Automatically generate sql query statements.
The automatic execution module calls the interface function of connection database for sql query statement Auto-Generation Tools
It is automatic to execute sql query statements, and the log generated in implementation procedure is output in real time in log files, in this way, operating personnel
Can the log information that executes of real time inspection, and facilitate the position of positioning bug, while can be with real time inspection sql query statements
Implementation progress and executive condition.
The result statistical module, after having executed sql query statements, programming count implementing result simultaneously exports, including
Run succeeded the various relevant informations such as number, the execution frequency of failure, execution date, the rate that runs succeeded, and be convenient to operation personnel couple
Implementation effect is understood more intuitively.
In conclusion the invention has the advantages that:1, by using sql query statements Auto-Generation Tool and database
Interactive mode makes the sql query statements that sql query statement Auto-Generation Tools are generated run in the database automatically, because
This, this invention removes linking link of the script between executing, and save the testing time;
2, log of the sql query statements for being generated Sql query statement Auto-Generation Tools in database implementation procedure
Log files are output in real time, for the log information that operating personnel's real time inspection executes, and facilitate the position of positioning bug, simultaneously
Can also real time inspection sql query statements implementation progress and executive condition;
3, after executing, programming count implementing result simultaneously exports, and the personnel that are convenient to operation have implementation effect more intuitive
Understanding.
Although specific embodiments of the present invention have been described above, those familiar with the art should manage
Solution, we are merely exemplary described specific embodiment, rather than for the restriction to the scope of the present invention, it is familiar with this
The technical staff in field modification and variation equivalent made by the spirit according to the present invention, should all cover the present invention's
In scope of the claimed protection.
Claims (6)
1. a kind of sql automatic execution methods of database sql sentence Auto-Generation Tools, it is characterised in that:The method includes
Following steps:
Step S1, by sql query statements Auto-Generation Tool and Database Connectivity;
Step S2, the function letter of the table structural information of the table to be inquired and the built-in function of all supports is obtained from database
Breath;
Step S3, sql query statements Auto-Generation Tool reads in table structural information and function information, and is generated using random algorithm
Sql query statements;
Step S4, sql query statements Auto-Generation Tool calls the interface function of connection database to execute sql inquiry languages automatically
Sentence, and the log generated in implementation procedure is output in real time in log files;
Step S5, after having executed sql query statements, programming count implementing result simultaneously exports.
2. the sql automatic execution methods of database sql sentence Auto-Generation Tools according to claim 1, feature exist
In:The step S1 is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool and Database Connectivity.
3. the sql automatic execution methods of database sql sentence Auto-Generation Tools according to claim 1, feature exist
In:The step S2 is specially:
The type information of each row, obtains all from database from the row name and table for obtaining the table to be inquired in database
The function name of the built-in function of support, the type of function return value type, the number of parameters that function includes and parameters
Information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
4. a kind of sql of database sql sentence Auto-Generation Tools executes system automatically, it is characterised in that:The system comprises
Link block, data obtaining module, sentence generation module, automatic execution module and result statistical module;
The link block is used for sql query statements Auto-Generation Tool and Database Connectivity;
Described information acquisition module, for out of, table structural information and all supports that obtain the table to be inquired in database
Set the function information of function;
The sentence generation module reads in table structural information and function information, and profit for sql query statement Auto-Generation Tools
Sql query statements are generated with random algorithm;
The automatic execution module calls the interface function of connection database automatic for sql query statement Auto-Generation Tools
Sql query statements are executed, and the log generated in implementation procedure is output in real time in log files;
The result statistical module, after having executed sql query statements, programming count implementing result simultaneously exports.
5. the sql of database sql sentence Auto-Generation Tools according to claim 4 executes system automatically, feature exists
In:The link block is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool and Database Connectivity.
6. the sql of database sql sentence Auto-Generation Tools according to claim 4 executes system automatically, feature exists
In:Described information acquisition module is specially:
The type information of each row, obtains all from database from the row name and table for obtaining the table to be inquired in database
The function name of the built-in function of support, the type of function return value type, the number of parameters that function includes and parameters
Information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810087108.7A CN108399196B (en) | 2018-01-30 | 2018-01-30 | Automatic sql execution method and system of database sql statement automatic generation tool |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810087108.7A CN108399196B (en) | 2018-01-30 | 2018-01-30 | Automatic sql execution method and system of database sql statement automatic generation tool |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108399196A true CN108399196A (en) | 2018-08-14 |
CN108399196B CN108399196B (en) | 2022-07-29 |
Family
ID=63095154
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810087108.7A Active CN108399196B (en) | 2018-01-30 | 2018-01-30 | Automatic sql execution method and system of database sql statement automatic generation tool |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108399196B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113961588A (en) * | 2021-10-27 | 2022-01-21 | 北京科杰科技有限公司 | Big data SQL program design method based on configurable parameters |
CN116302211A (en) * | 2023-05-22 | 2023-06-23 | 美云智数科技有限公司 | Configuration method and device of policy executor, computer equipment and storage medium |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6115704A (en) * | 1991-09-27 | 2000-09-05 | Bmc Software, Inc. | Extended SQL change definition language for a computer database system |
US20070027904A1 (en) * | 2005-06-24 | 2007-02-01 | George Chow | System and method for translating between relational database queries and multidimensional database queries |
CN101105814A (en) * | 2007-09-11 | 2008-01-16 | 金蝶软件(中国)有限公司 | Method and device for converting Script language to SQL language |
EP1901180A1 (en) * | 2006-09-07 | 2008-03-19 | Research In Motion Limited | System and method of generating databases |
CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
CN106919678A (en) * | 2017-02-27 | 2017-07-04 | 武汉珞佳伟业科技有限公司 | A kind of database inquiry optimization system and method |
CN107562955A (en) * | 2017-09-30 | 2018-01-09 | 北京酷我科技有限公司 | A kind of rapid generation of SQL statement |
-
2018
- 2018-01-30 CN CN201810087108.7A patent/CN108399196B/en active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6115704A (en) * | 1991-09-27 | 2000-09-05 | Bmc Software, Inc. | Extended SQL change definition language for a computer database system |
US20070027904A1 (en) * | 2005-06-24 | 2007-02-01 | George Chow | System and method for translating between relational database queries and multidimensional database queries |
EP1901180A1 (en) * | 2006-09-07 | 2008-03-19 | Research In Motion Limited | System and method of generating databases |
CN101105814A (en) * | 2007-09-11 | 2008-01-16 | 金蝶软件(中国)有限公司 | Method and device for converting Script language to SQL language |
CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
CN106919678A (en) * | 2017-02-27 | 2017-07-04 | 武汉珞佳伟业科技有限公司 | A kind of database inquiry optimization system and method |
CN107562955A (en) * | 2017-09-30 | 2018-01-09 | 北京酷我科技有限公司 | A kind of rapid generation of SQL statement |
Non-Patent Citations (1)
Title |
---|
丁祥武 等: "SQL测试用例集的自动生成", 《计算机应用与软件》 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113961588A (en) * | 2021-10-27 | 2022-01-21 | 北京科杰科技有限公司 | Big data SQL program design method based on configurable parameters |
CN116302211A (en) * | 2023-05-22 | 2023-06-23 | 美云智数科技有限公司 | Configuration method and device of policy executor, computer equipment and storage medium |
CN116302211B (en) * | 2023-05-22 | 2023-11-21 | 美云智数科技有限公司 | Configuration method and device of policy executor, computer equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108399196B (en) | 2022-07-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108984712B (en) | Service scene-based number making method and device and readable storage medium | |
US9009140B2 (en) | Optimization of database query | |
US9037549B2 (en) | System and method for testing data at a data warehouse | |
CN107402989A (en) | The method and distributed NewSQL Database Systems that a kind of full-text search is established | |
CN102236672A (en) | Method and device for importing data | |
CN101977121A (en) | Configuration file processing method, device and system | |
CN110427188B (en) | Configuration method, device, equipment and storage medium of single-test assertion program | |
US20140101097A1 (en) | Template based database analyzer | |
CN111026670B (en) | Test case generation method, test case generation device and storage medium | |
CN107943694A (en) | A kind of test data generating method and device | |
CN109614315A (en) | A kind of automatic generation method and system of data synchronism detection use-case | |
CN105760517A (en) | Method and device for transferring data from Oracle database to DB2 database | |
CN108399196A (en) | The sql automatic execution methods and system of database sql sentence Auto-Generation Tools | |
CN111291025B (en) | Method for supporting multi-physical model conversion by logic model and storage device | |
CN115391142A (en) | Database audit log generation method and system | |
CN111367893A (en) | Method and device for database version iteration | |
CN111506594B (en) | Big data query platform, management method thereof and data query method | |
CN116502273B (en) | Dynamic data desensitization method, device and equipment based on data blood edges | |
CN112799966A (en) | Method, system, equipment and medium for generating test data in batches by extensible plug-in | |
CN108388589A (en) | A kind of device that database sql query statements automatically generate | |
CN108460092B (en) | Automatic generation method and system for sql query statement containing database built-in function | |
CN112445867A (en) | Intelligent analysis method and system for data relationship | |
CN115455091A (en) | Data generation method and device, electronic equipment and storage medium | |
CN107273293B (en) | Big data system performance test method and device and electronic equipment | |
CN114297961A (en) | Chip test case processing method and related device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 350000 21 / F, building 5, f District, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province Applicant after: FUJIAN SINOREGAL SOFTWARE CO.,LTD. Address before: Floor 20-21, building 5, area F, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province 350000 Applicant before: FUJIAN SINOREGAL SOFTWARE CO.,LTD. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |