Python Daily
2.57K subscribers
1.48K photos
53 videos
2 files
38.9K links
Daily Python News
Question, Tips and Tricks, Best Practices on Python Programming Language
Find more reddit channels over at @r_channels
Download Telegram
My django related question got me a badge on Stacko!

/r/django
https://redd.it/7m1e8u
Django Rest API - writing to FK based

I have two models as below:

class University(models.Model):
name = models.CharField(max_length=50)

class Meta:
verbose_name = "University"
verbose_name_plural = "Universities"

def __str__(self):
return self.name

def __unicode__(self):
return self.name


class Student(models.Model):
first_name = models.CharField(max_length=50)
last_name = models.CharField(max_length=50)
university = models.ForeignKey(University, on_delete = models.SET_NULL, null = True)

class Meta:
verbose_name = "Student"
verbose_name_plural = "Students"

def __str__(self):
return '%s %s' % (self.first_name, self.last_name)

def __unicode__(self):
return '%s %s' % (self.first_name, self.last_name)



class UniversitySerializer(serializers.ModelSerializer):
class Meta:
model = University
fields = '__all__'

class StudentSerializer(serializers.ModelSerializer):
university = serializers.SlugRelatedField(slug_field = 'name', queryset = University.objects.all())

class Meta:
model = Student
fields = '__all__'

I want to be able to access the forms that are generated by the browsable API in angularJS or any of the front end frameworks.

Can someone please nudge me into the right direction?

It's something most likely very simple however, I am lost as I am very new to this.

Many thanks in advance

/r/djangolearning
https://redd.it/7lw5xb
Any idea on how to implement forest with Function based views? (beginner here)

I want to implement formset to add manytomanyfield in one class table. how can i achieve it? I [found one](https://medium.com/@adandan01/django-inline-formsets-example-mybook-420cc4b6225d) but it is using class based views, and i don't understand it yet.

can you help me here?

/r/djangolearning
https://redd.it/7lv0um
Anyone have any tricks to understanding and using classes in Python? I keep writing functions, instead. Why should I start using classes?



/r/Python
https://redd.it/7m4hlq
request.url

I am trying to get the url using request.url. It prints out

http://127.0.0.1:5058/blah/blah

But my url has

localhost/blah/blah

How can I get localhost/blah/blah and not 127.0.0.1

/r/flask
https://redd.it/7m7lhm
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
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