Example #1
0
def test_remove_vehicle_group_members(pg_conn, vhc_a1, vhc_a2):
    create_vehicle_group(pg_conn, 'group-1')
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a1)
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a2)
    remove_vehicle_group_members(pg_conn, 'group-1', (vhc_a1, ))
    rs = retrieve_vehicle_group_members(pg_conn, 'group-1')
    assert rs == [{'vehicle_id': vhc_a2, 'plate': 'AAA9999'}]
Example #2
0
def test_delete_vehicle_groups_by_group_names(pg_conn):
    create_vehicle_group(pg_conn, 'group-1')
    rs = retrieve_all_vehicle_groups(pg_conn)
    assert len(rs) == 1
    delete_vehicle_groups_by_group_names(pg_conn, ('group-1', ))
    rs = retrieve_all_vehicle_groups(pg_conn)
    assert rs == []
Example #3
0
def test_retrieve_vehicle_groups_by_vehicle_id(pg_conn, vhc_a1):
    create_vehicle_group(pg_conn, 'group-1')
    create_vehicle_group(pg_conn, 'group-2')
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a1)
    add_vehicle_group_member(pg_conn, 'group-2', vhc_a1)
    rs = retrieve_vehicle_groups_by_vehicle_id(pg_conn, vhc_a1)
    assert rs == [{'group_name': 'group-1'}, {'group_name': 'group-2'}]
Example #4
0
def test_retrieve_all_vehicle_groups(pg_conn):
    create_vehicle_group(pg_conn, 'group-1')
    create_vehicle_group(pg_conn, 'group-2')
    rs = retrieve_all_vehicle_groups(pg_conn)
    assert len(rs) == 2
    assert rs[0]['group_name'] == 'group-1'
    assert rs[1]['group_name'] == 'group-2'
Example #5
0
def test_retrieve_all_vehicle_groups(pg_conn):
    dql_binds.create_vehicle_group(pg_conn, 'group-2')
    dql_binds.create_vehicle_group(pg_conn, 'group-1')
    records = dql_binds.retrieve_all_vehicle_groups(pg_conn)
    assert (len(records) == 2)
    assert (records[0]['group_name'] == 'group-1')
    assert (records[1]['group_name'] == 'group-2')
Example #6
0
def test_add_vehicle_group_member(pg_conn):
    created_group_name = dql_binds.create_vehicle_group(pg_conn,
                                                        group_name='group-1')
    created_vehicle_id = dql_binds.create_vehicle(pg_conn, 'CCC1010')
    result = dql_binds.add_vehicle_group_member(pg_conn, created_group_name,
                                                created_vehicle_id)
    assert result is None
Example #7
0
def test_remove_vehicle_from_vehicle_groups(pg_conn):
    created_group_name = dql_binds.create_vehicle_group(pg_conn,
                                                        group_name='group-1')
    created_vehicle_id = dql_binds.create_vehicle(pg_conn, 'CCC1010')
    dql_binds.add_vehicle_group_member(pg_conn, created_group_name,
                                       created_vehicle_id)
    result = dql_binds.remove_vehicle_from_vehicle_groups(
        pg_conn, created_vehicle_id, (created_group_name, ))
    assert result is None
Example #8
0
def test_retrieve_vehicle_groups_by_vehicle_id(pg_conn):
    created_group_name = dql_binds.create_vehicle_group(pg_conn,
                                                        group_name='group-1')
    created_vehicle_id = dql_binds.create_vehicle(pg_conn, 'CCC1010')
    dql_binds.add_vehicle_group_member(pg_conn, created_group_name,
                                       created_vehicle_id)
    records = dql_binds.retrieve_vehicle_groups_by_vehicle_id(
        pg_conn, created_vehicle_id)
    assert len(records) == 1
    assert records[0]['group_name'] == 'group-1'
Example #9
0
def test_remove_vehicle_from_vehicle_groups(pg_conn, vhc_a1, vhc_a2):
    create_vehicle_group(pg_conn, 'group-1')
    create_vehicle_group(pg_conn, 'group-2')
    create_vehicle_group(pg_conn, 'group-3')
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a1)
    add_vehicle_group_member(pg_conn, 'group-2', vhc_a1)
    add_vehicle_group_member(pg_conn, 'group-3', vhc_a1)
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a2)
    remove_vehicle_from_vehicle_groups(pg_conn, vhc_a1, ('group-1', 'group-3'))
    rs = retrieve_vehicle_groups_by_vehicle_id(pg_conn, vhc_a1)
    assert rs == [{'group_name': 'group-2'}]
    rs = retrieve_vehicle_groups_by_vehicle_id(pg_conn, vhc_a2)
    assert rs == [{'group_name': 'group-1'}]
Example #10
0
def vhcgrp_b(pg_conn):
    return create_vehicle_group(pg_conn, 'vhcgrp_b')
Example #11
0
def test_retrieve_vehicle_group_members(pg_conn, vhc_a1):
    create_vehicle_group(pg_conn, 'group-1')
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a1)
    rs = retrieve_vehicle_group_members(pg_conn, 'group-1')
    assert rs == [{'vehicle_id': vhc_a1, 'plate': 'GGG0000'}]
Example #12
0
def test_add_vehicle_group_member(pg_conn, vhc_a1):
    create_vehicle_group(pg_conn, 'group-1')
    add_vehicle_group_member(pg_conn, 'group-1', vhc_a1)
Example #13
0
def test_delete_vehicle_groups_by_group_names(pg_conn):
    created_name = dql_binds.create_vehicle_group(pg_conn, 'group-1')
    result = dql_binds.delete_vehicle_groups_by_group_names(
        pg_conn, (created_name, ))
    assert result is None
Example #14
0
def test_update_vehicle_group(pg_conn):
    created_name = dql_binds.create_vehicle_group(pg_conn, 'group-1')
    result = dql_binds.update_vehicle_group(pg_conn,
                                            group_name=created_name,
                                            new_group_name='group-2')
    assert result is None
Example #15
0
def test_update_vehicle_group(pg_conn):
    create_vehicle_group(pg_conn, 'group-1')
    update_vehicle_group(pg_conn, 'group-1', 'group-a')
    rs = retrieve_all_vehicle_groups(pg_conn)
    assert rs[0]['group_name'] == 'group-a'
Example #16
0
def test_create_vehicle_group(pg_conn):
    created_name = dql_binds.create_vehicle_group(pg_conn,
                                                  group_name='group-1')
    assert (isinstance(created_name, str))
Example #17
0
def test_create_vehicle_group(pg_conn):
    create_vehicle_group(pg_conn, 'group-1')