Python Forum
Peewee returning objects and not strings..
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Peewee returning objects and not strings..
#3
(Dec-10-2017, 04:49 PM)Windspar Wrote: You can use vars to see what the object data is.
class Data:
	def __init__(self):
		self.data = "line"
		self.data2 = "line2"
		
data = Data()
print(data)
print(vars(data))

Thanks for your answer Windspar.
Unfortunately this dind't solve my problem

I changed my function get_data to this
def get_data():
    #init_database()
    data_list = []
    for email in Check_history.select():
        data_list.append([vars(Check_history.email), vars(Check_history.valid_or_invalid)])
        #print(vars(Check_history.email) + "BUT WHY DE FCUK")
    print(data_list)
    return data_list  


It retruns a huge list now:
Output:
[[{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order':1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None,'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100,'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints':None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None,'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}], [{'max_length': 100, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Email', 'help_text': None, 'db_column': 'email', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 1, '_sort_key': (2, 1), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'email', 'model_class': <class 'sql.Check_history'>}, {'max_length': 10, 'null': False, 'index': False, 'unique': False, 'verbose_name': 'Valid Or Invalid', 'help_text': None, 'db_column': 'valid_or_invalid', 'default': None, 'choices': None, 'primary_key': False, 'sequence': None, 'constraints': None, 'schema': None, 'undeclared': False, '_order': 2, '_sort_key': (2, 2), '_is_bound': True, '_negated': False, '_alias': None, '_bind_to': None, '_ordering': None, 'name': 'valid_or_invalid', 'model_class': <class 'sql.Check_history'>}]]
and I need the values in a list because I want to send the data to a html file with flask.
So the idea is that the get_data function returns [[EMAIL, VALID/INVALID],[EMAIL, VALID/INVALID],[EMAIL, VALID/INVALID]]

Ahh I found it.

for email in Check_history.select():
data_list.append([Check_history.email, Check_history.valid_or_invalid])

Check_history.email should be email.email.
Reply


Messages In This Thread
RE: Peewee returning objects and not strings.. - by JerryMotov - Dec-10-2017, 05:56 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Create SQLite3 database with peewee Jim53_1980 2 714 Dec-20-2023, 02:38 PM
Last Post: buran
  Trying to understand strings and lists of strings Konstantin23 2 816 Aug-06-2023, 11:42 AM
Last Post: deanhystad
  Splitting strings in list of strings jesse68 3 1,818 Mar-02-2022, 05:15 PM
Last Post: DeaD_EyE
  Finding multiple strings between the two same strings Slither 1 2,547 Jun-05-2019, 09:02 PM
Last Post: Yoriz
  lists, strings, and byte strings Skaperen 2 4,264 Mar-02-2018, 02:12 AM
Last Post: Skaperen
  peewee.OperationalError: no such table: JerryMotov 3 7,086 Dec-10-2017, 05:45 PM
Last Post: JerryMotov

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020