[GitHub] [airflow] WilliamTun commented on issue #11920: Add how-to Guide for Sqlite operators

[GitBox <gi...@apache.org>]

WilliamTun commented on issue #11920:
URL: https://github.com/apache/airflow/issues/11920#issuecomment-727633873


   Hey @kaxil 
   
   I have created/edited the following files:
   
   _airflow/providers/sqlite/example_dags/__init__.py
   airflow/providers/sqlite/example_dags/example_sqlite.py
   docs/howto/operator/index.rst
   docs/howto/operator/sqlite.rst_
   
   However, I have two problems:
   1. When I try to git push my changes, I am returned the following message:
   ERROR: Permission to apache/airflow.git denied to WilliamTun.
   fatal: Could not read from remote repository.
   Could you please tell me where I can get the relevant ssh key to push to this repo? 
   
   2. In the sqlite.rst file, I was unsure what the input parameters were. Could you tell me where I can get the info? I assumed it was in airflow/providers/sqlite/hooks/sqlite.py 
   However, by looking at the code:
   
   `class SqliteHook(DbApiHook):
       """Interact with SQLite."""
   
       conn_name_attr = 'sqlite_conn_id'
       default_conn_name = 'sqlite_default'
   
       def get_conn(self) -> sqlite3.dbapi2.Connection:
           """Returns a sqlite connection object"""
           conn_id = getattr(self, self.conn_name_attr)
           airflow_conn = self.get_connection(conn_id)
           conn = sqlite3.connect(airflow_conn.host)
           return conn`
   
   I could only assume the parameters needed to connect to sqlite was: 
      * - Parameter
        - Input
      * - conn_id: string
        - connection ID
   
   Please do correct me if I am wrong. Thank you.
   
   
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org