-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathDESCRIPTION
29 lines (29 loc) · 981 Bytes
/
DESCRIPTION
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
Package: dbUpdateTable
Title: Create and update keyed MySQL tables from R
Version: 0.1.0.2
Authors@R: person("Akhil", "Name", email = "[email protected]", role = c("aut", "cre"))
Description: The main purpose of this package is to provide a single function to update table in a MySQL database by key.
To achieve this, there first must be a method to create a keyed MySQL table available. This set up naturally lends itself to data.table where tables can be keyed natively
The update is achieved via a DELETE + INSERT. The INSERT uses the standard RMySQL function. The delete could be improved as this is just string parsing.
Depends:
R (>= 3.3.2)
Imports:
data.table,
RMySQL,
DBI,
magrittr,
stringr,
testthat,
tibble
License: MIT + file LICENSE
Encoding: UTF-8
LazyData: true
RoxygenNote: 5.0.1
Collate:
'dbDeleteRowByKey.R'
'dbGetKey.R'
'utils.R'
'get_sql_type.R'
'dbSyncTableR.R'
'dbUpdateTable.R'
'sql_types.R'