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
Sun Jul 12 12:52:41 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:

(1 comment)

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@160 
PS1, Line 160: id
> anyway, there might be some SQL magic that gets the last added subscriber id and allows using

Yeah, SQLite offets last_insert_rowid(). You can use it in nested queries:

  INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki)
  VALUES((select last_insert_rowid()), 1, '0123456789abcdef0123456789abcdef');



-- 
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: Sun, 12 Jul 2020 12:52:41 +0000
Gerrit-HasComments: Yes
Gerrit-Has-Labels: No
Comment-In-Reply-To: fixeria <vyanitskiy at sysmocom.de>
Comment-In-Reply-To: neels <nhofmeyr at sysmocom.de>
Gerrit-MessageType: comment
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osmocom.org/pipermail/gerrit-log/attachments/20200712/038a179f/attachment.htm>


More information about the gerrit-log mailing list