I am getting an error when i try to POST some data with my flask app.
here is my sqlalchemy class with 3 fields, and the corresponding schema class :
class Plant(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
dur = db.Column(db.Integer)
def __init__(self, name, dur):
self.name = name
self.dur = dur
class PlantSchema(ma.SQLAlchemySchema):
class Meta:
model = Plant
Here is the POST request in app.py, in order to add a plant model to my database :
plant_schema = PlantSchema()
@app.route('/plants', methods=['POST'])
def add_plant():
name = request.json.get('name', '')
dur = request.json.get('dur', '')
plant = Plant(name=name, dur=dur)
db.session.add(plant)
db.session.commit()
return plant_schema.jsonify(plant)
unfortunately, when i POST my request in Postman, i get the following
<head>
<title>ModuleNotFoundError: No module named 'MySQLdb'
</title>...
When i try to pip install mysqlclient ( which is the recommended fix ), i get :
Collecting mysqlclient
Using cached mysqlclient-2.1.0.tar.gz (87 kB)
Preparing metadata (setup.py) ... error
error: subprocess-exited-with-error
× python setup.py egg_info did not run successfully.
│ exit code: 1
╰─> [16 lines of output]
/bin/sh: mysql_config: command not found
/bin/sh: mariadb_config: command not found
/bin/sh: mysql_config: command not found
Traceback (most recent call last):
File "<string>", line 2, in <module>
File "<pip-setuptools-caller>", line 34, in <module>
File "/private/var/folders/j5/b194wjbn32sbqct7crpvcp2w0000gn/T/pip-install-ijejonzz/mysqlclient_841539cf1eed4511a135f8e95cb2be75/setup.py", line 15, in <module>
metadata, options = get_config()
File "/private/var/folders/j5/b194wjbn32sbqct7crpvcp2w0000gn/T/pip-install-ijejonzz/mysqlclient_841539cf1eed4511a135f8e95cb2be75/setup_posix.py", line 70, in get_config
libs = mysql_config("libs")
File "/private/var/folders/j5/b194wjbn32sbqct7crpvcp2w0000gn/T/pip-install-ijejonzz/mysqlclient_841539cf1eed4511a135f8e95cb2be75/setup_posix.py", line 31, in mysql_config
raise OSError("{} not found".format(_mysql_config_path))
OSError: mysql_config not found
mysql_config --version
mariadb_config --version
mysql_config --libs
[end of output]
note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed
if the problem is not with pip, im not sure what else to try?
