aboutsummaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2017-01-02Optimise SQL queries when displaying bills for a projectBaptiste Jonglez1-1/+3
By defaut, SQLAlchemy uses lazy loading, which means that displaying n bills will generate around n queries (to get the list of owers of each bill). Pre-load the list of owers to drastically decrease the number of SQL queries. Before this commit: 1004 SQL queries, 7535 ms elapsed time, 7536 ms CPU time, 530 ms SQL time After this commit: 5 SQL queries, 3342 ms elapsed time, 3393 ms CPU time, 15 ms SQL time Measured request: display the list of all bills for the project (without displaying the sidebar with balances) Test setup to measure performance improvement: - 5 users with various weights - 1000 bills, each paid by a random user, each involving all 5 users - laptop with Celeron N2830@2.16 GHz, SSD Samsung 850 EVO - sqlite database on SSD, using sqlite 3.15.2 - python 2.7.13 - Flask-DebugToolbar 0.10.0 (to count SQL queries and loading time) Performance measurements (using Flask-DebugToolbar with the second request, to avoid measuring cold-cache performance): - number of SQL queries - elapsed time (from request to response) - total CPU time consumed by the server handling the request - total time spent on SQL queries (as reported by SQLAlchemy)
2016-10-05Merge pull request #154 from aavenel/enableTravisCIAlexis Metaireau2-0/+11
Enable Travis CI
2016-10-01Add Travis CI badge in READMEAlexandre Avenel1-0/+4
2016-09-25Add a basic travis.yml file (Enable Travis CI)Alexandre Avenel1-0/+7
2016-09-13Merge pull request #151 from spiral-project/jd-fix-domainAlexis Metaireau1-18/+15
Change ihatemoney.notmyidea.org → ihatemoney.org
2016-09-13Change ihatemoney.notmyidea.org → ihatemoney.orgJocelyn Delalande1-18/+15
As the old domain seams dead and not even redirecting.
2016-09-12Merge pull request #150 from fredericsureau/negative-amountsAlexis Metaireau2-6/+2
Allow negative bill amounts
2016-09-12Update negative amounts testfredericsureau1-3/+1
2016-09-12Merge pull request #145 from adamchainz/readthedocs.ioAlexis Metaireau2-2/+2
Convert readthedocs links for their .org -> .io migration for hosted projects
2016-09-12Merge pull request #148 from JocelynDelalande/api-doc-precisionsAlexis Metaireau1-4/+4
REST API doc precisions
2016-09-12Allow negative bill amountsfredericsureau1-3/+1
2016-08-18Explain better multi-valued `payed_for` in API docJocelyn Delalande1-3/+3
… And use a multi-valued example, as it's IMHO the "standard" use-case with IHM.
2016-08-18Mentions in API doc that the date is optional.Jocelyn Delalande1-1/+1
2016-06-28Convert readthedocs links for their .org -> .io migration for hosted projectsAdam Chainz2-2/+2
As per [their blog post of the 27th April](https://blog.readthedocs.com/securing-subdomains/) ‘Securing subdomains’: > Starting today, Read the Docs will start hosting projects from subdomains on the domain readthedocs.io, instead of on readthedocs.org. This change addresses some security concerns around site cookies while hosting user generated data on the same domain as our dashboard. Test Plan: Manually visited all the links I’ve modified.
2016-06-28Merge pull request #144 from JocelynDelalande/fix-migrations-upgrade-pathAlexis Metaireau1-1/+15
Fix migrations upgrade path for MySQL
2016-06-18Fix migrations upgrade path for MySQLJocelyn Delande1-1/+15
For some reason, the migration path from unmanaged db (from alembic point-of-view) to managed db, through the initial migration works well with sqlite… But not with mysql where the db system tries to re-create the existing tables. This commit is a way to detect if we are migrating from pre-alembic era and skip the first migration (which would do nothing anyway), marking it as already executed. It's quite hackish but that's the best I found so far to get it working with both MySQL and SQLite.
2016-06-17Merge pull request #131 from JocelynDelalande/members-weightsAlexis Metaireau14-20/+302
Added Members weights handling
2016-06-16Update translationJocelyn Delande2-1/+4
2016-06-16Add migration to initialize Person weightsJocelyn Delande1-0/+39
That's for Persons that existed before the weights were added to model.
2016-06-16Hide the member weights in members list if all weights are "1".Jocelyn Delande4-1/+31
2016-06-16Added member edit formJocelyn Delande6-6/+60
2016-06-15display an edit button on members listJocelyn Delande2-1/+9
2016-06-15Ask for confirmation only for deleting usersJocelyn Delande1-1/+5
2016-06-15Added a template filter not to show zero decimals on user weightsJocelyn Delande3-1/+20
2016-06-15UI for showing user weights in user listJocelyn Delande2-1/+5
2016-06-15Added member weights support to APIJocelyn Delande2-8/+68
2016-06-15Add members weight in models and budget backend refs #94Jocelyn Delande4-3/+64
2016-05-31Merge pull request #141 from JocelynDelalande/jd-alembic-migrationsAlexis Metaireau8-1/+246
Alembic DB migrations
2016-05-31Add a manage.py CLI (flask_script)Jocelyn Delande1-0/+16
As it's the Flask-Migrate way to expose its commands (./manage.py db command). In our case, it's specially useful for creating new migrations.
2016-05-31Handle migrations through alembic/flask-MigrationsJocelyn Delande7-1/+230
Auto-initialization now applies migrations instead of using db. create_all() fix #83
2016-04-05Merge pull request #129 from JocelynDelalande/no-user-settings-in-testsAlexis Metaireau4-7/+16
Do not load user-overriden settings in unit tests.
2016-04-03Do not load user-overriden settings in unit tests.Jocelyn Delande4-7/+16
Loading not versioned settings.py during tests make them less predictable. That's inspired from django behaviour with DJANGO_SETTING_MODULE environment variable.
2015-11-09Merge pull request #122 from JocelynDelalande/configurable-prefixAlexis Metaireau5-14/+74
Made an URL prefix configurable in settings
2015-09-25Prevent comma to be included in URLMathieu Leplatre1-1/+1
2015-09-25Prevent comma to be included in URLMathieu Leplatre1-1/+1
2015-08-20Merge pull request #130 from JocelynDelalande/trailing-whitespacesQuentin Roy15-75/+75
Remove trailing whitespaces
2015-08-20Remove trailing whitespacesJocelyn Delande15-75/+75
2015-08-19Made an URL prefix configurable in settings, includes tests.Jocelyn Delande5-2/+55
2015-08-19Adds a way to (re)configure the running app, reloading settings.Jocelyn Delande1-12/+19
Currently, there is no way to reset settings after modifying them, which is anoying for tests.
2015-07-28Merge pull request #126 from aavenel/fix-settle-roundingAlexis Metaireau1-1/+1
Bugfix rounding settle algorithm
2015-07-05Bugfix rounding settle algorithmAlexandre Avenel1-1/+1
In some cases, settle algorithm failed to deliver optimal solution due to a rounding bug.
2015-05-20Merge pull request #121 from JocelynDelalande/deprecated-default-mail-senderAlexis Metaireau3-2/+16
nicely deprecates DEFAULT_MAIL_SENDER
2015-05-20Merge pull request #123 from JocelynDelalande/mysql-compatible-fieldsAlexis Metaireau1-5/+5
specified sizes for string columns for MySQL
2015-05-01specified sizes for string columns for MySQLJocelyn Delande1-5/+5
2015-04-30nicely deprecates DEFAULT_MAIL_SENDER as it changed upstream for flask-mail>=0.8Jocelyn Delande3-2/+16
2015-04-15Merge pull request #119 from aavenel/fix-118Alexis Metaireau1-1/+1
Fix 118
2015-04-12Fix #118 : Create a new project with the name "dashboard" should raise an ↵Alexandre Avenel1-1/+1
exception
2014-07-22Merge pull request #117 from aavenel/fix-roundingAlexis Metaireau3-5/+5
Fix #116 : rounding error in balances
2014-07-22Format numbers in templatesAlexandre Avenel3-4/+4
2014-07-21Fix rounding error in balancesAlexandre Avenel1-1/+1
generated by cgit v1.1 at 2025-12-06 22:02:51 +0000