command /database for CRUD and SQL #171

phodal · 2024-12-27T15:19:41Z

Describe the solution you'd like

For example

/database:table
```
autodev-index.sqlite
```

/database:column
```
chunks
```

/database:query
```sql
"select * from table
```

The text was updated successfully, but these errors were encountered:

Added `executeSqlQuery` method in `DatabaseSchemaAssistant` to execute SQL queries. Introduced `Execute` enum value in `DatabaseFunctionProvider` to handle SQL query requests. This extends the database tool's functionality to directly execute SQL statements.

…ndling #171 - Replace verbose script model creation with a concise null-coalescing operator. - Add logic to handle null console cases by creating and running query runners.

Improved console retrieval logic by adding fallback to create a new console if none is active. Also streamlined query execution flow by ensuring console is properly initialized before use.

Replace direct query execution with message bus-based processing for better extensibility. Added support for handling grid data requests and consumer callbacks. Removed unused file editor retrieval code.

Move `CompletableFuture` creation outside the thread execution block and adjust result completion logic to check row size instead of waiting for the last row. Added a TODO for further improvement.

- Split single import statement for `com.intellij.database.datagrid.*` into individual imports. - Remove commented-out code related to `CompletableFuture` and `ApplicationManager`. - Change `DGDepartment.DATA_IMPORT` to `DGDepartment.DATA_EXPORT` for clarity.

- Simplify `getDataSources` method to use single-expression syntax. - Rename `getAllRawDatasource` to `allRawDatasource` for consistency. - Remove unused `Disposer` import. - Fix minor formatting issues

Refactored the database runner execution logic to use `invokeAndWait` and `runSingleRunner` for better error handling and code clarity. Removed redundant code and improved the flow of database session management.

Extracted SQL execution logic into separate functions (`executeSqlInConsole` and `executeSql`) for better readability and maintainability. Removed unused imports and redundant code. Simplified the flow of SQL execution and error handling.

Include DATABASE command in the list of commands that trigger code block checks. Additionally, wrap database runner retrieval in a read action to ensure

Ensure thread safety by using `runReadAction` for PSI file retrieval. Added error handling for cases where the PSI file is not found, returning a descriptive error message instead of throwing an exception.

phodal added a commit to shire-lang/shire-demo that referenced this issue Dec 30, 2024

feat(database): 添加 autodev-index.sqlite 查询示例 phodal/shire#171

b08ca34

phodal added a commit that referenced this issue Dec 31, 2024

feat(parser): add DATABASE command to code block checks #171

8339428

Include DATABASE command in the list of commands that trigger code block checks. Additionally, wrap database runner retrieval in a read action to ensure

phodal closed this as completed in 8d7684c Dec 31, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

command /database for CRUD and SQL #171

command /database for CRUD and SQL #171

phodal commented Dec 27, 2024 •

edited

Loading

command /database for CRUD and SQL #171

command /database for CRUD and SQL #171

Comments

phodal commented Dec 27, 2024 • edited Loading

phodal commented Dec 27, 2024 •

edited

Loading