Mercurial Mercurial > pub > hg > cubicweb / annotate
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc/migration/3.22.0_Any.py
author Sylvain Thénault <sylvain.thenault@logilab.fr>
Tue, 22 Dec 2015 15:35:10 +0100
changeset 11034 75d752e6daf7
parent 11033 63d860a14a17
child 11101 66fb68c25f83
permissions -rw-r--r--
[server] improve TZDatetime support by depending on logilab-database 1.15.0 including https://www.logilab.org/ticket/1485893, we can now keep the tzinfo attribute on datetime objects for TZDatetime attributes, so one knows that this is a tz-aware datetime. To easily make it work with backends that have no tz support, we keep converting tz-aware datetime objects into utc naive datetime objects before sending them to the database.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
11033
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     1
 
if confirm('use Europe/Paris as timezone?'):
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     2
 
    timezone = 'Europe/Paris'
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     3
 
else:
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     4
 
    import pytz
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     5
 
    while True:
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     6
 
        timezone = raw_input('enter your timezone')
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     7
 
        if timezone in pytz.common_timezones:
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     8
 
            break
63d860a14a17 [schema] Use TZDatetime for creation_date and modification_date
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     9
 












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    10


dbdriver = repo.system_source.dbdriver












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    11


if dbdriver == 'postgres':












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    12


    sql("SET TIME ZONE '%s'" % timezone)












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    13














63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    14


for entity in schema.entities():












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    15


    if entity.final:












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    16


        continue












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    17


    change_attribute_type(entity.type, 'creation_date', 'TZDatetime', ask_confirm=False)












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    18


    change_attribute_type(entity.type, 'modification_date', 'TZDatetime', ask_confirm=False)












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    19














63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    20


if dbdriver == 'postgres':












63d860a14a17
[schema] Use TZDatetime for creation_date and modification_date



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    21


    sql("SET TIME ZONE UTC")














cubicweb