예제 #1
0
def insert_kingdom_resource_detail(curs,
                                   section_id,
                                   bp=None,
                                   lot=None,
                                   kingdom=None,
                                   discount=None,
                                   magic_items=None,
                                   settlement=None,
                                   special=None,
                                   limit=None,
                                   upgrade_from=None,
                                   upgrade_to=None,
                                   **kwargs):
    values = [
        section_id, bp, lot, kingdom, discount, magic_items, settlement,
        special, limit, upgrade_from, upgrade_to
    ]
    test_args(kwargs)
    sql = '\n'.join([
        "INSERT INTO kingdom_resource_details",
        " (section_id, bp, lot, kingdom, discount, magic_items, settlement,"
        " special, resource_limit, upgrade_from, upgrade_to)", " VALUES",
        " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    ])
    curs.execute(sql, values)
예제 #2
0
def insert_animal_companion_detail(curs,
                                   section_id,
                                   ac=None,
                                   attack=None,
                                   cmd=None,
                                   ability_scores=None,
                                   special_abilities=None,
                                   special_qualities=None,
                                   special_attacks=None,
                                   size=None,
                                   speed=None,
                                   bonus_feat=None,
                                   level=None,
                                   **kwargs):
    values = [
        section_id, ac, attack, cmd, ability_scores, special_abilities,
        special_qualities, special_attacks, size, speed, bonus_feat, level
    ]
    test_args(kwargs)
    sql = '\n'.join([
        "INSERT INTO animal_companion_details",
        " (section_id, ac, attack, cmd, ability_scores, special_abilities, "
        "  special_qualities, special_attacks, size, speed, bonus_feat, level)",
        " VALUES", " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    ])
    curs.execute(sql, values)
예제 #3
0
def insert_spell_detail(curs, section_id, school=None, subschool_text=None,
		descriptor_text=None, level_text=None, domain_text=None,
		component_text=None, casting_time=None, preparation_time=None,
		range=None, duration=None, saving_throw=None, spell_resistance=None,
		as_spell_id=None, **kwargs):
	values = [section_id, school, subschool_text, descriptor_text, level_text,
		domain_text, component_text, casting_time, preparation_time, range,
		duration, saving_throw, spell_resistance, as_spell_id]
	testa = kwargs.copy()
	if testa.has_key('spell_detail_id'):
		del testa['spell_detail_id']
	if testa.has_key('level'):
		del testa['level']
	if testa.has_key('levels'):
		del testa['levels']
	if testa.has_key('subschool'):
		del testa['subschool']
	if testa.has_key('descriptor'):
		del testa['descriptor']
	if testa.has_key('components'):
		del testa['components']
	if testa.has_key('effects'):
		del testa['effects']
	test_args(testa)
	sql = '\n'.join([
		"INSERT INTO spell_details",
		" (section_id, school, subschool_text, descriptor_text, level_text,",
		"  domain_text, component_text, casting_time, preparation_time, range,"
		"  duration, saving_throw, spell_resistance, as_spell_id)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #4
0
def insert_mythic_spell_detail(curs, section_id, spell_source=None, **kwargs):
	values = [section_id, spell_source]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO mythic_spell_details",
		" (section_id, spell_source)",
		" VALUES",
		" (?, ?)"])
	curs.execute(sql, values)
예제 #5
0
def insert_mythic_spell_detail(curs, section_id, spell_source=None, **kwargs):
	values = [section_id, spell_source]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO mythic_spell_details",
		" (section_id, spell_source)",
		" VALUES",
		" (?, ?)"])
	curs.execute(sql, values)
예제 #6
0
def insert_animal_companion_detail(curs, section_id, ac=None, attack=None, ability_scores=None, special_qualities=None, special_attacks=None, size=None, speed=None, level=None, **kwargs):
	values = [section_id, ac, attack, ability_scores, special_qualities, special_attacks, size, speed, level]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO animal_companion_details",
		" (section_id, ac, attack, ability_scores, special_qualities, special_attacks, size, speed, level)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #7
0
def insert_spell_detail(
    curs,
    section_id,
    school=None,
    subschool=None,
    descriptor_text=None,
    level_text=None,
    casting_time=None,
    preparation_time=None,
    range=None,
    duration=None,
    saving_throw=None,
    spell_resistance=None,
    as_spell_id=None,
    **kwargs
):
    values = [
        section_id,
        school,
        subschool,
        descriptor_text,
        level_text,
        casting_time,
        preparation_time,
        range,
        duration,
        saving_throw,
        spell_resistance,
        as_spell_id,
    ]
    testa = kwargs.copy()
    if testa.has_key("spell_detail_id"):
        del testa["spell_detail_id"]
    if testa.has_key("level"):
        del testa["level"]
    if testa.has_key("levels"):
        del testa["levels"]
    if testa.has_key("descriptor"):
        del testa["descriptor"]
    if testa.has_key("components"):
        del testa["components"]
    if testa.has_key("effects"):
        del testa["effects"]
    test_args(testa)
    sql = "\n".join(
        [
            "INSERT INTO spell_details",
            " (section_id, school, subschool, descriptor_text, level_text, casting_time, preparation_time, range, duration, saving_throw, spell_resistance, as_spell_id)",
            " VALUES",
            " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
        ]
    )
    curs.execute(sql, values)
예제 #8
0
def insert_resource_detail(curs, section_id, benefit=None, create=None,
		earnings=None, rooms=None, size=None, skills=None, teams=None,
		time=None, upgrade_from=None, upgrade_to=None, wage=None, **kwargs):
	values = [section_id, benefit, create, earnings, rooms, size, skills,
		teams, time, upgrade_from, upgrade_to, wage]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO resource_details",
		" (section_id, benefit, resource_create, earnings, rooms, size, skills,"
		" teams, time, upgrade_from, upgrade_to, wage)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
def insert_kingdom_resource_detail(curs, section_id, bp=None, lot=None,
		kingdom=None, discount=None, magic_items=None, settlement=None,
		special=None, limit=None, upgrade_from=None, upgrade_to=None, **kwargs):
	values = [section_id, bp, lot, kingdom, discount, magic_items,
		settlement, special, limit, upgrade_from, upgrade_to]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO kingdom_resource_details",
		" (section_id, bp, lot, kingdom, discount, magic_items, settlement,"
		" special, resource_limit, upgrade_from, upgrade_to)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #10
0
def insert_army_detail(curs, section_id, xp=None, creature_type=None,
		alignment=None, size=None, hp=None, acr=None, dv=None,
		om=None, special=None, speed=None, consumption=None, tactics=None,
		resources=None, note=None, **kwargs):
	values = [section_id, xp, creature_type, alignment, size, hp, acr, dv, om,
		special, speed, consumption, tactics, resources, note]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO army_details",
		" (section_id, xp, creature_type, alignment, size, hp, acr, dv, om,"
		" special, speed, consumption, tactics, resources, note)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #11
0
def insert_vehicle_detail(curs, section_id, size=None, vehicle_type=None, squares=None, cost=None, ac=None,
		hardness=None, hp=None, base_save=None, maximum_speed=None, acceleration=None, cmb=None, cmd=None,
		ramming_damage=None, propulsion=None, driving_check=None, forward_facing=None, driving_device=None,
		driving_space=None, decks=None, weapons=None, crew=None, passengers=None, **kwargs):
	values = [section_id, size, vehicle_type, squares, cost, ac, hardness, hp, base_save, maximum_speed, acceleration, cmb, cmd, ramming_damage, propulsion, driving_check, forward_facing, driving_device, driving_space, decks, weapons, crew, passengers]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO vehicle_details",
		" (section_id, size, vehicle_type, squares, cost, ac, hardness, hp, base_save, maximum_speed,",
		"  acceleration, cmb, cmd, ramming_damage, propulsion, driving_check, forward_facing,",
		"  driving_device, driving_space, decks, weapons, crew, passengers)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,",
		"  ?, ?, ?, ?, ?, ?, ?,",
		"  ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #12
0
def insert_settlement_detail(curs, section_id, alignment=None, settlement_type=None, size=None,
		corruption=None, crime=None, economy=None, law=None, lore=None, society=None, qualities=None,
		danger=None, disadvantages=None, government=None, population=None, base_value=None,
		purchase_limit=None, spellcasting=None, minor_items=None, medium_items=None,
		major_items=None, **kwargs):
	values = [section_id, alignment, settlement_type, size, corruption, crime, economy, law, lore,
		society, qualities, danger, disadvantages, government, population, base_value, purchase_limit,
		spellcasting, minor_items, medium_items, major_items]
	test_args(kwargs)
	sql = '\n'.join([
		"INSERT INTO settlement_details",
		" (section_id, alignment, settlement_type, size, corruption, crime, economy, law, lore, society,",
		"  qualities, danger, disadvantages, government, population, base_value, purchase_limit,",
		"  spellcasting, minor_items, medium_items, major_items)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #13
0
def insert_spell_detail(curs,
                        section_id,
                        school=None,
                        subschool_text=None,
                        descriptor_text=None,
                        level_text=None,
                        domain_text=None,
                        component_text=None,
                        casting_time=None,
                        preparation_time=None,
                        range=None,
                        duration=None,
                        saving_throw=None,
                        spell_resistance=None,
                        as_spell_id=None,
                        **kwargs):
    values = [
        section_id, school, subschool_text, descriptor_text, level_text,
        domain_text, component_text, casting_time, preparation_time, range,
        duration, saving_throw, spell_resistance, as_spell_id
    ]
    testa = kwargs.copy()
    if testa.has_key('spell_detail_id'):
        del testa['spell_detail_id']
    if testa.has_key('level'):
        del testa['level']
    if testa.has_key('levels'):
        del testa['levels']
    if testa.has_key('subschool'):
        del testa['subschool']
    if testa.has_key('descriptor'):
        del testa['descriptor']
    if testa.has_key('components'):
        del testa['components']
    if testa.has_key('effects'):
        del testa['effects']
    test_args(testa)
    sql = '\n'.join([
        "INSERT INTO spell_details",
        " (section_id, school, subschool_text, descriptor_text, level_text,",
        "  domain_text, component_text, casting_time, preparation_time, range,"
        "  duration, saving_throw, spell_resistance, as_spell_id)", " VALUES",
        " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    ])
    curs.execute(sql, values)
예제 #14
0
def insert_creature_detail(curs, section_id,
		sex=None, super_race=None, level=None, cr=None, mr=None, xp=None, alignment=None, size=None, creature_type=None,
		creature_subtype=None, init=None, senses=None, aura=None,
		ac=None, hp=None, fortitude=None, reflex=None, will=None, resist=None, defensive_abilities=None,
		dr=None, immune=None, sr=None, weaknesses=None,
		speed=None, melee=None, ranged=None, space=None, reach=None, special_attacks=None,
		strength=None, dexterity=None, constitution=None, intelligence=None, wisdom=None, charisma=None,
		base_attack=None, cmb=None, cmd=None, feats=None, skills=None, racial_modifiers=None, languages=None,
		special_qualities=None, gear=None, combat_gear=None, other_gear=None, boon=None,
		environment=None, organization=None, treasure=None,
		hit_dice=None, natural_armor=None, breath_weapon=None, **kwargs):
	values = [section_id,
		sex, super_race, level, cr, mr, xp, alignment, size, creature_type, creature_subtype, init, senses, aura,
		ac, hp, fortitude, reflex, will, resist, defensive_abilities, dr, immune, sr, weaknesses,
		speed, melee, ranged, space, reach, special_attacks,
		strength, dexterity, constitution, intelligence, wisdom, charisma, base_attack, cmb, cmd,
		feats, skills, racial_modifiers, languages,
		special_qualities, gear, combat_gear, other_gear, boon,
		environment, organization, treasure,
		hit_dice, natural_armor, breath_weapon]
	targs = kwargs.copy()
	if targs.has_key('spells'):
		del targs['spells']
	test_args(targs)

	sql = '\n'.join([
		"INSERT INTO creature_details",
		" (section_id,",
		"  sex, super_race, level, cr, mr, xp, alignment, size, creature_type, creature_subtype, init, senses, aura,",
		"  ac, hp, fortitude, reflex, will, resist, defensive_abilities, dr, immune, sr, weaknesses,",
		"  speed, melee, ranged, space, reach, special_attacks,",
		"  strength, dexterity, constitution, intelligence, wisdom, charisma,",
		"  base_attack, cmb, cmd, feats, skills, racial_modifiers, languages,",
		"  special_qualities, gear, combat_gear, other_gear, boon,",
		"  environment, organization, treasure,",
		"  hit_dice, natural_armor, breath_weapon)",
		" VALUES",
		" (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,"
		"  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,",
		"  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,",
		"  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,",
		"  ?, ?, ?, ?, ?, ?, ?)"])
	curs.execute(sql, values)
예제 #15
0
def insert_creature_detail(curs,
                           section_id,
                           sex=None,
                           super_race=None,
                           level=None,
                           cr=None,
                           mr=None,
                           xp=None,
                           alignment=None,
                           size=None,
                           creature_type=None,
                           creature_subtype=None,
                           init=None,
                           senses=None,
                           aura=None,
                           ac=None,
                           hp=None,
                           fortitude=None,
                           reflex=None,
                           will=None,
                           resist=None,
                           defensive_abilities=None,
                           dr=None,
                           immune=None,
                           sr=None,
                           weaknesses=None,
                           speed=None,
                           melee=None,
                           ranged=None,
                           space=None,
                           reach=None,
                           special_attacks=None,
                           strength=None,
                           dexterity=None,
                           constitution=None,
                           intelligence=None,
                           wisdom=None,
                           charisma=None,
                           base_attack=None,
                           cmb=None,
                           cmd=None,
                           feats=None,
                           skills=None,
                           racial_modifiers=None,
                           languages=None,
                           special_qualities=None,
                           gear=None,
                           combat_gear=None,
                           other_gear=None,
                           boon=None,
                           environment=None,
                           organization=None,
                           treasure=None,
                           hit_dice=None,
                           natural_armor=None,
                           breath_weapon=None,
                           **kwargs):
    values = [
        section_id, sex, super_race, level, cr, mr, xp, alignment, size,
        creature_type, creature_subtype, init, senses, aura, ac, hp, fortitude,
        reflex, will, resist, defensive_abilities, dr, immune, sr, weaknesses,
        speed, melee, ranged, space, reach, special_attacks, strength,
        dexterity, constitution, intelligence, wisdom, charisma, base_attack,
        cmb, cmd, feats, skills, racial_modifiers, languages,
        special_qualities, gear, combat_gear, other_gear, boon, environment,
        organization, treasure, hit_dice, natural_armor, breath_weapon
    ]
    targs = kwargs.copy()
    if targs.has_key('spells'):
        del targs['spells']
    test_args(targs)

    sql = '\n'.join([
        "INSERT INTO creature_details", " (section_id,",
        "  sex, super_race, level, cr, mr, xp, alignment, size, creature_type, creature_subtype, init, senses, aura,",
        "  ac, hp, fortitude, reflex, will, resist, defensive_abilities, dr, immune, sr, weaknesses,",
        "  speed, melee, ranged, space, reach, special_attacks,",
        "  strength, dexterity, constitution, intelligence, wisdom, charisma,",
        "  base_attack, cmb, cmd, feats, skills, racial_modifiers, languages,",
        "  special_qualities, gear, combat_gear, other_gear, boon,",
        "  environment, organization, treasure,",
        "  hit_dice, natural_armor, breath_weapon)", " VALUES",
        " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,"
        "  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,",
        "  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,",
        "  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,", "  ?, ?, ?, ?, ?, ?, ?)"
    ])
    curs.execute(sql, values)