Esempio n. 1
0
    def __init__(self,config):
        logging.info("START dialib")
        self.dbf=join(config["rootpath"],config["dbfile"])
        self.htmlconf=config["html"]
        self.html={}
        self.photo={}
        self.langconfig=join(config["rootpath"],
                             config["conf_lang"]+"_"+config['lang']+'.conf')

        f=open(self.htmlconf,'r')
        try:
            for ligne in f:
                if ligne[:2] == '[*':
                    label=ligne[2:]
                    label=label[:-1].strip()
                    label=label[:-2]
                    logging.debug("label=%s",label)
                    text=""
                else:
                    if ligne[:5]=="#####":
                        self.html[label]=text
                    else:
                        text+=ligne
        finally:
            f.close()
                        
        chdir(config["photopath"])
        db=SQLite(self.dbf)
        req='select rowid from groups where name="all"'
        res=db.select(req)
        self.id_group_all=res[0][0]
Esempio n. 2
0
    def usermgt(self,name='',pwd='',group=''):
        m=hmenu(self.langconfig,self.dbf)
        db=SQLite(self.dbf)

        ### parameter treatment
        if name=='':
            if group!='':
                req='insert into groups values("{}")'.format(group)
                status=db.upd_ins(req)
        else:
            req='select rowid from groups where name="{}"'.format(group)
            idgroup=db.select(req)
            hashpwd=bcrypt.hashpw(pwd,bcrypt.gensalt())

            req='insert into users (name,hashpass,id_group)'
            req+=' values("{}","{}",{})'.format(name,hashpwd,idgroup[0][0])
            status=db.upd_ins(req)

        try:
            sname=cherrypy.session['name']
            [actions,contenu]=m.usersAndGroup()
        except Exception as err:
            logging.error("in usermgt: %s",err)
            contenu=m.unknown()
        HTMLpage=self.html["globalTemplate"].format(actions,contenu)
        return HTMLpage
Esempio n. 3
0
 def __init__(self,name,pwd,dbfile):
     db=SQLite(dbfile)
     logging.debug("account:dbfile:%s",dbfile)
     req="select rowid,hashpass,id_group from users "
     req+='where name="{}"'.format(name)
     result=db.select(req)
     if result==[]:
         logging.info("account:user %s does not exist",name)
         cherrypy.session['mess']="userKO"
     else:
         id_name=result[0][0]
         hashpass=result[0][1]
         id_group=result[0][2]
         if bcrypt.hashpw(pwd,hashpass) == hashpass:
             ## password has been verified
             cherrypy.session['name']=name
             cherrypy.session['id_name']=id_name
             cherrypy.session['id_group']=id_group
             cherrypy.session['mess']="OK"
             logging.info("account:user %s:loged in",name)
         else:
             logging.info("account:user %s:wrong password",name)
             cherrypy.session['mess']="pwdKO"
Esempio n. 4
0
 def __init__(self,langconfig,dbfile):
     messagefile=getconfig(langconfig)
     self.messages=messagefile.getconfig()
     messagefile.close()
     self.db=SQLite(dbfile)
Esempio n. 5
0
class hmenu(object):
    def __init__(self,langconfig,dbfile):
        messagefile=getconfig(langconfig)
        self.messages=messagefile.getconfig()
        messagefile.close()
        self.db=SQLite(dbfile)


    def menuButton(self,message,link,anchor=""):
        '''
        create a button to navigate in the menu
        parameters:
        1 : message to print in the button (to be found in lang
        config files)
        2 : link to next web page

        '''
        htmlpage='<td class="hmenu_left" width="10" height="32"></td>\n'
        htmlpage+='<td class="hmenu_center"><a href="{}"'.format(link)
        if anchor!="":
            htmlpage+=' class="highslide" id="{}" '.format(anchor)
            htmlpage+='onclick="return hs.htmlExpand(this,'
            htmlpage+='{objectType: \'iframe\', outlineType: '
            htmlpage+='\'rounded-white\'})"\n'
        htmlpage+='>{}</a></td>\n'.format(self.messages[message])
        htmlpage+='<td class="hmenu_right" width="10"></td>\n'
        htmlpage+='<td width="10"></td>\n'

        return htmlpage

    def actionfor(self,name):
        '''
        will create the appropriate menu for 'name' depending on its right
        firstly for admin user ...
        '''

        logging.debug('menu:actionfor %s',cherrypy.session['name'])
        buttons='<table border="0" cellspacing="0">\n<tr>\n'
        buttons+='<td>{} : </td>'.format(cherrypy.session['name'])
        if name=="admin":
            ### return to main menu
            buttons+=self.menuButton('retour','/')
            ### user manangement
            buttons+=self.menuButton('usermgt','/usermgt')
            ### folder management
            buttons+=self.menuButton('foldermgt','/foldermgt')
    
        buttons+='</tr>\n</table>\n'
        
        return buttons

    def manageList(self,message,req):
        '''
        manage a list of element (allow to list, add, delete element)
        '''

        List=self.db.select(req)
        htmlpage='<h3>{}</h3>\n'.format(self.messages[message])
        for element in List:
            htmlpage+='<p><a href="highslide/users.html" class="highslide"'
            htmlpage+=' onclick="return hs.htmlExpand(this,'
            htmlpage+='{objecType:\'iframe\', outlineType: \'rounded-white\'})">\n'
            try:
                htmlpage+='{}</a> [{}]</p>\n'.format(element[0],element[1])
            except:
                htmlpage+='{}</a></p>\n'.format(element[0])

        ### table for action button
        htmlpage+='<table border="0" cellspacing="0">\n<tr>\n'
        link="/highslide/{}.html".format(message)
        htmlpage+=self.menuButton('create',link,message)
        htmlpage+='</tr>\n</table>\n'

        return htmlpage


    def usersAndGroup(self):
        ''' 
        page to manage users and group
        '''
        ### menu for userAndGroup page
        logging.debug("in usersAndGroup[%s]",cherrypy.session['name'])
        actions='<table border="0" cellspacing="0">\n<tr>\n'
        actions+='<td>{} : </td>'.format(cherrypy.session['name'])
        actions+=self.menuButton('retour','/')
        actions+='</tr>\n</table>\n'

        ### user manangement
        htmlpage='<td valign="top">\n'
        ### get list of users from db
        req='select users.name,groups.name from users,groups '
        req+='where users.id_group=groups.rowid'
        htmlpage+=self.manageList('listuser',req)

        ### end of user management
        htmlpage+='</td>\n'

        htmlpage+='<td width="20"></td>'

        ### group management
        htmlpage+='<td valign="top">\n'
        ### get list of groups from db
        req='select name from groups'
        htmlpage+=self.manageList('listgroup',req)

        ### end of folder management
        htmlpage+='</td>\n'

        return [actions,htmlpage]


    def foldersAndGroup(self):
        ''' 
        page to folder and group
        '''
        ### menu for folderAndGroup page
        logging.debug("in foldersAndGroup[%s]",cherrypy.session['name'])
        actions='<table border="0" cellspacing="0">\n<tr>\n'
        actions+='<td>{} : </td>'.format(cherrypy.session['name'])
        actions+=self.menuButton('retour','/')
        actions+='</tr>\n</table>\n'
        ### folder manangement
        htmlpage='<table border="0" cellspacing="0">\n<tr>\n'
        htmlpage+='<td>{} : </td>'.format(cherrypy.session['name'])
        htmlpage+='</tr>\n</table>\n'

        return htmlpage

    def unknown(self):
        '''
        only return button for unknown users
        '''
        htmlpage='<table border="0" cellspacing="0">\n<tr>\n'
        htmlpage+='<p class="error">{}</p>'.format(self.messages['notconnect'])
        htmlpage+=self.menuButton('retour','/')
        htmlpage+='</tr>\n</table>\n'

        return htmlpage
Esempio n. 6
0
def insertPathInDb(path):
    ### insert folder into db
    reqi="insert into folder values ('{}',0)".format(path)
    db=SQLite(join(config["rootpath"],config["dbfile"]))
    return db.upd_ins(reqi)
Esempio n. 7
0
def getPathInDb(path):
    ### check folder into db
    reqs="select rowid from folder where dirname='{}'".format(path)
    db=SQLite(join(config["rootpath"],config["dbfile"]))
    return db.select(reqs)
Esempio n. 8
0
def insertPathInDb(path):
    ### insert folder into db
    reqi="insert into folder values ('{}',0)".format(path)
    db=SQLite(join(config["rootpath"],config["dbfile"]))
    return db.upd_ins(reqi)




logging.info("START searchPhoto")
logging.info("searchPhoto:config file: %s",args.config)

### -t args have been passed : 
if args.createTables:
    logging.info("searchPhoto:createTable will run")
    db=SQLite(join(config["rootpath"],config["dbfile"]))
    res=db.create(join(config["rootpath"],config["tables"]))
    if res=="createOK":
        logging.info("searchPhoto:createTable run successfully")
    else:
        logging.error("searchPhoto:createTable run with error")

### start searching for files from photopath
bl=[]
filebl=open(join(config["rootpath"],config["blacklist"]),'r')
for l in filebl:
    bl.append(l[:-1])

chdir(config["photopath"])
### first, check/insert for "." path presence in db
res=getPathInDb(".")
Esempio n. 9
0
    def index(self,path='.',uname='',pwd=''):
        messagefile=getconfig(self.langconfig)
        messages=messagefile.getconfig()
        messagefile.close()

        ### affichage de la colonne menu: login, arbo, timeline
        actions=""
        contenu='<td valign="top">\n'
        bouton='<p><a href="/highslide/login.html" \
                    class="highslide" id="login" '
        bouton+='onclick="return hs.htmlExpand(this,\
                {objectType: \'iframe\', outlineType: \'rounded-white\'})">\n'
        bouton+='login</a></p>\n'

        #### checking for the user connection
        m=hmenu(self.langconfig,self.dbf)
        if uname!='':
            try:
                sname=cherrypy.session['name']
                contenu+='<p class="error">{}</p>\n'.format(
                    messages['alreadyconnected'])
                actions+=m.actionfor(sname)

            except:
                userac=account(uname,pwd,self.dbf)
                if cherrypy.session['mess']=="userKO":
                    contenu+='<p class="error">{}</p>\n'.format(
                        messages['userko'])
                    contenu+=bouton
                elif cherrypy.session['mess']=="pwdKO":
                    contenu+='<p class="error">{}</p>\n'.format(
                        messages['passwordko'])
                    contenu+=bouton
                else:
                    sname=cherrypy.session['name']
                    actions+=m.actionfor(sname)
        else:
            try:
                sname=cherrypy.session['name']
                actions+=m.actionfor(sname)
            except:
                contenu+=bouton

        #### getting list of directory in current folder
        db=SQLite(self.dbf)
        req='select dirname,rowid from folder where folder.rowid in\n'
        req+='(select id_folder_son from folderParent\n'
        req+='inner join folder on id_folder_father=folder.rowid\n'
        req+='and dirname="{}")'.format(path)
        res=db.select(req)
        
        #### getting access right on the list of folders
        listidfolder=''
        for r in res:
            listidfolder+="{},".format(r[1])

        listidfolder=listidfolder[:1] ### delete last comma

        try:
            req='select id_folder from folderByGroup '
            req+='where id_group={} '.format(self.id_group_all)
            req+='or id_group={}'.format(cherrypy.session['id_group'])
            access=db.select(req)
        except:
            req='select id_folder from folderByGroup '
            req+='where id_group={}'.format(self.id_group_all)
            access=db.select(req)

        aright=[]
        for i in access:
            aright.append(i[0])
        affpath="/"+path[2:]

        contenu+='<div class="menu">\n'
        contenu+='<a href="index?path=.">\
        <img src="/highslide/home.png" width=25 height=25></a>\n'
        contenu+='{}\n<ul>\n'.format(affpath)
        for r in res:
            if r[1] in aright:
                contenu+='<li class="open">'
                contenu+='<a href="index?path={}">{}</a></li>\n'.\
                         format(r[0],basename(r[0]))
            else:
                contenu+='<li class="lock"><a href="/highslide/login.html" '
                contenu+='class="highslide" id="login" '
                contenu+='onclick="return hs.htmlExpand(this,'
                contenu+='{objectType: \'iframe\', outlineType: '
                contenu+='\'rounded-white\'})">\n'
                contenu+='{}</a></li>\n'.format(basename(r[0]))


        contenu+='</ul>\n</td>\n'
        contenu+='</div>\n'

        #### getting list of image in current folder
        db=SQLite(self.dbf)
        req='select filename from files where id_dir=\n'
        req+='(select rowid from folder where dirname="{}")'.format(path)
        res=db.select(req)

        #### affichage des thumbs
        contenu+='<td>\n'
        contenu+='<div class="highslide-gallery">\n'
        if res!=[]:
            for p in res:
                contenu+='<a class="highslide" '
                contenu+='href="/photos/{}/{}" '.format(path,p[0])
                contenu+='onclick="return hs.expand(this,config1)">\n'
                contenu+='<img \
                src="/photos/{}/.Thumbnails/{}"/>'.format(path,p[0])
                contenu+='</a>'
    
    
        contenu+="</td>\n"
        HTMLpage=self.html["globalTemplate"].format(actions,contenu)
        return HTMLpage