import
psycopg2
from
config
import
config
conn
=
None
try
:
conn
=
psycopg2.connect(
*
*
config)
cur
=
conn.cursor()
BLOB_vdo
=
psycopg2.Binary(
open
(
'files\cartoon.mp4'
,
'rb'
).read())
BLOB_pdf
=
psycopg2.Binary(
open
(
'files\BlobNotes.pdf'
,
'rb'
).read())
cur.execute('INSERT INTO blob_datastore(s_no,file_name,\
blob_data) VALUES (
%
s,
%
s,
%
s);',
(
1
,
'cartoon.mp4'
, BLOB_vdo))
cur.execute('INSERT INTO blob_datastore(s_no,file_name,\
blob_data) VALUES (
%
s,
%
s,
%
s);',
(
2
,
'BlobNotes.pdf'
, BLOB_pdf))
cur.close()
except
(Exception, psycopg2.DatabaseError) as error:
print
(error)
finally
:
if
conn
is
not
None
:
conn.commit()