CODEWITHSUNDEEP
pythondjangodjango-modelssqlite
Vishak Raj
Vishak Raj

Reputation: 113

Select in Sqlite3

I am using the select in sqlite3 statement to get rows from django db (default db)

p=connection.cursor().execute("SELECT * FROM webapp_information WHERE dat  BETWEEN date('now', 'start of day') AND date('now', 'localtime');")
a=p.fetchall()
for i in a:
  print(i)`

i get the dat(date field) from db but it returns nothing.

I tried in different way-

In [206]: p=connection.cursor().execute("SELECT * FROM webapp_information WHERE dat='2018-08-28';")

It returns with a empty list, however I pretty sure the date are stored in the it. Any help? thank you in advance. Modules.py

from __future__ import unicode_literals
from django.db import models 
import datetime

# Create your models here.

class information(models.Model):
login=models.CharField(max_length=100,)
idd=models.CharField(max_length=100,)
avatar_url=models.CharField(max_length=100,default='nll',null=True)
gravatar_id=models.CharField(max_length=100,default='nll',null=True)
url=models.CharField(max_length=100, default='nll',null=True)
html_url=models.CharField(max_length=100,default='nll',null=True)
followers_url=models.CharField(max_length=100,default='nll',null=True)
following_url=models.CharField(max_length=100,default='nll',null=True)
gists_url=models.CharField(max_length=100,default='nll',null=True)
starred_url=models.CharField(max_length=100,default='nll',null=True)
subscriptions_url=models.CharField(max_length=100,default='nll',null=True)
organizations_url=models.CharField(max_length=100,default='nll',null=True)
repos_url=models.CharField(max_length=100,default='nll',null=True)
events_url=models.CharField(max_length=100,default='nll',null=True)
received_events=models.CharField(max_length=100,default='nll',null=True)
typ=models.CharField(max_length=100,default='nll',null=True)
site_admin=models.CharField(max_length=100,default='nll',null=True)
name=models.CharField(max_length=100,default='nll',null=True)
company=models.CharField(max_length=100,default='nll',null=True)
blog=models.CharField(max_length=100,default='nll',null=True)
location=models.CharField(max_length=100,default='nll',null=True)
email=models.CharField(max_length=100,default='nll',null=True)
hireable=models.CharField(max_length=100,default='nll',null=True)
bio=models.CharField(max_length=100,default='nll',null=True)
public_repos=models.CharField(max_length=100,default='nll',null=True)
public_gists=models.CharField(max_length=100,default='nll',null=True)
followers=models.CharField(max_length=100,default='nll',null=True)
following=models.CharField(max_length=100,default='nll',null=True)
created_at=models.CharField(max_length=100,default='nll',null=True)
updated_at=models.CharField(max_length=100,default='nll',null=True)
dat = models.DateField()
class sapi(models.Model):
    dat = models.DateField()

Upvotes: 0

Views: 580

Answers (1)

FlipperPA
FlipperPA

Reputation: 14311

I think you're looking to do something like this, with date ranges:

from webapp.models import Information

start_of_day_date = ...
now_date ...

p = Information.objects.filter(
    dat__range=(start_of_day_date, now_date),
)

for i in p:
    print(p)

For a good explanation on how to set start_of_day_date and now_date, see this post: Determine start and end time of current day (UTC -> EST -> UTC) ; Python

Good luck!

Upvotes: 1

Related Questions