Man pages for KWB-R/kwb.db
Functions supporting data base access
| connectionStringAccess | Connection String Access |
| createRDatabaseInterface | Create R-Function Interface to Database |
| currentDb | Get Path to or Name of Current Database |
| dataFrameToSqlTuples | Create SQL Tuples from Data Frame |
| dumpDatabase | Export Database Tables to CSV Files |
| getCurrentSqlDialect | Get Current SQL Dialect |
| getDatabaseFieldInfo | Get Information on Table Field Names and Types |
| getDatabaseSchema | Get Database Schema |
| getFilteredRecords | Get Filtered Records |
| getNamedExcelRanges | Get Named Ranges from Excel File |
| getSqlDialect | Get SQL Dialect from Given Database |
| getTypeIdentifier | Get Type Identifier |
| hsClearTable | Clear a Database Table |
| hsCloseDb | Close Connection to MS Access or Excel |
| hsCloseMdb | Close Connection |
| hsDropTable | Drop Database Table(s) |
| hsDumpMdb | Export Database Tables to CSV Files |
| hsFields | Available Fields in Database Table |
| hsGetTable | Get Table from MS Access Database |
| hsGetTimeSeries | Get Time Series With Timestamp Info |
| hsJetDate | Date to "mm/dd/yyyy HH:MM:SS" |
| hsLookupOrAddRecord | Lookup or Add Record |
| hsMdbTimeSeries | Get Mdb time series in UTC |
| hsOpenDb | Open Connection to MS Access or Excel |
| hsOpenMdb | Open Connection to MS Access Database |
| hsPutTable | Save Data Frame to Database Table |
| hsSetForeignKey | Set Foreign Key for Table Field |
| hsSetPrimaryKey | Set Primary Key of Database Table |
| hsSqlExAnd | SQL Expression "AND" |
| hsSqlExOr | SQL Expression "OR" |
| hsSqlExTimeCond | SQL Expression: Time Period |
| hsSqlExTimeGroup | SQL Expression: Time Grouping |
| hsSqlExTsFields | SQL Expression: Timestamp Info |
| hsSqlQuery | Send SQL Query to Database |
| hsTables | Available tables in database |
| hsTsField | Available timestamp-field(s) in database table |
| isExcel2003File | Is this an XLS file? |
| isExcel2007File | Is this an XLSX file? |
| isExcelFile | Is this an Excel file? |
| isMySQL | Is the Given Database of Type MySQL? |
| keyValuesToSql | List of Key = Value Pairs to SQL Expressions |
| keyValuesToSqlAssignment | List of Key = Value Pairs to SQL Assignment |
| keyValuesToSqlAssignment2 | Key Values to SQL Assignment (2) |
| keyValuesToSqlFilter | List of Key = Value Pairs to SQL Filter Expression |
| keyValueToSql | Generate SQL Filter or Assignment Expression |
| listValuesToSql | Create SQL Tuples from a List |
| lookupRecord | Lookup Record |
| merge_relations | Merge Table Schema with Relationship Information |
| openAdequateConnectionOrStop | Open Adequate Connection or Stop |
| printDatabaseSchema | Print Database Schema |
| rcode_DatabaseInterface | R-code for Functions to Access Database Tables |
| read_relations | Read Relations from MSysRelationships Table CSV Export |
| read_schemata | Read Table Schemata from XML Files |
| readSqlCommandsFromFile | Read SQL Commands from File |
| renamesToFieldList | List of Renamings to Field Selection String |
| renamesToQueries | List of Renamings to SQL Queries |
| runSqlCommandsFromFile | Run SQL Commands from File |
| safeTableName | Safe Table Name |
| selectFromDb | Select from Database |
| selectFromTable | Select from Table |
| setCurrentDb | Set Current Database |
| setCurrentSqlDialect | Set Current SQL Dialect |
| sqlForInsert | Generate SQL INSERT statement |
| sqlForInsertDataFrame | Generate SQL INSERT Statement |
| sqlForInsertFromSelect | SQL for INSERT FROM SELECT |
| sqlForInsertIgnoreInMsAccess | SQL for "INSERT IGNORE" in MS Access |
| sqlForSelect | Generate SQL SELECT statement#' |
| sqlForSelectByKey | Generate SQL SELECT Statement |
| sqlForUpdate | Generate SQL UPDATE Statement |
| sqlFullLeftJoin | Merge SQL Queries to One Query That Performs a Full Left Join |
| sqlJoinExpression | Create an SQL JOIN Expression |
| sqlLeftJoin | Generate SQL for LEFT JOIN |
| sqlLeftJoinBody | Generate (Base Part of) SQL for LEFT JOIN |
| sqlLeftJoinExpression | Create an SQL LEFT JOIN Expression |
| xmdb | Path to example database |
