aboutsummaryrefslogtreecommitdiffstats
path: root/mediagoblin/db/migrations.py
Commit message (Collapse)AuthorAgeFilesLines
* Fix some unused imports and local variables.Ben Sturmfels2021-09-231-5/+3
|
* Apply pyupgrade --py36-plus.Ben Sturmfels2021-09-231-2/+2
| | | | This removes some 'u' prefixes and converts simple format() calls to f-strings.
* Remove remaining imports/calls to six not automatically removed by pyupgrade.Ben Sturmfels2021-03-051-2/+0
|
* Apply `pyupgrade --py3-plus` to remove Python 2 compatibility code.Ben Sturmfels2021-03-051-22/+21
|
* migrations: Only don't import "migrate" if it's not availableChristopher Allan Webber2016-03-291-1/+9
| | | | | * mediagoblin/db/migrations.py: Import migrate if available; if not print a warning.
* Fix a typo in consolidate_reports migrationJessica Tallon2016-02-291-1/+1
|
* Fix #5369 - Broken activities cause issues in migrationsJessica Tallon2016-01-061-6/+85
| | | | | | | | | | | This fixes a few bugs in previous migrations and then also introduces a new migration for those who had run the previous migrations without encountering the bugs to ensure that the database is in the same state as those who ran it after the bug fixes introduced in this commit. The commit also ensures that all activities are valid, they should be but they might not be so checks, from now on we should be able to assume that all activities will always be valid.
* Fix a exception db closed exception in migrationsJessica Tallon2015-12-291-6/+6
| | | | | | | Some sqlite migrations were failing due to some problems with sqlite. A work around has been created for these however it does involve loading lots of data into memory. If you have a large database you should consider trying to move to postgres.
* Fix migrations of activity intermediatorsJessica Tallon2015-12-291-11/+11
| | | | | | | There was a problem where it was assuming the tablenames are the same in master as they always were and that isn't the case. This would cause it to raise an exception when trying to look up a table which didn't exist. This fixes that by hardcoding the old tablenames in for this migration.
* Fix #5368 - Improve test efficiancyJessica Tallon2015-12-291-4/+5
| | | | | | | | There were a number of tests where lots of models where being iterated through and then at the end committing them. The problem is all the changes had to be kept in memory or on disk somewhere before they were commit to the database. This fix commits each change as it's being made, allowing resources to be freed and fixing some of the inefficiencies
* Comment changes for federationJessica Tallon2015-10-201-4/+269
| | | | | | | | | | | | | | This adds a new Comment link table that is used to link between some object and then the comment object, which can be more or less any object in Mediagoblin. The MediaComment has been renamed to TextComment as that more aptly describes what it is. There is migrations for these changes. There is also the conslidation of the Report tables into a single Report table, the same with the Notification objects. This is because both of them split out MediaEntry and Comment versions into their own polymorphic versions from a base, this is no longer a meaningful distinction as comments can be anything.
* Add public_id fixes throughout the codeJessica Tallon2015-10-071-0/+29
| | | | | | | | This adds several things, mainly code which checks for the public id and if it doesn't exist generating it where it can. This is to because we need to keep the public_id to be able to effectively soft delete models. This also adds a public_id field to the Activity along with a migration.
* Add Graveyard modelJessica Tallon2015-10-071-57/+16
| | | | | | | | | | This adds the Graveyard model which is used when a model is deleted, it stores the important "shell" information on the model so it can hard-delete the real object. It also remaps the GenericModelReference references to the new Graveyard model. This also moves the soft deletion setting from __model_args__ to "deletion_mode" on the model.
* Add the __model_args__ deletion codeJessica Tallon2015-10-071-0/+67
| | | | | | | | This adds the "deleted" fields to the models as well as a new __model_args__ section whcih supports the option for changing the deletion type. Deletion is now handled by choosing a deletion method based on the __model_args__["deletion"] setting, for example if it's soft deletion it will call Model.soft_delete()
* Collection changes and migration for federationJessica Tallon2015-10-071-0/+144
| | | | | | | - Adds a "type" column to the Collection object and allows the CollectionItem model to contain any object. - Changes "items" to "num_items" as per TODO - Renames "uploader", "creator" and "user" to a common "actor" in most places
* Fix some unit tests and bugsJessica Tallon2015-08-241-1/+2
| | | | | | | | | | | | | | | | | | This fixes a lot of the issues with the LocalUser changes that were merged recently. There was a problem where the attributes of LocalUser were not being eagerly loaded and because the Session was detached an exception was being raised when they were accessed. This also fixes some typo's which were introduced. Finally this adds a temporary fix for a potential SQLAlchemy bug, this is a bug where doing: User.query.filter(LocalUser.username == "some_username").first() does NOT yeild a user with the username "some_username" but all users on the site. The temp fix is to just query the LocalUser, this should be resolved when bug is confirmed and fixed upstream.
* Fix #5344 - OAuth NotImplemented exceptionJessica Tallon2015-08-211-0/+59
| | | | | | | | | | | | This introduces a migration which adds a dummy Client, RequestToken and AccessToken. These are used when an invalid request comes in, instead of bailing early, it needs dummy data to prevent timing attacks. This then implements the methods which get the IDs of the dummy objects. If these are changed in the future a migration which checks for the previous dummy object should be created and updates them to reflect the new IDs/tokens.
* Change structure of MediaEntry and add migrationJessica Tallon2015-08-191-3/+42
| | | | | | This makes the changes needed for federating MediaEntry objects as well as adding the migration and necessary methods to get the public_id just in time (JIT).
* Add the user models to the MODELS listJessica Tallon2015-07-311-9/+30
| | | | | | | | This adds the two new user models (LocalUser and RemoteUser) to the MODELS list that is in models.py. This stops the strange bug that occurs if you migrate a fresh database, the two models don't exist however migrating an existing database would create them as the migrations exist.
* Change codebase to query or create correct User modelJessica Tallon2015-07-311-0/+1
| | | | | | | The code base had many references to User.username and other specific to LocalUser attributes as that was the way it use to exist. This updates those to query on the generic User model but filtering by attributes on the LocalUser.
* Add polymorphic properties to UserJessica Tallon2015-07-311-3/+9
| | | | | | | | | | This adds the ability to search for any user based on the generic User case and be given back the specific LocalUser or RemoteUser. This will require any code using the model to look which attributes they are searching on and specify the specific User model they are on if they're not on the generic User model. This will also require new users to be created with LocalUser.
* Add LocalUser and RemoteUser and migrationJessica Tallon2015-07-311-0/+120
|
* Fix removal of ActivityIntermediatory migrationJessica Tallon2015-06-241-2/+19
| | | | | | | | | | The migration had a problem where other tables still referenced the migration as well as a typo in an earlier migration. They have both been fixed and tested on PostgreSQL and SQLite3. This also fixes a bug where sometimes when creating an activity it'd raise an Exception as the object hadn't got an ID. This has been fixed globally with a fix to the create_activity federation tool.
* Fix some problems with activity mixins and migrationsJessica Tallon2015-05-261-3/+3
|
* Add a more verbose GenericForeignKey implementationJessica Tallon2015-05-261-2/+2
|
* Add migration to remove ActivityIntermediatorJessica Tallon2015-05-261-3/+12
| | | | | Migration to drop the table and removal of it from the model as it has now been superseeded by the GenericForeignKey field.
* Migrate Activity to using the new GenericForeignKeyJessica Tallon2015-05-261-1/+140
|
* Add GenericForeignKey field and reference helper modelJessica Tallon2015-05-261-0/+15
|
* Fix the token issues in the migrationChristopher Allan Webber2015-02-171-3/+3
| | | | | | There's no .id on access/request token tables, so fixed to use the .token field. Also switched a reference of client_table -> rt_table
* acess_token->access_tokenChristopher Allan Webber2015-02-171-1/+1
|
* Fixing typo: notifiction->notificationChristopher Allan Webber2015-02-171-1/+1
|
* This one should be dt_to_utc, not db_to_utc, I believeChristopher Allan Webber2015-02-171-1/+1
|
* Fix #1065 - Migrate from native datetimes to UTCJessica Tallon2015-02-151-0/+126
|
* Merge branch 'location'Jessica Tallon2014-10-091-0/+37
|\ | | | | | | | | | | | | | | | | | | | | | | Add Location model which holds textual, geolocation coordiantes or postal addresses. This migrates data off Image model metadata onto the general Location model. It also adds the ability for location to be set on MediaEntry, User, MediaComment and Collection models. The geolocation plugin has been updated so that the location can be displayed in more general places rather than explicitely on the MediaEntry view. If GPS coordiantes are set for the User the profile page will also have the OSM provided by the geolocation plugin.
| * Add location model and migrationsJessica Tallon2014-10-091-0/+37
| |
* | Merge branch '905-activities'Jessica Tallon2014-10-071-2/+193
|\ \ | | | | | | | | | | | | | | | Add Activity and Generator models which allow for activities to be created. This now works with the feed API.
| * | Fix all the unit tests and clean up codeJessica Tallon2014-10-061-32/+42
| | |
| * | Only have Model.activity for activity compatable objects/targetsJessica Tallon2014-09-031-23/+13
| | |
| * | Fix migrations and refactor object_typeJessica Tallon2014-09-021-43/+105
| | | | | | | | | | | | | | | | | | | | | - Make changes to objectType to be more pythonic "object_type" - Move object_type to mixins rather than be on the models - Convert migrations to sqlalchemy core rather than ORM (fix) - Change TYPES to use descriptive strings rather than numbers
| * | Add ActivityIntermediator table and refactor some of Activity modelJessica Tallon2014-08-271-37/+108
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - This has introduced a intermediatory table between object/target and the activity. This allows for multiple activities to be associated with one object/target. - This moves some of the methods off Activity model into a mixin which didn't need to interact with database things. - This also cleaned up the migrations as well as adding retroactive creation of activities for collection creation.
| * | Create activity model and add activity creationJessica Tallon2014-08-221-0/+58
| |/ | | | | | | | | | | | | | | This creates the Activity and Genrator models from the Activity Streams spec and. I then created a migration which retro-actively create activities for media uploaded and comments created. Through out the code I've added so automatically activties are created when a user peforms an action (uploading media, commenting, etc.).
* | Fix migrations on Python 2.Christopher Allan Webber2014-09-301-0/+3
| | | | | | | | This commit sponsored by Loïc Grobol. Thank you!
* | Merge branch 'master' into merge-python3-portChristopher Allan Webber2014-09-161-9/+179
|\| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Has some issues, will iteratively fix! Conflicts: mediagoblin/gmg_commands/__init__.py mediagoblin/gmg_commands/deletemedia.py mediagoblin/gmg_commands/users.py mediagoblin/oauth/views.py mediagoblin/plugins/api/views.py mediagoblin/tests/test_api.py mediagoblin/tests/test_edit.py mediagoblin/tests/test_oauth1.py mediagoblin/tests/test_util.py mediagoblin/tools/mail.py mediagoblin/webfinger/views.py setup.py
| * Fix a python2.6 compatibility issue. Removing a dict comprehension.Christopher Allan Webber2014-08-181-1/+2
| | | | | | | | This commit sponsored by Christopher Beppler. Thanks!
| * Elrond keeps pointing out places I should "is not None" at :)Christopher Allan Webber2014-08-081-2/+2
| |
| * Okay, we don't know that indexes are falsey, so let's make it clearer. Yeek!Christopher Allan Webber2014-08-081-1/+1
| |
| * this negation needs parens.Christopher Allan Webber2014-08-081-1/+1
| |
| * Pull the indexes out of the dictionary directlyChristopher Allan Webber2014-08-081-8/+11
| | | | | | | | Instead of checking for their keys and pulling them out later, that is.
| * If the constraint already exists, roll back to a sane state.Christopher Allan Webber2014-08-081-1/+1
| |
| * Explaining why we're committing mid-migrationChristopher Allan Webber2014-08-081-0/+4
| |
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-31 05:51:16 +0000