• R/O
  • SSH
  • HTTPS

format-sql: Commit


Commit MetaInfo

Revision71 (tree)
Time2018-08-25 20:28:29
Authorkimur058

Log Message

join句の整形候補を追加

Change Summary

Incremental Difference

--- trunk/DMLBreaker3.x/DMLBreaker.js (revision 70)
+++ trunk/DMLBreaker3.x/DMLBreaker.js (revision 71)
@@ -403,12 +403,12 @@
403403
404404 formatSql = formatWhere(formatSql);
405405
406- } else if (wkAdd.match(/ inner join | right join /i) != null) {
406+ } else if (wkAdd.match(/ (inner|right|cross) join /i) != null) {
407407
408408 formatSql += wkAdd.substring(0, wkAdd.length - 11) + "\n" + tab + wkAdd.slice(-11);
409409 wkAdd = "\n\t" + tab;
410410
411- } else if (wkAdd.match(/ left join /i) != null) {
411+ } else if (wkAdd.match(/ (left|full) join /i) != null) {
412412
413413 formatSql += wkAdd.substring(0, wkAdd.length - 10) + "\n" + tab + wkAdd.slice(-10);
414414 wkAdd = "\n\t" + tab;
@@ -418,7 +418,7 @@
418418 formatSql += wkAdd.substring(0, wkAdd.length - 17) + "\n" + tab + wkAdd.slice(-17);
419419 wkAdd = "\n\t" + tab;
420420
421- } else if (wkAdd.match(/ left outer join /i) != null) {
421+ } else if (wkAdd.match(/ (left|full) outer join /i) != null) {
422422
423423 formatSql += wkAdd.substring(0, wkAdd.length - 16) + "\n" + tab + wkAdd.slice(-16);
424424 wkAdd = "\n\t" + tab;
Show on old repository browser