tirthajyoti / pydbgen Goto Github PK

I've installed pydbgen using pip into venv and received FileNotFoundError for realistic email generator:

>>>  import pydbgen
>>> from pydbgen import pydbgen
>>> myDB=pydbgen.pydb()

>>> for _ in range(10):
...     print(db.realistic_email('Tirtha Sarkar'))
Traceback (most recent call last):
  File "<stdin>", line 2, in <module>
  File "/home/dr/devel/pydbgen/venv/lib/python3.6/site-packages/pydbgen/pydbgen.py", line 99, in realistic_email
    fh = open(path)
FileNotFoundError: [Errno 2] No such file or directory: 'Domains.txt'

Version:

─$ venv/bin/pip freeze | grep pydbgen
pydbgen==1.0.5

The setup.py file used when installing from the repo requires sqlite. In py3 at least this should be sqlite3?

#from pydbgen import pydbgen
myDB=pydbgen.pydb()
testdf= myDB.gen_data_series(data_type='data')
print(testdf)

=====================

Traceback (most recent call last):
File "D:/python/Demopycharm/Test_month/z2020_01_month/Data-collect.py", line 40, in
testdf= myDB.gen_data_series(data_type='data')
File "D:\python\Demopycharm\Myspider\venv\lib\site-packages\pydbgen\pydbgen.py", line 191, in gen_data_series
fake.seed(self.seed)
File "D:\python\Demopycharm\Myspider\venv\lib\site-packages\faker\proxy.py", line 79, in getattribute
raise TypeError(msg)
TypeError: Calling .seed() on instances is deprecated. Use the class method Faker.seed() instead.

while generating datafram getting below error

testdf=myDB.gen_dataframe(25,fields=['name','city','phone','license_plate','email'],real_email=True,phone_simple=True)
Error

fh = open(path)

FileNotFoundError: [Errno 2] No such file or directory: 'Domains.txt'

When passing array containing only 'phone' into fields parameter for gen_excel function, column title but no data are present in the spreadsheet. Passing single column type seems to work fine for other data types.

Running in Jupyter notebook / Ipython 3 shell:

!pip3 install pydbgen
import pydbgen

pydbgen.pydb()

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-4-c22bf096fc05> in <module>
----> 1 myDB = pydbgen.pydb()

AttributeError: module 'pydbgen' has no attribute 'pydb'

Also:

dir(pydbgen)

['__doc__',
 '__file__',
 '__loader__',
 '__name__',
 '__package__',
 '__path__',
 '__spec__']

Fix is:

from pydbgen import pydbgen

TypeError: Calling .seed() on instances is deprecated. Use the class method Faker.seed() instead.
I am getting this error when I am generating the data

code:
testdf=myDB.gen_dataframe(25,fields='name','city','phone',
'license_plate','email',real_email=True,phone_simple=True)

SyntaxError: positional argument follows keyword argument

https://github.com/tirthajyoti/pydbgen/blob/master/pydbgen/pydbgen.py#L99

import pydbgen
myDB = pydbgen.pydb()
myDB.realistic_email("Peter Parker")

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "...../pydbgen/pydbgen/pydbgen.py", line 99, in realistic_email
    print(path)
UnboundLocalError: local variable 'path' referenced before assignment

when i am about to create a new db table ,it always throw an exception like Cannot choose from an empty sequence

The list of possible columns/fields is quite limited. How could I for example create a number column with random numbers?