nik/davical
1
0
Fork 0
mirror of https://gitlab.com/davical-project/davical.git synced 2026-01-28 00:43:37 +00:00
Code Issues Actions Packages Projects Releases Wiki Activity
4,018 Commits 11 Branches 58 Tags 14 MiB
Commit Graph

312 Commits

Author SHA1 Message Date
Andrew Ruthven
1ca8284bdc Add ROOM as a principal type 
This hopefully resolves #282.
 2024-01-21 19:12:42 +13:00
Andrew Ruthven
bc33199083 Run patches when creating the database 
From now on we should only provide patches, not a patch and modify
the initial SQL and data. Otherwise we never test the patches.
 2024-01-21 17:47:23 +13:00
Andrew Ruthven
27f19cb3b3 Fix typo 2024-01-21 16:41:34 +13:00
Andrew Ruthven
15d01c8bed Store DTSTART and DTEND from user in shadow columns 
We want to store the calculated dtstart and dtend in the database so we can
use SQL to fetch records. However, we also need what the user sent us so we
can allow prop-filters to be used as well.

So we store what the user sends us in dtstart_orig and dtend_orig and only
use for relevant prop-filter reports.
 2023-03-12 20:17:43 +01:00
Andrew Ruthven
8fbab49f0d Create unique constraints for tmp_password and role_member. 2023-02-15 07:42:34 +00:00
Andrew Ruthven
e3b5c331be Add a primary key to calendar_alarm table. 
Also fixed a bug in scripts/refresh-alarms.php if there was an
alarm with a duplicate trigger.

This is part of the fix for #276.
 2023-02-15 07:42:34 +00:00
Andrew Ruthven
6819d6d7d1 Add a primary_key to the addressbook_addresses_* tables 
This is part of the fix for #276.
 2023-02-15 07:42:34 +00:00
Florian Schlichting
69d5c58a5b switch egrep to grep -E to avoid test failure 
this is https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1019335, which
should be fixed but apparently isn't in the image we're using...
 2022-10-04 09:41:09 +02:00
Jamie McClymont
0c006b5c7c Make the recurrence range columns in the database tz-aware 2019-01-03 16:04:28 +13:00
Antoine
c2254d7682 Allow user to define awl_appuser and awl_dbauser on create-database script 2018-02-21 12:36:03 +01:00
Florian Schlichting
7674fe9831 'perl update-davical-database' did not find the intended config file / patchdir 
people may use that invocation in addition to calling
/usr/share/davical/dba/update-debian-database, and happen upon a
cryptic error when YAML tries to parse dba/update-davical-database
instead of config/administration.yml
 2017-10-09 10:17:03 +02:00
Florian Schlichting
39001794a3 Update caldav_functions.sql for Postgresql 10 
From version 10, Postgresql does not allow set-returning functions in
CASE statements. As we're using the functions recursively, we cannot
use LATERAL as suggested in the error message, but we can switch the
condition inside-out with only a limited amount of repetition.
 2017-10-04 22:36:29 +02:00
Florian Schlichting
69ef196730 create-database.sh: call update-davical-database with --dbuser instead of just --owner (see #124) 2017-09-20 17:02:57 +02:00
Florian Schlichting
2a84694331 Unbreak locale selection in admin interface 
http://php.net/manual/en/function.setlocale.php says "Different systems
have different naming schemes for locales." This seems to be true for
platforms (eg Win vs. Linux), but on Debian AFAIR locales were always at
least two-part (de_DE), never just one (de). This seems to have been
broken in 504651a3, likely by mistake.

Also, switch locale immediately, even before writing to the database.

BTW, what happens when system default locale is configured to e.g. fr_FR
and the user selects "English" - does that work?
 2017-01-17 23:40:26 +01:00
Florian Schlichting
2c11535eb0 use secure URIs where possible 2017-01-08 15:48:52 +01:00
Andrew McMillan
c5c0421caf Add /metrics.php to be scraped by Prometheus for monitoring. 2016-06-22 23:53:22 +01:00
Andrew McMillan
1ab66a70b5 Some database changes for server-side attendee handling. 2016-06-22 23:44:10 +01:00
Florian Schlichting
af1707ef1d prepare for 1.1.4 2016-01-03 19:09:56 +01:00
Andrew McMillan
9580da622a Support regression testing with postgres on non-default port 
[from github handle-remote-attendees branch]
 2015-12-27 13:02:38 +01:00
Florian Schlichting
8895aac2bf replace a few remaining instances of the old name "rscds" 2015-10-02 22:22:10 +02:00
Florian Schlichting
0cdcce0a6c Do not throw postgres errors when views/types/functions to be dropped do not exist (yet). Fixes #43 2015-10-02 22:09:34 +02:00
Mark Davies
0797e8233e First batch of database indexes 
Added in support of Issue #31, Database Performance Improvements. Note
creation of 1.2.12 db patch script - may need renaming or other special
treatment when merging this branch.
 2014-12-16 21:29:26 +01:00
Mark Davies
1fe5d24d9f Fix up Windows create-database.bat - see Issue #32. 2014-12-16 21:07:38 +01:00
Aaron W. Swenson
cfd5fd7555 Loop Over AWL Directory Candidates 
Using this method we're able to loop over the candidate directories
until we find what should be suitable AWL location. Further, adding
additional locations is as simple as adding a new line to ${awldirs}.

It does have the limitation that if the path has a new line in it
(/some/ridic
ulous/path), it'll treat it as two different paths. However, if
somebody seriously has that, they deserve the pain.
 2014-11-14 13:44:39 -05:00
“Paul
931651ca32 Remove quoted SQL language identifiers 2014-09-02 20:01:28 +02:00
Ján Máté
b5e409f7da fix to rename/delete the collection properties during the collection renaming/deleting 2013-10-25 12:16:27 +13:00
Andrew McMillan
8f3175248a A corrected change to fix the case of the language name everywhere. 2013-03-06 23:56:40 +13:00
Andrew McMillan
25c9fca4b8 Correct capitalisation of 'plpgsql' language for Postgres 9.2. 2013-03-06 20:22:55 +13:00
Andrew McMillan
5e195b151e A function which can expand collections inside collections. 
Including through bindings.
 2012-05-05 23:00:28 +12:00
Andrew McMillan
7c15051f84 Further fixes to WebDAV synchronization. 
This should be fully reliable now and also cleans out all sync
changes more than one week old.  update-database is needed to pull
the new function.
 2012-04-17 15:44:09 +12:00
Andrew McMillan
c6b95bc3f6 Do a bit_or() among multiple privilege settings. 2012-04-05 13:22:47 +12:00
Andrew McMillan
7140963e49 Allow user_no, created and modified to be set on create. 2012-01-15 20:44:10 +13:00
Andrew McMillan
d86132ed54 Current locales. 2011-11-21 10:57:10 +13:00
Andrew McMillan
3198191462 New Spanish(Spain) translation, updated French translations. 2011-10-26 12:36:01 +13:00
Andrew McMillan
c41f4071e4 Get rid of unsightly error due to removal of time_zone table. 2011-09-30 11:56:35 +02:00
Andrew McMillan
6d89db58d0 Fix setting of PG password from administration.yml during upgrade. 2011-09-24 14:29:41 +12:00
Andrew McMillan
cd7f8c35f2 Update to version 1.2.11 2011-09-24 12:56:11 +12:00
Andrew McMillan
5104ca25a4 Provide an alternative 1.2.10 with the check_db_revision() function fixed. 2011-09-20 08:55:26 +12:00
Andrew McMillan
cdc23ea732 Add etag to timezone table. 2011-09-19 08:42:28 +12:00
Andrew McMillan
f9ad324ba1 Adjustments to timezones representation in the database to support timezone protocol. 2011-09-17 23:40:04 +12:00
Andrew McMillan
05d42557d7 Update davical.sql to 1.2.10. 2011-09-12 09:49:32 +12:00
Andrew McMillan
1c965d4cdf Removed these outdated files. 2011-09-11 00:56:16 +12:00
Andrew McMillan
b4364fb999 Fix for the following error: 
davical: LOG: principals/users/cars/hilux/: Query: QF: SQL error "42804" - ERROR: column "changed_by" is of type integer but expression is of type name LINE 1: ...on, property_name, property_value ) VALUES( path, user, curr... ^ HINT: You will need to rewrite or cast the expression. QUERY: INSE
davical: LOG: principals/users/cars/hilux/: Query: QF: RT INTO property ( dav_name, changed_by, changed_on, property_name, property_value ) VALUES( path, user, current_timestamp, key, value ) CONTEXT: PL/pgSQL function "set_dav_property" line 16 at SQL statement"
davical: LOG: principals/users/cars/hilux/: Query: QF: SELECT set_dav_property( :dav_name, :user_no, :tag::text, :value::text)
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":dav_name" => "/cars/hilux/"
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":user_no" => "1023"
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":tag" => "http://apple.com/ns/ical/:calendar-color"
davical: LOG: principals/users/cars/hilux/: Query: QF:     ":value" => "#711A76"

From 'mate' on IRC.
 2011-08-28 16:38:14 +12:00
Andrew McMillan
05badd4d3a New SQL patch file, and fix comment in the last one also. 2011-08-25 15:05:28 +12:00
Rob Ostensen
b2ef0b0bf2 Add the required fields to dav_binding and clean up the SQL to better match the rest of the source. 
Add a header/last-modified check to skip the import on calendars that haven't changed.
 2011-08-25 14:17:28 +12:00
Andrew McMillan
504651a3f5 Add new locales and restructure how they are handled. 
We now build the dba/supported_locales.sql file from po/locale.values
files for each locale, and we are also fetching the translations from
transifex.net in order to build them.

This commit also adds support for some new locales, especially
Brazilian Portuguese and Mexican Spanish.
 2011-08-25 12:45:33 +12:00
Andrew McMillan
8743238952 Ensure dav_id_seq is initialized to a non-colliding value. 
Signed-off-by: Andrew McMillan <andrew@morphoss.com>
 2011-04-03 21:36:45 +12:00
Andrew McMillan
5dbe73f709 Set the correct DBA username. 
Signed-off-by: Andrew McMillan <andrew@morphoss.com>
 2011-03-31 11:40:34 +13:00
Andrew McMillan
ed7ffea332 Updated strings for localisation. 2011-01-14 16:20:16 +13:00
Andrew McMillan
493ec64cba Extend default_privileges to members of a group. 
Signed-off-by: Andrew McMillan <andrew@morphoss.com>
 2011-01-03 10:10:52 +13:00