base.py 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946
  1. """!@package grass.temporal
  2. @brief GRASS Python scripting module (temporal GIS functions)
  3. Temporal GIS base classes to be used in other
  4. Python temporal gis packages.
  5. This packages includes all base classes to store basic information
  6. like id, name, mapset creation and modification time as well as sql
  7. serialization and de-serialization and the sql database interface.
  8. Usage:
  9. @code
  10. >>> import grass.temporal as tgis
  11. >>> rbase = tgis.RasterBase(ident="soil@PERMANENT")
  12. >>> vbase = tgis.VectorBase(ident="soil:1@PERMANENT")
  13. >>> r3base = tgis.Raster3DBase(ident="soil@PERMANENT")
  14. >>> strdsbase = tgis.STRDSBase(ident="soil@PERMANENT")
  15. >>> stvdsbase = tgis.STVDSBase(ident="soil@PERMANENT")
  16. >>> str3dsbase = tgis.STR3DSBase(ident="soil@PERMANENT")
  17. @endcode
  18. (C) 2011-2012 by the GRASS Development Team
  19. This program is free software under the GNU General Public
  20. License (>=v2). Read the file COPYING that comes with GRASS
  21. for details.
  22. @author Soeren Gebbert
  23. """
  24. from datetime import datetime, date, time, timedelta
  25. from core import *
  26. ###############################################################################
  27. class DictSQLSerializer(object):
  28. def __init__(self):
  29. self.D = {}
  30. self.dbif = SQLDatabaseInterfaceConnection()
  31. def serialize(self, type, table, where=None):
  32. """!Convert the internal dictionary into a string of semicolon
  33. separated SQL statements The keys are the column names and
  34. the values are the row entries
  35. Usage:
  36. \code
  37. >>> t = DictSQLSerializer()
  38. >>> t.D["id"] = "soil@PERMANENT"
  39. >>> t.D["name"] = "soil"
  40. >>> t.D["mapset"] = "PERMANENT"
  41. >>> t.D["creator"] = "soeren"
  42. >>> t.D["creation_time"] = datetime(2001,1,1)
  43. >>> t.D["modification_time"] = datetime(2001,1,1)
  44. >>> t.serialize(type="SELECT", table="raster_base")
  45. ('SELECT name , creator , creation_time , modification_time , mapset , id FROM raster_base ;\\n', ())
  46. >>> t.serialize(type="INSERT", table="raster_base")
  47. ('INSERT INTO raster_base ( name ,creator ,creation_time ,modification_time ,mapset ,id ) VALUES (? ,? ,? ,? ,? ,?) ;\\n', ('soil', 'soeren', datetime.datetime(2001, 1, 1, 0, 0), datetime.datetime(2001, 1, 1, 0, 0), 'PERMANENT', 'soil@PERMANENT'))
  48. >>> t.serialize(type="UPDATE", table="raster_base")
  49. ('UPDATE raster_base SET name = ? ,creator = ? ,creation_time = ? ,modification_time = ? ,mapset = ? ,id = ? ;\\n', ('soil', 'soeren', datetime.datetime(2001, 1, 1, 0, 0), datetime.datetime(2001, 1, 1, 0, 0), 'PERMANENT', 'soil@PERMANENT'))
  50. >>> t.serialize(type="UPDATE ALL", table="raster_base")
  51. ('UPDATE raster_base SET name = ? ,creator = ? ,creation_time = ? ,modification_time = ? ,mapset = ? ,id = ? ;\\n', ('soil', 'soeren', datetime.datetime(2001, 1, 1, 0, 0), datetime.datetime(2001, 1, 1, 0, 0), 'PERMANENT', 'soil@PERMANENT'))
  52. @type must be SELECT. INSERT, UPDATE
  53. @table The name of the table to select, insert or update
  54. @where The optional where statement
  55. @return a tuple containing the SQL string and the arguments
  56. \endcode
  57. """
  58. sql = ""
  59. args = []
  60. # Create ordered select statement
  61. if type == "SELECT":
  62. sql += 'SELECT '
  63. count = 0
  64. for key in self.D.keys():
  65. if count == 0:
  66. sql += ' %s ' % key
  67. else:
  68. sql += ' , %s ' % key
  69. count += 1
  70. sql += ' FROM ' + table + ' '
  71. if where:
  72. sql += where
  73. sql += ";\n"
  74. # Create insert statement
  75. if type == "INSERT":
  76. count = 0
  77. sql += 'INSERT INTO ' + table + ' ('
  78. for key in self.D.keys():
  79. if count == 0:
  80. sql += ' %s ' % key
  81. else:
  82. sql += ' ,%s ' % key
  83. count += 1
  84. count = 0
  85. sql += ') VALUES ('
  86. for key in self.D.keys():
  87. if count == 0:
  88. if self.dbif.dbmi.paramstyle == "qmark":
  89. sql += '?'
  90. else:
  91. sql += '%s'
  92. else:
  93. if self.dbif.dbmi.paramstyle == "qmark":
  94. sql += ' ,?'
  95. else:
  96. sql += ' ,%s'
  97. count += 1
  98. args.append(self.D[key])
  99. sql += ') '
  100. if where:
  101. sql += where
  102. sql += ";\n"
  103. # Create update statement for existing entries
  104. if type == "UPDATE":
  105. count = 0
  106. sql += 'UPDATE ' + table + ' SET '
  107. for key in self.D.keys():
  108. # Update only entries which are not None
  109. if self.D[key] is not None:
  110. if count == 0:
  111. if self.dbif.dbmi.paramstyle == "qmark":
  112. sql += ' %s = ? ' % key
  113. else:
  114. sql += ' %s ' % key
  115. sql += '= %s '
  116. else:
  117. if self.dbif.dbmi.paramstyle == "qmark":
  118. sql += ' ,%s = ? ' % key
  119. else:
  120. sql += ' ,%s ' % key
  121. sql += '= %s '
  122. count += 1
  123. args.append(self.D[key])
  124. if where:
  125. sql += where
  126. sql += ";\n"
  127. # Create update statement for all entries
  128. if type == "UPDATE ALL":
  129. count = 0
  130. sql += 'UPDATE ' + table + ' SET '
  131. for key in self.D.keys():
  132. if count == 0:
  133. if self.dbif.dbmi.paramstyle == "qmark":
  134. sql += ' %s = ? ' % key
  135. else:
  136. sql += ' %s ' % key
  137. sql += '= %s '
  138. else:
  139. if self.dbif.dbmi.paramstyle == "qmark":
  140. sql += ' ,%s = ? ' % key
  141. else:
  142. sql += ' ,%s ' % key
  143. sql += '= %s '
  144. count += 1
  145. args.append(self.D[key])
  146. if where:
  147. sql += where
  148. sql += ";\n"
  149. return sql, tuple(args)
  150. def deserialize(self, row):
  151. """!Convert the content of the dbmi dictionary like row into the
  152. internal dictionary
  153. @param row: The dictionary like row to store in the internal dict
  154. """
  155. self.D = {}
  156. for key in row.keys():
  157. self.D[key] = row[key]
  158. def clear(self):
  159. """!Initialize the internal storage"""
  160. self.D = {}
  161. def print_self(self):
  162. """!Print the content of the internal dictionary to stdout
  163. """
  164. print self.D
  165. ###############################################################################
  166. class SQLDatabaseInterface(DictSQLSerializer):
  167. """!This class represents the SQL database interface
  168. Functions to insert, select and update the internal
  169. structure of this class in the temporal database are implemented.
  170. This is the base class for raster, raster3d, vector and
  171. space time datasets data management classes:
  172. * Identification information (base)
  173. * Spatial extent
  174. * Temporal extent
  175. * Metadata
  176. Usage:
  177. \code
  178. >>> t = SQLDatabaseInterface("raster", "soil@PERMANENT")
  179. >>> t.D["name"] = "soil"
  180. >>> t.D["mapset"] = "PERMANENT"
  181. >>> t.D["creator"] = "soeren"
  182. >>> t.D["creation_time"] = datetime(2001,1,1)
  183. >>> t.get_delete_statement()
  184. "DELETE FROM raster WHERE id = 'soil@PERMANENT';\\n"
  185. >>> t.get_is_in_db_statement()
  186. "SELECT id FROM raster WHERE id = 'soil@PERMANENT';\\n"
  187. >>> t.get_select_statement()
  188. ("SELECT creation_time , mapset , name , creator FROM raster WHERE id = 'soil@PERMANENT';\\n", ())
  189. >>> t.get_select_statement_mogrified()
  190. "SELECT creation_time , mapset , name , creator FROM raster WHERE id = 'soil@PERMANENT';\\n"
  191. >>> t.get_insert_statement()
  192. ('INSERT INTO raster ( creation_time ,mapset ,name ,creator ) VALUES (? ,? ,? ,?) ;\\n', (datetime.datetime(2001, 1, 1, 0, 0), 'PERMANENT', 'soil', 'soeren'))
  193. >>> t.get_insert_statement_mogrified()
  194. "INSERT INTO raster ( creation_time ,mapset ,name ,creator ) VALUES ('2001-01-01 00:00:00' ,'PERMANENT' ,'soil' ,'soeren') ;\\n"
  195. >>> t.get_update_statement()
  196. ("UPDATE raster SET creation_time = ? ,mapset = ? ,name = ? ,creator = ? WHERE id = 'soil@PERMANENT';\\n", (datetime.datetime(2001, 1, 1, 0, 0), 'PERMANENT', 'soil', 'soeren'))
  197. >>> t.get_update_statement_mogrified()
  198. "UPDATE raster SET creation_time = '2001-01-01 00:00:00' ,mapset = 'PERMANENT' ,name = 'soil' ,creator = 'soeren' WHERE id = 'soil@PERMANENT';\\n"
  199. >>> t.get_update_all_statement()
  200. ("UPDATE raster SET creation_time = ? ,mapset = ? ,name = ? ,creator = ? WHERE id = 'soil@PERMANENT';\\n", (datetime.datetime(2001, 1, 1, 0, 0), 'PERMANENT', 'soil', 'soeren'))
  201. >>> t.get_update_all_statement_mogrified()
  202. "UPDATE raster SET creation_time = '2001-01-01 00:00:00' ,mapset = 'PERMANENT' ,name = 'soil' ,creator = 'soeren' WHERE id = 'soil@PERMANENT';\\n"
  203. \endcode
  204. """
  205. def __init__(self, table=None, ident=None):
  206. """!Constructor of this class
  207. @param table: The name of the table
  208. @param ident: The identifier (primary key) of this
  209. object in the database table
  210. """
  211. DictSQLSerializer.__init__(self)
  212. self.table = table # Name of the table, set in the subclass
  213. self.ident = ident
  214. def get_table_name(self):
  215. """!Return the name of the table in which the internal
  216. data are inserted, updated or selected"""
  217. return self.table
  218. def get_delete_statement(self):
  219. """!Return the delete string"""
  220. return "DELETE FROM " + self.get_table_name() + \
  221. " WHERE id = \'" + str(self.ident) + "\';\n"
  222. def delete(self, dbif=None):
  223. """!Delete the entry of this object from the temporal database
  224. @param dbif: The database interface to be used,
  225. if None a temporary connection will be established
  226. """
  227. sql = self.get_delete_statement()
  228. #print sql
  229. if dbif:
  230. dbif.cursor.execute(sql)
  231. else:
  232. dbif = SQLDatabaseInterfaceConnection()
  233. dbif.connect()
  234. dbif.cursor.execute(sql)
  235. dbif.close()
  236. def get_is_in_db_statement(self):
  237. """!Return the selection string"""
  238. return "SELECT id FROM " + self.get_table_name() + \
  239. " WHERE id = \'" + str(self.ident) + "\';\n"
  240. def is_in_db(self, dbif=None):
  241. """!Check if this object is present in the temporal database
  242. @param dbif: The database interface to be used,
  243. if None a temporary connection will be established
  244. """
  245. sql = self.get_is_in_db_statement()
  246. #print sql
  247. if dbif:
  248. dbif.cursor.execute(sql)
  249. row = dbif.cursor.fetchone()
  250. else:
  251. dbif = SQLDatabaseInterfaceConnection()
  252. dbif.connect()
  253. dbif.cursor.execute(sql)
  254. row = dbif.cursor.fetchone()
  255. dbif.close()
  256. # Nothing found
  257. if row is None:
  258. return False
  259. return True
  260. def get_select_statement(self):
  261. """!Return the sql statement and the argument list in
  262. database specific style"""
  263. return self.serialize("SELECT", self.get_table_name(),
  264. "WHERE id = \'" + str(self.ident) + "\'")
  265. def get_select_statement_mogrified(self, dbif=None):
  266. """!Return the select statement as mogrified string
  267. @param dbif: The database interface to be used,
  268. if None a temporary connection will be established
  269. """
  270. if not dbif:
  271. dbif = SQLDatabaseInterfaceConnection()
  272. return dbif.mogrify_sql_statement(self.get_select_statement())
  273. def select(self, dbif=None):
  274. """!Select the content from the temporal database and store it
  275. in the internal dictionary structure
  276. @param dbif: The database interface to be used,
  277. if None a temporary connection will be established
  278. """
  279. sql, args = self.get_select_statement()
  280. #print sql
  281. #print args
  282. if dbif:
  283. if len(args) == 0:
  284. dbif.cursor.execute(sql)
  285. else:
  286. dbif.cursor.execute(sql, args)
  287. row = dbif.cursor.fetchone()
  288. else:
  289. dbif = SQLDatabaseInterfaceConnection()
  290. dbif.connect()
  291. if len(args) == 0:
  292. dbif.cursor.execute(sql)
  293. else:
  294. dbif.cursor.execute(sql, args)
  295. row = dbif.cursor.fetchone()
  296. dbif.close()
  297. # Nothing found
  298. if row is None:
  299. return False
  300. if len(row) > 0:
  301. self.deserialize(row)
  302. else:
  303. core.fatal(_("Object <%s> not found in the temporal database")
  304. % self.get_id())
  305. return True
  306. def get_insert_statement(self):
  307. """!Return the sql statement and the argument
  308. list in database specific style"""
  309. return self.serialize("INSERT", self.get_table_name())
  310. def get_insert_statement_mogrified(self, dbif=None):
  311. """!Return the insert statement as mogrified string
  312. @param dbif: The database interface to be used,
  313. if None a temporary connection will be established
  314. """
  315. if not dbif:
  316. dbif = SQLDatabaseInterfaceConnection()
  317. return dbif.mogrify_sql_statement(self.get_insert_statement())
  318. def insert(self, dbif=None):
  319. """!Serialize the content of this object and store it in the temporal
  320. database using the internal identifier
  321. @param dbif: The database interface to be used,
  322. if None a temporary connection will be established
  323. """
  324. sql, args = self.get_insert_statement()
  325. #print sql
  326. #print args
  327. if dbif:
  328. dbif.cursor.execute(sql, args)
  329. else:
  330. dbif = SQLDatabaseInterfaceConnection()
  331. dbif.connect()
  332. dbif.cursor.execute(sql, args)
  333. dbif.close()
  334. def get_update_statement(self, ident=None):
  335. """!Return the sql statement and the argument list
  336. in database specific style
  337. @param ident: The identifier to be updated, useful for renaming
  338. """
  339. if ident:
  340. return self.serialize("UPDATE", self.get_table_name(),
  341. "WHERE id = \'" + str(ident) + "\'")
  342. else:
  343. return self.serialize("UPDATE", self.get_table_name(),
  344. "WHERE id = \'" + str(self.ident) + "\'")
  345. def get_update_statement_mogrified(self, dbif=None, ident=None):
  346. """!Return the update statement as mogrified string
  347. @param dbif: The database interface to be used,
  348. if None a temporary connection will be established
  349. @param ident: The identifier to be updated, useful for renaming
  350. """
  351. if not dbif:
  352. dbif = SQLDatabaseInterfaceConnection()
  353. return dbif.mogrify_sql_statement(self.get_update_statement(ident))
  354. def update(self, dbif=None, ident=None):
  355. """!Serialize the content of this object and update it in the temporal
  356. database using the internal identifier
  357. Only object entries which are exists (not None) are updated
  358. @param dbif: The database interface to be used,
  359. if None a temporary connection will be established
  360. @param ident: The identifier to be updated, useful for renaming
  361. """
  362. if self.ident is None:
  363. raise IOError("Missing identifer")
  364. sql, args = self.get_update_statement(indent)
  365. #print sql
  366. #print args
  367. if dbif:
  368. dbif.cursor.execute(sql, args)
  369. else:
  370. dbif = SQLDatabaseInterfaceConnection()
  371. dbif.connect()
  372. dbif.cursor.execute(sql, args)
  373. dbif.close()
  374. def get_update_all_statement(self, ident=None):
  375. """!Return the sql statement and the argument
  376. list in database specific style
  377. @param ident: The identifier to be updated, useful for renaming
  378. """
  379. if ident:
  380. return self.serialize("UPDATE ALL", self.get_table_name(),
  381. "WHERE id = \'" + str(ident) + "\'")
  382. else:
  383. return self.serialize("UPDATE ALL", self.get_table_name(),
  384. "WHERE id = \'" + str(self.ident) + "\'")
  385. def get_update_all_statement_mogrified(self, dbif=None, ident=None):
  386. """!Return the update all statement as mogrified string
  387. @param dbif: The database interface to be used,
  388. if None a temporary connection will be established
  389. @param ident: The identifier to be updated, useful for renaming
  390. """
  391. if not dbif:
  392. dbif = SQLDatabaseInterfaceConnection()
  393. return dbif.mogrify_sql_statement(self.get_update_all_statement(ident))
  394. def update_all(self, dbif=None, ident=None):
  395. """!Serialize the content of this object, including None objects,
  396. and update it in the temporal database using the internal identifier
  397. @param dbif: The database interface to be used,
  398. if None a temporary connection will be established
  399. @param ident: The identifier to be updated, useful for renaming
  400. """
  401. if self.ident is None:
  402. raise IOError("Missing identifer")
  403. sql, args = self.get_update_all_statement(ident)
  404. #print sql
  405. #print args
  406. if dbif:
  407. dbif.cursor.execute(sql, args)
  408. else:
  409. dbif = SQLDatabaseInterfaceConnection()
  410. dbif.connect()
  411. dbif.cursor.execute(sql, args)
  412. dbif.close()
  413. ###############################################################################
  414. class DatasetBase(SQLDatabaseInterface):
  415. """!This is the base class for all maps and spacetime datasets storing
  416. basic identification information
  417. Usage:
  418. \code
  419. >>> t = DatasetBase("raster", "soil@PERMANENT", creator="soeren", ctime=datetime(2001,1,1), ttype="absolute")
  420. >>> t.id
  421. 'soil@PERMANENT'
  422. >>> t.name
  423. 'soil'
  424. >>> t.mapset
  425. 'PERMANENT'
  426. >>> t.creator
  427. 'soeren'
  428. >>> t.ctime
  429. datetime.datetime(2001, 1, 1, 0, 0)
  430. >>> t.ttype
  431. 'absolute'
  432. >>> t.print_info()
  433. +-------------------- Basic information -------------------------------------+
  434. | Id: ........................ soil@PERMANENT
  435. | Name: ...................... soil
  436. | Mapset: .................... PERMANENT
  437. | Creator: ................... soeren
  438. | Creation time: ............. 2001-01-01 00:00:00
  439. | Temporal type: ............. absolute
  440. >>> t.print_shell_info()
  441. id=soil@PERMANENT
  442. name=soil
  443. mapset=PERMANENT
  444. creator=soeren
  445. creation_time=2001-01-01 00:00:00
  446. temporal_type=absolute
  447. \endcode
  448. """
  449. def __init__(self, table=None, ident=None, name=None, mapset=None,
  450. creator=None, ctime=None,ttype=None):
  451. """!Constructor
  452. @param table: The name of the temporal database table
  453. that should be used to store the values
  454. @param ident: The unique identifier must be a combination of
  455. the dataset name, layer name and the mapset
  456. name@mapset or name:1@mapset
  457. used as as primary key in the temporal database
  458. @param name: The name of the map or dataset
  459. @param mapset: The name of the mapset
  460. @param creator: The name of the creator
  461. @param ctime: The creation datetime object
  462. @param ttype: The temporal type
  463. * "absolute" Identifier for absolute time
  464. * "relative" Identifier for relative time
  465. """
  466. SQLDatabaseInterface.__init__(self, table, ident)
  467. self.set_id(ident)
  468. if ident is not None and name is None and mapset is None:
  469. if ident.find("@") >= 0:
  470. name, mapset = ident.split("@")
  471. if name.find(":") >= 0:
  472. name, layer = ident.split(":")
  473. self.set_name(name)
  474. self.set_mapset(mapset)
  475. self.set_creator(creator)
  476. self.set_ctime(ctime)
  477. self.set_ttype(ttype)
  478. # Commented out for performance reasons
  479. #self.set_mtime(mtime)
  480. #self.set_revision(revision)
  481. def set_id(self, ident):
  482. """!Convenient method to set the unique identifier (primary key)
  483. @param ident: The unique identifier must be a combination
  484. of the dataset name, layer name and the mapset
  485. name@mapset or name:1@mapset
  486. """
  487. self.ident = ident
  488. self.D["id"] = ident
  489. if ident is not None:
  490. if ident.find("@") >= 0:
  491. name, mapset = ident.split("@")
  492. self.set_mapset(mapset)
  493. self.set_name(name)
  494. else:
  495. core.fatal(_("Wrong identifier, the mapset is missing"))
  496. if name.find(":") >= 0:
  497. name, layer = ident.split(":")
  498. self.set_layer(layer)
  499. self.set_name(name)
  500. def set_name(self, name):
  501. """!Set the name of the dataset
  502. @param name: The name of the dataset
  503. """
  504. self.D["name"] = name
  505. def set_mapset(self, mapset):
  506. """!Set the mapset of the dataset
  507. @param mapsets: The name of the mapset in which this dataset is stored
  508. """
  509. self.D["mapset"] = mapset
  510. def set_layer(self, layer):
  511. """!Convenient method to set the layer of the map (part of primary key)
  512. Layer are supported for vector maps
  513. @param layer: The layer of the map
  514. """
  515. self.D["layer"] = layer
  516. def set_creator(self, creator):
  517. """!Set the creator of the dataset
  518. @param creator: The name of the creator
  519. """
  520. self.D["creator"] = creator
  521. def set_ctime(self, ctime=None):
  522. """!Set the creation time of the dataset,
  523. if nothing set the current time is used
  524. @param ctime: The current time of type datetime
  525. """
  526. if ctime is None:
  527. self.D["creation_time"] = datetime.now()
  528. else:
  529. self.D["creation_time"] = ctime
  530. def set_ttype(self, ttype):
  531. """!Set the temporal type of the dataset: absolute or relative,
  532. if nothing set absolute time will assumed
  533. @param ttype: The temporal type of the dataset "absolute or relative"
  534. """
  535. if ttype is None or (ttype != "absolute" and ttype != "relative"):
  536. self.D["temporal_type"] = "absolute"
  537. else:
  538. self.D["temporal_type"] = ttype
  539. # def set_mtime(self, mtime=None):
  540. # """!Set the modification time of the map, if nothing set the current time is used"""
  541. # if mtime == None:
  542. # self.D["modification_time"] = datetime.now()
  543. # else:
  544. # self.D["modification_time"] = mtime
  545. # def set_revision(self, revision=1):
  546. # """!Set the revision of the map: if nothing set revision 1 will assumed"""
  547. # self.D["revision"] = revision
  548. def get_id(self):
  549. """!Convenient method to get the unique identifier (primary key)
  550. @return None if not found
  551. """
  552. if "id" in self.D:
  553. return self.D["id"]
  554. else:
  555. return None
  556. def get_map_id(self):
  557. """!Convenient method to get the unique map identifier
  558. without layer information
  559. @param return the name of the vector map as name@mapset
  560. or None in case the id was not set
  561. """
  562. if self.id:
  563. if self.id.find(":") >= 0:
  564. # Remove the layer identifier from the id
  565. return self.id.split("@")[0].split(":")[0] + "@" + \
  566. self.id.split("@")[1]
  567. else:
  568. return self.id
  569. else:
  570. return None
  571. def get_layer(self):
  572. """!Convenient method to get the layer of the map (part of primary key)
  573. Layer are currently supported for vector maps
  574. @return None if not found
  575. """
  576. if "layer" in self.D:
  577. return self.D["layer"]
  578. else:
  579. return None
  580. def get_name(self):
  581. """!Get the name of the dataset
  582. @return None if not found"""
  583. if "name" in self.D:
  584. return self.D["name"]
  585. else:
  586. return None
  587. def get_mapset(self):
  588. """!Get the name of mapset of this dataset
  589. @return None if not found"""
  590. if "mapset" in self.D:
  591. return self.D["mapset"]
  592. else:
  593. return None
  594. def get_creator(self):
  595. """!Get the creator of the dataset
  596. @return None if not found"""
  597. if "creator" in self.D:
  598. return self.D["creator"]
  599. else:
  600. return None
  601. def get_ctime(self):
  602. """!Get the creation time of the dataset, datatype is datetime
  603. @return None if not found"""
  604. if "creation_time" in self.D:
  605. return self.D["creation_time"]
  606. else:
  607. return None
  608. def get_ttype(self):
  609. """!Get the temporal type of the map
  610. @return None if not found"""
  611. if "temporal_type" in self.D:
  612. return self.D["temporal_type"]
  613. else:
  614. return None
  615. # def get_mtime(self):
  616. # """!Get the modification time of the map, datatype is datetime
  617. # @return None if not found"""
  618. # if self.D.has_key("modification_time"):
  619. # return self.D["modification_time"]
  620. # else:
  621. # return None
  622. # def get_revision(self):
  623. # """!Get the revision of the map
  624. # @return None if not found"""
  625. # if self.D.has_key("revision"):
  626. # return self.D["revision"]
  627. # else:
  628. # return None
  629. # Properties of this class
  630. id = property(fget=get_id, fset=set_id)
  631. map_id = property(fget=get_map_id, fset=None)
  632. name = property(fget=get_name, fset=set_name)
  633. mapset = property(fget=get_mapset, fset=set_mapset)
  634. ctime = property(fget=get_ctime, fset=set_ctime)
  635. ttype = property(fget=get_ttype, fset=set_ttype)
  636. creator = property(fget=get_creator, fset=set_creator)
  637. def print_info(self):
  638. """!Print information about this class in human readable style"""
  639. # 0123456789012345678901234567890
  640. print " +-------------------- Basic information -------------------------------------+"
  641. print " | Id: ........................ " + str(self.get_id())
  642. print " | Name: ...................... " + str(self.get_name())
  643. print " | Mapset: .................... " + str(self.get_mapset())
  644. if self.get_layer():
  645. print " | Layer:...................... " + str(self.get_layer())
  646. print " | Creator: ................... " + str(self.get_creator())
  647. print " | Creation time: ............. " + str(self.get_ctime())
  648. print " | Temporal type: ............. " + str(self.get_ttype())
  649. # print " | Modification time: ......... " + str(self.get_mtime())
  650. # print " | Revision in database: ...... " + str(self.get_revision())
  651. def print_shell_info(self):
  652. """!Print information about this class in shell style"""
  653. print "id=" + str(self.get_id())
  654. print "name=" + str(self.get_name())
  655. print "mapset=" + str(self.get_mapset())
  656. if self.get_layer():
  657. print "layer=" + str(self.get_layer())
  658. print "creator=" + str(self.get_creator())
  659. print "creation_time=" + str(self.get_ctime())
  660. print "temporal_type=" + str(self.get_ttype())
  661. # print "modification_time=" + str(self.get_mtime())
  662. # print "revision=" + str(self.get_revision())
  663. ###############################################################################
  664. class RasterBase(DatasetBase):
  665. """!Time stamped raster map base information class"""
  666. def __init__(self, ident=None, name=None, mapset=None, creator=None,
  667. creation_time=None, temporal_type=None):
  668. DatasetBase.__init__(self, "raster_base", ident, name, mapset,
  669. creator, creation_time, temporal_type)
  670. class Raster3DBase(DatasetBase):
  671. """!Time stamped 3D raster map base information class"""
  672. def __init__(self, ident=None, name=None, mapset=None, creator=None,
  673. creation_time=None, temporal_type=None,):
  674. DatasetBase.__init__(self, "raster3d_base", ident, name,
  675. mapset, creator, creation_time,
  676. temporal_type)
  677. class VectorBase(DatasetBase):
  678. """!Time stamped vector map base information class"""
  679. def __init__(self, ident=None, name=None, mapset=None, layer=None,
  680. creator=None, creation_time=None, temporal_type=None):
  681. DatasetBase.__init__(self, "vector_base", ident, name, mapset,
  682. creator, creation_time, temporal_type)
  683. self.set_id(ident)
  684. if ident is not None and name is None and mapset is None:
  685. if ident.find("@") >= 0:
  686. name, mapset = ident.split("@")
  687. if layer is None:
  688. if name.find(":") >= 0:
  689. name, layer = name.split(":")
  690. self.set_name(name)
  691. self.set_mapset(mapset)
  692. # Layer currently only in use by vector maps
  693. self.set_layer(layer)
  694. ###############################################################################
  695. class STDSBase(DatasetBase):
  696. """!Base class for space time datasets
  697. This class adds the semantic type member variable to the dataset
  698. base class.
  699. Usage:
  700. \code
  701. >>> t = STDSBase("stds", "soil@PERMANENT", semantic_type="average", creator="soeren", ctime=datetime(2001,1,1), ttype="absolute")
  702. >>> t.semantic_type
  703. 'average'
  704. >>> t.print_info()
  705. +-------------------- Basic information -------------------------------------+
  706. | Id: ........................ soil@PERMANENT
  707. | Name: ...................... soil
  708. | Mapset: .................... PERMANENT
  709. | Creator: ................... soeren
  710. | Creation time: ............. 2001-01-01 00:00:00
  711. | Temporal type: ............. absolute
  712. | Semantic type:.............. average
  713. >>> t.print_shell_info()
  714. id=soil@PERMANENT
  715. name=soil
  716. mapset=PERMANENT
  717. creator=soeren
  718. creation_time=2001-01-01 00:00:00
  719. temporal_type=absolute
  720. semantic_type=average
  721. \endcode
  722. """
  723. def __init__(self, table=None, ident=None, name=None, mapset=None,
  724. semantic_type=None, creator=None, ctime=None,
  725. ttype=None):
  726. DatasetBase.__init__(self, table, ident, name, mapset, creator,
  727. ctime, ttype)
  728. self.set_semantic_type(semantic_type)
  729. def set_semantic_type(self, semantic_type):
  730. """!Set the semantic type of the space time dataset"""
  731. self.D["semantic_type"] = semantic_type
  732. def get_semantic_type(self):
  733. """!Get the semantic type of the space time dataset
  734. @return None if not found"""
  735. if "semantic_type" in self.D:
  736. return self.D["semantic_type"]
  737. else:
  738. return None
  739. semantic_type = property(fget=get_semantic_type, fset=set_semantic_type)
  740. def print_info(self):
  741. """!Print information about this class in human readable style"""
  742. DatasetBase.print_info(self)
  743. # 0123456789012345678901234567890
  744. print " | Semantic type:.............. " + str(
  745. self.get_semantic_type())
  746. def print_shell_info(self):
  747. """!Print information about this class in shell style"""
  748. DatasetBase.print_shell_info(self)
  749. print "semantic_type=" + str(self.get_semantic_type())
  750. ###############################################################################
  751. class STRDSBase(STDSBase):
  752. """!Space time raster dataset base information class"""
  753. def __init__(self, ident=None, name=None, mapset=None,
  754. semantic_type=None, creator=None, ctime=None,
  755. ttype=None):
  756. STDSBase.__init__(self, "strds_base", ident, name, mapset,
  757. semantic_type, creator, ctime,
  758. ttype)
  759. class STR3DSBase(STDSBase):
  760. """!Space time 3D raster dataset base information class"""
  761. def __init__(self, ident=None, name=None, mapset=None,
  762. semantic_type=None, creator=None, ctime=None,
  763. ttype=None):
  764. STDSBase.__init__(self, "str3ds_base", ident, name, mapset,
  765. semantic_type, creator, ctime,
  766. ttype)
  767. class STVDSBase(STDSBase):
  768. """!Space time vector dataset base information class"""
  769. def __init__(self, ident=None, name=None, mapset=None,
  770. semantic_type=None, creator=None, ctime=None,
  771. ttype=None):
  772. STDSBase.__init__(self, "stvds_base", ident, name, mapset,
  773. semantic_type, creator, ctime,
  774. ttype)
  775. ###############################################################################
  776. if __name__ == "__main__":
  777. import doctest
  778. doctest.testmod()