PO_BOX

py

School

Stony Brook University *

*We aren’t endorsed by this school

Course

214

Subject

Computer Science

Date

Jan 9, 2024

Type

py

Pages

2

Uploaded by MinisterScience5603

Report
from sqlalchemy import create_engine, Column, String, Integer, or_ from sqlalchemy.orm import declarative_base, sessionmaker DATABASE_URL = "sqlite:///sites_crawled(123) copy.db3" # Base class for declarative models Base = declarative_base() # Defining the SitesCrawled class class SitesCrawled(Base): __tablename__ = 'sites_crawled' id = Column(Integer, primary_key=True) site = Column(String(1024)) # Defining the DoctorScrapedInfo class class DoctorScrapedInfo(Base): __tablename__ = 'scraped_doctors_info' id = Column(Integer, primary_key=True) site_crawled_id = Column(Integer, nullable=False) site = Column(String(1024), nullable=False) website = Column(String(1024)) name = Column(String(1024)) title = Column(String(1024)) first_name = Column(String(1024)) middle_name = Column(String(1024)) last_name = Column(String(1024)) personal_suffix = Column(String(1024)) clinical_suffix = Column(String(1024)) specialty = Column(String(1024)) university = Column(String(1024)) street = Column(String(1024)) street_internal = Column(String(1024)) city = Column(String(1024)) state = Column(String(1024)) zip_code = Column(String(1024)) phone_number = Column(String(1024)) # Defining the MultipleAddresses class class MultipleAddresses(Base): __tablename__ = 'multiple_addresses' id = Column(Integer, primary_key=True, autoincrement=True) # Auto-incrementing id doctor_scraped_info_id = Column(Integer, nullable=False) street = Column(String(1024)) street_internal = Column(String(1024)) city = Column(String(1024)) state = Column(String(1024)) zip_code = Column(String(1024)) phone_number = Column(String(1024)) # Setting up the connection and session engine = create_engine(DATABASE_URL) Base.metadata.create_all(engine) Session = sessionmaker(bind=engine) session = Session() # Querying and deleting entries from DoctorScrapedInfo table with "PO box" or "PO
BOX" in the street column doctors_with_pobox = session.query(DoctorScrapedInfo).filter( or_( DoctorScrapedInfo.street.ilike('%PO box%'), DoctorScrapedInfo.street.ilike('%PO BOX%'), DoctorScrapedInfo.street.ilike('%PO Box%') ) ).all() for doctor in doctors_with_pobox: session.delete(doctor) # Querying and deleting entries from MultipleAddresses table with "PO box" or "PO BOX" in the street column addresses_with_pobox = session.query(MultipleAddresses).filter( or_( MultipleAddresses.street.ilike('%PO box%'), MultipleAddresses.street.ilike('%PO BOX%'), MultipleAddresses.street.ilike('%PO Box%') ) ).all() for address in addresses_with_pobox: session.delete(address) session.commit()
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

FT-Review-NS.pdf
Rev-Fi23.docx
CIS256L Project 1.3_Frankie_Gunn.docx
CIS256L_InClass_Activity_1.2_Frankie_Gunn.docx
CIS 251 Guided Practice 5.6.docx
Unit 2 CT.docx
Suffix.py
Remove_Duplicates.py
Web4.pdf
Copyy of CSE 300 Resource Review.pdf
CKPM 217-S2023-Assignment 2-updated 13June2023.pdf
CMPSC_461_Fall_2023_Assignment_1_solution.pdf
Recommended textbooks for you
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS