def setUp(self): super(self.__class__, self).setUp() conn = DBConnection() conn.alias = 'test_connection' conn.engine = settings.DATABASES['default']['ENGINE'] conn.name = settings.DATABASES['default']['NAME'] conn.user = settings.DATABASES['default']['USER'] conn.password = settings.DATABASES['default']['PASSWORD'] conn.host = settings.DATABASES['default']['HOST'] conn.port = settings.DATABASES['default']['PORT'] conn.save() layer = DataBaseLayer() layer.db_connection = conn layer.name = 'tests_location_25831' layer.table = 'tests_location_25831' layer.srid = 25831 layer.pk_field = 'code' layer.geom_field = 'geometry' layer.anonymous_view = True layer.anonymous_add = True layer.anonymous_update = True layer.anonymous_delete = True layer.save() self.layer = layer self.locations = [] Location = create_dblayer_model(layer) self.Location = Location location = Location() location.code = 'C001' location.address = 'C/ Major 1, Salt' location.geometry = 'POINT(482984.669856201 4647181.21886241)' location.save() self.locations.append(location)
def setUp(self): super(self.__class__, self).setUp() settings.LAYERSERVER_PAGE_SIZE = 5 settings.LAYERSERVER_MAX_PAGE_SIZE = 10 conn = DBConnection() conn.alias = 'test' conn.engine = settings.DATABASES['default']['ENGINE'] conn.name = settings.DATABASES['default']['NAME'] conn.user = settings.DATABASES['default']['USER'] conn.password = settings.DATABASES['default']['PASSWORD'] conn.host = settings.DATABASES['default']['HOST'] conn.port = settings.DATABASES['default']['PORT'] conn.save() layer = DataBaseLayer() layer.db_connection = conn layer.name = 'tests_location_25831' layer.table = 'tests_location_25831' layer.srid = 25831 layer.pk_field = 'code' layer.geom_field = 'geometry' layer.anonymous_view = True layer.anonymous_add = True layer.anonymous_update = True layer.anonymous_delete = True layer.save() self.layer = layer # X,Y,lng,lat, address data = [ (485984.399179716, 4646678.69635524, 2.8308397, 41.9719769, 'Carrer de Montori, 6, Girona'), (486004.280534943, 4646672.62826433, 2.8310798, 41.9719226, 'Carrer de Montori, 12, Girona'), (486015.159965428, 4646685.57498505, 2.8312108, 41.9720394, 'Carrer de Montori, 17, Girona'), (485981.063816979, 4646697.33357378, 2.830799, 41.9721447, 'Carrer del Castellet, 1, Girona'), (486025.905078693, 4646718.69591949, 2.8313397, 41.9723379, 'Carrer del Turó Rodó, 24, Girona'), (485976.301483811, 4646685.65164834, 2.8307418, 41.9720394, 'Carrer de Montori, 7, Girona'), (486036.873361096, 4646679.99190294, 2.831473, 41.9719895, 'Carrer de Montori, 23, Girona'), (485991.335509501, 4646704.60788712, 2.8309228, 41.9722104, 'Carrer de Sant Grau, 3, Girona'), (485995.924639975, 4646687.31164811, 2.8309786, 41.9720547, 'Carrer de Montori, 9, Girona'), (485971.231262542, 4646664.92148798, 2.8306811, 41.9718526, 'Carrer de Montori, 2, Girona'), (485997.86065962, 4646673.30709788, 2.8310023, 41.9719286, 'Carrer de Montori, 10, Girona'), (485991.234154363, 4646674.24171126, 2.8309223, 41.9719369, 'Carrer de Montori, 8, Girona'), (486038.970629009, 4646714.22905804, 2.8314975, 41.9722979, 'Carrer del Turó Rodó, 27, Girona'), (486029.087115901, 4646714.71482487, 2.8313782, 41.9723021, 'Carrer del Turó Rodó, 29, Girona'), (486009.346425706, 4646699.62048077, 2.8311403, 41.9721658, 'Carrer de Montori, 13, Girona'), (486032.850809002, 4646682.10936383, 2.8314244, 41.9720085, 'Carrer de Montori, 21, Girona'), (486009.503670912, 4646720.54909947, 2.8311417, 41.9723543, 'Carrer de Sant Grau, 7, Girona'), (485997.896958484, 4646700.10937757, 2.8310021, 41.97217, 'Carrer de Sant Grau, 4, Girona'), (486011.821936575, 4646698.69406302, 2.8311702, 41.9721575, 'Carrer de Montori, 11, Girona'), (486023.688015233, 4646682.56041124, 2.8313138, 41.9720124, 'Carrer de Montori, 19, Girona'), (486003.516233289, 4646684.19897165, 2.8310703, 41.9720268, 'Carrer de Montori, 15, Girona'), (485969.753316113, 4646680.10204534, 2.8306629, 41.9719893, 'Carrer de Montori, 5, Girona'), (485976.833113544, 4646673.75941402, 2.8307485, 41.9719323, 'Carrer de Montori, 4, Girona'), (485981.073650482, 4646714.89831056, 2.8307987, 41.9723029, 'Carrer del Castellet, 4, Girona'), (485984.756663944, 4646704.48763906, 2.8308434, 41.9722092, 'Carrer del Castellet, 2, Girona'), (485995.585985817, 4646708.84080015, 2.830974, 41.9722486, 'Carrer de Sant Grau, 5, Girona'), (486000.922999553, 4646713.66002545, 2.8310383, 41.9722921, 'Carrer de Sant Grau, 5A, Girona'), (486013.232808288, 4646666.24866927, 2.831188, 41.9718653, 'Carrer de Montori, 14, Girona'), (485975.306531153, 4646710.45744782, 2.8307292, 41.9722628, 'Carrer del Castellet, 3, Girona'), ] self.locations = [] Location = create_dblayer_model(layer) self.Location = Location for i, item in enumerate(data): location = Location() location.code = 'B%s' % i location.address = item[4] location.geometry = 'POINT(%s %s)' % (item[0], item[1]) location.save() self.locations.append(location)