base.py 35 KB

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