Skip to content

RomDataSource enhancements for sql environments, eliminating implicit globals, etc. #479

@rburghol

Description

@rburghol
  • New methods/Data Structures for RomDataSource class:
    • local_dfs: list of data frames to be allowed in sqldf calls using the sql_query method/interface from ds
    • get_local_env(): provide list of dataframes in environment for use in sqldf queries and other env restricted applications
      • Adds the [roperties vardefs, propvalues, tsvalues, and features that are held in datasource class, and adds members of local_dfs
    • sql_query(query_text, local=FALSE)
      • restricts data frame queries to dataframes in the ds$local_dfs list
      • local=TRUE: use the ODBC connection not the local dataframes

@COBrogan @BrendanBrogan

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions