<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    jojo's blog--快樂憂傷都與你同在
    為夢想而來,為自由而生。 性情若水,風起水興,風息水止,故時而激蕩,時又清平……
    posts - 11,  comments - 30,  trackbacks - 0
    [mdrop@authbackup5 jojo]$ cat insert_sql_statement.sql

    #!/usr/bin/perl -w

    #
    # Created by: JoJo
    # Created Date: 28 July 2009
    # Desc: To create the sql statement for Sanriotown Digital
    #

    use DateTime;
    use DBI;


    #open log file for writing, append purpose
    open(MYLOGFILE, ">> mylog");


    ######### Step 1: Create DB Connection  ################################
    #definition of variables
    $db="UserDB";
    $host="localhost";
    $socket="/var/lib/auth5-1.us4/mysql1/mysql.sock";
    $user="root";
    $password="pwd";


    #connect to MySQL database
    my $dbh   = DBI->connect ("DBI:mysql::mysql_socket=$socket;database=$db:host=$host",$user,$password)
                             or die "Can't connect to database: $DBI::errstr"n";



    ######### Step 2: Get Active User ################################

    # Get date
    my $sdt = DateTime->now;
    # Get active user ( from userdb, usertype != 8)
    print MYLOGFILE "Get all active users from cobranddb.sanriotown_com_userdb tables at  $sdt."n";
    #!`echo 'select username from cobranddb.sanriotown_com_userdb where usertype  &8 <> 8 '|mysql -uroot -ppwd --socket=/var/lib/auth5-1.us4/mysql/mysql.sock --skip-column-names >  activeuser.txt` || die print "Cannot connect to cobranddb database."n";
    # Get date
    my $edt = DateTime->now;
    print MYLOGFILE "Finish grep all active users from cobranddb.sanriotown_com_userdb tables at  $edt."n";




    ######### Step 3: Get Active UserID and Field Value, then Create Insert Statement File#############

    # Open active user file for reading
    open (USERFILE, 'activeuser.txt');
    # Get date
    my $s1dt = DateTime->now;
    # Get active userid and its field value for "country" filedname whose cobrand is "sanriotown.com"
    print MYLOGFILE "Get active userid and its field value for 'country' filedname whose cobrand is 'sanriotown.com' from UserDB.UserProfileTbl and UserDB.UserTbl tables at  $s1dt."n";
    while (<USERFILE>) {
      chomp;
      #prepare the query
      my $sql = "select  u.userid, p.fieldvalue from UserDB.UserProfileTbl p, UserDB.UserTbl u where u.cobrand='sanriotown.com' and u.username='$_' and u.userid=p.userid and p.fieldname='country' ";
      my $sth = $dbh->prepare( $sql);
      #execute the query
      $sth->execute( );

      ## Retrieve the results of a row of data and print
      my ( $userid,$fieldvalue);
      $sth->bind_columns ( undef,"$userid,"$fieldvalue );
      while ( $sth->fetch( ) )  {      
          #print MYLOGFILE  "Userid is $userid and the fieldvalue is $fieldvalue"n";
          `echo "insert UserDB.UserProfileTbl values($userid,'orignal_country', '$fieldvalue');" >> insert_sql_statement.sql`;
      }

      $sth->finish( );
    }
    # Get date
    my $e1dt = DateTime->now;
    print MYLOGFILE "Finish grep active userid and its field value for 'country' filedname whose cobrand is 'sanriotown.com' from UserDB.UserProfileTbl and UserDB.UserTbl tables at  $e1dt."n";


    ######### Step 4: Close All File and DB Connection#############

    # Close all opened file
    close (USERFILE);
    close (MYLOGFILE);
    $dbh->disconnect( );
    exit;

    posted on 2009-07-29 10:13 Blog of JoJo 閱讀(272) 評論(0)  編輯  收藏 所屬分類: 每日一記 、My Script

    <2025年5月>
    27282930123
    45678910
    11121314151617
    18192021222324
    25262728293031
    1234567

    常用鏈接

    留言簿(6)

    隨筆檔案

    文章分類

    文章檔案

    新聞分類

    新聞檔案

    相冊

    收藏夾

    搜索

    •  

    最新評論

    閱讀排行榜

    評論排行榜

    主站蜘蛛池模板: 亚洲 欧洲 日韩 综合在线| 亚洲av无码乱码国产精品fc2| 亚洲男人的天堂久久精品| 亚欧免费视频一区二区三区| 久久久久亚洲av无码专区喷水| 久久久高清日本道免费观看| 91亚洲国产成人久久精品网站| 亚欧免费无码aⅴ在线观看| 久久亚洲私人国产精品vA| 18女人毛片水真多免费| 亚洲Av高清一区二区三区| 久久综合AV免费观看| 亚洲日韩国产一区二区三区在线| 好男人看视频免费2019中文| 亚洲精品又粗又大又爽A片| 夜色阁亚洲一区二区三区| 中文字幕高清免费不卡视频| 久久亚洲国产精品| 1000部拍拍拍18勿入免费凤凰福利| 亚洲剧情在线观看| 国产精品久久香蕉免费播放| 亚洲免费在线观看| 精品日韩亚洲AV无码| 成人免费看黄20分钟| 成人a毛片视频免费看| 久久久久亚洲AV无码专区首| 日本XXX黄区免费看| 免费精品国自产拍在线播放| 亚洲av永久无码精品古装片| 啦啦啦高清视频在线观看免费| 九九免费久久这里有精品23| 日木av无码专区亚洲av毛片| 成人免费一区二区三区在线观看| 猫咪免费人成在线网站| 西西人体44rt高清亚洲| 黄a大片av永久免费| 两个人看www免费视频| 亚洲精品无AMM毛片| 亚洲高清国产AV拍精品青青草原| 最近2019中文免费字幕| 中文字幕免费不卡二区|