quda
Exqlite - make it work with existing Sqlite db
Hi,
I need to do the following tasks for me project using Sqlite3 existing dbs (files):
- connect to each of the Sqlite db/files in the repository
- list all the tables in the db.
- select (filter) some tables of interest
- for selected tables execute one query to extract some data (a very simple query such as SELECT items FROM table WHERE condition)
- return a map with all the collected results
So far, I managed (with difficulties) to install and configure Exqlite into the project.
I tried to follow the documentation Readme — Exqlite v0.38.0 and did:
{:ok, conn} = Exqlite.Sqlite3.open("path_to_one_db")
:ok = Exqlite.Sqlite3.execute(conn, "SELECT name FROM sqlite_master WHERE "type"='table'");
…and I got stuck. I don’t know how to use this library further on. The documentation is not very clear. There are no examples/tutorial online.
Next step is to get the list with the tables in the db.
Thanks for your help,
T.
PS: As you might have noted, I am quite new to Elixir. 
Marked As Solved
kwando
Yep, I noticed that too. But I dont think it will be very hard to guess how it works 
{:ok, db} = Exqlite.Basic.open(":memory:")
db
|> Exqlite.Basic.exec("create table books (title, author)")
db
|> Exqlite.Basic.exec("insert into books (title, author) values (?, ?)", ["test", "bob"])
db
|> Exqlite.Basic.exec("select * from books")
|> Exqlite.Basic.rows()
Results in this
{:ok, [["test", "bob"]], ["title", "author"]}
Also Liked
LostKobrakai
It might be worth looking at using exqlite through ecto, which is quite well documented.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"