Repository navigation
Expand file tree
/
Copy pathgenerate_internal_data.R
More file actions
100 lines (97 loc) · 7.97 KB
/
Copy pathgenerate_internal_data.R
File metadata and controls
100 lines (97 loc) · 7.97 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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
data_types <- list("1" = "Text", "2" = "Number", "3" = "Date",
"4" = "Time", "5" = "Date-Time", "6" = "Toggle",
"7" = "Select", "8" = "Pick List", "9" = "Multi-Select",
"10" = "Range", "11" = "Image", "12" = "Signature",
"13" = "Sound", "15" = "Manatee Works", "16" = "Label",
"17" = "Divider", "18" = "Subform", "19" = "Text Area",
"20" = "Phone", "21" = "SSN", "22" = "Email",
"23" = "Zip Code", "24" = "Assign To", "25" = "Unique ID",
"28" = "Drawing", "30" = "Magstripe", "31" = "RFID",
"32" = "Attachment", "33" = "Read Only", "35" = "Image Label",
"37" = "Location", "38" = "Socket Scanner", "39" = "Linea Pro",
"42" = "ETI Thermometer", "44" = "ESRI", "45" = "3rd Party",
"46" = "Counter", "47" = "Timer")
reserved_words <- c("abort", "absolute", "access", "action", "add", "after", "all",
"allocate", "alter", "analyse", "analyze", "and", "any", "are",
"array", "as", "nasc", "nasensitive", "assertion", "asymmetric",
"at ", "atomic", "attach", "audit", "authorization", "autoincrement",
"avg", "before", "begin", "between", "bigint ", "binary", "bit",
"bit_length", "blob", "boolean", "both", "breadth", "by", "call",
"called", "cascade", "cascaded ", "case", "cast", "catalog",
"change", "char", "char_length", "character", "character_length",
"check", "client_id", "clob", "close ", "cluster", "coalesce",
"collate", "collation", "column", "comment", "commit", "compress",
"condition", "conflict", "connect ", "connection", "constraint",
"constraints", "constructor", "contains", "continue", "convert",
"corresponding", "count ", "create", "cross", "cube", "current",
"current_date", "current_default_transform_group", "current_path",
"current_role ", "current_time", "current_timestamp", "current_transform_group_for_type",
"current_user", "cursor", "cycle", "data", "database ", "databases",
"date", "day", "day_hour", "day_microsecond", "day_minute", "day_second",
"deallocate", "dec", "decimal ", "declare", "default", "deferrable",
"deferred", "delayed", "delete", "depth", "deref", "desc", "describe",
"descriptor ", "detach", "deterministic", "diagnostics", "disconnect",
"distinct", "distinctrow", "div", "do", "domain", "double", "drop ",
"dual", "dynamic", "each", "element", "else", "elseif", "enclosed",
"end", "equals", "escape", "escaped", "except ", "exception",
"exclusive", "exec", "execute", "exists", "exit", "explain",
"external", "extract", "fail", "FALSE", "fetch ", "file", "filter",
"first", "float", "float4", "float8", "for", "force", "foreign",
"found", "free", "freeze ", "from", "full", "fulltext", "function",
"general", "get", "glob", "global", "go", "goto", "grant", "group",
"grouping ", "handler", "having", "high_priority", "hold", "hour",
"hour_microsecond", "hour_minute", "hour_second", "id", "identified ",
"identity", "if", "ignore", "ilike", "immediate", "in", "increment",
"index", "indexed", "indicator", "infile", "initial ", "initially",
"inner", "inout", "input", "insensitive", "insert", "instead",
"int", "int1", "int2", "int3", "int4", "int8 ", "integer", "intersect",
"interval", "into", "is", "isnull", "isolation", "iterate", "join",
"key", "keys", "kill ", "language", "large", "last", "lateral",
"leading", "leave", "left", "level", "like", "limit", "lines",
"load", "local ", "localtime", "localtimestamp", "locator", "location",
"lock", "long", "longblob", "longtext", "loop", "low_priority",
"lower", "map ", "match", "max", "maxextents", "mediumblob",
"mediumint", "mediumtext", "member", "merge", "method", "middleint",
"min", "minus ", "minute", "minute_microsecond", "minute_second",
"mlslabel", "mod", "mode", "modifies", "modify", "module", "month",
"multiset ", "names", "national", "natural", "nchar", "nclob",
"new", "next", "no", "no_write_to_binlog", "noaudit", "nocompress",
"none ", "not", "notnull", "nowait", "null", "nullif", "number",
"numeric", "object", "octet_length", "of", "off", "offline",
"offset ", "old", "on", "online", "only", "open", "optimize",
"option", "optionally", "or", "order", "ordinality", "out", "outer ",
"outfile", "output", "over", "overlaps", "pad", "parameter",
"partial", "partition", "path", "pctfree", "placing", "plan ",
"position", "pragma", "precision", "prepare", "preserve", "primary",
"prior", "privileges", "procedure", "public", "purge ", "query",
"raid0", "raise", "range", "raw", "read", "reads", "real", "recursive",
"ref", "references", "referencing", "regexp ", "reindex", "relative",
"release", "rename", "repeat", "replace", "require", "resignal",
"resource", "restrict", "result ", "return", "returns", "revoke",
"right", "rlike", "role", "rollback", "rollup", "routine", "row",
"rowid", "rownum", "rows ", "savepoint", "scale", "schema", "schemas",
"scope", "scroll", "search", "second", "second_microsecond",
"section", "select ", "sensitive", "separator", "sequence", "session",
"session_user", "set", "sets", "share", "show", "signal", "similar",
"size ", "smallint", "some", "soname", "space", "spatial", "specific",
"specifictype", "sql", "sql_big_result", "sql_calc_found_rows ",
"sql_small_result", "sqlcode", "sqlerror", "sqlexception", "sqlstate",
"sqlwarning", "ssl", "start", "starting", "state ", "static",
"straight_join", "submultiset", "substring", "successful", "sum",
"symmetric", "synonym", "sysdate", "system ", "system_user",
"table", "tablesample", "temp", "temporary", "terminated", "then",
"time", "timestamp", "timezone_hour ", "timezone_minute", "tinyblob",
"tinyint", "tinytext", "to", "trailing", "transaction", "translate",
"translation", "treat ", "trigger", "trim", "TRUE", "type", "uid",
"under", "undo", "union", "unique", "unknown", "unlock", "unnest",
"unsigned ", "until", "update", "upgrade", "upper", "usage",
"use", "user", "using", "utc_date", "utc_time", "utc_timestamp",
"vacuum ", "validate", "value", "values", "varbinary", "varchar",
"varchar2", "varcharacter", "varying", "verbose", "view", "virtual ",
"when", "whenever", "where", "while", "window", "with", "within",
"without", "work", "write", "x509", "xor", "year ", "year_month",
"zerofill", "zone", "created_date", "created_by", "created_location",
"created_device_id", "modified_date ", "modified_by", "modified_location",
"modified_device_id", "parent_record_id", "parent_page_id", "parent_element_id"
)
devtools::use_data(data_types, reserved_words, internal=T, overwrite = T)