Numeric Production Mechanism
Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »

tsqlreader

0.0.3 • Public • Published

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

install

npm i tsqlreader

Downloadsweekly downloads

3

version

0.0.3

license

MIT

repository

githubgithub

last publish

collaborators

  • avatar