How can I change the email alert frequency settings for every user?

Question

asked 2012-10-31 14:39:27 -0500

381 ● 7 ● 4 ● 24
http://www.astrobin.com/

Since I haven't launched my Askbot site yet, but I have thousands of users in my database, I want to change all their email alert frequency settings to the default values.

How can I do that with Django ORM or MySql?

Thanks!

Accepted Answer

answered 2012-10-31 14:47:38 -0500

siovene

381 ● 7 ● 4 ● 24
http://www.astrobin.com/

I've got it!

**mysql> update askbot_emailfeedsetting set frequency='i' where feed_type='m_and_c';
Query OK, 2711 rows affected (0.09 sec)
Rows matched: 2713  Changed: 2711  Warnings: 0

mysql> update askbot_emailfeedsetting set frequency='i' where feed_type='q_ask';
Query OK, 2709 rows affected (0.09 sec)
Rows matched: 2712  Changed: 2709  Warnings: 0

mysql> update askbot_emailfeedsetting set frequency='n' where feed_type='q_all';
Query OK, 2711 rows affected (0.08 sec)
Rows matched: 2712  Changed: 2711  Warnings: 0

mysql> update askbot_emailfeedsetting set frequency='i' where feed_type='q_sel';
Query OK, 2711 rows affected (0.04 sec)
Rows matched: 2712  Changed: 2711  Warnings: 0

mysql> update askbot_emailfeedsetting set frequency='d' where feed_type='q_ans';
Query OK, 2 rows affected (0.08 sec)
Rows matched: 2712  Changed: 2  Warnings: 0

They should be added automatically actually. There is a function user.add_missing_askbot_subscriptions() which will set the default values.
Evgeny ( 2012-10-31 15:07:07 -0500 )edit
Yeah, but mine weren't missing. I just didn't set them to my liking, and wanted to change them.
siovene ( 2012-10-31 15:30:28 -0500 )edit

How can I change the email alert frequency settings for every user?

Comments

1 Answer

Comments

Your answer

Reliable Askbot Hosting

Question tools

Stats

Related questions