CN109101242B - Data base automatic dispositions method and device - Google Patents
Data base automatic dispositions method and device Download PDFInfo
- Publication number
- CN109101242B CN109101242B CN201810795367.5A CN201810795367A CN109101242B CN 109101242 B CN109101242 B CN 109101242B CN 201810795367 A CN201810795367 A CN 201810795367A CN 109101242 B CN109101242 B CN 109101242B
- Authority
- CN
- China
- Prior art keywords
- database
- script
- automatic
- data base
- deployment
- 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
- 238000000034 method Methods 0.000 title claims abstract description 79
- 239000010409 thin film Substances 0.000 claims description 31
- 239000010408 film Substances 0.000 claims description 19
- 238000009434 installation Methods 0.000 claims description 18
- 230000008569 process Effects 0.000 claims description 16
- 238000004088 simulation Methods 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 9
- 230000008901 benefit Effects 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 9
- 238000004891 communication Methods 0.000 description 6
- 238000004590 computer program Methods 0.000 description 6
- 230000008859 change Effects 0.000 description 4
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000004927 fusion Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000004806 packaging method and process Methods 0.000 description 2
- 238000005267 amalgamation Methods 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 230000035800 maturation Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000012163 sequencing technique Methods 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
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of data base automatic dispositions method and devices, it is related to technical field of data processing, the data base automatic dispositions method, comprising: the Disposition Instructions for receiving user execute the automatically dispose script for being applied to MYSQL database deployment constructed in advance according to Disposition Instructions.The data base automatic dispositions method can alleviate the problem of deployment of database in the prior art is by existing low efficiency, high labor cost is manually disposed, and can be improved deployment efficiency, reduce cost of labor.In addition, this method also has following implementation cost low, simple and reliable advantage.
Description
Technical field
The present invention relates to technical field of data processing, more particularly, to a kind of data base automatic dispositions method and device.
Background technique
Currently, needing to dispose database in software development process, the deployment of database is computer technology neck
An important content in domain.
However, in the prior art, the dispositions method of database is disposed by artificial mode, i.e. developer's hand
Dynamic carries out operation deployment, low efficiency, high labor cost to database；Further, since there are people for the deployment of existing database
For factor, configuration process is error-prone.
There has been no effective solution methods at present regarding to the issue above.
Summary of the invention
In view of this, the purpose of the present invention is to provide a kind of data base automatic dispositions method and device, it is existing to alleviate
There is the problem of deployment of the database in technology is by existing low efficiency, high labor cost is manually disposed, can be improved
Efficiency is disposed, cost of labor is reduced.
In a first aspect, the embodiment of the invention provides a kind of data base automatic dispositions methods, comprising:
Receive the Disposition Instructions of user
The automatically dispose script for being applied to MYSQL database deployment constructed in advance is executed according to the Disposition Instructions.
With reference to first aspect, the embodiment of the invention provides the first possible embodiments of first aspect, wherein institute
State the automatically dispose script for being applied to MYSQL database deployment for executing according to the Disposition Instructions and constructing in advance, comprising:
Obtain database path；
Automatic installation database service；
Database is initialized；
Automatic log-on data library service.
The possible embodiment of with reference to first aspect the first, the embodiment of the invention provides second of first aspect
Possible embodiment, wherein described to be applied to what MYSQL database was disposed according to what Disposition Instructions execution constructed in advance
Automatically dispose script, further includes:
Judge whether database service starting succeeds；
If so, executing database auto-initiation script.
The possible embodiment of with reference to first aspect the first, the embodiment of the invention provides the third of first aspect
Possible embodiment, wherein the automatic installation database service, comprising:
Create data file catalogue；
Automatic configuration Parameter File；
File directory and the Parameter File installation database service based on the data.
The third possible embodiment with reference to first aspect, the embodiment of the invention provides the 4th kind of first aspect
Possible embodiment, wherein the automatic configuration Parameter File, comprising:
Judge the catalogue with the presence or absence of Parameter File；
If it is not, then generating Parameter File；
Forbidden character in path parameter in Parameter File is replaced.
The 4th kind of possible embodiment with reference to first aspect, the embodiment of the invention provides the 5th kind of first aspect
Possible embodiment, wherein the generation Parameter File, comprising:
Automatically create configuration file；
Database parameter is automatically write into the configuration file generates Parameter File.
The 4th kind of possible embodiment with reference to first aspect, the embodiment of the invention provides the 6th kind of first aspect
Possible embodiment, wherein the automatic configuration Parameter File, further includes:
If so, being backed up to the Parameter File.
The possible embodiment of with reference to first aspect the first, the embodiment of the invention provides the 7th kind of first aspect
Possible embodiment, wherein the acquisition database path, comprising:
Obtain open source community version；
Obtain local directory path.
The possible embodiment of second with reference to first aspect, the embodiment of the invention provides the 8th kind of first aspect
Possible embodiment, wherein the building process of the database auto-initiation script includes the following steps:
Create database initializtion script film catalogue；
Initializtion script is loaded in initializtion script film catalogue；
It automatically creates and initializes weather data library；
Automatically create simultaneously initialization component database.
Second aspect, the embodiment of the present invention also provide a kind of data base automatic deployment device, comprising:
Deployment module, for receiving the Disposition Instructions of user；
Execution module, for according to the Disposition Instructions execute construct in advance be applied to MYSQL database deployment from
Dynamicization deployment script.
The third aspect, the embodiment of the present invention also provide a kind of electronic equipment, including memory, processor and are stored in described
On memory and the computer program that can run on the processor, the processor are realized when executing the computer program
The step of above-mentioned method.
Fourth aspect, the embodiment of the present invention also provide a kind of computer readable storage medium, the computer-readable storage
Computer program is stored on medium, the computer program executes above-mentioned method when being run by processor the step of.
The embodiment of the present invention bring it is following the utility model has the advantages that
It data base automatic dispositions method provided in an embodiment of the present invention, device, electronic equipment and computer-readable deposits
Storage media, wherein the data base automatic dispositions method, comprising: the Disposition Instructions for receiving user execute pre- according to Disposition Instructions
What is first constructed is applied to the automatically dispose script of MYSQL database deployment.Therefore, technical side provided in an embodiment of the present invention
Then case is applied to MYSQL database according to what Disposition Instructions execution constructed in advance first by receiving the Disposition Instructions of user
The execution automatically dispose script of deployment, is automatically performed the deployment of database, alleviates the deployment of database in the prior art
It the problem of by existing low efficiency, high labor cost is manually disposed, can be improved deployment efficiency, reduce cost of labor.
Meanwhile on the one hand this method is due to carrying out operation deployment, people without professional by the way of automatically dispose database
People can dispose database by automatically dispose script come a key；On the other hand, instead of cumbersome artificial of deployment phase
Manual operation；While improving efficiency, reduce error probability.In addition, this method also has the following characteristics that 1, implementation cost
It is low, it is simple and reliable；2, insensitive to installation path；3, configuration file, parameter, automatically generating of service；4, data library initialization
It is merged with data bank service (such as thin film solar emulation platform standalone version this application) height, i.e. the database of this method deployment
It is suitble to be dissolved into thin film solar emulation platform standalone version this application, is called directly, can be completed to single machine by application program
Version MYSQL database maps out the work, hence it is evident that reduces to thin film solar emulation platform Database Systems workload, makes the later period
Using online simplification, can reach the database in thin film solar emulation platform single machine version can be bundled to application program
Purpose.
Other features and advantages of the present invention will illustrate in the following description, also, partly become from specification
It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention are in specification, claims
And specifically noted structure is achieved and obtained in attached drawing.
To enable the above objects, features and advantages of the present invention to be clearer and more comprehensible, preferred embodiment is cited below particularly, and cooperate
Appended attached drawing, is described in detail below.
Detailed description of the invention
It, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical solution in the prior art
Embodiment or attached drawing needed to be used in the description of the prior art be briefly described, it should be apparent that, it is described below
Attached drawing is some embodiments of the present invention, for those of ordinary skill in the art, before not making the creative labor
It puts, is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of flow chart of data base automatic dispositions method provided in an embodiment of the present invention；
Fig. 2 is the specific flow chart of step S102 in Fig. 1；
Fig. 3 is the flow chart of automatic configuration Parameter File provided by the invention；
Fig. 4 is a kind of schematic diagram of data base automatic dispositions method provided in an embodiment of the present invention；
Fig. 5 is a kind of application scenario diagram of data base automatic dispositions method provided in an embodiment of the present invention；
Fig. 6 is the schematic diagram that a kind of data base automatic provided in an embodiment of the present invention disposes device；
Fig. 7 is the schematic diagram of a kind of electronic equipment provided in an embodiment of the present invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with attached drawing to the present invention
Technical solution be clearly and completely described, it is clear that described embodiments are some of the embodiments of the present invention, rather than
Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise
Under every other embodiment obtained, shall fall within the protection scope of the present invention.
Currently, the deployment of database is disposed by artificial mode in the prior art, i.e., developer is manually
Operation deployment, low efficiency, high labor cost are carried out to database；Further, since the deployment of existing database there are it is artificial because
Element, configuration process is error-prone, such as artificial manual creation configuration file, is manually entered parameter and path values, more quick to path
Sense, this is just very easy to artificial input error parameter, and then causes the service of later data library that cannot be loaded, and check it is wrong compared with
It is difficult.Based on this, a kind of data base automatic dispositions method and device provided in an embodiment of the present invention can be alleviated in the prior art
Database deployment by existing low efficiency, high labor cost is manually disposed the problem of, can be improved deployment efficiency,
Reduce cost of labor.
For convenient for understanding the present embodiment, first to a kind of data base automatic portion disclosed in the embodiment of the present invention
Arranging method describes in detail.
Embodiment one:
As shown in Figure 1, the embodiment of the invention provides a kind of data base automatic dispositions methods, this method comprises:
Step S101 receives the Disposition Instructions of user；
Step S102 executes the automatically dispose for being applied to MYSQL database deployment constructed in advance according to Disposition Instructions
Script；
Above-mentioned user can be with right and wrong developer, such as worker and technician；It can certainly be developer.
The building process of the above-mentioned automatically dispose script applied to MYSQL database deployment is as follows:
The building instruction of the first user is received, building obtains automatically dispose script；Here the first user refers to exploitation
Personnel.Building instruction includes the automatically dispose foot for the operating system being applicable in based on database version and above-mentioned database version
This code.
It can for example being put down for the thin film solar emulation of energy automobile for developer's creation by step S102
The data bank service automatic packaging and business object auto-initiation of platform standalone version this application make strong place mat.
Specifically, referring to Fig. 2, step S102 includes:
Step S1021 obtains database path；
In specific implementation, step S1021 is specifically included that
1) open source community version is obtained；
Specifically, database version information and its applicable operating system are obtained, to ensure the premise item of installing DB
Part avoids the problem that causing to dispose failure since the automatically dispose script of version information and operating system and building is inconsistent,
Meanwhile avoiding carrying out subsequent unnecessary operation, improve deployment efficiency.
2) local directory path is obtained；
In the present embodiment, by obtaining the local directory path of open source community version, reduce dispositions method is to operation
The susceptibility in system path.
Step S1022, automatic installation database service；
System service is automatically created by step realization, makes automatically generating of service, reduces artificial configuration errors.
When specific implementation, step S1022 is mainly realized by following steps:
1, create data file catalogue；
2, automatic configuration Parameter File；
In the present embodiment, referring to Fig. 3, which is mainly executed by following steps:
Step S301 judges catalogue with the presence or absence of Parameter File；
If it is not, thening follow the steps S302；If so, thening follow the steps S304；
Step S302 generates Parameter File；
In specific execute, step S302 may include:
A automatically creates configuration file；
B automatically writes database parameter into above-mentioned configuration file, generates Parameter File；
Wherein, above-mentioned database parameter includes database path parameter, such as elementary path data and Actual path data；
Step S303 is replaced the forbidden character in the path parameter in Parameter File.
Specifically, first determining whether in the above-mentioned parameter file generated with the presence or absence of forbidden character；If it exists, then using default
Character (such as "/") replaces the forbidden character (such as " ") in the path parameter of above-mentioned parameter file.
By configuration file, automatically generating of parameter, the error probability of manual mode is reduced, while forbidden character being replaced
It changes, the operating system convenient for being applicable in version is read.
Step S304, backs up Parameter File.
In the present embodiment, Parameter File is backed up as history parameters file, compares and checks convenient for developer, with right
Automatically dispose script is updated perfect.
3, above-mentioned data file content and above-mentioned parameter file installation database service are based on.
Step S1023, initializes database；
Step S1024, automatic log-on data library service.
It is automatically performed by data library initialization, is conducive to the degrees of fusion for improving database and film emulation platform.
Further, step S102 further include:
Step S1025, judges whether database service starting succeeds；
Specifically, due to being written with pass corresponding with starting success code or starting failure code in automatically dispose script
Key word information can judge whether database service starting succeeds by reading above-mentioned keyword message, for example, when starting successfully
When, keyword " starting successfully " corresponding with success code is started can be generated；When starting failure, generation can be generated and started unsuccessfully
The corresponding keyword of code " starting failure ".
If so, thening follow the steps S1026, the precondition of database auto-initiation script is met by step S1026,
Ensure first to have disposed database, then reinitialize business；If it is not, thening follow the steps S1027；
Step S1026 executes database auto-initiation script；
Above-mentioned database auto-initiation script can be the database auto-initiation of thin film solar emulation platform
Script；In other words, database auto-initiation script here is a kind of business initializtion script or project initialization foot
This, it is therefore intended that making project or the online facilitation of business, wherein thin film solar emulation platform is that developer's energy automobile is opened
A kind of application of hair；
It can be the database auto-initiation of thin film solar emulation platform with database auto-initiation script below
Step S1026 is specifically described for script:
In the present embodiment, step S1026 the following steps are included:
A establishes thin film solar emulation platform database automatically；
B creates security permission and accesses user；
C auto-initiation service-user.
It should be noted that the building process of above-mentioned database auto-initiation script is the following steps are included: (1) creates
Database initializtion script film catalogue；
(2) initializtion script is loaded in initializtion script film catalogue；
(3) it automatically creates and initializes weather data library；
Here it is illustrated by taking the building process of the database auto-initiation script of thin film solar emulation platform as an example:
(1) film simulation initialisation script film catalogue is created；
(2) initializtion script is loaded in initializtion script film catalogue；
(3) it automatically creates and initializes weather data library；
When specific implementation, which includes:
(31) it automatically creates weather data library and authorizes；
(32) weather data library initialization.
(4) simultaneously initialization component database is automatically created.
When specific execution, which includes:
(41) it automatically creates component database and authorizes；
(42) module data library initialization.
Above-mentioned steps realize the auto-initiation of thin film solar emulation platform database environment.
That is, the purpose of database auto-initiation script of the thin film solar emulation platform is to cooperate film
Solar simulation platform is using online used, i.e., automatic to load in installing simulation platform in application, during foreground application deployment
Init_data.bat instruction set automatically generates thin film solar Component Gallery and weather data library in the default stage of application deployment
And import database initialization data.This has the advantage that 1: business procedure automatic packaging and installation, and it is initial to save database
The time in change stage is conducive to improve deployment efficiency；2: this deployment of standalone version and implementation phase have liberated database administrator
The work of (Database Administrator, abbreviation DBA), is conducive to project or operation flow；3: in subsequent project
Line provides simple deployment scheme and online guidance method, is conducive to project management.
It should be pointed out that step (3), (4) are only that description is convenient to use, do not represent its sequencing, step (3) and
Step (4) also may be performed simultaneously, and can construct to obtain the environment of thin film solar emulation platform by (3), (4), while right
The permission of user configures；
Step S1027 searches failure cause.
Specifically, searching failure cause, there are three types of alternate ways, wherein mode one: can manually search；Mode two: by
Machine is searched automatically, such as information investigation can be carried out by machine and preparatory node data, i.e., with each section for running succeeded
The node data of point compares, to search acquisition failure node；Above-mentioned node refers to each sub-steps；Here machine
Refer to that electronic equipment, electronic equipment can be personal computer, mobile terminal etc.；It is former to redeploy lookup failure for mode three
Cause, with removal system interference (such as failure caused by system fluctuation, outside invading or environmental fluctuating；Specifically, can be
Automatically dispose is executed again after the step of obtaining local directory path, is also possible to execute the step of automatic installation database service
Rapid perform script again.
The embodiment of the invention provides a kind of data base automatic dispositions methods, are applied to MYSQL database and dispose, packet
It includes: receiving the Disposition Instructions of user, the automation for being applied to MYSQL database deployment constructed in advance is executed according to Disposition Instructions
Deployment script.Specifically, technical solution provided in an embodiment of the present invention, writes automation by developer or programmer first
Deployment script code, building obtain automatically dispose script, then receive the Disposition Instructions of user, execute automatically dispose foot
This, is automatically performed the deployment of database, alleviates the deployment of database in the prior art by existing for manually deployment
The problem of low efficiency, high labor cost, can be improved deployment efficiency, reduce cost of labor.Meanwhile this method is due to using automatic
Change the mode of deployment database, on the one hand carries out operation deployment without professional, everybody can pass through automatically dispose
Script carrys out key deployment database；On the other hand, the manually operated cumbersome instead of deployment phase；What is improved efficiency is same
When, reduce error probability.In addition, this method also has the following characteristics that 1, implementation cost is low, it is simple and reliable；2, to installation road
Diameter is insensitive；3, configuration file, parameter, automatically generating of service；4, data library initialization and thin film solar emulation platform list
Machine version application height merges, i.e. the database of this method deployment is suitble to be dissolved into thin film solar emulation platform standalone version should
It in, is called directly by application program, can be completed and map out the work to standalone version MYSQL database, hence it is evident that reduce to thin
Film solar emulation platform Database Systems workload applies the later period online, can reach imitative in thin film solar
Database can be bundled to the purpose of application program in true platform single machine version.
In order to make it easy to understand, database version is MYSQL Community below using database as MYSQL database
5.7.21 database；Operating system is windows system, i.e. MYSQL Community 5.7.21zip editions under windows
This, business (or project) is for thin film solar emulation platform is applied and to combine Fig. 4 to number provided in an embodiment of the present invention
It is briefly described according to the principle of library Automation arranging method:
Step S401: open source community version mysql-5.7.21-winx64 is obtained；
Step S402: automatic deployment script mysql_install.bat is executed；
Automatic deployment script mysql_install.bat writes building by developer in advance and obtains.
Step S403: thin film solar emulation platform auto-initiation script init_data.bat is executed.
Thin film solar emulation platform auto-initiation script init_data.bat is also write building in advance by developer
It obtains.
It should be pointed out that the database is not limited to MYSQL Community 5.7.21 version, it can also be other
The MYSQL Community 5.7 of windows version and subsequent zip edition data library.
In practical applications, referring to Fig. 5, this method is executed by following steps:
Step S501 obtains open source community version；
Step S502 obtains local directory path；
Then the step of executing automation installation database service, which mainly includes
Step S503, step S504 and step S505；Wherein, step S503 and step S504 is only to describe to be easy to use, and is not represented
Its precedence, step S503 and step S504 may be performed simultaneously；
Step S503, automatic configuration Parameter File start；
Step S503a judges whether there is Parameter File my.ini；
If so, step S503b is executed, if it is not, executing step S503d；
Step S503b is automatically created and database parameter generation Parameter File my.ini is written；
Forbidden character " in path in step S503c, replacement my.ini "；
Step S503d, renaming Parameter File my.ini are history parameters file my_back.Ini.
The purpose of the step is backup Parameter File.
Step S504, create data file DATA catalogue；
Step S505, script install mysql service；
Step S506 initializes MYSQL database；
Step S507, it is automatic to start mysql service；
Step S508, judges whether starting succeeds；
If starting successfully, step S509 is executed；If starting failure, executes step S510；
Step S509 executes film simulation data base initializtion script init_data.bat；
Wherein, the building process of film simulation data base initializtion script init_data.bat is referring to step S511-
S516；It should be noted that step S513 and step S515, step S514 and step S516 are only to describe to be easy to use, not
Represent its precedence；Step S513 and step S515 may be performed simultaneously；Step S514 and step S516 can also be held simultaneously
Row.
Step S510 searches failure cause；
The mode artificially searched is shown in legend.
Step S511 creates film emulation platform initializtion script flim catalogue；
Step S512 loads initializtion script；
Step S513 automatically creates weather data library and authorizes；
Step S514, weather data library initialization；
Step S515 automatically creates component database and authorizes；
Step S516, module data library initialization.
The embodiment of the present invention develops one kind and can satisfy and merge the automatic portion of thin film solar emulation platform single machine version
The data base automatic dispositions method of administration and application height fusion, removes the cumbersome manually operated of deployment phase, makes to dispose
It is insensitive to installation path, and configuration file, parameter, automatically generating of service, and data library initialization can be with films too
Positive energy emulation platform application height merges, and can be packaged the MYSQL database of implementation, and realize automatic deployment and business pair
As the MYSQL database of auto-initiation version.
In addition, this method flow implementation and at low cost, the operating mode simple, intuitive of change, are suitble to be dissolved into the film sun
It in energy emulation platform standalone version this application, is called directly by application program, simplifies the later period using online；Compared to existing
User present in dispositions method needs manual creation and rewrites configuration file, and important parameter need to be manually specified and data file is deposited
Path and series of steps processing are put, configuration process is easy error, to path-sensitive and thin film solar emulation platform standalone version
The not high problem of this application degrees of fusion, this method are simple and reliable: to be known by automated intelligent due to having automatic deployment program function
Other operation system path, it is insensitive to operation system path；Service, the deploying steps such as initialization are simplified to fall by intelligence, i.e., automatically
Creation system service automatically creates database parameter and auto-initiation thin film solar emulation platform database environment；Energy
It is enough integrated into thin film solar emulation platform standalone version this application, as long as main program calls mysql_ in single machine version
Install.bat script can be completed and map out the work to standalone version MYSQL database, to thin film solar emulation platform number
It is more obvious according to the reduction of library system workload, thin film solar emulation platform standalone version this application amalgamation database is promoted, is
Thin film solar emulation platform standalone version this application is online to provide feasible database interfusion scheme.
Embodiment two:
As shown in fig. 6, the embodiment of the invention provides a kind of data base automatics to dispose device, it is applied to MYSQL data
Library deployment, comprising:
Deployment module 601, for receiving the Disposition Instructions of user,
Execution module 602 is applied to the automatic of MYSQL database deployment for what is constructed in advance according to Disposition Instructions execution
Change deployment script；
Further, execution module 602 specifically includes:
Acquiring unit 6021, user obtain database path；
Service unit 6022 is used for automatic installation database service；
Initialization unit 6023, for being initialized to database；
Start unit 6024 is serviced for automatic log-on data library.
Further, acquiring unit 6021 is specifically used for: obtaining open source community version；Obtain local directory path.
Further, service unit 6022 is specifically used for: create data file catalogue；Automatic configuration Parameter File；Base
In above-mentioned data file content and above-mentioned parameter file installation database service.
Further, deployment module 602 further includes judging unit 6025, for judge database service starting whether at
Function；If so, executing database auto-initiation script.Wherein, the building process of database auto-initiation script includes such as
Lower step: creation database initializtion script film catalogue；Initializtion script is loaded in initializtion script film catalogue；Automatically
It creates and initializes weather data library；Automatically create simultaneously initialization component database.
Data base automatic provided in an embodiment of the present invention disposes device, with data base automatic provided by the above embodiment
Dispositions method technical characteristic having the same reaches identical technical effect so also can solve identical technical problem.
The technical effect and preceding method embodiment phase of device provided by the embodiment of the present invention, realization principle and generation
Together, to briefly describe, Installation practice part does not refer to place, can refer to corresponding contents in preceding method embodiment.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description
It with the specific work process of device, can refer to corresponding processes in the foregoing method embodiment, details are not described herein.
Referring to Fig. 7, the embodiment of the present invention also provides a kind of XXXX device 100, comprising: processor 40, memory 41, bus
42 and communication interface 43, the processor 40, communication interface 43 and memory 41 are connected by bus 42；Processor 40 is for holding
The executable module stored in line storage 41, such as computer program.
Wherein, memory 41 may include high-speed random access memory (RAM, Random Access Memory),
It may further include non-labile memory (non-volatile memory), for example, at least a magnetic disk storage.By extremely
A few communication interface 43 (can be wired or wireless) is realized logical between the system network element and at least one other network element
Letter connection, can be used internet, wide area network, local network, Metropolitan Area Network (MAN) etc..
Bus 42 can be isa bus, pci bus or eisa bus etc..The bus can be divided into address bus, data
Bus, control bus etc..Only to be indicated with a four-headed arrow convenient for indicating, in Fig. 7, it is not intended that an only bus or
A type of bus.
Wherein, memory 41 is for storing program, and the processor 40 executes the journey after receiving and executing instruction
Sequence, method performed by the device that the stream process that aforementioned any embodiment of the embodiment of the present invention discloses defines can be applied to handle
In device 40, or realized by processor 40.
Processor 40 may be a kind of IC chip, the processing capacity with signal.During realization, above-mentioned side
Each step of method can be completed by the integrated logic circuit of the hardware in processor 40 or the instruction of software form.Above-mentioned
Processor 40 can be general processor, including central processing unit (Central Processing Unit, abbreviation CPU), network
Processor (Network Processor, abbreviation NP) etc.；It can also be digital signal processor (Digital Signal
Processing, abbreviation DSP), specific integrated circuit (Application Specific Integrated Circuit, referred to as
ASIC), ready-made programmable gate array (Field-Programmable Gate Array, abbreviation FPGA) or other are programmable
Logical device, discrete gate or transistor logic, discrete hardware components.It may be implemented or execute in the embodiment of the present invention
Disclosed each method, step and logic diagram.General processor can be microprocessor or the processor is also possible to appoint
What conventional processor etc..The step of method in conjunction with disclosed in the embodiment of the present invention, can be embodied directly in hardware decoding processing
Device executes completion, or in decoding processor hardware and software module combination execute completion.Software module can be located at
Machine memory, flash memory, read-only memory, programmable read only memory or electrically erasable programmable memory, register etc. are originally
In the storage medium of field maturation.The storage medium is located at memory 41, and processor 40 reads the information in memory 41, in conjunction with
Its hardware completes the step of above method.
In addition, in the description of the embodiment of the present invention unless specifically defined or limited otherwise, term " installation ", " phase
Even ", " connection " shall be understood in a broad sense, for example, it may be being fixedly connected, may be a detachable connection, or be integrally connected；It can
To be mechanical connection, it is also possible to be electrically connected；It can be directly connected, can also can be indirectly connected through an intermediary
Connection inside two elements.For the ordinary skill in the art, above-mentioned term can be understood at this with concrete condition
Concrete meaning in invention.
In all examples being illustrated and described herein, any occurrence should be construed as merely illustratively, without
It is as limitation, therefore, other examples of exemplary embodiment can have different values.Unless specifically stated otherwise, otherwise
Opposite step, numerical expression and the numerical value of the component and step that illustrate in these embodiments are not intended to limit model of the invention
It encloses.It should also be noted that similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi are attached
It is defined in figure, does not then need that it is further defined and explained in subsequent attached drawing.
The flow chart and block diagram in the drawings show the system of multiple embodiments according to the present invention, method and computer journeys
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, section or code of table, a part of the module, section or code include one or more use
The executable instruction of the logic function as defined in realizing.It should also be noted that in some implementations as replacements, being marked in box
The function of note can also occur in a different order than that indicated in the drawings.For example, two continuous boxes can actually base
Originally it is performed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.It is also noted that
It is the combination of each box in block diagram and or flow chart and the box in block diagram and or flow chart, can uses and execute rule
The dedicated hardware based system of fixed function or movement is realized, or can use the group of specialized hardware and computer instruction
It closes to realize.
The computer program product of data base automatic dispositions method, including storage are carried out provided by the embodiment of the present invention
The computer readable storage medium of the executable non-volatile program code of processor, the instruction that said program code includes can
For executing previous methods method as described in the examples, specific implementation can be found in embodiment of the method, and details are not described herein.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description,
The specific work process of device and unit, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
In several embodiments provided herein, it should be understood that disclosed systems, devices and methods, it can be with
It realizes by another way.The apparatus embodiments described above are merely exemplary, for example, the division of the unit,
Only a kind of logical function partition, there may be another division manner in actual implementation, in another example, multiple units or components can
To combine or be desirably integrated into another system, or some features can be ignored or not executed.Another point, it is shown or beg for
The mutual coupling, direct-coupling or communication connection of opinion can be through some communication interfaces, device or unit it is indirect
Coupling or communication connection can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.
It, can be with if the function is realized in the form of SFU software functional unit and when sold or used as an independent product
It is stored in the executable non-volatile computer-readable storage medium of a processor.Based on this understanding, of the invention
Technical solution substantially the part of the part that contributes to existing technology or the technical solution can be with software in other words
The form of product embodies, which is stored in a storage medium, including some instructions use so that
One computer equipment (can be personal computer, server or the network equipment etc.) executes each embodiment institute of the present invention
State all or part of the steps of method.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-
Only Memory), random access memory (RAM, Random Access Memory), magnetic or disk etc. are various can be with
Store the medium of program code.
Finally, it should be noted that embodiment described above, only a specific embodiment of the invention, to illustrate the present invention
Technical solution, rather than its limitations, scope of protection of the present invention is not limited thereto, although with reference to the foregoing embodiments to this hair
It is bright to be described in detail, those skilled in the art should understand that: anyone skilled in the art
In the technical scope disclosed by the present invention, it can still modify to technical solution documented by previous embodiment or can be light
It is readily conceivable that variation or equivalent replacement of some of the technical features；And these modifications, variation or replacement, do not make
The essence of corresponding technical solution is detached from the spirit and scope of technical solution of the embodiment of the present invention, should all cover in protection of the invention
Within the scope of.Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (7)
1. a kind of data base automatic dispositions method characterized by comprising
Receive the Disposition Instructions of user；
The automatically dispose script for being applied to MYSQL database deployment constructed in advance is executed according to the Disposition Instructions；
It is described that the automatically dispose script for being applied to MYSQL database deployment constructed in advance is executed according to the Disposition Instructions,
Include:
Judge whether database service starting succeeds；
If so, executing database auto-initiation script；
The database auto-initiation script is the database auto-initiation script of thin film solar emulation platform；
The building process of the database auto-initiation script of the thin film solar emulation platform includes:
Create film simulation initialisation script film catalogue；
Initializtion script is loaded in initializtion script film catalogue；
It automatically creates weather data library and authorizes；
Weather data library initialization；
It automatically creates component database and authorizes；
Module data library initialization；
The execution database auto-initiation script the following steps are included:
Automatically thin film solar emulation platform database is established；
It creates security permission and accesses user；
Auto-initiation service-user.
2. data base automatic dispositions method according to claim 1, which is characterized in that described according to the Disposition Instructions
Execute the automatically dispose script for being applied to MYSQL database deployment constructed in advance, comprising:
Obtain database path；
Automatic installation database service；
Database is initialized；
Automatic log-on data library service.
3. data base automatic dispositions method according to claim 2, which is characterized in that the automatic installation database clothes
Business, comprising:
Create data file catalogue；
Automatic configuration Parameter File；
File directory and the Parameter File installation database service based on the data.
4. data base automatic dispositions method according to claim 3, which is characterized in that the automatic configuration parameter text
Part, comprising:
Judge the catalogue with the presence or absence of Parameter File；
If it is not, then generating Parameter File；
Forbidden character in path parameter in Parameter File is replaced.
5. data base automatic dispositions method according to claim 4, which is characterized in that the generation Parameter File, packet
It includes:
Automatically create configuration file；
Database parameter is automatically write into the configuration file generates Parameter File.
6. data base automatic dispositions method according to claim 4, which is characterized in that the automatic configuration parameter text
Part, further includes:
If so, being backed up to the Parameter File.
7. data base automatic dispositions method according to claim 2, which is characterized in that the acquisition database path,
Include:
Obtain open source community version；
Obtain local directory path.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810795367.5A CN109101242B (en) | 2018-07-19 | 2018-07-19 | Data base automatic dispositions method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810795367.5A CN109101242B (en) | 2018-07-19 | 2018-07-19 | Data base automatic dispositions method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109101242A CN109101242A (en) | 2018-12-28 |
| CN109101242B true CN109101242B (en) | 2019-11-19 |
Family
ID=64846903
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810795367.5A Active CN109101242B (en) | 2018-07-19 | 2018-07-19 | Data base automatic dispositions method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109101242B (en) |
Families Citing this family (1)
| 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 |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106469068A (en) * | 2015-08-14 | 2017-03-01 | 中国移动通信集团安徽有限公司 | The dispositions method of application program and system |
| CN106649430A (en) * | 2016-08-30 | 2017-05-10 | 广西电网有限责任公司 | Automatic one-click deploying method for SQL Server |
| CN107247790A (en) * | 2017-06-16 | 2017-10-13 | 北京小米移动软件有限公司 | The method and apparatus of newly-built mail |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140019407A1 (en) * | 2012-07-11 | 2014-01-16 | Salesforce.Com, Inc. | Systems and methods with client advisories in an on-demand computing environment |
-
2018
- 2018-07-19 CN CN201810795367.5A patent/CN109101242B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106469068A (en) * | 2015-08-14 | 2017-03-01 | 中国移动通信集团安徽有限公司 | The dispositions method of application program and system |
| CN106649430A (en) * | 2016-08-30 | 2017-05-10 | 广西电网有限责任公司 | Automatic one-click deploying method for SQL Server |
| CN107247790A (en) * | 2017-06-16 | 2017-10-13 | 北京小米移动软件有限公司 | The method and apparatus of newly-built mail |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109101242A (en) | 2018-12-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10579344B2 (en) | Converting visual diagrams into code | |
| US11184241B2 (en) | Topology-aware continuous evaluation of microservice-based applications | |
| US9348738B2 (en) | Testing functional correctness and idempotence of software automation scripts | |
| EP4369180A2 (en) | Callpath finder | |
| US20060253839A1 (en) | Generating performance tests from UML specifications using markov chains | |
| US10592494B2 (en) | Collection record for overlapping data stream collections | |
| US10031814B2 (en) | Collection record location as log tail beginning | |
| US10977031B2 (en) | Method for a software development system | |
| CN104169902B (en) | Synchronous local and remote data | |
| US10133768B2 (en) | Latest external dependee entity in transaction record | |
| CN107368420A (en) | API method of testings, device and electronic equipment | |
| CN109298882A (en) | Management method, computer readable storage medium and the terminal device of interface | |
| US20160306838A1 (en) | Acceleration property for processing data stream | |
| US9766929B2 (en) | Processing of data stream collection record sequence | |
| WO2016018352A1 (en) | Platform configuration selection based on a degraded makespan | |
| CN106529281B (en) | A kind of executable file processing method and processing device | |
| CN109101242B (en) | Data base automatic dispositions method and device | |
| CN113687779B (en) | Data migration method, device, electronic equipment and readable storage medium | |
| US20150280996A1 (en) | Cloud topology visualizations | |
| CN113407174A (en) | Task scheduling method, device, equipment and storage medium | |
| US10073938B2 (en) | Integrated circuit design verification | |
| US20200097285A1 (en) | Locating business rules in application source code | |
| CN109582347A (en) | A kind of method and device obtaining front-end code | |
| CN115098362A (en) | Page testing method and device, electronic equipment and storage medium | |
| CN110290172B (en) | Container application cloning method and device, computer equipment and storage 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 | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20201204 Address after: No. 101400 Yanqi Economic Development Zone, Huairou Patentee after: Beijing Huihong Technology Co., Ltd Address before: 100000 room 107, building 2, Olympic Village Street Complex office, Chaoyang District, Beijing Patentee before: HANERGY MOBILE ENERGY HOLDING GROUP Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20210930 Address after: 101400 Yanqi Street, Yanqi Economic Development Zone, Huairou District, Beijing Patentee after: Dongjun new energy Co.,Ltd. Address before: 101400 No.31 Yanqi street, Yanqi Economic Development Zone, Huairou District, Beijing (cluster registration) Patentee before: Beijing Huihong Technology Co., Ltd |