sqlim
Basic Db Queries for mysql
Installation
npm install sqlim
Usage
Connect Mysql
var sqlim=;sqlimdataBasehost='localhost';sqlimdataBaseuser='root';sqlimdataBasepass='';sqlimdataBasename='';sqlim;
Available Functions
- select
- from
- where
- where_or
- where_like
- where_like_or
- join
- join_left
- join_right
- getSql
- orderby
- groupby
- clear
- get
- insert
- update
- delete
select
sqlim;// SQL: select field,field1 as f,sum(field) as total
from
sqlim;// SQL: from table,table t1
where
sqlim;// SQL: where field=1 and field2='test'
where_or
sqlim;// SQL: where field=1 or field2='test'
where_like
sqlim;// SQL: where field like '%t1%' and field2 like 'test'
where_like_or
sqlim;// SQL: where field like '%t1%' or field2 like 'test'
join
sqlim;// SQL: join tablename t on t.ID=m.FIELD
join_left
sqlim;// SQL: left join tablename t on t.ID=m.FIELD
join_right
sqlim;// SQL: right join tablename t on t.ID=m.FIELD
getSql
sqlim ;var sql=sqlim;// OUTPUT sql: select ID,NAME,USERNAME,EMAIL from users where ID=2 and ISADMIN=2
orderby
sqlim;// SQL: order by ID asc,DATE desc
groupby
sqlim;// SQL: group by YEAR(datefield),STOCKNAME
clear
Reset Sql
sqlimclear;// SQL: ""
get
Sql Results
var {console;}sqlim;// Running SQL: select * from tablename;// OUTPUT: [{ID:1,FIELDNAME:'VALUE',ISTEST:'OK'}] sqlim;// Running SQL: select ID,FIELDNAME from tablename;// OUTPUT: [{ID:1,FIELDNAME:VALUE}] sqlim;// Running SQL: select ID,FIELDNAME from tablename;// OUTPUT: [{ID:1,FIELDNAME:VALUE}]
insert
var { if error throw error; console;// last insert id}var data=NAME:'test'SURNAME:'test';sqlim;// SQL: "insert into tablename set NAME='test',SURNAME='test'"
update
var { if error throw error; console;}var data=NAME:'test'SURNAME:'test';sqlim;// SQL: "update tablename set NAME='test',SURNAME='test'" sqlim;// SQL: "update tablename set NAME='test',SURNAME='test' where ID=17"
delete
var { if error throw error; console;}sqlim;// SQL: "delete from tablename" sqlim;// SQL: "delete from tablename where ID=17"