File: test_v_db_update.py

package info (click to toggle)
grass 8.4.2-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 277,040 kB
  • sloc: ansic: 460,798; python: 227,732; cpp: 42,026; sh: 11,262; makefile: 7,007; xml: 3,637; sql: 968; lex: 520; javascript: 484; yacc: 450; asm: 387; perl: 157; sed: 25; objc: 6; ruby: 4
file content (45 lines) | stat: -rw-r--r-- 1,147 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
"""
Created on Sun Jun 08 22:14:26 2018

@author: Sanjeet Bhatti
"""

from grass.gunittest.case import TestCase
from grass.gunittest.main import test
from grass.gunittest.gmodules import SimpleModule

from grass.script.core import run_command


class TestVDbUpdate(TestCase):
    """Test v.db.update script"""

    mapName = "mygeodetic_pts"

    @classmethod
    def setUpClass(cls):
        """Copy vect"""
        run_command("g.copy", vector="geodetic_pts,mygeodetic_pts")

    @classmethod
    def tearDownClass(cls):
        """Remove vector"""
        run_command("v.db.dropcolumn", map=cls.mapName, columns="zval")
        run_command("g.remove", flags="f", type="vector", name=cls.mapName)

    def test_update(self):
        """update value test"""
        run_command("v.db.addcolumn", map=self.mapName, column="zval double precision")

        module = SimpleModule(
            "v.db.update",
            map=self.mapName,
            column="zval",
            query_column="CAST(z_value AS double precision)",
            where="z_value <> 'N/A'",
        )
        self.assertModule(module)


if __name__ == "__main__":
    test()