Comments (2)
Thanks @katopz
wasm-joey has a single function which performs the SQL request so I think the best way to implement escaping is to use the generic ?
placeholder (and pass in both the query string and an array of the parameters to map).
function performSqlQuery(string_query, parameter_array) {
return new Promise(function(resolve, reject) {
connection.query(string_query, parameter_array, function(err, resultSelect) {
if (err) {
res.status(400).send("Perhaps a bad request, or database is not running");
}
resolve(resultSelect);
});
});
}
The code calling this single performSqlQuery
would then be updated to look like the following.
function updateAOT(_wasm_id, _ssvm_options, _is_an_update) {
// snip
var sqlSelect = "SELECT wasm_binary from wasm_executables WHERE wasm_id = ?;";
var parameterArray = [_wasm_id];
performSqlQuery(sqlSelect, parameterArray).then((result, error) => {
// snip
});
}
from wasm-joey.
Updates have started on a new branch https://github.com/second-state/wasm-joey/tree/update_sql_as_per_issue_1
Placeholders have been implemented up until line 1563 and will continue to be updated from line 1592 onwards (approximately 19 of 52 have been updated at this stage)
from wasm-joey.
Related Issues (20)
- Specify a “callback url” in the header HOT 4
- Move the wasm_description to the header HOT 5
- Implement multipart/form-data to support html file upload HOT 2
- Implement header prefix of SSVM HOT 1
- Specify an "argument_url" in the header HOT 4
- Provide logging via `logging_callback_url` HOT 3
- Add logic for cases where wasm_id does not exist HOT 1
- Support stateful context HOT 2
- Support text/plain in /api/state HOT 1
- Limit the number of callbacks to rpc.ssvm.secondstate.io HOT 1
- Allow caller to submit request and then terminate request/response process HOT 1
- Levels of logging (verbose vs minimal) HOT 1
- Add unique parameter i.e. `joey_remote_url` or `joey_arg_url` for remote m2m data exchange HOT 1
- Documentation
- Provide easy access to store small amounts of data frequently HOT 2
- Enquire about return_value of RunUint8Array HOT 1
- Test new issue template
- Write tests for multipart using every combination of GET, POST and Callback HOT 1
- Error executing this function, please check function name, input parameters, return parameter for correctness HOT 9
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from wasm-joey.