Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat(shannon): to support executing SQL statement in javascript function #276

Open
ShannonBase opened this issue Nov 26, 2024 · 1 comment
Assignees
Labels
feature it will be implemented as a new feature

Comments

@ShannonBase
Copy link
Contributor

ShannonBase commented Nov 26, 2024

Summary

Description for this feature.
Now that we have supported javascript language function in shaonnonbase. But, it can not run SQL statement. For example,

DELIMITER |
CREATE FUNCTION TestConn() RETURNS INT
LANGUAGE JAVASCRIPT AS 
BEGIN
    const mysql = require('mysql');

    const connection = executeSQL("select * from table1 where col1='a'");

    return 0;
END|

We want to execute a SQL statement in javascript function.

@ShannonBase ShannonBase added the feature it will be implemented as a new feature label Nov 26, 2024
@ShannonBase ShannonBase self-assigned this Nov 26, 2024
@ShannonBase
Copy link
Contributor Author

This issue will be supported when #277 was done.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature it will be implemented as a new feature
Projects
None yet
Development

No branches or pull requests

1 participant