Python execute 예제들

예제 #1

파일: woniu-build.py 프로젝트: leemon9527/woniu-cmdb

def create_table(name,data):
    tmp = []
    for v in data:
        tmp.append('%s varchar(200)'%v['name'])
    sql = 'create table %s (id int not null auto_increment primary key,%s)' % (name,','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)

예제 #2

def create_table(name,data):
    tmp = []
    for v in data:
        tmp.append('%s varchar(200)'%v['name'])
    sql = 'create table %s (id int not null auto_increment primary key,%s) ENGINE=InnoDB DEFAULT CHARSET=utf8' % (name,','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)

예제 #3

파일: woniu-build.py 프로젝트: libingbing667/woniu-cmdb

def create_table(name, data):
    tmp = []
    for v in data:
        tmp.append('%s varchar(200)' % v['name'])
    sql = 'create table %s (id int not null auto_increment primary key,%s) type=myisam default charset utf8' % (
        name, ','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)

예제 #4

def del_table(name):
    sql = 'drop table if exists '+name
    print sql
    db.execute(sql)

예제 #5

    print sql
    db.execute(sql)
def create_table(name,data):
    tmp = []
    for v in data:
        tmp.append('%s varchar(200)'%v['name'])
    sql = 'create table %s (id int not null auto_increment primary key,%s) ENGINE=InnoDB DEFAULT CHARSET=utf8' % (name,','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)
def init_database(config):

    for c in config:
        name = c['name']
        del_table(name)
        create_table(name,c['data'])

if __name__ == '__main__':
    config = []
    for page in page_config['menu']:
        if 'sub' in page:
            for s in page['sub']:
                config.append(s)
        else:
            config.append(page)
    print config
    if len(sys.argv)>1 and sys.argv[1]=='init':
        init_database(config)
        db.execute('insert into user (username,password) values ("51reboot","51reboot")')
    gen_config(config)

예제 #6

파일: woniu-build.py 프로젝트: leemon9527/woniu-cmdb

def del_table(name):
    sql = 'drop table if exists '+name
    print sql
    db.execute(sql)

예제 #7

파일: woniu-build.py 프로젝트: leemon9527/woniu-cmdb

    sql = 'drop table if exists '+name
    print sql
    db.execute(sql)
def create_table(name,data):
    tmp = []
    for v in data:
        tmp.append('%s varchar(200)'%v['name'])
    sql = 'create table %s (id int not null auto_increment primary key,%s)' % (name,','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)
def init_database(config):

    for c in config:
        name = c['name']
        del_table(name)
        create_table(name,c['data'])

if __name__ == '__main__':
    config = []
    for page in page_config['menu']:
        if 'sub' in page:
            for s in page['sub']:
                config.append(s)
        else:
            config.append(page)
    print config
    if len(sys.argv)>1 and sys.argv[1]=='init':
        init_database(config)
        db.execute('insert into user (username,password) values ("admin","admin")')
    gen_config(config)

예제 #8

파일: woniu-build.py 프로젝트: 467754239/woniu-cmdb

    sql = 'drop table if exists '+name
    print sql
    db.execute(sql)
def create_table(name,data):
    tmp = []
    for v in data:
        tmp.append('%s varchar(200)'%v['name'])
    sql = 'create table %s (id int not null auto_increment primary key,%s) type=myisam default charset utf8' % (name,','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)
def init_database(config):

    for c in config:
        name = c['name']
        del_table(name)
        create_table(name,c['data'])

if __name__ == '__main__':
    config = []
    for page in page_config['menu']:
        if 'sub' in page:
            for s in page['sub']:
                config.append(s)
        else:
            config.append(page)
    print config
    if len(sys.argv)>1 and sys.argv[1]=='init':
        init_database(config)
        db.execute('insert into user (username,password) values ("51reboot","51reboot")')
    gen_config(config)

예제 #9

파일: woniu-build.py 프로젝트: totemofwolf/cmdb

    sql = 'create table %s (id int not null auto_increment primary key,%s)' % (
        name, ','.join(tmp))
    print sql
    db.execute(sql)
    print 'table %s is created' % (name)


def init_database(config):

    for c in config:
        name = c['name']
        del_table(name)
        create_table(name, c['data'])


if __name__ == '__main__':
    config = []
    for page in page_config['menu']:
        if 'sub' in page:
            for s in page['sub']:
                config.append(s)
        else:
            config.append(page)
    print config
    if len(sys.argv) > 1 and sys.argv[1] == 'init':
        init_database(config)
        db.execute(
            'insert into user (username,password) values ("qingteng","qingteng@qt2016")'
        )
    gen_config(config)