Any Django Expert I can have a chat with?

I have been making websites with Django for almost a year now, and needed a professional ~~mentor~~ to talk to.

if you can help or are free, please comment or message me.

/r/djangolearning
https://redd.it/7m7xlb

At my wits end debugging this SQL syntax error

I'm making a web application in Django, using a MySQL server for the database, and I keep getting a message that I have an error in my SQL syntax. I'm not writing any SQL queries. Django is doing that for me. I tried recreating the migration files and database, and I still get the same error, so I figure there must be an error in my models.py file, but I can't find it. The crazy part is, I'm working with a commit from a few days ago, and I don't remember getting this error then.

Does anyone know what I might be doing wrong?

Here's my repository on GitHub:
https://github.com/WolfElkan/hst3

And here's the error I'm getting, along with the full traceback:

Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying auth.0007_alter_validators_add_error_messages... OK
Applying auth.0008_alter_user_username_max_length... OK
Applying main.0001_initial...Traceback (most recent call last):
File "manage.py", line 22, in <module>
execute_from_command_line(sys.argv)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/core/management/__init__.py", line 367, in execute_from_command_line
utility.execute()
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/core/management/__init__.py", line 359, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/core/management/base.py", line 294, in run_from_argv
self.execute(*args, **cmd_options)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/core/management/base.py", line 345, in execute
output = self.handle(*args, **options)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 204, in handle
fake_initial=fake_initial,
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/migrations/executor.py", line 115, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/migrations/executor.py", line 145, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/migrations/executor.py", line 244, in apply_migration
state = migration.apply(state, schema_editor)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/migrations/migration.py", line 129, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/migrations/operations/models.py", line 96, in database_forwards
schema_editor.create_model(model)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/backends/base/schema.py", line 295, in create_model
s

elf.execute(sql, params or None)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/backends/base/schema.py", line 112, in execute
cursor.execute(sql, params)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/backends/utils.py", line 62, in execute
return self.cursor.execute(sql)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 110, in execute
return self.cursor.execute(query, args)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/Users/Wolf/Desktop/Education/CodingDojo/PYTHON/myEnvironments/djangoEnv/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() NOT NULL, `birthday` date NOT NULL, `grad_year` numeric(4, 0) NULL, `height` ' at line 1")


/r/django
https://redd.it/7m95tl

What's everyone working on this week?

Tell /r/python what you're working on this week! You can be bragging, grousing, sharing your passion, or explaining your pain. Talk about your current project or your pet project; whatever you want to share.


/r/Python
https://redd.it/7m7xmi

Video sharing platform in Flask

For the last month, I've been working on a Video Sharing Platform, a bit like YouTube.

Uses can upload videos and flag videos uploaded by other users. There's a dashboard page where they can see their view count and few settings to change password and delete account.

Upvotes and downvotes will be added soon.

Administrators can delete users and flagged videos if necessary.

I would be grateful if you could look at it and provide me with any feedback on how to make it better or more efficient.

P.S. - The video uploading is synchronous at the moment. Can't seem to get it work asynchronously.

[Github Link](https://github.com/sharadbhat/Video-Sharing-Platform)

/r/flask
https://redd.it/7m9ca1

PyPy2.7 and PyPy3.5 v5.10 dual release
https://morepypy.blogspot.fr/2017/12/pypy27-and-pypy35-v510-dual-release.html

/r/Python
https://redd.it/7m73nr

Notes on CPython Lists
https://rcoh.svbtle.com/notes-of-cpython-lists

/r/Python
https://redd.it/7m909a

10 Tips for Upgrading to Django 2.0
http://eldarion.com/blog/2017/12/26/10-tips-upgrading-django-20/

/r/django
https://redd.it/7mawy8

Run python script daily?

Hello!

I created a python script to check whether or not there are any new albums released by the artists in my public playlists on Spotify using the spotipy api (https://github.com/plamere/spotipy).

However I need to run the script daily in order for it to check if there are any new albums available and email me if so. What would be the easiest and cheapest way to run this program daily? The program works by saving the current days dictionary which has the artist as the key and the number of albums as the value to a csv file. It then reads in the previous days csv file and compares them.

Basically what is the easiest way to run this program once a day where I can store and load csv files as well? I have been trying to find something to what I need but I cannot. Any tutorial links or advice would be appreciated.

Thank you in advance!

/r/Python
https://redd.it/7mc15g

MongoDB support to Django by transpiling SQL queries to MongoDB query
https://github.com/nesdis/djongo

/r/django
https://redd.it/7mdh56

Introduction to NumPy and Pandas - A Simple Tutorial
https://cloudxlab.com/blog/numpy-pandas-introduction/

/r/Python
https://redd.it/7mdn56

After trying to learn from multiple tutorials I’m so frustrated. I’ll pay someone to tutor me.

Pm me your rates. Must speak English. I have hosting and already know python.

/r/djangolearning
https://redd.it/7lpzcy

Add more or remove Feature with ManyToManyField?

[take this link for example,](https://bootsnipp.com/snippets/featured/dynamic-form-fields-add-amp-remove) I want to implement on my site.

I am using Many to Many field, which is connected to a different table, I have explained the issue [here](https://www.reddit.com/r/django/comments/7l88th/how_to_implement_manytomany_field_in_front_end/)
https://www.reddit.com/r/django/comments/7l88th/how_to_implement_manytomany_field_in_front_end/.

can someone help me here?

/r/djangolearning
https://redd.it/7lnmly

django-admin.py or django-admin without .py?

When I first started using Django, I picked up the habit of writing

django-admin.py startproject my_project .

Now I'm seeing this written without the .py:

django-admin startproject my_project .

I noticed this changed in the tutorial starting with Django 1.8, but keeping the .py works on my system in 2.0.

Is there a clear recommendation to use the `django-admin` command without the .py?

/r/django
https://redd.it/7mg8q7

Microsoft Considers Adding Python as an Official Scripting Language to Excel
https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-python-as-an-official-scripting-language-to-excel/

/r/Python
https://redd.it/7mebxa

Best Python setup for young programmer

We got my young (13 y/o) sibling (who has a strong math interest) a computer, so naturally I bought the [Python for Kids](https://www.nostarch.com/pythonforkids) book (as well as [Doing Math With Python](https://www.nostarch.com/doingmathwithpython)).

The problem now is the python setup. I initially installed Anaconda and PyCharm, but realized that it was a bit more complicated (for a 13 year old) that I anticipated (virtual environments and what-not).

Whats the recommended python setup for kids (on windows 10). Im assuming IDLE? But what about installing modules? Is there any super user friendly IDE (or the like) software that they can use?

Edit: the issue isn't editing code, Notepad++, atom, sublime, or any of non-IDE text editors should do fine. The issue is easily (think push-button) running the code. I learned C/C++ on Bloodshead C++ IDE if that gives a better picture of what I'm thinking.

/r/Python
https://redd.it/7mhs16

Webapp with DRF: ending up with too many view-specific serializers?

As stated in the title, my webapp is built on DRF, and though I **love** how easy serializers are to use, I feel like I'm almost creating specialized serializers for the data each view needs. The alternative seems to be to have one serializer that returns an overkill amount of data and have the front end deal with sorting out what it needs vs doesnt need.

for example: I have a Client (C) model and it has a related OnboardingStatus (OS) model and a AccountStatistics (AS) model. I can either make 3 serializers to send C alone/C+OS/C+AS
**OR** I can make 1 serializer that sends C+OS+AS all the time. (I simplified here, my data is bigger and a bit more nested)

How do the fine redditors of /r/django deal with this issue? Is there a smarter way that I'm not seeing?

/r/django
https://redd.it/7me9f8

Dramatiq: Fast, Reliable, and Simple Distributed Task Queue for Python 3 (Interview)
https://www.podcastinit.com/dramatiq-with-bogdan-popa-episode-141/

/r/Python
https://redd.it/7mgbi5

[D] Superhuman AI for heads-up no-limit poker: Libratus beats top professionals
https://youtu.be/2dX0lwaQRX0

/r/MachineLearning
https://redd.it/7mg73w

[P] Uncanny Road
http://uncannyroad.com/

/r/MachineLearning
https://redd.it/7mj4sk

Matplot lib - how to replicate Exzel ability to display (x,y) when you mouse over a data point?

Is this even a possibility? Thanks.

/r/Python
https://redd.it/7mjv0j