Change in osmo-hlr[master]: manual: describe subscriber import by SQL

This is merely a historical archive of years 2008-2021, before the migration to mailman3.

A maintained and still updated list archive can be found at https://lists.osmocom.org/hyperkitty/list/gerrit-log@lists.osmocom.org/.

fixeria gerrit-no-reply at lists.osmocom.org
Thu Jul 9 07:59:00 UTC 2020


fixeria has posted comments on this change. ( https://gerrit.osmocom.org/c/osmo-hlr/+/19052 )

Change subject: manual: describe subscriber import by SQL
......................................................................


Patch Set 1:

(2 comments)

https://gerrit.osmocom.org/c/osmo-hlr/+/19052/1/doc/manuals/chapters/subscribers.adoc 
File doc/manuals/chapters/subscribers.adoc:

https://gerrit.osmocom.org/c/osmo-hlr/+/19052/1/doc/manuals/chapters/subscribers.adoc@148 
PS1, Line 148: choose subscriber IDs that are not yet in use
Hmm, don't we use something like AUTOINCREMENT [1]? Or wait, there seems to be no need to use it:

"""
On an INSERT, if the ROWID or INTEGER PRIMARY KEY column is not explicitly given a value, then it will be filled automatically with an unused integer, usually one more than the largest ROWID currently in use. This is true *regardless* of whether or not the AUTOINCREMENT keyword is used.
"""

[1] https://www.sqlite.org/autoinc.html


https://gerrit.osmocom.org/c/osmo-hlr/+/19052/1/doc/manuals/chapters/subscribers.adoc@160 
PS1, Line 160: id
So I guess you can simply omit this field, and sqlite will pick a unique value for you?



-- 
To view, visit https://gerrit.osmocom.org/c/osmo-hlr/+/19052
To unsubscribe, or for help writing mail filters, visit https://gerrit.osmocom.org/settings

Gerrit-Project: osmo-hlr
Gerrit-Branch: master
Gerrit-Change-Id: I3246e6d5364215a71c33b5aca876deab7b6cfd70
Gerrit-Change-Number: 19052
Gerrit-PatchSet: 1
Gerrit-Owner: neels <nhofmeyr at sysmocom.de>
Gerrit-Reviewer: Jenkins Builder
Gerrit-Reviewer: daniel <dwillmann at sysmocom.de>
Gerrit-Reviewer: dexter <pmaier at sysmocom.de>
Gerrit-Reviewer: fixeria <vyanitskiy at sysmocom.de>
Gerrit-Reviewer: laforge <laforge at osmocom.org>
Gerrit-Reviewer: neels <nhofmeyr at sysmocom.de>
Gerrit-Reviewer: pespin <pespin at sysmocom.de>
Gerrit-Comment-Date: Thu, 09 Jul 2020 07:59:00 +0000
Gerrit-HasComments: Yes
Gerrit-Has-Labels: No
Gerrit-MessageType: comment
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osmocom.org/pipermail/gerrit-log/attachments/20200709/6e8d1ad4/attachment.htm>


More information about the gerrit-log mailing list