yt3trees / execsql Goto Github PK
View Code? Open in Web Editor NEWRight click on the .sql file -> "Send" -> ExecSQL.exe -> Execute the query
License: MIT License
Right click on the .sql file -> "Send" -> ExecSQL.exe -> Execute the query
License: MIT License
現状はSQLの実行のみでSELECT結果の表示には対応していない。
CSV出力もできると良いかもしれない。
pyodbcではクエリを実行する際にSELECTとCREATE系は別の書き方をしないといけない。
SELECT用ボタンとEXCUTE用ボタンの2つを作れば解決するが、それだと見た目がスマートじゃないので1つのボタンでSELECTもCREATE系も対応できるようにしたい。
Currently, it only executes SQL and does not support displaying the SELECT results.
It would be nice to be able to output CSV as well.
In pyodbc, when executing a query, you have to write SELECT and CREATE differently.
This can be solved by creating two buttons, one for SELECT and one for EXCUTE, but that doesn't look very smart, so I'd like to be able to use one button for both SELECT and CREATE.
oneファイルじゃない形でビルドしてそれをショートカットで呼ぶのが良さそう。
実行時間の長いsqlを実行すると「応答なし」になるので別スレッドとして実行されるよう修正する。
その際プログレスバーを表示する。
ファイルパスが長いと見切れるので対応する。
ただラベルのテキストからパスを取得してクリック時のフォーカス処理を実装しているため工夫が必要。
.sqlファイル内にGOコマンドが入っているとエラーが出て実行できない。
pyodbcではGOコマンドを識別できないためのようだが、できれば解消したい。
参考:https://stackoverflow.com/questions/26940127/sql-query-fails-when-using-pyodbc-but-works-in-sql
If a GO command is included in the .sql file, an error occurs and it cannot be executed.
This seems to be because pyodbc cannot identify the GO command, but I would like to solve this problem if possible.
Reference:https://stackoverflow.com/questions/26940127/sql-query-fails-when-using-pyodbc-but-works-in-sql
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.