def handle(self, *args, **options): links = ['https://www.facebook.com/318748909507/videos/649968942464224', 'https://www.facebook.com/318748909507/videos/2612971758972997/', 'https://www.facebook.com/318748909507/videos/498942800766464/', 'https://www.facebook.com/318748909507/videos/527572888153782/', 'https://www.facebook.com/318748909507/videos/926772904410122/', 'https://www.facebook.com/318748909507/videos/2574431759464489/', 'https://www.facebook.com/318748909507/videos/247198643102613/', 'https://www.facebook.com/318748909507/videos/1588663631296750/', 'https://www.facebook.com/318748909507/videos/2665635223721596/', 'https://www.facebook.com/318748909507/videos/2669484819990940/', 'https://www.facebook.com/318748909507/videos/535514280498748/', 'https://www.facebook.com/318748909507/videos/3697736870267369/', 'https://www.facebook.com/318748909507/videos/705004410305115/', 'https://www.facebook.com/318748909507/videos/3025730300817570/', 'https://www.facebook.com/318748909507/videos/222023952224132/', 'https://www.facebook.com/318748909507/videos/659991487900808/', 'https://www.facebook.com/318748909507/videos/629913900921785/', 'https://www.facebook.com/318748909507/videos/165132848228069/', 'https://www.facebook.com/318748909507/videos/184435959355973/', 'https://www.facebook.com/318748909507/videos/244576203543813/', 'https://www.facebook.com/318748909507/videos/276445793512600/', 'https://www.facebook.com/318748909507/videos/710323713052933/', 'https://www.facebook.com/318748909507/videos/246632956586240/', 'https://www.facebook.com/318748909507/videos/556846081927489/', 'https://www.facebook.com/318748909507/videos/171019884353180/' ] user_model = get_user_model() username = '******' user = user_model.objects.get( username=username ) group = Group() group.name = 'Soccer Drills 4' group.user = user group.save() index = 0 for link in links: session = Session() session.user = user session.group = group session.link = link session.index = index session.save() index += 1
async def get_session_by_hash(self, session_hash: str) -> Union[Session, None]: sql = "SELECT * FROM sessions WHERE hash = $1" async with self.pool.acquire() as con: # type: Connection row = await con.fetchrow(sql, session_hash) if row is None: return None session = Session() session.id = row['id'] session.user = await self.get_user_by_id(user_id=row['user']) session.hash = row['hash'] session.created = row['created'] session.last_used = row['last_used'] session.last_ip = row['last_ip'] return session
async def new_session(self, user_id: UUID, ip: str) -> Session: session_id = uuid4() user = await self._get_user(user_id=user_id) created = datetime.utcnow() sess_hash = sha256( (u"%s %s %s" % (session_id, user.id, created)).encode("utf8")).hexdigest() sql = "INSERT INTO sessions (id, \"user\", hash, created, last_used, last_ip) VALUES ($1, $2, $3, $4, $5, $6)" async with self.pool.acquire() as con: # type: Connection await con.execute(sql, session_id, user_id, sess_hash, created, created, ip) session = Session() session.id = session_id session.user = user session.hash = sess_hash session.created = created session.last_used = created session.last_ip = ip return session
def handle(self, *args, **options): links = [ 'https://www.facebook.com/318748909507/videos/649968942464224', 'https://www.facebook.com/318748909507/videos/2612971758972997/', 'https://www.facebook.com/318748909507/videos/498942800766464/', 'https://www.facebook.com/318748909507/videos/527572888153782/', 'https://www.facebook.com/318748909507/videos/926772904410122/', 'https://www.facebook.com/318748909507/videos/2574431759464489/', 'https://www.facebook.com/318748909507/videos/247198643102613/', 'https://www.facebook.com/318748909507/videos/1588663631296750/', 'https://www.facebook.com/318748909507/videos/2665635223721596/', 'https://www.facebook.com/318748909507/videos/2669484819990940/', 'https://www.facebook.com/318748909507/videos/535514280498748/', 'https://www.facebook.com/318748909507/videos/3697736870267369/', 'https://www.facebook.com/318748909507/videos/705004410305115/', 'https://www.facebook.com/318748909507/videos/3025730300817570/', 'https://www.facebook.com/318748909507/videos/222023952224132/', 'https://www.facebook.com/318748909507/videos/659991487900808/', 'https://www.facebook.com/318748909507/videos/629913900921785/', 'https://www.facebook.com/318748909507/videos/2911103542318651/', 'https://www.facebook.com/318748909507/videos/836336946858397/', 'https://www.facebook.com/318748909507/videos/245310483493661/', 'https://www.facebook.com/318748909507/videos/251541702868527/', 'https://www.facebook.com/318748909507/videos/2614751715434132/', 'https://www.facebook.com/318748909507/videos/165132848228069/', 'https://www.facebook.com/318748909507/videos/184435959355973/', 'https://www.facebook.com/318748909507/videos/244576203543813/', 'https://www.facebook.com/318748909507/videos/276445793512600/', 'https://www.facebook.com/318748909507/videos/710323713052933/', 'https://www.facebook.com/318748909507/videos/246632956586240/', 'https://www.facebook.com/318748909507/videos/556846081927489/', 'https://www.facebook.com/318748909507/videos/171019884353180/' ] user_model = get_user_model() username = '******' user = user_model.objects.filter(username=username).first() if not user: user = user_model.objects.create_superuser(username=username, password='******') user_settings = UserSettings() user_settings.user = user user_settings.dark_theme = True user_settings.save() group = Group() group.name = 'Test 1' group.user = user group.save() session = Session() session.user = user session.group = group session.link = 'http://www.google.com' session.index = 0 session.save() session = Session() session.user = user session.group = group session.link = 'http://www.google.com' session.index = 1 session.save() session = Session() session.user = user session.group = group session.link = 'http://www.google.com' session.index = 2 session.save() session = Session() session.user = user session.group = group session.link = 'http://www.google.com' session.index = 3 session.save() group = Group() group.name = 'Test 2' group.user = user group.save() group = Group() group.name = 'Test 3' group.user = user group.save() group = Group() group.name = 'Soccer Drills' group.user = user group.save() index = 0 for link in links: session = Session() session.user = user session.group = group session.link = link session.index = index session.save() index += 1