{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import sys, os" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "sys.path.append('/Users/joel/src/thundr/tracker')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "username = 'germany'" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "spotify = \"\"\"\n", "spotify:user:spotify:playlist:37i9dQZF1DX5jaJwnxMHFn\n", "spotify:user:spotify:playlist:37i9dQZF1DX4jP4eebSWR9\n", "spotify:user:spotify:playlist:37i9dQZF1DXcEJw9C2rUbi\n", "spotify:user:spotify:playlist:37i9dQZF1DX9WU5Losjsy8\n", "spotify:user:spotify:playlist:37i9dQZF1DWUW2bvSkjcJ6\n", "spotify:user:spotify:playlist:37i9dQZF1DX0gbcr80GO9l\n", "spotify:user:spotify:playlist:37i9dQZF1DWSFDWzEZlALC\n", "spotify:user:spotify:playlist:37i9dQZF1DX2lUf1uE6Mre\n", "spotify:user:spotify:playlist:37i9dQZF1DX36edUJpD76c\n", "spotify:user:spotify:playlist:37i9dQZF1DWSTqUqJcxFk6\n", "spotify:user:spotify:playlist:37i9dQZF1DX0Na9FTYame5\n", "spotify:user:spotify:playlist:37i9dQZF1DX2YejlcRQo1e\n", "spotify:user:spotify:playlist:37i9dQZF1DX8ttEdg9VJHO\n", "spotify:user:spotify:playlist:37i9dQZF1DX5FlZmJ3JWL1\n", "spotify:user:spotify:playlist:37i9dQZF1DXdcGcdKNYAG0\n", "spotify:user:spotify:playlist:37i9dQZF1DX2YSAZIuAiB1\n", "spotify:user:spotify:playlist:37i9dQZF1DWSGhQVrPck2m\n", "spotify:user:spotify:playlist:37i9dQZF1DX05Mltk4BtiL\n", "spotify:user:spotify:playlist:37i9dQZF1DX1htCFhfVtyK\n", "spotify:user:spotify:playlist:37i9dQZF1DXbHTRQKCdV52\n", "spotify:user:spotify:playlist:37i9dQZF1DWX7rdRjOECPW\n", "spotify:user:spotify:playlist:37i9dQZF1DXbKGrOUA30KN\n", "spotify:user:spotify:playlist:37i9dQZF1DWURW6ov0F5Ak\n", "spotify:user:spotify:playlist:37i9dQZF1DX29KIe1kv8n3\n", "spotify:user:spotify:playlist:37i9dQZF1DX4uPi2roRUwU\n", "spotify:user:spotify:playlist:37i9dQZF1DX2uJ1OVfn3CH\n", "spotify:user:spotify:playlist:37i9dQZF1DXbX3zSzB4MO0\n", "spotify:user:spotify:playlist:37i9dQZF1DWXxGT6t7a314\n", "spotify:user:spotify:playlist:37i9dQZF1DX8AliSIsGeKd\n", "spotify:user:spotify:playlist:37i9dQZF1DX4TiN7pMwV0Z\n", "spotify:user:spotify:playlist:37i9dQZF1DX1WhyP6stXXl\n", "spotify:user:spotify:playlist:37i9dQZF1DX9EM98aZosoy\n", "spotify:user:spotify:playlist:37i9dQZF1DWZJhOVGWqUKF\n", "spotify:user:spotify:playlist:37i9dQZF1DXaIrEwuQ3hyy\n", "spotify:user:spotify:playlist:37i9dQZF1DX6KItbiYYmAv\n", "spotify:user:spotify:playlist:37i9dQZF1DXcn67fMiU8jb\n", "spotify:user:spotify:playlist:37i9dQZF1DWZESE3fHLhmD\n", "spotify:user:spotify:playlist:37i9dQZF1DX5wcoyvtNnP4\n", "spotify:user:spotify:playlist:37i9dQZF1DX8FmtpZigIQk\n", "spotify:user:spotify:playlist:37i9dQZF1DX8Kgdykz6OKj\n", "spotify:user:spotify:playlist:37i9dQZF1DX3Ebqev5IkYU\n", "spotify:user:spotify:playlist:37i9dQZF1DX37cXruBmbRS\n", "spotify:user:spotify:playlist:37i9dQZF1DX8Dd9bxD1WYH\n", "spotify:user:spotify:playlist:37i9dQZF1DX9C7yrj7Bl8r\n", "spotify:user:spotify:playlist:37i9dQZF1DWVdgXTbYm2r0\n", "spotify:user:spotify:playlist:37i9dQZF1DXbz5uvvU2C9n\n", "spotify:user:spotify:playlist:37i9dQZF1DWZSeAwtQzvji\n", "spotify:user:spotify:playlist:37i9dQZF1DWSWyJydK4fTU\n", "spotify:user:spotify:playlist:37i9dQZF1DWWEQmYXXOzi0\n", "spotify:user:spotify:playlist:37i9dQZF1DWWM6GBnxtToT\n", "spotify:user:spotify:playlist:37i9dQZF1DX7ZUug1ANKRP\n", "spotify:user:spotify:playlist:37i9dQZF1DX8hcTuUCeYxa\n", "spotify:user:spotify:playlist:37i9dQZF1DX6RA5ZrA5a23\n", "spotify:user:spotify:playlist:37i9dQZF1DWTvNyxOwkztu\n", "spotify:user:spotify:playlist:37i9dQZF1DX5GuMRZBomNE\n", "spotify:user:spotify:playlist:37i9dQZF1DX07Bg0Q5GozA\n", "spotify:user:spotify:playlist:37i9dQZF1DX6j6TEp70WNZ\n", "spotify:user:spotify:playlist:37i9dQZF1DX79bPfjTeYGx\n", "spotify:user:spotify:playlist:3uLbbdNhIs5eU5IN5Fyda4\n", "spotify:user:spotify:playlist:37i9dQZF1DWTA0RRFCoIUN\n", "spotify:user:spotify:playlist:37i9dQZF1DX1FMxcobUJLz\n", "spotify:user:spotify:playlist:37i9dQZF1DX1BzILRveYHb\n", "spotify:user:spotify:playlist:37i9dQZF1DX0XYoY9uUkXA\n", "spotify:user:spotify:playlist:37i9dQZF1DX0hvSv9Rf41p\n", "spotify:user:spotify:playlist:37i9dQZF1DX843Qf4lrFtZ\n", "spotify:user:spotify:playlist:37i9dQZF1DX3MU5XUozve7\n", "spotify:user:spotify:playlist:37i9dQZF1DXbwoaqxaoAVr\n", "spotify:user:spotify:playlist:37i9dQZF1DWT6SJaitNDax\n", "spotify:user:spotify:playlist:37i9dQZF1DXaJN8jVBUEiZ\n", "spotify:user:spotify:playlist:37i9dQZF1DXdsy92d7BLpC\n", "spotify:user:spotify:playlist:37i9dQZF1DX5xiztvBdlUf\n", "\"\"\".split()" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "No buildsha.py defined. sha will be 'NOT_SET'\n", "Not using secrets manager\n", "use_my_whitelist_cache False\n" ] } ], "source": [ "from tracker import db" ] }, { "cell_type": "code", "execution_count": 63, "metadata": {}, "outputs": [], "source": [ "db.Session.remove()" ] }, { "cell_type": "code", "execution_count": 64, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Engine(postgres://bot:***@whitelist2.cbn1zk7uet6r.eu-west-1.rds.amazonaws.com:5432/wl_us_ultra?sslmode=require)" ] }, "execution_count": 64, "metadata": {}, "output_type": "execute_result" } ], "source": [ "db.setup_session()\n", "db.Session.rollback()\n", "db.Session.get_bind()\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from api.resources.admin import upsert_spotify_playlist" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "for uri in spotify[25:]:\n", " try:\n", " upsert_spotify_playlist(username=username, url_or_uri=uri)\n", " except Exception as e:\n", " import sys\n", " print(\"Utter failure on {}\".format(uri))\n", " print(sys.exc_info())\n", " else:\n", " print(\"Done: {}\".format(uri))" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from tracker import spotify as spot" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "for uri in spotify:\n", " user, spyid = spot.decode_url_or_uri(uri)\n", " exist = db.Session.query(db.UsersSpyPlaylists).filter_by(username=username, spyid=spyid).first()\n", " print(\"Result: \", uri, exist is not None)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from tracker.youtube import youtube\n", " " ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def get_yt_channel(channel_id):\n", " res = youtube.get_channel(channel_id=channel_id)\n", " if 'items' in res:\n", " item0 = res['items'][0]\n", " return item0" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def create_yt_record(username, channel_data):\n", " ytid = channel_data['id']['channelId']\n", " name = channel_data['snippet']['title']\n", " exists = db.Session.query(db.YtChannel).get(ytid)\n", " if not exists:\n", " db.Session.add(db.YtChannel(ytid=ytid, name=name))\n", " db.Session.flush()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "youtublers = \"\"\"\n", "https://www.youtube.com/channel/UCG0f1o3GoPJWGHsb0FRc8ug\n", "https://www.youtube.com/channel/UCFZ75Bg73NJnJgmeUX9l62g\n", "https://www.youtube.com/channel/UCXIyz409s7bNWVcM-vjfdVA\n", "https://www.youtube.com/channel/UCl7UWnHw13IsfFAqU9DsA2A\n", "https://www.youtube.com/channel/UCttOBQS6RSh8avmR8vcrB8A\n", "https://www.youtube.com/channel/UClDlxHXefg3Jh7gLx0-aDew\n", "https://www.youtube.com/channel/UCpBwMEZcpf_oCWuqHUPLtHw\n", "https://www.youtube.com/channel/UCdjZk4tVh36cykHUWBWnR4w\n", "https://www.youtube.com/channel/UCqbKhBvxM3qWzC8huPiifYg\n", "https://www.youtube.com/channel/UCVEZoPRBgiJHTjrfa_LDVEg\n", "https://www.youtube.com/channel/UC1Tq1skVDxKIJdiqd9ey_hg\n", "https://www.youtube.com/channel/UC8OZsdWmGCM-vojiQmtUK8g\n", "\"\"\".split()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "for chan in youtublers:\n", " chan_data = get_yt_channel(chan.split('/')[-1])\n", " if chan_data:\n", " print(chan)\n", " create_yt_record(username, chan_data)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Instagram 📸" ] }, { "cell_type": "code", "execution_count": 56, "metadata": {}, "outputs": [], "source": [ "instas = [s for s in \"\"\"https://www.instagram.com/bjeinar\n", "https://www.instagram.com/eddieteagle\n", "https://www.instagram.com/livejulianne\n", "https://www.instagram.com/ninaqvam\n", "https://www.instagram.com/mariekomissar\n", "https://www.instagram.com/anetteea\n", "https://www.instagram.com/gronnrune\n", "https://www.instagram.com/kristoffer.aase\n", "https://www.instagram.com/rykkinnfella \n", "https://www.instagram.com/felixbryngell\n", "https://www.instagram.com/noramamdu\n", "https://www.instagram.com/lwnygaard\n", "https://www.instagram.com/trinehartz\n", "https://www.instagram.com/eriksenviktoria\n", "https://www.instagram.com/sindruseidus\n", "https://www.instagram.com/frankjohansen\n", "https://www.instagram.com/yngvenaess\n", "https://www.instagram.com/loddbolt\n", "https://www.instagram.com/siljesjul\n", "https://www.instagram.com/jarlnymo\n", "https://www.instagram.com/murakami_yumi\n", "https://www.instagram.com/pawlbruns\n", "https://www.instagram.com/alvaore\n", "https://www.instagram.com/krigerdanne\n", "https://www.instagram.com/jojooooooooo\n", "https://www.instagram.com/siljehope\n", "https://www.instagram.com/katrinenagy\n", "https://www.instagram.com/benedictevib\n", "https://www.instagram.com/espolini\n", "https://www.instagram.com/andreasoverland\n", "https://www.instagram.com/matsjoa\n", "https://www.instagram.com/minanergaard\n", "https://www.instagram.com/karolineringstad\n", "https://www.instagram.com/kristinassa\n", "https://www.instagram.com/rachel_d_stanger\n", "https://www.instagram.com/mariusskullerud\n", "https://www.instagram.com/eiriklydmann\n", "https://www.instagram.com/domi_ef\n", "https://www.instagram.com/christinkrag\n", "https://www.instagram.com/lenecharlottewa\n", "https://www.instagram.com/lenecharlottewa\n", "https://www.instagram.com/leribe\n", "https://www.instagram.com/ivarhenry\n", "https://www.instagram.com/inamargrethe\n", "https://www.instagram.com/reinfjell\n", "https://www.instagram.com/l_herlung\n", "https://www.instagram.com/hannahsofia\n", "https://www.instagram.com/midtstue\n", "https://www.instagram.com/lenirugsveen\n", "https://www.instagram.com/monaolsen\n", "https://www.instagram.com/errrlend\n", "https://www.instagram.com/matea.grovik\n", "https://www.instagram.com/yordanajakobsen\n", "https://www.instagram.com/tarjei.van.ravens\n", "https://www.instagram.com/oivindgehrken\n", "https://www.instagram.com/djbeatriixx\n", "https://www.instagram.com/shegotwhat\n", "https://www.instagram.com/siljeborgan/\n", "https://www.instagram.com/limita/\n", "https://www.instagram.com/trine_j/\n", "https://www.instagram.com/guttormraa/\n", "https://www.instagram.com/kimerikpedersen/\n", "https://www.instagram.com/viviansormeland/\n", "https://www.instagram.com/asbjornmyrvold/\n", "https://www.instagram.com/claesol/\n", "https://www.instagram.com/fosnes/\n", "https://www.instagram.com/kimaasli/\n", "https://www.instagram.com/trondopsahl/\n", "https://www.instagram.com/toffeng/\n", "https://www.instagram.com/larsenerlend/\n", "https://www.instagram.com/vibekehaywold/\n", "https://www.instagram.com/peer101/\n", "https://www.instagram.com/steffenkjevik/\n", "https://www.instagram.com/leiffosselie/\n", "https://www.instagram.com/kikinetell/\n", "https://www.instagram.com/odaxsol/\n", "https://www.instagram.com/marirustoy/\n", "https://www.instagram.com/byesvein/\n", "https://www.instagram.com/larserikmyran/\n", "https://www.instagram.com/linje.2/\n", "https://www.instagram.com/nordicliveinsta/\n", "https://www.instagram.com/allthingslivenorway/\n", "https://www.instagram.com/la_isla_anita/\n", "https://www.instagram.com/bjornar_bp/\n", "https://www.instagram.com/gretebjelde/\n", "https://www.instagram.com/burgerflipper/\n", "https://www.instagram.com/markvaughan21/\n", "https://www.instagram.com/oisneve/\n", "https://www.instagram.com/simenherning/\n", "https://www.instagram.com/lkinden/\n", "https://www.instagram.com/askfrederikberg/\n", "https://www.instagram.com/charlotteoqvist/\n", "https://www.instagram.com/nyfikon/\n", "https://www.instagram.com/kaspsteen/\n", "https://www.instagram.com/odastormoen/\n", "https://www.instagram.com/kimpauls/\n", "https://www.instagram.com/rudolfreim/\n", "https://www.instagram.com/noracollective/\n", "https://www.instagram.com/vanwahlen/\n", "https://www.instagram.com/nassirachour/\n", "https://www.instagram.com/shiremarius/\n", "https://www.instagram.com/baltgws/\n", "https://www.instagram.com/bwoistop/\n", "https://www.instagram.com/petterkatastrofe/\n", "https://www.instagram.com/staysman/\n", "https://www.instagram.com/hefaugusto/\n", "https://www.instagram.com/leoajkic/\n", "https://www.instagram.com/girsonnmg/\n", "https://www.instagram.com/jorndalchow/\n", "https://www.instagram.com/kanonkris/\n", "https://www.instagram.com/timordie/\n", "https://www.instagram.com/idaelinus/?hl=nb\n", "https://www.instagram.com/wolfgangwee/?hl=nb\n", "https://www.instagram.com/adipop_/?hl=nb\n", "https://www.instagram.com/rubengran/?hl=nb\n", "https://www.instagram.com/christinedancke/\n", "https://www.instagram.com/sverrevedal/?hl=nb\n", "https://www.instagram.com/lea_isabelle/?hl=nb\n", "https://www.instagram.com/sverrebjornsen/?hl=nb\n", "https://www.instagram.com/jonasberglov/?hl=nb\n", "https://www.instagram.com/stianroste/?hl=nb\n", "https://www.instagram.com/mattismja/?hl=nb\n", "https://www.instagram.com/martebratberg/?hl=nb\n", "https://www.instagram.com/kristinearntzen/?hl=nb\n", "https://www.instagram.com/jhegstad/?hl=nb\n", "https://www.instagram.com/winsents/?hl=nb\n", "https://www.instagram.com/knuuudsen/?hl=nb\n", "https://www.instagram.com/marimonsson/?hl=nb\n", "https://www.instagram.com/tetelidbom/?hl=nb\n", "https://www.instagram.com/adelinaibi/?hl=nb\n", "https://www.instagram.com/martinlepperod/?hl=nb\n", "https://www.instagram.com/annaprincezz/\n", "https://www.instagram.com/nintur/\n", "https://www.instagram.com/steliassen/\n", "https://www.instagram.com/arianrhodengebo/\n", "https://www.instagram.com/jannehelen/\n", "https://www.instagram.com/finnulrik.berntsen/\n", "https://www.instagram.com/piaskevik/\n", "https://www.instagram.com/ramonakf/\n", "https://www.instagram.com/shaunhm/\n", "https://www.instagram.com/martin.holmen/\n", "https://www.instagram.com/abieltee/\n", "https://www.instagram.com/amirhorori/\n", "https://www.instagram.com/kidjoki/?hl=nb\n", "https://www.instagram.com/stargatemusic/\n", "https://www.instagram.com/lidogotpix/?hl=nb\n", "https://www.instagram.com/mats_lie_skare/?hl=nb\n", "https://www.instagram.com/martinsjolie/?hl=nb\n", "https://www.instagram.com/willidap/?hl=nb\n", "https://www.instagram.com/cashmerecat/?hl=nb\n", "https://www.instagram.com/reelmags/\n", "https://www.instagram.com/jesperborgen/?hl=nb\n", "https://www.instagram.com/krisschaka/?hl=nb\n", "https://www.instagram.com/minus.manus/?hl=nb\n", "https://www.instagram.com/smaalandunofficial/\n", "https://www.instagram.com/hforalvor/\n", "https://www.instagram.com/dagopago/\n", "https://www.instagram.com/kimofstad/?hl=nb\n", "??\n", "https://www.instagram.com/madebyaxident/?hl=nb\n", "https://www.instagram.com/vinterboomin/?hl=nb\n", "https://www.instagram.com/simenhope/\n", "https://www.instagram.com/thisisanders_/?hl=nb\n", "https://www.instagram.com/mathiasnilsen_/\n", "https://www.instagram.com/2ndhaf/?hl=nb\n", "https://www.instagram.com/coucheron/?hl=nb\n", "https://www.instagram.com/orangevillacollective/\n", "https://www.instagram.com/p/B6_Yf9ngDiz/\n", "https://www.instagram.com/state.official_/?hl=nb\n", "https://www.instagram.com/andkja/\n", "https://www.instagram.com/thepav/\n", "https://www.instagram.com/audun_agnar/\n", "https://www.instagram.com/becauseimbaard/\n", "https://www.instagram.com/carlviktor/\n", "https://www.instagram.com/eivindhelgerod/\n", "https://www.instagram.com/emilieadams/\n", "https://www.instagram.com/emeliehollow/\n", "https://www.instagram.com/fannyhultman/\n", "https://www.instagram.com/finsonmusic/\n", "https://www.instagram.com/fred_well/\n", "https://www.instagram.com/itsfridaamundsen/\n", "https://www.instagram.com/gucci_caliente/\n", "https://www.instagram.com/hanne.mjoen/\n", "https://www.instagram.com/hayleyaitkenn/\n", "https://www.instagram.com/helgemoen/\n", "https://www.instagram.com/hildastenmalm/\n", "https://www.instagram.com/hihildur/\n", "https://www.instagram.com/haawkbeats/\n", "https://www.instagram.com/skaarofficial/\n", "?\n", "https://www.instagram.com/inawroldsenofficial/\n", "https://www.instagram.com/himlagreit/\n", "https://www.instagram.com/jimbergsted/\n", "https://www.instagram.com/kerstinljungstrom/\n", "https://www.instagram.com/kristinxmaries/\n", "https://www.instagram.com/kristofferhaugan/\n", "https://www.instagram.com/larshornlavik/\n", "https://www.instagram.com/mayemusic/\n", "https://www.instagram.com/lisereppeofficial/\n", "https://www.instagram.com/lucasnord/\n", "https://www.instagram.com/howtoplaymadden/\n", "https://www.instagram.com/hjellert/\n", "https://www.instagram.com/matildamusic/\n", "https://www.instagram.com/mariamena_official/\n", "https://www.instagram.com/natali.noor/\n", "https://www.instagram.com/neanelson/\n", "https://www.instagram.com/nordicsongs/\n", "https://www.instagram.com/novablueofficial/\n", "https://www.instagram.com/olavtronsmoen/\n", "https://www.instagram.com/olebtalstad/\n", "https://www.instagram.com/oletorjus/\n", "https://www.instagram.com/patrikjean/\n", "https://www.instagram.com/theartistruben/\n", "https://www.instagram.com/siverthh/\n", "https://www.instagram.com/stephanslaaen/\n", "https://www.instagram.com/svalre/\n", "https://www.instagram.com/viljar.losnegard/\n", "https://www.instagram.com/iamzikai/\n", "https://www.instagram.com/arcticrights/\n", "https://www.instagram.com/baggpipestudios/\n", "https://www.instagram.com/sailormusicnorway/\n", "https://www.instagram.com/northboundstockholm/\n", "https://www.instagram.com/mrradarmusic/\n", "https://www.instagram.com/rmvpublishing/\n", "https://www.instagram.com/sonyatvsca/\n", "https://www.instagram.com/stealthmusicpublishing/\n", "https://www.instagram.com/stellarsongsscandinavia/\n", "https://www.instagram.com/thekennelmusic/\n", "https://www.instagram.com/universalmusicpub_scand/\n", "https://www.instagram.com/warnerchappellscand/\n", "\"\"\".splitlines() if '.com/' in s]" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [], "source": [ "def add_insta_influencer(for_usernames: list, insta_username):\n", " insta_username = insta_username.lower()\n", " existing = db.Session.query(db.InUser).get(insta_username)\n", " if existing:\n", " print(f\"Existing: {insta_username}\")\n", " existing.is_influencer = True\n", " else:\n", " print(f\"New: {insta_username}\")\n", " db.Session.add(db.InUser(inid=insta_username, is_influencer=True))\n", " \n", " prepared = \",\".join([f\"(:user{i}, :inid)\" for i in range(len(for_usernames))])\n", " params = {f'user{i}':v for i, v in enumerate(for_usernames)}\n", " params['inid'] = insta_username\n", " \n", " sql = f'''insert into users_in_influencers (username, inid) values {prepared} on conflict do nothing'''\n", " \n", " db.Session.execute(sql, params=params)\n", " db.Session.commit()\n", " print('inserted...')" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "inids = list(set([inurl.strip().split(\"?\")[0].strip('/').split('/')[-1] for inurl in instas]))" ] }, { "cell_type": "code", "execution_count": 59, "metadata": {}, "outputs": [], "source": [ "usernames = ['norway']" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 65, "metadata": { "scrolled": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Existing: callmegeorge___\n", "inserted...\n", "Existing: maggiecollinsyo\n", "inserted...\n", "Existing: braydonritson\n", "inserted...\n", "Existing: rachheeeta\n", "inserted...\n", "Existing: esthershewry\n", "inserted...\n", "Existing: jackcrane\n", "inserted...\n", "Existing: kurtisbailey\n", "inserted...\n", "Existing: piprasmussen\n", "inserted...\n", "Existing: _clairemooney\n", "inserted...\n", "Existing: iohyouforever\n", "inserted...\n", "Existing: night.pilot\n", "inserted...\n", "Existing: dylanalcott\n", "inserted...\n", "Existing: pike_gemma\n", "inserted...\n", "Existing: taitmcgregor\n", "inserted...\n", "Existing: doncandon\n", "inserted...\n", "Existing: jackgraymusic\n", "inserted...\n", "Existing: matty_newton\n", "inserted...\n", "Existing: rubyslippered\n", "inserted...\n", "Existing: andygav_\n", "inserted...\n", "Existing: domalessio\n", "inserted...\n", "Existing: nickobyrne\n", "inserted...\n", "Existing: zachlacava\n", "inserted...\n", "Existing: chieflysounds\n", "inserted...\n", "Existing: cathy_oates\n", "inserted...\n", "Existing: hardwickonthegram\n", "inserted...\n", "Existing: leonidbusinesss\n", "inserted...\n", "Existing: nic_richards\n", "inserted...\n", "Existing: ancikamester\n", "inserted...\n", "Existing: 123agencygroup\n", "inserted...\n", "Existing: smallzy\n", "inserted...\n", "Existing: cranehayley\n", "inserted...\n", "Existing: erica_mallett\n", "inserted...\n", "Existing: lindamarigliano\n", "inserted...\n", "Existing: thesansberryblog\n", "inserted...\n", "Existing: ninalasvegas\n", "inserted...\n", "Existing: debbie_carr\n", "inserted...\n", "Existing: daverubyhowe\n", "inserted...\n", "Existing: jpfdm\n", "inserted...\n", "Existing: emmaechow\n", "inserted...\n", "Existing: publicpaco\n", "inserted...\n", "Existing: _colebennett_\n", "inserted...\n", "Existing: fdelish\n", "inserted...\n", "Existing: hamstagram_l\n", "inserted...\n", "Existing: mattokine\n", "inserted...\n", "Existing: heypoppyreid\n", "inserted...\n", "Existing: olliewards\n", "inserted...\n", "Existing: zappatage\n", "inserted...\n", "Existing: marionbriand\n", "inserted...\n", "Existing: harrisonkefford\n", "inserted...\n", "Existing: caseface_killah\n", "inserted...\n", "Existing: jonohar\n", "inserted...\n", "Existing: isabellajmoore\n", "inserted...\n", "Existing: gxbriellemxry\n", "inserted...\n", "Existing: jessgleeson\n", "inserted...\n", "Existing: miricarter_\n", "inserted...\n", "Existing: stacygougoulis\n", "inserted...\n", "Existing: pathongofaus\n", "inserted...\n", "Existing: nativejaime\n", "inserted...\n", "Existing: ncfindlay\n", "inserted...\n", "Existing: page1management\n", "inserted...\n", "Existing: ash_london\n", "inserted...\n", "Existing: lukegirgis\n", "inserted...\n", "Existing: veronicamilsom\n", "inserted...\n", "Existing: heatherlindsay84\n", "inserted...\n", "Existing: tommyfaith\n", "inserted...\n", "Existing: christinathiers\n", "inserted...\n", "Existing: paulparkmusic\n", "inserted...\n", "Existing: chantelle_zoe\n", "inserted...\n", "Existing: dabakerboy\n", "inserted...\n", "Existing: chrislangenberg\n", "inserted...\n", "Existing: kate_carnell\n", "inserted...\n", "Existing: amyjanedowdle\n", "inserted...\n", "Existing: lewis_mitchell_music\n", "inserted...\n", "Existing: boy_soda_\n", "inserted...\n", "Existing: trishanth\n", "inserted...\n", "Existing: jeremysharpy\n", "inserted...\n", "Existing: colininertia\n", "inserted...\n", "Existing: cassettekidd\n", "inserted...\n", "Existing: clairelollins\n", "inserted...\n", "Existing: stephengoodhew\n", "inserted...\n", "Existing: karla_ranby\n", "inserted...\n", "Existing: avahayz\n", "inserted...\n", "Existing: benedictwatts\n", "inserted...\n", "Existing: heathfidelity\n", "inserted...\n", "Existing: mismissy92\n", "inserted...\n", "Existing: declanbyrneee\n", "inserted...\n", "Existing: nattencic\n", "inserted...\n", "Existing: shantan_ichiban\n", "inserted...\n", "Existing: bentle__\n", "inserted...\n", "Existing: iamedwintehrani\n", "inserted...\n", "Existing: tscarlett__\n", "inserted...\n", "Existing: flackseed\n", "inserted...\n", "Existing: delia_bartle\n", "inserted...\n", "Existing: theyeahnahgod\n", "inserted...\n", "Existing: bakedgoodsmedia\n", "inserted...\n", "Existing: scottarms\n", "inserted...\n", "Existing: 00evan\n", "inserted...\n", "Existing: xaviermayne_\n", "inserted...\n", "Existing: _justinmccarthy\n", "inserted...\n", "Existing: harrymoore91\n", "inserted...\n", "Existing: eddiebenjamin_\n", "inserted...\n", "Existing: triplejtheking\n", "inserted...\n", "Existing: jordieireland\n", "inserted...\n", "Existing: p.r.e.e.c.e\n", "inserted...\n", "Existing: adamlewislovesyou\n", "inserted...\n", "Existing: ash_carroll\n", "inserted...\n", "Existing: celline.n\n", "inserted...\n", "Existing: stevan.jpeg\n", "inserted...\n", "Existing: sallycolemania\n", "inserted...\n", "Existing: mikseveritt\n", "inserted...\n", "Existing: timshiel\n", "inserted...\n", "Existing: panini_panini_\n", "inserted...\n", "Existing: davidjamesmccarthy\n", "inserted...\n", "Existing: thewongnathan\n", "inserted...\n", "Existing: loveme.do\n", "inserted...\n", "Existing: samwaldo\n", "inserted...\n", "Existing: fonzwhaler\n", "inserted...\n" ] } ], "source": [ "for inid in inids:\n", " add_insta_influencer(for_usernames=usernames, insta_username=inid)\n", " " ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [], "source": [ "db.Session.commit()" ] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "## SoundCloud 🎼" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'urgirlameh, ben_preece, benjaminbrxwn, bentlemus, blake-wares, boy_soda, user-596083168, christina-thiers, user-372573519, daverubyhowe, declan-byrne-967761347, user-986590125, emma-chow, pike_gemma, johann-ponniah, djjordieireland, chieflysounds, miks-everitt, australianindies, ninalasvegas, piprasmussen94, ro-flack, shantan_ichiban, user-767791778, moustace, stephen-goodhew, fonz-whaler, sounddocblog, trishanth-chandrahasan, veronica-milsom'" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sc_accounts = [ s.split('.com/')[1] for s in '''-\n", "-\n", "-\n", "https://soundcloud.com/urgirlameh\n", "-\n", "-\n", "-\n", "-\n", "\n", "-\n", "-\n", "-\n", "https://soundcloud.com/ben_preece\n", "-\n", "https://soundcloud.com/benjaminbrxwn\n", "https://soundcloud.com/bentlemus\n", "https://soundcloud.com/blake-wares\n", "https://soundcloud.com/boy_soda\n", "-\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/user-596083168\n", "https://soundcloud.com/christina-thiers\n", "-\n", "-\n", "https://soundcloud.com/user-372573519\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/daverubyhowe\n", "-\n", "https://soundcloud.com/declan-byrne-967761347\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/user-986590125\n", "-\n", "-\n", "https://soundcloud.com/emma-chow\n", "\n", "-\n", "\n", "-\n", "-\n", "https://soundcloud.com/pike_gemma\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/johann-ponniah\n", "-\n", "-\n", "https://soundcloud.com/djjordieireland\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/chieflysounds\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/miks-everitt\n", "-\n", "-\n", "-\n", "-\n", "-\n", "https://soundcloud.com/australianindies\n", "-\n", "https://soundcloud.com/ninalasvegas\n", "-\n", "-\n", "-\n", "\n", "https://soundcloud.com/piprasmussen94\n", "-\n", "-\n", "-\n", "https://soundcloud.com/ro-flack\n", "-\n", "-\n", "-\n", "-\n", "-\n", "\"https://soundcloud.com/shantan_ichiban\n", "\"\n", "https://soundcloud.com/user-767791778\n", "https://soundcloud.com/moustace\n", "https://soundcloud.com/stephen-goodhew\n", "- \n", "-\n", "-\n", "-\n", "https://soundcloud.com/fonz-whaler\n", "https://soundcloud.com/sounddocblog\n", "https://soundcloud.com/trishanth-chandrahasan\n", "https://soundcloud.com/veronica-milsom\n", "-\n", "-'''.splitlines() if '.com/' in s]\n", "\", \".join(sc_accounts)" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [], "source": [ "from tracker import soundcloud" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "urgirlameh\n", "ben_preece\n", "benjaminbrxwn\n", "bentlemus\n", "blake-wares\n", "boy_soda\n", "user-596083168\n", "christina-thiers\n", "user-372573519\n", "daverubyhowe\n", "declan-byrne-967761347\n", "user-986590125\n", "emma-chow\n", "pike_gemma\n", "johann-ponniah\n", "djjordieireland\n", "chieflysounds\n", "miks-everitt\n", "australianindies\n", "ninalasvegas\n", "piprasmussen94\n", "ro-flack\n", "shantan_ichiban\n", "user-767791778\n", "moustace\n", "stephen-goodhew\n", "fonz-whaler\n", "sounddocblog\n", "trishanth-chandrahasan\n", "veronica-milsom\n" ] } ], "source": [ "for scaccount in sc_accounts:\n", " print(scaccount)\n", " soundcloud.add_influencer_from_url(f'https://soundcloud.com/{scaccount}', usernames=usernames)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Twitter 🐥" ] }, { "cell_type": "code", "execution_count": 47, "metadata": {}, "outputs": [], "source": [ "from tracker import twitter, actions" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [], "source": [ "def add_twitter_influencer(twitter_username, for_usernames):\n", " try:\n", " user = twitter.new_instance().fetch_user(twitter_username, shallow=True)\n", " except Exception as e:\n", " print(f\"Failed to get user {twitter_username} sckipping\")\n", " print(e)\n", " return\n", " \n", " if user:\n", " print(\"*** Adding Twitter user\", twitter_username)\n", " dbrecord = db.Session.query(db.TrackedEntity).filter_by(twitter_id=user['id_str']).first()\n", " if dbrecord:\n", " dbrecord.twitter_data = user\n", " dbrecord.is_influencer = True\n", " else:\n", " dbrecord = actions.add_entity(twitter_data=user, is_influencer=True)\n", "\n", " # Want to ensure this gets picked up by the nightly tracker\n", " dbrecord.twitter_last_update = None\n", " db.Session.flush()\n", " \n", " prepared = \",\".join([f\"(:user{i}, :eid)\" for i in range(len(for_usernames))])\n", " params = {f'user{i}':v for i, v in enumerate(for_usernames)}\n", " params['eid'] = dbrecord.eid\n", "\n", " sql = f'''insert into users_tw_influencers (username, eid) values {prepared} on conflict do nothing'''\n", "\n", " db.Session.execute(sql, params=params)\n", " \n", " db.Session.commit()\n", "\n" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'ColinInertia, 123AgencyGroup, doncandon, danzilber, iamdavemccarthy, daverubyhowe, debbieecarr, dec_byrne, DeliaBartle, domalessio, rubyslippered, DylanAlcott, EddieBenjamin_, EdwinOnggo, iamedwintehrani, emmaechow, ericamallett_, Gxbriellemxry, pike_gemma, Georgie_wilkie, hjlane, HarrisonKefford, HayleyCrane_, Heathfidelity, heatherlindsay, isabellajmoore, jackcrane, JackGrayMusic, dogbunz, iohyouforever, JordieIreland, JTCassette, jujusansone, KarlaRanby, Kate_Carnell, kurt_mmg, chieflysounds, LeonRogovoy, lindamarigliano, LukeGirgis, MarionBriand1, mattokine, mikseveritt, miricarter_, missyshines, nattencic, thewongnathan, nickobyrne, richardsnicole, ninalasvegas, OllieWards, CosmosMidnight, paulparkmusic, PipRasmussen, heypoppyreid, triplejtheking, flackseed, sally_coleman_, sarahhamiltonbs, shantan_ichiban, Smallzy, moustace, a_sensible_man, yunglover49, tait_mcgregor, timshiel, FonzWhaler, tommyfaith_, Trishanth, vmilsom, itsxaviermayne, ZachLaCava'" ] }, "execution_count": 50, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tw_users = [\n", " tw.split('.com/')[1].split('?')[0].strip()\n", " for tw in '''-\n", "\n", "https://twitter.com/ColinInertia?lang=en\n", "https://twitter.com/123AgencyGroup\n", "https://twitter.com/doncandon\n", "https://twitter.com/danzilber\n", "-\n", "https://twitter.com/iamdavemccarthy\n", "https://twitter.com/daverubyhowe\n", "https://twitter.com/debbieecarr\n", "https://twitter.com/dec_byrne\n", "https://twitter.com/DeliaBartle\n", "https://twitter.com/domalessio\n", "https://twitter.com/rubyslippered\n", "https://twitter.com/DylanAlcott\n", "https://twitter.com/EddieBenjamin_\n", "https://twitter.com/EdwinOnggo\n", "https://twitter.com/iamedwintehrani\n", "https://twitter.com/emmaechow?lang=en\n", "https://twitter.com/ericamallett_\n", "-\n", "\n", "-\n", "https://twitter.com/Gxbriellemxry\n", "https://twitter.com/pike_gemma?lang=en\n", "https://twitter.com/Georgie_wilkie\n", "https://twitter.com/hjlane\n", "-\n", "https://twitter.com/HarrisonKefford\n", "\n", "https://twitter.com/HayleyCrane_\n", "https://twitter.com/Heathfidelity?lang=en\n", "https://twitter.com/heatherlindsay\n", "https://twitter.com/isabellajmoore\n", "https://twitter.com/jackcrane\n", "https://twitter.com/JackGrayMusic\n", "-\n", "-\n", "https://twitter.com/dogbunz\n", "https://twitter.com/iohyouforever?lang=en\n", "-\n", "-\n", "https://twitter.com/JordieIreland\n", "https://twitter.com/JTCassette\n", "https://twitter.com/jujusansone\n", "-\n", "https://twitter.com/KarlaRanby\n", "https://twitter.com/Kate_Carnell\n", "-\n", "https://twitter.com/kurt_mmg\n", "https://twitter.com/chieflysounds\n", "https://twitter.com/LeonRogovoy\n", "-\n", "https://twitter.com/lindamarigliano\n", "https://twitter.com/LukeGirgis\n", "-\n", "https://twitter.com/MarionBriand1\n", "https://twitter.com/mattokine\n", "-\n", "-\n", "https://twitter.com/mikseveritt\n", "https://twitter.com/miricarter_\n", "https://twitter.com/missyshines\n", "https://twitter.com/nattencic\n", "https://twitter.com/thewongnathan\n", "-\n", "https://twitter.com/nickobyrne?lang=en\n", "https://twitter.com/richardsnicole\n", "https://twitter.com/ninalasvegas\n", "https://twitter.com/OllieWards\n", "https://twitter.com/CosmosMidnight\n", "-\n", "https://twitter.com/paulparkmusic\n", "https://twitter.com/PipRasmussen\n", "https://twitter.com/heypoppyreid?lang=en\n", "-\n", "https://twitter.com/triplejtheking?lang=en\n", "https://twitter.com/flackseed\n", "https://twitter.com/sally_coleman_\n", "-\n", "https://twitter.com/sarahhamiltonbs?lang=en\n", "-\n", "-\n", "https://twitter.com/shantan_ichiban\n", "https://twitter.com/Smallzy?lang=en\n", "https://twitter.com/moustace\n", "https://twitter.com/a_sensible_man?lang=en\n", "https://twitter.com/yunglover49\n", "https://twitter.com/tait_mcgregor\n", "https://twitter.com/timshiel\n", "-\n", "https://twitter.com/FonzWhaler\n", "https://twitter.com/tommyfaith_\n", "https://twitter.com/Trishanth\n", "https://twitter.com/vmilsom\n", "https://twitter.com/itsxaviermayne\n", "https://twitter.com/ZachLaCava?lang=en'''.splitlines()\n", " if '.com/' in tw\n", "]\n", "\", \".join(tw_users)" ] }, { "cell_type": "code", "execution_count": 51, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "ColinInertia\n", "Failed to get user ColinInertia sckipping\n", "[{'code': 50, 'message': 'User not found.'}]\n", "123AgencyGroup\n", "*** Adding Twitter user 123AgencyGroup\n", "doncandon\n", "*** Adding Twitter user doncandon\n", "danzilber\n", "*** Adding Twitter user danzilber\n", "iamdavemccarthy\n", "*** Adding Twitter user iamdavemccarthy\n", "daverubyhowe\n", "*** Adding Twitter user daverubyhowe\n", "debbieecarr\n", "*** Adding Twitter user debbieecarr\n", "dec_byrne\n", "*** Adding Twitter user dec_byrne\n", "DeliaBartle\n", "*** Adding Twitter user DeliaBartle\n", "domalessio\n", "*** Adding Twitter user domalessio\n", "rubyslippered\n", "*** Adding Twitter user rubyslippered\n", "DylanAlcott\n", "*** Adding Twitter user DylanAlcott\n", "EddieBenjamin_\n", "*** Adding Twitter user EddieBenjamin_\n", "EdwinOnggo\n", "*** Adding Twitter user EdwinOnggo\n", "iamedwintehrani\n", "Failed to get user iamedwintehrani sckipping\n", "[{'code': 50, 'message': 'User not found.'}]\n", "emmaechow\n", "*** Adding Twitter user emmaechow\n", "ericamallett_\n", "*** Adding Twitter user ericamallett_\n", "Gxbriellemxry\n", "*** Adding Twitter user Gxbriellemxry\n", "pike_gemma\n", "*** Adding Twitter user pike_gemma\n", "Georgie_wilkie\n", "*** Adding Twitter user Georgie_wilkie\n", "hjlane\n", "*** Adding Twitter user hjlane\n", "HarrisonKefford\n", "*** Adding Twitter user HarrisonKefford\n", "HayleyCrane_\n", "*** Adding Twitter user HayleyCrane_\n", "Heathfidelity\n", "*** Adding Twitter user Heathfidelity\n", "heatherlindsay\n", "*** Adding Twitter user heatherlindsay\n", "isabellajmoore\n", "*** Adding Twitter user isabellajmoore\n", "jackcrane\n", "*** Adding Twitter user jackcrane\n", "JackGrayMusic\n", "*** Adding Twitter user JackGrayMusic\n", "dogbunz\n", "*** Adding Twitter user dogbunz\n", "iohyouforever\n", "*** Adding Twitter user iohyouforever\n", "JordieIreland\n", "*** Adding Twitter user JordieIreland\n", "JTCassette\n", "*** Adding Twitter user JTCassette\n", "jujusansone\n", "*** Adding Twitter user jujusansone\n", "KarlaRanby\n", "Failed to get user KarlaRanby sckipping\n", "[{'code': 63, 'message': 'User has been suspended.'}]\n", "Kate_Carnell\n", "*** Adding Twitter user Kate_Carnell\n", "kurt_mmg\n", "Failed to get user kurt_mmg sckipping\n", "[{'code': 50, 'message': 'User not found.'}]\n", "chieflysounds\n", "*** Adding Twitter user chieflysounds\n", "LeonRogovoy\n", "*** Adding Twitter user LeonRogovoy\n", "lindamarigliano\n", "*** Adding Twitter user lindamarigliano\n", "LukeGirgis\n", "*** Adding Twitter user LukeGirgis\n", "MarionBriand1\n", "*** Adding Twitter user MarionBriand1\n", "mattokine\n", "*** Adding Twitter user mattokine\n", "mikseveritt\n", "*** Adding Twitter user mikseveritt\n", "miricarter_\n", "*** Adding Twitter user miricarter_\n", "missyshines\n", "*** Adding Twitter user missyshines\n", "nattencic\n", "*** Adding Twitter user nattencic\n", "thewongnathan\n", "*** Adding Twitter user thewongnathan\n", "nickobyrne\n", "*** Adding Twitter user nickobyrne\n", "richardsnicole\n", "*** Adding Twitter user richardsnicole\n", "ninalasvegas\n", "*** Adding Twitter user ninalasvegas\n", "OllieWards\n", "*** Adding Twitter user OllieWards\n", "CosmosMidnight\n", "*** Adding Twitter user CosmosMidnight\n", "paulparkmusic\n", "*** Adding Twitter user paulparkmusic\n", "PipRasmussen\n", "*** Adding Twitter user PipRasmussen\n", "heypoppyreid\n", "*** Adding Twitter user heypoppyreid\n", "triplejtheking\n", "*** Adding Twitter user triplejtheking\n", "flackseed\n", "*** Adding Twitter user flackseed\n", "sally_coleman_\n", "*** Adding Twitter user sally_coleman_\n", "sarahhamiltonbs\n", "*** Adding Twitter user sarahhamiltonbs\n", "shantan_ichiban\n", "*** Adding Twitter user shantan_ichiban\n", "Smallzy\n", "*** Adding Twitter user Smallzy\n", "moustace\n", "*** Adding Twitter user moustace\n", "a_sensible_man\n", "*** Adding Twitter user a_sensible_man\n", "yunglover49\n", "Failed to get user yunglover49 sckipping\n", "[{'code': 50, 'message': 'User not found.'}]\n", "tait_mcgregor\n", "*** Adding Twitter user tait_mcgregor\n", "timshiel\n", "*** Adding Twitter user timshiel\n", "FonzWhaler\n", "*** Adding Twitter user FonzWhaler\n", "tommyfaith_\n", "*** Adding Twitter user tommyfaith_\n", "Trishanth\n", "*** Adding Twitter user Trishanth\n", "vmilsom\n", "*** Adding Twitter user vmilsom\n", "itsxaviermayne\n", "*** Adding Twitter user itsxaviermayne\n", "ZachLaCava\n", "*** Adding Twitter user ZachLaCava\n" ] } ], "source": [ "for twuser in tw_users:\n", " print(twuser)\n", " add_twitter_influencer(twitter_username=twuser, for_usernames=usernames)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.1" } }, "nbformat": 4, "nbformat_minor": 2 }