Skip to content

Instantly share code, notes, and snippets.

@hunt3ri
Created May 29, 2017 22:16
Show Gist options
  • Save hunt3ri/cbc80239cdc28775fe3c06da57042759 to your computer and use it in GitHub Desktop.
Save hunt3ri/cbc80239cdc28775fe3c06da57042759 to your computer and use it in GitHub Desktop.
Create sports article table
CREATE TABLE IF NOT EXISTS sports_articles(
id BIGSERIAL PRIMARY KEY,
title VARCHAR(100),
article VARCHAR(2000));
Insert into sports_articles (title, post) values('Francesco Totti brings down curtain on "something beautiful" at Roma', 'Francesco Totti tried to raise a smile. Striding out on to the Stadio Olimpico pitch for a farewell address at the end of his last-ever match for Roma, he shushed the home crowd and then teased that staying quiet “ought to be easy for you”.');
Insert into sports_articles (title, post) values('Brendan Rodgers pays tribute to Barcelona after Celtic are thrashed', 'Brendan Rodgers said that Barcelona “beat you up with the ball” on a night on which he likened the Camp Nou pitch to an ice-rink, the game whizzing past his helpless players. Celtic fell to a 7-0 defeat but their manager insisted that there was “no embarrassment” and that he could not have asked for any more from his team.');
Insert into sports_articles (title, post) values('Arsenal board expected to rubber stamp Arsène Wenger’s new two-year deal', 'The Arsenal board is set to rubber stamp Arsène Wenger’s new two-year contract when they meet on Tuesday morning, as part of a detailed discussion about the club’s direction. Wenger’s future feels as though it ought to be at the top of the agenda, since the subject has dominated the season, but vying for prominence will be an examination of budgets, which will take in how much the manager has to spend on transfers over the summer.');
Insert into sports_articles (title, post) values('Brendan Rodgers targets European progress after Celtic’s domestic treble', 'No sooner had Celtic completed their domestic treble by defeating Aberdeen in the Scottish Cup final than discussion moved towards what exactly Brendan Rodgers can do next. Celtic are believed to be keen on four players – a centre-back, midfielder, winger and striker – as they plan for the new campaign.');
Insert into sports_articles (title, post) values('Barcelona confirm Ernesto Valverde as new manager at Camp Nou', 'Barcelona have confirmed Ernesto Valverde as their new manager following Luis Enrique’s departure.
Valverde, 53, stepped down from his role in charge of Athletic Bilbao last week having led the Basque club to seventh place in La Liga and Europa League qualification.');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment