Questions tagged [mashup.db]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
549 views

Error Building SQLite Query Programmatically: TypeError: execute() takes 2 positional arguments but 3 were given

I'm trying to build a sqlite query programmatically by building a string that I pass to db.execute. query = "SELECT * FROM places WHERE postal_code LIKE :q" result = db.execute(query, q=q) This ...
0
votes
1answer
161 views

can't import US.txt into places

PSET 8 Mashup: I am not able to run the following commands as given by the problem set: $ sqlite3 mashup.db .separator "\t" .import US.txt places I've tried multiple ways, I am certainly in the same ...
0
votes
1answer
712 views

How to insert data from a txt file to specific SQLite table column

I am trying to make the search function in mashup more versatile by creating a new column in my SQLite places table called full_location where it will hold the postal_code, place_name, and admin_name1 ...
0
votes
1answer
206 views

pset8/mashup.db

I am working on pset8/mashup.db and seem to be stuck into this for long. Actually the documentation per CS50 says that we should consider reading readme.txt and US.txt for finding the data types for ...