Beispiel #1
0
    def new(cls, id, url, name):
        if url == str(id):
            url = ''

        if url.isdigit():
            id = int(url)
            url = ''

        o = None
        if id:
            o = cls.mc_get(id)

        if o is None and url:
            o = cls.get(url=url)

        if o is None:
            o = cls()

        o.id = id

        if url:
            o.url = url
            #print url
            key = mc_model_url%(cls.__name__ , url)
            mc.set(key, id)
        key = mc_model_url%(cls.__name__ , id)
        mc.set(key, id)

        if name:
            o.name = name

        o.save()

        return o
Beispiel #2
0
 def mc_id_by_value_new(self, value):
     id = self.mc_id_by_value(value)
     if not id:
         id = self.insert(value)
         h = md5(value).hexdigest()
         mc_key = self.__mc_value__ % h
         mc.set(mc_key, id)
     return id
Beispiel #3
0
 def mc_id_by_value(self, value):
     h = md5(value).hexdigest()
     mc_key = self.__mc_value__ % h
     r = mc.get(mc_key)
     if r is None:
         r = self.id_by_value(value)
         mc.set(mc_key, r)
     return r
Beispiel #4
0
 def insert_no_value_cache(self, value):
     cursor = self.cursor
     cursor.execute(
         'insert into %s (value) values (%%s)' % self.__table__,
         value
     )
     cursor.connection.commit()
     id = cursor.lastrowid
     mc_key = self.__mc_id__ % id
     mc.set(mc_key, value)
     return id
Beispiel #5
0
 def get(self, id):
     mc_key = self.__mc_id__ % id
     r = mc.get(mc_key)
     if r is None:
         cursor = self.cursor
         cursor.execute('select value from %s where id=%%s' % self.__table__, id)
         r = cursor.fetchone()
         if r:
             r = r[0]
         if r is None:
             r = self.NULL
         mc.set(mc_key, r)
     return r
Beispiel #6
0
 def by_url(cls, url):
     key = mc_model_url%(cls.__name__ , url)
     id = mc.get(key)
     if id is None:
         if type(url) in (int, long) or url.isdigit():
             o = cls.mc_get(url)
             if o:
                 id = o.id
         else:
             o = cls.get(url=url)
             if o:
                 id = o.id
     mc.set(key, id or 0)
     return id
Beispiel #7
0
 def set(self, id, value):
     r = self.get(id)
     if r != value:
         mc_key = self.__mc_id__ % id
         cursor = self.cursor
         table = self.__table__
         cursor.execute(
             'insert into %s (id,value) values (%%s,%%s) on duplicate key update value=values(value)' % table,
             (id, value)
         )
         cursor.connection.commit()
         if value is None:
             value = False
         mc.set(mc_key, value)
Beispiel #8
0
 def mc_value_id_set(self, value, id):
     h = md5(value).hexdigest()
     mc_key = self.__mc_value__ % h
     mc.set(mc_key, id)
Beispiel #9
0
        setattr(i, key, func(i.id))


def ico_url_bind(zsite_list):
    return ico_url_bind_with_default(zsite_list, ico_url)


def pic_url_bind(zsite_list, size):
    key = "pic%s" % size
    for i in zsite_list:
        setattr(i, key, pic_url(i.id, size))


def pic_url_bind_with_default(zsite_list, size):
    key = "pic%s" % size
    for i in zsite_list:
        setattr(i, key, pic_url_with_default(i.id, size))


if __name__ == "__main__":
    # print ico_url(399)
    # print pic_url(399)
    from _db import mc

    mc = mc.mc
    for i in range(100000):
        mc.set("1", 1)
        mc.delete("1")
        if mc.get("1"):
            print "!!!"
Beispiel #10
0
def pic_url_bind(zsite_list, size):
    key = 'pic%s' % size
    for i in zsite_list:
        setattr(
            i,
            key,
            pic_url(i.id, size)
        )

def pic_url_bind_with_default(zsite_list, size):
    key = 'pic%s' % size
    for i in zsite_list:
        setattr(
            i,
            key,
            pic_url_with_default(i.id, size)
        )


if __name__ == '__main__':
    #print ico_url(399)
    #print pic_url(399)
    from _db import mc
    mc = mc.mc
    for i in range(100000):
        mc.set('1', 1)
        mc.delete('1')
        if mc.get('1'):
            print '!!!'