Magellan Linux

  • Back to homepage
    • /[magellan-source]/trunk/pkgtools/mage2mysql.sh

    Annotation of /trunk/pkgtools/mage2mysql.sh

    Parent Directory Parent Directory | Revision Log Revision Log

    Revision 1331 - (hide annotations) (download) (as text)
    Tue May 31 17:44:01 2011 UTC (12 years, 11 months ago) by niro
    File MIME type: application/x-sh
    File size: 4808 byte(s) 
    -sync with current
    1 niro 802 #!/bin/sh
    2     # mage2mysql
    3    
    4     # mage functions
    5     source /home/tjoke/svn/alx/alx-src/trunk/tinyalxconfig-ng/functions/mysqlfunctions
    6     source /usr/lib/mage/mage4.functions.sh
    7     source /etc/mage.rc.global
    8     source /etc/mage.rc
    9    
    10     # sql settings
    11     SQL_USER=mage
    12     SQL_PASS=mage
    13     SQL_HOST=localhost
    14     SQL_DB=mage
    15 niro 806 SQL_TABLE_PACKAGES=mg_packages
    16     SQL_TABLE_CATEGORIES=mg_categories
    17 niro 802
    18     create_database()
    19     {
    20     # create categories table
    21 niro 804 mysqldo "CREATE TABLE IF NOT EXISTS ${SQL_TABLE_CATEGORIES} (
    22 niro 802 id int(10) NOT NULL auto_increment,
    23     pcat varchar(255) NOT NULL,
    24     PRIMARY KEY (id)
    25     )"
    26    
    27     # create packages table
    28 niro 804 mysqldo "CREATE TABLE IF NOT EXISTS ${SQL_TABLE_PACKAGES} (
    29 niro 802 id int(10) NOT NULL auto_increment,
    30     pname varchar(255) NOT NULL,
    31     pver varchar(255) NOT NULL,
    32     pbuild varchar(255) NOT NULL,
    33     pcat varchar(255) NOT NULL,
    34     state varchar(255) NOT NULL,
    35 niro 805 description text default NULL,
    36 niro 802 homepage varchar(255) default NULL,
    37     pkgtype varchar(255) default NULL,
    38 niro 807 depend text default NULL,
    39     sdepend text default NULL,
    40     provide text default NULL,
    41 niro 802 time datetime NOT NULL,
    42     flag int(1) NOT NULL default '1',
    43     PRIMARY KEY (id)
    44     )"
    45     }
    46    
    47     evaluate_categories()
    48     {
    49     local i
    50     local pcat
    51    
    52     # ${MAGEDIR} is known from mage.rc{,.global}
    53     for i in ${MAGEDIR}/*
    54     do
    55     pcat="${i##*/}"
    56    
    57     # exclude includes
    58     [[ ${pcat} = include ]] && continue
    59    
    60 niro 804 id=$(mysqldo "SELECT id FROM ${SQL_TABLE_CATEGORIES} WHERE pcat='${pcat}'")
    61 niro 802
    62     # only add if not found
    63     if [[ -z ${id} ]]
    64     then
    65 niro 804 mysqldo "INSERT INTO ${SQL_TABLE_CATEGORIES} ( pcat ) VALUES ( '${pcat}' )"
    66 niro 802 fi
    67     done
    68     }
    69    
    70     evaluate_magefile()
    71     {
    72     local i
    73     local MAGEFILE="$1"
    74     local PKGNAME
    75     local PCAT
    76     local PNAME
    77     local PVER
    78     local PBUILD
    79     local STATE
    80     local DESCRIPTION
    81     local HOMEPAGE
    82     local PKGTYPE
    83     local DEPEND
    84     local SDEPEND
    85     local PROVIDE
    86    
    87     # read needed variables within the magefile
    88     for i in PKGNAME STATE HOMEPAGE PKGTYPE DEPEND SDEPEND PROVIDE
    89     do
    90     eval "${i}='$(get_value_from_magefile ${i} ${MAGEFILE})'"
    91     done
    92    
    93     # the description may contain some escape characters like ' and "
    94     # which break the above loop
    95 niro 808 DESCRIPTION="$(get_value_from_magefile DESCRIPTION ${MAGEFILE} | sed "s:':\\\':g")"
    96 niro 802
    97     # get var from the name of the magefile
    98     PCAT="$(magename2pcat ${MAGEFILE})"
    99     PNAME="$(magename2pname ${MAGEFILE})"
    100     PVER="$(magename2pver ${MAGEFILE})"
    101     PBUILD="$(magename2pbuild ${MAGEFILE})"
    102    
    103     # remove >= etc from depend and sdepend
    104     DEPEND=$(echo ${DEPEND} | sed 's/[^a-zA-Z0-9]\{2\}\ //g')
    105     SDEPEND=$(echo ${SDEPEND} | sed 's/[^a-zA-Z0-9]\{2\}\ //g')
    106    
    107     # check if there is a pname for the same state
    108 niro 804 local id=$(mysqldo "SELECT id FROM ${SQL_TABLE_PACKAGES} WHERE pname='${PNAME}' AND state='${STATE}'")
    109 niro 802
    110     # get categorie id
    111 niro 804 local pcatid=$(mysqldo "SELECT id FROM ${SQL_TABLE_CATEGORIES} WHERE pcat='${PCAT}'")
    112 niro 802
    113     # get current time
    114     local time="$(date +%F\ %T)"
    115    
    116 niro 1331 #get last primary key !!!
    117    
    118 niro 802 # found, then update
    119     if [[ ! -z ${id} ]]
    120     then
    121 niro 804 mysqldo "UPDATE ${SQL_TABLE_PACKAGES} SET
    122 niro 802 pname='${PNAME}',
    123     pver='${PVER}',
    124     pbuild='${PBUILD}',
    125     pcat='${pcatid}',
    126     state='${STATE}',
    127     description='${DESCRIPTION}',
    128     homepage='${HOMEPAGE}',
    129     pkgtype='${PKGTYPE}',
    130     depend='${DEPEND}',
    131     sdepend='${SDEPEND}',
    132     provide='${PROVIDE}',
    133     time='${time}',
    134     flag='1'
    135     WHERE id='${id}'"
    136    
    137     else
    138     # else import to database as new
    139 niro 804 mysqldo "INSERT INTO ${SQL_TABLE_PACKAGES} (
    140 niro 1331 id,
    141 niro 802 pname,
    142     pver,
    143     pbuild,
    144     pcat,
    145     state,
    146     description,
    147     homepage,
    148     pkgtype,
    149     depend,
    150     sdepend,
    151     provide,
    152     time,
    153     flag
    154     )
    155     VALUES (
    156 niro 1331 '${id}',
    157 niro 802 '${PNAME}',
    158     '${PVER}',
    159     '${PBUILD}',
    160     '${pcatid}',
    161     '${STATE}',
    162     '${DESCRIPTION}',
    163     '${HOMEPAGE}',
    164     '${PKGTYPE}',
    165     '${DEPEND}',
    166     '${SDEPEND}',
    167     '${PROVIDE}',
    168     '${time}',
    169     '1'
    170 niro 1331 ) ON DUPLICATE KEY UPDATE ${SQL_TABLE_PACKAGES} SET
    171     pname='${PNAME}',
    172     pver='${PVER}',
    173     pbuild='${PBUILD}',
    174     pcat='${pcatid}',
    175     state='${STATE}',
    176     description='${DESCRIPTION}',
    177     homepage='${HOMEPAGE}',
    178     pkgtype='${PKGTYPE}',
    179     depend='${DEPEND}',
    180     sdepend='${SDEPEND}',
    181     provide='${PROVIDE}',
    182     time='${time}',
    183     flag='1'
    184     WHERE id='${id}'"
    185 niro 802 fi
    186     }
    187    
    188     reset_flags()
    189     {
    190     # set all flags to zero
    191 niro 804 mysqldo "UPDATE ${SQL_TABLE_PACKAGES} SET flag='0'"
    192 niro 802 }
    193    
    194     prune_old_packages()
    195     {
    196     # debug
    197     # echo "Debug: following ids are requested for deletion:"
    198     # mysqldo "SELECT id FROM packages WHERE flag='0'"
    199    
    200     # delete them
    201 niro 804 mysqldo "DELETE FROM ${SQL_TABLE_PACKAGES} WHERE flag='0'"
    202 niro 802 }
    203    
    204     echo "Processing Categories ..."
    205     evaluate_categories
    206    
    207     echo "Resetting Flags ..."
    208     reset_flags
    209    
    210     # all magefiles
    211     ALL_MAGEFILES="$(find ${MAGEDIR} -name \*.mage | sort)"
    212    
    213     for magefile in ${ALL_MAGEFILES}
    214     do
    215     echo "Processing Magefile ${magefile}"
    216     evaluate_magefile ${magefile}
    217     done
    218    
    219     echo "Pruning outdated Packages ..."
    220     prune_old_packages

    Properties

    Name Value
    svn:keywords Id