# CEDARScript Integration: Aider
[](https://pypi.org/project/cedarscript-integration-aider/)
[](https://pypi.org/project/cedarscript-integration-aider/)
[](https://github.com/psf/black)
[](https://www.gnu.org/licenses/agpl-3.0)
`CEDARScript Integration: Aider` enables [`Aider`](https://aider.chat/) to use
[**CEDARScript**](https://github.com/CEDARScript/cedarscript-grammar#readme)
as an [_edit format_](https://aider.chat/docs/benchmarks.html#edit-formats).
## Table of Contents
- [What is CEDARScript?](#what-is-cedarscript)
- [Installation](#installation)
- [Why Use CEDARScript?](#why-use-cedarscript)
- [Performance Comparison](#performance-comparison)
- [Notable Achievements](#notable-achievements)
- [The Gemini 1.5 Flash benchmark highlights](#the-gemini-15-flash-benchmark-highlights)
- [Individual Test Analysis](#individual-test-analysis)
- [Detailed Analysis](#detailed-analysis)
- [Contributing](#contributing)
- [License](#license)
## What is CEDARScript?
[CEDARScript](https://bit.ly/cedarscript) (_Concise Examination, Development, And Refactoring Script_)
is a domain-specific language designed to improve how AI coding assistants interact with codebases and communicate their code modification intentions.
It provides a standardized way to express complex code modification and analysis operations, making it easier for
AI-assisted development tools to understand and execute these tasks.
## Installation
1. Install _**Aider with CEDARScript**_ via this command below:
```shell
python -m ensurepip --upgrade
pip install --upgrade --force-reinstall \
git+https://github.com/elifarley/aider@cedarscript \
aider-chat
```
2. Now, simply use the [`--edit-format` switch](https://aider.chat/docs/more/edit-formats.html) and select `cedarscript`:
```shell
aider --edit-format cedarscript
```
## Why use CEDARScript?
`TL;DR`: You can get higher success rates when refactoring large files, comparing to other edit formats.
1. **Higher Success Rates**: Significantly improves the performance of AI models in code refactoring tasks.
2. **Cost-Effective Performance**: Enables more affordable models to compete with top-tier options.
3. **Standardized Communication**: Provides a consistent format for AI-code interaction in coding tasks.
4. **Enhanced Accuracy**: Reduces errors and improves the quality of AI-generated code modifications.
## Performance Comparison
CEDARScript has shown remarkable improvements in AI model performance for code refactoring:
| Model | Format | Pass Rate | Well-Formed Cases | Syntax Errors | Indentation Errors | Cost | Avg. Time per case |
|-------------------|-------------|-----------|-------------------|---------------|--------------------|------|--------------------|
| Gemini 1.5 PRO | CEDARScript | 77.5% | 86.5% | 4 | 3 | 26.2 | 29 |
| Gemini 1.5 Flash | CEDARScript | 76.4% | 94.4% | 3 | 5 | 0.68 | 14.7 |
| Claude 3.5 Sonnet | diff | 64.0% | 76.4% | n/a | n/a | n/a | n/a |
| Gemini 1.5 PRO | diff-fenced | 49.4% | 7.9% | 21 | 93 | 28.3 | 110.1 |
### Notable Achievements:
- **Gemini 1.5 _PRO_** with **CEDARScript** outperformed both its diff-fenced format and **Claude 3.5 Sonnet**.
- Most remarkably, the more cost-effective **Gemini 1.5 _Flash_** model, using **CEDARScript**, outperformed **Claude 3.5 Sonnet**.
- It goes to show that even a more affordable model can surpass top-tier competitors when equipped with the _right_ tools.
This suggests that **CEDARScript** can level the playing field, enabling more accessible AI models
to compete with and even _exceed_ the capabilities of more expensive options in certain coding tasks.
### The Gemini 1.5 Flash benchmark highlights
- 48% of tests (43 total) showed improvements
- 103% increase in Pass 1 success rate (75 tests)
- Test duration reduced by 93% (from 5:17:26 to 0:25:17)
- Token efficiency greatly improved:
- Sent tokens: -37% (7.59M)
- Received tokens: -96% (180K)
- Error reduction:
- Error outputs: -94% (35 total)
- Malformed outputs: -94% (6 cases)
- Syntax errors: -85% (3 cases)
- Indent errors eliminated (100% reduction)
<details>
<summary>Delta...</summary>
</details>
### Individual Test Analysis
<details>
<summary>Individual Test Diff</summary>
```diff
--- 2024-10-22-05-21-41--gemini-1.5-flash-refactoring-whole
+++ 2024-10-22-05-13-37--gemini-1.5-flash-refactoring-cedarscript-i0.0.9-e0.3.3
# ============= Failed Attempts per Test =============
# N >= 0: it eventually passed after N failed attempts
# N < 0 : All attempts failed and limit was reached
@@ Improved, now PASSED (36) @@
++analyzer_cli_DebugAnalyzer__make_source_table: -4 -> 0
++autodetector_MigrationAutodetector__trim_to_apps: -4 -> 0
++backends_ModelBackend_with_perm: -4 -> 0
++builtin_BuiltinVariable_call_setattr: -4 -> 0
++checks_BaseModelAdminChecks__check_ordering_item: -4 -> 0
++checks_BaseModelAdminChecks__check_raw_id_fields_item: -4 -> 0
++checks_ModelAdminChecks__check_action_permission_methods: -4 -> 0
++checks_ModelAdminChecks__check_inlines_item: -4 -> 0
++checks_ModelAdminChecks__check_list_display_item: -4 -> 0
++clustering_ops_KMeans__mini_batch_training_op: -4 -> 0
++codeeditor_CodeEditor___get_brackets: -4 -> 0
++config_AppConfig__path_from_module: -4 -> 0
++config_ConfigCLI__get_settings_vars: -4 -> 0
++coordinator_HERETransitDataUpdateCoordinator__parse_transit_response: -4 -> 0
++cuda_cpp_scheduling_CUDACPPScheduling__can_fuse_epilogue_impl: -4 -> 0
++dataframeeditor_DataFrameView_next_index_name: -4 -> 0
++diffsettings_Command_output_hash: -4 -> 0
++dim2_Dim2CompatTests_test_reductions_2d_axis0: -4 -> 3
++distribution_DistributionFiles_parse_distribution_file_SUSE: -4 -> 0
++doc_DocCLI_get_role_man_text: -4 -> 0
++figure_FigureBase_colorbar: -4 -> 0
++functional_Functional__conform_to_reference_input: -4 -> 0
++galaxy_GalaxyCLI_execute_list_collection: -4 -> 0
++kernel_SpyderKernel_get_fault_text: -4 -> 1
++main_widget_PylintWidget_parse_output: -4 -> 0
++methods_BaseMethodsTests_test_where_series: -4 -> 0
++ogrinspect_Command_add_arguments: -4 -> 0
++onnxfunction_dispatcher_OnnxFunctionDispatcher__get_aten_name: -4 -> 1
++operations_DatabaseOperations_last_executed_query: -4 -> 0
++polar_RadialTick__determine_anchor: -4 -> 0
++profile_analyzer_cli_ProfileAnalyzer__get_list_profile_lines: -4 -> 0
++split_cat_SplitCatSimplifier_replace_cat: -4 -> 0
++split_cat_SplitCatSimplifier_replace_split: -4 -> 0
++text_CountVectorizer__limit_features: -4 -> 0
++triton_TritonScheduling_define_kernel: -4 -> 0
++triton_TritonScheduling_generate_node_schedule: -4 -> 0
@@ Improved, minor (3) @@
+ checks_BaseModelAdminChecks__check_autocomplete_fields_item: 3 -> 0
+ dataloader_DataLoader__is_role: 2 -> 0
+ operations_OracleOperations_convert_extent: 1 -> 0
@@ Worsened, now FAILED (7) @@
--base_BaseHandler_adapt_method_mode: 0 -> -4
--feedgenerator_Atom1Feed_add_item_elements: 0 -> -4
--generic_bsd_GenericBsdIfconfigNetwork_parse_inet_line: 0 -> -4
--graph_drawer_FxGraphDrawer__stringify_tensor_meta: 0 -> -4
--group_batch_fusion_GroupLinearFusion_fuse: 0 -> -4
--inspectdb_Command_normalize_col_name: 0 -> -4
--introspection_DatabaseIntrospection__parse_column_or_constraint_definition: 0 -> -4
@@ Stable: PASSED (30) @@
=+autosave_AutosaveForPlugin_get_files_to_recover: 0
=+base_BaseHandler_check_response: 0
=+baseconv_BaseConverter_convert: 0
=+compile_utils_MetricsContainer__get_metric_object: 0
=+concat__Concatenator__clean_keys_and_objs: 0
=+config_NetworkConfig_parse: 0
=+csrf_CsrfViewMiddleware__set_csrf_cookie: 0
=+dumpdata_Command_add_arguments: 0
=+finders_FileSystemFinder_check: 0
=+gateway_Gateway_get_and_delete_all_sms: 0
=+getitem_BaseGetitemTests_test_get: 0
=+grad_scaler_GradScaler__unscale_grads_: 0
=+gradient_checker_GradientChecker__assertInferTensorChecks: 0
=+graph_MigrationGraph_iterative_dfs: 0
=+grpc_debug_server_EventListenerBaseServicer__process_tensor_event_in_chunks: 0
=+i18n_JavaScriptCatalog_get_paths: 0
=+inspectdb_Command_get_field_type: 0
=+inspectdb_Command_get_meta: 0
=+introspection_DatabaseIntrospection__get_column_collations: 0
=+load_v1_in_v2__EagerSavedModelLoader__extract_signatures: 0
=+makemessages_Command_add_arguments: 0
=+makemigrations_Command_add_arguments: 0
=+migrate_Command_add_arguments: 0
=+operations_DatabaseOperations_bulk_insert_sql: 0
=+operations_DatabaseOperations_check_expression_support: 0
=+reshaping_BaseReshapingTests_test_concat_mixed_dtypes: 0
=+schema_DatabaseSchemaEditor_quote_value: 0
=+shell_Command_python: 0
=+special_RunSQL__run_sql: 0
=+weather_NWSWeather__forecast: 0
@@ Stable: FAILED (13) @@
=-autodetector_MigrationAutodetector_check_dependency: -4 -> -4
=-checks_ModelAdminChecks__check_list_editable_item: -4 -> -4
=-common_methods_invocations_foreach_inputs_sample_func__sample_rightmost_arg: -4 -> -4
=-common_utils_TestCase_genSparseTensor: -4 -> -4
=-doc_DocCLI_display_plugin_list: -4 -> -4
=-generator_GenOpTestCase_out_variant_op_test_case_generator: -4 -> -4
=-options_ModelAdmin_message_user: -4 -> -4
=-patches__Curve__get_arrow_wedge: -4 -> -4
=-quiver_Barbs__make_barbs: -4 -> -4
=-reshaping_BaseReshapingTests_test_unstack: -4 -> -4
=-sharding_policies_MaxShardSizePolicy__add_partition: -4 -> -4
=-split_cat_SplitCatSimplifier_get_transform_params: -4 -> -4
=-symbolic_shapes_ShapeEnv_bind_symbols: -4 -> -4
--- 2024-10-22-05-21-41--gemini-1.5-flash-refactoring-whole
+++ 2024-10-26-23-32-08--gemini-1.5-pro-refactoring-cedarscript-i0.0.18-e0.3.13
@@ ============= TEST STATUS CHANGES ============ @@
< REMOVED : 71 ( 80% of total)
<+ PASSED : 35 ( 39% of total)
<- FAILED : 36 ( 40% of total)
+ IMPROVED : 11 ( 12% of total)
++ Now PASSES : 10 ( 11% of total)
+ Minor : 1 ( 1% of total)
- WORSENED : 3 ( 3% of total)
-- Now FAILED : 3 ( 3% of total)
- Minor : 0 ( 0% of total)
= STABLE : 4 ( 4% of total)
=+ PASSED : 1 ( 1% of total)
#- FAILED : 3 ( 3% of total)
@@ ============= PERFORMANCE METRICS ============ @@
# TOTAL TEST COUNT : 18 (-71)
# DURATION hh:mm:ss: 0:10:29 (- 5:32:14, -97%) ---------
# COST ($) : 9.40 ( +7.02, +294%) ++++++++++++++++++++
# TOKENS SENT : 2,683,000 (-9,312,700, -78%) -------
# TOKENS RECEIVED : 12,382 (-4,970,531, -100%) ---------
# TIMEOUTS : 0 N/A
# ERROR OUTPUTS : 62 N/A
# USER ASKS : 37 ( -521, -93%) ---------
# CONTEXT EXHAUSTS : 0 N/A
# MALFORMED : 4 N/A
# SYNTAX ERRORS : 1 ( -105, -99%) ---------
# INDENT ERRORS : 9 ( -11, -55%) -----
# LAZY COMMENTS : 0 ( -28, -100%) ----------
```
</details>
#### Detailed Analysis
This overview suggests that the CEDARScript edit format has had a significant positive impact on the task of method extraction,
with improvements in nearly half of the tests and only a small percentage of tests worsening.
**Improvements:**
36 tests that previously failed now pass. This is a substantial improvement, indicating that CEDARScript is more
effective in correctly extracting methods from classes across a wide range of codebases.
**Notable improvements include:**
- `analyzer_cli_DebugAnalyzer__make_source_table`: Suggests better handling of debug-related code refactoring.
- `autodetector_MigrationAutodetector__trim_to_apps`: Indicates improved capability in refactoring Django migration-related code.
- `cuda_cpp_scheduling_CUDACPPScheduling__can_fuse_epilogue_impl`: Shows better performance in handling complex CUDA-related code.
- `triton_TritonScheduling_define_kernel` and triton_TritonScheduling_generate_node_schedule: Demonstrates improved capability in refactoring GPU computing-related code.
**Minor Improvements:**
3 tests showed minor improvements, such as `checks_BaseModelAdminChecks__check_autocomplete_fields_item`, suggesting
slight enhancements in handling Django admin-related code.
**Regressions:**
7 tests that previously passed now fail. While concerning, it's a relatively small number compared to the improvements.
**Notable regressions include:**
- `feedgenerator_Atom1Feed_add_item_elements`: Suggests potential issues with refactoring feed generation code.
- `generic_bsd_GenericBsdIfconfigNetwork_parse_inet_line`: Indicates challenges in refactoring network-related parsing code.
- `introspection_DatabaseIntrospection__parse_column_or_constraint_definition`: Shows difficulties in handling database schema introspection code.
**Stability:**
30 tests remained stable and passing, indicating that CEDARScript maintained performance in many areas, including various
Django commands, database operations, and utility functions.
13 tests remained stable but failing, suggesting that some challenging areas were not addressed by either format.
These include complex operations like `symbolic_shapes_ShapeEnv_bind_symbols` and `reshaping_BaseReshapingTests_test_unstack`.
**Analysis by Domain:**
- **Web Frameworks (e.g., Django)**: Generally improved, with better handling of model admin checks, configuration, and
database operations.
- **Data Science and ML**: Mixed results. Improvements in areas like clustering operations (`clustering_ops_KMeans__mini_batch_training_op`)
and data frame handling, but persistent issues in some reshaping operations.
- **System-level Operations**: Some improvements (e.g., `distribution_DistributionFiles_parse_distribution_file_SUSE`)
but also regressions (e.g., `generic_bsd_GenericBsdIfconfigNetwork_parse_inet_line`).
- **GPU and High-Performance Computing**: Significant improvements, especially in `CUDA` and `Triton`-related code.
**Interpretation:**
CEDARScript appears more effective in handling complex code structures, especially in areas related to web frameworks,
data processing, and high-performance computing.
It shows improved capability in understanding class contexts and correctly extracting methods across various domains.
However, it may introduce new challenges in certain specific areas, possibly due to its different approach to code manipulation.
**Areas for Further Investigation:**
Understanding why certain tests regressed (e.g., `feedgenerator_Atom1Feed_add_item_elements`) could provide insights for improvement.
Analyzing the stable failing tests (e.g., `symbolic_shapes_ShapeEnv_bind_symbols`) to see if CEDARScript can be enhanced
to address these persistent issues.
**Conclusion:**
- The introduction of CEDARScript appears to be a significant improvement for the task of extracting methods from classes.
- It shows particular strength in handling complex codebases, especially those related to web frameworks, data processing, and high-performance computing.
- However, care should be taken to address the areas where regressions occurred, particularly in system-level operations and certain parsing tasks.
- The consistent performance across various domains suggests that CEDARScript offers a more robust and versatile approach to code refactoring.
This analysis indicates that CEDARScript is a promising enhancement to Aider, offering more accurate and comprehensive
method extraction capabilities across a wide range of codebases.
However, it also highlights the need for continued refinement, especially in areas where regressions were observed.
</details>
### Benchmark Metrics
<details>
<summary>Sonnet 3.5 + diff</summary>
```yaml
- dirname: refac-claude-3.5-sonnet-diff-not-lazy
model: claude-3.5-sonnet (diff)
edit_format: diff
pass_rate_1: 64.0
percent_cases_well_formed: 76.4
```
</details>
<details>
<summary>Gemini 1.5 PRO + diff-fenced (leaderboard site)</summary>
```yaml
- dirname: refac-gemini
model: gemini/gemini-1.5-pro-latest
edit_format: diff-fenced
pass_rate_1: 49.4
percent_cases_well_formed: 7.9
```
</details>
<details>
<summary>Gemini 1.5 PRO + diff-fenced (own tests)</summary>
```yaml
- dirname: 2024-10-05-00-43-21--diff-fenced-Gemini-Refactoring
test_cases: 89
model: gemini/gemini-1.5-pro-latest
edit_format: diff-fenced
commit_hash: 772710b-dirty
pass_rate_1: 18.0
pass_rate_2: 21.3
pass_rate_3: 24.7
percent_cases_well_formed: 34.8
error_outputs: 180
num_malformed_responses: 180
num_with_malformed_responses: 58
user_asks: 128
lazy_comments: 2
syntax_errors: 21
indentation_errors: 93
exhausted_context_windows: 0
test_timeouts: 0
command: aider --model gemini/gemini-1.5-pro-latest
date: 2024-10-05
versions: 0.57.2.dev
seconds_per_case: 110.1
total_cost: 28.2515
```
</details>
<details>
<summary>Gemini 1.5 PRO + CEDARScript</summary>
```yaml
- dirname: 2024-10-19-22-48-07--cedarscript-0.3.1-refactoring-gemini1.5pro
test_cases: 89
model: gemini/gemini-1.5-pro-latest
edit_format: cedarscript-g
commit_hash: 4da1e9b-dirty
pass_rate_1: 77.5
percent_cases_well_formed: 86.5
error_outputs: 337
num_malformed_responses: 19
num_with_malformed_responses: 12
user_asks: 12
lazy_comments: 0
syntax_errors: 4
indentation_errors: 3
exhausted_context_windows: 0
test_timeouts: 0
command: aider --model gemini/gemini-1.5-pro-latest
date: 2024-10-19
versions: 0.59.2.dev
seconds_per_case: 29.0
total_cost: 26.2374
```
</details>
<details>
<summary>Gemini 1.5 Flash + whole</summary>
```yaml
- dirname: 2024-10-22-05-21-41--gemini-1.5-flash-refactoring-whole
test_cases: 89
model: gemini/gemini-1.5-flash-002
edit_format: whole
commit_hash: feb1c38
pass_rate_1: 41.6
pass_rate_2: 42.7
pass_rate_3: 43.8
pass_rate_4: 44.9
percent_cases_well_formed: 100.0
error_outputs: 0
num_malformed_responses: 0
num_with_malformed_responses: 0
user_asks: 558
lazy_comments: 28
syntax_errors: 106
indentation_errors: 20
exhausted_context_windows: 0
test_timeouts: 0
command: aider --model gemini/gemini-1.5-flash-002
date: 2024-10-22
versions: 0.59.2.dev
seconds_per_case: 231.1
total_cost: 2.3894
```
</details>
<details>
<summary>Gemini 1.5 Flash + CEDARScript</summary>
```yaml
- dirname: 2024-10-20-00-33-27--cedarscript-0.3.1-refactoring-gemini-1.5-flash
test_cases: 89
model: gemini/gemini-1.5-flash-latest
edit_format: cedarscript-g
commit_hash: 4da1e9b-dirty
pass_rate_1: 76.4
percent_cases_well_formed: 94.4
error_outputs: 403
num_malformed_responses: 13
num_with_malformed_responses: 5
user_asks: 21
lazy_comments: 0
syntax_errors: 3
indentation_errors: 5
exhausted_context_windows: 0
test_timeouts: 0
command: aider --model gemini/gemini-1.5-flash-latest
date: 2024-10-20
versions: 0.59.2.dev
seconds_per_case: 14.7
total_cost: 0.6757
```
</details>
#### functional_Functional__conform_to_reference_input
</details>
<details>
<summary>diff-fenced</summary>
```yaml
"cost": 0.33188854999999995,
"duration": 27.793912172317505,
"test_timeouts": 0,
"commit_hash": "772710b-dirty",
"num_error_outputs": 2,
"num_user_asks": 3,
"num_exhausted_context_windows": 0,
"num_malformed_responses": 2,
"syntax_errors": 0,
"indentation_errors": 3,
"lazy_comments": 0,
```
</details>
<details>
<summary>cedarscript</summary>
```yaml
"cost": 0.18178265,
"duration": 11.176445960998535,
"test_timeouts": 0,
"commit_hash": "772710b-dirty",
"num_error_outputs": 0,
"num_user_asks": 1,
"num_exhausted_context_windows": 0,
"num_malformed_responses": 0,
"syntax_errors": 0,
"indentation_errors": 0,
"lazy_comments": 0,
```
</details>
## Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
## License
This project is licensed under the MIT License.
Raw data
{
"_id": null,
"home_page": null,
"name": "cedarscript-integration-aider",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.11",
"maintainer_email": null,
"keywords": "cedarscript, code-editing, refactoring, code-analysis, sql-like, ai-assisted-development",
"author": null,
"author_email": "Elifarley <cedarscript@orgecc.com>",
"download_url": "https://files.pythonhosted.org/packages/7c/cb/cd46b721546b32c86240681bad3705797ea39007ef190f1aaaded4aa031e/cedarscript_integration_aider-1.3.5.tar.gz",
"platform": null,
"description": "# CEDARScript Integration: Aider\n\n[](https://pypi.org/project/cedarscript-integration-aider/)\n[](https://pypi.org/project/cedarscript-integration-aider/)\n[](https://github.com/psf/black)\n[](https://www.gnu.org/licenses/agpl-3.0)\n\n`CEDARScript Integration: Aider` enables [`Aider`](https://aider.chat/) to use \n[**CEDARScript**](https://github.com/CEDARScript/cedarscript-grammar#readme)\nas an [_edit format_](https://aider.chat/docs/benchmarks.html#edit-formats).\n\n## Table of Contents\n- [What is CEDARScript?](#what-is-cedarscript)\n- [Installation](#installation)\n- [Why Use CEDARScript?](#why-use-cedarscript)\n- [Performance Comparison](#performance-comparison)\n - [Notable Achievements](#notable-achievements)\n - [The Gemini 1.5 Flash benchmark highlights](#the-gemini-15-flash-benchmark-highlights)\n- [Individual Test Analysis](#individual-test-analysis)\n- [Detailed Analysis](#detailed-analysis)\n- [Contributing](#contributing)\n- [License](#license)\n\n## What is CEDARScript?\n\n[CEDARScript](https://bit.ly/cedarscript) (_Concise Examination, Development, And Refactoring Script_)\nis a domain-specific language designed to improve how AI coding assistants interact with codebases and communicate their code modification intentions.\nIt provides a standardized way to express complex code modification and analysis operations, making it easier for\nAI-assisted development tools to understand and execute these tasks.\n\n## Installation\n\n1. Install _**Aider with CEDARScript**_ via this command below:\n```shell\npython -m ensurepip --upgrade\npip install --upgrade --force-reinstall \\\ngit+https://github.com/elifarley/aider@cedarscript \\\naider-chat\n```\n2. Now, simply use the [`--edit-format` switch](https://aider.chat/docs/more/edit-formats.html) and select `cedarscript`:\n```shell\naider --edit-format cedarscript\n```\n\n## Why use CEDARScript?\n\n`TL;DR`: You can get higher success rates when refactoring large files, comparing to other edit formats.\n\n1. **Higher Success Rates**: Significantly improves the performance of AI models in code refactoring tasks.\n2. **Cost-Effective Performance**: Enables more affordable models to compete with top-tier options.\n3. **Standardized Communication**: Provides a consistent format for AI-code interaction in coding tasks.\n4. **Enhanced Accuracy**: Reduces errors and improves the quality of AI-generated code modifications.\n\n## Performance Comparison\n\nCEDARScript has shown remarkable improvements in AI model performance for code refactoring:\n\n| Model | Format | Pass Rate | Well-Formed Cases | Syntax Errors | Indentation Errors | Cost | Avg. Time per case |\n|-------------------|-------------|-----------|-------------------|---------------|--------------------|------|--------------------|\n| Gemini 1.5 PRO | CEDARScript | 77.5% | 86.5% | 4 | 3 | 26.2 | 29 |\n| Gemini 1.5 Flash | CEDARScript | 76.4% | 94.4% | 3 | 5 | 0.68 | 14.7 |\n| Claude 3.5 Sonnet | diff | 64.0% | 76.4% | n/a | n/a | n/a | n/a |\n| Gemini 1.5 PRO | diff-fenced | 49.4% | 7.9% | 21 | 93 | 28.3 | 110.1 |\n\n### Notable Achievements:\n- **Gemini 1.5 _PRO_** with **CEDARScript** outperformed both its diff-fenced format and **Claude 3.5 Sonnet**.\n- Most remarkably, the more cost-effective **Gemini 1.5 _Flash_** model, using **CEDARScript**, outperformed **Claude 3.5 Sonnet**.\n - It goes to show that even a more affordable model can surpass top-tier competitors when equipped with the _right_ tools.\n\nThis suggests that **CEDARScript** can level the playing field, enabling more accessible AI models\nto compete with and even _exceed_ the capabilities of more expensive options in certain coding tasks.\n\n### The Gemini 1.5 Flash benchmark highlights\n\n- 48% of tests (43 total) showed improvements\n- 103% increase in Pass 1 success rate (75 tests)\n- Test duration reduced by 93% (from 5:17:26 to 0:25:17)\n- Token efficiency greatly improved:\n- Sent tokens: -37% (7.59M)\n- Received tokens: -96% (180K)\n- Error reduction:\n- Error outputs: -94% (35 total)\n- Malformed outputs: -94% (6 cases)\n- Syntax errors: -85% (3 cases)\n- Indent errors eliminated (100% reduction)\n\n<details>\n<summary>Delta...</summary>\n \n\n</details>\n\n### Individual Test Analysis\n\n<details>\n<summary>Individual Test Diff</summary>\n\n```diff\n--- 2024-10-22-05-21-41--gemini-1.5-flash-refactoring-whole\n+++ 2024-10-22-05-13-37--gemini-1.5-flash-refactoring-cedarscript-i0.0.9-e0.3.3\n# ============= Failed Attempts per Test =============\n# N >= 0: it eventually passed after N failed attempts\n# N < 0 : All attempts failed and limit was reached\n\n@@ Improved, now PASSED (36) @@\n++analyzer_cli_DebugAnalyzer__make_source_table: -4 -> 0\n++autodetector_MigrationAutodetector__trim_to_apps: -4 -> 0\n++backends_ModelBackend_with_perm: -4 -> 0\n++builtin_BuiltinVariable_call_setattr: -4 -> 0\n++checks_BaseModelAdminChecks__check_ordering_item: -4 -> 0\n++checks_BaseModelAdminChecks__check_raw_id_fields_item: -4 -> 0\n++checks_ModelAdminChecks__check_action_permission_methods: -4 -> 0\n++checks_ModelAdminChecks__check_inlines_item: -4 -> 0\n++checks_ModelAdminChecks__check_list_display_item: -4 -> 0\n++clustering_ops_KMeans__mini_batch_training_op: -4 -> 0\n++codeeditor_CodeEditor___get_brackets: -4 -> 0\n++config_AppConfig__path_from_module: -4 -> 0\n++config_ConfigCLI__get_settings_vars: -4 -> 0\n++coordinator_HERETransitDataUpdateCoordinator__parse_transit_response: -4 -> 0\n++cuda_cpp_scheduling_CUDACPPScheduling__can_fuse_epilogue_impl: -4 -> 0\n++dataframeeditor_DataFrameView_next_index_name: -4 -> 0\n++diffsettings_Command_output_hash: -4 -> 0\n++dim2_Dim2CompatTests_test_reductions_2d_axis0: -4 -> 3\n++distribution_DistributionFiles_parse_distribution_file_SUSE: -4 -> 0\n++doc_DocCLI_get_role_man_text: -4 -> 0\n++figure_FigureBase_colorbar: -4 -> 0\n++functional_Functional__conform_to_reference_input: -4 -> 0\n++galaxy_GalaxyCLI_execute_list_collection: -4 -> 0\n++kernel_SpyderKernel_get_fault_text: -4 -> 1\n++main_widget_PylintWidget_parse_output: -4 -> 0\n++methods_BaseMethodsTests_test_where_series: -4 -> 0\n++ogrinspect_Command_add_arguments: -4 -> 0\n++onnxfunction_dispatcher_OnnxFunctionDispatcher__get_aten_name: -4 -> 1\n++operations_DatabaseOperations_last_executed_query: -4 -> 0\n++polar_RadialTick__determine_anchor: -4 -> 0\n++profile_analyzer_cli_ProfileAnalyzer__get_list_profile_lines: -4 -> 0\n++split_cat_SplitCatSimplifier_replace_cat: -4 -> 0\n++split_cat_SplitCatSimplifier_replace_split: -4 -> 0\n++text_CountVectorizer__limit_features: -4 -> 0\n++triton_TritonScheduling_define_kernel: -4 -> 0\n++triton_TritonScheduling_generate_node_schedule: -4 -> 0\n\n@@ Improved, minor (3) @@\n+ checks_BaseModelAdminChecks__check_autocomplete_fields_item: 3 -> 0\n+ dataloader_DataLoader__is_role: 2 -> 0\n+ operations_OracleOperations_convert_extent: 1 -> 0\n\n@@ Worsened, now FAILED (7) @@\n--base_BaseHandler_adapt_method_mode: 0 -> -4\n--feedgenerator_Atom1Feed_add_item_elements: 0 -> -4\n--generic_bsd_GenericBsdIfconfigNetwork_parse_inet_line: 0 -> -4\n--graph_drawer_FxGraphDrawer__stringify_tensor_meta: 0 -> -4\n--group_batch_fusion_GroupLinearFusion_fuse: 0 -> -4\n--inspectdb_Command_normalize_col_name: 0 -> -4\n--introspection_DatabaseIntrospection__parse_column_or_constraint_definition: 0 -> -4\n\n@@ Stable: PASSED (30) @@\n=+autosave_AutosaveForPlugin_get_files_to_recover: 0\n=+base_BaseHandler_check_response: 0\n=+baseconv_BaseConverter_convert: 0\n=+compile_utils_MetricsContainer__get_metric_object: 0\n=+concat__Concatenator__clean_keys_and_objs: 0\n=+config_NetworkConfig_parse: 0\n=+csrf_CsrfViewMiddleware__set_csrf_cookie: 0\n=+dumpdata_Command_add_arguments: 0\n=+finders_FileSystemFinder_check: 0\n=+gateway_Gateway_get_and_delete_all_sms: 0\n=+getitem_BaseGetitemTests_test_get: 0\n=+grad_scaler_GradScaler__unscale_grads_: 0\n=+gradient_checker_GradientChecker__assertInferTensorChecks: 0\n=+graph_MigrationGraph_iterative_dfs: 0\n=+grpc_debug_server_EventListenerBaseServicer__process_tensor_event_in_chunks: 0\n=+i18n_JavaScriptCatalog_get_paths: 0\n=+inspectdb_Command_get_field_type: 0\n=+inspectdb_Command_get_meta: 0\n=+introspection_DatabaseIntrospection__get_column_collations: 0\n=+load_v1_in_v2__EagerSavedModelLoader__extract_signatures: 0\n=+makemessages_Command_add_arguments: 0\n=+makemigrations_Command_add_arguments: 0\n=+migrate_Command_add_arguments: 0\n=+operations_DatabaseOperations_bulk_insert_sql: 0\n=+operations_DatabaseOperations_check_expression_support: 0\n=+reshaping_BaseReshapingTests_test_concat_mixed_dtypes: 0\n=+schema_DatabaseSchemaEditor_quote_value: 0\n=+shell_Command_python: 0\n=+special_RunSQL__run_sql: 0\n=+weather_NWSWeather__forecast: 0\n\n@@ Stable: FAILED (13) @@\n=-autodetector_MigrationAutodetector_check_dependency: -4 -> -4\n=-checks_ModelAdminChecks__check_list_editable_item: -4 -> -4\n=-common_methods_invocations_foreach_inputs_sample_func__sample_rightmost_arg: -4 -> -4\n=-common_utils_TestCase_genSparseTensor: -4 -> -4\n=-doc_DocCLI_display_plugin_list: -4 -> -4\n=-generator_GenOpTestCase_out_variant_op_test_case_generator: -4 -> -4\n=-options_ModelAdmin_message_user: -4 -> -4\n=-patches__Curve__get_arrow_wedge: -4 -> -4\n=-quiver_Barbs__make_barbs: -4 -> -4\n=-reshaping_BaseReshapingTests_test_unstack: -4 -> -4\n=-sharding_policies_MaxShardSizePolicy__add_partition: -4 -> -4\n=-split_cat_SplitCatSimplifier_get_transform_params: -4 -> -4\n=-symbolic_shapes_ShapeEnv_bind_symbols: -4 -> -4\n\n--- 2024-10-22-05-21-41--gemini-1.5-flash-refactoring-whole \n+++ 2024-10-26-23-32-08--gemini-1.5-pro-refactoring-cedarscript-i0.0.18-e0.3.13 \n@@ ============= TEST STATUS CHANGES ============ @@ \n \n< REMOVED : 71 ( 80% of total) \n<+ PASSED : 35 ( 39% of total) \n<- FAILED : 36 ( 40% of total) \n \n+ IMPROVED : 11 ( 12% of total) \n++ Now PASSES : 10 ( 11% of total) \n+ Minor : 1 ( 1% of total) \n \n- WORSENED : 3 ( 3% of total) \n-- Now FAILED : 3 ( 3% of total) \n- Minor : 0 ( 0% of total) \n \n= STABLE : 4 ( 4% of total) \n=+ PASSED : 1 ( 1% of total) \n#- FAILED : 3 ( 3% of total) \n \n@@ ============= PERFORMANCE METRICS ============ @@ \n# TOTAL TEST COUNT : 18 (-71) \n# DURATION hh:mm:ss: 0:10:29 (- 5:32:14, -97%) --------- \n# COST ($) : 9.40 ( +7.02, +294%) ++++++++++++++++++++ \n# TOKENS SENT : 2,683,000 (-9,312,700, -78%) ------- \n# TOKENS RECEIVED : 12,382 (-4,970,531, -100%) --------- \n# TIMEOUTS : 0 N/A \n# ERROR OUTPUTS : 62 N/A \n# USER ASKS : 37 ( -521, -93%) --------- \n# CONTEXT EXHAUSTS : 0 N/A \n# MALFORMED : 4 N/A \n# SYNTAX ERRORS : 1 ( -105, -99%) --------- \n# INDENT ERRORS : 9 ( -11, -55%) ----- \n# LAZY COMMENTS : 0 ( -28, -100%) ---------- \n```\n</details>\n\n#### Detailed Analysis\n\nThis overview suggests that the CEDARScript edit format has had a significant positive impact on the task of method extraction,\nwith improvements in nearly half of the tests and only a small percentage of tests worsening.\n\n**Improvements:**\n\n36 tests that previously failed now pass. This is a substantial improvement, indicating that CEDARScript is more \neffective in correctly extracting methods from classes across a wide range of codebases.\n\n**Notable improvements include:**\n- `analyzer_cli_DebugAnalyzer__make_source_table`: Suggests better handling of debug-related code refactoring.\n- `autodetector_MigrationAutodetector__trim_to_apps`: Indicates improved capability in refactoring Django migration-related code.\n- `cuda_cpp_scheduling_CUDACPPScheduling__can_fuse_epilogue_impl`: Shows better performance in handling complex CUDA-related code.\n- `triton_TritonScheduling_define_kernel` and triton_TritonScheduling_generate_node_schedule: Demonstrates improved capability in refactoring GPU computing-related code.\n\n**Minor Improvements:**\n\n3 tests showed minor improvements, such as `checks_BaseModelAdminChecks__check_autocomplete_fields_item`, suggesting \nslight enhancements in handling Django admin-related code.\n\n**Regressions:**\n\n7 tests that previously passed now fail. While concerning, it's a relatively small number compared to the improvements.\n\n**Notable regressions include:**\n- `feedgenerator_Atom1Feed_add_item_elements`: Suggests potential issues with refactoring feed generation code.\n- `generic_bsd_GenericBsdIfconfigNetwork_parse_inet_line`: Indicates challenges in refactoring network-related parsing code.\n- `introspection_DatabaseIntrospection__parse_column_or_constraint_definition`: Shows difficulties in handling database schema introspection code.\n\n**Stability:**\n\n30 tests remained stable and passing, indicating that CEDARScript maintained performance in many areas, including various \nDjango commands, database operations, and utility functions.\n13 tests remained stable but failing, suggesting that some challenging areas were not addressed by either format.\nThese include complex operations like `symbolic_shapes_ShapeEnv_bind_symbols` and `reshaping_BaseReshapingTests_test_unstack`.\n\n**Analysis by Domain:**\n\n- **Web Frameworks (e.g., Django)**: Generally improved, with better handling of model admin checks, configuration, and \ndatabase operations.\n- **Data Science and ML**: Mixed results. Improvements in areas like clustering operations (`clustering_ops_KMeans__mini_batch_training_op`)\nand data frame handling, but persistent issues in some reshaping operations.\n- **System-level Operations**: Some improvements (e.g., `distribution_DistributionFiles_parse_distribution_file_SUSE`)\nbut also regressions (e.g., `generic_bsd_GenericBsdIfconfigNetwork_parse_inet_line`).\n- **GPU and High-Performance Computing**: Significant improvements, especially in `CUDA` and `Triton`-related code.\n\n**Interpretation:**\n\nCEDARScript appears more effective in handling complex code structures, especially in areas related to web frameworks, \ndata processing, and high-performance computing.\nIt shows improved capability in understanding class contexts and correctly extracting methods across various domains.\nHowever, it may introduce new challenges in certain specific areas, possibly due to its different approach to code manipulation.\n\n**Areas for Further Investigation:**\n\nUnderstanding why certain tests regressed (e.g., `feedgenerator_Atom1Feed_add_item_elements`) could provide insights for improvement.\n\nAnalyzing the stable failing tests (e.g., `symbolic_shapes_ShapeEnv_bind_symbols`) to see if CEDARScript can be enhanced \nto address these persistent issues.\n\n**Conclusion:**\n- The introduction of CEDARScript appears to be a significant improvement for the task of extracting methods from classes.\n- It shows particular strength in handling complex codebases, especially those related to web frameworks, data processing, and high-performance computing.\n- However, care should be taken to address the areas where regressions occurred, particularly in system-level operations and certain parsing tasks.\n- The consistent performance across various domains suggests that CEDARScript offers a more robust and versatile approach to code refactoring.\n\nThis analysis indicates that CEDARScript is a promising enhancement to Aider, offering more accurate and comprehensive \nmethod extraction capabilities across a wide range of codebases.\nHowever, it also highlights the need for continued refinement, especially in areas where regressions were observed.\n</details>\n\n### Benchmark Metrics\n\n<details>\n<summary>Sonnet 3.5 + diff</summary>\n\n```yaml\n- dirname: refac-claude-3.5-sonnet-diff-not-lazy\n model: claude-3.5-sonnet (diff)\n edit_format: diff\n pass_rate_1: 64.0\n percent_cases_well_formed: 76.4\n```\n</details>\n\n<details>\n<summary>Gemini 1.5 PRO + diff-fenced (leaderboard site)</summary>\n\n```yaml\n- dirname: refac-gemini\n model: gemini/gemini-1.5-pro-latest\n edit_format: diff-fenced\n pass_rate_1: 49.4\n percent_cases_well_formed: 7.9\n```\n</details>\n\n<details>\n<summary>Gemini 1.5 PRO + diff-fenced (own tests)</summary>\n\n```yaml\n- dirname: 2024-10-05-00-43-21--diff-fenced-Gemini-Refactoring\n test_cases: 89\n model: gemini/gemini-1.5-pro-latest\n edit_format: diff-fenced\n commit_hash: 772710b-dirty\n pass_rate_1: 18.0\n pass_rate_2: 21.3\n pass_rate_3: 24.7\n percent_cases_well_formed: 34.8\n error_outputs: 180\n num_malformed_responses: 180\n num_with_malformed_responses: 58\n user_asks: 128\n lazy_comments: 2\n syntax_errors: 21\n indentation_errors: 93\n exhausted_context_windows: 0\n test_timeouts: 0\n command: aider --model gemini/gemini-1.5-pro-latest\n date: 2024-10-05\n versions: 0.57.2.dev\n seconds_per_case: 110.1\n total_cost: 28.2515\n```\n</details>\n\n<details>\n<summary>Gemini 1.5 PRO + CEDARScript</summary>\n\n```yaml\n- dirname: 2024-10-19-22-48-07--cedarscript-0.3.1-refactoring-gemini1.5pro\n test_cases: 89\n model: gemini/gemini-1.5-pro-latest\n edit_format: cedarscript-g\n commit_hash: 4da1e9b-dirty\n pass_rate_1: 77.5\n percent_cases_well_formed: 86.5\n error_outputs: 337\n num_malformed_responses: 19\n num_with_malformed_responses: 12\n user_asks: 12\n lazy_comments: 0\n syntax_errors: 4\n indentation_errors: 3\n exhausted_context_windows: 0\n test_timeouts: 0\n command: aider --model gemini/gemini-1.5-pro-latest\n date: 2024-10-19\n versions: 0.59.2.dev\n seconds_per_case: 29.0\n total_cost: 26.2374\n```\n</details>\n\n<details>\n<summary>Gemini 1.5 Flash + whole</summary>\n\n```yaml\n- dirname: 2024-10-22-05-21-41--gemini-1.5-flash-refactoring-whole\n test_cases: 89\n model: gemini/gemini-1.5-flash-002\n edit_format: whole\n commit_hash: feb1c38\n pass_rate_1: 41.6\n pass_rate_2: 42.7\n pass_rate_3: 43.8\n pass_rate_4: 44.9\n percent_cases_well_formed: 100.0\n error_outputs: 0\n num_malformed_responses: 0\n num_with_malformed_responses: 0\n user_asks: 558\n lazy_comments: 28\n syntax_errors: 106\n indentation_errors: 20\n exhausted_context_windows: 0\n test_timeouts: 0\n command: aider --model gemini/gemini-1.5-flash-002\n date: 2024-10-22\n versions: 0.59.2.dev\n seconds_per_case: 231.1\n total_cost: 2.3894\n```\n</details>\n\n<details>\n<summary>Gemini 1.5 Flash + CEDARScript</summary>\n\n```yaml\n- dirname: 2024-10-20-00-33-27--cedarscript-0.3.1-refactoring-gemini-1.5-flash\n test_cases: 89\n model: gemini/gemini-1.5-flash-latest\n edit_format: cedarscript-g\n commit_hash: 4da1e9b-dirty\n pass_rate_1: 76.4\n percent_cases_well_formed: 94.4\n error_outputs: 403\n num_malformed_responses: 13\n num_with_malformed_responses: 5\n user_asks: 21\n lazy_comments: 0\n syntax_errors: 3\n indentation_errors: 5\n exhausted_context_windows: 0\n test_timeouts: 0\n command: aider --model gemini/gemini-1.5-flash-latest\n date: 2024-10-20\n versions: 0.59.2.dev\n seconds_per_case: 14.7\n total_cost: 0.6757\n```\n</details>\n\n#### functional_Functional__conform_to_reference_input\n\n</details>\n\n<details>\n<summary>diff-fenced</summary>\n\n```yaml\n \"cost\": 0.33188854999999995,\n \"duration\": 27.793912172317505,\n \"test_timeouts\": 0,\n \"commit_hash\": \"772710b-dirty\",\n \"num_error_outputs\": 2,\n \"num_user_asks\": 3,\n \"num_exhausted_context_windows\": 0,\n \"num_malformed_responses\": 2,\n \"syntax_errors\": 0,\n \"indentation_errors\": 3,\n \"lazy_comments\": 0,\n```\n\n</details>\n\n<details>\n<summary>cedarscript</summary>\n\n```yaml\n \"cost\": 0.18178265,\n \"duration\": 11.176445960998535,\n \"test_timeouts\": 0,\n \"commit_hash\": \"772710b-dirty\",\n \"num_error_outputs\": 0,\n \"num_user_asks\": 1,\n \"num_exhausted_context_windows\": 0,\n \"num_malformed_responses\": 0,\n \"syntax_errors\": 0,\n \"indentation_errors\": 0,\n \"lazy_comments\": 0,\n```\n\n</details>\n\n\n## Contributing\n\nContributions are welcome! Please feel free to submit a Pull Request.\n\n## License\n\nThis project is licensed under the MIT License.\n",
"bugtrack_url": null,
"license": "AGPL-3.0",
"summary": "Allows `Aider` to use CEDARScript as an edit format",
"version": "1.3.5",
"project_urls": {
"Bug Tracker": "https://github.com/CEDARScript/cedarscript-integration-aider/issues",
"Documentation": "https://github.com/CEDARScript/cedarscript-integration-aider#readme",
"Homepage": "https://github.com/CEDARScript/cedarscript-integration-aider",
"Repository": "https://github.com/CEDARScript/cedarscript-integration-aider.git"
},
"split_keywords": [
"cedarscript",
" code-editing",
" refactoring",
" code-analysis",
" sql-like",
" ai-assisted-development"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "9c7fd52b11b100b78c7d9bed857943ce7250506336c6cb779f882ee12ccab5d3",
"md5": "7262a018e74e8a8d8e2954a36483c751",
"sha256": "6d8ed6294a6319aa522a57d9d60a1b9ebbc4b70d572414fd322e2a6484ef0be5"
},
"downloads": -1,
"filename": "cedarscript_integration_aider-1.3.5-py3-none-any.whl",
"has_sig": false,
"md5_digest": "7262a018e74e8a8d8e2954a36483c751",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.11",
"size": 44584,
"upload_time": "2024-11-19T05:35:50",
"upload_time_iso_8601": "2024-11-19T05:35:50.507607Z",
"url": "https://files.pythonhosted.org/packages/9c/7f/d52b11b100b78c7d9bed857943ce7250506336c6cb779f882ee12ccab5d3/cedarscript_integration_aider-1.3.5-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "7ccbcd46b721546b32c86240681bad3705797ea39007ef190f1aaaded4aa031e",
"md5": "3ba0639824fee3c951636bc9b267a42f",
"sha256": "60d254a9b8c91aa4b6ae4442a85c555f6e61d3915f8b4289661ada291aa9e2a6"
},
"downloads": -1,
"filename": "cedarscript_integration_aider-1.3.5.tar.gz",
"has_sig": false,
"md5_digest": "3ba0639824fee3c951636bc9b267a42f",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.11",
"size": 69500,
"upload_time": "2024-11-19T05:35:52",
"upload_time_iso_8601": "2024-11-19T05:35:52.629586Z",
"url": "https://files.pythonhosted.org/packages/7c/cb/cd46b721546b32c86240681bad3705797ea39007ef190f1aaaded4aa031e/cedarscript_integration_aider-1.3.5.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-19 05:35:52",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "CEDARScript",
"github_project": "cedarscript-integration-aider",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "cedarscript-integration-aider"
}
JSON
