Command Line Admin

From Tera-WURFL

Revision as of 06:12, 23 January 2011 by Kamermans (Talk | contribs)
Jump to: navigation, search

As of Tera-WURFL 2.1.3, you can perform all of the Tera-WURFL administration tasks from the command line in Linux, Windows, Mac OS and any other OS that can execute PHP scripts.

Contents

Usage

To use the CLI, just go to the admin/ folder in your Tera-WURFL installation. To see what options are available in your version, just run php cmd_line_admin.php:

# php cmd_line_admin.php
 
Tera-WURFL Stable 2.1.3
The command line WURFL updater for Tera-WURFL
Loaded WURFL: www.wurflpro.com - 2010-09-09 04:08:06
Last Updated: Wed, 15 Sep 2010 20:38:59 -0500
---------------------------------------
Usage: php cmd_line_admin.php [OPTIONS]
 
Option                     Meaning
 --help                    Show this message
 --update=<local,remote>   The source of the WURFL file:
                             Update from your local wurfl.xml file:
                               --update=local
                             Update from wurfl.sourceforge.net:
                               --update=remote
 --clearCache              Clear the device cache
 --rebuildCache            Rebuild the device cache by redetecting all
                             cached devices using the current WURFL
 --stats                   Show statistics about the Tera-WURFL Database

Updating the WURFL

To update the WURFL from the command line, use the --update=local or --update=remote parameter. "local" will load your local data/wurfl.xml, and "remote" will download the latest WURFL from wurfl.sourceforge.net (or whatever you set in TeraWurflConfig.php) and then use it to update Tera-WURFL.

# php cmd_line_admin.php --update=remote
Downloading WURFL from http://downloads.sourceforge.net/project/wurfl/WURFL/latest/wurfl-latest.zip ...
 
done (/testtw/2.1.3/mongo/data/wurfl.xml: 14.80 MB [897.30 KB compressed])
Downloaded in 4.6609511375427 sec @ 1.58 Mbps
 
Database Update OK
Total Time: 22.146492004395
Parse Time: 3.8051941394806 (TeraWurflXMLParser_SimpleXML)
Validate Time: 0.024373054504395
Sort Time: 1.2780990600586
Patch Time: 0.50953578948975
Database Time: 8.9265999794006
Cache Rebuild Time: 7.6026899814606
Number of Queries: 2456
PHP Memory Usage: 54.49 MB
--------------------------------
WURFL Version: www.wurflpro.com - 2010-09-17 15:50:54 (Fri Sep 17 15:56:32 -0500 2010)
WURFL Devices: 13687
PATCH New Devices: 39
PATCH Merged Devices: 1

Clearing the Device Cache

To clear the device cache from the command line, use the --clearCache parameter.

# php cmd_line_admin.php --clearCache
Device cache has been cleared.

Getting Tera-WURFL Statistics

To get general statistics about Tera-WURFL, use the --stats parameter.

# php cmd_line_admin.php --stats
Tera-WURFL Stable 2.1.3
Database Type: MongoDB (ver MongoDB 1.6.2)
Loaded WURFL: www.wurflpro.com - 2010-09-17 15:50:54
Last Updated: Sat, 18 Sep 2010 15:28:05 -0500
Config File: /testtw/2.1.3/mongo/TeraWurflConfig.php
---------- Table Stats -----------
 
 > MERGE
   Rows:    13726
   Devices: 6229
   Size:    30.00 MB
 
 > CACHE
   Rows:    522
   Size:    1.23 MB

Debugging Functions

There are also some debugging functions that are not shown in the help file. We use them internally for testing and troubleshooting, and you might also find a use for them.

--debug=constIDgrouped

Get the constant WURFL IDs that are hardcoded into the UserAgentMatcher files, grouped by UserAgentMatcher

#php cmd_line_admin.php --debug=constIDgrouped
 
AppleUserAgentMatcher
        apple_ipod_touch_ver1
        apple_ipad_ver1
        apple_iphone_ver1
BlackBerryUserAgentMatcher
        blackberry_generic_ver2
        blackberry_generic_ver3_sub2
        blackberry_generic_ver3_sub30
        blackberry_generic_ver3_sub50
        blackberry_generic_ver3_sub60
        blackberry_generic_ver3_sub70
        blackberry_generic_ver4
CatchAllUserAgentMatcher
        opwv_v72_generic
        opwv_v7_generic
        opwv_v62_generic
        opwv_v6_generic
        upgui_generic
        uptext_generic
        nokia_generic_series60
        generic_netfront_ver3
        generic_netfront_ver3_1
        generic_netfront_ver3_2
        generic_netfront_ver3_3
        generic_netfront_ver3_4
        generic_netfront_ver3_5
        docomo_generic_jap_ver1
ChromeUserAgentMatcher
        google_chrome
DoCoMoUserAgentMatcher
        docomo_generic_jap_ver2
        docomo_generic_jap_ver1
FirefoxUserAgentMatcher
        firefox_1
        firefox_1_5
        firefox_2
        firefox_3
        firefox_3_5
KddiUserAgentMatcher
        opwv_v62_generic
MotorolaUserAgentMatcher
        mot_mib22_generic
MSIEUserAgentMatcher
        msie
        msie_4
        msie_5
        msie_5_5
        msie_6
        msie_7
        msie_8
NintendoUserAgentMatcher
        nintendo_wii_browser
        nintendo_dsi_ver1
        nintendo_ds_ver1
NokiaUserAgentMatcher
        nokia_generic_series60
        nokia_generic_series80
OperaUserAgentMatcher
        opera
        opera_7
        opera_8
        opera_9
        opera_10
OperaMiniUserAgentMatcher
        browser_opera_mini_release1
        browser_opera_mini_release2
        browser_opera_mini_release3
        browser_opera_mini_release4
        browser_opera_mini_release4
WindowsCEUserAgentMatcher
        generic_ms_mobile_browser_ver1

--debug=constIDunique

Get the distinct constant WURFL IDs that are hardcoded into the UserAgentMatcher files

# php cmd_line_admin.php --debug=constIDunique
apple_ipad_ver1
apple_iphone_ver1
apple_ipod_touch_ver1
blackberry_generic_ver2
blackberry_generic_ver3_sub2
blackberry_generic_ver3_sub30
blackberry_generic_ver3_sub50
blackberry_generic_ver3_sub60
blackberry_generic_ver3_sub70
blackberry_generic_ver4
browser_opera_mini_release1
browser_opera_mini_release2
browser_opera_mini_release3
browser_opera_mini_release4
docomo_generic_jap_ver1
docomo_generic_jap_ver2
firefox_1
firefox_1_5
firefox_2
firefox_3
firefox_3_5
generic_ms_mobile_browser_ver1
generic_netfront_ver3
generic_netfront_ver3_1
generic_netfront_ver3_2
generic_netfront_ver3_3
generic_netfront_ver3_4
generic_netfront_ver3_5
google_chrome
mot_mib22_generic
msie
msie_4
msie_5
msie_5_5
msie_6
msie_7
msie_8
nintendo_ds_ver1
nintendo_dsi_ver1
nintendo_wii_browser
nokia_generic_series60
nokia_generic_series80
opera
opera_10
opera_7
opera_8
opera_9
opwv_v62_generic
opwv_v6_generic
opwv_v72_generic
opwv_v7_generic
upgui_generic
uptext_generic

--debug=createProcs

Recreate the stored procedures / database server-side functions without reloading the WURFL.

# php cmd_line_admin.php --debug=createProcs
Recreating Procedures.
Done.


--debug=batchLookupFallback --file=filename.txt

Iterate over the specified text file which contains one WURFL ID per row and print off the complete fallback tree for this device. This function is only supported on DatabaseConnectors that implement the fallback lookup directly on the database (MySQL5, MongoDB).

# php cmd_line_admin.php --debug=batchLookupFallback --file=filename.txt
samsung_sgh_i707_ver1, generic_mobile_browser_ver1_winmo7, generic_ms_mobile_browser_ver1_winmo6_5, generic_ms_mobile_browser_ver1_winmo6_1, generic_ms_mobile_browser_ver1_winmo6, generic_ms_mobile_browser_ver1_winmo5, generic_ms_mobile_browser_ver1_winmo2003, generic_ms_mobile_browser_ver1_pocketpc2002, generic_ms_mobile_browser_ver1_pocketpc2000, generic_ms_mobile_browser_ver1, generic_xhtml, generic
 
samsung_gt_e2121_ver1, opwv_v62_generic, opwv_v61_generic, opwv_v6_generic, upgui_generic, generic
 
apple_iphone_ver4, apple_iphone_ver3_1_3, apple_iphone_ver3_1_2, apple_iphone_ver3_1, apple_iphone_ver3, apple_iphone_ver2_2_1, apple_iphone_ver2_2, apple_iphone_ver2_1, apple_iphone_ver2, apple_iphone_ver1, apple_generic, generic_xhtml, generic
 
nokia_6303iclassic_ver1, nokia_6303classic_ver1, nokia_generic_series40_dp60, nokia_generic_series40_dp50, nokia_generic_series40_dp40, nokia_generic_series40_dp30, nokia_generic_series40_dp20, nokia_generic_series40, nokia_generic_series30, nokia_generic_series20, nokia_generic, generic
 
htc_buzz_ver1, generic_android_ver2_1, generic_android_ver2, generic_android_ver1_6, generic_android_ver1_5, generic_android, generic_xhtml, generic
 
kyocera_glide_ver1, opwv_v72_generic, opwv_v7_generic, opwv_v62_generic, opwv_v61_generic, opwv_v6_generic, upgui_generic, generic
 
nokia_5233_ver1, nokia_generic_series60_dp50, nokia_generic_series60_dp30_webkit, nokia_generic_series60_dp30, nokia_generic_series60_dp20, nokia_generic_series60, nokia_generic_series40, nokia_generic_series30, nokia_generic_series20, nokia_generic, generic
 
zte_sfr_r220_ver1, generic_xhtml, generic
 
htc_pb99400_ver1, generic_android_ver2_1, generic_android_ver2, generic_android_ver1_6, generic_android_ver1_5, generic_android, generic_xhtml, generic
 
lg_gt405_ver1, lg_generic_obigo_q7, lg_generic_obigo_q5, generic_xhtml, generic
Personal tools
Namespaces
Variants
Actions
WURFL DBAPI
Toolbox