Skip to content
igorp74 edited this page Apr 10, 2022 · 4 revisions

DataFrame Utils (df_utils)

  • db - for database connectors

    • mssqlsrv(sqlserver, database, **kwargs)

    • oracle(hostname, database, **kwargs)

    • postgresql(hostname, database, **kwargs)

      📌 MS SQL Server/Oracle/PostgreSQL connection engine for Python.
      
      ⚙️ ARGUMENTS:
      Mandatory
      - hostname:       Host IP or Name. Non-default port number goes after coma.
      - database:       Database name
      
      Optional
      - a_mode:         engine | conn      default (Engine)
      - a_autocommit:     True | False     default (False)
      
      - a_username:   username
      - a_password:   password
      

Example

screenshot_20220410-131902

Clone this wiki locally