Statistics
| Branch: | Tag: | Revision:

root / snf-pithos-backend / pithos / backends / lib / sqlalchemy @ dc7159be

# Date Author Comment
a3622324 01/09/2014 02:22 pm Chrysostomos Nanakos

pithos: pep8 fixes

b045ca90 12/16/2013 05:44 pm Sofia Papagiannaki

pithos: Reduce interaction with the database

ba402621 12/07/2013 11:59 am Sofia Papagiannaki

pithos: Fix ordering in detailed listing of public objects

Refs: #4727

f759041f 10/29/2013 04:15 pm Ilias Tsitsimpis

snf-pithos-app: Use the new AstakosClient

ae0a4858 10/03/2013 02:52 pm Nanakos Chrysostomos

pithos: Fix latest version list with specific timestamp

Return the sorted list of the latest attributes keys

87835e94 10/02/2013 11:27 pm Nanakos Chrysostomos

pithos: Fix timestamps

4a7b190f 09/30/2013 03:25 pm Nanakos Chrysostomos

pithos: Optimize latest_attribute_keys

pep8 fixes

b83df225 09/23/2013 09:49 pm Nanakos Chrysostomos

pithos: Optimize xfeature_get_bulk query

e98c5561 09/19/2013 05:46 pm Nanakos Chrysostomos

pithos: Further optimize latest_version_list query

76da16c3 09/19/2013 04:05 pm Nanakos Chrysostomos

pithos: Optimize latest_version_list query

7fef13f0 09/19/2013 12:30 pm Nanakos Chrysostomos

pithos: Optimize statistics_latest subquery

dc88754b 09/16/2013 04:19 pm Nanakos Chrysostomos

pithos: Performance Optimizations in Object Listing.

de8fb87d 09/02/2013 03:40 pm Sofia Papagiannaki

pithos: Destroy test database after test execution
:
Pithos uses a pool for the backend objects.
Pooled backend objects override the default close behavior
and return the object to the pool instead.
Therefore, django was unable to destroy the database
since there were active connections....

6e0f3e65 08/08/2013 05:40 pm Sofia Papagiannaki

pithos: Fix shared listing for implicitly shared objects

Provide also the appropriate tests

Refs: #4131

057c0977 08/07/2013 11:33 am Christos Stavrakakis

Merge branch 'hotfix-0.14.5' into develop

Conflicts:
snf-pithos-backend/pithos/backends/modular.py
version

d2fc71c9 08/05/2013 05:02 pm Sofia Papagiannaki

pithos: Fix access object version data/metadata

adce84cd 08/02/2013 08:02 pm Sofia Papagiannaki

pithos: Fix TypeError when trying to retrieve invalid object version

d4e4e501 07/25/2013 12:46 pm Christos Stavrakakis

Merge branch 'hotfix-0.14.3' into develop

Conflicts:
Changelog
snf-astakos-app/astakos/im/messages.py
snf-pithos-app/pithos/api/manage_accounts/__init__.py
snf-pithos-app/pithos/api/management/commands/reconcile-resources-pithos.py
snf-pithos-app/pithos/api/settings.py...

96090728 07/22/2013 06:40 pm Sofia Papagiannaki

pithos: Fix line continuation format

2ff02341 07/22/2013 06:19 pm Sofia Papagiannaki

pithos: Fix reconcile-resource-pithos command

  • Improved performance (reduce interaction with the database)
  • Fix command when `userid` option is provided

Conflicts:
snf-pithos-app/pithos/api/management/commands/reconcile-resources-pithos.py
snf-pithos-backend/pithos/backends/lib/sqlite/node.py

fbafd482 07/17/2013 07:06 pm Sofia Papagiannaki

pithos: Revert pep8 changes from sqlalchemy ClauseElements

pep8 complains for comparison with boolean in sqlalchemy.sql.expression.ClauseElement
with "E712 comparison to True should be 'if cond is True:' or 'if cond:'"
but sqlalchemy does not understand it otherwise.

72e191e5 07/17/2013 11:41 am Sofia Papagiannaki

pithos: Fix migrations

Some data migrations require to import pithos app settings.
These migrations used to fail in nodes where snf-pithos-app
is not installed.
Disable these migrations if they fail to import the necessary settings.

29148653 07/17/2013 11:41 am Sofia Papagiannaki

pithos: pep8 fixes

9f5c8386 07/11/2013 06:22 pm Sofia Papagiannaki

pithos: Fix attribute copy

The newly created attributed used to point in the source node
instead of the destination

Refs: 3510

18d46d23 07/11/2013 01:55 pm Sofia Papagiannaki

pithos backend: Extend list domain objects method

This method optionally accepts a user paramter and used to return
the objects shared to the user and having a specific domain.
This commit extends this functionality and returns also the objects
owned by the user and having the specific domain...

4100e0ee 07/11/2013 01:55 pm Sofia Papagiannaki

pithos: Update get objects in a specific domain

Improve performance

Refs: #3510

8b365874 07/11/2013 01:55 pm Sofia Papagiannaki

pithos: improve performance of get_domain_list

Before it used to query the database
for all the objects having the specific domain
and finally filtered out the objects to which the user had no access.
Now gets first the allowed_paths for the user and then...

83a3723e 06/28/2013 12:28 pm Sofia Papagiannaki

pithos: fix empty account usage computation

Usage computation for empty accounts used to fail with:
TypeError: 'NoneType' object is unsubscriptable

2e8edd42 06/17/2013 06:02 pm Sofia Papagiannaki

pithos: update pithos statistics computation

Compute account statistics instead of storing them in the database
Fix container statistics computation
Related commit: 3a9f1f113c1e2c853b7ae223fbcbb843d19f7f95

985b9b09 06/17/2013 06:02 pm Sofia Papagiannaki

pithos: enforce transaction isolation level

Refs: #3582 #3585

0f510652 06/17/2013 06:02 pm Sofia Papagiannaki

pithos: update recursively statistics up to the container level

To achieve atomicity we lock the container path.
However, the write operations update the statistics for the ancestor
nodes (container/account).
Therefore, the backend restricts the recursion up to the container...

f554bdb3 06/07/2013 01:36 pm Giorgos Korfiatis

pithos: Fix ASTAKOS_BASE_URL import in migration

47b8d4b1 05/13/2013 12:15 pm Christos Stavrakakis

Merge branch 'feature-quotas' into develop

Conflicts:
docs/dev-guide.rst

91114c83 05/09/2013 04:04 pm Sofia Papagiannaki

Merge branch 'tmp-pithos-db-escape-warning' into develop

7a65e284 05/01/2013 03:43 pm Sofia Papagiannaki

pithos: Remove unnecessary logging in public url unset

860c5d9c 05/01/2013 03:28 pm Sofia Papagiannaki

pithos: Remove obsolete settings from database migrations

Use astakosclient to retrieve user information

ae6199c5 05/01/2013 12:00 pm Sofia Papagiannaki

pithos: Update pithos management commands

Refs: #3625

d1e7d2b4 05/01/2013 12:00 pm Sofia Papagiannaki

pithos: Utilize astakosclient for quota handling

Refs: #3625, #3650

235a4227 04/22/2013 01:31 pm Sofia Papagiannaki

pithos: use other db escape string literal character

Refs: #3645

595b2b0d 04/22/2013 10:10 am Sofia Papagiannaki

Add database migration

Provide an alembic migration to add an index
on the attributes.domain field

5576e6dd 04/22/2013 10:10 am Sofia Papagiannaki

Pithos backend: Return objects in a specific domain

Refs: #3510

26837206 04/18/2013 05:12 pm Georgios D. Tsoukalas

fix trasactionless query in pithos backend init

The query was submitted for execution without any prior transaction
setup, which caused:

1. psycopg2 to implicitly start a transaction
2. the new transaction to remain unknown to the sqlalchemy layer
since it was implicit...

e1e37cf9 04/16/2013 11:59 am Sofia Papagiannaki

Fix pithos-reconcile-commissions command

Get pending commissions specifically for pithos

Refs: #3594

613659fc 04/15/2013 07:14 pm Sofia Papagiannaki

pithos: Register commission serials to allow for recoery

Refs: #3594

04a1b675 04/08/2013 06:17 pm Christos Stavrakakis

Move astakos lib from snf-common to snf-django-lib

4a105ce2 03/28/2013 05:21 pm Sofia Papagiannaki

Change pithos public URL implementation

Refs: commit: 56f3c759

Do not include encoded serial in the public URL.

Change PITHOS_PUBLIC_URL_MIN_LENGTH setting to
PITHOS_PUBLIC_URL_SECURITY.

Log public set/unset functions.

56f3c759 03/27/2013 06:51 pm Sofia Papagiannaki

Change pithos public implementation

Public URLs should consist of a random part.
A public URL should be unique and should not be
equal to any deleted public URL.
Finally publishing a public object has no effect.
Therefore, to generate a new public URL for an...

78348987 03/19/2013 01:24 pm Sofia Papagiannaki

Eliminate mutable default arguments

0a92ff85 03/19/2013 11:22 am Sofia Papagiannaki

Fix pithos purging accounting

Refs: #3442
Refs: #1733

Pithos has two different version accounting
policies:
  • free: do not include object history version size
    to the total account usage
  • debit: include object history version size to
    the total account usage...
2bbf1544 03/06/2013 05:44 pm Georgios D. Tsoukalas

Fix UUID bug breaking image list and VM creation

latest_uuid(uuid) returned the latest version with the given uuid.
This is called from pithos backend method get_uuid(),
which is called from plankton backend method get_image().

For the use in get_image() the uuid alone is not enough,...

97341ccb 03/05/2013 05:02 pm Georgios D. Tsoukalas

Fix serious inefficiency in pithos 0.13 migration

As was run on production during migration.

The migration looped over all rows (node, muser) from versions,
and update muser in each one.

However, the tuples (node, muser) are not unique in the table,
and more important, the muser values are much fewer than the nodes...

e4d84803 02/18/2013 10:23 pm Sofia Papagiannaki

Update pithos migration

Display progress

0e1fce89 02/18/2013 06:03 pm Sofia Papagiannaki

Improve pithos migrate

Cache also non existing accounts.

442bc80c 02/14/2013 04:27 pm Sofia Papagiannaki

Fix pithos purging

Error if there were no objects to purge

94bff756 02/14/2013 04:27 pm Sofia Papagiannaki

Provide command for managing pithos duplicate accounts

42ea7e66 02/14/2013 04:26 pm Sofia Papagiannaki

Migrate pithos object modification user

e31e4274 01/28/2013 03:43 pm Sofia Papagiannaki

Change error handling in uuid to displayname pithos path migration.

Stop migraton if it fails to retrieve a uuid/displayname.

2a7276e7 01/24/2013 02:47 pm Sofia Papagiannaki

Expose /user_catalogs service api call

Change migration scripts to use this instead of the user api call

890c2065 01/23/2013 06:51 pm Sofia Papagiannaki

Change feedback & user_catalogs astakos && pithos api calls

  • Substitute ``username`` with ``displayname``
32454501 01/07/2013 04:13 am Sofia Papagiannaki

Change pithos sharing to work with account uuids

50149cc8 01/03/2013 06:18 pm Sofia Papagiannaki

Migrate username to uuid in pithos permissions

096a7c3b 01/02/2013 11:45 am Sofia Papagiannaki

Fix negative population in statistics table

cd5033bd 12/28/2012 02:41 pm Sofia Papagiannaki

Provide error feedback during pithos database path migration to container uuid instead of email

c700f742 12/27/2012 06:29 pm Sofia Papagiannaki

Update Astakos API to provider calls for retrieving uuid from the username and vice versa, extend astakos client library (snf-common) and update pithos to use uuids instead of email for account identification

7ed99da8 11/09/2012 11:02 am root

wip issue_commision(). no accept or reject yet

eecad161 10/04/2012 02:44 pm Sofia Papagiannaki

Fix undefined variable

c53502b1 09/19/2012 03:14 pm Sofia Papagiannaki

Fix sqlalchemy warning: IN-predicate invoked with an empty sequence.

388ea25f 09/13/2012 03:06 pm Sofia Papagiannaki

Include version information in aquarium messages

dd0cc7a8 09/12/2012 03:54 pm Sofia Papagiannaki

Comment out sqlalchemy echo

6a5ca445 09/11/2012 04:54 pm Sofia Papagiannaki

Change QuotaholderSync to QuotaholderSerial

cb787cc4 09/11/2012 03:50 pm Sofia Papagiannaki

Change QuotaholderSync to QuotaholderSerial

5a6a68f3 09/11/2012 01:57 pm Sofia Papagiannaki

fix access to backend library classes Config and QuotaholderSync

6540c590 09/11/2012 01:43 pm Sofia Papagiannaki

New database tables to keep track of quota holder commisions

2715ade4 09/10/2012 04:09 pm Sofia Papagiannaki

Fix code formatting to conform to the PEP 8 style guide

078acc47 07/19/2012 02:44 pm Sofia Papagiannaki

Merge branch 'master' of https://code.grnet.gr/git/pithos

ca7812eb 07/19/2012 02:43 pm Sofia Papagiannaki

fix nodes latest_version revision

4051c82a 07/18/2012 08:16 pm Kostas Papadimitriou

Workaround to identify proper alchemy url

Not all apps use the same setting name for the pithos backend connection

c31d3228 07/18/2012 05:56 pm Kostas Papadimitriou

Do not set default url in alembic.ini

sqlalchemy url will be dynamically set in alembic config object based on
synnefo.settings.PITHOS_BACKEND_DB_CONNECTION.

6a82f89f 07/18/2012 05:41 pm Sofia Papagiannaki

use alembic to initialize the backend database

deacb43f 07/18/2012 03:13 pm Sofia Papagiannaki

Merge branch 'master' of https://code.grnet.gr/git/pithos

Merge with pithos-migrate

Conflicts:
snf-pithos-backend/pithos/backends/lib/sqlalchemy/alembic.ini

2c7aacf6 07/17/2012 10:09 pm Sofia Papagiannaki

Update alembic .ini

44d80edf 07/17/2012 10:07 pm Kostas Papadimitriou

Migrate against synnefo.settings backend by default

use ``PITHOS_BACKEND_DB_CONNECTION`` as default value for alembic sqlalchemy.url
option.

94243c86 07/17/2012 09:02 pm Sofia Papagiannaki

Remove index on cluster

Refs: #2675

5f8bbf54 07/17/2012 08:57 pm Sofia Papagiannaki

Refs: #2675

Introduce alembic

585b75e7 07/17/2012 04:22 am Sofia Papagiannaki

eliminate nested sql aggregations

Refs: #2675

07867f70 06/28/2012 07:33 pm Sofia Papagiannaki

Fix size & type of copied files

Refs: #2611

8221c89d 06/27/2012 06:31 pm Sofia Papagiannaki

Progress II: update sqlalchemy pithos backend lib

Refs: #2611

345dcf39 04/11/2012 10:56 am Antony Chazapis

Overwrite permissions every time.

Fixes #2312

a74ba506 04/10/2012 12:15 pm Sofia Papagiannaki

Send sharing notifications.

Fixes #2295

413448f1 03/08/2012 03:25 pm Sofia Papagiannaki

close sqlalchemy connections literally

6e147ecc 02/23/2012 03:11 pm Antony Chazapis

Remove lib package.

88353602 02/22/2012 12:36 pm Kostas Papadimitriou

Merge commit 'v0.9.0' into packaging

Conflicts:
pithos/__init__.py
pithos/api/management/commands/__init__.py
pithos/backends/lib/rabbitmq/__init__.py
pithos/backends/lib/rabbitmq/queue.py
pithos/lib/user.py
pithos/middleware/user.py
pithos/settings.py...

6c8595a5 01/23/2012 06:35 pm Kostas Papadimitriou

Merge branch 'master' into packaging

ab0982ad 01/23/2012 03:34 pm Kostas Papadimitriou

Merge branch 'master' into packaging

Conflicts:
pithos/settings.py
snf-pithos-app/pithos/middleware/log.py
snf-pithos-app/pithos/urls.py
snf-pithos-backend/pithos/backends/__init__.py
snf-pithos-tools/setup.py

8c306eab 01/17/2012 06:42 pm Kostas Papadimitriou

Split pithos components in separate packages

- splitted pithos modules in separate reusable components
- python packaging for all packages
- snf-webproject support (entry_points) for pithos django applications