Adventure works importer
Mix.install([
{:kino_db, "~> 0.2.1"},
{:postgrex, "~> 0.16.3"}
])
Section
opts = [
hostname: "localhost",
port: 5432,
username: "kuku",
password: "",
database: "Adventureworks"
]
{:ok, conn} = Kino.start_child({Postgrex, opts})
result2 =
Postgrex.query!(
conn,
"""
SELECT *
FROM information_schema.columns
WHERE table_name = 'person'
""",
[]
)
result3 = Postgrex.query!(conn, "SELECT demographics::text from person.person limit 5 ", [])
result4 =
Postgrex.query!(
conn,
"""
SELECT a.attname,
pg_catalog.format_type(a.atttypid, a.atttypmod),
(SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid, true)
FROM pg_catalog.pg_attrdef d
WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef),
a.attnotnull,
(SELECT c.collname FROM pg_catalog.pg_collation c, pg_catalog.pg_type t
WHERE c.oid = a.attcollation AND t.oid = a.atttypid AND a.attcollation <> t.typcollation) AS attcollation,
a.attidentity,
a.attgenerated
FROM pg_catalog.pg_attribute a
WHERE a.attrelid = '517744' AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum;
""",
[]
)