This site is an archive; learn more about 8 years of OpenHatch.

[OH-Dev] For a good time, run this SQL in production

Asheesh Laroia lists at asheesh.org
Thu Mar 15 19:08:30 UTC 2012


Excerpts from Walker Hale IV's message of Wed Mar 14 18:54:47 -0400 2012:
> Asheesh,
> 
> When I locally install 2012-03-12.json and run this command, I get one
> row back (for username=twiggy):
> 
> select * from auth_user
> where id not in (select user_id from profile_person)
> 
> I should get zero rows back. I am not authorized to run this query in
> production. Could you take a look?

mysql> select id,username,first_name,last_name,email,is_staff,is_active,is_superuser,last_login,date_joined from auth_user where id not in (select user_id from profile_person);
+----+----------+------------+-----------+-------+----------+-----------+--------------+---------------------+---------------------+
| id | username | first_name | last_name | email | is_staff | is_active | is_superuser | last_login          | date_joined         |
+----+----------+------------+-----------+-------+----------+-----------+--------------+---------------------+---------------------+
|  2 | twiggy   |            |           |       |        0 |         1 |            0 | 2009-07-12 13:11:03 | 2009-07-12 13:11:03 |
+----+----------+------------+-----------+-------+----------+-----------+--------------+---------------------+---------------------+
1 row in set (0.02 sec)

Our friend, twiggy! Raphael Krut-Landau will remember him, if he's still
on the list.

Twiggy was a demo user.

We should probably remove him.

-- Asheesh.


More information about the Devel mailing list