Skip to content

Instantly share code, notes, and snippets.

@galitskyd
Created September 19, 2017 14:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save galitskyd/5d0ecc55d87743ea46432de12f3120d5 to your computer and use it in GitHub Desktop.
Save galitskyd/5d0ecc55d87743ea46432de12f3120d5 to your computer and use it in GitHub Desktop.
import csv
from ftphosting.ftp.models import *
active_sites = [2,18,45,55,67,98,125,130,133,134,136,137,139,154,240,257,314,334,361,452,626,639,644,660,674,680,729,761,826,895,911,922,938,976,1039,1051,1054,1059,1074,1158,1181,1185,1194,1223,1241,1332,1361,1379,1396,1452,1455,1461,1493,1526,1556,1567,1608,1646,1647,1691,1744,1761,1795,1796,1820,1825,1851,1855,1856,1858,1874,1885,1911,1920,1928,1934,1956,1978,1993,2000,2011,2012,2097,2098,2129,2131,2147,2200,2238,2241,2245,2247,2257,2309,2349,2357,2366,2429,2449,2456,2485,2500,2512,2593,2609,2653,2654,2684,2698,2710,2716,2735,2807,2841,2857,2889,2897,2914,2935,2956,2959,2967,3052,3061,3065,3066,3081,3086,3102,3190,3230,3264,3270,3280,3290,3312,3351,3387,3395,3407,3427,3453,3454,3481,3524,3550,3606,3723,3730,3733,3748,3759,3821,3844,3906,3918,3920,3943,3946,3981,3984,4015,4026,4123,4128,4134,4147,4173,4179,4247,4272,4273,4308,4342,4356,4370,4381,4409,4434,4441,4466,4486,4558,4610,4672,4678,4689,4691,4718,4745,4746,4747,4754,4777,4793,4812,4845,4864,4876,4877,4894,4954,4962,4964,5030,5037,5056,5087,5107,5115,5167,5174,5197,5206,5216,5236,5273,5295,5304,5305,5306,5311,5320,5331,5340,5344,5349,5351,5361,5377,5402,5423,5428,5474,5537,5551,5552,5553,5591,5596,5598,5610,5611,5796,5824,5847,5899,5920,5922,5984,5987,6007,6053,6128,6140,6146,6170,6205,6220,6238,6267,6268,6280,6296,6297,6315,6319,6333,6341,6375,6427,6430,6477,6518,6526,6528,6546,6558,6614,6630,6675,6695,6717,6741,6753,6758,6817,6823,6860,6883,6906,6959,7003,7012,7020,7047,7157,7190,7228,7281,7299,7314,7331,7382,7383,7396,7431,7445,7474,7551,7553,7600,7631,7652,7657,7674,7705,7714,7872,7900,7906,7964,7974,7984,7988,8015,8018,8021,8053,8072,8104,8229,8263,8293,8318,8345,8360,8379,8409,8506,8512,8525,8538,8548,8608,8615,8616,8691,8945,8947,9014,9022,9029,9099,9147,9165,9306,9434,9452,9460,9503,9535,9565,9625,9640,9679,9691,9784,9789,9825,9840,9857,9873,9908,9916,9937,9943,9985,10002,10003,10004,10005,10023,10042,10070,10083,10100,10128,10130,10146,10171,10177,10202,10212,10247,10255,10287,10302,10306,10347,10349,10354,10360,10375,10400,10410,10414,10421,10443,10465,10470,10486,10490,10559,10674,10698,10711,10722,10816,10915,10921,10942,10961,10974,11024,11027,11068,11095,11142,11160,11179,11187,11190,11201,11212,11243,11259,11320,11335,11350,11389,11391,11396,11450,11455,11494,11503,11508,11524,11539,11556,11617,11709,11909,11945,12149,12237,12281,12369,12381,12393,12553,12613,12673,12681,12697,12721,12725,12769,12853,12865,12873,12893,12933,12997,13289,13317,13321,13481,13605,13617,13637,13761,13765,14209,14301,14525,14541,14917,15193,15365,15445,15481,15677,15809,15813,15837,16053,16217,16265,16313,16377,16433,16449,16497,16517,16641,16689,16693,16837,16905,16945,17021,17341,17461,17677,17741,17893,17933,18069,18077,18237,18289,18305,18381,18469,18549,18633,18685,18921,18925,19093,19125,19265,19529,19905,20253,20333,20357,20413,20493,20553,20573,20637,20709,20713,20721,20805,20905,21081,21097,21273,21321,21329,21345,21353,21377,21413,21457,21593,21605,21661,21761,21805,21881,21949,22189,22229,22261,22325,22389,22657,22665,22693,22701,22765,22849,22933,22945,23109,23141,23181,23329,23349,23473,23489,23521,23585,23665,23753,23801,23837,23885,23949,23957,24357,24457,24557,24637,24809,24837,24861,25161,25173,25237,25273,25301,25413,25517,25545,25685,25701,25713,25801,25841,25849,26021,26185,26229,26237,26261,26389,26493,26513,26577,26633,26713,26749,26841,27013,27105,27281,27425,27469,27501,27517,27537,27605,27673,27713,27805,27829,27877,27946,28154,28366,28410,28490,28498,28658,28670,28726,28738,28794,28850,28898,29030,29082,29170,29194,29234,29242,29258,29394,29478,29550,29642,29698,29878,29978,30030,30326,30338,30342,30346,30354,30358,30362,30370,30374,30378,30386,30390,30394,30402,30406,30414,30490,30502,30518,30526,30530,30542,30546,30566,30570,30626,30638,30650,30654,30658,30666,30670,30678,30826,30958,31026,31098,31214,31234,31254,31290,31406,31534,31550,31602,31630,31910,32094,32106,32206,32266,32330,32354,32362,32718,32738,32954,32998,33042,33058,33074,33086,33090,33186,33482,33534,33558,33610,33618,33630,33638,33690,33718,33742,33810,33858,33918,34090,34218,34262,34354,34438,34558,34602,34610,34702,34706,34726,34774,34778,35046,35186,35190,35238,35302,35374,35514,35550,35702,35718,35726,35802,35830,35870,35946,35986,36018,36106,36178,36362,36374,36386,36438,36482,36614,36726,36882,36982,36990,37146,37154,37182,37218,37230,37274,37286,37290,37302,37318,37342,37446,37574,37586,37742,37782,37826,37862,37982,38170,38266,38522,38582,38606,38638,38670,38674,38918,39034,39106,39142,39186,39198,39486,39498,39670,39678,39834,40054,40338,40534,40886,41058,41066,41074,41094,41222,41242,41486,41534,41550,41618,41630,42066,42298,42434,42654,42682,42714,42746,42758,42762,42790,42810,42862,42962,43154,43182,43330,43354,43410,43442,43594,43822,43858,43870,43922,43962,44254,44322,44346,44354,44478,44554,44566,44646,44722,44826,44842,45138,45258,45326,45330,45374,45422,45706,45710,46038,46094,46234,46254,46258,46422,46686,46850,46902,47262,47528,47646,47648,47658,47954,47972,48006,48020,48066,48134,48166,48214,48256,48286,48300,48306,48378,48420,48462,48538,48544,48702,48728,48780,48806,48820,48984,49050,49204,49308,49434,49442,49454,49468,49514,49590,49634,49698,49726,49770,49772,49776,49798,49854,49930,50036,50086,50088,50254,50302,50346,50396,50468,50472,50596,50674,50742,50886,50900,50948,51030,51032,51208,51296,51318,51434,51474,51568,51681,51773,52011,52173,52447,52531,52603,52647,52671,52681,52821,52861,52901,52995,53105,53107,53113,53159,53239,53285,53363,53389,53427,53737,53797,53871,53953,53967,53987,53993,54011,54023,54079,54103,54105,54149,54153,54157,54199,54215,54221,54247,54351,54401,54403,54467,54485,54501,54515,54539,54543,54631,54667,54763,54769,54791,54797,54813,54817,54943,55003,55021,55071,55079,55207,55231,55241,55243,55337,55403,55429,55463,55481,55493,55501,55519,55665,55683,55803,55845,55873,55965,55981,56053,56083,56103,56141,56143,56151,56203,56213,56225,56319,56345,56353,56381,56399,56401,56543,56573,56657,56717,56765,56811,56821,56849,56851,56857,56923,57012,57014,57018,57022,57058,57094,57126,57166,57198,57240,57302,57312,57456,57500,57504,57514,57578,57726,57798,57824,57923,57995,58076,58138,58228,58236,58240,58304,58334,58440,58548,58564,58570,58578,58592,58614,58652,58732,58742,58788,58798,58822,58952,59082,59114,59126,59130,59184,59226,59236,59308,59320,59346,59474,59554,59608,59630,59636,59716,59789,59845,59849,59893,60039,60041,60045,60123,60145,60273,60337,60377,60391,60407,60423,60475,60483,60603,60681,60725,60741,60751,60771,60775,60857,60867,60929,60939,61013,61019,61037,61097,61099,61175,61191,61197,61215,61535,61559,61609,61615,61677,61709,61733,61739,61765,61847,61865,61939,61959,61971,62051,62077,62093,62121,62179,62193,62233,62257,62333,62335,62343,62359,62371,62407,62411,62437,62489,62493,62667,62695,62729,62769,62797,62813,62837,62845,62893,62963,63017,63055,63115,63189,63225,63257,63265,63307,63397,63435,63453,63459,63461,63467,63491,63505,63543,63575,63579,63627,63637,63639,63681,63723,63809,63871,63913,63971,63987,63997,64003,64065,64077,64125,64139,64235,64309,64321,64349,64441,64489,64523,64553,64557,64759,64761,64765,64793,64849,64871,64903,64919,64921,64937,65045,65047,65093,65161,65165,65207,65239,65257,65289,65369,65381,65445,65461,65525,65627,65675,65687,65697,65701,65733,65879,65957,66011,66029,66075,66113,66157,66187,66247,66257,66273,66283,66291,66301,66411,66439,66489,66519,66551,66609,66669,66699,66775,66865,66921,67009,67131]
admin_emails = []
for site in Site.objects.filter(id__in=active_sites):
admins = site.get_admins()
for admin in admins:
admin_emails.append(admin.email)
with open('/tmp/admin_emails.csv', 'wb') as ofile:
for email in admin_emails:
ofile.write(email + ',/n')
print("File written successfully: `/tmp/admin_emails.csv`")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment