CN113641747A - Method, device and system for accessing postman tool to database - Google Patents
Method, device and system for accessing postman tool to database Download PDFInfo
- Publication number
- CN113641747A CN113641747A CN202111204345.5A CN202111204345A CN113641747A CN 113641747 A CN113641747 A CN 113641747A CN 202111204345 A CN202111204345 A CN 202111204345A CN 113641747 A CN113641747 A CN 113641747A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- postman
- tool
- request
- 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
- 238000000034 method Methods 0.000 title claims abstract description 55
- 230000003068 static effect Effects 0.000 claims description 29
- 230000006870 function Effects 0.000 description 26
- 230000008569 process Effects 0.000 description 11
- 238000004891 communication Methods 0.000 description 8
- 238000012360 testing method Methods 0.000 description 8
- 230000003993 interaction Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 238000010276 construction Methods 0.000 description 4
- 238000009434 installation Methods 0.000 description 4
- 230000002452 interceptive effect Effects 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
Images
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3696—Methods or tools to render software testable
-
- 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
- G06F16/2445—Data retrieval commands; View definitions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
- G06F9/44526—Plug-ins; Add-ons
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a device and a system for accessing a postman tool into a database, wherein the method comprises the following steps: compiling a database request containing a database operation statement through postman, and sending the database request to a data cloud plug-in; and the data cloud plug-in acquires database data according to the database operation statement and returns the database data to the postman. The data cloud plug-in for providing the database query service is built between the Postman and the database, and the data cloud plug-in realizes the acquisition of dynamic data in the database, so that other plug-ins do not need to be installed for the Postman, database operation statements are compiled by using a common database management language on the Postman, the dynamic data of the database returned by the data cloud plug-in can be received, and the problem that the Postman does not support the access of the database is broken through. Compared with a jmeter tool with an access database plug-in, the method does not need to be used after being pre-configured every time, and the database can be written for permanent use on postman only by once configuration.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method, a device and a system for accessing a postman tool to a database.
Background
The Postman tool is a powerful tool for API (Application Programming Interface) debugging and Http request management, and is often used in the field of software development.
At present, when a Postman tool is used for interface function testing, an interface return value needs to be subjected to assertion operation, when the Postman tool is subjected to assertion operation, dynamic data in a database sometimes needs to be acquired for assertion operation, but the Postman tool does not support the function of accessing the database, so that the dynamic data cannot be used for assertion.
Disclosure of Invention
The invention aims to provide a method, a device and a system for accessing a postman tool to a database, aiming at the defects of the prior art, and the aim is realized by the following technical scheme.
The invention provides a method for accessing a postman tool to a database in a first aspect, which comprises the following steps:
compiling a database request containing a database operation statement through a postman tool, and sending the database request to a data cloud plug-in;
and the data cloud plug-in acquires database data according to the database operation statement and returns the database data to the postman tool.
In some embodiments of the present application, writing a database request containing a database operation statement by a postman tool includes:
acquiring a database operation statement and a required return data type by a postman tool; the database request is generated by the postman tool using the static service address, the application service address, the database interface function path, and the retrieved database operation statements and return data types.
In some embodiments of the present application, the data cloud plug-in includes an application service and a static service, and the sending of the database request to the data cloud plug-in via a postman tool includes:
sending, by a postman tool, the database request to a static service to which the static service address points; and sending the database request to the application service pointed by the application service address through the static service.
In some embodiments of the present application, the obtaining, by the data cloud plug-in, database data according to the database operation statement includes:
inputting the database operation statement and the return data type as input parameters into a database interface function pointed by the database interface function path by the application service; and acquiring database data according to the database operation statement and the returned data type through the database interface function.
In some embodiments of the present application, obtaining database data according to the database operation statement and the return data type through the database interface function includes:
establishing connection with a database by using preset database configuration; acquiring data in the database by using the database operation statement through the connection; and converting the acquired data according to the type of the returned data to obtain database data.
In some embodiments of the present application, before establishing a connection with a database using a preset database configuration, the method further comprises:
judging whether the database operation statement is a query statement; if yes, executing the step of establishing connection with the database by using preset database configuration.
In some embodiments of the present application, the database configuration includes a connection address, a username, and a password for the database.
In some embodiments of the present application, after the data cloud plug-in returns the database data to the postman tool, the method further comprises:
utilizing, by the postman tool, the database data to assert an interface return value.
A second aspect of the invention provides a postman tool access database apparatus, the apparatus comprising: the data acquisition module on the data request module and the cloud server on the electronic equipment:
the data request module is used for compiling a database request containing database operation statements through a postman tool and sending the database request to the cloud server;
and the data acquisition module is used for acquiring database data by using the database operation statements and returning the database data to the postman tool.
A third aspect of the present invention provides a postman tool access database system, comprising: the system comprises an electronic device and a cloud server;
the electronic equipment is used for generating a database request containing a database operation statement through a postman tool and sending the database request to the cloud server;
and the cloud server is used for acquiring database data by using the database operation statements and returning the database data to the postman tool.
Based on the method, the device and the system for the postman tool to access the database in the first aspect and the third aspect, the method, the device and the system have at least the following advantages or advantages:
the data cloud plug-in for providing the database query service is built between the Postman tool and the database, and the data cloud plug-in realizes the acquisition of dynamic data in the database, so that other plug-in software does not need to be installed for the Postman tool, database operation statements are compiled on the Postman tool by using a common database management language, the dynamic data of the database returned by the data cloud plug-in can be received, and the problem that the Postman tool does not support the access of the database is broken through.
Compared with a jmeter tool with an access database plug-in, the method does not need to be reused after previous configuration is carried out each time, and the database request can be written on the postman tool for permanent use only by once configuration and construction.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention and not to limit the invention. In the drawings:
FIG. 1 is a flow chart illustrating an embodiment of a method for a postman tool to access a database in accordance with an illustrative embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating an interaction flow for a postman tool to access a database according to the embodiment of FIG. 1;
FIG. 3 is a schematic diagram illustrating an interaction flow for accessing a database by a postman tool according to the embodiment of FIG. 1;
FIG. 4 is a block diagram illustrating a postman tool access database system in accordance with an exemplary embodiment of the present invention;
fig. 5 is a schematic structural diagram illustrating a postman tool access database apparatus in accordance with an exemplary embodiment of the present invention.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the invention, as detailed in the appended claims.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in this specification and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.
It is to be understood that although the terms first, second, third, etc. may be used herein to describe various information, these information should not be limited to these terms. These terms are only used to distinguish one type of information from another. For example, first information may also be referred to as second information, and similarly, second information may also be referred to as first information, without departing from the scope of the present invention. The word "if" as used herein may be interpreted as "at … …" or "when … …" or "in response to a determination", depending on the context.
Compared with a jmeter tool, the Postman tool has more complete functions and is often used in the field of software development, but the Postman tool does not support access to a database, so that dynamic data cannot be used for asserting interface return values in the process of using the Postman tool for interface testing, and the coverage of interface testing is limited.
In the prior art, some postmans use an xmysql component to read data in a remote database, that is, by installing a node service on a device and installing the xmysql component, after configuring an environment variable, starting the node service and the xmysql component to connect with the database, and writing a database query statement in a postman tool according to the syntax of the xmysql component.
However, the process of using the xmysql component to access the database postman is cumbersome, requires installation of a plug-in on the device, and also requires writing a database query statement using the syntax of the xmysql component, which also requires the user to spend time learning such syntax to write.
Based on the method, the novel method for accessing the postman tool to the database is provided, namely, the database request containing the database operation statement is compiled through the postman tool, and the database request is sent to the data cloud plug-in, so that the data cloud plug-in acquires the database data by using the database operation statement, and returns the database data to the postman tool, and the function of accessing the postman tool to the database is achieved.
The technical effects that can be achieved based on the above description are:
the data cloud plug-in for providing the database query service is built between the Postman tool and the database, and the data cloud plug-in realizes the acquisition of dynamic data in the database, so that any component service does not need to be installed for the Postman tool, database operation statements are compiled on the Postman tool by using a common database management language, the dynamic data of the database returned by the data cloud plug-in can be received, and the problem that the Postman tool does not support the access of the database is broken through.
Compared with a jmeter tool with an access database plug-in, the method does not need to be reused after previous configuration is carried out each time, and the database request can be written on the postman tool for permanent use only by once configuration and construction.
In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application.
The first embodiment is as follows:
fig. 1 is a flowchart of an embodiment of a method for accessing a database by a postman tool according to an exemplary embodiment of the present invention, in this embodiment, a data cloud plug-in for providing a database query service is set up in advance on a cloud server, so that a postman tool installed on any electronic device can acquire database data through the data cloud plug-in. As shown in fig. 1, the method for accessing a database by a postman tool includes the following steps:
step 101: and compiling a database request containing a database operation statement through a postman tool, and sending the database request to the data cloud plug-in.
In this embodiment, an interface test module (tests module) is provided in the postman tool, and an interface return value can be obtained through an interface request in the interface test module, and if the interface return value needs to be asserted by using dynamic data in the database, a database operation statement needs to be written, so as to generate a database request including the database operation statement and send the database request to the data cloud plug-in.
When a user writes a database operation statement in an interface test module of the postman tool, the database operation statement is written only by using a commonly-used database management Language-Structured Query Language (SQL), so that the method is simple and easy, and compared with the prior art that the database operation statement is written by using the syntax of the xmysql component, a certain learning cost can be saved.
It should be noted that when a data cloud plug-in is built, different languages are used to provide database query services, different application services need to be selected, if a Python language is used, a uWSGI application service needs to be selected, and if a PHP language is used, a PHP-fpm application service needs to be selected. The uWSGI application service can only use an http communication mode for providing external services, but the http communication mode of the uWSGI application service is not stable, so in order to increase the communication stability, a layer of static service is added between the application service and the postman tool to provide http communication for the external services, and the application service is communicated with the external services through a socket.
Based on the static service, a static service can be established between the postman tool and the application service, the static service address and the application service address are preset in the postman tool, and the request forwarding service is provided.
The static service specifically can use nginx static service and is used for forwarding the database request to the data cloud plug-in, and the static service address is composed of an ip address and a port.
The application service is provided with a database interface service for realizing database data acquisition, and the application service address is the api address of the application service.
Therefore, the data cloud plug-in built by the method comprises the application service and the static service, and the data cloud plug-in can be built on a cloud server device so as to reduce the cost of the built hardware.
In an optional specific embodiment, for the specific generation process of the database request, the postman tool obtains the database operation statement and the required return data type, so that the postman tool can generate the database request by using the static service address, the application service address, the database interface function path, and the obtained database operation statement and the obtained return data type.
The database operation statement (SQL statement) and the required return data type (format) are two parameters specified by a user, and the return data type can determine the type of database data returned by the data cloud plug-in.
In one example, the return data types may include an array type (All), an object type (Row), and a string type (Scalar).
All data are acquired from data returned by the database and are combined into database data in an array type; row represents that a piece of data is obtained from data returned by the database, and the data is formed into database data according to the object type; scalar means that a single field is obtained from data returned by a database, and field values of the field are combined into database data in a character string type.
For example, assuming that the database operation statement is to query All student data of a class, if the format is All, All the student data is converted into array type data, if the format is Row, one student data is selected from All the student data and converted into an object type, and if the format is Scalar, a field value of a single field (such as age) is obtained from All the student data and converted into a character string type.
In an optional specific embodiment, when the database request includes a static service address and an application service address, aiming at the process that the postman tool sends the database request to the data cloud plug-in, the postman tool can send the database request to the static service pointed by the static service address through a pre-established http connection, and then the static service sends the database request to the application service pointed by the application service address through a pre-established socket connection, so that stable communication between the postman tool and the application service is realized.
The technical personnel in the field can understand that the built data cloud plug-in can also only comprise an application service, the postman tool directly uses an http communication service provided by the application service to the outside, establishes an http connection with the application service, and directly sends the database request to the application service through the http connection.
Step 102: the data cloud plug-in obtains database data using the database operation statements and returns the database data to the postman tool.
The database data acquired by the data cloud plug-in is dynamic data required by the interface test module on the postman tool for performing assertion operation on the interface return value.
In an optional specific embodiment, in the process of acquiring database data by the data cloud plug-in, the application service inputs a database operation statement and a returned data type as input parameters into a database interface function pointed by a database interface function path, and then acquires the database data according to the database operation statement and the returned data type through the database interface function.
In addition to deploying the database interface service, other services may be deployed in the application service, so that a database interface function path provided by the application service needs to be indicated in the database request, so as to navigate the database request to the database interface function, and implement parameter input.
In a specific embodiment, in a process of acquiring database data according to a database operation statement and a returned data type through a database interface function, a preset database configuration is first used to establish a connection with a database, then through the connection, data in the database is acquired through the database operation statement, and the acquired data is converted according to the returned data type to obtain database data.
For example, if the returned data type is an array type, the acquired data needs to be converted into database data of the array type, if the returned data type is an object type, the acquired data needs to be converted into database data of the object type, and if the returned data type is a character string type, the acquired data needs to be converted into database data of the character string type.
It is noted that the file format of the database data is json format regardless of the type of the database data.
Further, in order to implement the connection of the database, a database configuration needs to be preset, and the database configuration includes a connection address, a user name, and a password of the database.
For example, the connection with the database may be established by ODBC, JDBC, or any other suitable connection.
ODBC (Open Database Connectivity, Open Database interconnection) is an interface standard for realizing communication between an application program and a relational Database, which is introduced by microsoft corporation, and a Database conforming to the standard can operate the Database through a command written in SQL language, but only aims at the relational Database, such as SQL Server, Oracle, Access, Excel, and the like. JDBC (Java Data Base Connectivity) is a class interface written by a group of Java languages developed by Java Soft company and used for connecting and operating databases, and can provide a uniform access mode for multiple relational databases. The connection address of the database may be an ODBC connection address or a JDBC connection address.
In some optional embodiments, the operation types of the database operation statements include a query type (select), an update type (update), a delete type (delete), and an add type (insert intro), so as to avoid a user's misoperation, and make a false change to the database data. The database operation statements may be restricted prior to establishing a connection with the database.
Based on this, before the connection is established with the database by using the preset database configuration, whether the database operation statement is the query statement or not can be judged, if the query statement is the query statement, the connection is established with the database by using the preset database configuration, and if the query statement is not the query statement, the connection with the database is forbidden, so that the misoperation of a user can be effectively avoided by only querying the database data.
It should be noted that after the data cloud plug-in returns the database data to the postman tool, the postman tool can use the database data to perform an assertion operation on the interface return value.
So far, accomplish the access flow that above-mentioned figure 1 shows, through set up a data cloud plug-in that provides database inquiry service between Postman instrument and database, the acquisition of dynamic data in the database is realized by data cloud plug-in to need not for Postman instrument installation other plug-in software, compile database operation statement through using commonly used database management language on the Postman instrument, alright in order to receive the database dynamic data that data cloud plug-in returned, broken through the problem that the Postman instrument does not support the access database.
Compared with a jmeter tool with an access database plug-in, the method does not need to be reused after previous configuration is carried out each time, and the database request can be written on the postman tool for permanent use only by once configuration and construction.
Example two:
fig. 2 is a schematic view of an interaction flow of a postman tool accessing a database according to the embodiment shown in fig. 1, on the basis of the embodiment shown in fig. 1, in this embodiment, an interaction among the postman tool, a data cloud plug-in and the database is taken as an example for detailed description, the data cloud plug-in may only include an application service, as shown in fig. 2, and the interaction flow includes the following steps:
step 201: the postman tool sends a database request containing a database operation statement and a return data type to the data cloud plug-in.
Step 202: and the data cloud plug-in inputs the database operation statement and the returned data type as input parameters into the database interface function.
Step 203: and in the database interface function, establishing connection with the database by using preset database configuration.
Step 204: and in the database interface function, acquiring data in the database by using the database operation statement through the connection.
Step 205: and in the database interface function, converting the acquired data according to the type of the returned data to obtain database data.
Step 206: the data cloud plug-in returns the database data to the postman tool.
For the related description of the above steps 201 to 206, refer to the related description of the embodiment shown in fig. 1, which is not repeated herein.
So far, accomplish the interactive flow that above-mentioned fig. 2 shows, through set up a data cloud plug-in that provides database inquiry service between Postman instrument and database, the acquisition of dynamic data in the database is realized by data cloud plug-in to need not for Postman instrument installation other plug-in software, compile database operation statement through using commonly used database management language on the Postman instrument, alright receive the database dynamic data that data cloud plug-in returned, broken through the problem that the Postman instrument does not support the access database.
Compared with a jmeter tool with an access database plug-in, the method does not need to be reused after previous configuration is carried out each time, and the database request can be written on the postman tool for permanent use only by once configuration and construction.
Example three:
fig. 3 is a schematic view of an interaction flow of another postman tool accessing a database according to the embodiment shown in fig. 1, where on the basis of the embodiment shown in fig. 1, this embodiment takes an example that a data cloud plug-in includes a static service and an application service, and as shown in fig. 3, the interaction flow includes the following steps:
step 301: the postman tool sends a database request containing a database operation statement and a return data type to the static service.
Step 302: the static service forwards the database request containing the database operation statement and the return data type to the application service.
Step 303: the application service inputs the database operation statement and the return data type as input parameters into a database interface function pointed by the database interface function path.
Step 304: and in the database interface function, establishing connection with the database by using preset database configuration.
Step 305: and in the database interface function, acquiring data in the database by using the database operation statement through the connection.
Step 306: and in the database interface function, converting the acquired data according to the type of the returned data to obtain database data.
Step 307: the application service sends the database data to the static service.
Step 308: the static service forwards the database data to the postman tool.
For the related description of the above steps 301 to 308, refer to the related description of the embodiment shown in fig. 1, which is not repeated herein.
So far, accomplish the interactive flow that above-mentioned fig. 3 shows, through set up a data cloud plug-in that provides database inquiry service between Postman instrument and database, the acquisition of dynamic data in the database is realized by data cloud plug-in to need not for Postman instrument installation any subassembly service, compile database operation statement through using the database management language that commonly uses on the Postman instrument, alright in order to receive the database dynamic data that data cloud plug-in returned, broken through the problem that the Postman instrument does not support the access database.
Further, by adding a static service as middleware between the postman tool and the application service, stable communication between the postman tool and the application service is realized.
Example four:
fig. 4 is a schematic structural diagram of a postman tool access database system according to an exemplary embodiment of the present invention, and based on the above embodiment, as shown in fig. 4, the system includes an electronic device 410 and a cloud server 420;
the electronic device 410 is configured to compile a database request including a database operation statement through a postman tool, and send the database request to the cloud server 420;
and the cloud server 420 is configured to obtain database data by using the database operation statements, and return the database data to the postman tool on the electronic device 410.
Specifically, a data cloud plug-in is deployed on the cloud server, and is used for acquiring database data by using a database operation statement and returning the database data to the postman tool on the electronic device 410.
Corresponding to the embodiment of the method for accessing the database by the postman tool, the invention also provides an embodiment of a device for accessing the database by the postman tool.
Fig. 5 is a schematic structural diagram illustrating a postman tool access database apparatus according to an exemplary embodiment of the present invention, the apparatus is configured to execute the postman tool access database method provided in any of the above embodiments, as shown in fig. 5, the postman tool access database apparatus includes a data request module 510 on an electronic device and a data obtaining module 520 on a cloud server;
the data request module 510 is configured to generate a database request including a database operation statement through a postman tool, and send the database request to a cloud server;
the data obtaining module 520 is configured to obtain database data by using the database operation statements, and return the database data to the postman tool.
The implementation process of the functions and actions of each unit in the above device is specifically described in the implementation process of the corresponding step in the above method, and is not described herein again.
For the device embodiments, since they substantially correspond to the method embodiments, reference may be made to the partial description of the method embodiments for relevant points. The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of the invention. One of ordinary skill in the art can understand and implement it without inventive effort.
Other embodiments of the invention will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This invention is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the invention and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the invention being indicated by the following claims.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method of accessing a database by a postman tool, the method comprising:
compiling a database request containing a database operation statement through a postman tool, and sending the database request to a data cloud plug-in;
the data cloud plug-in obtains database data according to the database operation statements and returns the database data to the postman tool;
the postman tool is located on any electronic equipment, and the data cloud plug-in is located on the cloud server.
2. The method of claim 1, wherein composing a database request containing a database operation statement by a postman tool comprises:
acquiring a database operation statement and a required return data type by a postman tool;
the database request is generated by the postman tool using the static service address, the application service address, the database interface function path, and the retrieved database operation statements and return data types.
3. The method of claim 2, wherein the data cloud plug-in includes an application service and a static service, and wherein sending the database request to the data cloud plug-in via a postman tool comprises:
sending, by a postman tool, the database request to a static service to which the static service address points;
and sending the database request to the application service pointed by the application service address through the static service.
4. The method of claim 3, wherein the data cloud plugin acquires database data according to the database operation statement, and the method comprises:
inputting the database operation statement and the return data type as input parameters into a database interface function pointed by the database interface function path by the application service;
and acquiring database data according to the database operation statement and the returned data type through the database interface function.
5. The method of claim 4, wherein obtaining database data from the database operation statements and return data types via the database interface function comprises:
establishing connection with a database by using preset database configuration;
acquiring data in the database by using the database operation statement through the connection;
and converting the acquired data according to the type of the returned data to obtain database data.
6. The method of claim 5, wherein prior to establishing a connection with the database using the preset database configuration, the method further comprises:
judging whether the database operation statement is a query statement;
if yes, executing the step of establishing connection with the database by using preset database configuration.
7. The method of claim 5, wherein the database configuration comprises a connection address, a username, and a password for the database.
8. The method of claim 1, wherein after the data cloud plug-in returns the database data to the postman tool, the method further comprises:
utilizing, by the postman tool, the database data to assert an interface return value.
9. A postman tool access database apparatus, the apparatus comprising: the data acquisition module on the data request module and the cloud server on the electronic equipment:
the data request module is used for compiling a database request containing database operation statements through a postman tool and sending the database request to the cloud server;
and the data acquisition module is used for acquiring database data by using the database operation statements and returning the database data to the postman tool.
10. A postman tool access database system, comprising: the system comprises an electronic device and a cloud server;
the electronic equipment is used for compiling a database request containing a database operation statement through a postman tool and sending the database request to the cloud server;
and the cloud server is used for acquiring database data by using the database operation statements and returning the database data to the postman tool.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111204345.5A CN113641747B (en) | 2021-10-15 | 2021-10-15 | Method, device and system for accessing postman tool to database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111204345.5A CN113641747B (en) | 2021-10-15 | 2021-10-15 | Method, device and system for accessing postman tool to database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113641747A true CN113641747A (en) | 2021-11-12 |
| CN113641747B CN113641747B (en) | 2022-03-18 |
Family
ID=78427112
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111204345.5A Active CN113641747B (en) | 2021-10-15 | 2021-10-15 | Method, device and system for accessing postman tool to database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113641747B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122296A (en) * | 2017-04-18 | 2017-09-01 | 上海雷腾软件股份有限公司 | The method and apparatus that data for test interface are asserted |
| US10534701B1 (en) * | 2019-06-17 | 2020-01-14 | Capital One Services, Llc | API driven continuous testing systems for testing disparate software |
| WO2020155778A1 (en) * | 2019-02-03 | 2020-08-06 | 苏州市龙测智能科技有限公司 | Interface automation test method, test apparatus, test device and storage medium |
| CN112148610A (en) * | 2020-09-28 | 2020-12-29 | 深圳壹账通智能科技有限公司 | Test case execution method and device, computer equipment and storage medium |
| CN112650533A (en) * | 2020-12-22 | 2021-04-13 | 深圳前海微众银行股份有限公司 | Interface document generation method and device and terminal equipment |
-
2021
- 2021-10-15 CN CN202111204345.5A patent/CN113641747B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122296A (en) * | 2017-04-18 | 2017-09-01 | 上海雷腾软件股份有限公司 | The method and apparatus that data for test interface are asserted |
| WO2020155778A1 (en) * | 2019-02-03 | 2020-08-06 | 苏州市龙测智能科技有限公司 | Interface automation test method, test apparatus, test device and storage medium |
| US10534701B1 (en) * | 2019-06-17 | 2020-01-14 | Capital One Services, Llc | API driven continuous testing systems for testing disparate software |
| CN112148610A (en) * | 2020-09-28 | 2020-12-29 | 深圳壹账通智能科技有限公司 | Test case execution method and device, computer equipment and storage medium |
| CN112650533A (en) * | 2020-12-22 | 2021-04-13 | 深圳前海微众银行股份有限公司 | Interface document generation method and device and terminal equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113641747B (en) | 2022-03-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107861870B (en) | Interface test and test data generation method, device, terminal and storage medium | |
| CN110647469B (en) | Micro-service testing method and device, computer equipment and storage medium | |
| US9552281B2 (en) | Utilizing a test automation tool in a test automation environment | |
| CN110083650A (en) | A kind of data-query interfaces automatic generation method and system based on metadata self-discovery | |
| CN104111826A (en) | Software project development method and device | |
| CN107291608B (en) | Test script generation method, interface subscription/registration method and device | |
| CN111045652B (en) | Power distribution network development and service system | |
| CN113806037A (en) | Service calling method and device, storage medium and electronic equipment | |
| CN111309624B (en) | Test method, test device, test equipment and storage medium | |
| KR20190061060A (en) | Profile-based content and services | |
| CN104901845A (en) | Automation test system and method of domain name WHOIS service | |
| CN113839992B (en) | Equipment control method and device | |
| CN104954196A (en) | Automatic test method and system for DNS incremental data update service | |
| CN113238965B (en) | Interface test script generation method, system and storage medium | |
| CN113641747B (en) | Method, device and system for accessing postman tool to database | |
| CN113760733A (en) | Unit testing method and device | |
| CN115905314B (en) | Configuration data processing method, system, equipment and computer readable storage medium | |
| CN113055410A (en) | Cloud resource management method, device, equipment and system and readable storage medium | |
| CN108092959B (en) | BACnet protocol analysis method based on configuration | |
| CN113031928B (en) | Web system generation method and device, electronic equipment and computer readable storage medium | |
| CN112230938B (en) | Method and device for configuring rental products of industrial Internet | |
| CN103714035B (en) | Multilayer software bus structure for integrated environment | |
| CN114090625A (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN113342845A (en) | Data synchronization method, computer device and readable storage medium | |
| CN101251824B (en) | Method for testing public objects request proxy structure and tools |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20240514 Address after: 100102 room 1201, 12 / F, building 8, yard 34, Chuangyuan Road, Chaoyang District, Beijing Patentee after: Beijing new oxygen world wide Technology Consulting Co.,Ltd. Country or region after: China Address before: 100102 room 901, 9 / F, room 1001, 10 / F, building 8, yard 34, Chuangyuan Road, Chaoyang District, Beijing Patentee before: Beijing New Oxygen Technology Co.,Ltd. Country or region before: China |
|
| TR01 | Transfer of patent right |