CN112540752B - Insurance product online release method and device, computer equipment and storage medium - Google Patents

Insurance product online release method and device, computer equipment and storage medium Download PDF

Info

Publication number
CN112540752B
CN112540752B CN202011482014.3A CN202011482014A CN112540752B CN 112540752 B CN112540752 B CN 112540752B CN 202011482014 A CN202011482014 A CN 202011482014A CN 112540752 B CN112540752 B CN 112540752B
Authority
CN
China
Prior art keywords
product
export
dangerous
code
state
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
Application number
CN202011482014.3A
Other languages
Chinese (zh)
Other versions
CN112540752A (en
Inventor
田玉明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Taikang Life Insurance Co ltd
Taikang Insurance Group Co Ltd
Original Assignee
Taikang Life Insurance Co ltd
Taikang Insurance Group Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Taikang Life Insurance Co ltd, Taikang Insurance Group Co Ltd filed Critical Taikang Life Insurance Co ltd
Priority to CN202011482014.3A priority Critical patent/CN112540752B/en
Publication of CN112540752A publication Critical patent/CN112540752A/en
Application granted granted Critical
Publication of CN112540752B publication Critical patent/CN112540752B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/31Programming languages or programming paradigms
    • G06F8/315Object-oriented languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/60Software deployment
    • G06F8/65Updates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/70Software maintenance or management
    • G06F8/71Version control; Configuration management

Abstract

The embodiment of the invention provides an online issuing method and device for insurance products, computer equipment and storage media, wherein the method comprises the following steps: creating editing dangerous seeds and generating dangerous seed codes, and storing states corresponding to the dangerous seed codes as effective after the dangerous seeds are released; creating an edited product and generating a product code, and storing the state corresponding to the product code into effect when the states of the dangerous seeds of the release and the product reference are all effective; exporting information of the state of the product as an SQL file, storing the exported state as export, and storing the current time as export time, wherein the SQL file name comprises environment information and export time used when the product is encoded and exported; and acquiring the export state and export time corresponding to the product code according to the product code and the environment information in the name of the SQL file to be published, and publishing the SQL file to be published online when the acquired export state is export and the export time in the name of the SQL file to be published is consistent with the acquired export time.

Description

Insurance product online release method and device, computer equipment and storage medium
Technical Field
The present invention relates to the field of product management technologies, and in particular, to an online insurance product issuing method, device, computer equipment, and storage medium.
Background
The product management system is a unified insurance product management platform and is used for managing information of sold insurance products, clauses and the like, can provide functions related to products such as external product information inquiry, premium calculation and the like, and new products or past product modification all need to maintain product information in the product management system, and the product management system is provided with three environments, namely a development environment (dev), a test environment (uat) and a production environment (prd), which are respectively used for development, test and online production of the products, while the current development online mode is used for carrying out product development for the development environment, and after development is completed, product sql files are extracted for carrying out test and online production, and the specific procedures are as follows:
1. when a new product of an insurance product is sold on line, a product demand document is arranged according to clause information provided by a product part, a verification part and the like, and a developer maintains information of the product, the dangerous seed and the like in a product management system according to the product demand and the clause information;
2. exporting product information into an sql file after product development is finished, and publishing the sql file to a test or production environment when the sql file is lifted or online;
3. When the extraction of the sql file of the product is completed, the product information needs to be modified in the system due to the reasons of change of the demand and the like, and after the modification of the product information is completed, developers are required to re-extract the sql file to ensure that the extracted and released product information is consistent with the developed product information, but the problem of online production that the released product information is inconsistent with the developed product information due to the fact that the sql file is not re-extracted by personnel errors in the whole process is probably solved, and meanwhile, the problems of online risk and execution efficiency exist in the manual extraction and comparison of the sql file and the operation online release.
Disclosure of Invention
The embodiment of the invention provides an online release method of an insurance product, which aims to solve the technical problems of inconsistent release product information and developed product information, operational risk caused by manual operation and low efficiency in the prior art of online release of the product. The method comprises the following steps:
creating an editing dangerous seed and generating a dangerous seed code, storing states corresponding to different stages corresponding to the dangerous seed code in the process of creating and editing the dangerous seed, and storing the states corresponding to the dangerous seed code as valid when an issuing instruction for the dangerous seed is received;
Creating an edited product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating and editing the product, and storing the states corresponding to the product code as effective when an issuing instruction for the product is received and the states of dangerous seeds cited by the product are effective;
for the product with the effective state, exporting the information of the product into an SQL file, storing the export state corresponding to the product code of the product as export time, storing the current time corresponding to the product code of the product as export time, and generating a file name for the SQL file, wherein the file name comprises environment information and export time used in the process of encoding and exporting the product;
acquiring an SQL file to be issued, acquiring an export state and export time which are correspondingly stored by a product code according to environment information used when the product code in the file name of the SQL file to be issued is exported, and if the acquired export state is exported and the export time in the file name of the SQL file to be issued is consistent with the acquired export time, publishing the SQL file to be issued online.
The embodiment of the invention also provides an online release device for the insurance product, which is used for solving the technical problems of inconsistent release product information and developed product information, operational risk caused by manual operation and low efficiency in the prior art of online release of the product. The device comprises:
The dangerous seed creation and editing module is used for creating and editing dangerous seeds and generating dangerous seed codes, storing states corresponding to different stages corresponding to the dangerous seed codes in the process of creating and editing the dangerous seeds, and storing the states corresponding to the dangerous seed codes as valid when an issuing instruction for the dangerous seeds is received;
the product creation and editing module is used for creating and editing a product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating and editing the product, and storing the states corresponding to the product code into effect when an issuing instruction of the product is received and the states of dangerous seeds cited by the product are all effective;
the file export module is used for exporting information of the product into an SQL file aiming at the product with the effective state, storing the export state into export corresponding to the product code of the product, storing the current time into export time corresponding to the product code of the product, and generating a file name for the SQL file, wherein the file name comprises environment information and export time used during product code and export;
the product online release module is used for acquiring the SQL file to be released, acquiring the export state and export time corresponding to the product code according to the environment information used when the product code in the file name of the SQL file to be released is exported, and releasing the SQL file to be released online when the acquired export state is exported and the export time in the file name of the SQL file to be released is consistent with the acquired export time.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the arbitrary online release method of the insurance product when executing the computer program, so as to solve the technical problems of inconsistent release product information and developed product information, operation risk caused by manual operation and low efficiency in the online release of the product in the prior art.
The embodiment of the invention also provides a computer readable storage medium which stores a computer program for executing the arbitrary insurance product online release method, so as to solve the technical problems of inconsistent release product information and developed product information, operation risk caused by manual operation and low efficiency in the prior art of product online release.
In the embodiment of the invention, the automatic creation and editing of the dangerous seed and the generation of the dangerous seed code are provided, the states corresponding to different stages are stored corresponding to the dangerous seed code in the process of creating the editing dangerous seed, and the states corresponding to the dangerous seed code are stored as valid when an issuing instruction for the dangerous seed is received; automatically creating an edited product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating the edited product, storing the states corresponding to the product code into effect when an issuing instruction of the product is received and the states of dangerous seeds cited by the product are all effective, further exporting information of the product into an SQL file aiming at the product with the states in effect, storing export states into the SQL file corresponding to the product code of the product, storing the current time into export time corresponding to the product code of the product, generating a file name for the SQL file, wherein the file name comprises environment information and export time used when the product code and export; and finally, acquiring the SQL file to be published, acquiring a export state and export time which are correspondingly stored by the product code according to the environment information used when the product code in the file name of the SQL file to be published is exported, and publishing the SQL file to be published online when the acquired export state is exported and the export time in the file name of the SQL file to be published is consistent with the acquired export time. The automatic production method has the advantages that the automatic production method realizes automation in the processes of creation and editing of dangerous seeds, creation and editing of products, export of SQL files and online release of SQL files, and compared with manual operation in the prior art, risks caused by the manual operation can be avoided, and efficiency is improved; in addition, states corresponding to different stages are stored in various links such as creating editing dangerous seeds, creating editing products, exporting SQL files, online release and the like, the consistency of the SQL files to be released and the actual development products is verified according to the states and export time of the SQL files, and after the consistency is verified, the SQL files to be released are released online.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate and together with the description serve to explain the application. In the drawings:
FIG. 1 is a flow chart of an online distribution method of insurance products provided by an embodiment of the application;
FIG. 2 is a schematic flow chart of a risk creation editing provided by an embodiment of the present application;
FIG. 3 is a schematic flow chart of a product creation editing provided by an embodiment of the present application;
FIG. 4 is a schematic diagram of a seed, product creation view provided by an embodiment of the present application;
FIG. 5 is a schematic flow chart of a product export process according to an embodiment of the present application;
FIG. 6 is a schematic flow chart of online release of a product according to an embodiment of the present application;
FIG. 7 is a block diagram of a computer device according to an embodiment of the present application;
fig. 8 is a block diagram of an on-line insurance product issuing device according to an embodiment of the present application.
Detailed Description
The present application will be described in further detail with reference to the following embodiments and the accompanying drawings, in order to make the objects, technical solutions and advantages of the present application more apparent. The exemplary embodiments of the present application and the descriptions thereof are used herein to explain the present application, but are not intended to limit the application.
In an embodiment of the present invention, an online insurance product issuing method is provided, as shown in fig. 1, where the method includes:
step 102: creating an editing dangerous seed and generating a dangerous seed code, storing states corresponding to different stages corresponding to the dangerous seed code in the process of creating and editing the dangerous seed, and storing the states corresponding to the dangerous seed code as valid when an issuing instruction for the dangerous seed is received;
step 104: creating an edited product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating and editing the product, and storing the states corresponding to the product code as effective when an issuing instruction for the product is received and the states of dangerous seeds cited by the product are effective;
step 106: for the product with the effective state, exporting the information of the product into an SQL file, storing the export state corresponding to the product code of the product as export time, storing the current time corresponding to the product code of the product as export time, and generating a file name for the SQL file, wherein the file name comprises environment information and export time used in the process of encoding and exporting the product;
Step 108: acquiring an SQL file to be issued, acquiring an export state and export time which are stored corresponding to the product code according to environment information used when the product code in the file name of the SQL file to be issued is exported, and if the acquired export state is export and the export time in the file name of the SQL file to be issued is consistent with the acquired export time, issuing the SQL file to be issued online, otherwise, not issuing the SQL file to be issued online.
As can be seen from the flow shown in fig. 1, in the embodiment of the present invention, it is proposed to automatically create an editing dangerous seed and generate a dangerous seed code, store states corresponding to different stages corresponding to the dangerous seed code in the process of creating the editing dangerous seed, and store the states corresponding to the dangerous seed code as valid when receiving an issue instruction for the dangerous seed; automatically creating an edited product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating the edited product, storing the states corresponding to the product code into effect when an issuing instruction of the product is received and the states of dangerous seeds cited by the product are all effective, further exporting information of the product into an SQL file aiming at the product with the states in effect, storing export states into the SQL file corresponding to the product code of the product, storing the current time into export time corresponding to the product code of the product, generating a file name for the SQL file, wherein the file name comprises environment information and export time used when the product code and export; and finally, acquiring the SQL file to be published, acquiring a export state and export time which are correspondingly stored by the product code according to the environment information used when the product code in the file name of the SQL file to be published is exported, and publishing the SQL file to be published online when the acquired export state is exported and the export time in the file name of the SQL file to be published is consistent with the acquired export time. The automatic production method has the advantages that the automatic production method realizes automation in the processes of creation and editing of dangerous seeds, creation and editing of products, export of SQL files and online release of SQL files, and compared with manual operation in the prior art, risks caused by the manual operation can be avoided, and efficiency is improved; in addition, states corresponding to different stages are stored in various links such as creating editing dangerous seeds, creating editing products, exporting SQL files, online release and the like, the consistency of the SQL files to be released and the actual development products is verified according to the states and export time of the SQL files, and after the consistency is verified, the SQL files to be released are released online.
In the embodiment, in order to realize that states corresponding to different stages are stored corresponding to the dangerous seed codes in the process of creating and editing the dangerous seed, the states corresponding to the stages are automatically stored for links such as creating the dangerous seed, editing the dangerous seed, auditing and publishing in the process of creating and editing the dangerous seed respectively so as to mark and indicate which stage of the creating and editing process the dangerous seed is. For example, as shown in fig. 2, the process of creating and editing the dangerous seed is that firstly, creating a new dangerous seed according to information such as the name of the dangerous seed and generating a dangerous seed code, wherein the dangerous seed code of an initial version of the dangerous seed is 1, and the state stored in the corresponding dangerous seed code after the creation of the dangerous seed is the state to be edited; secondly, editing dangerous seed information according to new product requirements and clause information, and receiving indication information of editing completion after the dangerous seed editing is completed, wherein the state stored by the corresponding dangerous seed codes is changed into a state to be distributed; and further, checking the dangerous seed information, and changing the state stored by the corresponding dangerous seed code into effective state when the issued instruction is received after the information checking is finished, namely, the dangerous seed finishes the creating and editing process at the moment, and can be referenced by a product subsequently.
In the embodiment, in order to realize that states corresponding to different stages are stored corresponding to product codes in the process of creating and editing products, the states corresponding to the stages are automatically stored for links such as creating products, editing products, auditing and publishing in the process of creating and editing products respectively so as to mark and clearly show which stage of the creating and editing process the products are. For example, as shown in fig. 3, the process of creating an edited product can create a product according to information such as a product name and generate a product code after the creation of the dangerous seed is completed, and the automatic storage state of the corresponding product code can be the state to be edited; furthermore, dangerous seeds of different versions can be quoted according to the needs, product information is edited according to the product sales needs, and after editing completion indication information is received, the state stored by corresponding product codes can be changed into a state to be distributed; and finally, checking the product information, and when an issuing instruction is received after the information is checked correctly, checking that dangerous seed information cited by the product is in a valid state, and changing the state stored by the corresponding product code into a valid state after the product is issued.
In the specific implementation, when states corresponding to different stages are stored in the processes of creating, editing, exporting and the like of the dangerous seed and the product, different table information storage states can be directly corresponding to each other, a table can be generated, states corresponding to the dangerous seed code and the product code in the table are stored, the table can be called an online release management table publicish, further, a lock state of the online release management table publicish can be set, an initialization lock state (isLocked) is false, the lock state is not locked, an export state (exportState) of the product, export time and the like can be stored in the online release management table publicish, and the initialization export state (exportState) is 0 and is not exported.
In the implementation, after the dangerous seed finishes the creation and editing process, if the dangerous seed information is found to be wrong or needs to be changed and the like, the dangerous seed can be withdrawn and then enter the editing stage to change the information. For example, in this embodiment, as shown in fig. 2, when a withdrawal instruction for a dangerous seed is received, whether the dangerous seed is referenced by an issued product is determined, if not, the dangerous seed is withdrawn, the state of the dangerous seed code corresponding to the storage of the dangerous seed is changed to be edited, the editing operation for the dangerous seed is received, and when the issue instruction for the edited dangerous seed is received, the state of the dangerous seed code corresponding to the storage of the dangerous seed is changed to be valid again; if yes, firstly withdrawing the released product referring to the dangerous seed, changing the state of the corresponding storage of the product code of the released product into a state to be edited, withdrawing the dangerous seed, and changing the state of the corresponding storage of the dangerous seed code of the dangerous seed into the state to be edited; and receiving editing operation of the dangerous seed, and changing the state of the dangerous seed code corresponding storage of the dangerous seed into effective state when receiving an issuing instruction of the edited dangerous seed.
In a specific implementation, when the same dangerous seed is referred to by different products, the attribute information (such as the name of the dangerous seed, the insurance amount of the dangerous seed, the insurance rate of the dangerous seed, the insurance period and the like) of the dangerous seed may be inconsistent, the prior art method is to create a new dangerous seed code and re-edit the dangerous seed (according to the new dangerous seed treatment), but the method does not actually meet the specification of product management, and also causes partial re-work, in order to meet the reference of the product to the dangerous seed of different versions and reduce the re-work, in the embodiment, for the dangerous seed which completes the creation and editing, as shown in fig. 2, when one dangerous seed is referred to by different products, the attribute is inconsistent, the dangerous seed is subjected to version, the dangerous seed code of the dangerous seed after version upgrading is added with 1 for the current maximum dangerous seed code, and the state corresponding to the storage of the dangerous seed code is changed into the state to be upgraded; receiving editing operation of the dangerous seed after version upgrading, and changing the state of the dangerous seed code corresponding storage after editing to the state to be distributed; and when receiving an instruction for issuing the dangerous seed after version upgrading, changing the dangerous seed code of the dangerous seed after version upgrading into a state which is correspondingly stored.
In the specific implementation, after the release of the upgraded dangerous seeds is completed, the dangerous seeds can be referred by new products, meanwhile, the past products can continuously use the dangerous seed information of the old version, if the dangerous seeds of a certain version are not referred by any product, the dangerous seed archiving treatment can be carried out, and the archived dangerous seeds are not displayed in the dangerous seed pool.
When the method is implemented, firstly, judging whether a storage state corresponding to a product code of a released product is locked or not, if so, unlocking the released product, then withdrawing the released product, changing the state corresponding to the product code of the released product from effective to be edited, and changing the export modification of an export state corresponding to the product code of the released product to post-export modification, wherein withdrawal of the product is not allowed under the locked state.
Specifically, as shown in fig. 3, when the product is withdrawn, checking the lock state in the online release management table publist, if the product is locked, the product cannot be withdrawn, if the product is withdrawn, unlocking is needed, the product can be withdrawn to the state to be edited after unlocking, and meanwhile, judging that if the export state in the online release management table publist is 1-exported, updating the export state to 2-exported and then modifying.
In the concrete implementation, in the process of modifying and editing the dangerous seeds and products, a service table can be created to store modified table information, update time and the like.
In a specific implementation, the existing product management system only supports one product model or structure, and different product models or structures cannot be flexibly configured, in this embodiment, in order to further improve flexibility of dangerous types and product configurations, as shown in fig. 4, specifically:
receiving attribute information flexibly configured and storing the attribute information, namely realizing attribute management, and adding the attribute information in an attribute pool;
receiving and storing value field information corresponding to the attribute information, namely realizing code table management, if the attribute information needs to maintain the value field after the attribute information is newly added, selecting the newly added attribute information in the code table management, and further adding the value field information;
the attribute information is classified, namely module management is realized, different attribute information of the product can be split into different types of modules, such as an application module, a security module and a claim settlement module, meanwhile, a special information module, such as an information module of reddening information, an investment account and the like, can be created according to the attribute information required by different types of products, and the module can be newly added or the existing module is selected for attribute information editing, and the maintained attribute information is selected for editing when the module is newly added or edited; the modules of different types can be combined into view templates of products, dangerous types and the like, and the module information and attribute information corresponding to the different view templates are different;
According to different types of attribute information, combining different types of modules into view templates of products, dangerous types and the like, wherein the view templates can comprise a dangerous type view template, a product view template and view templates of other functions, the view templates of other functions can be views of plans, responsibilities and the like, and different types of products, dangerous types and the like can be flexibly combined and configured according to the types of the products and the dangerous types; the combined view template can be stored in a mondab database (mondab is a non-relational database, and the view model can be flexibly stored).
After the view templates are obtained, in the process of creating and editing the dangerous seeds, the corresponding view templates can be determined from the dangerous seed view templates according to the types of the dangerous seeds, and then new dangerous seeds are created and dangerous seed codes are generated according to the names of the dangerous seeds, attribute information included in the view templates, corresponding value domain information and other information.
In the process of creating the edited product, firstly referencing the needed dangerous seeds according to the type of the product; determining a corresponding view template from the product view templates according to the type of the product; and creating and editing the product according to the attribute information, the corresponding value range information and the quoted dangerous seed included in the determined view template. Wherein, the attribute information included in the product view template can be product basic information, channel information and the like.
When the method is implemented, after the product is created and edited, the product with effective state can be exported, namely, the information of the product is exported into an SQL file, the export state is stored as export corresponding to the product code of the product, the current time is stored as export time corresponding to the product code of the product, a file name is generated for the SQL file, and the file name comprises the environment information and the export time used during the product code and export.
In particular implementations, export types may also be set for different products, e.g., receiving export instructions for a product, which may include product codes and export types for the product;
when the export type is full export, acquiring all table information of the product according to the product code of the product and exporting the table information into an SQL file;
when the export type is incremental export, table information with updated time after the export time is obtained according to the product code of the product and exported as an SQL file.
Specifically, as shown in fig. 5, the input parameters of the export instruction are product coding and export types, the export types include full export (applicable to new products) and incremental export (applicable to updated products), and if the export is full export, all table information of the products is exported as sql files; if the table information is the increment export, comparing the update time in the table information related to the product with the export time in the online release management table during export, and if the update time is after the export time, indicating that the table is modified after export, and then needing to be exported as an sql file; the file name format of the sql file may be: and (3) the environment-product coding-export type-export time, uploading the generated sql file to a git appointed directory after the export is completed, and meanwhile, judging that the online release management table is updated if the product state is the released state, wherein the online release management table is updated, the export time is the current time, the export update state is 1-exported, the lock state is true, the locked product is forbidden to be modified.
In specific implementation, after the product is exported, the online release stage can be entered, as shown in fig. 6, when an online release pipeline jenkins is triggered, jenkins can acquire the latest sql file to be online released from a git appointed directory, analyze the name of the sql file, acquire environment information (dev-development environment, uat-test environment, etc.), product codes and timestamps (export time) used when the sql file is exported, adjust different interfaces based on different environment information, acquire the export state and export time of the current product from an online release management table according to the product codes, and verify that if the acquired export state is 1-exported and the acquired export time is consistent with the timestamp in the file name, the designated environment executes the online release of the sql file; otherwise, the pipeline is interrupted, whether full release (direct storage) or incremental release (storage update) is judged according to the analyzed export type, and the online release result of the product is verified through the page after the online release is completed.
In this embodiment, a process for implementing the above-mentioned online insurance product release method is specifically described, where the process includes the following steps:
1. assuming a new product requirement, including 1 new product and two dangerous types, creating compiled product information in a development environment (dev); firstly, creating an editing dangerous seed, wherein after the dangerous seed editing is finished, the state of the corresponding storage of the dangerous seed code is an effective state, then creating a product, when the product is created, associating the two dangerous seeds which are effective, after the product editing is finished, releasing the product, wherein the state of the corresponding storage of the product code is an effective state, the product code is P1, and meanwhile, generating an online release management table of the product, wherein the exported state is not exported, the locked state is unlocked, and the exported time is empty;
2. Exporting product information, generating a file with a file name of dev_P1_2020010110101010. Sql, uploading the file to a git warehouse, updating an online release management table at the moment, wherein the export state is 1-exported, the lock state is locked, and the export time is 20200101101010;
3. at the moment, the requirement is changed, the product information needs to be modified, the product is withdrawn firstly, the locked state of the product cannot be withdrawn, the product is unlocked firstly, the state of the lock is set to be unlocked, then the product is withdrawn to the state to be edited by clicking the withdrawal, at the moment, the export state in the online distribution management is judged to be 1-exported, and then the export state is updated to be 2-exported and then modified;
4. reissuing the product into an effective state after the product editing is finished, and if the online release pipeline is executed, the product cannot be successfully released because the export state in the online release management table is modified after 2-export;
5. the export state in the online release management table is updated to be 1-exported, the lock state is locked, and the export time is 20200101111010, and when the online release pipeline executes the sql file which is dev_p1_2020010110101010. Sql, release fails due to the fact that the timestamp 20200101101010 is different from the export time 20200101111010, and only the correct sql file can be executed correctly in the online release pipeline.
In this embodiment, a computer device is provided, as shown in fig. 7, including a memory 702, a processor 704, and a computer program stored in the memory and capable of running on the processor, where the processor implements any of the above-mentioned insurance product online distribution methods when executing the computer program.
In particular, the computer device may be a computer terminal, a server or similar computing means.
In this embodiment, a computer-readable storage medium storing a computer program for executing any of the insurance product online distribution methods described above is provided.
In particular, computer-readable storage media, including both permanent and non-permanent, removable and non-removable media, may be used to implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer-readable storage media include, but are not limited to, phase-change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Disks (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable storage media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
Based on the same inventive concept, the embodiment of the invention also provides an online release device for insurance products, as described in the following embodiment. Because the principle of the on-line issuing device for the insurance product for solving the problem is similar to that of the on-line issuing method for the insurance product, the implementation of the on-line issuing device for the insurance product can be referred to the implementation of the on-line issuing method for the insurance product, and the repetition is not repeated. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.
Fig. 8 is a block diagram of an on-line insurance product issuing device according to an embodiment of the present invention, as shown in fig. 8, including:
the dangerous seed creation and editing module 802 is used for creating and editing dangerous seeds and generating dangerous seed codes, storing states corresponding to different stages corresponding to the dangerous seed codes in the process of creating and editing the dangerous seeds, and storing the states corresponding to the dangerous seed codes as valid when an issuing instruction for the dangerous seeds is received;
the product creation editing module 804 is configured to create an edited product and generate a product code, store states corresponding to different stages corresponding to the product code in a process of creating and editing the product, and store the states corresponding to the product code as valid when an issue instruction for the product is received and the states of dangerous types cited by the product are valid;
A file export module 806, configured to export information of the product into an SQL file for the product whose status is valid, store an export status for the product code of the product as export, store a current time for the product code of the product as export time, and generate a file name for the SQL file, where the file name includes environment information and export time used when the product code and export are coded;
the product online publishing module 808 is configured to obtain an SQL file to be published, obtain a export state and export time corresponding to the product code according to environmental information used when the product code is exported in a file name of the SQL file to be published, and when the obtained export state is export and the export time in the file name of the SQL file to be published is consistent with the obtained export time, publish the SQL file to be published online.
In one embodiment, the apparatus further comprises:
the withdrawal module is used for judging whether the dangerous seed is quoted by the issued product when receiving a withdrawal instruction of the dangerous seed, if so, withdrawing the issued product quoted by the dangerous seed, changing the state of the corresponding storage of the product code of the issued product into to-be-edited, withdrawing the dangerous seed, and changing the state of the corresponding storage of the dangerous seed code of the dangerous seed into to-be-edited;
The editing module is used for receiving editing operation of the dangerous seeds and changing the state of the corresponding storage of the dangerous seed codes of the dangerous seeds into valid when receiving an issuing instruction of the edited dangerous seeds.
In one embodiment, further comprising:
the dangerous seed upgrading module is used for carrying out version upgrading on the dangerous seeds when the attribute of one dangerous seed is inconsistent when the dangerous seeds are led by different products, adding 1 to the current maximum dangerous seed code of the dangerous seeds after version upgrading, receiving editing operation on the dangerous seeds after version upgrading, and changing the state of the dangerous seed code corresponding to the stored dangerous seeds after version upgrading into effective state when receiving an issuing instruction on the dangerous seeds after version upgrading.
In one embodiment, the revocation module is further configured to determine whether a storage state corresponding to a product code of the published product is locked, if yes, unlock the published product, revoke the published product, change a state corresponding to the product code of the published product from effective to be edited, and modify a export state corresponding to the product code of the published product to post-export modification, where the product is not allowed to be revoked in the locked state.
In one embodiment, the apparatus further comprises:
the attribute management module is used for receiving and storing attribute information;
the code table management module is used for receiving and storing value domain information corresponding to the attribute information;
the module management module is used for classifying the attribute information;
the view management module is used for combining different view templates according to the attribute information of different classes, wherein the view templates comprise a dangerous view template, a product view template and view templates with other functions;
the dangerous seed creation editing module is also used for determining a corresponding view template from the dangerous seed view templates according to the type of the dangerous seed; and creating and editing the dangerous seed according to the attribute information and the corresponding value range information included in the determined view template.
In one embodiment, the product creation editing module is further configured to reference a desired risk according to a type of the product; determining a corresponding view template from the product view templates according to the type of the product; and creating and editing the product according to the attribute information, the corresponding value range information and the quoted dangerous seed included in the determined view template.
In one embodiment, the file export module is further configured to receive export instructions for the product, where the instructions include a product code and export type of the product; when the export type is full export, acquiring all table information of the product according to the product code of the product and exporting the table information into an SQL file; when the export type is incremental export, table information of updated time after export time is obtained according to the product code of the product and exported as an SQL file.
The embodiment of the invention realizes the following technical effects: the method comprises the steps of providing automatic creation and editing of dangerous seeds and generation of dangerous seed codes, storing states corresponding to different stages corresponding to the dangerous seed codes in the process of creating the editing dangerous seeds, and storing the states corresponding to the dangerous seed codes as effective when an issuing instruction for the dangerous seeds is received; automatically creating an edited product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating the edited product, storing the states corresponding to the product code into effect when an issuing instruction of the product is received and the states of dangerous seeds cited by the product are all effective, further exporting information of the product into an SQL file aiming at the product with the states in effect, storing export states into the SQL file corresponding to the product code of the product, storing the current time into export time corresponding to the product code of the product, generating a file name for the SQL file, wherein the file name comprises environment information and export time used when the product code and export; and finally, acquiring the SQL file to be published, acquiring a export state and export time which are correspondingly stored by the product code according to the environment information used when the product code in the file name of the SQL file to be published is exported, and publishing the SQL file to be published online when the acquired export state is exported and the export time in the file name of the SQL file to be published is consistent with the acquired export time. The automatic production method has the advantages that the automatic production method realizes automation in the processes of creation and editing of dangerous seeds, creation and editing of products, export of SQL files and online release of SQL files, and compared with manual operation in the prior art, risks caused by the manual operation can be avoided, and efficiency is improved; in addition, states corresponding to different stages are stored in various links such as creating editing dangerous seeds, creating editing products, exporting SQL files, online release and the like, the consistency of the SQL files to be released and the actual development products is verified according to the states and export time of the SQL files, and after the consistency is verified, the SQL files to be released are released online.
It will be apparent to those skilled in the art that the modules or steps of the embodiments of the invention described above may be implemented in a general purpose computing device, they may be concentrated on a single computing device, or distributed across a network of computing devices, they may alternatively be implemented in program code executable by computing devices, so that they may be stored in a storage device for execution by computing devices, and in some cases, the steps shown or described may be performed in a different order than what is shown or described, or they may be separately fabricated into individual integrated circuit modules, or a plurality of modules or steps in them may be fabricated into a single integrated circuit module. Thus, embodiments of the invention are not limited to any specific combination of hardware and software.
The above description is only of the preferred embodiments of the present invention and is not intended to limit the present invention, and various modifications and variations can be made to the embodiments of the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (10)

1. An online release method for insurance products is characterized by comprising the following steps:
creating an editing dangerous seed and generating a dangerous seed code, storing states corresponding to different stages corresponding to the dangerous seed code in the process of creating and editing the dangerous seed, and storing the states corresponding to the dangerous seed code as valid when an issuing instruction for the dangerous seed is received;
creating an edited product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating and editing the product, and storing the states corresponding to the product code as effective when an issuing instruction for the product is received and the states of dangerous seeds cited by the product are effective;
for the product with the effective state, exporting the information of the product into an SQL file, storing the export state corresponding to the product code of the product as export time, storing the current time corresponding to the product code of the product as export time, and generating a file name for the SQL file, wherein the file name comprises environment information and export time used in the process of encoding and exporting the product;
acquiring an SQL file to be issued, acquiring an export state and export time which are correspondingly stored by a product code according to environment information used when the product code in the file name of the SQL file to be issued is exported, and if the acquired export state is exported and the export time in the file name of the SQL file to be issued is consistent with the acquired export time, publishing the SQL file to be issued online.
2. The insurance product online distribution method of claim 1, further comprising:
when a withdrawal instruction for the dangerous seed is received, judging whether the dangerous seed is quoted by a released product, if so, withdrawing the released product referencing the dangerous seed, changing the corresponding stored state of the product code of the released product into a state to be edited, withdrawing the dangerous seed, and changing the corresponding stored state of the dangerous seed code of the dangerous seed into the state to be edited;
and receiving editing operation of the dangerous seed, and changing the state of the dangerous seed code corresponding storage of the dangerous seed into valid when receiving an issuing instruction of the edited dangerous seed.
3. The insurance product online distribution method according to claim 2, further comprising:
when the attribute of one dangerous seed is inconsistent when the dangerous seed is led by different products, carrying out version upgrading on the dangerous seed, adding 1 to the dangerous seed code of the dangerous seed after version upgrading, receiving editing operation on the dangerous seed after version upgrading, and changing the state of corresponding storage of the dangerous seed code of the dangerous seed after version upgrading into effective when receiving an issuing instruction of the dangerous seed after version upgrading.
4. The insurance product online distribution method according to claim 2, wherein withdrawing the distributed product referring to the dangerous seed and changing the product code of the product to a corresponding stored state to be edited, includes:
judging whether the lock state of the online release management table corresponding to the product code of the released product is locked or not, if so, unlocking the lock state firstly, then withdrawing the released product, changing the state of the product code corresponding storage of the released product from effective to be edited, and changing the export state of the product code corresponding storage of the released product from export to export and then modifying, wherein withdrawing the product is not allowed under the lock state of the online release management table.
5. The insurance product online distribution method according to any one of claims 1 to 4, further comprising:
receiving and storing attribute information;
receiving and storing value domain information corresponding to the attribute information;
classifying the attribute information;
combining different view templates according to different types of the attribute information, wherein the view templates comprise a dangerous view template, a product view template and view templates with other functions;
creating editing risk, including:
Determining a corresponding view template from the dangerous view templates according to the type of the dangerous;
and creating and editing the dangerous seed according to the attribute information and the corresponding value range information included in the determined view template.
6. The insurance product online distribution method of claim 5, wherein creating an edited product includes:
referencing a desired risk according to the type of the product;
determining a corresponding view template from the product view templates according to the type of the product;
and creating and editing the product according to the attribute information, the corresponding value range information and the quoted dangerous seed included in the determined view template.
7. The insurance product online distribution method according to any one of claims 1 to 4, characterized in that exporting information of the product as an SQL file includes:
receiving export instructions for the product, wherein the instructions include a product code and an export type of the product;
when the export type is full export, acquiring all table information of the product according to the product code of the product and exporting the table information into an SQL file;
when the export type is incremental export, table information of updated time after export time is obtained according to the product code of the product and exported as an SQL file.
8. An insurance product online issuing device, comprising:
the dangerous seed creation and editing module is used for creating and editing dangerous seeds and generating dangerous seed codes, storing states corresponding to different stages corresponding to the dangerous seed codes in the process of creating and editing the dangerous seeds, and storing the states corresponding to the dangerous seed codes as valid when an issuing instruction for the dangerous seeds is received;
the product creation and editing module is used for creating and editing a product and generating a product code, storing states corresponding to different stages corresponding to the product code in the process of creating and editing the product, and storing the states corresponding to the product code into effect when an issuing instruction of the product is received and the states of dangerous seeds cited by the product are all effective;
the file export module is used for exporting information of the product into an SQL file aiming at the product with the effective state, storing the export state into export corresponding to the product code of the product, storing the current time into export time corresponding to the product code of the product, and generating a file name for the SQL file, wherein the file name comprises environment information and export time used during product code and export;
The product online release module is used for acquiring the SQL file to be released, acquiring the export state and export time corresponding to the product code according to the environment information used when the product code in the file name of the SQL file to be released is exported, and releasing the SQL file to be released online when the acquired export state is exported and the export time in the file name of the SQL file to be released is consistent with the acquired export time.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the insurance product online distribution method of any of claims 1 to 7 when the computer program is executed by the processor.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program that performs the insurance product online distribution method of any one of claims 1 to 7.
CN202011482014.3A 2020-12-16 2020-12-16 Insurance product online release method and device, computer equipment and storage medium Active CN112540752B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011482014.3A CN112540752B (en) 2020-12-16 2020-12-16 Insurance product online release method and device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011482014.3A CN112540752B (en) 2020-12-16 2020-12-16 Insurance product online release method and device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN112540752A CN112540752A (en) 2021-03-23
CN112540752B true CN112540752B (en) 2023-09-22

Family

ID=75018834

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011482014.3A Active CN112540752B (en) 2020-12-16 2020-12-16 Insurance product online release method and device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112540752B (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102799430A (en) * 2012-07-02 2012-11-28 电子科技大学 Mobile internet business-oriented off-line visual business development generator
CN108108493A (en) * 2018-01-17 2018-06-01 中国平安人寿保险股份有限公司 Algorithm process method, server and storage medium based on the demonstration of MIT interests
CN108257031A (en) * 2017-11-09 2018-07-06 中国平安人寿保险股份有限公司 Medical insurance product dissemination method, device and storage medium
US10585663B1 (en) * 2017-10-13 2020-03-10 State Farm Mutual Automobile Insurance Company Automated data store access source code review
CN111062818A (en) * 2019-11-08 2020-04-24 崔玉龙 Insurance customization system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102799430A (en) * 2012-07-02 2012-11-28 电子科技大学 Mobile internet business-oriented off-line visual business development generator
US10585663B1 (en) * 2017-10-13 2020-03-10 State Farm Mutual Automobile Insurance Company Automated data store access source code review
CN108257031A (en) * 2017-11-09 2018-07-06 中国平安人寿保险股份有限公司 Medical insurance product dissemination method, device and storage medium
CN108108493A (en) * 2018-01-17 2018-06-01 中国平安人寿保险股份有限公司 Algorithm process method, server and storage medium based on the demonstration of MIT interests
CN111062818A (en) * 2019-11-08 2020-04-24 崔玉龙 Insurance customization system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
李君香.设备管理软件.《中国科技投资》.2013,第36页. *

Also Published As

Publication number Publication date
CN112540752A (en) 2021-03-23

Similar Documents

Publication Publication Date Title
US8010962B2 (en) Infrastructure for the automation of the assembly of schema maintenance scripts
US6519763B1 (en) Time management and task completion and prediction software
US20080140732A1 (en) Method and system for sharing file based data
AU756363B2 (en) Method and apparatus for round-trip software engineering
US10970673B2 (en) Bill of material synchronization
CN102682096B (en) Collaborative management device and collaborative management method for simulation resource information and model source codes
US20080091742A1 (en) System and method for detecting and updating geographical information dataset versions
CN105915381B (en) A kind of realization monitoring system service logic online modification system
US20150006469A1 (en) Methodology supported business intelligence (BI) software and system
US20150254073A1 (en) System and Method for Managing Versions of Program Assets
US9535687B2 (en) Audited builds based upon separate class dependency records
CN114780563A (en) Zipper surface processing method and equipment based on data lake
CN106951593B (en) Method and device for generating configuration file of protection measurement and control device
CN112540752B (en) Insurance product online release method and device, computer equipment and storage medium
KR102365292B1 (en) A method for managing the lifecycle of a complex engineering object and a system for its implementation
CN105550116A (en) Automated test management system
RU2683690C1 (en) Method and system for automatic generation of a program code for an enterprise data warehouse
CN108647018A (en) Can live preview code generating system
US11934800B2 (en) Generating metadata to facilitate code generation
CN117573199B (en) Model difference comparison analysis method, device, equipment and medium
CN115237875B (en) Log data processing method, device, equipment and storage medium
KR101926165B1 (en) The document editing system of web-based hmi solution and document editing method by the system
US20050108279A1 (en) Method and dynamic system for the mangement and production of technical documentation in a database
CN115113917A (en) Method and device for storing and importing system configuration information
CN117668085A (en) Automatic ETL device and method based on graphic interface configuration

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