SQLite visual management method

A management method and code technology, applied in the field of SQLite visual management, can solve problems such as hindering development, reducing development efficiency, and program generation problems, and achieving the effect of reducing maintenance costs, speeding up development progress, and improving productivity

CN101782910BInactive Publication Date: 2013-02-06盛冠商务咨询(上海)有限公司
3 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Publication Date
2013-02-06
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses a SQLite visual management method which comprises the steps of: after entering an operating database, inputting structured query language (SQL) codes by a user to generate an event for code hint, detecting a sentence of code of a word at a position of the current cursor; judging whether the word at the position of the current cursor has a context, if so, searching the context for finding a table name; if finding the table name, taking a field name in the table for prompting the user, if not, searching the context for finding another name, if finding the another name, searching a real name of the table corresponding to the another name in all input SQL sentences; and if finding the real name, taking the field name in the table for prompting the user. The SQLite visual management method can carry out the SQL sentence code prompting, thereby improving the development efficiency of SQLite.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to database development and management technology, in particular to a SQLite visual management method. Background technique

[0002] As an increasingly popular database, SQLite has never had a really easy-to-use visual development and management integration system. Therefore, for SQLite operations, you can only focus on the console, or use SQLite Database Browser (Browser for short, its official website is http: / / sqlitebrowser.sourceforge.net / ). Browser does not support the SQL statement code prompt function, database developers can only write SQL statements based on their familiarity with the database, or refer to related documents, especially for beginners, people often forget a command, or forget their own What objects are there in the database, and querying these things is undoubtedly a waste of time, reduces development efficiency, is very inconvenient, and will cause problems in the program due to developer input errors. ...

Examples

Embodiment Construction

[0033] One embodiment of the SQLite visual management method of the present invention is as follows: figure 1 As shown, the SQLite visual management tool software is started, and after entering the operation database, code prompts can be performed, and the code prompts include the following steps:

[0034] 1. Through the SQL statement operation, the user enters the SQL code;

[0035] 2. After the event for code prompting is generated, check the sentence of code at the word where the current cursor is located;

[0036] 3. Determine whether the word where the current cursor is located has a context. The context refers to the word before or after a word in a code, such as the code "select*from Table", then the word "from" above It is "select", and the following is "table"; if the word where the current cursor is located has no context, no code prompt will be performed; if the word where the current cursor is located has context, go to step 4;

[0037] 4. Search the context to d...