Overview Version History Q & A Rating & Review
Piton
Piton is a portable SQL testing VS Code Extension. The goal is to be an easy to use SQL tool for Quality Engineers.
Screenshot
Installation
Download and install Piton from the marketplace
Click the Piton icon on the sidebar
Click the "create piton example" button, this won't show if a .piton.sql exists already
Refresh the list to show created files
Run a file and look at Piton output for the results
Click on the "has valid characters" in the piton explorer view
Click the approve button next to "has valid characters" and the check will be set to pass
🎉 Congrats! You got the first file passing!
Optional - Install SQL Parser from the marketplace
Optional - Install CSV Viewer from the marketplace
Docs
Docs
Example
-- pn-connectionString pn-filePath/sqlite-example.db
-- pn-sqlDialect sqlite
-- pn-count
select *
from Studio_Ghibli
-- pn-check
-- pn-name has valid characters
-- pn-id-col Name
select *
from Studio_Ghibli
where Name like '%ä%'
-- pn-check
-- pn-expect snapshot
-- pn-id-col Name
select *
from Studio_Ghibli
Why Another Testing Library?
There are more formal SQL testing frameworks that requires a lot of developer setup and assistance. The goal of this tool is to be lightweight and something a QA can add to their tool kit. Similar to show Postman is help QAs even when Swagger is used.
Supported SQL
Architecture
layers
1. VS Code Extension
2. File Runner
3. SQL Dialect (pg, oracledb, sqlite, or duckdb)
4. SQL DB
Known Issues
duckdb overrides any approved values set in the .csv because of an ID issue
the run button does not disable if the job is running already
Release Notes
Feature and bugfixes for each release.
0.11.5
Fixed oracle sql dialect option and connection string issues
Added Sql Server support
0.11.3
Fixed summary page showing more files when it shouldn't
0.11.0
Added file minimap report
0.10.1
Minor chart color changes
0.10.0
0.9.0
Added snapshot capabilities
Added approval and deny hot buttons
0.8.4
Fixed issue parsing files
0.8.3
Significantly reduced vsix size
Refactored query parsing to handle more types of queries
Cleaning up memory usage after run
0.8.2
fixed sqlite connection issue
0.8.0
Added a result.piton.csv to summarize the results
Improved the sidebar to show more result data
Added oracledb to sql dialects
Added sqlite to sql dialects
Added on hover hints for piton logic
0.7.0
Ready to review by co-workers
Following extension guidelines
Ensure that you've read through the extensions guidelines and follow the best practices for creating your extension.
Primary Style Color: #ADBBD8
Enjoy!
