Reading File url from DropBox using Python

 

import dropbox

dbx = dropbox.Dropbox('dropBox_Api-key')

#dbx = dropbox.Dropbox('sl.BP-UylLoDgL_PgQ-TIYsyaQ0TJcp_BiiZgJVKaS2_hn-g2Rl9TGbZ6XabUdhcUiSYow6xF-9uyTIs74GYQkFjJ6T0R81vMbGs-wkMQCN1bo4IquKx-RqRswcneIlHXxg9DCO_bHFBkgN')

#response = dbx.files_list_folder("").entries

#for file in response:

    #print (file.link)

    #print(sharing_create_shared_link(file.path_d   isplay, short_url=False, pending_upload=None))

       

 

#shared_link_metadata = dbx.sharing_create_shared_link_with_settings("/sales2")

#print (shared_link_metadata.links[0].url)

print('---------------------------')

files = dbx.files_list_folder("/KYSALESV1").entries

for file in files:

    #print(file.name)

    shared_link = dbx.sharing_list_shared_links(str("/KYSALESV1/"+ file.name), direct_only=True)

    for item in shared_link.links:

        print(item.url+'|'+file.name)

SQL Problem ,Recursive CTE

 

WITH  integer_sequence(n) AS (

  SELECT 2019 -- starting value

  UNION ALL

  SELECT n+1 FROM integer_sequence WHERE n < 2021 -- ending value

)

Select customer_id,customer_name,AVG(Amount) from (

Select A.n as bill_Year,A.customer_id ,A.customer_name,ISNULL(Amount,0) AS Amount from (

SELECT * FROM integer_sequence A  cross join  (Select distinct customer_id,customer_name from Test_SQL)B

) A

left outer join  Test_SQL B on  A.n=DATEPART(YEAR,B.ddate) and A.customer_id=B.customer_id

 

) B

group by customer_id,customer_name

Useful git command

 git remote  -v  (find he git origin link)

git branch branch-name    (create new branch)

git branch -a (list all branch)

git switch "branch-name"  (switch to another branch)

git merge "branch-name"  (merging branch )

git push --set-upstream origin "branch-name"  update new branch in remote

git log --oneline --all --graph  (list changes in files)