CN111857752B - PostgreSQL database installation method, device and equipment - Google Patents
PostgreSQL database installation method, device and equipment Download PDFInfo
- Publication number
- CN111857752B CN111857752B CN202010710032.6A CN202010710032A CN111857752B CN 111857752 B CN111857752 B CN 111857752B CN 202010710032 A CN202010710032 A CN 202010710032A CN 111857752 B CN111857752 B CN 111857752B
- Authority
- CN
- China
- Prior art keywords
- target
- database
- command line
- postgresql
- 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.)
- Active
Links
- 238000009434 installation Methods 0.000 title claims abstract description 134
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000012360 testing method Methods 0.000 claims abstract description 108
- BUGBHKTXTAQXES-UHFFFAOYSA-N Selenium Chemical compound [Se] BUGBHKTXTAQXES-UHFFFAOYSA-N 0.000 claims abstract description 44
- 229910052711 selenium Inorganic materials 0.000 claims abstract description 44
- 239000011669 selenium Substances 0.000 claims abstract description 44
- 238000004590 computer program Methods 0.000 claims description 9
- 238000013515 script Methods 0.000 claims description 8
- 230000008569 process Effects 0.000 claims description 6
- 230000000694 effects Effects 0.000 abstract description 2
- 230000006870 function Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000011900 installation process Methods 0.000 description 4
- 230000001960 triggered effect Effects 0.000 description 4
- 230000006978 adaptation Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 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
- 230000009471 action Effects 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
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
Abstract
The invention discloses a PostgreSQL database installation method, which comprises the following steps: analyzing the received PostgreSQL database installation request to obtain a target linux system and target database version information; generating a target test case corresponding to the version information of the target database; the target test cases are sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test cases; 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, postgreSQL database installation equipment and a storage medium, which have corresponding technical effects.
Description
Technical Field
The present invention relates to the field of computer application technologies, and in particular, to a method, an apparatus, a device, and a computer readable storage medium for installing a postgreSQL database.
Background
With respect to the Linux operating system, each vendor has its own release version, while the open source database PostgreSQL has different installation versions and installation commands for these different Linux versions, and there are more or less differences in these installation commands. For example, if a PostgresSQL version 12 download command is yum install https:// download. Postgresql. Org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-repo-last. Noarch. Rpm for a Red Hat (Red Hat 7) architecture X86_64 system, and a Debian Buster (10. X) system download command is debhttp:// apt. Postgresql. Org/pub/repos/apt/Buster-pgdg main. And the download command can be obtained only by manually inputting the operation system by opening the website by the user, and the installation of the PostgreSQL database is manually completed, so that the technical requirement on the database installation of the user is high, time is wasted, and errors are easy to occur.
In summary, how to effectively solve the problems of high requirements on the database installation technology of the users, time waste and error easily caused by the existing manual postgreSQL database installation method is a problem which needs to be solved by those skilled in the art.
Disclosure of Invention
The invention aims to provide a PostgreSQL database installation method, which greatly reduces the technical requirement on the database installation of users, improves the database installation efficiency and reduces the installation error probability; it is another object of the present invention to provide a PostgreSQL database installation apparatus, device, and computer-readable storage medium.
In order to solve the technical problems, the invention provides the following technical scheme:
a PostgreSQL database installation method, comprising:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and version information of the target database;
generating a target test case corresponding to the target database version information;
the target test case is sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface 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 can perform PostgreSQL database installation operation based on each target command line.
In a specific embodiment of the present invention, the parsing of the received PostgreSQL database installation request to obtain the version information of the target database includes:
acquiring target system type information of the target linux system;
and determining the version information of the target database according to the type information of the target system.
In a specific embodiment of the present invention, obtaining the target system type information to which the target linux system belongs includes:
and acquiring the type information of the target system to which the target linux system belongs through the shell script.
In one 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 the latest database version information, and determining the latest database version information as the target database version information.
In one 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 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 calling the phastomjs interface-free browser by the selenium test tool to query each target command line corresponding to the target test case includes:
the selenium testing tool calls the phastomjs interface-free browser to inquire the downloading command line of each target database and the installing command line of each target database 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 operation based on each target command line, including:
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 performs PostgreSQL database downloading operation based on each target database downloading 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 version information of the target database;
the test case generation module is used for generating a target test case corresponding to the version information of the target database;
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 cantomJS non-interface 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 can perform PostgreSQL database installation operation based on each target command line.
In one embodiment of the present invention, the request parsing module includes:
the system type acquisition sub-module is used for acquiring the type information of the target system 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 executing the computer program.
A computer readable storage medium having stored thereon a computer program which when executed by a processor implements the steps of the PostgreSQL database installation method as described previously.
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 version information of the target database; generating a target test case corresponding to the version information of the target database; the target test cases are sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test cases; 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 automatically inquiring a target command line corresponding to the version information of the target database by using a selenium testing tool and a phasomjs interface-free browser by acquiring the version information of the target database, and completing automatic installation of the PostgreSQL database based on the target command line. The whole database installation process is automatically triggered, so that the technical requirement on the database installation of users is greatly reduced, the database installation efficiency is improved, and the installation error probability is reduced.
Correspondingly, the embodiment of the invention also provides a postgreSQL database installation device, equipment and a computer readable storage medium corresponding to the postgreSQL database installation method, which have the technical effects and are not repeated herein.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of one implementation of a PostgreSQL database installation method in accordance with an embodiment of the invention;
FIG. 2 is a flow chart of another implementation of the PostgreSQL database installation method in accordance with an embodiment of the invention;
FIG. 3 is a flow chart of another implementation of the PostgreSQL database installation method in accordance with an embodiment of the invention;
FIG. 4 is a block diagram of a PostgreSQL database installation device according to an embodiment of the invention;
fig. 5 is a block diagram of a PostgreSQL database installation apparatus according to an embodiment of the present invention.
Detailed Description
In order to better understand the aspects of the present invention, the present invention will be described in further detail with reference to the accompanying drawings and detailed description. It will be apparent that the described embodiments are only some, but not all, embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Embodiment one:
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 a target linux system to be installed in the database and version information of the target database.
And when the target linux system needs to perform PostgreSQL database installation, sending a PostgreSQL database installation request to a 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 subjected to PostgreSQL database installation, for example, may be a Debian operating system, a wu Ban Tu (ubuntu) operating system, a red cap operating system, or the like.
The PostgreSQL database is an object-relational database of very well-behaved free software, supporting most of the SQL standards and providing many other modern features such as complex queries, foreign keys, triggers, views, transaction integrity, multi-version concurrency control, etc. Likewise, the PostgreSQL database may be extended in many ways, for example by adding new data types, functions, operators, aggregation functions, indexing methods, procedural languages, etc.
S102: and generating a target test case corresponding to the version information of the target database.
After analyzing to obtain 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 cases to the selenium test tool so that the selenium test tool calls the cantomJS non-interface browser to inquire each target command line corresponding to the target test cases.
After the target test cases corresponding to the target database version information are generated, the target test cases are sent to a selenium test tool, and the selenium test tool calls a cantomJS interface-free browser to inquire each target command line corresponding to the target test cases.
The selenium test tool is a tool for Web application testing. The Selenium test tool runs directly in the browser as if the real user were operating. The main functions of the selenium test tool include: compatibility with browsers is tested, i.e., whether an application can work well on top of different browsers and operating systems. Testing system functions, i.e., creating regression testing to verify software functions and user requirements. Supporting automatic recording action and automatic generation of test scripts in different languages, such as Net, java, perl.
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.
After each target command line corresponding to the target test case is queried, each target command line is returned to the target linux system. 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 compared with the existing manual PostgreSQL database installation mode, the method greatly reduces the technical requirements for the database installation of users, 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 version information of the target database; generating a target test case corresponding to the version information of the target database; the target test cases are sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test cases; 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 automatically inquiring a target command line corresponding to the version information of the target database by using a selenium testing tool and a phasomjs interface-free browser by acquiring the version information of the target database, and completing automatic installation of the PostgreSQL database based on the target command line. The whole database installation process is automatically triggered, so that the technical requirement on the database installation of users is 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. The following embodiments relate to the same steps as those in the first embodiment or the steps corresponding to the first embodiment, and the corresponding beneficial effects can also be referred to each other, so that the following modified embodiments will not be repeated.
Embodiment two:
referring to fig. 2, fig. 2 is a flowchart illustrating another implementation of the PostgreSQL database installation method according to an embodiment of the present invention, which may include the steps of:
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.
And pre-deploying a shell script for acquiring system type information of the linux system, and acquiring target system type information of the target linux system through the shell script after analyzing to obtain the target linux system to be installed in the 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: when the target system type information is a Debian operating system or a ubuntu operating system, the latest database version information is acquired, and the latest database version information is determined as the target database version information.
Since the default latest database version information of the Debian operating system or the ubuntu operating system is the target database version information, when the target system type information is the Debian operating system or the ubuntu operating system, the latest database version information is acquired, and the latest database version information is determined as the target database version information.
S204: and generating a target test case corresponding to the version information of the target database.
S205: and sending the target test case to the selenium test tool so that the selenium test tool calls the phastomjs interface-free browser to inquire the downloading command line of each target database and the installing command line of each target database corresponding to the target test case.
After the selenium test tool receives the target test cases, a phastomjs interface-free browser is called to inquire the downloading command lines of the target databases and the installing command lines of the target databases corresponding to the target test cases.
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 performs PostgreSQL database downloading operation based on each target database downloading command line and performs PostgreSQL database installation operation based on each target database installation command line.
After inquiring to obtain the downloading command line and the installing command line of each target database corresponding to the target test case, returning the downloading command line and the installing command line of each target database to the target linux system. The target linux system performs PostgreSQL database downloading operations based on each target database downloading command line, and performs PostgreSQL database installing operations based on each target database installing command line. By searching the downloading command line of each target database and the installing command line of each target database, the command lines corresponding to the downloading process and the installing process of the PostgreSQL database are classified, the ordered downloading process and the installing process of the PostgreSQL database are promoted, and the installing efficiency of the PostgreSQL database is further improved.
The function of automatically acquiring website information without paging is realized through a selenium testing tool and a phastomjs non-interface browser. The current operating system type, such as "Debian GNU/Linux 9 (Stretch)", is automatically identified first, then the download page of PostgreSQL Debian is automatically opened and the Stretch is automatically selected (9.x), and finally the download command is acquired to automatically install the same. The method has the advantages that the webpage is not required to be opened to manually acquire the database downloading command line and manually input the database installation command line for installation, the accuracy of the command line is improved, and the increase of installation time caused by the occurrence of manual input of wrong command lines is avoided.
Embodiment III:
referring to fig. 3, fig. 3 is a flowchart illustrating another implementation of the PostgreSQL database installation method according to an embodiment of the present invention, which may include the steps of:
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 target system type information is the 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.
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, so that when the target system type information 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, thereby meeting the personalized requirements of the user.
S304: and generating a target test case corresponding to the version information of the target database.
S305: and sending the target test case to the selenium test tool so that the selenium test tool calls the phastomjs interface-free browser to inquire the downloading command line of each target database and the installing command line of each target database 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 performs PostgreSQL database downloading operation based on each target database downloading command line and performs 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 device, where the PostgreSQL database installation device described below and the postgreql database installation method described above may be referred to correspondingly.
Referring to fig. 4, fig. 4 is a block diagram illustrating a PostgreSQL database installation apparatus according to an embodiment of the present invention, the apparatus may include:
the request analysis module 41 is configured to analyze the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and version information of the target database;
the test case generation module 42 is configured to generate a target test case corresponding to the version information of the target database;
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 the cantomjs interface-free browser to query each target command line corresponding to the target test case;
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.
By applying the device 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 version information of the target database; generating a target test case corresponding to the version information of the target database; the target test cases are sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test cases; 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 automatically inquiring a target command line corresponding to the version information of the target database by using a selenium testing tool and a phasomjs interface-free browser by acquiring the version information of the target database, and completing automatic installation of the PostgreSQL database based on the target command line. The whole database installation process is automatically triggered, so that the technical requirement on the database installation of users is greatly reduced, the database installation efficiency is improved, and the installation error probability is reduced.
In one embodiment of the present invention, the request parsing module 41 includes:
the system type acquisition sub-module is used for acquiring the type information of the target system to which the target linux system belongs;
and the database version determining sub-module is used for determining target database version information according to the target system type information.
In a specific embodiment of the present invention, the system type obtaining submodule is specifically a module for obtaining, through a shell script, information of a target system type to which the target linux system belongs.
In one embodiment of the present invention, the database version determining submodule is specifically a module for acquiring the latest database version information when the target system type information is a Debian operating system or a ubuntu operating system, and determining the latest database version information as the target database version information.
In a specific embodiment of the present invention, the database version determining submodule is specifically a module for resolving the PostgreSQL database installation request to obtain preset database version information when the target system type information is a red cap operating system, and determining 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 invoking the phastomjs interface-free browser by the selenium test tool to query the download command lines of each target database and the installation command lines of each target database corresponding to the 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.
Corresponding to the above method embodiment, referring to fig. 5, fig. 5 is a schematic diagram of a PostgreSQL database installation apparatus 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 version information of the target database; generating a target test case corresponding to the version information of the target database; the target test cases are sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test cases; 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 description of the apparatus provided by the present invention, please refer to the above method embodiment, and the description of the present invention is omitted herein.
Corresponding to the above method embodiments, the present invention also provides a computer readable storage medium having a computer program stored thereon, which when executed by a processor, performs the steps of:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and version information of the target database; generating a target test case corresponding to the version information of the target database; the target test cases are sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test cases; 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: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
For the description of the computer-readable storage medium provided by the present invention, refer to the above method embodiments, and the disclosure is not repeated here.
In this specification, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different point from other embodiments, so that the same or similar parts between the embodiments are referred to each other. The apparatus, device and computer readable storage medium of the embodiments are described more simply because they correspond to the methods of the embodiments, and the description thereof will be given with reference to the method section.
The principles and embodiments of the present invention have been described herein with reference to specific examples, but the description of the examples above is only for aiding in understanding the technical solution of the present invention and its core ideas. It should be noted that it will be apparent to those skilled in the art that various modifications and adaptations of the invention can be made without departing from the principles of the invention and these modifications and adaptations are intended to be within the scope of the invention as defined in the following claims.
Claims (9)
1. A PostgreSQL database installation method, comprising:
analyzing the received PostgreSQL database installation request to obtain a target linux system to be installed in the database and version information of the target database;
generating a target test case corresponding to the target database version information;
the target test case is sent to a selenium test tool, so that the selenium test tool calls a cantomJS non-interface browser to inquire each target command line corresponding to the target test case; the process of calling the phastomjs interface-free browser to query each target command line corresponding to the target test case by the selenium test tool comprises the following steps: the selenium testing tool calls the phastomjs interface-free browser to inquire the downloading command line of each target database and the installing command line of each target database 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 operation based on each target command line; wherein the returning each target command line to the target linux system to enable the target linux system to perform PostgreSQL database installation operation based on each target command line includes: 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 performs PostgreSQL database downloading operation based on each target database downloading command line and performs PostgreSQL database installation operation based on each target database installation command line.
2. The PostgreSQL database installation method of claim 1, wherein parsing the received PostgreSQL database installation request to obtain the target database version information comprises:
acquiring target system type information of the target linux system;
and determining the version information of the target database according to the type information of the target system.
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 acquiring the type information of the target system to which the target linux system belongs through the shell script.
4. The PostgreSQL database installation method of 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 the latest database version information, and determining the latest database version information as the target database version information.
5. The PostgreSQL database installation method of 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 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. 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 version information of the target database;
the test case generation module is used for generating a target test case corresponding to the version information of the target database;
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 cantomJS non-interface browser to query each target command line corresponding to the target test case; the command line query module is specifically configured to: the selenium testing tool calls the phastomjs interface-free browser to inquire the downloading command line of each target database and the installing command line of each target database corresponding to the target test case;
the database installation module is used for returning each target command line to the target linux system so that the target linux system can perform PostgreSQL database installation operation based on each target command line; the database installation module is specifically configured to: 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 performs PostgreSQL database downloading operation based on each target database downloading command line and performs PostgreSQL database installation operation based on each target database installation command line.
7. The PostgreSQL database installation apparatus of claim 6, wherein the request resolution module comprises:
the system type acquisition sub-module is used for acquiring the type information of the target system 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.
8. 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 according to any one of claims 1 to 5 when said computer program is executed.
9. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of the PostgreSQL database installation method according to any one of claims 1 to 5.
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 CN111857752A (en) | 2020-10-30 |
| CN111857752B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117215839B (en) * | 2023-10-30 | 2024-03-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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111857752A (en) | 2020-10-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109032631B (en) | Application program patch package obtaining method and device, computer equipment and storage medium | |
| CN109255107A (en) | Configuration software processing method, device, computer equipment and storage medium | |
| CN111240955A (en) | Automatic testing method and device for Http interface, storage medium and electronic device | |
| CN111679852B (en) | Detection method and device for conflict dependency library | |
| CN110716874A (en) | Method for testing hardware compatibility of domestic operating system | |
| CN111857752B (en) | PostgreSQL database installation method, device and equipment | |
| CN115167831A (en) | Software integration method and device based on AUTOSAR and use method | |
| US20210026756A1 (en) | Deriving software application dependency trees for white-box testing | |
| CN111026670A (en) | Test case generation method, test case generation device, and storage medium | |
| CN114153473A (en) | Module integration method, device, storage medium and electronic equipment | |
| CN103246605A (en) | Method and system for collocating remote controller key values based on xml (extensive markup language) | |
| CN111241111B (en) | Data query method and device, data comparison method and device, medium and equipment | |
| CN110727482A (en) | Interface updating method and device | |
| CN110968339B (en) | Method and device for front-end building tool and electronic equipment | |
| CN114064601B (en) | Storage process conversion method, device, equipment and storage medium | |
| CN115129598A (en) | Risk detection method, device, system and medium for SQL (structured query language) statements | |
| CN114201399A (en) | Method, device, equipment and storage medium for identifying influence range of program change | |
| CN111506339A (en) | Method and device for processing change information of Software Development Kit (SDK) | |
| CN111459492A (en) | Method, device, storage medium and equipment for detecting compatibility of Dubbo service interface | |
| CN110716949A (en) | Method, device, medium and electronic equipment for automatically optimizing structured query statement | |
| KR101737575B1 (en) | Method and device for verifying data based on sql sentences generated automatically | |
| CN114416104B (en) | Structured data file processing method and device | |
| CN113568601B (en) | Model software automatic integration and dynamic and static verification method based on integrated configuration file | |
| CN113190456B (en) | Test method, test device, electronic equipment and storage medium | |
| CN108776591B (en) | System and method for packaging domestic platform software |
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 |