Check patentability & draft patents in minutes with Patsnap Eureka AI!

A sql statement parsing method based on fmdb

An analysis method and a technology of statements, which are applied in the field of FMDB-based SQL statement analysis, can solve problems such as unfavorable development work and errors, and achieve the effects of improving development efficiency, simplifying the amount of code written, and being easy to implement

Active Publication Date: 2021-07-13
BEIJING KUWO TECH
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If a batch of attribute names are changed, the workload is simply disastrous, which can easily lead to errors and is not conducive to the development work

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A sql statement parsing method based on fmdb

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0039] Such as figure 1 Shown, the SQL statement parsing method based on FMDB of the present invention, comprises the steps:

[0040] In the FM interface layer, create a UserDBManager class to manage the user database,

[0041] The UserDBManager class generates an object and calls the method: AllModel(), which internally calls the FMDB wrapper function:

[0042] Table function, used to specify table related information, said table refers to a table in the user database,

[0043] Operation function, used to specify information about the operation to be performed,

[0044] Additional functions for specifying additional conditional information,

[0045] After receiving and parsing the parameters corresponding to the above encapsulation functions, the UserDBManager class encapsulates the parsing results through the commit command, and then calls SQL to perfor...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present invention relates to an FMDB-based SQL statement parsing method, comprising the following steps: at the FM interface layer, creating a UserDBManager class for managing user databases, the UserDBManager class generates an object and calls the method: AllModel(), This method internally calls the FMDB encapsulation function: table function, used to specify table-related information, the table refers to the table in the user database, operation function, used to specify the operation-related information to be executed, additional function, used to specify additional condition information , when the parameters corresponding to the above encapsulation functions are received and parsed, the UserDBManager class encapsulates the parsing results through the commit command, and then calls SQL to perform corresponding operations. The invention is based on FMDB, has a clear structure, is easy to realize, simplifies the amount of coding of SQL statements, is beneficial to improve development efficiency, and reduces errors caused by repetitive labor in programming.

Description

technical field [0001] The invention relates to the technical field of SQLite API encapsulation, in particular to an FMDB-based SQL statement parsing method. Background technique [0002] The iOS SDK has supported SQLite for a long time. When using it, you only need to add the libsqlite3.dylib dependency and import the sqlite3.h header file. However, the native SQLite API is quite unfriendly in use, and it is very inconvenient to use. [0003] In addition, when using the SQLite database, it is inevitable to write a bunch of complex SQL statements. As follows (example only): [0004] / / Create table [0005] (1) CREATE TABLE IF NOT EXISTS BSUser (id integer (11) PRIMARY KEY, arrtext DEFAULT NULL, data text DEFAULT NULL, stu_id long DEFAULT NULL, name text DEFAULT NULL, image text DEFAULT NULL); [0006] (2) CREATE TABLE IF NOT EXISTS BSTeacher (id integer (11) PRIMARY KEY, name text DEFAULT NULL, depart text DEFAULT NULL); [0007] (3) CREATE TABLE IF NOT EXISTS BSStudent...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2453G06F16/242
CPCG06F16/24534G06F16/24539
Inventor 郭艳杰
Owner BEIJING KUWO TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com