Python user_get_uid Examples

Example #1

def get_avatar(burl, height):
    """ xxx """
    return_data = ''
    uid = user_get_uid()
    avatar_id = 0
    connection = pymysql.connect(host=DB_SRV,
                                 user=DB_USR,
                                 password=DB_PWD,
                                 db=DB_NAME,
                                 charset='utf8mb4',
                                 cursorclass=pymysql.cursors.DictCursor)
    cursor = connection.cursor(pymysql.cursors.SSCursor)
    sql = "SELECT avatar_id FROM users WHERE uid = '" + str(uid) + "'"
    cursor.execute(sql)
    res = cursor.fetchall()
    for row in res:
        avatar_id = row[0]

    if avatar_id != 0:
        return_data = '<img alt="" src="'+\
        burl+'static/avatar/'+\
        str(avatar_id) +'.png" style="vertical-align: middle;border-style: none;width: '+\
        str(height) +'px;">'

    cursor.close()
    connection.close()
    return return_data

Example #2

def get_box_user_profile_header():
    """ Get the moving tickers header """
    box_content = ''
    if user_is_login() == 1:
        uid = user_get_uid()

        box_content = '<div class="box-uhead sa-uhead-box">' +\
        '   <div class="row sa-uhead-box bg-dark">'+\
        '        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">'+\
        '            <div class="box-part rounded sa-center-content sa-uhead-box" '+\
        'style="height: 95px;">'+\
        get_tradingview_ticker(uid) +\
        '            </div>'+\
        '        </div>'+\
        '   </div>'+\
        '</div>'

    return box_content

Example #3

File: portf_save.py Project: k-7f3dap1320/sa-2fnixdzh9i

def portf_get_user_numeric_id():
    """ xxx """
    return_data = ''
    uid = user_get_uid()
    connection = pymysql.connect(host=DB_SRV,
                                 user=DB_USR,
                                 password=DB_PWD,
                                 db=DB_NAME,
                                 charset='utf8mb4',
                                 cursorclass=pymysql.cursors.DictCursor)
    cursor = connection.cursor(pymysql.cursors.SSCursor)
    sql = "SELECT id FROM users WHERE uid='" + str(uid) + "'"
    cursor.execute(sql)
    res = cursor.fetchall()
    for row in res:
        return_data = row[0]
    cursor.close()
    connection.close()
    return return_data

Example #4

File: select_market.py Project: k-7f3dap1320/sa-2fnixdzh9i

def save_selectmarket(burl, sel):
    """ xxx """
    return_data = set_page(get_head('<meta http-equiv="refresh" content="0;URL=' +\
                                    burl + 'genportf/?acm='+\
                                    str(sel) +'&step=1&notstart=0" />') + get_body('', '',''))
    user_id = user_get_uid()
    connection = pymysql.connect(host=DB_SRV,
                                 user=DB_USR,
                                 password=DB_PWD,
                                 db=DB_NAME,
                                 charset='utf8mb4',
                                 cursorclass=pymysql.cursors.DictCursor)
    cursor = connection.cursor(pymysql.cursors.SSCursor)
    sql = "UPDATE users SET default_profile='" + str(
        sel) + "' WHERE uid='" + str(user_id) + "'"
    cursor.execute(sql)
    connection.commit()
    cursor.close()
    connection.close()
    return return_data

Example #5

def get_user():
    """ xxx """
    return_data = user_get_uid()
    return return_data