Nothing
Code
pixar_dm %>% build_copy_queries(src_db, .) %>% as.list()
Output
$name
[1] "pixar_films" "academy" "box_office" "genres"
[5] "public_response"
$remote_name
pixar_films academy box_office genres
"pixar_films" "academy" "box_office" "genres"
public_response
"public_response"
$columns
$columns[[1]]
[1] "number" "film" "release_date" "run_time" "film_rating"
$columns[[2]]
[1] "film" "award_type" "status"
$columns[[3]]
[1] "film" "budget" "box_office_us_canada"
[4] "box_office_other" "box_office_worldwide"
$columns[[4]]
[1] "film" "genre"
$columns[[5]]
[1] "film" "rotten_tomatoes" "metacritic" "cinema_score"
[5] "critics_choice"
$sql_table
<SQL> CREATE TEMPORARY TABLE "pixar_films" (
"number" TEXT,
"film" TEXT,
"release_date" DATE,
"run_time" DOUBLE PRECISION,
"film_rating" TEXT,
PRIMARY KEY ("film")
)
<SQL> CREATE TEMPORARY TABLE "academy" (
"film" TEXT,
"award_type" TEXT,
"status" TEXT,
PRIMARY KEY ("film", "award_type"),
FOREIGN KEY ("film") REFERENCES "pixar_films" ("film")
)
<SQL> CREATE TEMPORARY TABLE "box_office" (
"film" TEXT,
"budget" DOUBLE PRECISION,
"box_office_us_canada" DOUBLE PRECISION,
"box_office_other" DOUBLE PRECISION,
"box_office_worldwide" DOUBLE PRECISION,
PRIMARY KEY ("film"),
FOREIGN KEY ("film") REFERENCES "pixar_films" ("film")
)
<SQL> CREATE TEMPORARY TABLE "genres" (
"film" TEXT,
"genre" TEXT,
PRIMARY KEY ("film", "genre"),
FOREIGN KEY ("film") REFERENCES "pixar_films" ("film")
)
<SQL> CREATE TEMPORARY TABLE "public_response" (
"film" TEXT,
"rotten_tomatoes" DOUBLE PRECISION,
"metacritic" DOUBLE PRECISION,
"cinema_score" TEXT,
"critics_choice" DOUBLE PRECISION,
PRIMARY KEY ("film"),
FOREIGN KEY ("film") REFERENCES "pixar_films" ("film")
)
$sql_index
$sql_index[[1]]
NULL
$sql_index[[2]]
<SQL> CREATE INDEX academy__film ON "academy" ("film")
$sql_index[[3]]
<SQL> CREATE INDEX box_office__film ON "box_office" ("film")
$sql_index[[4]]
<SQL> CREATE INDEX genres__film ON "genres" ("film")
$sql_index[[5]]
<SQL> CREATE INDEX public_response__film ON "public_response" ("film")
$index_name
$index_name[[1]]
NULL
$index_name[[2]]
[1] "academy__film"
$index_name[[3]]
[1] "box_office__film"
$index_name[[4]]
[1] "genres__film"
$index_name[[5]]
[1] "public_response__film"
Code
dm_for_filter() %>% collect() %>% build_copy_queries(src_db, .) %>% as.list()
Output
$name
[1] "tf_1" "tf_3" "tf_6" "tf_2" "tf_4" "tf_5"
$remote_name
tf_1 tf_3 tf_6 tf_2 tf_4 tf_5
"tf_1" "tf_3" "tf_6" "tf_2" "tf_4" "tf_5"
$columns
$columns[[1]]
[1] "a" "b"
$columns[[2]]
[1] "f" "f1" "g"
$columns[[3]]
[1] "zz" "n" "o"
$columns[[4]]
[1] "c" "d" "e" "e1"
$columns[[5]]
[1] "h" "i" "j" "j1"
$columns[[6]]
[1] "ww" "k" "l" "m"
$sql_table
<SQL> CREATE TEMPORARY TABLE "tf_1" (
"a" SERIAL,
"b" TEXT,
PRIMARY KEY ("a")
)
<SQL> CREATE TEMPORARY TABLE "tf_3" (
"f" TEXT,
"f1" INTEGER,
"g" TEXT,
PRIMARY KEY ("f", "f1")
)
<SQL> CREATE TEMPORARY TABLE "tf_6" (
"zz" INTEGER,
"n" TEXT,
"o" TEXT,
PRIMARY KEY ("o"),
UNIQUE ("n")
)
<SQL> CREATE TEMPORARY TABLE "tf_2" (
"c" TEXT,
"d" INTEGER,
"e" TEXT,
"e1" INTEGER,
PRIMARY KEY ("c"),
FOREIGN KEY ("d") REFERENCES "tf_1" ("a"),
FOREIGN KEY ("e", "e1") REFERENCES "tf_3" ("f", "f1")
)
<SQL> CREATE TEMPORARY TABLE "tf_4" (
"h" TEXT,
"i" TEXT,
"j" TEXT,
"j1" INTEGER,
PRIMARY KEY ("h"),
FOREIGN KEY ("j", "j1") REFERENCES "tf_3" ("f", "f1")
)
<SQL> CREATE TEMPORARY TABLE "tf_5" (
"ww" INTEGER,
"k" INTEGER,
"l" TEXT,
"m" TEXT,
PRIMARY KEY ("k"),
FOREIGN KEY ("m") REFERENCES "tf_6" ("n"),
FOREIGN KEY ("l") REFERENCES "tf_4" ("h") ON DELETE CASCADE
)
$sql_index
$sql_index[[1]]
NULL
$sql_index[[2]]
NULL
$sql_index[[3]]
NULL
$sql_index[[4]]
<SQL> CREATE INDEX tf_2__d ON "tf_2" ("d")
<SQL> CREATE INDEX tf_2__e_e1 ON "tf_2" ("e", "e1")
$sql_index[[5]]
<SQL> CREATE INDEX tf_4__j_j1 ON "tf_4" ("j", "j1")
$sql_index[[6]]
<SQL> CREATE INDEX tf_5__m ON "tf_5" ("m")
<SQL> CREATE INDEX tf_5__l ON "tf_5" ("l")
$index_name
$index_name[[1]]
NULL
$index_name[[2]]
NULL
$index_name[[3]]
NULL
$index_name[[4]]
[1] "tf_2__d" "tf_2__e_e1"
$index_name[[5]]
[1] "tf_4__j_j1"
$index_name[[6]]
[1] "tf_5__m" "tf_5__l"
Code
as.list(queries)
Output
$name
[1] "parent1" "parent2" "child" "child__a"
$remote_name
$remote_name$parent1
<Id> table = parent1
$remote_name$parent2
<Id> table = parent2
$remote_name$child
<Id> table = child
$remote_name$child__a
<Id> table = child__a
$columns
$columns[[1]]
[1] "key"
$columns[[2]]
[1] "a__key"
$columns[[3]]
[1] "a__key"
$columns[[4]]
[1] "key"
$sql_table
<SQL> CREATE TEMPORARY TABLE "parent1" (
"key" DOUBLE PRECISION,
PRIMARY KEY ("key")
)
<SQL> CREATE TEMPORARY TABLE "parent2" (
"a__key" DOUBLE PRECISION,
PRIMARY KEY ("a__key")
)
<SQL> CREATE TEMPORARY TABLE "child" (
"a__key" DOUBLE PRECISION,
FOREIGN KEY ("a__key") REFERENCES "parent2" ("a__key")
)
<SQL> CREATE TEMPORARY TABLE "child__a" (
"key" DOUBLE PRECISION,
FOREIGN KEY ("key") REFERENCES "parent2" ("a__key")
)
$sql_index
$sql_index[[1]]
NULL
$sql_index[[2]]
NULL
$sql_index[[3]]
<SQL> CREATE INDEX child__a__key ON "child" ("a__key")
$sql_index[[4]]
<SQL> CREATE INDEX child__a__key__1 ON "child__a" ("key")
$index_name
$index_name[[1]]
NULL
$index_name[[2]]
NULL
$index_name[[3]]
[1] "child__a__key"
$index_name[[4]]
[1] "child__a__key__1"
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.