Skip to content

Instantly share code, notes, and snippets.

@robertlevonyan

robertlevonyan/movies.sq

Last active March 4, 2021 08:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save robertlevonyan/00bb20e8b5ec34b60ca52bbe89be2f31 to your computer and use it in GitHub Desktop.
Save robertlevonyan/00bb20e8b5ec34b60ca52bbe89be2f31 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
movies.sq
import java.util.Date;
CREATE TABLE Movie(
id INTEGER PRIMARY KEY,
backdropPath TEXT,
posterPath TEXT,
title TEXT,
overview TEXT,
releaseDate TEXT as Date
);
selectAll:
SELECT *
FROM Movie;
insert:
INSERT OR IGNORE INTO Movie(id, backdropPath, posterPath, title, overview, releaseDate)
VALUES ?;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment