CN114385723A

CN114385723A - Data reading method and device, electronic equipment and storage medium

Info

Publication number: CN114385723A
Application number: CN202011138384.5A
Authority: CN
Inventors: 庾龙鑫
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2020-10-22
Filing date: 2020-10-22
Publication date: 2022-04-22

Abstract

The application discloses a data reading method and device, electronic equipment and a storage medium, and belongs to the technical field of computers. According to the method and the device, the mapping relation between the data table and the structural body of the target program is automatically constructed through the target table name corresponding to the data item to be read, and the data item to be read can be imported based on the mapping relation when the target program is operated, so that the target program does not need to be integrally modified when the query function logic is modified, the code expansibility of the target program is improved, the modification cost of a data reading process is greatly reduced, and the data reading efficiency is improved.

Description

Data reading method and device, electronic equipment and storage medium

Technical Field

The present disclosure relates to the field of computer technologies, and in particular, to a data reading method and apparatus, an electronic device, and a storage medium.

Background

As computer technology develops, technicians often need to call Data items stored in a database in program code (e.g., C + + code), and the Data items are usually accessed from the database by using a DAO (Data Access Object) tool.

For a generalized DAO tool, a mapping relationship between attributes of a structure in C + + and fields of a library table (a data table in an index database) needs to be established first, and at this time, a complex C + + code needs to be written by the DAO tool, and then, data items stored in corresponding fields in the library table are read based on the written C + + code.

In the above process, once the service needs to query other data items, when modifying the queried functional logic, the script program written by the DAO tool needs to be modified integrally, and then a C + + code is regenerated based on the modified script program again, resulting in poor extensibility of the C + + code, low data reading efficiency, and high modification cost.

Disclosure of Invention

The embodiment of the application provides a data reading method and device, an electronic device and a storage medium, which can simplify the complex data reading process and improve the data reading efficiency. The technical scheme is as follows:

in one aspect, a data reading method is provided, and the method includes:

acquiring a target table name of a data table where a data item to be read is located;

acquiring mapping information between the data table and a structural body of a target program based on the target table name;

establishing a mapping relation between the data table and the structural body based on the mapping information;

and importing the data item to be read into the target program based on the mapping relation.

In one aspect, there is provided a data reading apparatus, the apparatus including:

the first acquisition module is used for acquiring a target table name of a data table where a data item to be read is located;

the second acquisition module is used for acquiring mapping information between the data table and a structural body of the target program based on the target table name;

the establishing module is used for establishing a mapping relation between the data table and the structural body based on the mapping information;

and the importing module is used for importing the data item to be read into the target program based on the mapping relation.

In some embodiments, the mapping information comprises a source file of the structure body, a header file and a common header file, the source file defining a function for constructing at least one field map in the structure body, the header file specifying a data format of the structure body, and the common header file defining a global initialization function.

In some embodiments, the establishing module is to:

and when the target program is initialized, calling the global initialization function of the public header file to establish the mapping relation.

In some embodiments, the second obtaining module comprises:

an obtaining unit, configured to obtain at least one offset between at least one field of the structure and a head address of the structure;

a creating unit, configured to create a mapping table between the target table name and the at least one field based on the at least one offset;

a determining unit, configured to determine the mapping table as the mapping information.

In some embodiments, the creating unit is to:

for any field, creating a target triple based on the field name of the field, the field type of the field and the offset between the field and the first address;

and storing a key value pair formed by the key name and the key value into the mapping table by taking the target table name as the key name and the target triple as the key value.

In some embodiments, the import module is to:

acquiring the data item to be read from the data table according to the structured query statement;

determining a corresponding target storage position of the data item to be read in the structural body according to the mapping relation;

storing the data item to be read into the target storage location.

In some embodiments, the apparatus further comprises:

and the setting module is used for setting the field name of the first field of the structural body as the target table name when the structural body is created.

In one aspect, an electronic device is provided, which includes one or more processors and one or more memories, where at least one program code is stored in the one or more memories, and loaded by the one or more processors and executed to implement the data reading method according to any one of the above possible implementations.

In one aspect, a storage medium is provided, in which at least one program code is stored, the at least one program code being loaded and executed by a processor to implement the data reading method according to any one of the above possible implementations.

In one aspect, a computer program product or computer program is provided that includes one or more program codes stored in a computer readable storage medium. The one or more processors of the electronic device can read the one or more program codes from the computer-readable storage medium, and the one or more processors execute the one or more program codes, so that the electronic device can execute the data reading method of any one of the above-mentioned possible embodiments.

The beneficial effects brought by the technical scheme provided by the embodiment of the application at least comprise:

the mapping relation between the data table and the structural body of the target program is automatically constructed through the target table name corresponding to the data item to be read, and the data item to be read can be imported based on the mapping relation when the target program is operated, so that the target program is not required to be integrally modified when the query function logic is modified, the code expansibility of the target program is improved, the modification cost of the data reading process is greatly reduced, and the data reading efficiency is improved.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to be able to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic diagram of an implementation environment of a data reading method according to an embodiment of the present application;

fig. 2 is a flowchart of a data reading method provided in an embodiment of the present application;

fig. 3 is a flowchart of a data reading method provided in an embodiment of the present application;

fig. 4 is a schematic structural diagram of a data reading apparatus according to an embodiment of the present application;

fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed Description

To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

The terms "first," "second," and the like in this application are used for distinguishing between similar items and items that have substantially the same function or similar functionality, and it should be understood that "first," "second," and "nth" do not have any logical or temporal dependency or limitation on the number or order of execution.

The term "at least one" in this application means one or more, and the meaning of "a plurality" means two or more, for example, a plurality of first locations means two or more first locations.

Before introducing the embodiments of the present application, some basic concepts in the cloud technology field need to be introduced:

cloud Technology (Cloud Technology): the cloud computing business mode management system is a management technology for unifying series resources such as hardware, software, networks and the like in a wide area network or a local area network to realize data calculation, storage, processing and sharing, namely is a general name of a network technology, an information technology, an integration technology, a management platform technology, an application technology and the like applied based on a cloud computing business mode, can form a resource pool, is used as required, and is flexible and convenient. Cloud computing technology will become an important support in the field of cloud technology. Background services of the technical network system require a large amount of computing and storage resources, such as video websites, picture-like websites and more web portals. With the high development and application of the internet industry, each article may have its own identification mark and needs to be transmitted to a background system for logic processing, data in different levels are processed separately, and various industrial data need strong system background support and can be realized through cloud computing.

Cloud Storage (Cloud Storage): the distributed cloud storage system (hereinafter referred to as a storage system) refers to a storage system which integrates a large number of storage devices (storage devices are also referred to as storage nodes) of different types in a network through application software or application interfaces to cooperatively work through functions of cluster application, grid technology, distributed storage file systems and the like, and provides data storage and service access functions to the outside.

Database (Database): in short, it can be regarded as an electronic file cabinet, i.e. a place for storing electronic files, and the user can add, query, update, delete, etc. to the data in the files. A "database" is a collection of data that is stored together in a manner that can be shared by multiple users, has as little redundancy as possible, and is independent of the application.

Relational Database (Relational Database): refers to a database that uses a relational model to organize data, and stores data in rows and columns for a user to understand, and a series of rows and columns of a relational database are called tables (also called data tables and library tables), and a group of tables constitutes the database. A user retrieves data in a database by a query, which is an executable code that defines certain areas in the database. The relational model can be simply understood as a two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and relations between them. In short, the relational database is a database composed of a plurality of two-dimensional row-column tables that can be connected to each other, and currently, the mainstream relational databases include Oracle, DB2, Microsoft SQL Server, Microsoft Access, MySQL, and the like.

The embodiment of the present application relates to the above-mentioned relational database, in which a plurality of data tables are stored, each record (i.e. each row) in the data table is referred to as a tuple, each field (i.e. each column) in the data table is referred to as an attribute, a data item stored in each field is referred to as an attribute value, and a field name (i.e. a column name of each column) of each field is referred to as an attribute name.

Base Table (Data Table): the data table in the database is a unit for structuring and organizing data in the database, and multidimensional data under the same logic can be organized together through the database table.

Field (Field): a plurality of fields may be included in a library table, each field representing a single dimension of data in a library table, where a field corresponds to a column of data.

Structured Query Language (SQL): the standard computer language for relational database management and data manipulation, SQL is used to query, insert, update and modify data in a database.

Application Programming Interface (API): refers to a number of predefined functions that provide applications and developers the ability to access a set of routines based on certain software or hardware.

Data Access Object (DAO): and the data access interface provides the capability of abstracting access data from a storage platform (namely, a database).

Fig. 1 is a schematic diagram of an implementation environment of a data reading method according to an embodiment of the present application. Referring to fig. 1, the implementation environment includes a terminal 101 and a server 102, and the terminal 101 and the server 102 are both electronic devices.

The terminal 101 is used for running the target program, and technicians can automatically import the database query result set into the C + + structure by using a script tool when writing the C + + code of the target program, that is, automatically import of the data item to be read is realized.

The terminal 101 and the server 102 can be directly or indirectly connected by wired or wireless communication, and the present application is not limited thereto.

The server 102 is configured to provide a storage platform for the terminal 101, optionally, the server 102 is a stand-alone device, or the server 102 is an electronic device with a main-standby structure, or the server 102 is a cloud database, a distributed storage cluster, and the like, and in this embodiment, the type of the server 102 is not specifically limited. In some embodiments, the server 102 may be integrated on the same physical machine as the terminal 101.

Optionally, the server 102 is an independent physical server, or a server cluster or distributed system formed by a plurality of physical servers, or a cloud server providing basic cloud computing services such as cloud service, cloud database, cloud computing, cloud function, cloud storage, web service, cloud communication, middleware service, domain name service, security service, CDN (Content Delivery Network), big data and artificial intelligence platform.

Optionally, the terminal 101 generally refers to one of a plurality of terminals, and the device type of the terminal 101 includes: at least one of a smart phone, a tablet computer, an electronic book reader, an MP3(Moving Picture Experts Group Audio Layer III, motion Picture Experts compression standard Audio Layer 3) player, an MP4(Moving Picture Experts Group Audio Layer IV, motion Picture Experts compression standard Audio Layer 4) player, a laptop, a desktop, a smart speaker, or a smart watch. For example, the terminal 101 is a notebook computer, or other portable electronic device.

Those skilled in the art will appreciate that the number of terminals 101 described above may be greater or fewer. For example, the number of the terminals 101 may be only one, or the number of the terminals 101 may be several tens or hundreds, or more. The number and the device type of the terminals 101 are not limited in the embodiment of the present application.

Fig. 2 is a flowchart of a data reading method according to an embodiment of the present application. Referring to fig. 2, the embodiment is applied to an electronic apparatus, and includes:

201. the electronic equipment acquires the target table name of the data table where the data item to be read is located.

Optionally, the electronic device runs under a Linux or Windows platform, supports a compiler with a version of C + +98 or above, and may be an electronic device such as a desktop computer, a notebook computer, a tablet computer, and the like.

It should be noted that the electronic device and the server are in communication connection through a wired or wireless network, and the server can provide a data access interface based on a database, where a data table in which the data item to be read is stored in the database.

In some embodiments, the electronic device is installed with an object program, which is a Script program written based on a scripting language, for example, when the scripting language is Python, the Script program is a program running in a Python3.0 compiling environment, in other embodiments, the object program is an application program written based on another programming language, for example, the another programming language includes JS (JavaScript, a high-level programming language with function priority, interpreted type or just-in-time compiling type), VBS (Visual Basic Script, VB scripting language), and the like, or the another programming language includes C, C + +, C # and other computer program languages independent of a scripting tool, and the embodiment of the present application does not specifically limit the type of the object program.

In an example, the electronic device may use the target program by only referencing a deserialize _ helper.h header file and compiling a linked deserialize _ helper.cpp source file, and optionally, the target program runs in a Python3 compiling environment, an IP Address (Internet Protocol Address) and a communication port of a server providing the database are set in the target program, after a data connection is established between the target program and the server, the user may further provide the target program with a user name and a password required for accessing the server when the data connection is established, so as to facilitate authentication and verification by the server, and open corresponding data access rights to the target program after the verification is passed.

In some embodiments, the user inputs a target library name of a database where a data item to be read is located and a target table name of a data table located in the database to the target program, and optionally, the user inputs the target library name and the target table name to the target program based on a command line, in one example, the command line,/gen _ bo.

202. The electronic device acquires mapping information between the data table and the structure of the target program based on the target table name.

In some embodiments, the mapping information includes a source file of the structure, a header file for defining a function for building at least one field map in the structure, and a common header file for defining a global initialization function for aggregating the building functions defined in the source file.

It should be noted that, when the target program generates a plurality of structures for a plurality of data tables (i.e., library tables), although one data table corresponds to one structure, only one common header file is generated, that is, the structures of the plurality of data tables share the same common header file, so that the mapping relationships between all the data tables and all the structures can be completed by defining a global initialization function in the common header file.

In some embodiments, the electronic device may first obtain at least one offset between at least one field of the structure and a first address of the structure, then create a mapping table between the target table name and the at least one field based on the at least one offset, and finally determine the mapping table as the mapping information.

Optionally, the electronic device may obtain each offset corresponding to each field by calling a C + + macro function # define offset (type, number) (size _ t) & (((type) 0) - > number), in an example, taking a User table (User table) as an example, the User table includes at least the following fields: the user Identification (Identification, ID), the user Name (Name), the user gender (six), and the like, fields with different meanings can be set in different application scenarios, for example, a user balance field is added in a payment scenario, a user sub-number field is added in an examination scenario, and the like.

In some embodiments, for any field, the electronic device creates a target triple based on a field name of the any field, a field type of the any field, and an offset between the any field and the first address, and stores a key-value pair formed by the key name and the key value into the mapping table by taking the target table name as the key name and the target triple as the key value. It should be noted that the first address refers to a first address of the structure, that is, a memory address of a first field (i.e. an attribute) of the structure, in other words, since a storage unit in the memory is a byte, each byte has a respective sequence number called a memory address of each byte, a structure occupies a continuous storage space (corresponding to a series of continuous memory addresses) in the memory, and each field (i.e. each attribute) of the structure is sequentially arranged in the storage space during storage, so that the memory address of the first field is the same as the memory address of the entire structure.

In one example, the electronic device may construct a mapping table based on a Native map structure of C + +, that is, after acquiring, for each field, a target triple < field name, field type, address offset corresponding to an attribute >, the electronic device creates a mapping table of table names- < field names, field types, address offsets corresponding to attributes > based on the target triples, and stores the mapping table in the map structure, wherein the map structure is a data structure supported in a Native (Native) library of the electronic device, and stores data in a Key Value pair manner, and the mapping table is constructed based on the map structure, that is, a target table name (a character string) is used as a Key name (Key), and the target triple < field name, field type, address offset corresponding to an attribute > is used as a Key Value (Value), so that the target table name is stored in correspondence with the target of each field, to construct the mapping information.

In the above process, a single target table name may correspond to a plurality of field information (i.e., a target triple), the field name and the address offset of the structure attribute may be bound in each field information, and the storage addresses of all the attributes in the structure, that is, the storage addresses of all the fields in the structure, may be located by combining the attribute address offset and the structure pointer address transmitted when the API function is called, so as to facilitate the automatic construction of the mapping relationship between the data table and the structure.

203. The electronic equipment establishes a mapping relation between the data table and the structural body based on the mapping information.

In some embodiments, the electronic device may call the global initialization function of the common header file to establish the mapping relationship when initializing the target program. The mapping relationship refers to an association relationship between a data table in a remote database and a structure created in a local target program, for example, a plurality of User tables are stored and maintained in a cloud database, and a User table of a target User needs to be called by the local target program, the structure is created locally, and the structure is associated with the User table of the target User in the cloud database, that is, the mapping relationship between the structure and the User table of the target User is created, and only after the mapping relationship is created, it can be ensured that the target program can smoothly read each data item to be read stored in the cloud database. In one example, a target table name of the data table is set as a type name of the structure, and field names of respective fields in the data table are set as field names of respective fields of the structure, so that the data table and the structure correspond to each other.

Optionally, if the data items to be read are stored in a plurality of data tables respectively, at this time, the electronic device may obtain one piece of mapping information for each data table, and the mapping information of each data table is the same common header file, so that the mapping relationship is established for each data table only by calling the common header file once during initialization, and thus, the time for establishing the mapping relationship can be saved.

In some embodiments, the electronic device may also add a respective header file to the mapping information of each data table, and call a local initialization function in the respective header file in the initialization process, so as to establish a mapping relationship between each data table and the corresponding structure body.

204. And the electronic equipment imports the data item to be read into the target program based on the mapping relation.

In some embodiments, the electronic device may obtain the data item to be read from the data table according to a structured query statement (query SQL statement), determine a target storage location corresponding to the data item to be read in the structure according to the mapping relationship, and store the data item to be read in the target storage location. Optionally, the query SQL statement is directly embedded in the program code of the target program, so that the query SQL statement can be executed when the target program is run, and the data item to be read is imported, and optionally, the query SQL statement is input to the target program through a command line, so that the query SQL statement can be input in an external incoming manner, and the data item to be read is imported.

Alternatively, since the target program can parse the target table name from the query SQL statement of the user, but the pointer that is introduced when the API function is called is the null pointer type void, the table name corresponding to the structure body indicated by this pointer cannot be obtained through the void pointer. In view of this, when creating the structure, the electronic device may set the field name of the first field of the structure as the table name, that is, set the first attribute of the structure as the table name string corresponding to the structure.

In the above process, since the attribute memory distribution sequence of the C + + structure is the same as the attribute definition sequence, the attribute memory location of the table name string is placed at the head of the memory space of each structure, and the storage address of the attribute of the table name string is the same as the head address of the structure, so that the first string (i.e., the table name string) in the memory space of the structure can be directly read by the null pointer introduced when the API function is called, and the table name corresponding to the structure indicated by the pointer can be obtained. After the table name corresponding to the structure is obtained, if the table name is consistent with the target table name specified by the query SQL statement, the structure is used as a subsequent data structure for storing the data item to be read.

Then, the electronic device obtains the data items to be read indicated by the query SQL statement from the server according to the query SQL statement, and the data items to be read can form a query result set (referred to as a query result set for short), and the sequence of the query result values in the query result set is consistent with the sequence of the field names specified in the query SQL statement, so that the field names and the field name sequences to be obtained are obtained by analyzing the query SQL statement, and the query result values in the query result set can be filled into the corresponding attributes of the structure according to the mapping relationship between the field names and the attribute addresses in the mapping table (i.e. mapping information) in sequence, so that when importing the data items into the structure of the target program, automatic import can be achieved, no extra manual labor is required by a user, and development cost is greatly saved.

In some embodiments, because the query result values (i.e., the data items to be read) in the query result set are all stored in a string type, the electronic device may further convert the data items to be read into actual attribute types indicated by the field types according to a mapping relationship from a field to a field type in the mapping table (the target triple stores not only the field but also the field type), so as to achieve a more intelligent and accurate data importing effect.

According to the method provided by the embodiment of the application, the mapping relation between the data table and the structural body of the target program is automatically constructed through the target table name corresponding to the data item to be read, and the data item to be read can be imported based on the mapping relation when the target program is operated, so that the target program is not required to be integrally modified when the query function logic is modified, the code expansibility of the target program is improved, the modification cost of a data reading process is greatly reduced, and the data reading efficiency is improved.

Furthermore, because the mapping relation can be automatically constructed only by using the target table name, the construction of the mapping relation can be finished without specifying the related information of a complex table, and in addition, data reading can be carried out without introducing additional parameters when the target program is operated, so that the complicated data reading process is greatly simplified, the mutual inspection of program codes of other parties among technicians is facilitated under the multi-person cooperation scene, and the understanding cost of the program codes of the target program is reduced.

All the above optional technical solutions can be combined arbitrarily to form the optional embodiments of the present disclosure, and are not described herein again.

Fig. 3 is a flowchart of a data reading method according to an embodiment of the present application, please refer to fig. 3, the method is applied to an electronic device, and the method includes the following steps:

301. the electronic equipment acquires the target table name of the data table where the data item to be read is located.

Step 301 is similar to step 201 and will not be described herein.

302. The electronic device obtains at least one offset between at least one field of a structure of the target program and a head address of the structure.

Alternatively, the electronic device may obtain the offsets corresponding to the fields by calling a C + + macro function # define offset (type, member) (size _ t) & (((type) 0) - > member).

In some embodiments, the electronic device may also call another macro function to obtain the above offsets, and the embodiments of the present application do not specifically limit the manner of obtaining the offsets.

303. The electronic device creates a mapping table between the target table name and the at least one field based on the at least one offset.

In some embodiments, for any field, the electronic device creates a target triple based on a field name of the any field, a field type of the any field, and an offset between the any field and the first address, and stores a key-value pair formed by the key name and the key value into the mapping table by taking the target table name as the key name and the target triple as the key value.

In one example, the electronic device may build a mapping table based on a native map structure of C + +, that is, after the electronic device obtains a target triple < field name, field type, address offset of corresponding attribute > for each field, create a mapping table of table name- < field name, field type, address offset of corresponding attribute > based on these target triples, and store the mapping table in a map structure.

304. The electronic device determines the mapping table as mapping information between the data table and the structural body of the target program.

In step 302-. In some embodiments, in addition to storing the mapping table in a map structure, the mapping table may also be stored in other data structures such as a hash table, a bitmap, an array, and the like, so as to construct mapping information having different data structures, and the data structure of the mapping information is not specifically limited in this embodiment of the application.

Optionally, the mapping information includes a source file, a header file and a common header file of the structure body, the source file is used for defining a function for constructing at least one field mapping in the structure body, the header file is used for declaring a data format of the structure body, and the common header file is used for defining a global initialization function.

In some embodiments, the electronic device stores the mapping table into a source file of the structure, so as to define the function for constructing the mapping relationship of each field based on the mapping table.

305. The electronic equipment establishes a mapping relation between the data table and the structural body based on the mapping information.

In some embodiments, the electronic device may call the global initialization function of the common header file to establish the mapping relationship when initializing the target program.

306. And the electronic equipment acquires the data item to be read from the data table according to the structured query statement.

In the above process, the electronic device obtains the data items to be read indicated by the query SQL statement from the server according to the query SQL statement, and the data items to be read may form a query result set (referred to as a query result set for short).

307. And the electronic equipment determines the corresponding target storage position of the data item to be read in the structural body according to the mapping relation.

In the above process, the electronic device obtains the field names and the field name sequences to be obtained by parsing and querying the SQL semantics, and can determine the attribute addresses (i.e., target storage locations) of the attributes in the structure according to the mapping relationship from the field names to the attribute addresses in the mapping table (i.e., mapping information).

308. The electronic device stores the data item to be read into the target storage location.

In the process, because the sequence of the query result values in the query result set is consistent with the sequence of the field names specified in the query SQL semantic, the field names and the field name sequence to be acquired are obtained by analyzing the query SQL semantic, and the query result values in the query result set can be filled into the corresponding attributes of the structure according to the mapping relation between the field names and the attribute addresses in the mapping table (namely mapping information).

It should be noted that, although the target program can parse the target table name from the query SQL statement of the user, the pointer that is introduced when the API function is called is the null pointer type void, and the table name corresponding to the structure body indicated by the pointer cannot be obtained through the void pointer. In view of this, when creating the structure, the electronic device may set the field name of the first field of the structure as the table name (i.e., the target table name), that is, set the first attribute of the structure as the table name string corresponding to the structure.

In

step

306 and 308, the electronic device imports the data item to be read into the target program based on the mapping relationship. In some embodiments, the electronic device may also import the data item to be read through another DAO scripting tool, and the manner of importing the data item to be read is not specifically limited in this application embodiment.

In the above process, for any query SQL statement input by the user, after the server returns a query result set based on the query SQL statement, the server can automatically import each data item to be read (corresponding to a query result value) into the C + + structure based on the query result set, and automatically construct a logical mapping relationship between a data table field and an offset through a target program (e.g., a scripting tool), where the offset is an offset between a structure attribute and a first address of the structure, and by this logical mapping relationship, the problem that a specific attribute cannot be located through an attribute name or a field name when the C + + is not running can be solved, and by parsing the query SQL statement, each data item to be read in the query result set can be filled into a corresponding attribute of the structure, so that not only a full-volume query scenario can be supported, but also a flexible non-full-volume query scenario can be supported, and greatly facilitates code review work.

In addition, no additional input parameter is needed after the SQL code is queried, the mapping relation can be automatically constructed by means of a target program, the use is convenient, the introduced parameter is simple, the mapping relation is deeply decoupled from the database query, no third-party library file is relied on, a user can conveniently customize a personalized query scheme by querying the SQL statement, for example, error alarm, log record and the like are added, and the method has higher flexibility, applicability and portability.

In some exemplary scenarios, when a structure of the data table changes due to a requirement change, for example, a field is added or deleted in the data table, the target program only needs to be called to regenerate a structure definition related file corresponding to the data table once, and in addition, other code logics do not need to be modified at all, and the target program can automatically judge a construction condition under a currently corresponding item folder, so that the logic needing to be modified is adaptively changed (for example, mapping information of a certain attribute is added or deleted in a mapping table), so that a structure header file and a source file are regenerated and replaced, and a common header file is adaptively modified, so that incremental change is very convenient.

Fig. 4 is a schematic structural diagram of a data reading apparatus according to an embodiment of the present application, please refer to fig. 4, where the apparatus includes:

a first obtaining module 401, configured to obtain a target table name of a data table where a data item to be read is located;

a second obtaining module 402, configured to obtain mapping information between the data table and a structure of the target program based on the target table name;

an establishing module 403, configured to establish a mapping relationship between the data table and the structure based on the mapping information;

and an importing module 404, configured to import the data item to be read into the target program based on the mapping relationship.

According to the device provided by the embodiment of the application, the mapping relation between the data table and the structural body of the target program is automatically constructed through the target table name corresponding to the data item to be read, and the data item to be read can be imported based on the mapping relation when the target program is operated, so that the target program is not required to be integrally modified when the query function logic is modified, the code expansibility of the target program is improved, the modification cost of a data reading process is greatly reduced, and the data reading efficiency is improved.

In some embodiments, the mapping information includes a source file of the structure body defining a function for constructing at least one field map in the structure body, a header file for declaring a data format of the structure body, and a common header file for defining a global initialization function.

In some embodiments, the establishing module 403 is configured to:

when the target program is initialized, the global initialization function of the public header file is called to establish the mapping relation.

In some embodiments, based on the apparatus components of fig. 4, the second obtaining module 402 includes:

a creating unit configured to create a mapping table between the target table name and the at least one field based on the at least one offset;

In some embodiments, the creating unit is to:

In some embodiments, the import module 404 is configured to:

determining a target storage position corresponding to the data item to be read in the structural body according to the mapping relation;

and storing the data item to be read into the target storage position.

In some embodiments, based on the apparatus composition of fig. 4, the apparatus further comprises:

It should be noted that: in the data reading apparatus provided in the above embodiment, when reading data, only the division of the functional modules is exemplified, and in practical applications, the functions can be distributed by different functional modules as needed, that is, the internal structure of the electronic device is divided into different functional modules to complete all or part of the functions described above. In addition, the data reading apparatus and the data reading method provided by the above embodiments belong to the same concept, and specific implementation processes thereof are detailed in the data reading method embodiments and are not described herein again.

Fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application. In this embodiment, an electronic device is taken as an example of the terminal 500, and the device types of the terminal 500 include: a smart phone, a tablet computer, an MP3 player (Moving Picture Experts Group Audio Layer III, motion video Experts compression standard Audio Layer 3), an MP4 player (Moving Picture Experts Group Audio Layer IV, motion video Experts compression standard Audio Layer 4), a notebook computer, or a desktop computer. Terminal 500 may also be referred to by other names such as user equipment, portable terminal, laptop terminal, desktop terminal, and the like.

In general, the terminal 500 includes: a processor 501 and a memory 502.

Optionally, processor 501 includes one or more processing cores, such as a 4-core processor, an 8-core processor, and so forth. Alternatively, the processor 501 is implemented in at least one hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). In some embodiments, processor 501 includes a main processor and a coprocessor, the main processor is a processor for Processing data in the wake state, also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 501 is integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content that the display screen needs to display. In some embodiments, processor 501 further includes an AI (Artificial Intelligence) processor for processing computational operations related to machine learning.

In some embodiments, memory 502 includes one or more computer-readable storage media, which are optionally non-transitory. Optionally, memory 502 also includes high speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in the memory 502 is used to store at least one program code for execution by the processor 501 to implement the data reading methods provided by the various embodiments herein.

In some embodiments, the terminal 500 may further optionally include: a peripheral interface 503 and at least one peripheral. The processor 501, memory 502 and peripheral interface 503 can be connected by bus or signal lines. Each peripheral can be connected to the peripheral interface 503 via a bus, signal line, or circuit board. Specifically, the peripheral device includes: at least one of radio frequency circuitry 504, display screen 505, camera assembly 506, audio circuitry 507, positioning assembly 508, and power supply 509.

The peripheral interface 503 may be used to connect at least one peripheral related to I/O (Input/Output) to the processor 501 and the memory 502. In some embodiments, the processor 501, memory 502, and peripheral interface 503 are integrated on the same chip or circuit board; in some other embodiments, any one or both of the processor 501, the memory 502, and the peripheral interface 503 are implemented on a separate chip or circuit board, which is not limited in this embodiment.

The Radio Frequency circuit 504 is used for receiving and transmitting RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuitry 504 communicates with communication networks and other communication devices via electromagnetic signals. The rf circuit 504 converts an electrical signal into an electromagnetic signal to transmit, or converts a received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuit 504 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and so forth. Optionally, the radio frequency circuitry 504 communicates with other terminals via at least one wireless communication protocol. The wireless communication protocols include, but are not limited to: metropolitan area networks, various generation mobile communication networks (2G, 3G, 4G, and 5G), Wireless local area networks, and/or WiFi (Wireless Fidelity) networks. In some embodiments, the rf circuit 504 further includes NFC (Near Field Communication) related circuits, which are not limited in this application.

The display screen 505 is used to display a UI (User Interface). Optionally, the UI includes graphics, text, icons, video, and any combination thereof. When the display screen 505 is a touch display screen, the display screen 505 also has the ability to capture touch signals on or over the surface of the display screen 505. The touch signal can be input to the processor 501 as a control signal for processing. Optionally, the display screen 505 is also used to provide virtual buttons and/or a virtual keyboard, also referred to as soft buttons and/or a soft keyboard. In some embodiments, the display screen 505 is one, providing the front panel of the terminal 500; in other embodiments, the display screens 505 are at least two, respectively disposed on different surfaces of the terminal 500 or in a folded design; in still other embodiments, the display 505 is a flexible display disposed on a curved surface or a folded surface of the terminal 500. Even more optionally, the display screen 505 is arranged in a non-rectangular irregular figure, i.e. a shaped screen. Alternatively, the Display screen 505 is made of LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode), or the like.

The camera assembly 506 is used to capture images or video. Optionally, camera assembly 506 includes a front camera and a rear camera. Generally, a front camera is disposed at a front panel of the terminal, and a rear camera is disposed at a rear surface of the terminal. In some embodiments, the number of the rear cameras is at least two, and each rear camera is any one of a main camera, a depth-of-field camera, a wide-angle camera and a telephoto camera, so that the main camera and the depth-of-field camera are fused to realize a background blurring function, and the main camera and the wide-angle camera are fused to realize panoramic shooting and VR (Virtual Reality) shooting functions or other fusion shooting functions. In some embodiments, camera assembly 506 also includes a flash. Optionally, the flash is a monochrome temperature flash, or a bi-color temperature flash. The double-color-temperature flash lamp is a combination of a warm-light flash lamp and a cold-light flash lamp and is used for light compensation under different color temperatures.

In some embodiments, audio circuitry 507 includes a microphone and a speaker. The microphone is used for collecting sound waves of a user and the environment, converting the sound waves into electric signals, and inputting the electric signals to the processor 501 for processing, or inputting the electric signals to the radio frequency circuit 504 to realize voice communication. For the purpose of stereo sound collection or noise reduction, a plurality of microphones are respectively disposed at different positions of the terminal 500. Optionally, the microphone is an array microphone or an omni-directional pick-up microphone. The speaker is used to convert electrical signals from the processor 501 or the radio frequency circuit 504 into sound waves. Alternatively, the speaker is a conventional membrane speaker, or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, not only the electric signal can be converted into a sound wave audible to human, but also the electric signal can be converted into a sound wave inaudible to human for use in distance measurement or the like. In some embodiments, audio circuitry 507 also includes a headphone jack.

The positioning component 508 is used for positioning the current geographic Location of the terminal 500 for navigation or LBS (Location Based Service). Alternatively, the Positioning component 508 is a Positioning component based on a GPS (Global Positioning System) in the united states, a beidou System in china, a graves System in russia, or a galileo System in the european union.

Power supply 509 is used to power the various components in terminal 500. Optionally, power source 509 is alternating current, direct current, disposable or rechargeable. When power source 509 comprises a rechargeable battery, the rechargeable battery supports wired or wireless charging. The rechargeable battery is also used to support fast charge technology.

In some embodiments, terminal 500 also includes one or more sensors 510. The one or more sensors 510 include, but are not limited to: acceleration sensor 511, gyro sensor 512, pressure sensor 513, fingerprint sensor 514, optical sensor 515, and proximity sensor 516.

In some embodiments, the acceleration sensor 511 detects the magnitude of acceleration on three coordinate axes of the coordinate system established with the terminal 500. For example, the acceleration sensor 511 is used to detect the components of the gravitational acceleration in three coordinate axes. Optionally, the processor 501 controls the display screen 505 to display the user interface in a landscape view or a portrait view according to the gravitational acceleration signal collected by the acceleration sensor 511. The acceleration sensor 511 is also used for acquisition of motion data of a game or a user.

In some embodiments, the gyro sensor 512 detects the body direction and the rotation angle of the terminal 500, and the gyro sensor 512 and the acceleration sensor 511 cooperate to acquire the 3D motion of the user on the terminal 500. The processor 501 implements the following functions according to the data collected by the gyro sensor 512: motion sensing (such as changing the UI according to a user's tilting operation), image stabilization at the time of photographing, game control, and inertial navigation.

Optionally, the pressure sensor 513 is disposed on a side frame of the terminal 500 and/or under the display screen 505. When the pressure sensor 513 is disposed on the side frame of the terminal 500, the user's holding signal of the terminal 500 can be detected, and the processor 501 performs left-right hand recognition or shortcut operation according to the holding signal collected by the pressure sensor 513. When the pressure sensor 513 is disposed at the lower layer of the display screen 505, the processor 501 controls the operability control on the UI interface according to the pressure operation of the user on the display screen 505. The operability control comprises at least one of a button control, a scroll bar control, an icon control and a menu control.

The fingerprint sensor 514 is used for collecting a fingerprint of the user, and the processor 501 identifies the identity of the user according to the fingerprint collected by the fingerprint sensor 514, or the fingerprint sensor 514 identifies the identity of the user according to the collected fingerprint. Upon recognizing that the user's identity is a trusted identity, the processor 501 authorizes the user to perform relevant sensitive operations including unlocking the screen, viewing encrypted information, downloading software, paying, and changing settings, etc. Optionally, the fingerprint sensor 514 is provided on the front, back or side of the terminal 500. When a physical button or a vendor Logo is provided on the terminal 500, the fingerprint sensor 514 can be integrated with the physical button or the vendor Logo.

The optical sensor 515 is used to collect the ambient light intensity. In one embodiment, processor 501 controls the display brightness of display screen 505 based on the ambient light intensity collected by optical sensor 515. Specifically, when the ambient light intensity is high, the display brightness of the display screen 505 is increased; when the ambient light intensity is low, the display brightness of the display screen 505 is reduced. In another embodiment, processor 501 also dynamically adjusts the shooting parameters of camera head assembly 506 based on the ambient light intensity collected by optical sensor 515.

A proximity sensor 516, also referred to as a distance sensor, is typically disposed on the front panel of the terminal 500. The proximity sensor 516 is used to collect the distance between the user and the front surface of the terminal 500. In one embodiment, when the proximity sensor 516 detects that the distance between the user and the front surface of the terminal 500 gradually decreases, the processor 501 controls the display screen 505 to switch from the bright screen state to the dark screen state; when the proximity sensor 516 detects that the distance between the user and the front surface of the terminal 500 becomes gradually larger, the display screen 505 is controlled by the processor 501 to switch from the breath screen state to the bright screen state.

Those skilled in the art will appreciate that the configuration shown in fig. 5 is not intended to be limiting and can include more or fewer components than those shown, or some components may be combined, or a different arrangement of components may be used.

In an exemplary embodiment, a computer readable storage medium, such as a memory including at least one program code, which is executable by a processor in an electronic device to perform the data reading method in the above embodiments, is also provided. For example, the computer-readable storage medium includes a ROM (Read-Only Memory), a RAM (Random-Access Memory), a CD-ROM (Compact Disc Read-Only Memory), a magnetic tape, a floppy disk, an optical data storage device, and the like.

In an exemplary embodiment, a computer program product or computer program is also provided, comprising one or more program codes, the one or more program codes being stored in a computer readable storage medium. One or more processors of the electronic device can read the one or more program codes from the computer-readable storage medium, and the one or more processors execute the one or more program codes, so that the electronic device can execute to complete the data reading method in the above-described embodiments.

Those skilled in the art will appreciate that all or part of the steps for implementing the above embodiments can be implemented by hardware, or can be implemented by a program instructing relevant hardware, and optionally, the program is stored in a computer readable storage medium, and optionally, the above mentioned storage medium is a read-only memory, a magnetic disk or an optical disk, etc.

The above description is only exemplary of the present application and should not be taken as limiting, as any modification, equivalent replacement, or improvement made within the spirit and principle of the present application should be included in the protection scope of the present application.

Claims

1. A method of reading data, the method comprising:

2. The method of claim 1, wherein the mapping information comprises a source file, a header file and a common header file of the structure, wherein the source file is used for defining a function for constructing at least one field mapping in the structure, the header file is used for declaring a data format of the structure, and the common header file is used for defining a global initialization function.

3. The method of claim 2, wherein the establishing a mapping relationship between the data table and the structure based on the mapping information comprises:

4. The method of claim 1, wherein obtaining mapping information between the data table and a structure of a target program based on the target table name comprises:

acquiring at least one offset between at least one field of the structure body and a head address of the structure body;

creating a mapping table between the target table name and the at least one field based on the at least one offset;

determining the mapping table as the mapping information.

5. The method of claim 4, wherein creating the mapping table between the target table name and the at least one field based on the at least one offset comprises:

6. The method according to claim 1, wherein the importing the data item to be read into the target program based on the mapping relationship comprises:

storing the data item to be read into the target storage location.

7. The method of claim 1, further comprising:

and when the structure body is created, setting the field name of the first field of the structure body as the target table name.

8. A data reading apparatus, characterized in that the apparatus comprises:

9. An electronic device, comprising one or more processors and one or more memories having at least one program code stored therein, the at least one program code being loaded and executed by the one or more processors to implement the data reading method of any one of claims 1 to 7.

10. A storage medium having stored therein at least one program code, which is loaded and executed by a processor to implement the data reading method according to any one of claims 1 to 7.