brownan / g2 Goto Github PK

In addition to the current limit on the number of songs on the playlist, I want to define time limits as well:

Hard limit: A user can never occupy more than this many minutes of song time on the playlist

Soft limit: A user may add a song that causes their total time to exceed this limit, but they cannot add any more songs after that.

The reasoning is, if a user adds a 2 hour mix, they shouldn't be able to add any more songs. However, a user should still be able to add several shorter songs (up to a limit). The hard limit could be something like 2 hours, and the soft limit could be more like 30 or 45 minutes.

So they don't reload the page, making it easier to add more than one song at a time

python manage syncdb fails,

E.g. with sqlite3:

~/radio_www/pydj$ python manage.py syncdb
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table playlist_artist
Creating table playlist_album
Creating table playlist_rating
Creating table playlist_userprofile_favourites
Creating table playlist_userprofile
Creating table playlist_editnote
Creating table playlist_fieldedit
Creating table playlist_songedit
Creating table playlist_songreport
Creating table playlist_song
Creating table playlist_songdir
Creating table playlist_emoticon
Creating table playlist_comment
Creating table playlist_playlistentry
Creating table playlist_removedentry
Creating table playlist_oldplaylistentry
Creating table playlist_settings
Creating table playlist_series
Creating table playlist_show
Creating table playlist_oldshow
Creating table playlist_showrating
Creating table playlist_showcomment
Creating table playlist_showminute
Creating table forum_category
Creating table forum_forum_groups
Creating table forum_forum
Creating table forum_thread
Creating table forum_post
Creating table forum_subscription
Creating table forum_lastread

You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Username (Leave blank to use 'andi'): test
E-mail address: [email protected]
Password:
Password (again):
Superuser created successfully.
Traceback (most recent call last):
File "manage.py", line 11, in
execute_manager(settings)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/init.py", line 438, in execute_manager
utility.execute()
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/init.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv
self.execute(_args, *_options.dict)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute
output = self.handle(_args, *_options)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle
return self.handle_noargs(**options)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 109, in handle_noargs
emit_post_sync_signal(created_models, verbosity, interactive, db)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/sql.py", line 190, in emit_post_sync_signal
interactive=interactive, db=db)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 172, in send
response = receiver(signal=self, sender=sender, **named)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/contrib/auth/management/init.py", line 51, in create_permissions
content_type=ctype
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/manager.py", line 138, in create
return self.get_query_set().create(**kwargs)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/query.py", line 360, in create
obj.save(force_insert=True, using=self.db)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save
self.save_base(using=using, force_insert=force_insert, force_update=force_update)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/base.py", line 553, in save_base
result = manager._insert(values, return_id=update_pk, using=using)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/manager.py", line 195, in _insert
return insert_query(self.model, values, **kwargs)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/query.py", line 1436, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 791, in execute_sql
cursor = super(SQLInsertCompiler, self).execute_sql(None)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
cursor.execute(sql, params)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute
return self.cursor.execute(sql, params)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 234, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.IntegrityError: columns content_type_id, codename are not unique

Hi,

Crash is only with sqlite3, mysql is ok.
Select 'Artists' from menu then a specific artist - it crashes with: