data-raw/DATASET.R

In arestrom/iformr: A set of tools to leverage the iFormBuilder API

## code to prepare `DATASET` dataset goes here
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"
)

# Generate sysdata.rda...will write to R folder
usethis::use_data(data_types, reserved_words, internal=TRUE, overwrite = TRUE)