CN112286907A - Database configuration method and device, electronic equipment and readable storage medium - Google Patents
Database configuration method and device, electronic equipment and readable storage medium Download PDFInfo
- Publication number
- CN112286907A CN112286907A CN202011156066.1A CN202011156066A CN112286907A CN 112286907 A CN112286907 A CN 112286907A CN 202011156066 A CN202011156066 A CN 202011156066A CN 112286907 A CN112286907 A CN 112286907A
- Authority
- CN
- China
- Prior art keywords
- target
- database
- database configuration
- request file
- data
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 64
- 238000004590 computer program Methods 0.000 claims description 12
- 230000008569 process Effects 0.000 claims description 9
- 238000000605 extraction Methods 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 6
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 239000000126 substance Substances 0.000 claims description 3
- 230000006870 function Effects 0.000 description 11
- 230000009286 beneficial effect Effects 0.000 description 10
- 238000012545 processing Methods 0.000 description 10
- 238000012360 testing method Methods 0.000 description 6
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 229920001621 AMOLED Polymers 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 238000007792 addition Methods 0.000 description 2
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000012896 Statistical algorithm Methods 0.000 description 1
- 238000013528 artificial neural network Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 230000001537 neural effect Effects 0.000 description 1
- 238000011022 operating instruction Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 239000002096 quantum dot Substances 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 238000013468 resource allocation Methods 0.000 description 1
- 229920006395 saturated elastomer Polymers 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/35—Creation or generation of source code model driven
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of computer databases, in particular to a database configuration method, a database configuration device, electronic equipment and a readable storage medium. The method comprises the following steps: developing a program message by acquiring a target service front end; extracting a target object of the development program message; writing the target object into a preset relation definition template and generating a target request file; and sending the target request file to a database according to a database configuration template. The database configuration scheme disclosed by the application improves the database configuration efficiency of the background management system.
Description
Technical Field
The invention relates to the technical field of computer databases, in particular to a database configuration method and device, electronic equipment and a readable storage medium.
Background
In computer operation application, basically all service scenes need to be involved in interacting with various databases or accessing the databases, and especially when a new APP needs to be developed or a function module in an APP needs to be modified and optimized, the modification and deletion operations on the databases are required and the database needs to be operated due to the change of the database content, but in such a case, the manual code development workload of technical personnel for database data operation is large, and the repetitive work is more. Once the structure of the base table is changed or the business logic is changed, the analysis and modification range is wide, and the system maintenance difficulty is high.
Disclosure of Invention
The present application aims to solve at least one of the above technical drawbacks. The technical scheme adopted by the application is as follows:
in a first aspect, an embodiment of the present application discloses a database configuration method, where the method includes:
acquiring a target service front-end development program message;
extracting a target object of the development program message;
writing the target object into a preset relation definition template and generating a target request file;
and sending the target request file to a database according to a database configuration template.
Further, the relationship definition template is used for constructing a mapping relationship for code fields in the development program, which are associated with the target service, and target data tables in a database; and the target data table is a data table for storing the target service demand data.
Further, the relationship definition template content includes, but is not limited to:
table field conversion, value mapping, target data table operation type.
Optionally, the obtaining of the target service front-end development program message includes:
and receiving a user editing instruction according to the target service requirement, and generating a development program message of the front end of the target service.
Further, extracting the target object of the development program message includes:
determining the operation type of the target service requirement on the database according to the target service requirement; wherein the operation types include, but are not limited to: inserting data, deleting data, modifying data and inquiring data;
analyzing the structural object of the development program message according to the operation type to obtain a code field related to the operation type; wherein the code field associated with the operation type is a target object.
Optionally, after acquiring the code field related to the operation type, the method further includes:
formatting the code field; wherein the formatting process is to convert a hump in the code field into an underline;
and packaging and writing the formatted code field into a preset relation definition template to generate a target request file.
Further, sending the target request file to a database includes:
writing the target request file into a target data table according to the database configuration module; executing target operation on the target data table according to the written target request file; wherein the target operation includes, but is not limited to: inserting data, deleting data and modifying data;
and/or the presence of a gas in the gas,
sending the target request file to a target data table according to the database configuration template; the target data table is a data table for storing the target service demand data; and according to the target request file, the target data table sends a feedback file to a front end.
Further, before the code field after the formatting process is encapsulated and written into a preset relationship definition template to generate a target request file, the method further includes:
and performing diff operation on the encapsulated formatted code field according to the previous encapsulated code field in the cache.
In a second aspect, an embodiment of the present application provides a database configuration apparatus, where the apparatus includes: the device comprises an interface module, an extraction module, a writing module and a storage module; wherein the content of the first and second substances,
the interface module is used for acquiring a target service front-end development program message;
the extraction module is used for extracting a target object of the development program message;
the writing module is used for writing the target object into a preset relation definition template and generating a target request file;
the interface module is also used for sending the target request file to a database according to a database configuration template;
the storage module is used for storing the preset relationship definition template, the database configuration template and the database.
In a third aspect, an embodiment of the present application provides an electronic device, including a processor and a memory;
the memory is used for storing operation instructions;
the processor is configured to execute the method in any of the embodiments by calling the operation instruction.
In a fourth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the method of any one of the above embodiments.
The embodiment of the application provides a database configuration scheme by acquiring a target service front-end development program message; extracting a target object of the development program message; writing the target object into a preset relation definition template and generating a target request file; and sending the target request file to a database according to a database configuration template. The beneficial effects at least comprise: the invention provides a method for quickly realizing the front-end linkage and the back-end linkage of back management addition, deletion, modification and check based on templated definition, which can quickly finish function landing only by developing a front-end page and configuring an access template, thereby greatly reducing the manpower input in the aspect.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments of the present application will be briefly described below.
Fig. 1 is a schematic flowchart of a database configuration method according to an embodiment of the present application;
fig. 2 is a schematic diagram of a database configuration interface according to an embodiment of the present disclosure;
fig. 3 is a schematic diagram of a database configuration apparatus according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present invention.
It will be understood by those skilled in the art that, unless otherwise specified, the singular forms "a", "an", "the" and "the" may include the plural forms, and the plural forms "a", "an", "a", and "the" are merely intended to illustrate the object definition for clarity and do not limit the object itself, and certainly, the object definition for "a" and "an" may be the same terminal, device, user, etc., and may also be the same terminal, device, user, etc. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
In addition, it is to be understood that "at least one" in the embodiments of the present application means one or more, "a plurality" means two or more. "and/or" describes the association relationship of the associated objects, meaning that there may be three relationships, e.g., a and/or B, which may mean: a alone, both A and B, and B alone, where A, B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of the singular or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, a and b, a and c, b and c, or a, b and c, wherein a, b and c can be single or multiple.
To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 1 shows a schematic flowchart of a database configuration provided in an embodiment of the present application, and as shown in fig. 1, the method mainly includes:
s101, acquiring a target service front-end development program message;
optionally, the obtaining of the target service front-end development program message includes: and receiving a user editing instruction according to the target service requirement, and generating a development program message of the front end of the target service.
S102, extracting a target object of the development program message;
in an optional embodiment of the present application, an implementation process of extracting a target object of the development program packet is as follows: determining the operation type of the target business demand on the database according to the target business demand, wherein the operation type includes but is not limited to: inserting data, deleting data, modifying data and inquiring data; and analyzing the structural object of the development program message according to the operation type to acquire a code field related to the operation type, wherein the code field related to the operation type is a target object.
In a further optional embodiment, after acquiring the code field related to the operation type, the method further includes: formatting the code field; wherein the formatting process is to convert a hump in the code field into an underline; and packaging and writing the formatted code field into a preset relation definition template to generate a target request file.
S103, writing the target object into a preset relation definition template and generating a target request file; the relation definition template is used for constructing a mapping relation for a code field in the development program, which is associated with a target service, and a target data table in a database, namely configuring a corresponding relation between service data in the development program and the target data table; the target data table (also called a table of a drop base) is a data table for storing the target service demand data. The relation definition template is generated according to the system function type or APP type and the management requirement of the service, such as the service requirement analysis of single-table operation or multi-table association operation. In operation, a front-end engineer completes development of a front page according to business requirements, packages a message in a json format, transmits a message with an operateType I/U/D/Q defined as an operation type according to addition, deletion, modification and check in a main structure, requests a rear-end interface of the front-end page, and then carries out routing request processing according to the operation type of the request by the interface. Further, the relationship definition template content includes, but is not limited to: table field conversion, value mapping, target data table operation type.
And S104, sending the target request file to a database according to a database configuration template.
In an optional embodiment, the sending the target request file to the database may be implemented by: writing the target request file into a target data table according to the database configuration module; executing target operation on the target data table according to the written target request file; wherein the target operation includes, but is not limited to: inserting data, deleting data and modifying data;
in another alternative embodiment, the implementation process of sending the target request file to the database may be: sending the target request file to a target data table according to the database configuration template; the target data table is a data table for storing the target service demand data; and according to the target request file, the target data table sends a feedback file to a front end. The embodiment is an embodiment for executing query operation on a target data table based on a defined relation template, wherein a feedback file is a returned query result, and underlining humping processing needs to be performed on the query result before the query result is fed back to a front-end interface in a specific implementation process.
In a further optional embodiment, before packaging and writing the formatted code field into a preset relationship definition template to generate a target request file, the method further includes: and performing diff operation on the encapsulated code field according to the last encapsulated code field in the cache, wherein if the code field analyzed from the front-end development program at the last time is the same as the code field analyzed from the development program at this time, the data in the target data table corresponding to the part can not be changed, and the operation is not performed at this time, so that the efficiency of database configuration is improved.
To more clearly introduce the database configuration scheme disclosed in the present application, a preset relationship definition template sample is provided for exemplary illustration:
in the above illustration example, data is seen as a primary table data definition, and an association secondary table is defined as resources (data, this calling name of resources is not limited);
table: is the table name to be operated;
primKey: for the field of the master table, filling the master key of the master table, if the field is filled as the foreign key of the associated table for the slave table, a plurality of values are supported for the primKey in the slave table, comma separation is carried out, and when a plurality of values exist, relKey comparison is applied for use. This case is used for querying the existing data set (i.e. the last target object, i.e. the code field related to the target service parsed from the front-end development program last time) to be used for diff comparison with the new data set (target object) when performing the insert operation, which can support multiple-valued and multiple-conditional;
the speSearchKey is a field needing special inquiry and is separated by commas;
condition: commas are separated for conditions of field retrieval requiring special queries, such as greater than a number, less than a number, fuzzy query like, and the sequence is consistent with the fields described by the speSearchKey;
relKey: if the label can be null or null value when the master table is defined, the value of the label is a field corresponding to the dependent master table when the label is the slave table;
relObj: if the tag can be null or null value when defined for the master table, the value is corresponding to the object depending on the master table when defined for the slave table, like the data written in the above example.
In a further embodiment, before writing the target object into the preset relationship definition template and generating the target request file, the target object parsed from the front-end development program of the current service needs to be configured with the target database, and then data related to such configuration relationship needs to be written into the preset relationship definition template. Optionally, the configuration operation may be completed by providing a configuration interface for a user, and fig. 2 is a configuration interface sample, where relevant descriptions are the same as the relationship definition template sample, and are not described herein again.
Based on the database configuration method shown in fig. 1, another aspect of the present application provides a database configuration apparatus, as shown in fig. 3, the apparatus may include: the device comprises a 301 interface module, a 302 extraction module, a 303 write module and a 304 storage module; wherein the content of the first and second substances,
the 301 interface module is used for acquiring a target service front-end development program message;
the 302 extraction module is used for extracting a target object of the development program message;
the 303 writing module is configured to write the target object into a preset relationship definition template and generate a target request file;
the 301 interface module is further configured to send the target request file to a database according to a database configuration template;
the 304 storage module is configured to store the preset relationship definition template, the database configuration template, and the database.
It is to be understood that the above-mentioned respective constituent devices of the database configuration apparatus in the present embodiment have functions of implementing the respective steps of the method in the embodiment shown in fig. 1. The function can be realized by hardware, and can also be realized by executing corresponding software by hardware. The hardware or software includes one or more modules or systems corresponding to the above-described functions. The modules and systems can be software and/or hardware, and the modules and systems can be realized independently or integrated by a plurality of modules and systems. For the functional description of each module and system, reference may be specifically made to the corresponding description of the method in the embodiment shown in fig. 1, and therefore, the beneficial effects that can be achieved by the method may refer to the beneficial effects in the corresponding method provided above, which are not described again here.
It is to be understood that the illustrated structure of the embodiment of the present invention does not constitute a specific limitation to the specific structure of the database configuration apparatus. In other embodiments of the present application, the database configuration means may include more or fewer components than shown, or some components may be combined, some components may be split, or a different arrangement of components. The illustrated components may be implemented in hardware, software, or a combination of software and hardware.
The embodiment of the application provides an electronic device, which comprises a processor and a memory;
a memory for storing operating instructions;
and the processor is used for executing the database configuration method provided by any embodiment of the application by calling the operation instruction.
As an example, fig. 4 shows a schematic structural diagram of an electronic device to which the embodiment of the present application is applicable, and as shown in fig. 3, the electronic device 400 includes: a processor 401 and a memory 403. Wherein the processor 401 is coupled to the memory 403, such as via a bus 402. Optionally, the electronic device 400 may also include a transceiver 404. It should be noted that the transceiver 404 is not limited to one in practical applications. It is to be understood that the illustrated structure of the embodiment of the present invention does not constitute a specific limitation to the specific structure of the electronic device 400. In other embodiments of the present application, electronic device 400 may include more or fewer components than shown, or some components may be combined, some components may be split, or a different arrangement of components. The illustrated components may be implemented in hardware, software, or a combination of software and hardware. Optionally, the electronic device may further include a display screen 405 for displaying images or receiving operation instructions of a user as needed.
The processor 401 is applied to the embodiment of the present application, and is configured to implement the method shown in the foregoing method embodiment. The transceiver 404 may include a receiver and a transmitter, and the transceiver 404 is applied in the embodiment of the present application and is used for implementing the function of the electronic device of the embodiment of the present application to communicate with other devices when executed.
The Processor 401 may be a CPU (Central Processing Unit), a general purpose Processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array) or other Programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor 401 may also be a combination of computing functions, e.g., comprising one or more microprocessors, a combination of a DSP and a microprocessor, or the like.
The processor 401 may operate the database configuration method provided in the embodiment of the present application, so as to reduce the operation complexity of the user, improve the intelligent degree of the terminal device, and improve the user experience. The processor 401 may include different devices, for example, when the CPU and the GPU are integrated, the CPU and the GPU may cooperate to execute the database configuration method provided in the embodiment of the present application, for example, part of algorithms in the database configuration method is executed by the CPU, and another part of algorithms is executed by the GPU, so as to obtain faster processing efficiency.
The Memory 403 may be a ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, a RAM (Random Access Memory) or other types of dynamic storage devices that can store information and instructions, an EEPROM (Electrically Erasable Programmable Read Only Memory), a CD-ROM (Compact disk), a high speed Random Access Memory, a non-volatile Memory such as at least one magnetic disk storage device, a flash Memory device, a universal flash Memory (UFS), or other optical disk storage, optical disk storage (including Compact disk, laser disk, optical disk, digital versatile disk, blu-ray disk, etc.), a magnetic disk storage medium or other magnetic storage devices, a magnetic disk storage medium, or other types of magnetic storage devices, Or any other medium which can be used to carry or store desired program code in the form of instructions or data structures and which can be accessed by a computer, but is not limited to such.
Optionally, the memory 403 is used for storing application program codes for executing the scheme of the present application, and is controlled by the processor 401 to execute. The processor 401 is configured to execute the application program code stored in the memory 403 to implement the database configuration method provided in any embodiment of the present application.
The memory 403 may be used to store computer-executable program code, which includes instructions. The processor 401 executes various functional applications of the electronic device 400 and data processing by executing instructions stored in the memory 403. The memory 403 may include a program storage area and a data storage area. Wherein, the storage program area can store the codes of the operating system and the application program, etc. The stored data area may store data created during use of the electronic device 400 (e.g., images, video, etc. captured by a camera application), and the like.
The memory 403 may also store one or more computer programs corresponding to the database configuration method provided in the embodiments of the present application. The one or more computer programs stored in the memory 403 and configured to be executed by the one or more processors 401 include instructions that may be used to perform the steps of the respective embodiments described above.
Of course, the codes of the database configuration method provided in the embodiment of the present application may also be stored in the external memory. In this case, the processor 401 may execute the code of the database configuration method stored in the external memory through the external memory interface, and the processor 401 may control the database configuration flow to be executed.
The display screen 405 includes a display panel. The display panel may be a Liquid Crystal Display (LCD), an organic light-emitting diode (OLED), an active-matrix organic light-emitting diode (active-matrix organic light-emitting diode, AMOLED), a flexible light-emitting diode (FLED), a miniature, a Micro-oeld, a quantum dot light-emitting diode (QLED), or the like. In some embodiments, the electronic device 400 may include 1 or N display screens 405, N being a positive integer greater than 1. The display screen 405 may be used to display information input by or provided to the user as well as various Graphical User Interfaces (GUIs). For example, the display screen 405 may display a photograph, video, web page, or file, etc.
The electronic device provided by the embodiment of the present application is applicable to any embodiment of the above method, and therefore, the beneficial effects that can be achieved by the electronic device can refer to the beneficial effects in the corresponding method provided above, and are not described again here.
The embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the database configuration method shown in the above method embodiment.
The computer-readable storage medium provided in the embodiments of the present application is applicable to any embodiment of the foregoing method, and therefore, the beneficial effects that can be achieved by the computer-readable storage medium can refer to the beneficial effects in the corresponding method provided above, and are not described herein again.
The embodiment of the present application further provides a computer program product, which when running on a computer, causes the computer to execute the above related steps to implement the method in the above embodiment. The computer program product provided in the embodiments of the present application is applicable to any of the embodiments of the method described above, and therefore, the beneficial effects that can be achieved by the computer program product can refer to the beneficial effects in the corresponding method provided above, and are not described herein again.
According to the database configuration scheme provided by the embodiment of the application, relevant data of test service execution of corresponding testers are obtained by distributed concurrent scanning of logs of the multi-system server, the constructed database configuration model suitable for the testers of different levels is used for calculating the workload, the standard daily workload set by a statistical algorithm is used as a reference for evaluating the workload saturation of the testers, and the work arrangement is pre-warned according to the workload saturation condition so as to make resource tilt strategy decision. And the drawn workload distribution map of the tester and the workload distribution map of the project domain function test task are beneficial to finding low-efficiency crowds by test responsible persons, mining low-efficiency reasons in a targeted manner, focusing attention on over-saturated crowds, reversely analyzing the test quality, avoiding the problem of hidden danger of the test quality caused by the heavy test task, and carrying out resource allocation and balance more reasonably.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, a module or a unit may be divided into only one logical function, and may be implemented in other ways, for example, a plurality of units or components may be combined or integrated into another apparatus, or some features may be discarded or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units may be one physical unit or a plurality of physical units, may be located in one place, or may be distributed to a plurality of different places. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a readable storage medium. Based on such understanding, the technical solutions of the embodiments of the present application may be essentially or partially contributed to by the prior art, or all or part of the technical solutions may be embodied in the form of a software product, where the software product is stored in a storage medium and includes several instructions to enable a device (which may be a single chip, a chip, or the like) or a processor (processor) to execute all or part of the steps of the methods of the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of changes or substitutions within the technical scope of the present application, and can make several modifications and decorations, and these changes, substitutions, improvements and decorations should also be considered to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (11)
1. A method of configuring a database, the method comprising:
acquiring a target service front-end development program message;
extracting a target object of the development program message;
writing the target object into a preset relation definition template and generating a target request file;
and sending the target request file to a database according to a database configuration template.
2. The database configuration method according to claim 1, wherein the relationship definition template is used for constructing a mapping relationship for a code field associated with a target service in the development program and a target data table in a database; and the target data table is a data table for storing the target service demand data.
3. The database configuration method according to claim 2, wherein the relationship definition template content includes but is not limited to:
table field conversion, value mapping, target data table operation type.
4. The database configuration method according to claim 1 or 3, wherein the obtaining of the target service front-end development program message comprises:
and receiving a user editing instruction according to the target service requirement, and generating a development program message of the front end of the target service.
5. The database configuration method according to claim 4, wherein extracting the target object of the development program message comprises:
determining the operation type of the target service requirement on the database according to the target service requirement; wherein the operation types include, but are not limited to: inserting data, deleting data, modifying data and inquiring data;
analyzing the structural object of the development program message according to the operation type to obtain a code field related to the operation type; wherein the code field associated with the operation type is a target object.
6. The database configuration method according to claim 5, wherein after acquiring the code field related to the operation type, the method further comprises:
formatting the code field; wherein the formatting process is to convert a hump in the code field into an underline;
and packaging and writing the formatted code field into a preset relation definition template to generate a target request file.
7. The database configuration method of claim 6, wherein sending the target request file to a database comprises:
writing the target request file into a target data table according to the database configuration module; executing target operation on the target data table according to the written target request file; wherein the target operation includes, but is not limited to: inserting data, deleting data and modifying data;
and/or the presence of a gas in the gas,
sending the target request file to a target data table according to the database configuration template; the target data table is a data table for storing the target service demand data; and according to the target request file, the target data table sends a feedback file to a front end.
8. The database configuration method according to claim 7, wherein before encapsulating and writing the formatted code field into a preset relationship definition template to generate a target request file, the method further comprises:
and performing diff operation on the encapsulated formatted code field according to the previous encapsulated code field in the cache.
9. An apparatus for configuring a database, the apparatus comprising: the device comprises an interface module, an extraction module, a writing module and a storage module; wherein the content of the first and second substances,
the interface module is used for acquiring a target service front-end development program message;
the extraction module is used for extracting a target object of the development program message;
the writing module is used for writing the target object into a preset relation definition template and generating a target request file;
the interface module is also used for sending the target request file to a database according to a database configuration template;
the storage module is used for storing the preset relationship definition template, the database configuration template and the database.
10. An electronic device comprising a processor and a memory;
the memory is used for storing operation instructions;
the processor is used for executing the method of any one of claims 1-8 by calling the operation instruction.
11. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when being executed by a processor, carries out the method of any one of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011156066.1A CN112286907A (en) | 2020-10-26 | 2020-10-26 | Database configuration method and device, electronic equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011156066.1A CN112286907A (en) | 2020-10-26 | 2020-10-26 | Database configuration method and device, electronic equipment and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112286907A true CN112286907A (en) | 2021-01-29 |
Family
ID=74373054
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011156066.1A Pending CN112286907A (en) | 2020-10-26 | 2020-10-26 | Database configuration method and device, electronic equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112286907A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113656095A (en) * | 2021-08-06 | 2021-11-16 | 北京数码大方科技股份有限公司 | Method and device for processing configuration data |
| CN115794827A (en) * | 2022-11-29 | 2023-03-14 | 广发银行股份有限公司 | Data table structure management system and method |
| WO2024016850A1 (en) * | 2022-07-18 | 2024-01-25 | 易保网络技术(上海)有限公司 | Method and system for processing data conflict, and electronic device and computer-readable storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103631601A (en) * | 2013-12-10 | 2014-03-12 | 北京中电普华信息技术有限公司 | Code generation method and code generation device |
| CN103853803A (en) * | 2013-06-26 | 2014-06-11 | 携程计算机技术（上海）有限公司 | Database configuration file encapsulation method and operation method as well as operation device thereof |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN108228282A (en) * | 2018-04-04 | 2018-06-29 | 北京三快在线科技有限公司 | For the method and device of Website page loading |
| US10203937B1 (en) * | 2016-06-03 | 2019-02-12 | HM Health Solutions Inc. | Grand unified processor |
| CN109670081A (en) * | 2018-12-28 | 2019-04-23 | 中国银行股份有限公司 | The method and device of service request processing |
| CN109933571A (en) * | 2019-01-23 | 2019-06-25 | 平安科技（深圳）有限公司 | Database design documentation generation method, device and computer readable storage medium |
-
2020
- 2020-10-26 CN CN202011156066.1A patent/CN112286907A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103853803A (en) * | 2013-06-26 | 2014-06-11 | 携程计算机技术（上海）有限公司 | Database configuration file encapsulation method and operation method as well as operation device thereof |
| CN103631601A (en) * | 2013-12-10 | 2014-03-12 | 北京中电普华信息技术有限公司 | Code generation method and code generation device |
| US10203937B1 (en) * | 2016-06-03 | 2019-02-12 | HM Health Solutions Inc. | Grand unified processor |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN108228282A (en) * | 2018-04-04 | 2018-06-29 | 北京三快在线科技有限公司 | For the method and device of Website page loading |
| CN109670081A (en) * | 2018-12-28 | 2019-04-23 | 中国银行股份有限公司 | The method and device of service request processing |
| CN109933571A (en) * | 2019-01-23 | 2019-06-25 | 平安科技（深圳）有限公司 | Database design documentation generation method, device and computer readable storage medium |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113656095A (en) * | 2021-08-06 | 2021-11-16 | 北京数码大方科技股份有限公司 | Method and device for processing configuration data |
| CN113656095B (en) * | 2021-08-06 | 2023-08-04 | 北京数码大方科技股份有限公司 | Processing method and device for configuration data |
| WO2024016850A1 (en) * | 2022-07-18 | 2024-01-25 | 易保网络技术(上海)有限公司 | Method and system for processing data conflict, and electronic device and computer-readable storage medium |
| CN115794827A (en) * | 2022-11-29 | 2023-03-14 | 广发银行股份有限公司 | Data table structure management system and method |
| CN115794827B (en) * | 2022-11-29 | 2023-07-21 | 广发银行股份有限公司 | Data table structure management system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112286907A (en) | Database configuration method and device, electronic equipment and readable storage medium | |
| CN112527848B (en) | Report data query method, device and system based on multiple data sources and storage medium | |
| CN111782216A (en) | Page generation method, server and storage medium | |
| US11557047B2 (en) | Method and apparatus for image processing and computer storage medium | |
| CN112506486A (en) | Search system establishing method and device, electronic equipment and readable storage medium | |
| CN110647316A (en) | Method and device for generating universal business object, computer equipment and storage medium | |
| CN113204345A (en) | Page generation method and device, electronic equipment and storage medium | |
| CN112732567A (en) | Mock data testing method and device based on ip, electronic equipment and storage medium | |
| CN114708461A (en) | Multi-modal learning model-based classification method, device, equipment and storage medium | |
| CN112187530A (en) | Log analysis method and device, electronic equipment and readable storage medium | |
| CN115731313A (en) | SVG format picture processing method, device, equipment, medium and product | |
| US11881044B2 (en) | Method and apparatus for processing image, device and storage medium | |
| CN108897779A (en) | A kind of quick obtaining list value and the method and system to list assignment | |
| CN116089535A (en) | Data synchronization method, device, equipment and storage medium | |
| CN113468258B (en) | Heterogeneous data conversion method, heterogeneous data conversion device and storage medium | |
| CN115114297A (en) | Data lightweight storage and search method and device, electronic equipment and storage medium | |
| US20090328034A1 (en) | Establishing a bi-directional grid computing network | |
| CN115599787A (en) | Level sub-metering method and device, electronic equipment and storage medium | |
| CN114004209A (en) | PDF format data export method and device, electronic equipment and readable storage medium | |
| CN113254455A (en) | Dynamic configuration method and device of database, computer equipment and storage medium | |
| CN112686759A (en) | Account checking monitoring method, device, equipment and medium | |
| CN112612427A (en) | Vehicle stop data processing method and device, storage medium and terminal | |
| US20230119741A1 (en) | Picture annotation method, apparatus, electronic device, and storage medium | |
| CN118278373A (en) | Custom examination certificate template generation method and device and electronic equipment | |
| CN113656431A (en) | Graph display method based on big data |
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 |