Highest Voted 'gqlquery' Questions

0

votes

1 answer

GAE by using GQL, how to use SQL's like query?

def post(self): selector = self.request.get('search') search = db.GqlQuery("SELECT * FROM Product WHERE productName = :selector", selector=selector) products = search.fetch(10) values = { 'products' : products } …

google-cloud-datastore gql gqlquery

asked Nov 29 '10 at 06:41

user520987

41
3

0

votes

0 answers

GqlQuery error for simple registration form in Python

Sorry, for the weird title but I wanted to elaborate what you would be working with. So here is what I want to do: Grab the user_id and hash from my cookie. (Complete) Put it in a gql query that finds the user_id and hash in my database (In…

python google-app-engine user-registration gqlquery

asked Feb 11 '17 at 20:03

Mr.Bill

179
14

0

votes

1 answer

AppEngine GqlQuery (WHERE NOT)

I want to find all employees from a company where the telephone number is NOT empty. Now I have this: db.GqlQuery('SELECT * FROM Employee ' 'WHERE company = :company ' 'AND phone > :nophone', company=company, nophone=None) But this…

database google-app-engine gqlquery

asked Nov 10 '10 at 14:57

Elias

3,300
4
34
38

0

votes

1 answer

How do a make a login feature that retrieves the user from the database?

I am making a basic web page that has a sign up page and a login page. I am using google app engine, python, and HTML. This is my user function: class User(db.Model): name = db.StringProperty(required=True) pw_hash =…

html python-2.7 google-app-engine backend gqlquery

asked Nov 09 '16 at 05:24

Kelli Davis

1
1

0

votes

1 answer

GQL query by key syntax no longer works in GAE console

I have Datastore Viewer URLs stored for specific queries such as: SELECT * FROM User WHERE __key__ = key('User',9999) which now, in the updated console interface, don't work. Has the syntax changed?

google-app-engine gql gqlquery

asked Jun 07 '16 at 15:52

leontx

1,165
1
14
24

0

votes

1 answer

GqlQuery with selfreferenceproperty key

I have an entity with a selfreferencyproperty and I wanted to search with a WHERE condition on the selfref field's key. My intent is to reduce DB hits by building a list of keys, then iterating over the same entity to build a nested list. I am using…

google-app-engine gqlquery

asked Sep 07 '10 at 21:49

user441842

3
1

0

votes

1 answer

gqlQuerry comparing datetime objects

Here is the relevant code copied from my application on GAE. today = datetime.datetime.strptime(date_variable, "%d/%m/%Y") yesterday = ref_today - datetime.timedelta(days=1) tomorrow = ref_today + datetime.timedelta(days=1) logging.info('%s : %s …

python-2.7 google-app-engine gqlquery

asked Feb 21 '16 at 07:39

Sharma Anil

23
5

0

votes

0 answers

workaround on projection queries with equality filter

I have the following model in python Google App Engine: class UserAction(ndb.Model): author_gae_key = ndb.KeyProperty(indexed=True) target_gae_key = ndb.KeyProperty(indexed=True) # key of word, topic, etc. action_type =…

python google-app-engine gqlquery

asked Dec 31 '15 at 04:00

user3217125

579
5
12

0

votes

2 answers

How do I execute this query in GQL [Google App engine]?

I have a table of projects with two of it's columns as 'language' and 'tag'. After the user gives an input, I want to output all the projects whose language is input or tag is input. Sql query for above would be this, Sql query: Select * from…

google-app-engine gql gqlquery

asked Nov 10 '15 at 05:09

Wasim Thabraze

780
1
12
29

0

votes

1 answer

How to perform this GqlQuery?

I have the datastore as follows, class Data(db.Model): project = db.StringProperty() project_languages = db.ListProperty(str,default=[]) When user inputs a language (input_language), I want to output all the projects which contains the…

google-app-engine gql gqlquery

asked Nov 09 '15 at 12:20

Wasim Thabraze

780
1
12
29

0

votes

1 answer

GQL query checking numerical id within a list of ids

I'm trying to compare the unique numerical id of an element in my database with a list of longs. My GQL query should return those elements which have this id I'm passing as part of their array of longs. I've tried using a statement of the…

python google-app-engine gql gqlquery

asked Oct 23 '15 at 15:33

Rohil Verma

45
9

0

votes

1 answer

How do I use GQL to select a group that look like this Key('Group', '1779_1528')

How do I use GQL to select a group that look like this Key('Group', '1779_1528'). i tried: Select * from User where group = '1779_1528' Select * from User where group = Key('Group', '5335_5556') Select * from User where group HAS ANCESTOR…

mysql google-app-engine google-cloud-datastore gql gqlquery

asked Sep 15 '15 at 04:29

phongyewtong

5,085
13
56
81

0

votes

0 answers

GQL query for webapp2 Unique logins

I want to use GQL to find specific entries in Google App Engine Datastore. The entities that I want locate are webapp2 unique user records. I have tried structuring the query with keys, strings, etc, without success. EDIT: the entities' model is…

google-app-engine webapp2 gql gqlquery

asked Jul 07 '15 at 17:59

coffeerv

1
4

0

votes

2 answers

How to prevent multiple submission in database

I have made a simple guestbook where I have a

and a submit button.
When the submit button is clicked multiple times in short period of time, the same data will go in to the database multiple times. How do I prevent this?
Here is the…</div>
        <div class="grid ai-start jc-space-between fw-wrap">
            <div class="grid gs4 fw-wrap tags ">
                
                <a href="../../questions/tagged/python" class="post-tag grid--cell" title="show questions tagged 'python'" rel="tag">python</a> 
                
                <a href="../../questions/tagged/google-app-engine" class="post-tag grid--cell" title="show questions tagged 'google-app-engine'" rel="tag">google-app-engine</a> 
                
                <a href="../../questions/tagged/textarea" class="post-tag grid--cell" title="show questions tagged 'textarea'" rel="tag">textarea</a> 
                
                <a href="../../questions/tagged/gql" class="post-tag grid--cell" title="show questions tagged 'gql'" rel="tag">gql</a> 
                
                <a href="../../questions/tagged/gqlquery" class="post-tag grid--cell" title="show questions tagged 'gqlquery'" rel="tag">gqlquery</a> 
                
            </div>
            <div class="started mt0">
                
                    
<div class="s-user-card s-user-card">
    <time class="s-user-card--time" datetime="asked Oct 17 '14 at 17:35">asked Oct 17 '14 at 17:35</time>
    <a href="../../users/4154438/memmo-fiero" class="s-avatar s-avatar__32 s-user-card--avatar">
        <img class="s-avatar--image" src="../../users/profiles/4154438.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Memmo Fiero" />
    </a>
    <div class="s-user-card--info">
        <a href="../../users/4154438/memmo-fiero" class="s-user-card--link">Memmo Fiero</a>
        <ul class="s-user-card--awards">
            <li class="s-user-card--rep" title="reputation score">109</li>
            
            
            <li class="s-award-bling s-award-bling__bronze" title="7 bronze badges">7</li>
        </ul>
    </div>
</div>

</div>
        </div>
    </div>
</div>
                    </div>
                
                    <div class="mln24">
                    <div class="question-summary" id="question-summary-23774458">
    <div class="statscontainer">
        <div class="stats">
            <div class="vote">
                <div class="votes">
                    <span class="vote-count-post"><strong>0</strong></span>
                    <div class="viewcount">votes</div>
                </div>
            </div>

<div class="status answered-accepted">
                <strong>1</strong> answer
            </div>
        </div>
    </div>
    <div class="summary">
        
        <h3><a href="../../questions/23774458/ndb-query-select-both-key-and-properties-simultaneously" class="question-hyperlink">ndb query select both __key__ and properties simultaneously</a></h3>
        <div class="excerpt">Is it possible to select both the key as well as properties in an ndb query?
Right now I have:
one = ndb.gql('SELECT __key__ FROM Subject ORDER BY order ASC')
two = ndb.gql('SELECT name,order FROM Subject ORDER BY order ASC')

Is it possible to have…</div>
        <div class="grid ai-start jc-space-between fw-wrap">
            <div class="grid gs4 fw-wrap tags ">
                
                <a href="../../questions/tagged/google-app-engine" class="post-tag grid--cell" title="show questions tagged 'google-app-engine'" rel="tag">google-app-engine</a> 
                
                <a href="../../questions/tagged/app-engine-ndb" class="post-tag grid--cell" title="show questions tagged 'app-engine-ndb'" rel="tag">app-engine-ndb</a> 
                
                <a href="../../questions/tagged/gql" class="post-tag grid--cell" title="show questions tagged 'gql'" rel="tag">gql</a> 
                
                <a href="../../questions/tagged/gqlquery" class="post-tag grid--cell" title="show questions tagged 'gqlquery'" rel="tag">gqlquery</a> 
                
            </div>
            <div class="started mt0">
                
                    
<div class="s-user-card s-user-card">
    <time class="s-user-card--time" datetime="asked May 21 '14 at 05:14">asked May 21 '14 at 05:14</time>
    <a href="../../users/1122418/mrmo123" class="s-avatar s-avatar__32 s-user-card--avatar">
        <img class="s-avatar--image" src="../../users/profiles/1122418.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="mrmo123" />
    </a>
    <div class="s-user-card--info">
        <a href="../../users/1122418/mrmo123" class="s-user-card--link">mrmo123</a>
        <ul class="s-user-card--awards">
            <li class="s-user-card--rep" title="reputation score">725</li>
            <li class="s-award-bling s-award-bling__gold" title="1 gold badge">1</li>
            <li class="s-award-bling s-award-bling__silver" title="8 silver badge">8</li>
            <li class="s-award-bling s-award-bling__bronze" title="23 bronze badge">23</li>
        </ul>
    </div>
</div>

</div>
        </div>
    </div>
</div>
                    </div>

</div>
        </div>

</div>
        </div>
        <script src="../../static/js/stack-icons.js"></script>
        <script src="../../static/js/fromnow.js"></script>
        
    </body>
</html>

Questions tagged [gqlquery]