sql - Python Pygresql Insert Current Date -


what correct way insert current time postgresql using pygresql db-api compliant interface? understood postgresql uses 'timedate' , python (3.x) uses 'datetime'. there clean way convert between two? pygresql package displays error when trying insert 'datetime' fields.

pg.programmingerror: error:  schema "datetime" not exist

using pygresql type 'timestamp' still uses 'datetime' shown in code below 'sqlcur' postgresql cursor, 'tblnam' table, 'collst' list of columns, , 'insrec' list of records contains 1 field has current time:

## ## load packages ## import pgdb pgdb     import connect  datetime import datetime import pprint ## ## setup variables ## dbahst = 'localhost' dbausr = 'user' dbapas = 'pass' dbanam = 'db' dbaprt = '5432' tblnam = 'device_table' collst = ['ci_nm', 'loc_txt', 'model_nm', 'datecreated' ]  insrec = ['device1', 'location1', 'model1' ] ## ## connect postgresql ## sqlobj = connect(         database  = dbanam,         host      = dbahst,         port      = int(dbaprt),         user      = dbausr,         password  = dbapas ) sqlcur = sqlobj.cursor() ## ## setup current time ## = datetime.now() dtenew = pgdb.timestamp(now.year, now.month, now.day, now.hour, now.minute, now.second, now.microsecond) print( type(dtenew) ) pprint.pprint (dtenew) insrec.append (dtenew) ## ## store record ## sqlcur.execute( "insert %s (%s) values %s" % (tblnam, ', '.join(collst) , tuple(insrec),  ) )

the code above displays following output:

<class 'datetime.datetime'> datetime.datetime(2016, 11, 5, 14, 26, 38, 242624) traceback (most recent call last):   file "c:\test-pygresql-date.py", line 39, in <module>     sqlcur.execute( "insert %s (%s) values (%s)" % (tblnam, ', '.join(collst) , tuple(insrec),  ) )   file "c:\users\user1\appdata\local\programs\python\python36\lib\site-packages\pgdb.py", line 913, in execute     return self.executemany(operation, [parameters])   file "c:\users\user1\appdata\local\programs\python\python36\lib\site-packages\pgdb.py", line 937, in executemany     rows = self._src.execute(sql) pg.programmingerror: error:  schema "datetime" not exist line 1: ...reated) values (('device1', 'locatin1', 'model1', datetime.d...

displaying type , 'pprint' of date field 'dtenew' shows still set 'datetime.datetime' instead of 'pgdb.timestamp'.

<class 'datetime.datetime'> datetime.datetime(2016, 11, 5, 14, 26, 38, 242624)


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more