Python getRows Examples

Example #1

File: profiles.py Project: cas--/erminig-ng

def get_profile_by_id(id):
	cur = dblayer.run("SELECT * FROM Profiles WHERE id=?", (id,))
	rows = dblayer.getRows(cur)
	if len(rows) == 0:
		return None

	return {'localSource': rows[0]['localSource'], 'localSourceTitle': rows[0]['localSourceTitle'], 'remoteAccountId': rows[0]['remoteAccountId'], 'remoteSource': rows[0]['remoteSource'], 'remoteSourceTitle': rows[0]['remoteSourceTitle'], 'enabled': rows[0]['enabled'], 'direction': rows[0]['direction'], 'lastUpdate': rows[0]['lastUpdate'], 'id': rows[0]['id'], 'lastLocalUpdate': rows[0]['lastLocalUpdate']}

Example #2

File: google_accounts.py Project: cas--/erminig-ng

def get_registered_accounts():
	cur = dblayer.run("SELECT id, username FROM GoogleAccounts")
	rows = dblayer.getRows(cur)

	accts = []
	for i in rows:
		accts.append([i['id'], i['username']])

	return accts

Example #3

def get_registered_accounts():
    cur = dblayer.run("SELECT id, username FROM GoogleAccounts")
    rows = dblayer.getRows(cur)

    accts = []
    for i in rows:
        accts.append([i['id'], i['username']])

    return accts

Example #4

File: profiles.py Project: cas--/erminig-ng

def get_all():
	cur = dblayer.run("SELECT * FROM Profiles")
	rows = dblayer.getRows(cur)

	profiles = []
	for i in rows:
		profiles.append([i['id'], i['type'], i['localSource'], i['localSourceTitle'], i['remoteSource'], i['remoteSourceTitle'], i['enabled'], i['direction'], i['lastUpdate'], i['lastLocalUpdate']])

	return profiles

Example #5

File: profiles.py Project: cas--/erminig-ng

def get_all():
    cur = dblayer.run("SELECT * FROM Profiles")
    rows = dblayer.getRows(cur)

    profiles = []
    for i in rows:
        profiles.append([
            i['id'], i['type'], i['localSource'], i['localSourceTitle'],
            i['remoteSource'], i['remoteSourceTitle'], i['enabled'],
            i['direction'], i['lastUpdate'], i['lastLocalUpdate']
        ])

    return profiles

Example #6

File: app.py Project: rmkeezer/media-horde-api

    def get(self):
        try: 
            parser = reqparse.RequestParser()
            addAuthArgs(parser)
            parser.add_argument('tableName', type=str)
            args = parser.parse_args()
            if authenticate(args)['status'] == 100:
                return {'error': 'Authentication Failed'}

            _tableName = args['tableName']

            return getRows(_tableName, '*')

        except Exception as e:
            return {'error': str(e)}

Example #7

File: profiles.py Project: cas--/erminig-ng

def get_profile_by_id(id):
    cur = dblayer.run("SELECT * FROM Profiles WHERE id=?", (id, ))
    rows = dblayer.getRows(cur)
    if len(rows) == 0:
        return None

    return {
        'localSource': rows[0]['localSource'],
        'localSourceTitle': rows[0]['localSourceTitle'],
        'remoteAccountId': rows[0]['remoteAccountId'],
        'remoteSource': rows[0]['remoteSource'],
        'remoteSourceTitle': rows[0]['remoteSourceTitle'],
        'enabled': rows[0]['enabled'],
        'direction': rows[0]['direction'],
        'lastUpdate': rows[0]['lastUpdate'],
        'id': rows[0]['id'],
        'lastLocalUpdate': rows[0]['lastLocalUpdate']
    }

Example #8

File: google_accounts.py Project: cas--/erminig-ng

def get_account_by_id(id):
	cur = dblayer.run("SELECT username, password FROM GoogleAccounts "\
			"WHERE id = ?", (id,))
	row = dblayer.getRows(cur)[0]
	return (row['username'], row['password'], id)

Example #9

File: profiles.py Project: cas--/erminig-ng

def get_titles_by_id(id):
    cur = dblayer.run("SELECT localSourceTitle, remoteSourceTitle FROM "\
      "Profiles WHERE id=?", (id,))
    rows = dblayer.getRows(cur)

    return (rows[0]['localSourceTitle'], rows[0]['remoteSourceTitle'])

Example #10

def get_account_by_id(id):
    cur = dblayer.run("SELECT username, password FROM GoogleAccounts "\
      "WHERE id = ?", (id,))
    row = dblayer.getRows(cur)[0]
    return (row['username'], row['password'], id)

Example #11

File: profiles.py Project: cas--/erminig-ng

def get_titles_by_id(id):
	cur = dblayer.run("SELECT localSourceTitle, remoteSourceTitle FROM "\
			"Profiles WHERE id=?", (id,))
	rows = dblayer.getRows(cur)

	return (rows[0]['localSourceTitle'], rows[0]['remoteSourceTitle'])