Questions tagged [postgresql]
The postgresql tag has no usage guidance.
14
questions
0
votes
1
answer
145
views
How to use a PostgreSQL database using python CS50 library's SQL function?
I wanted to use the CS50 library's SQL function for interacting with a PostgreSQL database.
I have installed PostgreSQL on my computer and removed the need for passwords by modifying the .../Program ...
- 101
0
votes
0
answers
19
views
Join table seems showing an error
I tried this statement on the adminer postgreSql database online database query tool and works but when i try to code it into my FLASK app showing nothing.
lists = db.execute("SELECT b.isbn,b.author,...
- 1
0
votes
1
answer
219
views
postgresql syntax error
So this is part of the import.py code in project1:
db.execute("INSERT INTO books (isbn, title, author, year) VALUES (:isbn, :title, :author, :year)",
{"isbn": isbn, "title": title,...
- 418
0
votes
1
answer
79
views
Problem in importing from csv file
I am currently trying to import the contents of the books.csv file into my PostgreSQL database on Adminer.
Here's my code:
import csv
import os
from sqlalchemy import create_engine
from sqlalchemy....
- 146
0
votes
2
answers
306
views
adminer.cs50.net giving "Session expired, please login again." error when attempting to login
This seems to have happened 11 Sept 2019 but it is occurring again.
I tried logging into Adminer today and am receiving this error: "Session expired, please login again." I thought my Heroku ...
- 11
0
votes
1
answer
18
views
How to return a value while calculating between two columns from the same table in postgresql?
I'm trying to write a SQL query for Postgresql where I'm subtracting a value of a column in a row with that of another row in the same table and returning the result. I can use IS NULL in SQL, and ...
- 15
0
votes
1
answer
196
views
Unsure of what my DATABASE_URL is
I am using windows 10 (64-bit) and am following the course "Web Programming with python and Javascript" in CS50, in which i wanted to use my computer as a local host to store the table content. I am ...
- 101
0
votes
1
answer
1k
views
error while trying to update database using python and sqlalchemy
While I was trying to run create.py file having the following code:
import os
from flask import Flask, render_template, request
from models import *
app = Flask(__name__)
app.config["...
0
votes
1
answer
137
views
CS50 Web Programming: Lecture 3 (SQL)- import.py won't work for me
I'm trying to run the same code for import.py from the lecture, but am running into trouble.
import.py:
import csv
import os
from sqlalchemy import create_engine
from sqlalchemy.orm import ...
- 1
0
votes
3
answers
703
views
adminer.cs50.net Not working
Guys there has been a problem in the website : "https://adminer.cs50.net" I tried to login multiple times and keeps giving me the error: "Session expired, please login again."
could someone please ...
- 11
0
votes
1
answer
4k
views
Issue with psycopg2 dependency - pg_config executable not found on Mac OS
For Project 1:
When running "pip3 install -r requirements.txt"
for the initial setup, I get an issue with the psycopg2 dependency:
Error: pg_config executable not found.
pg_config is required to ...
- 11
0
votes
1
answer
718
views
AttributeError: __enter__
I defined a table in python using sqlalchemy but when i try to create it this error appears
0
votes
1
answer
563
views
SQL SELECT query for multiple word search
I'm working through project 1 in the CS50 Web Programming course. I have created a search form which is just one text box in the middle of the page where the user can type in the ISBN number, the ...
- 3
7
votes
7
answers
5k
views
CS50w - list.py - AttributeError: 'NoneType' object has no attribute '_instantiate_plugins'
I'm trying to run the list.py code on my Ubuntu machine, but I'm getting the following error:
AttributeError: 'NoneType' object has no attribute '_instantiate_plugins'
I looked at this post and it ...
- 73