CN114996243A - Database operation method and device, electronic equipment and storage medium - Google Patents
Database operation method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN114996243A CN114996243A CN202210719886.XA CN202210719886A CN114996243A CN 114996243 A CN114996243 A CN 114996243A CN 202210719886 A CN202210719886 A CN 202210719886A CN 114996243 A CN114996243 A CN 114996243A
- Authority
- CN
- China
- Prior art keywords
- database
- operation statement
- statement
- target object
- audit field
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明实施例公开了一种数据库操作方法、装置、电子设备及存储介质。该方法包括:当目标对象对数据库进行操作时,获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句;确定所述第一操作语句中是否包含预设审计字段,若否,则基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。本发明实施例的技术方案,实现在对数据库进行操作时,自动记录审计字段所对应的数据,从而提升了开发效率,降低了开发成本。
The embodiments of the present invention disclose a database operation method, device, electronic device and storage medium. The method includes: when a target object operates a database, acquiring object information of the target object, and acquiring a first operation statement for the target object to operate on the database; determining whether the first operation statement contains A preset audit field, if not, a second operation statement is generated based on the preset audit field, the object information and the first operation statement, and the second operation statement is executed to perform an operation on the database. data manipulation. The technical scheme of the embodiment of the present invention realizes that when the database is operated, the data corresponding to the audit field is automatically recorded, thereby improving the development efficiency and reducing the development cost.
Description
技术领域technical field
本发明涉及计算机技术领域,尤其涉及一种数据库操作方法、装置、电子设备及存储介质。The present invention relates to the field of computer technology, and in particular, to a database operation method, apparatus, electronic device and storage medium.
背景技术Background technique
随着计算机技术的发展,数据库被广泛的应用于软件开发。目前,在软件开发过程中,一般是基于技术人员所编写的数据库操作语句对数据库中数据进行操作,例如,修改数据库中的数据或向数据库中插入数据。为了保证数据库中记录的数据的来源,就需要通过审计字段记录数据库中数据。现有技术中,当技术人员对数据库进行操作时,通常需要技术人员采用手动的方式对审计字段进行赋值,不仅大大影响开发效率,而且还存在开发成本较高的问题。With the development of computer technology, databases are widely used in software development. At present, in the software development process, data in the database is generally operated on the basis of database operation statements written by technicians, for example, data in the database is modified or data is inserted into the database. In order to ensure the source of the data recorded in the database, it is necessary to record the data in the database through the audit field. In the prior art, when a technician operates a database, the technician is usually required to manually assign values to the audit fields, which not only greatly affects the development efficiency, but also has the problem of high development cost.
发明内容SUMMARY OF THE INVENTION
本发明提供了一种数据库操作方法、装置、电子设备及存储介质,以实现在对数据库进行操作时,自动记录审计字段所对应的数据,从而提升了开发效率,降低了开发成本。The invention provides a database operation method, device, electronic equipment and storage medium, so as to realize the automatic recording of data corresponding to audit fields when the database is operated, thereby improving the development efficiency and reducing the development cost.
根据本发明的一方面,提供了一种数据库操作方法,该方法包括:According to an aspect of the present invention, a database operation method is provided, the method comprising:
当目标对象对数据库进行操作时,获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句;When the target object operates the database, obtain the object information of the target object, and obtain the first operation statement of the target object to operate the database;
确定所述第一操作语句中是否包含预设审计字段,若否,则基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。Determine whether the first operation statement contains a preset audit field, and if not, generate a second operation statement based on the preset audit field, the object information and the first operation statement, and execute the first operation statement. Two operation statements to perform data operations on the database.
根据本发明的另一方面,提供了一种数据库操作装置。该装置包括:According to another aspect of the present invention, a database operation apparatus is provided. The device includes:
第一操作语句获取模块,用于当目标对象对数据库进行操作时,获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句;a first operation statement obtaining module, configured to obtain object information of the target object when the target object operates on the database, and obtain the first operation statement of the target object to operate the database;
第一数据库操作模块,用于确定所述第一操作语句中是否包含预设审计字段,若否,则基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。The first database operation module is used to determine whether the first operation statement contains a preset audit field, and if not, generate a second operation statement based on the preset audit field, the object information and the first operation statement. The operation statement is executed, and the second operation statement is executed to perform data operation on the database.
根据本发明的另一方面,提供了一种电子设备,所述电子设备包括:According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:
至少一个处理器;以及at least one processor; and
与所述至少一个处理器通信连接的存储器;其中,a memory communicatively coupled to the at least one processor; wherein,
所述存储器存储有可被所述至少一个处理器执行的计算机程序,所述计算机程序被所述至少一个处理器执行,以使所述至少一个处理器能够执行本发明任一实施例所述的数据库操作方法。The memory stores a computer program executable by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform any of the embodiments of the present invention. Database operation methods.
根据本发明的另一方面,提供了一种计算机可读存储介质,所述计算机可读存储介质存储有计算机指令,所述计算机指令用于使处理器执行时实现本发明任一实施例所述的数据库操作方法。According to another aspect of the present invention, a computer-readable storage medium is provided, where computer instructions are stored in the computer-readable storage medium, and the computer instructions are used to cause a processor to implement any of the embodiments of the present invention when executed. database operation method.
本发明实施例的技术方案,当目标对象对数据库进行操作时,通过获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句。进而可以确定所述第一操作语句中是否包含预设审计字段,若否,则可以基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。本发明实施例的技术方案,解决了现有操作数据库时需要手动赋值审计字段所存在的开发效率较低和开发成本较高的技术问题,实现了在对数据库进行操作时,自动记录审计字段所对应的数据,从而提升了开发效率,降低了开发成本。According to the technical solution of the embodiment of the present invention, when the target object operates on the database, the object information of the target object is obtained, and the first operation statement of the target object to operate the database is obtained. Further, it can be determined whether the first operation statement contains a preset audit field, and if not, a second operation statement can be generated based on the preset audit field, the object information and the first operation statement, and executed The second operation statement is used to perform data operation on the database. The technical solution of the embodiment of the present invention solves the technical problems of low development efficiency and high development cost that need to manually assign audit fields when operating the database, and realizes that when the database is operated, automatically record all the audit fields. Corresponding data, thereby improving development efficiency and reducing development costs.
应当理解,本部分所描述的内容并非旨在标识本发明的实施例的关键或重要特征,也不用于限制本发明的范围。本发明的其它特征将通过以下的说明书而变得容易理解。It should be understood that the content described in this section is not intended to identify key or critical features of the embodiments of the invention, nor is it intended to limit the scope of the invention. Other features of the present invention will become readily understood from the following description.
附图说明Description of drawings
为了更清楚地说明本发明实施例中的技术方案,下面将对实施例描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to illustrate the technical solutions in the embodiments of the present invention more clearly, the following briefly introduces the accompanying drawings used in the description of the embodiments. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained from these drawings without creative effort.
图1为本发明实施例一提供的一种数据库操作方法的流程示意图;1 is a schematic flowchart of a method for operating a database according to Embodiment 1 of the present invention;
图2为本发明实施例二提供的一种数据库操作装置的结构示意图;FIG. 2 is a schematic structural diagram of a database operating device according to Embodiment 2 of the present invention;
图3为本发明实施例三提供的一种电子设备的结构示意图。FIG. 3 is a schematic structural diagram of an electronic device according to Embodiment 3 of the present invention.
具体实施方式Detailed ways
为了使本技术领域的人员更好地理解本发明方案,下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分的实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都应当属于本发明保护的范围。In order to make those skilled in the art better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only Embodiments are part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.
需要说明的是,本发明的说明书和权利要求书及上述附图中的术语“第一”、“第二”等是用于区别类似的对象,而不必用于描述特定的顺序或先后次序。应该理解这样使用的数据在适当情况下可以互换,以便这里描述的本发明的实施例能够以除了在这里图示或描述的那些以外的顺序实施。此外,术语“包括”和“具有”以及他们的任何变形,意图在于覆盖不排他的包含,例如,包含了一系列步骤或单元的过程、方法、系统、产品或设备不必限于清楚地列出的那些步骤或单元,而是可包括没有清楚地列出的或对于这些过程、方法、产品或设备固有的其它步骤或单元。It should be noted that the terms "first", "second" and the like in the description and claims of the present invention and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used may be interchanged under appropriate circumstances such that the embodiments of the invention described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having" and any variations thereof, are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those expressly listed Rather, those steps or units may include other steps or units not expressly listed or inherent to these processes, methods, products or devices.
可以理解的是,在使用本公开各实施例公开的技术方案之前,均应当依据相关法律法规通过恰当的方式对本公开所涉及个人信息的类型、使用范围、使用场景等告知用户并获得用户的授权。It can be understood that, before using the technical solutions disclosed in the embodiments of the present disclosure, the user should be informed of the type, scope of use, and use scenario of the personal information involved in the present disclosure in an appropriate manner in accordance with relevant laws and regulations, and the user's authorization should be obtained. .
例如,在响应于接收到用户的主动请求时,向用户发送提示信息,以明确地提示用户,其请求执行的操作将需要获取和使用到用户的个人信息。从而,使得用户可以根据提示信息来自主地选择是否向执行本公开技术方案的操作的电子设备、应用程序、服务器或存储介质等软件或硬件提供个人信息。For example, in response to receiving an active request from the user, prompt information is sent to the user to explicitly prompt the user that the requested operation will require the acquisition and use of the user's personal information. Therefore, the user can independently choose whether to provide personal information to software or hardware such as electronic devices, applications, servers, or storage media that perform operations of the technical solutions of the present disclosure according to the prompt information.
作为一种可选的但非限定性的实现方式,响应于接收到用户的主动请求,向用户发送提示信息的方式例如可以是弹窗的方式,弹窗中可以以文字的方式呈现提示信息。此外,弹窗中还可以承载供用户选择“同意”或者“不同意”向电子设备提供个人信息的选择控件。As an optional but non-limiting implementation manner, in response to receiving the user's active request, the method of sending prompt information to the user may be, for example, a pop-up window, and the prompt information may be presented in text in the pop-up window. In addition, the pop-up window may also carry a selection control for the user to select "agree" or "disagree" to provide personal information to the electronic device.
可以理解的是,上述通知和获取用户授权过程仅是示意性的,不对本公开的实现方式构成限定,其它满足相关法律法规的方式也可应用于本公开的实现方式中。It can be understood that the above process of notifying and obtaining user authorization is only illustrative, and does not limit the implementation of the present disclosure, and other methods that satisfy relevant laws and regulations can also be applied to the implementation of the present disclosure.
实施例一Example 1
图1为本发明实施例一提供的一种数据库操作方法的流程示意图,本实施例可适用于对数据库进行操作的情况,该方法可以由数据库操作装置来执行,该数据库操作装置可以采用硬件和/或软件的形式实现,该数据库操作装置可配置于诸如计算机或者服务器等的电子设备中。如图1所示,本实施例的方法包括:FIG. 1 is a schematic flowchart of a method for operating a database according to Embodiment 1 of the present invention. This embodiment is applicable to the case of operating a database, and the method can be executed by a database operating device, and the database operating device can use hardware and Implemented in the form of software and/or software, the database operation apparatus may be configured in electronic equipment such as a computer or a server. As shown in Figure 1, the method of this embodiment includes:
S110、当目标对象对数据库进行操作时,获取目标对象的对象信息,并获取目标对象对数据库进行操作的第一操作语句。S110. When the target object operates on the database, obtain object information of the target object, and obtain a first operation statement for the target object to operate on the database.
其中,目标对象可以理解对数据库进行操作的对象。目标对象的数量可以是一个、两个或两个以上。在本发明实施例中,对数据库进行操作包括:于数据库中创建数据表的操作,于数据库中修改数据表的操作,于数据库中的数据表中插入数据的操作,以及于数据库中的数据表中修改数据的操作中的至少一个。对象信息可以包括对象标识和/或操作时刻。对象标识可以由对象名称和对象角色等信息组合。操作时刻可以理解为目标对象对数据库中的数据进行操作的时刻。第一操作语句可以理解为对数据库进行操作的原始数据库操作语句。需要说明的是,第一操作语句可以由至少一条数据库操作语句组合得到。Among them, the target object can understand the object that operates the database. The number of target objects can be one, two or more. In the embodiment of the present invention, the operation of the database includes: an operation of creating a data table in the database, an operation of modifying a data table in the database, an operation of inserting data into a data table in the database, and an operation of inserting data into a data table in the database At least one of the operations that modify data in . Object information may include object identification and/or time of operation. Object identification can be composed of information such as object name and object role. The operation moment can be understood as the moment when the target object operates the data in the database. The first operation statement can be understood as an original database operation statement for operating the database. It should be noted that the first operation statement may be obtained by combining at least one database operation statement.
具体的,当检测到目标对象对数据库进行操作时,可以获取所述目标对象的对象标识,以及记录所述目标对象操作所述数据库的操作时间。进而可以将所述对象标识和操作时间作为目标对象的对象信息。以及在目标对象对数据库进行操作时,可以拦截该目标对象对数据库进行操作的第一操作语句。需要说明的是,在目标对象对数据库进行操作时,可以先执行获取对象信息的操作,后执行获取第一操作语句的操作;或者,可以先执行获取第一操作语句的操作,后执行获取对象信息的操作。Specifically, when it is detected that the target object operates on the database, the object identifier of the target object can be acquired, and the operation time of the target object operating the database can be recorded. Further, the object identification and operation time may be used as object information of the target object. And when the target object operates on the database, the first operation statement for the target object to operate on the database can be intercepted. It should be noted that when the target object operates on the database, the operation of obtaining the object information may be performed first, and then the operation of obtaining the first operation statement may be performed; or, the operation of obtaining the first operation statement may be performed first, and then the operation of obtaining the object may be performed. information manipulation.
需要说明的是,目标对象所操作的数据库的种类有多种,在此不做具体限定,例如,可以为Oracle数据库、SQLServer数据库以及MongoDB数据库等。It should be noted that there are various types of databases operated by the target object, which are not specifically limited here. For example, they may be Oracle databases, SQL Server databases, and MongoDB databases.
可选地,在获取目标对象的对象信息之后,还包括:确定对象信息是否为有效信息,可避免出现恶意修改数据库中数据的现象。若是,则执行获取目标对象对数据库进行操作的第一操作语句。在本发明实施例中,在获取到目标对象的对象信息后,确定获取到的对象信息是否为有效信息,可有效的保证数据安全。可以理解的是,如果确定对象信息并非为有效信息,则可以生成提示信息,以提示目标对象输入有效信息。Optionally, after acquiring the object information of the target object, the method further includes: determining whether the object information is valid information, so as to avoid the phenomenon of maliciously modifying the data in the database. If so, execute the first operation statement for obtaining the target object to operate the database. In the embodiment of the present invention, after acquiring the object information of the target object, it is determined whether the acquired object information is valid information, which can effectively ensure data security. It can be understood that, if it is determined that the object information is not valid information, prompt information can be generated to prompt the target object to input valid information.
在本发明实施例中,确定对象信息是否为有效信息的方式有多种,在此不做具体限定,例如,可以解析对象信息,确定对象信息中的解析关键信息;获取目标对象的参考关键信息;将参考关键信息和解析关键信息进行比对,得到比对结果;基于比对结果,可以确定对象信息是否为有效信息。In the embodiment of the present invention, there are various ways to determine whether the object information is valid information, which is not specifically limited here. For example, the object information can be parsed, and the analysis key information in the object information can be determined; the reference key information of the target object can be obtained. ; Compare the reference key information with the analytical key information to obtain a comparison result; based on the comparison result, it can be determined whether the object information is valid information.
其中,解析关键信息可以是通过对对象信息进行解析后得到的信息。可选的,解析关键信息可以为目标对象的当前输入的当前对象名称。相应的,参考关键信息可以为目标对象的实际对象名称。对比结果可以用于确定对象信息是否为有效信息。如果比对结果为对比一致,则可以确定对象信息为有效信息;如果比对结果为对比不一致,则可以确定对象信息并非为有效信息。The analytical key information may be information obtained by parsing the object information. Optionally, the parsing key information may be the current object name of the current input of the target object. Correspondingly, the reference key information may be the actual object name of the target object. The comparison result can be used to determine whether the object information is valid information. If the comparison result is that the comparison is consistent, it can be determined that the object information is valid information; if the comparison result is that the comparison is inconsistent, it can be determined that the object information is not valid information.
可选地,获取目标对象对数据库进行操作的第一操作语句,包括:通过调用预先定义的数据库语句拦截器,获取目标对象对数据库进行操作的第一操作语句。Optionally, acquiring the first operation statement for the target object to operate the database includes: acquiring the first operation statement for the target object to operate the database by invoking a predefined database statement interceptor.
其中,数据库语句拦截器可以用于在预编译第一操作语句之前对第一操作语句进行拦截,以获取第一操作语句。The database statement interceptor may be configured to intercept the first operation statement before precompiling the first operation statement to obtain the first operation statement.
具体的,当检测到目标对象对数据库进行操作时,可以将预先定义的数据库语句拦截器加载至内存中。当数据库语句拦截器加载至内存后,可以调用所述数据库语句拦截器,以于内存中执行数据库语句拦截器。进而可以通过执行数据库语句拦截器,拦截目标对象对数据库进行操作的第一操作语句。从而可以获取第一操作语句。Specifically, when it is detected that the target object operates on the database, a predefined database statement interceptor can be loaded into the memory. After the database statement interceptor is loaded into the memory, the database statement interceptor can be called to execute the database statement interceptor in the memory. Furthermore, the first operation statement of the target object operating on the database can be intercepted by executing the database statement interceptor. Thereby, the first operation statement can be obtained.
示例性的,目标对象对数据库进行操作可以为springboot应用启动。数据库语句拦截器可以为mybatis拦截器。当springboot应用启动时,加载mybatis拦截器。Exemplarily, the operation of the database by the target object can be started for the springboot application. The database statement interceptor can be mybatis interceptor. When the springboot application starts, the mybatis interceptor is loaded.
可选地,通过调用预先定义的数据库语句拦截器,拦截目标对象对数据库进行操作的第一操作语句,包括:通过调用预先定义的数据库语句拦截器,拦截用于对数据库进行操作的数据库操作方法的入口参数;对入口参数进行解析,得到入口参数中包含的数据库操作语句。Optionally, by calling a predefined database statement interceptor, intercepting the first operation statement of the target object operating on the database, including: by calling the predefined database statement interceptor, intercepting the database operation method for operating the database. the entry parameter; parse the entry parameter to obtain the database operation statement contained in the entry parameter.
其中,数据库操作方法可以理解为用于对数据库进行操作的方法。数据库操作方法的入口参数可以理解为数据库操作方法的实际参数。数据库操作方法的实际参数中包括第一操作语句。The database operation method may be understood as a method for operating the database. The entry parameters of the database operation method can be understood as the actual parameters of the database operation method. The actual parameters of the database operation method include the first operation statement.
可选地,通过调用预先定义的数据库语句拦截器,拦截用于对数据库进行操作的数据库操作方法的入口参数,包括:通过调用预先定义的数据库拦截器,拦截用于对数据库进行操作的接口所封装的数据库操作方法的入口参数。其中,用于对数据库进行操作的接口可以为StatementHandler接口。数据库操作方法可以为prepare方法。Optionally, by calling a predefined database statement interceptor, intercepting the entry parameters of the database operation method used to operate the database, including: by calling the predefined database interceptor, intercepting all the interface used to operate the database. The entry parameter of the encapsulated database operation method. The interface for operating the database may be the StatementHandler interface. The database operation method can be the prepare method.
S120、确定第一操作语句中是否包含预设审计字段,若否,则基于预设审计字段、对象信息和第一操作语句,生成第二操作语句,并执行第二操作语句,以对数据库进行数据操作。S120. Determine whether a preset audit field is included in the first operation statement, and if not, generate a second operation statement based on the preset audit field, the object information and the first operation statement, and execute the second operation statement to perform an operation on the database. data manipulation.
其中,预设审计字段可以理解为记录数据库中数据的创建者字段(crterId)、创建时间字段(crteTime)、修改者字段(modierId)以及修改时间字段(modiTime),可以体现在数据库中的每一张数据表中。第二操作语句是基于预设审计字段、对象信息和第一操作语句生成的数据库操作语句。需要说明的是,在本发明实施例中,第一操作语句中所包含的预设审计字段的数量可以是一个、两个或两个以上。Among them, the preset audit field can be understood as the creator field (crterId), the creation time field (crteTime), the modifier field (modierId) and the modification time field (modiTime) of the data in the record database, which can be reflected in each field in the database. in the data sheet. The second operation statement is a database operation statement generated based on the preset audit field, the object information and the first operation statement. It should be noted that, in this embodiment of the present invention, the number of preset audit fields included in the first operation statement may be one, two, or more than two.
具体的,在得到第一操作语句后,可以对第一操作语句进行解析,进而可以得到第一操作语句中包含的全部字段。可以对全部字段进行分析。进而可以确定全部字段中是否包含预设审计字段,即,确定第一操作语句中是否包含预设审计字段。如果第一操作语句中未包含预设审计字段,则可以基于预设审计字段和对象信息重写第一操作语句。进而可以得到重写后的第一操作语句,并作为第二操作语句。在得到第二操作语句后,可以执行第二操作语句,从而可以基于第二操作语句对数据库中的数据进行操作。Specifically, after the first operation statement is obtained, the first operation statement can be parsed, and then all the fields included in the first operation statement can be obtained. All fields can be analyzed. Further, it can be determined whether all the fields contain a preset audit field, that is, whether the first operation statement contains a preset audit field. If the preset audit field is not included in the first operation statement, the first operation statement may be rewritten based on the preset audit field and the object information. Further, the rewritten first operation statement can be obtained and used as the second operation statement. After the second operation statement is obtained, the second operation statement can be executed, so that the data in the database can be operated based on the second operation statement.
可选地,基于预设审计字段、对象信息和第一操作语句,生成第二操作语句,包括:将预设审计字段添加至第一操作语句,以使第一操作语句包含预设审计字段。在添加完成后,可以基于对象信息为第一操作语句中的预设审计字段进行赋值处理,可实现预设审计字段的自动化赋值,从而达到无感知记录审计字段的信息。在赋值完成后,可以得到赋值完成的第一操作语句,并作为第二操作语句。Optionally, generating the second operation statement based on the preset audit field, the object information and the first operation statement includes: adding the preset audit field to the first operation statement, so that the first operation statement includes the preset audit field. After the addition is completed, assignment processing can be performed for the preset audit field in the first operation statement based on the object information, which can realize automatic assignment of the preset audit field, so as to record the information of the audit field without perception. After the assignment is completed, the first operation statement after the assignment is completed can be obtained and used as the second operation statement.
可选地,在确定第一操作语句中是否包含预设审计字段之前,还包括:确定第一操作语句的操作类型;如果操作类型为目标类型,则执行确定第一操作语句中是否包含预设审计字段。Optionally, before determining whether a preset audit field is included in the first operation statement, the method further includes: determining the operation type of the first operation statement; if the operation type is the target type, then executing determining whether the first operation statement includes a preset audit field. Audit fields.
其中,目标类型包括数据修改和/或数据写入。操作类型可以包括数据修改、数据写入、数据删除以及数据查询中的至少一个。Among them, the target type includes data modification and/or data writing. The operation type may include at least one of data modification, data write, data deletion, and data query.
具体的,可以提取第一操作语句中的操作关键字。其中,操作关键字可以包括中INSERT(增加)、DELETE(删除)、UPDATE(更改)以及SELECT(查询)的至少一种。进而可以基于操作关键字,确定与操作关键字对应的操作类型,即,确定与第一操作语句对应的操作类型。如果操作类型为数据修改和/或数据写入,则可以执行确定第一操作语句是否包含预设审计字段的操作。可以理解的是,如果第一操作语句的操作类型为数据删除和/或数据查询,则可以执行第一操作语句。Specifically, the operation keyword in the first operation statement can be extracted. The operation keyword may include at least one of INSERT (add), DELETE (delete), UPDATE (change) and SELECT (query). Further, based on the operation keyword, the operation type corresponding to the operation keyword may be determined, that is, the operation type corresponding to the first operation statement may be determined. If the operation type is data modification and/or data writing, an operation of determining whether the first operation statement contains a preset audit field may be performed. It can be understood that, if the operation type of the first operation statement is data deletion and/or data query, the first operation statement can be executed.
在上述实施例的基础上,还包括:如果第一操作语句中包含预设审计字段,则可以基于对象信息对预设审计字段进行赋值处理,可避免出现预设审计字段未赋值现象。在赋值完成后,可以得到赋值完成的第一操作语句,并执行赋值完成的第一操作语句,以对数据库进行操作。Based on the above embodiment, the method further includes: if the first operation statement includes a preset audit field, the preset audit field can be assigned based on the object information, which can avoid the phenomenon that the preset audit field is not assigned. After the assignment is completed, the first operation statement with the assignment completed can be obtained, and the first operation statement with the assignment completed can be executed to operate the database.
本发明实施例的技术方案,当目标对象对数据库进行操作时,通过获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句。进而可以确定所述第一操作语句中是否包含预设审计字段,若否,则可以基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。本发明实施例的技术方案,解决了现有操作数据库时需要手动赋值审计字段所存在的开发效率较低和开发成本较高的技术问题,实现了在对数据库进行操作时,自动记录审计字段所对应的数据,从而提升了开发效率,降低了开发成本。According to the technical solution of the embodiment of the present invention, when the target object operates on the database, the object information of the target object is obtained, and the first operation statement of the target object to operate the database is obtained. Further, it can be determined whether the first operation statement contains a preset audit field, and if not, a second operation statement can be generated based on the preset audit field, the object information and the first operation statement, and executed The second operation statement is used to perform data operation on the database. The technical solution of the embodiment of the present invention solves the technical problems of low development efficiency and high development cost that need to manually assign audit fields when operating the database, and realizes that when the database is operated, automatically record all the audit fields. Corresponding data, thereby improving development efficiency and reducing development costs.
实施例二Embodiment 2
图2为本发明实施例二提供的一种数据库操作装置的结构示意图。如图2所示,该装置包括:第一操作语句获取模块210和第一数据库操作模块220。FIG. 2 is a schematic structural diagram of a database operating apparatus according to Embodiment 2 of the present invention. As shown in FIG. 2 , the apparatus includes: a first operation
其中,第一操作语句获取模块210,用于当目标对象对数据库进行操作时,获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句;第一数据库操作模块220,用于确定所述第一操作语句中是否包含预设审计字段,若否,则基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。Wherein, the first operation
本发明实施例的技术方案,当目标对象对数据库进行操作时,通过第一操作语句获取模块,获取所述目标对象的对象信息,并获取所述目标对象对所述数据库进行操作的第一操作语句。进而可以通过第一数据库操作模块,确定所述第一操作语句中是否包含预设审计字段,若否,则可以基于所述预设审计字段、所述对象信息和所述第一操作语句,生成第二操作语句,并执行所述第二操作语句,以对所述数据库进行数据操作。本发明实施例的技术方案,解决了现有操作数据库时需要手动赋值审计字段所存在的开发效率较低和开发成本较高的技术问题,实现了在对数据库进行操作时,自动记录审计字段所对应的数据,从而提升了开发效率,降低了开发成本。According to the technical solution of the embodiment of the present invention, when the target object operates on the database, the first operation statement obtaining module obtains the object information of the target object, and obtains the first operation for the target object to operate the database. statement. Further, it can be determined by the first database operation module whether the first operation statement contains a preset audit field, and if not, it can be generated based on the preset audit field, the object information and the first operation statement. The second operation statement is executed, and the data operation is performed on the database. The technical solution of the embodiment of the present invention solves the technical problems of low development efficiency and high development cost that need to manually assign audit fields when operating the database, and realizes that when the database is operated, automatically record all the audit fields. Corresponding data, thereby improving development efficiency and reducing development costs.
可选的,第一数据库操作模块220,用于:Optionally, the first
将所述预设审计字段添加至所述第一操作语句;基于所述对象信息为所述第一操作语句中的预设审计字段进行赋值处理,得到赋值完成的第一操作语句,并作为第二操作语句。Add the preset audit field to the first operation statement; perform assignment processing for the preset audit field in the first operation statement based on the object information, obtain the first operation statement with the assignment completed, and use it as the first operation statement. Two operational statements.
可选的,在所述确定所述第一操作语句中是否包含预设审计字段之前,该装置还包括:Optionally, before the determining whether a preset audit field is included in the first operation statement, the device further includes:
操作类型确定模块,用于确定所述第一操作语句的操作类型;如果所述操作类型为目标类型,则执行所述确定所述第一操作语句中是否包含预设审计字段;其中,所述目标类型包括数据修改和/或数据写入。an operation type determination module, configured to determine the operation type of the first operation statement; if the operation type is a target type, execute the determining whether the first operation statement contains a preset audit field; wherein, the Target types include data modification and/or data writing.
可选的,该装置还包括:第二数据库操作模块,用于:Optionally, the device further includes: a second database operation module for:
如果所述第一操作语句中包含所述预设审计字段,则基于所述对象信息对所述预设审计字段进行赋值处理,得到赋值完成的第一操作语句,并执行所述赋值完成的第一操作语句,以对所述数据库进行操作。If the first operation statement includes the preset audit field, perform an assignment process on the preset audit field based on the object information, obtain a first operation statement whose assignment is completed, and execute the first operation statement whose assignment is completed. an operation statement to operate on the database.
可选的,第一操作语句获取模块210,用于:Optionally, the first operation
通过调用预先定义的数据库语句拦截器,获取所述目标对象对所述数据库进行操作的第一操作语句。By invoking a predefined database statement interceptor, the first operation statement for the target object to operate on the database is acquired.
可选的,第一操作语句获取模块210,具体用于:Optionally, the first operation
通过调用预先定义的数据库语句拦截器,拦截用于对数据库进行操作的数据库操作方法的入口参数;对所述入口参数进行解析,得到所述入口参数中包含的第一操作语句。By invoking a predefined database statement interceptor, the entry parameter of the database operation method used to operate the database is intercepted; the entry parameter is parsed to obtain the first operation statement contained in the entry parameter.
可选的,在所述获取所述目标对象的对象信息之后,该装置还包括:Optionally, after obtaining the object information of the target object, the device further includes:
对象信息判断模块,用于确定所述对象信息是否为有效信息,若是,则执行所述获取所述目标对象对所述数据库进行操作的第一操作语句。The object information judgment module is configured to determine whether the object information is valid information, and if so, execute the first operation statement for obtaining the target object and operating the database.
本发明实施例所提供的数据库操作装置可执行本发明任意实施例所提供的数据库操作方法,具备执行方法相应的功能模块和有益效果。The database operation apparatus provided by the embodiment of the present invention can execute the database operation method provided by any embodiment of the present invention, and has corresponding functional modules and beneficial effects of the execution method.
值得注意的是,上述数据库操作装置所包括的各个单元和模块只是按照功能逻辑进行划分的,但并不局限于上述的划分,只要能够实现相应的功能即可;另外,各功能单元的具体名称也只是为了便于相互区分,并不用于限制本发明实施例的保护范围。It is worth noting that the units and modules included in the above database operating device are only divided according to functional logic, but are not limited to the above division, as long as the corresponding functions can be realized; in addition, the specific names of the functional units It is only for the convenience of distinguishing from each other, and is not used to limit the protection scope of the embodiments of the present invention.
实施例三Embodiment 3
图3示出了可以用来实施本发明的实施例的电子设备10的结构示意图。电子设备旨在表示各种形式的数字计算机,诸如,膝上型计算机、台式计算机、工作台、个人数字助理、服务器、刀片式服务器、大型计算机、和其它适合的计算机。电子设备还可以表示各种形式的移动装置,诸如,个人数字处理、蜂窝电话、智能电话、可穿戴设备(如头盔、眼镜、手表等)和其它类似的计算装置。本文所示的部件、它们的连接和关系、以及它们的功能仅仅作为示例,并且不意在限制本文中描述的和/或者要求的本发明的实现。FIG. 3 shows a schematic structural diagram of an
如图3所示,电子设备10包括至少一个处理器11,以及与至少一个处理器11通信连接的存储器,如只读存储器(ROM)12、随机访问存储器(RAM)13等,其中,存储器存储有可被至少一个处理器执行的计算机程序,处理器11可以根据存储在只读存储器(ROM)12中的计算机程序或者从存储单元18加载到随机访问存储器(RAM)13中的计算机程序,来执行各种适当的动作和处理。在RAM 13中,还可存储电子设备10操作所需的各种程序和数据。处理器11、ROM 12以及RAM 13通过总线14彼此相连。输入/输出(I/O)接口15也连接至总线14。As shown in FIG. 3, the
电子设备10中的多个部件连接至I/O接口15,包括:输入单元16,例如键盘、鼠标等;输出单元17,例如各种类型的显示器、扬声器等;存储单元18,例如磁盘、光盘等;以及通信单元19,例如网卡、调制解调器、无线通信收发机等。通信单元19允许电子设备10通过诸如因特网的计算机网络和/或各种电信网络与其他设备交换信息/数据。Various components in the
处理器11可以是各种具有处理和计算能力的通用和/或专用处理组件。处理器11的一些示例包括但不限于中央处理单元(CPU)、图形处理单元(GPU)、各种专用的人工智能(AI)计算芯片、各种运行机器学习模型算法的处理器、数字信号处理器(DSP)、以及任何适当的处理器、控制器、微控制器等。处理器11执行上文所描述的各个方法和处理,例如数据库操作方法。The
在一些实施例中,数据库操作方法可被实现为计算机程序,其被有形地包含于计算机可读存储介质,例如存储单元18。在一些实施例中,计算机程序的部分或者全部可以经由ROM 12和/或通信单元19而被载入和/或安装到电子设备10上。当计算机程序加载到RAM13并由处理器11执行时,可以执行上文描述的数据库操作方法的一个或多个步骤。备选地,在其他实施例中,处理器11可以通过其他任何适当的方式(例如,借助于固件)而被配置为执行数据库操作方法。In some embodiments, the database operation method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as
本文中以上描述的系统和技术的各种实施方式可以在数字电子电路系统、集成电路系统、场可编程门阵列(FPGA)、专用集成电路(ASIC)、专用标准产品(ASSP)、芯片上系统的系统(SOC)、负载可编程逻辑设备(CPLD)、计算机硬件、固件、软件、和/或它们的组合中实现。这些各种实施方式可以包括:实施在一个或者多个计算机程序中,该一个或者多个计算机程序可在包括至少一个可编程处理器的可编程系统上执行和/或解释,该可编程处理器可以是专用或者通用可编程处理器,可以从存储系统、至少一个输入装置、和至少一个输出装置接收数据和指令,并且将数据和指令传输至该存储系统、该至少一个输入装置、和该至少一个输出装置。Various implementations of the systems and techniques described herein above may be implemented in digital electronic circuitry, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips system (SOC), load programmable logic device (CPLD), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include being implemented in one or more computer programs executable and/or interpretable on a programmable system including at least one programmable processor that The processor, which may be a special purpose or general-purpose programmable processor, may receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device an output device.
用于实施本发明的方法的计算机程序可以采用一个或多个编程语言的任何组合来编写。这些计算机程序可以提供给通用计算机、专用计算机或其他可编程数据处理装置的处理器,使得计算机程序当由处理器执行时使流程图和/或框图中所规定的功能/操作被实施。计算机程序可以完全在机器上执行、部分地在机器上执行,作为独立软件包部分地在机器上执行且部分地在远程机器上执行或完全在远程机器或服务器上执行。Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/operations specified in the flowcharts and/or block diagrams to be carried out. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.
在本发明的上下文中,计算机可读存储介质可以是有形的介质,其可以包含或存储以供指令执行系统、装置或设备使用或与指令执行系统、装置或设备结合地使用的计算机程序。计算机可读存储介质可以包括但不限于电子的、磁性的、光学的、电磁的、红外的、或半导体系统、装置或设备,或者上述内容的任何合适组合。备选地,计算机可读存储介质可以是机器可读信号介质。机器可读存储介质的更具体示例会包括基于一个或多个线的电气连接、便携式计算机盘、硬盘、随机存取存储器(RAM)、只读存储器(ROM)、可擦除可编程只读存储器(EPROM或快闪存储器)、光纤、便捷式紧凑盘只读存储器(CD-ROM)、光学储存设备、磁储存设备、或上述内容的任何合适组合。In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in connection with the instruction execution system, apparatus or device. Computer-readable storage media may include, but are not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices, or devices, or any suitable combination of the foregoing. Alternatively, the computer-readable storage medium may be a machine-readable signal medium. More specific examples of machine-readable storage media would include one or more wire-based electrical connections, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM or flash memory), fiber optics, compact disk read only memory (CD-ROM), optical storage, magnetic storage, or any suitable combination of the foregoing.
为了提供与用户的交互,可以在电子设备上实施此处描述的系统和技术,该电子设备具有:用于向用户显示信息的显示装置(例如,CRT(阴极射线管)或者LCD(液晶显示器)监视器);以及键盘和指向装置(例如,鼠标或者轨迹球),用户可以通过该键盘和该指向装置来将输入提供给电子设备。其它种类的装置还可以用于提供与用户的交互;例如,提供给用户的反馈可以是任何形式的传感反馈(例如,视觉反馈、听觉反馈、或者触觉反馈);并且可以用任何形式(包括声输入、语音输入或者、触觉输入)来接收来自用户的输入。To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having a display device (eg, a CRT (cathode ray tube) or an LCD (liquid crystal display)) for displaying information to the user monitor); and a keyboard and pointing device (eg, a mouse or trackball) through which a user can provide input to the electronic device. Other kinds of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (eg, visual feedback, auditory feedback, or tactile feedback); and can be in any form (including acoustic input, voice input, or tactile input) to receive input from the user.
可以将此处描述的系统和技术实施在包括后台部件的计算系统(例如,作为数据服务器)、或者包括中间件部件的计算系统(例如,应用服务器)、或者包括前端部件的计算系统(例如,具有图形用户界面或者网络浏览器的用户计算机,用户可以通过该图形用户界面或者该网络浏览器来与此处描述的系统和技术的实施方式交互)、或者包括这种后台部件、中间件部件、或者前端部件的任何组合的计算系统中。可以通过任何形式或者介质的数字数据通信(例如,通信网络)来将系统的部件相互连接。通信网络的示例包括:局域网(LAN)、广域网(WAN)、区块链网络和互联网。The systems and techniques described herein may be implemented on a computing system that includes back-end components (eg, as a data server), or a computing system that includes middleware components (eg, an application server), or a computing system that includes front-end components (eg, a user's computer having a graphical user interface or web browser through which a user may interact with implementations of the systems and techniques described herein), or including such backend components, middleware components, Or any combination of front-end components in a computing system. The components of the system may be interconnected by any form or medium of digital data communication (eg, a communication network). Examples of communication networks include: Local Area Networks (LANs), Wide Area Networks (WANs), blockchain networks, and the Internet.
计算系统可以包括客户端和服务器。客户端和服务器一般远离彼此并且通常通过通信网络进行交互。通过在相应的计算机上运行并且彼此具有客户端-服务器关系的计算机程序来产生客户端和服务器的关系。服务器可以是云服务器,又称为云计算服务器或云主机,是云计算服务体系中的一项主机产品,以解决了传统物理主机与VPS服务中,存在的管理难度大,业务扩展性弱的缺陷。A computing system can include clients and servers. Clients and servers are generally remote from each other and usually interact through a communication network. The relationship of client and server arises by computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also known as a cloud computing server or a cloud host. It is a host product in the cloud computing service system to solve the traditional physical host and VPS services, which are difficult to manage and weak in business scalability. defect.
应该理解,可以使用上面所示的各种形式的流程,重新排序、增加或删除步骤。例如,本发明中记载的各步骤可以并行地执行也可以顺序地执行也可以不同的次序执行,只要能够实现本发明的技术方案所期望的结果,本文在此不进行限制。It should be understood that steps may be reordered, added or deleted using the various forms of flow shown above. For example, the steps described in the present invention can be performed in parallel, sequentially or in different orders, and as long as the desired results of the technical solutions of the present invention can be achieved, no limitation is imposed herein.
上述具体实施方式,并不构成对本发明保护范围的限制。本领域技术人员应该明白的是,根据设计要求和其他因素,可以进行各种修改、组合、子组合和替代。任何在本发明的精神和原则之内所作的修改、等同替换和改进等,均应包含在本发明保护范围之内。The above-mentioned specific embodiments do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modifications, equivalent replacements and improvements made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202210719886.XA CN114996243A (en) | 2022-06-23 | 2022-06-23 | Database operation method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202210719886.XA CN114996243A (en) | 2022-06-23 | 2022-06-23 | Database operation method and device, electronic equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN114996243A true CN114996243A (en) | 2022-09-02 |
Family
ID=83037028
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202210719886.XA Pending CN114996243A (en) | 2022-06-23 | 2022-06-23 | Database operation method and device, electronic equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114996243A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115455029A (en) * | 2022-09-14 | 2022-12-09 | 协鑫电港云科技(海南)有限公司 | Battery swap data acquisition method, device, electronic device, and storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110270857A1 (en) * | 2010-04-30 | 2011-11-03 | International Business Machines Corporation | Method and System for Centralized Control of Database Applications |
CN109726217A (en) * | 2019-01-10 | 2019-05-07 | 北京字节跳动网络技术有限公司 | A kind of database operation method, device, equipment and storage medium |
CN111625552A (en) * | 2020-05-20 | 2020-09-04 | 北京百度网讯科技有限公司 | Data collection method, device, equipment and readable storage medium |
CN112988787A (en) * | 2021-05-17 | 2021-06-18 | 太平金融科技服务(上海)有限公司深圳分公司 | Database data processing method and device, computer equipment and storage medium |
CN114169309A (en) * | 2021-12-13 | 2022-03-11 | 平安养老保险股份有限公司 | Method and device for modifying behavior data table, computer equipment and storage medium |
-
2022
- 2022-06-23 CN CN202210719886.XA patent/CN114996243A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110270857A1 (en) * | 2010-04-30 | 2011-11-03 | International Business Machines Corporation | Method and System for Centralized Control of Database Applications |
CN109726217A (en) * | 2019-01-10 | 2019-05-07 | 北京字节跳动网络技术有限公司 | A kind of database operation method, device, equipment and storage medium |
CN111625552A (en) * | 2020-05-20 | 2020-09-04 | 北京百度网讯科技有限公司 | Data collection method, device, equipment and readable storage medium |
CN112988787A (en) * | 2021-05-17 | 2021-06-18 | 太平金融科技服务(上海)有限公司深圳分公司 | Database data processing method and device, computer equipment and storage medium |
CN114169309A (en) * | 2021-12-13 | 2022-03-11 | 平安养老保险股份有限公司 | Method and device for modifying behavior data table, computer equipment and storage medium |
Non-Patent Citations (1)
Title |
---|
杨剑等编: "Linux操作系统基础与应用", 30 November 2021, 北京理工大学出版社, pages: 161 - 162 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115455029A (en) * | 2022-09-14 | 2022-12-09 | 协鑫电港云科技(海南)有限公司 | Battery swap data acquisition method, device, electronic device, and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10013458B2 (en) | Detecting logical relationships based on structured query statements | |
CN112015468B (en) | Interface document processing method and device, electronic equipment and storage medium | |
US20240403344A1 (en) | Code retrieval method and apparatus based on large language model | |
CN112860811A (en) | Method and device for determining data blood relationship, electronic equipment and storage medium | |
CN112528067A (en) | Graph database storage method, graph database reading method, graph database storage device, graph database reading device and graph database reading equipment | |
CN118535601A (en) | A method, device, electronic device and storage medium for operating a database table | |
CN115905322A (en) | Service processing method and device, electronic equipment and storage medium | |
CN116644223A (en) | Data query method, device, equipment and readable medium | |
CN117149907A (en) | Data synchronization method, device, equipment and medium | |
CN114936246B (en) | A Redis data management method, device, equipment, storage medium and product | |
CN111159227A (en) | Data query method, device, equipment and storage medium | |
CN115328898A (en) | A data processing method, device, electronic device and medium | |
CN114996243A (en) | Database operation method and device, electronic equipment and storage medium | |
CN116401410B (en) | Method, device, storage medium and equipment for accessing map data to multi-scene graph database | |
CN117171165A (en) | A data logging method, device, electronic equipment and storage medium | |
CN114461502B (en) | Model monitoring method and device | |
CN115576977A (en) | Data paging query method, device, electronic equipment and storage medium | |
CN115454971A (en) | Data migration method and device, electronic equipment and storage medium | |
CN115329999A (en) | A method, device, platform and storage medium for processing operation and maintenance tasks | |
CN115167847A (en) | Application log acquisition method, device, equipment and storage medium | |
CN115017134A (en) | Database operation management method and device, electronic equipment and storage medium | |
CN114650222B (en) | Parameter configuration method, device, electronic equipment and storage medium | |
CN119311717A (en) | A data query method, device, equipment and storage medium based on dynamic script | |
CN117573677A (en) | Data updating method, device, equipment and medium based on transverse table database structure | |
CN116414833A (en) | A report data query method, device, equipment and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |