def insert_keywords(user_id,role_id,keyword):
db = database_connection()
cursor = db.cursor()
sql_role = 'INSERT INTO roles(user_id,role_name) VALUES("%s","%s")'%(user_id,role_name)
cursor.execute(sql_role)
db.commit()
role_id = cursor.lastrowid
sql_mapping = 'INSERT INTO mapping(role_id,user_id,keyword,email,name) VALUES("%s","%s","%s","%s","%s")'%(role_id,user_id,keyword,email,name)
print sql_mapping
cursor.execute(sql_mapping)
db.commit()
print '''<HTML>'''
print '''<TITLE>SwiftMail::Insert Roles </TITLE><body>'''
#print header.printHeader()
#print leftNav.printLeftNav()
print '''<div class="left-side" style="width:745px;" >'''
print '''<table align="center" border='0'><tr><td> </td></tr></table>'''
print 'Roles has been created successfully! '
print "<A HREF='insert_roles.py?user_id=1'> Go Back To Add New Roles </A></div>"
#print footer.printFooter()
print '''</body></html>'''
def generate_deleteform(): db = database_connection() cursor = db.cursor() sql_role = "select a.role_id,a.role_name from roles a, mapping b where a.role_id = b.role_id and b.user_id = '%s'"%customer_id cursor.execute(sql_role) results=cursor.fetchall() #print header.printHeader() #print leftNav.printLeftNav() print header.printHeader() print '''<div class="left-side" style="width:745px;" >''' print '''<div class="formbox" align="center">''' print '''<form name="form_delete" action="delete_roles.py"><table border='1' class="formboxcontent"> <tr><td colspan="5"><b>Click on the respective Roles to Delete</b></td></tr> <tr><td colspan='1'> </td><td><b>Role Name</b></td></tr>''' for row in results: role_id = row[0] role_name = row[1] print '''<tr><td><input name="role_id" type="radio" value="%d" /></td><td>'''%role_id print role_name print'''</td>''' print '''<tr><td> </td><td align='right'> <input name="btn_delete" type="submit" value="Delete" /> <INPUT TYPE = hidden NAME = 'action' VALUE ='display'> </tr></td>''' print '''</table></form>'''
def con_str(): user_id = utility.getUserId(utility.getUserName()) db = database_connection() cursor = db.cursor() string2="" sql_role = 'select role_id from mapping where user_id = %s' %user_id cursor.execute(sql_role) results_role=cursor.fetchall() for row in results_role: role_id = row[0] sql_keyword = 'select keywords,emails,names from mapping where role_id = %s' %role_id cursor.execute(sql_keyword) results_keyword=cursor.fetchall() for row1 in results_keyword: keyword = row1[0] if keyword: string2 = keyword+";"+string2 emails = row1[1] if emails: string2 =emails+";"+string2 names = row1[2] if names: string2 =names+";"+string2 sql_user = '******' %user_id cursor.execute(sql_user) results_user=cursor.fetchall() for rows in results_user: user_name = rows[0] return (string2,user_name)
def update_ids(ids):
conn = database_connection()
for (lastfm_id, spotify_id) in ids:
cur = conn.cursor()
cur.execute(
"update scrobbles set spotify_id=%s, has_spotify_id=%s where lastfm_id=%s",
(spotify_id, True, lastfm_id))
conn.commit()
def get_lastfm_ids_without_spotify(group_size):
conn = database_connection()
cur = conn.cursor()
cur.execute(
"select lastfm_id from scrobbles where has_spotify_id=false limit %s" %
group_size)
return [x[0] for x in cur]
def getLocal(): user_id = utility.getUserId(utility.getUserName()) db = database_connection() cursor = db.cursor() sql = "select gmail_login,gmail_pwd,login_id from user where user_id='%s'" %user_id cursor.execute(sql) results = cursor.fetchall() for row in results: local = row[2] return local
def getGmailAcct(): user_id = utility.getUserId(utility.getUserName()) db = database_connection() cursor = db.cursor() sql = "select gmail_login,gmail_pwd,login_id from user where user_id='%s'" %user_id #%(getUserName()) #print sql cursor.execute(sql) results = cursor.fetchall() for row in results: username= row[0] password = row[1] local = row[2] #print username return (username,password,local)
def delete_roledata(role_id): db = database_connection() cursor = db.cursor() sql_delete2 = 'DELETE FROM mapping WHERE role_id=%s'%(role_id) cursor.execute(sql_delete2) db.commit() sql_delete = 'DELETE FROM roles WHERE role_id=%s'%(role_id) cursor.execute(sql_delete) db.commit() print header.printHeader() #print leftNav.printLeftNav() print '''<div class="left-side" style="width:745px;" >''' print '''<div class="formbox" align="center">''' print '<p>Roles has been deleted Successfully<p>' print '<a href="display_roles.py">Go back to Display Roles</a>' print '''</div></div>'''
def display_roledata(role_id,role_name,keyword,email,name): db = database_connection() cursor = db.cursor() sql_mappingupdate = 'UPDATE mapping SET keywords="%s",emails="%s",names="%s" WHERE role_id="%s"'%(keyword,email,name,role_id) sql_role = 'UPDATE roles SET role_name = "%s" where role_id = "%s"' %(role_name,role_id) #print sql_dvdupdate cursor.execute(sql_mappingupdate) db.commit() cursor.execute(sql_role) db.commit() #print header.printHeader() #print leftNav.printLeftNav() print header.printHeader() print '''<div class="left-side" style="width:745px;" >''' print '''<div class="formbox" align="center">''' print '<p>Roles Info has been updated Successfully<p>' print '<a href="display_roles.py">Go back to Display Roles</a>' print '''</div></div>'''
def insert_roles(user_id,role_name,keyword,email,name):
db = database_connection()
cursor = db.cursor()
sql_validate = 'select role_name from roles where role_name = "%s"' %(role_name)
cursor.execute(sql_validate)
results1=cursor.fetchall()
if results1:
generate_form(1)
else:
sql_role = 'INSERT INTO roles(role_name) VALUES("%s")'%(role_name)
cursor.execute(sql_role)
db.commit()
role_id = cursor.lastrowid
#keywords = keyword.strip().split(";")
#print len(keywords)
#for keyword in keywords:
sql_mapping = 'INSERT INTO mapping(role_id,user_id,keywords,emails,names) VALUES("%s","%s","%s","%s","%s")'%(role_id,user_id,keyword,email,name)
#print sql_mapping
cursor.execute(sql_mapping)
db.commit()
print '''<HTML>'''
print header.printHeader()
print '''<TITLE>SwiftMail::Insert Roles </TITLE><body>'''
#print leftNav.printLeftNav()
print '''<div class="left-side" style="width:745px;" >'''
print '''<table align="center" border='0'><tr><td> </td></tr></table>'''
print 'Roles has been created successfully! '
print "<A HREF='home.py'> Go Back </A></div>"
#print footer.printFooter()
print '''</body></html>'''
from db import database_connection
if __name__ == "__main__":
f = open("lastfm.csv").readlines()
conn = database_connection()
for idx, line in enumerate(f):
lfm_id = line.strip()
cur = conn.cursor()
cur.execute("insert into scrobbles (lastfm_id) values (%s)",
(lfm_id, ))
if idx % 1024 == 0:
conn.commit()
def update_ids(ids):
conn = database_connection()
for (lastfm_id, spotify_id) in ids:
cur = conn.cursor()
cur.execute("update scrobbles set spotify_id=%s, has_spotify_id=%s where lastfm_id=%s", (spotify_id, True, lastfm_id))
conn.commit()
#!c:/Python26/python.exe
import cgi
import cgitb
cgitb.enable()
import header
import utility
from db import database_connection
print "Content-type: text/html; charset=iso-8859-1\n\n"
db = database_connection()
cursor = db.cursor()
print '''<script language=javascript>function form_validation(){
var form_error=false;
var error_message = "";
if(document.dvd_form.dvd_name.value == "")
{
error_message+='Please Enter DVD Name.\\n';
form_error = true;
}
if(document.dvd_form.release_date.value == "")
{
error_message+='Please Enter Release Date.\\n';
form_error = true;
}
var stripped = document.dvd_form.imdb_rating.value.replace(/[\(\)\.\-\ ]/g, '');
if(document.dvd_form.imdb_rating.value == "" || isNaN(parseInt(stripped)))
{
error_message+='Please Enter Valid IMDB Rating.\\n';
def with_ids():
conn = database_connection()
cur = conn.cursor()
cur.execute("select count(*) from scrobbles where has_spotify_id=true")
return cur.next()[0]
def get_total_scrobbles():
conn = database_connection()
cur = conn.cursor()
cur.execute("select count(*) from scrobbles")
return cur.next()[0]
def get_lastfm_ids_without_spotify(group_size):
conn = database_connection()
cur = conn.cursor()
cur.execute("select lastfm_id from scrobbles where has_spotify_id=false limit %s" % group_size)
return [x[0] for x in cur]
def get_total_scrobbles():
conn = database_connection()
cur = conn.cursor()
cur.execute("select count(*) from scrobbles")
return cur.next()[0]
#!/usr/bin/python
# -*- coding: utf-8 -*-
from flask import Flask
from flask_restful.utils.cors import crossdomain
import config
app = Flask(__name__)
app.secret_key = config.SECRET_KEY
app.decorators = [crossdomain(origin='*')]
from db import database_connection
# Calls database connection
mongo = database_connection()
from apps.facerecognition.views import face_auth
from apps.school.views import version3_school
app.register_blueprint(
face_auth,
url_prefix='{prefix}'.format(prefix=config.URL_PREFIX))
app.register_blueprint(
version3_school,
url_prefix='{prefix}'.format(prefix=config.URL_PREFIX))
if __name__ == "__main__":
app.run(host=app.config['HOST'], port=app.config['PORT'])
def with_ids():
conn = database_connection()
cur = conn.cursor()
cur.execute("select count(*) from scrobbles where has_spotify_id=true")
return cur.next()[0]
