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
