def addPlayerSocial(player_id,twitter_url,instagram_url,facebook_url,conn): cursor = conn.cursor() created_id = utils.generateID() cursor.execute("INSERT INTO social_accounts VALUES('%s','%s','%s','%s')"%(created_id, twitter_url, instagram_url, facebook_url)) conn.commit()
def createMachine(self, res): extras = [] extra = '' base = '' inf = infra.provider(settings.settings()) volume = self.get_volume_from_image(res['image'], utils.generateID() + '_', resize=res['size']) if volume: base = os.path.basename(res['image']) extras.append(inf.fileStorage(volume)) cdrom = self.get_cdrom_image(res['cdrom']) if cdrom: if not base: base = os.path.basename(cdrom) extras.append(inf.cdromStorage(cdrom)) image_extra_loader = None if volume or cdrom: item = cdrom if volume: item = volume image_extra_loader = self.image_extra_config(os.path.basename(item), res['name']) image_extra_userdata = {} if image_extra_loader is not None: print ('Found image loader: %s' % (image_extra_loader.base())) extra_device = image_extra_loader.extraDeviceConfig(inf) if extra_device: extras.append(extra_device) image_extra = image_extra_loader.extra() if image_extra: extra += image_extra image_extra_userdata = image_extra_loader.userdata() # TODO: Support other features if 'network_name' in settings.settings(): extras.append(inf.defineNetworkInterface(settings.settings()['network_name'])) extradevices = '\n'.join(extras) dom_xml = inf.customDomain(res['name'], res['cpus'], res['memory'], extradevices=extradevices, extra=extra) dom = inf.createDomain(dom_xml) dom_res = dom.create() _db = db.connect(settings.settings()) config_data = json.dumps(image_extra_userdata) config_data = config_data.replace('\'', '\\\'') db.update(_db, 'machines', 'config=\'%s\'' % (config_data), where='id="%s"' % (res['name']))
def detect(self, path): ''' FILE EXAMPLE: Name of collection SongId1 SongId2 SongId3 ''' collec = model.Collection() collec.cid = utils.generateID() with open(path) as data: collec.name = data.readline() collec.listSong = list(map(int, data.readline().rstrip().split())) return collec
def addSponsor(name, image_url, ext_url, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO sponsors VALUES('%s','%s','%s','%s')"%(utils.generateID(), name, image_url, ext_url)) conn.commit() except Exception as e: print(str(e)) pass
def addComment(username, newsid ,title, content, date, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO comments VALUES('%s','%s','%s','%s','%s','%s')"%(utils.generateID(), username, newsid, title, content, date)) conn.commit() except Exception as e: print(str(e)) pass
def addVideo(title, ext_url, source_type,conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO videos VALUES('%s','%s','%s','%s')"%(utils.generateID(), title, ext_url, source_type)) conn.commit() except Exception as e: print(str(e)) pass
def __init__(self, sets): self.id = utils.generateID() self.port = 5555 self.host = 'localhost' if 'backend_port' in sets: self.port = sets['backend_port'] if 'backend_host' in sets: self.host = sets['backend_host'] self.running = False self.queue = [] self.callbacks = {} self.queue_mutex = threading.Lock() threading.Thread.__init__(self)
def addVenue(name, capacity, location, description, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO venues VALUES('%s','%s','%s','%s','%s')"%(utils.generateID(),name, capacity,location,description)) conn.commit() except Exception as e: print(str(e)) pass
def addAward(description, last_winner_id, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO awards VALUES('%s','%s','%s')"%(utils.generateID(),description,last_winner_id)) conn.commit() return 'OK' except Exception as e: print(str(e)) pass
def addNews(title, content, image_url, date, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO news VALUES('%s','%s','%s','%s','%s')"%(utils.generateID(), title, content, image_url, date)) conn.commit() except Exception as e: print(str(e)) pass
def detectData(self, local_path): ''' read data from file mp3 upload file into firebase funtion return song model ''' file = eyed3.load(local_path) tag = file.tag resp_url = self.uploadFile(local_path, 'songs', tag.title + '.mp3') song = model.Song(utils.generateID(), tag.title, tag.artist, tag.album, utils.getNow(), 0, 'No Lyris', resp_url) return song
def detect(self, path): ''' FILE EXAMPLE: Name of artist C:\Image\Artist.png <-- Second line: Image cover local path Multiline after <-- Profile of Artist (Same as: Name, age, address, ...) ''' artist = model.Artist() artist.aid = utils.generateID() with open(path) as data: artist.name = data.readline() artist.cover = data.readline() artist.profile = data.readlines() return artist
def addSocialAccounts(twitter_account, instagram_account, facebook_account, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO social_accounts VALUES('%s','%s','%s','%s')"%(utils.generateID(), twitter_account, instagram_account, facebook_account)) conn.commit() except Exception as e: print(str(e)) pass
def addAdvertise(image_url, ext_url, size, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO advertises VALUES('%s','%s','%s','%s')"%(utils.generateID(), image_url, ext_url, size)) conn.commit() except Exception as e: print(str(e)) pass
def post_machine(): if not request.json: abort_msg(400, 'Expected JSON input') # TODO: quota per user res = { 'memory': 256 * 1024, # FIXME some reasonable default 'cpus': 1, 'name': utils.generateID(), 'net': '', 'image': '', 'size': '', 'cdrom': '', } if 'mem' in request.json: res['memory'] = request.json['mem'] if 'memory' in request.json: res['memory'] = request.json['memory'] if 'size' in request.json: res['size'] = request.json['size'] if 'cpus' in request.json: try: res['cpus'] = int(request.json['cpus']) except: pass if 'image' in request.json: res['image'] = request.json['image'] if 'cdrom' in request.json: res['cdrom'] = request.json['cdrom'] if 'name' in request.json: res['name'] = request.json['name'] _db = db.connect(settings.settings()) db.insert(_db, 'machines', [res['name'], '', '', auth.username(), '']) act = actions.provider(settings.settings()) act.sendActionNow({'createMachine': res}, None) data = { 'uri': url_for('machine_id', machine_id=res['name'], _external=True), 'id': res['name'] } return jsonify(data)
def addUser(firstname, lastname, age, gender, email,username,password,conn): try: cursor = conn.cursor() created_id = utils.generateID() cursor.execute("INSERT INTO users VALUES('%s','%s','%s','%s','%s','%s','%s')"%(created_id, firstname, lastname, age, gender, email, 'User')) cursor.execute("INSERT INTO userLogin VALUES('%s','%s','%s')"%(created_id,username,password)) conn.commit() return 'OK' except Exception as e: print(str(e)) return 'SameUsername'
def handle(self, poll, socket, loop=True): self.running = True while self.running: if not self.queue: self.getResults(poll, socket) continue with self.queue_mutex: (data, callback) = self.queue.pop(0) data['id'] = utils.generateID() self.callbacks[data['id']] = callback socket.send_json(data) # It's good to handle results here as well self.getResults(poll, socket) if not loop: break
def addUser(firstName, secondName, lastName, mail=""): if secondName == u"": title = "%s %s." % (lastName , firstName[0]) else: title = "%s %s.%s." % (lastName , firstName[0] , secondName[0]) entity = users.Users() entity.title = title entity.altTitle = firstName + " " + secondName entity.lastName = lastName entity.firstName = firstName entity.secondName = secondName entity.mail = mail entity.idLink = utils.generateID(10) return entity pass
def addRecord(description, player_name, video_url, date,conn): try: cursor = conn.cursor() cursor.execute("SELECT ID FROM players WHERE name = '%s'"%(player_name)) player_id = cursor.fetchone() cursor.execute("SELECT ID FROM videos WHERE name = '%s'"%(video_url)) video_id = cursor.fetchone() cursor.execute("INSERT INTO records VALUES('%s','%s','%s','%s','%s')"%(utils.generateID(), description, player_id, video_id, date)) conn.commit() except Exception as e: print(str(e)) pass
def addUser(newUser): if (newUser['firstname'] == None): title = newUser['surname'] elif (newUser['secondname'] == ''): title = "%s %s." % (newUser['surname'], newUser['firstname'][0]) else: title = "%s %s.%s." % (newUser['surname'], newUser['firstname'][0] , newUser['secondname'][0]) entity = users.Users() entity.title = title title = newUser['surname'] if (newUser['secondname'] == ''): entity.altTitle = "%s" % (newUser['firstname']) else: entity.altTitle = "%s %s" % (newUser['firstname'], newUser['secondname']) entity.lastName = newUser['surname'] entity.firstName = newUser['firstname'] if (newUser['secondname'] == None): entity.secondName = '' else: entity.secondName = newUser['secondname'] entity.company = newUser['company'] entity.mail = newUser['email'] entity.idLink = utils.generateID(10) entity.put() return entity pass
def addMatch(tournament_name, venue_name, player_name1, player_name2, isLive, score, conn): try: cursor = conn.cursor() cursor.execute("SELECT ID FROM venues WHERE name = '%s'"%(venue_name)) venue_id = cursor.fetchone() cursor.execute("SELECT ID FROM players WHERE name = '%s'"%(player_name1)) player_id = cursor.fetchone() cursor.execute("SELECT ID FROM players WHERE name = '%s'"%(player_name2)) player_id2 = cursor.fetchone() cursor.execute("SELECT ID FROM tournaments WHERE name = '%s'"%(tournament_name)) award_id = cursor.fetchone() cursor.execute("INSERT INTO matches VALUES('%s','%s','%s','%s','%s','%s','%s')"%(utils.generateID(), tournament_name, venue_name, player_name1, player_name2, isLive, score)) conn.commit() except Exception as e: print(str(e)) pass
def addTournament(name, venue_name, round, player_count, last_winner_name, award_name, conn): try: cursor = conn.cursor() cursor.execute("SELECT ID FROM venues WHERE name = '%s'"%(venue_name)) venue_id = cursor.fetchone() cursor.execute("SELECT ID FROM players WHERE name = '%s'"%(last_winner_name)) player_id = cursor.fetchone() cursor.execute("SELECT ID FROM awards WHERE name = '%s'"%(award_name)) award_id = cursor.fetchone() cursor.execute("INSERT INTO tournaments VALUES('%s','%s','%s','%s','%s','%s','%s')"%(utils.generateID(), name, venue_id, round, player_count, player_id, award_id)) conn.commit() except Exception as e: print(str(e)) pass
def addTicket(venue_name, title, content, price, date, ext_url,conn): try: cursor = conn.cursor() cursor.execute("SELECT ID FROM venues WHERE name = '%s'"%(venue_name)) venue_id = cursor.fetchone() cursor.execute("INSERT INTO tickets VALUES('%s','%s','%s','%s','%s','%s','%s')"%(utils.generateID(),venue_id, title, content, price, date, ext_url)) conn.commit() except Exception as e: print(str(e)) pass
def addPlayer(firstname, lastname, age, gender, email, nationality, turned_pro, location, nickname, money_list_earnings, birthday, conn): try: cursor = conn.cursor() cursor.execute("INSERT INTO players VALUES('%s','%s','%s','%d','%s','%s','%s','%s','%s','%s','%s','%s')"%(utils.generateID(), firstname, lastname, age, gender, email, nationality, turned_pro, location, nickname, money_list_earnings, birthday)) conn.commit() except Exception as e: print(e) pass