    SELECT date_trunc(&#39;day&#39;, user_logs.timestamp) &quot;day&quot;, count(*) views
    FROM user_logs
    WHERE user_logs.timestamp &gt;= %(timestamp_1)s
        AND user_logs.timestamp &lt;= %(timestamp_2)s
    group by 1
    ORDER BY 1

I want to find the background color of a Layout from my code. Is there any way to find it? something like `linearLayout.getBackgroundColor()`?

Get background color of a Layout

**EDIT 2**: TL;DR: **the answer was yes in 2013, but this flaw has been fixed**

By following the Getting Started instructions on vagrantup.com, I seem to end up with a virtual machine that is accepting SSH connections on port 2222 so that anyone can get root access to my VM and read my host working directory using the default credentials (username=password=vagrant or vagrant_insecure_private_key).

Is this true? If yes, why is it not considered a gaping security vulnerability? What if I had copied sensitive data to the VM?

**EDIT**: and for those who think anyone on the internet being able to read your sources and executing arbitrary code on your VM is not that bad, I recommend reading the &quot;Breaking out&quot; section in this blog post http://blog.ontoillogical.com/blog/2012/10/31/breaking-in-and-out-of-vagrant/

In a nutshell: running Vagrant &quot;as intended&quot; can also enable anyone to break into your host/development machine (e.g., by using a malicious git post-commit hook).



Vagrant insecure by default?

I&#39;ve got a table storing user access/view logs for the webservice I run. It tracks the time as a timestamp though I&#39;m finding when I do aggregate reporting I only care about the day, not the time.

I&#39;m currently running the following query:

    SELECT
        user_logs.timestamp
    FROM
        user_logs
    WHERE
        user_logs.timestamp &gt;= %(timestamp_1)s
        AND user_logs.timestamp &lt;= %(timestamp_2)s
    ORDER BY
        user_logs.timestamp

There are often other where conditions but they shouldn&#39;t matter to the question. I&#39;m using Postgres but I&#39;d assume whatever feature is used will work in other languages.

I pull the results into a Python script which counts the number of views per date but it&#39;d make much more sense to me if the database could group and count for me.

How do I strip it down so it&#39;ll group by the day and ignore the time?

Grouping timestamps by day, not by time

I've got a table storing user access/view logs for the webservice I run. It tracks the time as a timestamp though I'm finding when I do aggregate reporting I only care about the day, not the time.
I'm currently running the following query:
<pre><code class="hljs language-vbnet">SELECT
 user_logs.timestamp
FROM
 user_logs
WHERE
 user_logs.timestamp >= %(timestamp_1)s
 AND user_logs.timestamp &#x3C;= %(timestamp_2)s
ORDER BY
 user_logs.timestamp
</code></pre>
There are often other where conditions but they shouldn't matter to the question. I'm using Postgres but I'd assume whatever feature is used will work in other languages.
I pull the results into a Python script which counts the number of views per date but it'd make much more sense to me if the database could group and count for me.
How do I strip it down so it'll group by the day and ignore the time?

I have trailing spaces in a column in a SQL Server table called `Company Name`.

All data in this column has trailing spaces.

I want to remove all those, and I want to have the data without any trailing spaces.

The company name is like `&quot;Amit Tech Corp         &quot;`

I want the company name to be `&quot;Amit Tech Corp&quot;`

Remove Trailing Spaces and Update in Columns in SQL Server

I&#39;ve just got myself a little bit stuck with some SQL. I don&#39;t think I can phrase the question brilliantly - so let me show you.

I have two tables, one called person, one called appointment. I&#39;m trying to return the number of appointments a person has (including if they have zero). Appointment contains the `person_id` and there is a `person_id` per appointment. So `COUNT(person_id)` is a sensible approach.

The query:

    SELECT person_id, COUNT(person_id) AS &quot;number_of_appointments&quot; 
    FROM appointment 
    GROUP BY person_id;

Will return correctly, the number of appointments a person_id has. However, a person who has 0 appointments isn&#39;t returned (obviously as they are not in that table).

Tweaking the statement to take person_id from the person table gives me something like:

    SELECT person.person_id, COUNT(appointment.person_id) AS &quot;number_of_appointments&quot;
    FROM appointment
    JOIN person ON person.person_id = appointment.person_id
    GROUP BY person.person_id;

This however, will still only return a person_id who has an appointment and not what I want which is a return with persons who have 0 appointments!

Any suggestions please?

How to include &quot;zero&quot; / &quot;0&quot; results in COUNT aggregate?

This question is concerning joining two databases in Google spreadsheet using =QUERY function

I have a table like so in range A1:C3

    a d g
    b e h
    c f i

I have another table

    c j m
    a k n
    b l o

I want the final table to look like this

    a d g k n
    b e h l o 
    c f i j m

I can do this by using a vlookup function pretty easily in cell D1 and paste it down and across, but my dataset is huge. I would need a whole page of vlookups and Google Spreadsheet tells I&#39;m at my limit in complexities.

I look at the Google&#39;s Query Language reference... there doesn&#39;t seem to be an type of &quot;join&quot; functions mentioned. You would think it would be an easy &quot;join on A&quot; type operation.

Can anybody solves this without a vlookup?



Google spreadsheet &quot;=QUERY&quot; join() equivalent function?

I would like to know is there a way to select randomly generated number between 100 and 500 along with a select query. 

Eg: `SELECT name, address, random_number FROM users`

I dont have to store this number in db and only to use it to display purpose. 

I tried it something like this, but it can&#39;t get to work..

    SELECT name, address, FLOOR(RAND() * 500) AS random_number FROM users

Hope someone help me out.
Thank you

creating a random number using MYSQL

How can I convert this code to raw sql and use in rails? Because When I deploy this code in heroku,there is a request timeout error.I think this will be faster if I use raw sql.

    @payments = PaymentDetail.joins(:project).order(&#39;payment_details.created_at desc&#39;)
    @payment_errors = PaymentError.joins(:project).order(&#39;payment_errors.created_at desc&#39;)
    
    @all_payments = (@payments + @payment_errors)

Rails raw SQL example

How can I add an element to an Enum field in an alembic migration when using a version of PostgreSQL older than 9.1 (which adds the ALTER TYPE for enums)? [This](https://stackoverflow.com/questions/1771543/postgresql-updating-an-enum-type) SO question explains the direct process, but I&#39;m not quite sure how best to translate that using alembic.

This is what I have:

    new_type = sa.Enum(&#39;nonexistent_executable&#39;, &#39;output_limit_exceeded&#39;,
                       &#39;signal&#39;, &#39;success&#39;, &#39;timed_out&#39;, name=&#39;status&#39;)
    old_type = sa.Enum(&#39;nonexistent_executable&#39;, &#39;signal&#39;, &#39;success&#39;, &#39;timed_out&#39;,
                       name=&#39;status&#39;)
    tcr = sa.sql.table(&#39;testcaseresult&#39;,
                       sa.Column(&#39;status&#39;, new_type, nullable=False))
    
    
    def upgrade():
        op.alter_column(&#39;testcaseresult&#39;, u&#39;status&#39;, type_=new_type,
                        existing_type=old_type)
    
    
    def downgrade():
        op.execute(tcr.update().where(tcr.c.status==u&#39;output_limit_exceeded&#39;)
                   .values(status=&#39;timed_out&#39;))
        op.alter_column(&#39;testcaseresult&#39;, u&#39;status&#39;, type_=old_type,
                        existing_type=new_type)

The above unfortunately only produces `ALTER TABLE testcaseresult ALTER COLUMN status TYPE status` upon upgrade, which essentially does nothing.

Altering an Enum field using Alembic

I have the following SQL which I need to do

    CREATE TABLE cars_users2 AS SELECT DISTINCT * FROM cars_users;
    
    DROP TABLE cars_users;
    
    ALTER TABLE cars_users2 RENAME TO cars_users;

since I cannot use heroku dataclips to drop a table, I cannot use dataclips.

So I guess I need to do this in a migration.

How do I write this sql as a migration?

How to write SQL in a migration in Rails

How is it possible to get the current sequence value in postgresql 8.4?

Note: I need the value for the some sort of statistics, just retrieve and store. Nothing related to the concurrency and race conditions in case of manually incrementing it isn&#39;t relevant to the question.

Note 2: The sequence is shared across several tables

Note 3: `currval` won&#39;t work because of:

 - Return the value most recently obtained by nextval for this sequence in the current session
 - `ERROR: currval of sequence &quot;&lt;sequence name&gt;&quot; is not yet defined in this session`

My current idea: is to parse DDL, which is weird

Options to retrieve the current (on a moment of running query) sequence value

I&#39;ve have a Django app that&#39;s currently hosted up on Amazon&#39;s EC2 service. I have two machines, one with the Django app and the other with my PostgreSQL database. So far it has been rock solid. 

Many sources claim I should implement Redis into my stack, but what would be the purpose of implementing Redis with Django and Postgresql? How can I implement Redis in my Django code for example? 

How can I use it with PostgreSQL? 

These are all the questions I&#39;ve been trying to find answers to so I came here hoping to get answers from the biggest and the best. I really appreciate any answers. 

Thank You

Content Type	Original Author	Original Content on Stackoverflow
Question	Teifion	View Question on Stackoverflow
Solution 1 - Sql	Clodoaldo Neto	View Answer on Stackoverflow

Grouping timestamps by day, not by time

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Vagrant insecure by default?

Get background color of a Layout

Attributions