Contacts     ->      ICQ:    699 512 265,         E-Mail: CerebroSQL@gmail.com

  • YouTube Social  Icon

SQL Query Editor [SQLite]

This tool allows you to create and execute queries with a convenient user interface. The editor also includes tools for database cloning, backup, view the query plans, the history of commands and a variety of other functions allowing to make work with databases simple and fun

on the example of a database program "CerebroSQL" [CeraDB.db and ASH.db]

Create a new list

Connecting to database
1. Create permanent links:

To create a static connection, you must click on the button in the editor window "List saving connect"

In the window that opens, fill in the required fields:

  • Database path - full path to the database file

  • Attach - alias database

  • In cases where the encrypted database, install a check "passwd" and fill in the fields Mode and Passwd

  • Not oyazatelnye field:

  • Field Backup file - full path to the backup file, check "Passwd" and Passwd Field Mode and if it is necessary to encrypt

  • The field "Comment" - Comment (information)

Click the "Add" button


To connect using the saved settings

In the editor window, click "Attach database", in the window that opens, set the checks against relevant databases (allowed to choose any number of bases), press the "Apply" button

p.s .: cer_sqlite_list information is stored in the table, more in Database "Cerebro"

2. Connect to the database directly to the main program
By "Cerebro" database program can connect directly through the core of the program, using the "Connect core" button. In this connection there is no way to connect to multiple databases

3. Using SQL commands
Query Editor supports all standard SQLite, including the Attach command [Detach]

The object tree

Group "Objects" (drop down list)

The drop-down list contains the aliases all connected databases
In cases where the list is selected alias in the tree displays only the selected database objects, otherwise, displays objects of all databases

 

Branch "Attach"

Menu (attached database):

  • Sweep - An analog operation Vacuum

  • Backup - In cases, if you create an alias, were filled with a block "backup", via this menu, you can quickly perform a database backup operation by using the stored parameters

  • Show All SQL - code to display all the database objects

  • Detach - disable the selected database from the current sheet

Branch "TABLE"

List attached database tables
Each branch (table) contains child objects:

  • Columns (with types)

  • Index (with detailed information)

  • Triggers

Menu

Delete all rows - to delete all the rows in the selected table
Rename - to generate and add to the list editor command to change the name of the table
Drop - removal table
Source - form and add leaf table creation code editor
SQL [Select] - generate request code to the table showing all the field names
Example:
SELECT c_id,
c_st,
c_objst,
c_objd,
c_objc,
c_objt,
c_objn,
c_par,
c_source,
c_comment
FROM DB.CER_SOURCE

SQL [Insert] - generate code to insert commands in this table
Example:
insert into DB.CER_SOURCE (c_id, c_st, c_objst, c_objd, c_objc, c_objt, c_objn, c_par, c_source, c_comment)
values ​​()

Data - display the data table

Branch "INDEX"

The branch contains a list of database indexes with detailed information on each

Branch "VIEW"

The branch contains a list of ideas created in the database.
For each submission the disclosure of branches can view the list of speakers

Menu
Source - view presentation code
Data - display the data representation

Branch "TRIGGER"
The branch contains a list of database triggers

Branch "PARAMETER"
Connection settings/databases
In disclosing the branch has a feature:
1. Do not select the database in the list of attached databases
In the parameter list will display only the parameters characteristic of the compound

2. The base is selected from the list of attached databases
Displays information about all the information Pragma

Control buttons on the sheet

1. Create a static connections
2. Execute the query/script [sequence query]: F5 or F8
3. Commit operation (not used for SQLite)
4. Roll back the change (not used for SQLite)
5. Stop the current operation (interrupt script execution)
6. Close the open dataset
7. View the query plan: F4

8. Export data grid in one of the following formats:

  • XLS

  • TXT

  • CSV

  • HTML

  • RTF

9. Save the contents of the sheet to a file on disk
10. Open file

particular use

Working with windows

The drop-down list contains a set of directories stored for quick access to files stored in them
Button №1 -open the folder selection window

Button №2 - save the current directory in the drop-down list for future use (cer_directory table)

When you select a folder in the drop-down list box below the list of files loaded therein are stored

When single clicks on the file name in the text box, loaded in the box on the right

When you double-click on the file name of the text will be added to the current active list

Search for files containing the keyword
To search for files containing the keyword field is used "<enter the text for selection of file>", as well as a number of buttons:

  • To find

  • Clear condition

The button "Load" serves to replace the text of the current sheet content of the selected file
"Insert" button to add a text file in the current sheet
"Close" button to close the window "Open file"

11. Open the log program
12. Open the monitor program
13. Code Blocks

Creating code blocks
See "Edit database Cerebro"

14. Open the window log error/error description ORA family -...
See "Errors ORA -..... | program"
15. Managing aliases queries

To create a new alias for the query in the tree with the right to select an entry "New"
Fill in the fields:

  • Type database: SQLite

  • Alias: a unique alias for the query

  • Text: text query

  • Comment: Comment to a request/alias (optional)

In the future, to make the request, you can use his alias instead of writing the full text

16. Test button
17. Display Output window

Version 3.7 added the editor's hint, you can use to redirect the information returned by the query in the output window (hint works for the implementation of this ["transaction"], respectively, can be used in scripts).

18. Kloner databases
Designed to create copies of databases, individual objects or schema extraction

Tab [Parameter]
The field "New DB file path *" is used to specify the full path to the new database created in the process of cloning
The buttons (on the right):

  • Open a file selection dialog

  • Run the database script markup

Field "Mode *" - the choice of database encryption protocol
Golf "Passwd *" - password for the database created

The list of "Default DB *" - list of stored aliases stored compounds. Selects the source of the database which will be cloned
When you select a database in the list, the program connects to the selected database and loading the list of tables for cloning
Check "Full source" - to move all code regardless of the selected tables to transfer
Check "Data only" - to transfer only the data (tables are not created)
Check "Clear data" - before importing data to clear the destination table
Check "Check all" - select all the tables in the list to import tables

After clicking the "Create" button, a new database is created, the selected data (code) will be transferred to it, log the work is written on the tab [Log] this window

19. Storage of description (code) objects
The mechanism is designed for storing source codes, links and descriptions of objects