CN111857752A - PostgreSQL database installation method, device and equipment - Google Patents
PostgreSQL database installation method, device and equipment Download PDFInfo
- Publication number
- CN111857752A CN111857752A CN202010710032.6A CN202010710032A CN111857752A CN 111857752 A CN111857752 A CN 111857752A CN 202010710032 A CN202010710032 A CN 202010710032A CN 111857752 A CN111857752 A CN 111857752A
- Authority
- CN
- China
- Prior art keywords
- target
- database
- postgresql
- command line
- installation
- 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
- 238000009434 installation Methods 0.000 title claims abstract description 137
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000012360 testing method Methods 0.000 claims abstract description 107
- BUGBHKTXTAQXES-UHFFFAOYSA-N Selenium Chemical compound [Se] BUGBHKTXTAQXES-UHFFFAOYSA-N 0.000 claims abstract description 43
- 229910052711 selenium Inorganic materials 0.000 claims abstract description 43
- 239000011669 selenium Substances 0.000 claims abstract description 43
- 238000004590 computer program Methods 0.000 claims description 10
- 238000013515 script Methods 0.000 claims description 8
- 230000000694 effects Effects 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 6
- 238000011900 installation process Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000001960 triggered effect Effects 0.000 description 4
- 230000006872 improvement Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- ZBMRKNMTMPPMMK-UHFFFAOYSA-N 2-amino-4-[hydroxy(methyl)phosphoryl]butanoic acid;azane Chemical compound [NH4+].CP(O)(=O)CCC(N)C([O-])=O ZBMRKNMTMPPMMK-UHFFFAOYSA-N 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/61—Installation
-
- 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/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- 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/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a PostgreSQL database installation method, which comprises the following steps: analyzing the received PostgreSQL database installation request to obtain target linux system and target database version information; generating a target test case corresponding to the target database version information; sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case; and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line. The invention improves the database installation efficiency and reduces the installation error probability. The invention also discloses a postgreSQL database installation device, equipment and a storage medium, and the postgreSQL database installation device, the equipment and the storage medium have corresponding technical effects.
Description
Technical Field
The invention relates to the technical field of computer application, in particular to a postgreSQL database installation method, a postgreSQL database installation device, postgreSQL database installation equipment and a computer-readable storage medium.
Background
With respect to the Linux operating system, each vendor has its own release version, and the developer database PostgreSQL has different installation versions and installation commands for these different Linux versions, and these installation commands are more or less different. For example, if a system with a Red cap (Red Hat 7) architecture of X86_64 is provided with a download command of PostgressSQL 12 version as yum install https:// download.postgressql.org/pub/repos/yum/reprpms/EL-7-X86 _ 64/pgdg-reda t-repo-est.nanoarch.rpm, while a download command of Debian Buster (10.X) system is deb http:// apt.postgressql.org/pub/repos/apt/Buster-pgdg main. And the downloading command can be acquired only by opening a website and manually inputting the operation system to select, and the postgreSQL database is manually installed, so that the technical requirement on the installation of the database of the user is high, the time is wasted, and errors are easy to occur.
To sum up, how to effectively solve the problems that the existing manual postgreSQL database installation mode has high requirements on the database installation technology of the user, wastes time, makes mistakes easily and the like is a problem that needs to be solved urgently by a person skilled in the art at present.
Disclosure of Invention
The invention aims to provide a PostgreSQL database installation method, which greatly reduces the technical requirements on the installation of a database of a user, improves the installation efficiency of the database and reduces the installation error probability; another object of the present invention is to provide a PostgreSQL database installation apparatus, a device, and a computer-readable storage medium.
In order to solve the technical problems, the invention provides the following technical scheme:
a PostgreSQL database installation method comprises the following steps:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and target database version information;
generating a target test case corresponding to the target database version information;
sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire each target command line corresponding to the target test case;
And returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
In a specific embodiment of the present invention, parsing a received PostgreSQL database installation request to obtain target database version information includes:
acquiring target system type information to which the target linux system belongs;
and determining the target database version information according to the target system type information.
In a specific embodiment of the present invention, the obtaining of the target system type information to which the target linux system belongs includes:
and obtaining the type information of the target system to which the target linux system belongs through the shell script.
In a specific embodiment of the present invention, determining the target database version information according to the target system type information includes:
and when the target system type information is a Debian operating system or a ubuntu operating system, acquiring latest database version information, and determining the latest database version information as the target database version information.
In a specific embodiment of the present invention, determining the target database version information according to the target system type information includes:
When the target system type information is a red-cap operating system, analyzing the PostgreSQL database installation request to obtain preset database version information, and determining the preset database version information as the target database version information.
In a specific embodiment of the present invention, the process of the selenium test tool calling phantomJS non-interface browser to query each target command line corresponding to the target test case includes:
the selenium test tool calls the phantomJS interface-free browser to inquire each target database downloading command line and each target database installing command line corresponding to the target test case;
returning each target command line to the target linux system, so that the target linux system performs postgreSQL database installation operations based on each target command line, including:
and returning each target database download command line and each target database installation command line to the target linux system, so that the target linux system performs PostgreSQL database download operation based on each target database download command line and performs PostgreSQL database installation operation based on each target database installation command line.
A PostgreSQL database installation apparatus comprising:
the request analysis module is used for analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and target database version information;
the test case generation module is used for generating a target test case corresponding to the target database version information;
the command line query module is used for sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to query each target command line corresponding to the target test case;
and the database installation module is used for returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
In a specific embodiment of the present invention, the request parsing module includes:
the system type acquisition sub-module is used for acquiring target system type information to which the target linux system belongs;
and the database version determining submodule is used for determining the target database version information according to the target system type information.
A PostgreSQL database installation apparatus comprising:
a memory for storing a computer program;
a processor for implementing the steps of the PostgreSQL database installation method as described above when the computer program is executed.
A computer-readable storage medium having stored thereon a computer program which, when executed by a processor, carries out the steps of the PostgreSQL database installation method as set forth above.
By applying the method provided by the embodiment of the invention, the received PostgreSQL database installation request is analyzed to obtain the target linux system to be installed in the database and the target database version information; generating a target test case corresponding to the target database version information; sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case; and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line. By acquiring the version information of the target database, a selenium test tool and a phantomJS non-interface browser are utilized to automatically query a target command line corresponding to the version information of the target database, and the automatic installation of the PostgreSQL database is completed based on the target command line. The whole database installation process is automatically triggered and completed, so that the technical requirements on the database installation of users are greatly reduced, the database installation efficiency is improved, and the installation error probability is reduced.
Accordingly, embodiments of the present invention further provide a PostgreSQL database installation apparatus, a device, and a computer-readable storage medium corresponding to the PostgreSQL database installation method, which have the above technical effects, and are not described herein again.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of an implementation of a method for installing a PostgreSQL database according to an embodiment of the present invention;
FIG. 2 is a flowchart of another implementation of a PostgreSQL database installation method according to an embodiment of the present invention;
FIG. 3 is a flowchart of another implementation of a PostgreSQL database installation method according to an embodiment of the present invention;
fig. 4 is a block diagram of a PostgreSQL database installation apparatus according to an embodiment of the present invention;
fig. 5 is a block diagram of a PostgreSQL database installation device according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the disclosure, the invention will be described in further detail with reference to the accompanying drawings and specific embodiments. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The first embodiment is as follows:
referring to fig. 1, fig. 1 is a flowchart illustrating an implementation of a PostgreSQL database installation method according to an embodiment of the present invention, where the method may include the following steps:
s101: and analyzing the received PostgreSQL database installation request to obtain the target linux system to be installed in the database and the target database version information.
And when the target linux system needs to install the PostgreSQL database, sending a PostgreSQL database installation request to the database installation center. And the database installation center receives the PostgreSQL database installation request and analyzes the received PostgreSQL database installation request to obtain the target linux system and the target database version information to be installed in the database.
The target linux system may be any linux system to be installed with a PostgreSQL database, such as a Debian operating system, a wubang (ubuntu) operating system, a red hat operating system, and the like.
The PostgreSQL database is a very full-featured, free-software object-relational database that supports most SQL standards and provides many other modern features such as complex queries, foreign keys, triggers, views, transaction integrity, multi-version concurrency control, and the like. Likewise, the PostgreSQL database may also be extended in many ways, such as by adding new data types, functions, operators, aggregation functions, indexing methods, procedural languages, and the like.
S102: and generating a target test case corresponding to the target database version information.
And after analyzing the target linux system and the target database version information, generating a target test case (test case) corresponding to the target database version information.
S103: and sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case.
After the target test case corresponding to the target database version information is generated, the target test case is sent to a selenium test tool, and the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case.
The selenium test tool is a tool for Web application testing. The Selenium test tool runs directly in the browser, just as a real user is operating. The main functions of the selenium test tool include: compatibility with browsers, i.e. testing whether an application can work well on different browsers and operating systems, is tested. And testing system functions, namely creating regression testing verification software functions and user requirements. And test scripts of different languages such as Net, Java, Perl and the like are supported to be automatically recorded and automatically generated.
S104: and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
And after all target command lines corresponding to the target test cases are inquired, returning all the target command lines to the target linux system. And after receiving each target command line, the target linux system performs PostgreSQL database installation operation based on each target command line. The whole database installation process is automatically triggered and completed, and compared with the existing manual PostgreSQL database installation mode, the method greatly reduces the technical requirements on the user for database installation, improves the database installation efficiency and reduces the installation error probability.
By applying the method provided by the embodiment of the invention, the received PostgreSQL database installation request is analyzed to obtain the target linux system to be installed in the database and the target database version information; generating a target test case corresponding to the target database version information; sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case; and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line. By acquiring the version information of the target database, a selenium test tool and a phantomJS non-interface browser are utilized to automatically query a target command line corresponding to the version information of the target database, and the automatic installation of the PostgreSQL database is completed based on the target command line. The whole database installation process is automatically triggered and completed, so that the technical requirements on the database installation of users are greatly reduced, the database installation efficiency is improved, and the installation error probability is reduced.
It should be noted that, based on the first embodiment, the embodiment of the present invention further provides a corresponding improvement scheme. In the following embodiments, steps that are the same as or correspond to those in the first embodiment may be referred to each other, and corresponding advantageous effects may also be referred to each other, which are not described in detail in the following modified embodiments.
Example two:
referring to fig. 2, fig. 2 is a flowchart of another implementation of a method for installing a PostgreSQL database according to an embodiment of the present invention, where the method may include the following steps:
s201: and analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database.
S202: and obtaining the type information of the target system to which the target linux system belongs through the shell script.
The method comprises the steps of deploying a shell script for acquiring system type information to which a linux system belongs in advance, and acquiring target system type information to which the target linux system belongs through the shell script after analyzing to obtain the target linux system to be installed in a database. Therefore, the automatic identification of the type information of the target system to which the target linux system belongs is realized, and a foundation is laid for the automatic installation of the whole PostgreSQL database.
S203: and when the target system type information is the Debian operating system or the ubuntu operating system, acquiring the latest database version information, and determining the latest database version information as the target database version information.
Because the default latest database version information of the Debian operating system or the ubuntu operating system is the target database version information, when the type information of the target system is the Debian operating system or the ubuntu operating system, the latest database version information is obtained, and the latest database version information is determined as the target database version information.
S204: and generating a target test case corresponding to the target database version information.
S205: and sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire each target database download command line and each target database installation command line corresponding to the target test case.
After the selenium test tool receives the target test case, a phantomJS non-interface browser is called to inquire each target database downloading command line and each target database installing command line corresponding to the target test case.
S206: and returning each target database downloading command line and each target database installation command line to the target linux system, so that the target linux system carries out PostgreSQL database downloading operation based on each target database downloading command line and carries out PostgreSQL database installation operation based on each target database installation command line.
And after the target database downloading command lines and the target database installation command lines corresponding to the target test cases are obtained through query, returning the target database downloading command lines and the target database installation command lines to the target linux system. The target linux system performs PostgreSQL database download operation based on each target database download command line, and performs PostgreSQL database installation operation based on each target database installation command line. The command lines corresponding to the PostgreSQL database downloading and PostgreSQL database installation processes are classified by respectively searching the target database downloading command lines and the target database installation command lines, so that the PostgreSQL database downloading and the PostgreSQL database installation are promoted to be carried out in order, and the PostgreSQL database installation efficiency is further improved.
The function of automatically acquiring website information without page is realized through a selenium test tool and a phantomJS interface-free browser. The method comprises the steps of firstly automatically recognizing the current operating system type, such as 'Debian GNU/Linux 9 (Stretch'), then automatically opening a download page of PostgreSQL Debian and automatically selecting the Stretch (9.x), and finally obtaining a download command to automatically install the download page. The webpage does not need to be opened to manually acquire the database downloading command line and manually input the database installation command line for installation, so that the accuracy of the command line is improved, and the increase of the installation time caused by the manual input of a wrong command line is avoided.
Example three:
referring to fig. 3, fig. 3 is a flowchart of another implementation of a method for installing a PostgreSQL database according to an embodiment of the present invention, where the method may include the following steps:
s301: and analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database.
S302: and obtaining the type information of the target system to which the target linux system belongs through the shell script.
S303: and when the type information of the target system is a red cap operating system, analyzing the PostgreSQL database installation request to obtain preset database version information, and determining the preset database version information as the target database version information.
Because the red-cap operating system determines the target database version information according to the database version information preset by the user, and the preset database version information is not necessarily the latest database version information, when the type information of the target system is the red-cap operating system, the PostgreSQL database installation request is analyzed to obtain the preset database version information, and the preset database version information is determined as the target database version information, so that the personalized requirements of the user are met.
S304: and generating a target test case corresponding to the target database version information.
S305: and sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire each target database download command line and each target database installation command line corresponding to the target test case.
S306: and returning each target database downloading command line and each target database installation command line to the target linux system, so that the target linux system carries out PostgreSQL database downloading operation based on each target database downloading command line and carries out PostgreSQL database installation operation based on each target database installation command line.
Corresponding to the above method embodiment, the embodiment of the present invention further provides a PostgreSQL database installation apparatus, and the PostgreSQL database installation apparatus described below and the PostgreSQL database installation method described above may be referred to in correspondence with each other.
Referring to fig. 4, fig. 4 is a block diagram illustrating a PostgreSQL database installation apparatus according to an embodiment of the present invention, where the apparatus may include:
a request analysis module 41, configured to analyze the received PostgreSQL database installation request to obtain target linux system and target database version information of the database to be installed;
the test case generation module 42 is used for generating a target test case corresponding to the target database version information;
the command line query module 43 is configured to send the target test case to the selenium test tool, so that the selenium test tool invokes a phantomJS interface-free browser to query each target command line corresponding to the target test case;
and the database installation module 44 is configured to return each target command line to the target linux system, so that the target linux system performs a PostgreSQL database installation operation based on each target command line.
The device provided by the embodiment of the invention is applied to analyze the received PostgreSQL database installation request to obtain the target linux system to be installed in the database and the target database version information; generating a target test case corresponding to the target database version information; sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case; and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line. By acquiring the version information of the target database, a selenium test tool and a phantomJS non-interface browser are utilized to automatically query a target command line corresponding to the version information of the target database, and the automatic installation of the PostgreSQL database is completed based on the target command line. The whole database installation process is automatically triggered and completed, so that the technical requirements on the database installation of users are greatly reduced, the database installation efficiency is improved, and the installation error probability is reduced.
In an embodiment of the present invention, the request parsing module 41 includes:
the system type acquisition submodule is used for acquiring target system type information to which the target linux system belongs;
and the database version determining submodule is used for determining the target database version information according to the target system type information.
In a specific embodiment of the present invention, the system type obtaining sub-module is specifically a module that obtains target system type information to which a target linux system belongs through a shell script.
In a specific embodiment of the present invention, the database version determination sub-module is specifically a module that, when the target system type information is the Debian operating system or the ubuntu operating system, obtains the latest database version information, and determines the latest database version information as the target database version information.
In a specific embodiment of the present invention, the database version determination submodule is specifically a module that, when the target system type information is a red-hat operating system, analyzes the PostgreSQL database installation request to obtain preset database version information, and determines the preset database version information as the target database version information.
In a specific embodiment of the present invention, the command line query module 43 is specifically a module for a selenium test tool to invoke a phantomJS non-interface browser to query each target database download command line and each target database installation command line corresponding to a target test case;
The database installation module 44 is specifically a module that returns each target database download command line and each target database installation command line to the target linux system, so that the target linux system performs a PostgreSQL database download operation based on each target database download command line, and performs a PostgreSQL database installation operation based on each target database installation command line.
In correspondence to the above method embodiment, referring to fig. 5, fig. 5 is a schematic diagram of a PostgreSQL database installation device provided by the present invention, which may include:
a memory 51 for storing a computer program;
the processor 52, when executing the computer program stored in the memory 51, may implement the following steps:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and target database version information; generating a target test case corresponding to the target database version information; sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case; and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
For the introduction of the device provided by the present invention, please refer to the above method embodiment, which is not described herein again.
Corresponding to the above method embodiment, the present invention further provides a computer-readable storage medium having a computer program stored thereon, the computer program, when executed by a processor, implementing the steps of:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and target database version information; generating a target test case corresponding to the target database version information; sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire all target command lines corresponding to the target test case; and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
The computer-readable storage medium may include: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
For the introduction of the computer-readable storage medium provided by the present invention, please refer to the above method embodiments, which are not described herein again.
The embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts among the embodiments are referred to each other. The device, the apparatus and the computer-readable storage medium disclosed in the embodiments correspond to the method disclosed in the embodiments, so that the description is simple, and the relevant points can be referred to the description of the method.
The principle and the implementation of the present invention are explained in the present application by using specific examples, and the above description of the embodiments is only used to help understanding the technical solution and the core idea of the present invention. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.
Claims (10)
1. A PostgreSQL database installation method is characterized by comprising the following steps:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and target database version information;
Generating a target test case corresponding to the target database version information;
sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to inquire each target command line corresponding to the target test case;
and returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
2. The PostgreSQL database installation method according to claim 1, wherein parsing the received PostgreSQL database installation request to obtain target database version information comprises:
acquiring target system type information to which the target linux system belongs;
and determining the target database version information according to the target system type information.
3. The PostgreSQL database installation method according to claim 2, wherein obtaining target system type information to which the target linux system belongs comprises:
and obtaining the type information of the target system to which the target linux system belongs through the shell script.
4. The PostgreSQL database installation method according to claim 2, wherein determining the target database version information from the target system type information comprises:
And when the target system type information is a Debian operating system or a ubuntu operating system, acquiring latest database version information, and determining the latest database version information as the target database version information.
5. The PostgreSQL database installation method according to claim 2, wherein determining the target database version information from the target system type information comprises:
when the target system type information is a red-cap operating system, analyzing the PostgreSQL database installation request to obtain preset database version information, and determining the preset database version information as the target database version information.
6. The PostgreSQL database installation method according to any one of claims 1 to 5, wherein the step of the selenium test tool calling a phantomJS interface-less browser to query each target command line corresponding to the target test case comprises:
the selenium test tool calls the phantomJS interface-free browser to inquire each target database downloading command line and each target database installing command line corresponding to the target test case;
returning each target command line to the target linux system, so that the target linux system performs postgreSQL database installation operations based on each target command line, including:
And returning each target database download command line and each target database installation command line to the target linux system, so that the target linux system performs PostgreSQL database download operation based on each target database download command line and performs PostgreSQL database installation operation based on each target database installation command line.
7. A PostgreSQL database installation apparatus, comprising:
the request analysis module is used for analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and target database version information;
the test case generation module is used for generating a target test case corresponding to the target database version information;
the command line query module is used for sending the target test case to a selenium test tool so that the selenium test tool calls a phantomJS interface-free browser to query each target command line corresponding to the target test case;
and the database installation module is used for returning each target command line to the target linux system so that the target linux system performs PostgreSQL database installation operation based on each target command line.
8. The PostgreSQL database installation apparatus according to claim 7, wherein the request parsing module comprises:
the system type acquisition sub-module is used for acquiring target system type information to which the target linux system belongs;
and the database version determining submodule is used for determining the target database version information according to the target system type information.
9. A PostgreSQL database installation device, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the PostgreSQL database installation method according to any of claims 1 to 6 when executing the computer program.
10. A computer-readable storage medium, having stored thereon a computer program which, when being executed by a processor, carries out the steps of the PostgreSQL database installation method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010710032.6A CN111857752B (en) | 2020-07-22 | 2020-07-22 | PostgreSQL database installation method, device and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010710032.6A CN111857752B (en) | 2020-07-22 | 2020-07-22 | PostgreSQL database installation method, device and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111857752A true CN111857752A (en) | 2020-10-30 |
| CN111857752B CN111857752B (en) | 2023-08-08 |
Family
ID=73001414
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010710032.6A Active CN111857752B (en) | 2020-07-22 | 2020-07-22 | PostgreSQL database installation method, device and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111857752B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112732279A (en) * | 2021-01-11 | 2021-04-30 | 中国船舶重工集团公司第七0七研究所 | PostgressSQL-based automatic database installation and deployment method |
| CN117215839A (en) * | 2023-10-30 | 2023-12-12 | 广州鼎甲计算机科技有限公司 | Web-based system restoration method, apparatus, device, medium, and program product |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107656867A (en) * | 2017-09-14 | 2018-02-02 | 中标软件有限公司 | A kind of method and apparatus of database and Compatibility of Operating System authentication test |
| WO2018103223A1 (en) * | 2016-12-09 | 2018-06-14 | 武汉斗鱼网络科技有限公司 | Method and device for operating database |
| CN108197021A (en) * | 2017-12-28 | 2018-06-22 | 深圳市彬讯科技有限公司 | A kind of web system automated testing method, device, equipment and storage medium |
| WO2018233037A1 (en) * | 2017-06-20 | 2018-12-27 | 平安科技（深圳）有限公司 | Database integration testing method, device, server, and storage medium |
| CN109241035A (en) * | 2018-08-28 | 2019-01-18 | 福建南威软件有限公司 | A kind of custom script realizes the automatic deployment method of database |
| CN109857411A (en) * | 2018-12-13 | 2019-06-07 | 正方软件股份有限公司 | The method and device of installation database under linux system |
| CN110990016A (en) * | 2019-11-29 | 2020-04-10 | 浪潮商用机器有限公司 | Method, device, equipment and page for acquiring commands of Linux operating system |
-
2020
- 2020-07-22 CN CN202010710032.6A patent/CN111857752B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018103223A1 (en) * | 2016-12-09 | 2018-06-14 | 武汉斗鱼网络科技有限公司 | Method and device for operating database |
| WO2018233037A1 (en) * | 2017-06-20 | 2018-12-27 | 平安科技（深圳）有限公司 | Database integration testing method, device, server, and storage medium |
| CN107656867A (en) * | 2017-09-14 | 2018-02-02 | 中标软件有限公司 | A kind of method and apparatus of database and Compatibility of Operating System authentication test |
| CN108197021A (en) * | 2017-12-28 | 2018-06-22 | 深圳市彬讯科技有限公司 | A kind of web system automated testing method, device, equipment and storage medium |
| CN109241035A (en) * | 2018-08-28 | 2019-01-18 | 福建南威软件有限公司 | A kind of custom script realizes the automatic deployment method of database |
| CN109857411A (en) * | 2018-12-13 | 2019-06-07 | 正方软件股份有限公司 | The method and device of installation database under linux system |
| CN110990016A (en) * | 2019-11-29 | 2020-04-10 | 浪潮商用机器有限公司 | Method, device, equipment and page for acquiring commands of Linux operating system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112732279A (en) * | 2021-01-11 | 2021-04-30 | 中国船舶重工集团公司第七0七研究所 | PostgressSQL-based automatic database installation and deployment method |
| CN117215839A (en) * | 2023-10-30 | 2023-12-12 | 广州鼎甲计算机科技有限公司 | Web-based system restoration method, apparatus, device, medium, and program product |
| CN117215839B (en) * | 2023-10-30 | 2024-03-12 | 广州鼎甲计算机科技有限公司 | Web-based system restoration method, apparatus, device, medium, and program product |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111857752B (en) | 2023-08-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109684847B (en) | Automatic repairing method, device, equipment and storage medium for script loopholes | |
| CN101930400A (en) | SDK (Software Development Kit) automatic test system and method | |
| US11422917B2 (en) | Deriving software application dependency trees for white-box testing | |
| CN112559354A (en) | Front-end code specification detection method and device, computer equipment and storage medium | |
| CN113505073B (en) | Performance test method, device, equipment and medium of database | |
| CN110688305B (en) | Test environment synchronization method, device, medium and electronic equipment | |
| CN111240955A (en) | Automatic testing method and device for Http interface, storage medium and electronic device | |
| CN111857752A (en) | PostgreSQL database installation method, device and equipment | |
| CN109032631A (en) | Application program service packs acquisition methods, device, computer equipment and storage medium | |
| CN111026670A (en) | Test case generation method, test case generation device, and storage medium | |
| CN112615758A (en) | Application identification method, device, equipment and storage medium | |
| CN112231206A (en) | Script editing method for application program test, computer readable storage medium and test platform | |
| CN112052037A (en) | Application software development method, device, equipment and medium | |
| CN116627850B (en) | Function debugging method and device, storage medium and electronic equipment | |
| CN111506339A (en) | Method and device for processing change information of Software Development Kit (SDK) | |
| CN116226871A (en) | Vulnerability verification method, device and medium based on static and dynamic combination | |
| CN108132799B (en) | Inter-process static program analysis information extraction method, device and equipment | |
| CN113946509A (en) | Buried point searching and comparing method and device, computing device and readable storage medium | |
| CN112003647B (en) | Detection method, device and equipment for recycled optical modem and storage medium | |
| CN111309311B (en) | Vulnerability detection tool generation method, device, equipment and readable storage medium | |
| CN114296738A (en) | Method for determining compiled directory, computer equipment and storage medium | |
| CN113805861A (en) | Code generation method based on machine learning, code editing system and storage medium | |
| CN113761402A (en) | Link debugging method, device, equipment and storage medium | |
| CN113608996B (en) | Mirror image compiling test method, system, device and readable storage medium | |
| CN111151008A (en) | Game operation data verification method, device, configuration background and medium |
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 |