a
    ¯$\dÅ  ã                   @   sz   d dl Z d dlZ dd„ Zdd„ Zdd„ Zdd	„ Zd
d„ Zdd„ Zdd„ Zdd„ Z	dd„ Z
dd„ Zdd„ Zdd„ Zeƒ  dS )é    Nc                 C   sX   t  d¡}| ¡ }| ¡  d}| ||f}| ||¡ tdƒ | ¡  | ¡  | ¡  d S )NúWpostgres://qyqfclhd:0fYqqyr1sQsb00YWU_bNLsvrz3YJA74x@lallah.db.elephantsql.com/qyqfclhdzAINSERT INTO known_prospects (date, name, email) VALUES (%s,%s,%s)úData inserted successfully©Úpsycopg2ÚconnectÚcursorÚexecuteÚprintÚcommitÚclose©ÚdateÚnameÚemailÚconnÚcurÚinsert_scriptÚinsert_value© r   úCc:\Users\scott\Documents\Python\scheduled_emails\python_postgres.pyÚsave_to_db_known   s    

r   c                 C   sX   t  d¡}| ¡ }| ¡  d}| ||f}| ||¡ tdƒ | ¡  | ¡  | ¡  d S )Nr   zCINSERT INTO unknown_prospects (date, name, email) VALUES (%s,%s,%s)r   r   r   r   r   r   Úsave_to_db_unknown   s    

r   c                 C   sX   t  d¡}| ¡ }| ¡  d}| ||f}| ||¡ tdƒ | ¡  | ¡  | ¡  d S )Nr   z:INSERT INTO realtors (date, name, email) VALUES (%s,%s,%s)r   r   r   r   r   r   Úsave_to_db_realtors*   s    

r   c                 C   sZ   t  d¡}| ¡ }| ¡  d}| |||f}| ||¡ tdƒ | ¡  | ¡  | ¡  d S )Nr   zGINSERT INTO insurance (date, name, email, address) VALUES (%s,%s,%s,%s)r   r   )r   r   r   Úaddressr   r   r   r   r   r   r   Úsave_to_db_insurance<   s    
r   c                 C   sX   t  d¡}| ¡ }| ¡  d}| ||f}| ||¡ tdƒ | ¡  | ¡  | ¡  d S )Nr   z9INSERT INTO bankers (date, name, email) VALUES (%s,%s,%s)r   r   r   r   r   r   Úsave_to_db_bankersN   s    

r   c                  C   s8   t  d¡} |  ¡ }| d¡ |  ¡  | ¡  |  ¡  d S )Nr   z4ALTER TABLE insurance ADD COLUMN address VARCHAR(50))r   r   r   r   r
   r   )r   r   r   r   r   Úadd_column_to_insurance_tableq   s    

r   c                  C   s0   t  d¡} |  ¡ }| d¡ | ¡ }| ¡  |S )Nr   zSELECT * FROM known_prospects;©r   r   r   r   Zfetchallr   ©r   r   Údatar   r   r   Úget_data~   s    

r    c                  C   s0   t  d¡} |  ¡ }| d¡ | ¡ }| ¡  |S )Nr   z SELECT * FROM unknown_prospects;r   r   r   r   r   Úget_data_unknown‡   s    

r!   c                  C   s0   t  d¡} |  ¡ }| d¡ | ¡ }| ¡  |S )Nr   zSELECT * FROM realtors;r   r   r   r   r   Úget_data_realtors   s    

r"   c                  C   s0   t  d¡} |  ¡ }| d¡ | ¡ }| ¡  |S )Nr   zSELECT * FROM insurance;r   r   r   r   r   Úget_data_insurance™   s    

r#   c                  C   s0   t  d¡} |  ¡ }| d¡ | ¡ }| ¡  |S )Nr   zSELECT * FROM bankers;r   r   r   r   r   Úget_data_bankers¢   s    

r$   c                  C   s0   t  d¡} |  ¡ }| d¡ | ¡ }| ¡  |S )Nr   zSELECT * FROM birthday;r   r   r   r   r   Úget_data_birthday«   s    

r%   )r   Zpsycopg2.extrasr   r   r   r   r   r   r    r!   r"   r#   r$   r%   r   r   r   r   Ú<module>   s   #						