Python get_one_value_int 예제들

예제 #1

파일: tool_import_times_from_collection.py 프로젝트: jason-xxl/statty

def process(my_date):

    global whole_collection, element_existance_counters, sql_collection_id

    current_date=datetime.fromtimestamp(my_date).strftime('%Y-%m-%d')
    
    collection_id = helper_mysql.get_one_value_int(sql_collection_id % (current_date,))

    collection=helper_mysql.get_raw_collection_by_id(collection_id)

    if not collection_id or not collection:
        print 'No collection of',current_date,collection_id
        return
    
    whole_collection|=collection

    for i in collection:
        if not element_existance_counters.has_key(i):
            element_existance_counters[i]=0
        element_existance_counters[i]+=1

예제 #2

파일: tool_insert_value.py 프로젝트: jason-xxl/statty

key='daily_fresh_subscriber_include_unsub'
sub_key=''
date='2011-11-04'
value='1024'

helper_mysql.put_raw_data(oem_name=oem_name,category=category,key=key,sub_key=sub_key, \
value=value,table_name=db_name,date=date,created_on=None,db_conn=None)

exit()

helper_mysql.db.query(r'''
delete from `%s` where oem_name='%s' and category='%s' and `key`='%s' and `sub_key`='%s' and `date`='%s'
''' % (db_name,oem_name,category,key,sub_key,date))

print 'matched rows:'+str(helper_mysql.get_one_value_int(r'''
select count(*) from `%s` where oem_name='%s' and category='%s' and `key`='%s' and `date`='%s'
''' % (db_name,oem_name,category,key,date)))

print 'first value:'+str(helper_mysql.get_one_value_int(r'''
select `value` from `%s` where oem_name='%s' and category='%s' and `key`='%s' and `date`='%s'
''' % (db_name,oem_name,category,key,date)))

helper_mysql.db.query(r'''replace INTO `mozat_stat`.`%s` (`oem_name` ,`category` ,`key` ,`sub_key` ,`date` ,`value` ,`created_on`)VALUES ('%s', '%s', '%s', '%s', '%s', '%s',CURRENT_TIMESTAMP);''' \
         % (db_name,oem_name,category,key,sub_key,value,date))

print 'updated value:'+str(helper_mysql.get_one_value_int(r'''
select `value` from `%s` where oem_name='%s' and category='%s' and `key`='%s' and `date`='%s'
''' % (db_name,oem_name,category,key,date)))

예제 #3

파일: tool_copy_view.py 프로젝트: jason-xxl/statty

for id in view_ids:
    db.query(r'select * from view where id='+str(id))
    result_set = db.store_result()

    row = result_set.fetch_row(how=2)
    #({'view.name': 'Operators_Reports STC Overall 5 Average Data Per User', 'view.description': '', 'view.day_range_default': '0', 'view.sql': "...", 'view.default_tab': '0', 'view.chart': '', 'view.id': '71'},)

    if row:
        row=row[0]

        name=row['view.name'].replace('Umniah','Globe')
        sql=row['view.sql'].replace('Umniah','Globe').replace('umniah','globe')

        max_view_id=helper_mysql.get_one_value_int(r'''
        select max(`id`) from `view`
        ''')

        description=row['view.description'].replace(str(row['view.id']),str(max_view_id+1))
        
        print 'view_name:'+name
        print 'sql:'+sql
        print '\n'
        
        db.query(r'insert into view (`name`,`description`,`day_range_default`,`sql`,`conn_string`) values (%s,%s,%s,%s,%s)' \
                              %(db.string_literal(name),db.string_literal(description), \
                                db.string_literal(row['view.day_range_default']),db.string_literal(sql),db.string_literal(row['view.conn_string'])))
        view_id=row['view.id']
        new_id=db.insert_id()
        print 'inserted view:'+str(new_id)