I need to save some fields in my database in the format YYY-MM-MM 00:00:00+00.
So I decide to do this:
# setting.py
TIME_ZONE = 'America/Mexico_City'
USE_I18N = True
USE_L10N = True
USE_TZ = True
# models.py
class Program(models.Model):
objects = models.Manager()
objects_custom = ProgramManager()
class Meta:
ordering = ['id']
name = models.CharField(max_length=100, null=False)
program_budget = models.CharField(max_length=100, null=False)
company = models.ForeignKey(Company, on_delete=models.CASCADE, null=True)
active = models.BooleanField(default=True)
uuid4 = models.CharField(max_length=50, unique=True, null=True)
country_list = models.TextField(null=True)
method_payment = models.CharField(max_length=100, null=True)
currency = models.CharField(max_length=4, default='USD', null=True)
create_at = models.DateTimeField(auto_now_add=True, null=True)
discharge_program = models.DateTimeField(auto_now_add=True, null=True)
updated_at = models.DateTimeField(auto_now=True)
deleted_at = models.DateTimeField(null=True)
is_saved = models.NullBooleanField(default=False, null=True, blank=True)
is_suspended = models.BooleanField(default=False)
start_at = models.DateTimeField(null=True)
finish_at = models.DateTimeField(null=True)
# utils.py
from datetime import datetime, time
import pytz
from settings.py import TIME_ZONE
def get_start_at(date):
"""Obtain the current day initialize in the first second of the day.
Parameters:
date (date): date object
Returns:
(datetime): YYYY-MM-DD 00:00:00
"""
return datetime.combine(date, time.min, pytz.timezone(TIME_ZONE))
Here are my values to create the register:
{
'has_individual_budget': False,
'name': 'plan test create program start_at datetime',
'program_budget': '0',
'uuid4', 'd6effacf-3c19-48db-ab06-5af1d97df599',
'country_list':
'[{"id":239,"name":"Venezuela","iso_code2":"VE","iso_code3":"VEN","phone_prefix":58,"currency":"VEF","flag":"U+1F1FB
U+1F1EA","phone_national_regex":"^[68]00\\\\d{7}|(?:[24]\\\\d|[59]0)\\\\d{8}$","active":1}]',
'method_payment': '7fb39a7e-a6de-488b-9564-9bd853b598ec',
'currency': 'USD',
'is_saved': False,
'start_at': datetime.datetime(2022, 3, 28, 0, 0, tzinfo=<DstTzInfo
'America/Mexico_City' LMT-1 day, 17:23:00 STD>),
'finish_at': datetime.datetime(2022, 4, 27, 23, 59, 59, 999999,
tzinfo=<DstTzInfo 'America/Mexico_City' LMT-1 day, 17:23:00 STD>),
'company': <Company: Company object (247)>,
'card_provider': <CardProvider: stripe-usa>,
'payment_provider': <CardProvider: stripe-usa>
}
as you can see the field 'start_at' is the datetime that I want to store in
the database, but when I look the insert query:
{
'sql': """
INSERT INTO "user_program"
(
"name",
"program_budget",
"company_id",
"active",
"uuid4",
"country_list",
"method_payment",
"currency",
"create_at",
"discharge_program",
"updated_at",
"deleted_at",
"is_saved",
"is_suspended",
"start_at",
"finish_at",
"has_individual_budget",
"card_provider_id",
"payment_provider_id"
)
VALUES
(
\'plan test create program start_at datetime\',
\'0\',
247,
true,
\'d6effacf-3c19-48db-ab06-5af1d97df599\',
\'[{"id":239,"name":"Venezuela","iso_code2":"VE","iso_code3":"VEN","phone_prefix":58,"currency":"VEF","flag":"U+1F1FB
U+1F1EA","phone_national_regex":"^[68]00\\\\d{7}|(?:[24]\\\\d|[59]0)\\\\d{8}$","active":1}]\',
\'7fb39a7e-a6de-488b-9564-9bd853b598ec\',
\'USD\',
\'2022-03-28T18:47:10.865801+00:00\'::timestamptz,
\'2022-03-28T18:47:10.865870+00:00\'::timestamptz,
\'2022-03-28T18:47:10.865913+00:00\'::timestamptz,
NULL,
false,
false,
\'2022-03-28T00:00:00-06:37\'::timestamptz, -- start_field, notice that the
timezone part should be -06 but it is -06:37
\'2022-04-27T23:59:59.999999-06:37\'::timestamptz,
false,
1,
1
)
RETURNING "user_program"."id"',
'time': '0.267'
}
Plase tell me how to fix that, if I need to change the TIME_ZONE or something.
Regards, Andres.
El martes, 29 de marzo de 2022 a la(s) 01:41:42 UTC-4, Antonis Christofides
escribió:
Hello,
1. Please copy your code exactly. Is it really
"pytz.timezone(TIME_ZONE)"? Or is it
"pytz.timezone(*settings.*TIME_ZONE)"? If it is the first one, please
include the definition or importing of TIME_ZONE.
2. Please pretty-print your dictionary. You can use pprint for that. If
it doesn't work on OrderedDicts, convert it to a simple dictionary
before pretty printing.
3. Likewise, do something so that your SQL statement is more readable,
such as manually inserting newlines and indents.
Regards,
Antonis
Antonis Christofides
+30-6979924665 <tel:+30%20697%20992%204665> (mobile)
On 28/03/2022 22.02, Andrés Alvarez wrote:
I need to save some fields in my database in the format YYY-MM-MM
00:00:00+00. So I decide to do this:
field_to_save = datetime.combine(date_to_save, time.min,
pytz.timezone(TIME_ZONE))
in settings.py I have:
TIME_ZONE = 'America/Mexico_City'
USE_I18N = True
USE_L10N = True
USE_TZ = True
My model:
class Program(models.Model):
objects = models.Manager()
objects_custom = ProgramManager()
class Meta:
ordering = ['id']
# ... others fields
start_at = models.DateTimeField(null=True)
finish_at = models.DateTimeField(null=True)
Here are my values to create the register:
OrderedDict([('has_individual_budget', False), ('name', 'plan test create
program start_at datetime'), ('program_budget', '0'), ('uuid4',
'd6effacf-3c19-48db-ab06-5af1d97df599'), ('country_list',
'[{"id":239,"name":"Venezuela","iso_code2":"VE","iso_code3":"VEN","phone_prefix":58,"currency":"VEF","flag":"U+1F1FB
U+1F1EA","phone_national_regex":"^[68]00\\\\d{7}|(?:[24]\\\\d|[59]0)\\\\d{8}$","active":1}]'),
('method_payment', '7fb39a7e-a6de-488b-9564-9bd853b598ec'), ('currency',
'USD'), ('is_saved', False), ('start_at', datetime.datetime(2022, 3, 28,
0, 0, tzinfo=<DstTzInfo 'America/Mexico_City' LMT-1 day, 17:23:00 STD>)),
('finish_at', datetime.datetime(2022, 4, 27, 23, 59, 59, 999999,
tzinfo=<DstTzInfo 'America/Mexico_City' LMT-1 day, 17:23:00 STD>)),
('company', <Company: Company object (247)>), ('card_provider',
<CardProvider: stripe-usa>), ('payment_provider', <CardProvider:
stripe-usa>)])
as you can see the field 'start_at' is the datetime that I want to store
in the database, but when I look the insert query:
{'sql': 'INSERT INTO "user_program" ("name", "program_budget",
"company_id", "active", "uuid4", "country_list", "method_payment",
"currency", "create_at", "discharge_program", "updated_at", "deleted_at",
"is_saved", "is_suspended", "start_at", "finish_at",
"has_individual_budget", "card_provider_id", "payment_provider_id")
VALUES (\'plan test create program start_at datetime\', \'0\', 247, true,
\'d6effacf-3c19-48db-ab06-5af1d97df599\',
\'[{"id":239,"name":"Venezuela","iso_code2":"VE","iso_code3":"VEN","phone_prefix":58,"currency":"VEF","flag":"U+1F1FB
U+1F1EA","phone_national_regex":"^[68]00\\\\d{7}|(?:[24]\\\\d|[59]0)\\\\d{8}$","active":1}]\',
\'7fb39a7e-a6de-488b-9564-9bd853b598ec\', \'USD\',
\'2022-03-28T18:47:10.865801+00:00\'::timestamptz,
\'2022-03-28T18:47:10.865870+00:00\'::timestamptz,
\'2022-03-28T18:47:10.865913+00:00\'::timestamptz, NULL, false, false,
\'2022-03-28T00:00:00-06:37\'::timestamptz,
\'2022-04-27T23:59:59.999999-06:37\'::timestamptz, false, 1, 1) RETURNING
"user_program"."id"', 'time': '0.267'}
the timezone part is -06:37 should be only -06.
Plase tell me how to fix that, if I need to change the TIME_ZONE or
something.
Regards, Andres.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/1999ec1e-9170-432e-adc0-71cab3dece6an%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/1999ec1e-9170-432e-adc0-71cab3dece6an%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/d1cfcde9-3d21-4918-8edf-b9366b1dfa33n%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/d1cfcde9-3d21-4918-8edf-b9366b1dfa33n%40googlegroups.com?utm_medium=email&utm_source=footer>.
