forked from taozhi8833998/node-sql-parser
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathload.js
More file actions
58 lines (54 loc) · 1.55 KB
/
load.js
File metadata and controls
58 lines (54 loc) · 1.55 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
import { commonOptionConnector, toUpper, hasVal, literalToSQL } from './util'
import { partitionToSQL } from './insert'
import { tableToSQL } from './tables'
import { columnsToSQL } from './column'
import { setToSQL } from './update'
function loadDataFields(expr) {
if (!expr) return ''
const { keyword, terminated, enclosed, escaped } = expr
return [
toUpper(keyword),
literalToSQL(terminated),
literalToSQL(enclosed),
literalToSQL(escaped),
].filter(hasVal).join(' ')
}
function loadDataLines(expr) {
if (!expr) return ''
const { keyword, starting, terminated } = expr
return [
toUpper(keyword),
literalToSQL(starting),
literalToSQL(terminated),
].filter(hasVal).join(' ')
}
function loadDataIgnore(expr) {
if (!expr) return ''
const { count, suffix } = expr
return ['IGNORE', literalToSQL(count), suffix].filter(hasVal).join(' ')
}
function loadDataToSQL(expr) {
if (!expr) return ''
const { mode, local, file, replace_ignore, table, partition, character_set, column, fields, lines, set, ignore } = expr
const result = [
'LOAD DATA',
toUpper(mode),
toUpper(local),
'INFILE',
literalToSQL(file),
toUpper(replace_ignore),
'INTO TABLE',
tableToSQL(table),
partitionToSQL(partition),
commonOptionConnector('CHARACTER SET', literalToSQL, character_set),
loadDataFields(fields),
loadDataLines(lines),
loadDataIgnore(ignore),
columnsToSQL(column),
commonOptionConnector('SET', setToSQL, set),
]
return result.filter(hasVal).join(' ')
}
export {
loadDataToSQL,
}