Harry Wang harrywang

## ocr.json
{
  "responses": [
    {
      "textAnnotations": [
        {
          "locale": "it",
          "description": "Unilever\nDove Dove\n国潮盛富 全民嗨购,\nDe Dove Dove ve\nम\n满88送88礼包\n",
          "boundingPoly": {
            "vertices": [
              {

## index.html
<!DOCTYPE html>
<meta charset="UTF-8">
<style>

.node circle {
  fill: #fff;
  stroke: steelblue;
  stroke-width: 3px;
}

## git_exercise.MD

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                harrywang
                / git_exercise.MD
            
            
              Last active
              February 13, 2020 23:24
            
              
                Git Exercise
              
          
    Git Exercise


create a new repo
clone to local
.gitignore
Markdown
add a python file and run
commit the file and push
add another python file
commit the file and push


## siteground-clone.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                harrywang
                / siteground-clone.md
            
            
              Last active
              September 22, 2019 14:47
            
          
    use wcba as an example:
login as admin. go to cpanel

go to subdomain and create a new subdomain:


## duplicates_pipeline.py
class DuplicatesPipeline(object):

    def __init__(self):
        """
        Initializes database connection and sessionmaker.
        Creates tables.
        """
        engine = db_connect()
        create_table(engine)
        self.Session = sessionmaker(bind=engine)

## save_quote_pipeline.py
class SaveQuotesPipeline(object):
    def __init__(self):
        """
        Initializes database connection and sessionmaker
        Creates tables
        """
        engine = db_connect()
        create_table(engine)
        self.Session = sessionmaker(bind=engine)

## models.py
from sqlalchemy import create_engine, Column, Table, ForeignKey, MetaData
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import (
    Integer, String, Date, DateTime, Float, Boolean, Text)
from scrapy.utils.project import get_project_settings

Base = declarative_base()


## quote_spider.py
import scrapy
from scrapy.loader import ItemLoader
from tutorial.items import QuoteItem

class QuotesSpider(scrapy.Spider):
    name = "quotes"
    allowed_domains = ["toscrape.com"]
    start_urls = ['http://quotes.toscrape.com/']


## items.py
from scrapy.item import Item, Field
from scrapy.loader.processors import MapCompose, TakeFirst
from datetime import datetime


def remove_quotes(text):
    # strip the unicode quotes
    text = text.strip(u'\u201c'u'\u201d')
    return text

## items.py
from scrapy.item import Item, Field
from scrapy.loader.processors import MapCompose

def remove_quotes(text):
    # strip the unicode quotes
    text = text.strip(u'\u201c'u'\u201d')
    return text
	{
	"responses": [
	{
	"textAnnotations": [
	{
	"locale": "it",
	"description": "Unilever\nDove Dove\n国潮盛富全民嗨购,\nDe Dove Dove ve\nम\n满88送88礼包\n",
	"boundingPoly": {
	"vertices": [
	{
	<!DOCTYPE html>
	<meta charset="UTF-8">
	<style>

	.node circle {
	fill: #fff;
	stroke: steelblue;
	stroke-width: 3px;
	}
	class DuplicatesPipeline(object):

	def __init__(self):
	"""
	Initializes database connection and sessionmaker.
	Creates tables.
	"""
	engine = db_connect()
	create_table(engine)
	self.Session = sessionmaker(bind=engine)
	class SaveQuotesPipeline(object):
	def __init__(self):
	"""
	Initializes database connection and sessionmaker
	Creates tables
	"""
	engine = db_connect()
	create_table(engine)
	self.Session = sessionmaker(bind=engine)
	from sqlalchemy import create_engine, Column, Table, ForeignKey, MetaData
	from sqlalchemy.orm import relationship
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy import (
	Integer, String, Date, DateTime, Float, Boolean, Text)
	from scrapy.utils.project import get_project_settings

	Base = declarative_base()
	import scrapy
	from scrapy.loader import ItemLoader
	from tutorial.items import QuoteItem

	class QuotesSpider(scrapy.Spider):
	name = "quotes"
	allowed_domains = ["toscrape.com"]
	start_urls = ['http://quotes.toscrape.com/']
	from scrapy.item import Item, Field
	from scrapy.loader.processors import MapCompose, TakeFirst
	from datetime import datetime


	def remove_quotes(text):
	# strip the unicode quotes
	text = text.strip(u'\u201c'u'\u201d')
	return text