Skip to content
This repository has been archived by the owner on Nov 23, 2023. It is now read-only.

Latest commit

 

History

History
46 lines (31 loc) · 1.62 KB

README.md

File metadata and controls

46 lines (31 loc) · 1.62 KB
Raw

Functionality

Our application support reading a CSV file that contains keywords separated by a comma. Then analyze the google search and return:

  • Total links on the search page
  • Total advertises on the search page
  • Total results with the keyword
  • HTML of the page (You also can preview it)

Versioning

We use the following library with version:

  • Ruby - 3.0.0
  • Rails - 7.0.3
  • psql (PostgreSQL) - 14.5

Setup and run application

  1. Clone project: git clone https://github.com/sanG-github/Search-Analytics.git
  2. Install Gem: bundle install
  3. Using your credentials with the example: .env.example
    1. With JWT_SECRET_KEY, generated by bin/rails secret
  4. Setup database: bin/rails db:create db:migrate
  5. Precompile: rake assets:precompile
  6. Run server: rails server
  7. Run sidekiq: bundle exec sidekiq

Database design

Screen Shot 2022-09-16 at 21.10.41.png

  • users store information of the user
  • attachments store the name and contents of the file after removing duplicate keyword
  • results store the necessary datas (like the numbers)
  • source_codes store source code of the Advertisement, Links, and HTML code of the Google search page. That needs to be separated because it contains large data.

About index, please take a look at the db/schema.rb