m_fx nguyenhieuec
nguyenhieuec
/ query_builder.py
Created
June 5, 2020 03:52
— forked from richiefrost/query_builder.py
Simple use of the builder pattern to create a SQL query generator
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| class QueryBuilder: | |
| def __init__(self): | |
| self.select_value = '' | |
| self.from_table_name = '' | |
| self.where_value = '' | |
| self.groupby_value = '' | |
| def select(self, select_arg): | |
| self.select_value = select_arg | |
| return self |
nguyenhieuec
/ get_rating_tiki_bs4.py
Last active
May 25, 2020 02:25
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import requests | |
| from bs4 import BeautifulSoup | |
| page = requests.get('https://tiki.vn/dien-thoai-may-tinh-bang/c1789?src=c.1789.hamburger_menu_fly_out_banner&_lc=Vk4wMjMwMDcwMTA=') | |
| soup = BeautifulSoup(page.text, 'html.parser') | |
| with open("tiki_page.html", mode='w') as f: | |
| f.write(soup.prettify()) | |
| rating = soup.findAll('p', {"class": "rating"}) | |
| for p in rating: |
NewerOlder