Sign Up for Free

RunKit +

Try any Node.js package right in your browser

This is a playground to test code. It runs a full Node.js environment and already has all of npm’s 400,000 packages pre-installed, including tsqlreader with all npm packages installed. Try it out:

var tsqlreader = require("tsqlreader")

This service is provided by RunKit and is not affiliated with npm, Inc or the package authors.

tsqlreader v0.0.3

load queries from .sql-files + naming + tamplates

#tsqlreader

Load SQL-queries from a file. Inside the file you write multiple queries like that in a file:

sql someName
    SELECT * from something;
end
#some comment
/* 
multiline
comment
*/
// rest of line comment
sql queryUsingFragment
    SELECT ${fragment} from ${prefix}something
end

sql fragment
    fieldOne as f, fieldtwo as fieldtwo
end

As you see, this small lib supports commets and fragments in a simple format.

var sqlreader = require('tsqlreader');
var initialFragments = {
    prefix: 'wp_'
};
var queries = sqlreader.parseSQLFileSync('queries/domain.sql',initialFragments);

mysql.query(queries.myQuery,params,callback);

for now this is all you need. the path, provided can be absolute, or relative to the current file or relative to process.cwd().

InitialFragments is an optional parameter, to predefine fragmets. In this case, it is used to provide a prefix for the table.

Motivation

Developer

Tobias Nickel German software developer in Shanghai. alt text

RunKit is a free, in-browser JavaScript dev environment for prototyping Node.js code, with every npm package installed. Sign up to share your code.
Sign Up for Free