go-jobscraper/notes.md

Notes

• Test Link https://www.jobserve.com/MySearch/F3A56475D5FD4966.rss

LocationRegex

[Ll]ocation:(?:<\/span>)?\n*(.*?)&nbsp;
Location:<\/strong><\/td><td width="50">&nbsp;<\/td><td>(.*?)<\/td>

RateRegex

[Rr]ate:(?:<\/span>)?\n*(.*?)&nbsp;
Rate:<\/strong><\/td><td width="50">&nbsp;<\/td><td>(.*?)<\/td>

Company Regex

Advertiser:<\/strong><\/td><td width="50">&nbsp;<\/td><td>(.*?)<\/td>

Location regex

Location:<\/strong><\/td><td width="50">&nbsp;<\/td><td>(.*?)<\/td>

Image regex

src="https:\/\/(.+?)"

-- jobs definition

CREATE TABLE "jobs" (
	"_id"	INTEGER NOT NULL UNIQUE,
	"title"	TEXT,
	"site"	TEXT,
	"url"	TEXT,
	"id"	TEXT UNIQUE,
	"summary"	TEXT,
	"company"	TEXT,
	"location"	TEXT,
	"postdate"	TEXT,
	"salary"	TEXT,
	"easyapply"	INTEGER,
	"timestamp"	INTEGER,
	PRIMARY KEY("_id" AUTOINCREMENT)
);

CREATE TABLE jobs (
	_id SERIAL PRIMARY KEY,
	title VARCHAR,
	site VARCHAR,
	url VARCHAR,
	id VARCHAR UNIQUE,
	summary TEXT,
	company VARCHAR,
	location VARCHAR,
	postdate VARCHAR,
	salary VARCHAR,
	easyapply INTEGER,
	"timestamp" INTEGER
);