cube-js/cube

Validate column existence in database

Open

#6,601 opened on 2023年5月15日

GitHub で見る
 (3 comments) (0 reactions) (0 assignees)Rust (19,563 stars) (1,965 forks)batch import
help wanted

説明

Hey folks 👋 !

Is your feature request related to a problem? Please describe. As a cube JS user, i am frustrated not being able to confront my cube definition vs actual tables layout in database

Describe the solution you'd like Ideally, a CLI command npx cube-js validate-table-layout would generate 1 SQL query per cube and 1 SQL query per view then dry run (Where 1=2) it against a given database to check column existence

Describe alternatives you've considered I considered to build my own validation using a python script but it's cumberstone and would not benefit cube nor the comunity

Additional context Such feature exist for Looker for example

コントリビューターガイド

技術スタック
javascripttypescriptnodejssql
領域
backendclidatabasedeveloper experience
Issue 種別
feature
難度新しい貢献者にとっての実装難度です。1 は非常に小さな変更、5 は専門的な作業です。
3
推定時間経験ある貢献者が調査、実装、テスト、pull request 準備にかけるおおよその時間範囲です。
1-2 days
活動状況Issue が今どれだけ取り組みやすいかを示します。新しい、活発、古い、ブロック中、またはメンテナー入力待ちなどです。
stale
明確さ期待される変更、受け入れ条件、次の手順がどれだけ明確かを示します。
clear
前提条件
Knowledge of Cube.js data modelBasic SQLNode.js/TypeScript CLI development
初心者向け度初回貢献者にどれだけ取り組みやすいかを 1-100 で推定したスコアです。
40
調査方針
Investigate the Cube.js CLI codebase, specifically the commands directory. Look at existing commands for patterns (e.g., /packages/cubejs cli/src/command). The feature requires generating SQL queries for each cube/view and dry running them. Consider using the database adapter from /packages/cubejs backend shared to connect and validate. Review similar features in Looker’s Spectacles for inspiration. Discuss in issue #6601 for any clarifications on scope.